Who this guide is for
DTC and fast-growing Shopify merchants who keep running out of bestsellers and feel forecasting is guesswork. Especially relevant for brands managing 20+ SKUs across multiple suppliers.
The challenges of scale
Bestsellers go out of stock during peaks while slow movers sit on the shelf, because planning is based on rough averages and gut feel rather than actual demand velocity.
Shopify's native low-stock alerts trigger too late - you only notice stockouts after they happen, not when you still have time to reorder. As one merchant put it: 'I keep running out of stock on products without noticing… losing potential sales during peak demand… I'm sure I am bleeding customers to my competitors as a result.'
Inventory planning lives in spreadsheets that do not scale beyond a few dozen SKUs or suppliers. Doing this math manually for 100+ SKUs is an absolute headache.
Team struggles to balance stockouts vs. overstock; reorders are either too early (cash locked up) or too late (sales lost).
Shopify's inventory system updates only after an order is placed and has no concept of 'available to sell' across bundles or shared components, so counts can go negative before any alert fires.
There is no per-SKU reorder point stored in native Shopify - meaning every replenishment decision is reactive rather than driven by pre-calculated thresholds.
Seasonal demand spikes (e.g., Q4 holiday, back-to-school) are not automatically factored into reorder timing, causing recurring stockouts at the same points every year.
Fundamental concepts
Reorder Point (ROP)
The inventory level at which you must place a new purchase order so that new stock arrives before you run out. It connects your forecasted demand during the lead-time window to a concrete trigger point.
Formula
ROP = (Average Daily Demand × Lead Time in Days) + Safety StockExample: If you sell 15 units/day, your supplier takes 10 days to deliver, and you want 50 units of safety stock: ROP = (15 × 10) + 50 = 200 units. When stock drops to 200, place the order.
Safety Stock
Extra buffer inventory held above expected lead-time demand to protect against demand spikes and supplier delivery delays. Safety stock is the insurance policy of inventory planning.
Formula
Safety Stock = (Max Daily Demand × Max Lead Time) – (Average Daily Demand × Average Lead Time)Example: Max daily demand: 25 units. Max lead time: 14 days. Avg demand: 15/day. Avg lead time: 10 days. Safety Stock = (25 × 14) – (15 × 10) = 350 – 150 = 200 units.
Lead Time
The total number of days between placing a purchase order and receiving sellable stock, including supplier production time, transit, and warehouse check-in. Longer and more variable lead times require earlier reorder triggers and higher safety stock.
Formula
Lead Time = Production Days + Transit Days + Receiving DaysExample: A supplier in Shenzhen with 7-day production + 18-day sea freight + 2-day receiving = 27-day total lead time. This must feed directly into the ROP formula.
Inventory Carrying Cost
The annual cost of holding inventory - including capital cost (opportunity cost of cash tied up), warehouse/storage fees, insurance, shrinkage, and obsolescence risk. Expressed as a percentage of average inventory value.
Formula
Carrying Cost % = (Capital Cost + Storage + Insurance + Obsolescence + Shrinkage) / Average Inventory Value × 100Example: A brand holding $500,000 in inventory at a 25% carrying rate pays an effective $125,000/year in holding costs - even if the goods never move.
Stockout Cost
The revenue and customer lifetime value lost when a product is unavailable. Includes immediate lost sales, customer defection to competitors, and damage to brand reputation. Often underestimated because lost revenue is invisible in reports.
Formula
Stockout Cost = Lost Units × Average Order Value × (1 + Customer Retention Impact)Example: If you're out of stock for 3 days on a product selling 20 units/day at $60 AOV, the immediate lost revenue is 60 × $60 = $3,600 - before accounting for customers who never return.
Days of Inventory Remaining (DIR)
An estimate of how many days of stock you have left at the current sales rate. A leading indicator for stockout risk - when DIR drops below your lead time + safety buffer, you're already behind.
Formula
DIR = Current Stock on Hand / Average Daily Sales (over trailing 28–90 days)Example: 300 units on hand, selling 12/day = 25 days of inventory. If your lead time is 21 days and you want 7 days of safety stock, your ROP is already at risk.
Why native Shopify isn't enough
While Shopify is a strong commerce engine, its native inventory tooling often reaches a limit once brands need better forecasting, replenishment logic, supplier workflows, and purchasing discipline.
- Shopify shows on-hand, committed, and incoming stock quantities but does not calculate per-SKU reorder points or demand-based reorder quantities natively.
- Native low-stock and out-of-stock alerts are simple numeric thresholds - they cannot encode lead times, safety stock, or seasonal velocity adjustments per SKU.
- The inventory count updates only when an order is placed, not when a customer views or reserves an item; this means bundles and shared-component products can oversell before alerts fire.
- Shopify Flow can send alert emails when stock drops below a threshold, but it cannot compute reorder points, forecast demand, or calculate safe reorder quantities on its own.
- Stocky (Shopify's bundled POS forecasting app) offered min/max replenishment suggestions, but Shopify has announced Stocky will be discontinued in 2026 - removing even this basic automated forecasting from the platform.
- There is no native Shopify feature to store per-SKU lead times that feed into reorder point calculations; merchants must track this in metafields, notes, or external spreadsheets.
- Shopify's 'Days of Inventory Remaining' metric (available in analytics) uses a 28-day rolling average and does not account for upcoming promotions, seasonality, or outstanding purchase orders.
Key stats and benchmarks
Industry analysis shows retailers lose approximately 3% of annual revenue to stockouts alone; in apparel, stockouts can drive up to 40% of lost sales when combined with overstock effects.
Globally, stockouts and overstock combined cost retailers an estimated $1.73 trillion per year in lost revenue and tied-up capital (IHL Research).
Over half of all ecommerce SKUs experience at least one stockout per year, and most are only noticed after sales have already dropped.
Poor inventory alignment - stockouts plus overstock - can erode around 11% of annual sales for ecommerce merchants.
Annual inventory carrying costs typically run 20–30% of average inventory value, meaning every dollar of unnecessary buffer stock is an active drag on cash flow.
US retailers alone lose approximately $362.1 billion per year to excess inventory (overstock carrying costs and write-downs).
Merchants who implement reorder-point automation report an average 25–35% reduction in stockout incidents within the first 90 days.
Practical angles to explore
- Step-by-step guide: how to calculate your first ROP and safety stock from Shopify order data - with a downloadable template
- The real cost of a stockout: how to calculate the revenue you're actually losing (most merchants severely underestimate this)
- Why Shopify's low-stock alerts are set up to fail you - and what to use instead
- Seasonality-adjusted reorder points: how to build demand forecasts that account for Q4, sales events, and product launches
- Stockout post-mortem framework: how to diagnose why you ran out and prevent the same SKU from stocking out again
How Synplex helps
Synplex embeds reorder-point and safety-stock logic directly into a Shopify-native workflow: it uses your order history, lead times, and supplier data to predict when SKUs will run out, computes recommended reorder quantities, and generates draft purchase orders before stockouts occur - without forcing you back into spreadsheets.
- Per-SKU reorder point calculation based on actual Shopify sales velocity and supplier lead times
- Automatic safety stock recommendations that update as demand patterns change
- Smart Replenishment: generates suggested purchase order quantities before stock hits the danger zone
- Supplier lead time storage that feeds directly into inventory logic - not just a notes field
- Days of inventory remaining forecasts that account for open POs and seasonality
Suggested guide outline
- 1Intro: Why Shopify stores keep getting blindsided by stockouts (and what it's really costing them)
- 2Section 1: How far native Shopify inventory tools get you - and exactly where they stop
- 3Section 2: Core concepts every Shopify merchant needs to know - ROP, safety stock, lead time, DIR
- 4Section 3: Step-by-step - calculating reorder points for your top 10 SKUs using Shopify data
- 5Section 4: Building a seasonal demand adjustment into your reorder logic
- 6Section 5: When spreadsheets break - scaling beyond a few dozen SKUs
- 7Section 6: How Synplex turns this into a continuous, automated replenishment process
- 8Closing checklist: 10 things to fix this week to reduce stockouts by next month
Frequently asked questions
Common questions about stockout prevention on shopify: practical playbook for growing brands.