Your reorder point is the stock level that triggers your next purchase order: Reorder Point = (Average Daily Sales × Supplier Lead Time) + Safety Stock. Safety stock is the buffer that absorbs demand spikes and late deliveries so you do not sell out before the new shipment arrives. Get both numbers right per SKU and reactive, gut-feel reordering stops.
Key takeaways
- The reorder point formula is: (Avg Daily Sales × Lead Time in Days) + Safety Stock.
- Safety stock can be calculated three ways; the right method depends on how much sales history you have.
- A service level of 95% corresponds to a Z-score of 1.65 in the statistical formula.
- Applying these formulas per SKU is where spreadsheets start breaking down at scale.
- Recalculate both numbers whenever a supplier's lead time changes or a SKU's sales velocity shifts meaningfully.
Why gut feel fails (and what it costs)
If your best-seller goes out of stock for four days and it normally moves 15 units a day at a $40 margin, that is $2,400 in lost contribution margin from one oversight on one SKU. Multiply that across a catalog of 200 SKUs with varying suppliers and you have a systematic problem, not a one-off mistake.
The fix is not to check inventory more often. It is to know the exact number at which each SKU should trigger a reorder, calculated from two inputs you already have: how fast it sells and how long your supplier takes.
The reorder point formula, explained
Reorder Point (ROP) = (Average Daily Sales × Lead Time in Days) + Safety Stock
Each variable does one job:
- Average Daily Sales: total units sold over a recent period (30 or 90 days is common) divided by the number of days in that period.
- Lead Time in Days: the number of calendar days from placing a purchase order to receiving stock at your warehouse or 3PL. Use actual historical averages, not the number your supplier quotes.
- Safety Stock: a buffer added so that if demand spikes or the shipment arrives late, you do not hit zero before the next delivery.
Worked example
A skincare serum sells an average of 12 units per day. Your supplier takes 10 days to deliver. You decide on 25 units of safety stock (calculation shown below).
ROP = (12 × 10) + 25 = 145 units
When on-hand stock drops to 145, place the order. By the time the shipment arrives 10 days later, you will have sold roughly 120 units and still hold your 25-unit buffer.
Three ways to calculate safety stock (choose by data maturity)
Not every merchant has two years of clean sales history. The right formula depends on how much data you can trust.
| Method | Formula | When to use | Trade-off |
|---|---|---|---|
| Fixed days of cover | Avg Daily Sales × Safety Days | New SKUs, sparse history | Simple but ignores variability |
| Max-minus-average | (Max Daily Sales × Max Lead Time) − (Avg Daily Sales × Avg Lead Time) | Seasonal or intermittent demand | Conservative; can overstock |
| Statistical (Z-score) | Z × σd × √L | Established SKUs with 60+ days of history | Most accurate; requires standard deviation |
Method 1: Fixed days of cover
Set safety stock equal to a fixed number of "buffer days." If you sell 12 units/day and want 7 days of cover:
Safety Stock = 12 × 7 = 84 units
Simple to run in a spreadsheet and easy to explain to a supplier. Use this for new products or SKUs with fewer than 30 days of sales data.
Method 2: Max-minus-average
Safety Stock = (Max Daily Sales × Max Lead Time) − (Avg Daily Sales × Avg Lead Time)
If your serum has peaked at 20 units/day, your worst lead time was 14 days, and averages are 12 units/day and 10 days:
Safety Stock = (20 × 14) − (12 × 10) = 280 − 120 = 160 units
This is the conservative choice. It is well-suited to high-revenue SKUs where a stockout is expensive, though it can tie up more cash than necessary on slower movers.
Method 3: Statistical (Z-score) formula
Once you have 60 or more days of sales history, the statistical approach sizes safety stock against actual demand variability and your chosen service level:
Safety Stock = Z × σd × √L
- Z = the service level factor (see table below)
- σd = standard deviation of daily demand
- L = supplier lead time in days
Service level to Z-score reference:
| Target Service Level | Z-Score |
|---|---|
| 90% | 1.28 |
| 95% | 1.65 |
| 97.5% | 1.96 |
| 99% | 2.33 |
If σd is 4 units/day, L is 10 days, and you want a 95% service level (Z = 1.65):
Safety Stock = 1.65 × 4 × √10 = 1.65 × 4 × 3.16 ≈ 21 units
A 95% service level means you have enough stock to meet demand in 95 out of every 100 replenishment cycles. Going to 99% (Z = 2.33) would push safety stock to roughly 29 units, nearly 40% more inventory for that last 4 percentage points of protection.
For a deeper look at how lead time variability feeds into this math, see Lead Time and Demand Variability: The Two Numbers That Drive Every Reorder.
A common mistake: forgetting to separate methods by SKU tier
Most merchants apply one rule across their whole catalog. That is where cash gets trapped or stockouts sneak in. A practical split:
- A-tier SKUs (top 20% of revenue): use the statistical method with a 95-99% service level.
- B-tier SKUs (middle 60%): use max-minus-average or statistical at 90-95%.
- C-tier SKUs (bottom 20%, slow movers): use fixed days of cover at a low service level, or flag them for dead-stock review before adding safety stock at all.
Adding safety stock to a SKU that has not sold in 60 days turns a small problem into a larger one. If you are holding inventory that stopped moving, that capital is better freed before you reorder. The ABC Analysis guide walks through how to tier your catalog before you run these calculations.
When to recalculate
Reorder points and safety stock are not set-and-forget numbers. Recalculate when:
- A supplier's lead time changes by more than 2 days.
- A SKU's 30-day sales velocity diverges from its 90-day average by more than 20%.
- You enter or exit a seasonal peak (a holiday-adjusted demand window changes the numerator in every formula).
- You add a new supplier for an existing SKU.
- You open a new Shopify location that fulfills the same products.
The more SKUs you manage, the faster manual recalculation becomes the bottleneck. At roughly 50-100 SKUs with multiple suppliers, running these formulas in a spreadsheet every week is a part-time job in itself.
Putting it all together without a spreadsheet
Once you have confirmed the math works on a handful of SKUs, the real question is whether you will actually run it every week across your full catalog. Most merchants do not, which is exactly when stockouts happen.
Stockcast: Inventory Forecast monitors your Shopify stock levels daily, applies this reorder point math to every active SKU, and surfaces recommendations ranked by urgency so you act on the right product first. Every recommendation shows the exact calculation behind it, so you are never trusting a black box. If you are coming from Stocky, your supplier data imports via CSV and your reorder logic carries over in minutes.
There is a free plan up to 25 SKUs and a 14-day trial on paid tiers, which is enough time to validate the formula outputs against your own spreadsheet before committing.
FAQ
What is a reorder point?
A reorder point is the inventory level at which you place a new purchase order, calculated so that the remaining stock lasts through your supplier's lead time plus a safety buffer. It equals (Average Daily Sales × Lead Time in Days) + Safety Stock.
What is the difference between safety stock and reorder point?
Safety stock is the buffer quantity you hold to absorb demand spikes or late deliveries. The reorder point is the trigger level that tells you when to order. Safety stock is a component inside the reorder point formula, not a separate system.
How often should I recalculate my reorder points on Shopify?
Recalculate whenever a supplier's lead time changes, when a SKU's sales velocity shifts by more than 20% from its baseline, or when you enter a seasonal period. For active catalogs, a monthly refresh is a practical minimum.
Frequently asked questions
What is a reorder point?
A reorder point is the inventory level at which you should place a new purchase order. It is calculated as (Average Daily Sales x Lead Time in Days) + Safety Stock, ensuring new stock arrives before you sell out.
What is the difference between safety stock and reorder point?
Safety stock is the buffer quantity held to absorb unexpected demand spikes or supplier delays. The reorder point is the stock level that triggers your next order. Safety stock is a component inside the reorder point formula.
How often should I recalculate reorder points for my Shopify store?
Recalculate whenever a supplier's lead time changes by more than two days, when a SKU's sales velocity shifts meaningfully from its recent average, or when entering or exiting a seasonal peak. A monthly review is a practical minimum for most catalogs.