Most vape retailers reorder based on what feels low on the shelf. The problem is that gut instinct buying produces predictable results: you over-invest in slow-moving SKUs because they were popular six months ago, and you run out of your actual best-sellers mid-week because you did not reorder early enough. Data fixes both problems — and the data you need is already sitting in your Shopify backend.
Part 1: Why Gut Instinct Buying Fails
The vape category moves fast. A disposable that led sales in October may be outsold two-to-one by a newer SKU by February. A flavour profile that moved well in summer will stall in winter. Without a systematic way to read what is actually happening on your shelves, you are making $5,000–$15,000 inventory decisions on incomplete information.
Three failure modes show up repeatedly:
- Recency bias. You reorder the SKU a customer asked for yesterday, not the one with the highest consistent sell-through over the past 30 days.
- Dead stock accumulation. Slow-moving SKUs stay on the shelf because you are not tracking velocity, so capital keeps getting tied up in product that is not turning. This is one of the most common cash flow problems vape retailers face.
- Stockout on bestsellers. Your highest-velocity SKU goes out of stock on a Friday because reorder was triggered visually ("looks low") rather than by a data threshold.
Part 2: The Three Metrics That Matter
| Metric | Formula | What It Tells You |
|---|---|---|
| Sell-Through Rate (STR) | Units Sold ÷ (Units Sold + Units Remaining) × 100 | What percentage of the inventory you received actually sold. Target: 80%+ over a 30-day window for disposables. Below 50% signals a slow mover. |
| Inventory Turnover | Cost of Goods Sold ÷ Average Inventory Value | How many times you sell through your full inventory in a period. A healthy vape retail turnover is 8–12x annually. Below 6x means capital is sitting idle in stock. |
| Category Margin Contribution | (Revenue − COGS) ÷ Total Store Gross Profit × 100 | What share of your total gross profit each product category is actually generating. Identifies which categories deserve more shelf space and buying budget. |
Part 3: How to Pull the Data From Shopify
All three metrics can be calculated from reports already available in your Shopify admin. No third-party app required for the basics.
Sell-Through Rate
- Go to
Analytics → Reports → Sales by product - Set date range to last 30 days
- Export to CSV — columns you need:
Product Title,Net Quantity - Cross-reference with
Inventory → Products → Exportfor current stock on hand - Apply formula:
Net Quantity ÷ (Net Quantity + Current Stock) × 100
Inventory Turnover
- Go to
Analytics → Reports → Finances summaryfor Cost of Goods Sold (requires Shopify cost tracking to be enabled) - Calculate average inventory value:
(Opening Stock Value + Closing Stock Value) ÷ 2 - Apply formula:
COGS ÷ Average Inventory Value - Annualise if calculating over a shorter period: multiply by
12 ÷ number of months
Category Margin Contribution
- Go to
Analytics → Reports → Sales by product type - Enable cost tracking to see gross margin per category (
Settings → Products → Show cost per item) - Calculate each category's gross profit and divide by total store gross profit
Sales by product type report with margin data requires Shopify plan or above. If you are on Basic, use Sales by product and group categories manually in the exported CSV.
Part 4: Star SKUs, Zombie SKUs, and Seasonal Patterns
Identifying Stars and Zombies
Once you have 30-day STR data for your full product list, sort by sell-through rate descending. The top of the list is your star SKUs — products that are turning fast, likely running short before your next order arrives. The bottom of the list is your zombie SKUs — products consuming shelf space and working capital without generating equivalent return.
| Classification | STR (30-day) | Action |
|---|---|---|
| Star SKU | 80%+ | Set reorder trigger at 30% remaining. Increase order quantity on next cycle. Prioritise shelf position. |
| Solid performer | 50–79% | Maintain current ordering pattern. Monitor for upward or downward trend over 60 days. |
| Watch list | 30–49% | Do not reorder at same quantity. Run down existing stock. Consider display position change before discontinuing. |
| Zombie SKU | Below 30% | Do not reorder. Clear remaining stock through promotion or bundling. Reallocate budget to Star SKUs. |
Example: Lost Mary OS50000 in a top-selling fruit flavour will typically show 85–95% STR in a 30-day window for an SVS store with normal foot traffic. A niche flavour from the same brand — say a less popular dessert profile — may sit at 20–35%. The data tells you to double down on the fruit flavour and not reorder the dessert profile, regardless of how confident you felt about it at the time of purchase.
Canadian Seasonal Patterns
Overlay your STR data against season to spot recurring patterns rather than one-off events. For a broader look at what flavour profiles are trending across Canada right now, see: Canada Vape Flavour Trends 2026.
- Spring / Summer (Apr–Aug): Ice, fruit, and tropical profiles consistently outperform. ALLO and Flavour Beast ice SKUs typically see their highest STR in this window. Increase buying budget for these categories by 20–30% ahead of the season, not during it.
- Autumn / Winter (Sep–Mar): Tobacco and menthol profiles hold more consistent STR. Long-puff-count devices perform well as customers spend more time indoors. STLTH and DOJO tend to hold velocity better through this period than fruit-forward SKUs.
- December: Transaction volume spikes but shifts toward gift-friendly products and starter kits. Budget for 25–40% higher disposable volume in the first two weeks of December and plan your Arctic order to arrive by Nov 25 at the latest.
Part 5: Turning Data Into Your Next Order
The output of your data review should be a prioritised order list, not just a general sense that you need to "order more Lost Mary." A structured approach:
- Pull STR for your full product list covering the last 30 days.
-
Flag everything above 80% STR as a mandatory reorder item. Calculate days of stock remaining at current velocity:
Units Remaining ÷ (Units Sold ÷ 30). If that number is below 14, reorder immediately. - Flag everything below 30% STR as a no-reorder. Do not let slow-mover inertia drive repeat purchases.
- Check seasonal timing. If you are within 6 weeks of a seasonal peak, add 20–30% to your star SKU order quantities to build pre-season buffer stock.
- Place the order before you need it. Arctic Distributions ships Ontario orders in 1–3 business days — but building a 1–2 week buffer between your reorder trigger and your actual stockout point eliminates the Friday afternoon panic order.
Stock your stars. Clear your zombies. Order before you need to.
Arctic Distributions supplies Ontario SVS retailers with correctly stamped, CRC-compliant inventory across all major brands. No minimum order quantity — free shipping on orders above $1,000 CAD.
→ Apply for a Wholesale Account Contact Usvape inventory canada · vape shop sales tracking canada · how to analyze vape store data
Related Articles:
- How to Stock Your First Vape Shop in Canada
- Top 10 Best-Selling Disposable Vapes in Canada (2026)
- Vape Display Setup Tips That Drive Sales
- Vape Wholesale vs. Direct Brand Distribution: How to Choose
- How to Get a Vape Retail Licence in Ontario (2026)
WARNING: Vaping products contain nicotine, a highly addictive chemical. This website is intended for licensed retailers only. Must be 19+ to purchase in Ontario.
