Shopify Inventory Management: Best Practices That Prevent Lost Revenue

Stockouts cost you twice — once in the lost sale, again in the customer who buys from a competitor and never returns. Overstocks cost you cash flow. The middle ground is what every operator wants and few execute consistently.

Here's the inventory system that scales from 50 SKUs to 5,000 without falling apart.

Start with accurate data

Inventory management is data management. If your counts are wrong, every other decision falls apart.

The starting state for most stores:

• Inventory levels are off by 5–15% from physical reality.
• Some products have no SKU.
• Variants are not consistently named.
• Bundles and kits aren't decremented properly.

Cleanup steps:

1. Do a full physical count. Match Shopify's recorded levels to physical inventory.
2. Standardize SKUs. A SKU should be readable: BRAND-PRODUCT-VARIANT (e.g., BLG-TSHIRT-BLK-M).
3. Audit variants. Naming should be consistent ("Black" not sometimes "BLK" and sometimes "Jet Black").
4. Set up bundle handling. Use a bundling app or Shopify Bundles to ensure component SKUs decrement when a bundle sells.

This cleanup takes 1–3 days of focused work. Don't skip it.

Inventory replenishment math

The two numbers every operator should know per SKU:

• Lead time. Days from when you place a reorder to when it's available to sell.
• Average daily sales rate. Units sold per day, smoothed over the trailing 60–90 days.

Then the formulas:

Reorder point = (Average daily sales × Lead time) + Safety stock

Safety stock = (Max daily sales − Average daily sales) × Lead time

Example: a SKU sells 10 units/day average, 25 max during a sale spike, lead time 30 days.

• Safety stock = (25 − 10) × 30 = 450 units
• Reorder point = (10 × 30) + 450 = 750 units

When inventory hits 750, you reorder. Sounds tedious — and it is — which is why you build it once in a spreadsheet or app and refresh weekly.

Tools that help

• Shopify built-in. Decent for stores under 200 SKUs. Lacks forecasting.
• Stocky (Shopify-owned, free with Shopify POS Pro). Forecasting, purchase orders, vendor management.
• Inventory Planner. Industry standard for multi-channel forecasting. ~$120/mo and up.
• Cogsy. Good UX, modern UI, integrates with multiple sales channels. ~$200/mo.
• NetSuite or Brightpearl. Full ERP — only for stores doing $10M+ across many channels.

For most operators in the $250K–$5M range, Inventory Planner is the sweet spot.

ABC analysis: focus where it matters

Not every SKU deserves equal attention. Sort your catalog into:

• A items. Top 20% of SKUs that drive 80% of revenue. Forecast these weekly. Never let them stock out.
• B items. Middle 30% that drive 15% of revenue. Forecast monthly.
• C items. Bottom 50% that drive 5%. Forecast quarterly. Some should be discontinued.

Most operators spend equal time on every SKU and as a result do all of it badly. Focus on A items.

Multi-location and 3PL inventory

Once you ship from multiple locations:

• Designate a canonical inventory record. Either Shopify or your 3PL is the source of truth — never both.
• Sync inventory updates in near-real-time. Most 3PLs support this via integration; verify the sync works correctly during peak load.
• Allocate inventory by location based on demand patterns. East coast 3PL gets more of products that sell heavily in NY/MA; west coast 3PL gets more of products that sell heavily in CA/WA.

Forecasting for promotions and seasonality

Standard forecasting assumes stable demand. Promotions and seasonal spikes break it. Plan separately:

• BFCM. Pull last year's data, scale by expected growth (typically 30–80% YoY for healthy stores), buy 8–12 weeks before.
• Sale events. Most promotions drive 3–10x normal volume on featured SKUs. Pre-stock specifically.
• Holidays. Christmas, Valentine's, Mother's Day — each has its own product mix.

Build a 12-month sales calendar at the start of each year. Map inventory plans to it.

Dealing with stockouts gracefully

When a stockout happens:

• Pre-order. If your supply chain can deliver in 30–60 days, accept pre-orders with clear delivery date. Captures the sale, builds anticipation.
• Notify me when back in stock. Klaviyo or a back-in-stock app captures emails. When inventory arrives, the email blast often clears 30–50% of the new stock in 24 hours.
• Suggest alternatives. If product A is out, the PDP should show product B, C, D as alternatives.
• Hide stocked-out products from collection pages. Sort them last or remove entirely. Don't make customers click through dead ends.

Avoiding overstock

Overstock ties up cash. Tactics:

• Markdown calendar. SKUs that haven't sold X units in Y days get a 15% markdown. Then 25%. Then 40%. Get the cash back into rotation.
• Bundling. Pair slow-moving SKUs with best-sellers as a bundle.
• Liquidation channels. TJ Maxx-style off-price retailers, Amazon outlets, end-of-life sales to your email list.
• Discontinue ruthlessly. A SKU that hasn't sold in 90 days is probably not worth re-ordering.

Reporting cadence

• Daily: Stock levels for A items.
• Weekly: Reorder point check on all A and B items, sell-through review.
• Monthly: Full inventory health report — turnover, stockouts, overstocks, dead stock.
• Quarterly: ABC re-classification, supplier performance review, financial inventory valuation.

The compounding payoff

A store with tight inventory management has:

• 95%+ in-stock rate on A items.
• Inventory turnover of 4–8x annually (varies by category).
• Less than 5% of revenue tied up in dead stock.
• Cash flow that funds growth instead of inventory carrying cost.

The brands that scale past $5M aren't the ones with the best ads. They're the ones with the operations to deliver consistently when ads work.