Safety stock and reorder points: how ecommerce brands avoid stockouts without overbuying

Mirena Rumenova
Mirena Rumenova
November 19, 2026
Safety stock and reorder points: how ecommerce brands avoid stockouts without overbuying

The right safety stock for each SKU is (max daily sales × max lead time) − (average daily sales × average lead time). Set the reorder point at average daily sales × lead time + safety stock, so you reorder before a stockout without parking extra cash.

That math matters. IHL Group inventory distortion research, reported by Retail Insight Network, puts the cost of out-of-stocks and overstocks at about $1.7tn in 2026. That is 6.2% of worldwide retail sales, with out-of-stocks at 65.6% of the cost and overstocks at 34.4%.

Below is a formula table to copy into a spreadsheet, with worked examples and the cash cost of each buffer.

What is safety stock and why does it matter?

Safety stock is the extra inventory you hold per SKU to cover demand spikes and late deliveries until the next purchase order arrives. It is the buffer, and the reorder point is the trigger that tells you when to buy.

Too little buffer, and one viral post or delayed container empties the shelf. Too much, and cash sits in boxes that sell slowly.

The right size depends on how well you predict demand. Wikipedia's safety stock entry notes that a less accurate forecast needs more safety stock, and so does a higher service level. So a new product with patchy sales history needs a bigger buffer than a steady bestseller.

A SKU sold on Shopify, WooCommerce, Amazon and an EU marketplace draws down one shared pool of stock. Keeping that pool accurate is the job of multi channel inventory management.

How do you calculate reorder points correctly?

You calculate a reorder point in four steps: average daily usage, supplier lead time, safety stock, then lead time demand plus the buffer. Run the reorder point calculation per SKU.

Step 1: average daily usage across every channel

Average daily usage is the total units a SKU sells across all channels in a period, divided by the days in that period.

Example: in 30 days, a candle SKU sells 450 units on a US Shopify store and 180 on an EU WooCommerce store. It also sells 180 on Amazon and 90 on an EU marketplace. That is 900 units ÷ 30 days = 30 units a day.

Skip one channel and every number after this one is too low.

Step 2: supplier lead time in days

Supplier lead time is the number of days between placing a purchase order and having stock ready to sell. Pull it from your own purchase order history and note the average and the longest.

Include production, transit, customs and receiving. A container that lands on day 14 but is unpacked on day 16 is a 16-day lead time. Example: average lead time 14 days, max lead time 18 days.

Step 3: safety stock

Safety stock can be set with the max-average method or the service level method. The first is simple and cautious; the second ties the buffer to the stockout risk you accept.

With the max-average method, safety stock = (max daily sales × max lead time) − (avg daily sales × avg lead time). Example: (40 × 18) − (30 × 14) = 720 − 420 = 300 units.

With the service level method, safety stock = z × σ(daily sales) × √(lead time days). A z of 1.65 ≈ 95%, meaning demand is covered in about 95 of 100 reorder cycles. Example: 1.65 × 12 × √14 (3.74) = 74 units, where 12 is the standard deviation of daily sales.

The max-average method stacks your worst sales day on your worst lead time, so it buys more insurance. Switch to the service level method once you have enough daily sales history.

Step 4: reorder point formula

The reorder point formula is average daily sales × lead time + safety stock. When available stock falls to that number, you reorder.

Example: 30 × 14 + 300 = 720 units. Compare it against available stock (on hand + on order − reserved), since on-hand stock ignores reservations and incoming orders.

With 600 on hand, 200 on order and 120 reserved, available stock is 680. That is below 720, so reorder now.

All numbers in the table below are examples for one illustrative SKU, never Prim.io customer data.

InputFormulaExample result
Average daily usageUnits sold across all channels over period ÷ days in period900 ÷ 30 = 30 units a day
Lead time demandAvg daily sales × avg lead time30 × 14 = 420 units
Safety stock (max-average)(Max daily sales × max lead time) − (avg daily sales × avg lead time)(40 × 18) − 420 = 300 units
Safety stock (service level)z × σ(daily sales) × √(lead time days), z = 1.65 for about 95%1.65 × 12 × 3.74 = 74 units
Reorder pointAvg daily sales × lead time + safety stock420 + 300 = 720 units
Available stockOn hand + on order − reserved600 + 200 − 120 = 680 units
Cash tied up in bufferSafety stock × unit cost300 × $12 = $3,600

In Excel or Google Sheets, the service level row is =1.65*STDEV.S(B2:B31)*SQRT(14), with 30 days of daily sales in B2:B31.

How does lead time affect safety stock levels?

Lead time raises safety stock levels: the longer and less predictable a supplier's lead time, the bigger the buffer and the cash it ties up. In this example, doubling lead time more than doubles the max-average buffer.

Both columns use the example SKU above, with a $12 unit cost.

Input14-day supplier (example)30-day supplier (example)
Average lead time14 days30 days
Max lead time18 days38 days
Lead time demand420 units900 units
Safety stock (max-average)300 units620 units
Safety stock (service level, z = 1.65)74 units108 units
Reorder point (max-average)720 units1,520 units
Cash tied up in buffer$3,600$7,440

The 30-day supplier ties up $3,840 more cash for the same sales. Weigh that against any unit price saving.

The same IHL Group research links long supplier lead times and inaccurate forecasts to higher overstock risk.

For unit cost, use landed cost: purchase price plus freight and duties, before sales tax or VAT.

How do you prevent stockouts without overbuying inventory?

You prevent stockouts without overbuying by recalculating safety stock each season and sizing buffers by SKU priority.

Recalculate before each peak from the same weeks of last year's actual sales. For example, a swimwear SKU selling 30 a day in June may sell 8 in November. A June buffer carried into winter just parks cash.

Next, rank SKUs by revenue. Top sellers get the service level method at 95% or higher. Slow sellers get thin buffers, because a short stockout costs little and dead stock costs cash.

Then review inventory turnover regularly. A buffer that never gets touched is too big.

All of this needs trustworthy stock counts. A perpetual inventory system updates stock with every sale and receipt, so your available stock check stays current.

Why do manual safety stock estimates fail growing brands?

Manual safety stock estimates fail growing brands because they rest on gut feel and stale spreadsheets, while sales data sits in separate channel apps. Brands then stock out on spikes or tie up cash in slow stock.

A spreadsheet is a snapshot. Shopify sales get exported Monday, Amazon sales Wednesday, and by Friday the sheet is stale.

Lead times sit in supplier emails and wholesale reservations in another tool. Each gap pulls the reorder point calculation further from reality.

The fix is one record for sales, stock, purchase orders and lead times. ERP inventory management keeps stock across warehouses and sales channels in one place, so the formula runs on current data.

How Prim.io combines BI and inventory control

Prim.io combines BI and inventory control by running its AI assistant and Qlik-powered BI on the same live stock and sales data. Prim.io is a cloud ERP with built-in AI for ecommerce and multi-channel brands, running orders, stock, finance, CRM, production and BI in one system.

The Prim.io AI assistant answers from the company's own sales, stock and finance data, so a buyer can check a SKU without building a report.

Prim.io MCP connects Claude, ChatGPT and Cursor with per-user permissions and approval before changes.

For safety stock work, Prim.io cloud ERP puts real-time multi-warehouse inventory, purchasing and landed cost in one record, with a minimum and optimal quantity set for each SKU in each warehouse. Each warehouse can also send a message in Prim.io to chosen user roles when a SKU falls to its minimum quantity, so buyers know it is time to place the purchase order.

Channel sales reach Prim.io through Prim.io native integrations. Store, marketplace and courier connectors are priced per connector (€20 to €50 per month); finance connectors are free.

Open a free demo account

Free demo account, no credit card needed, cancel anytime.

Why ecommerce brands choose Prim.io

Ecommerce brands choose Prim.io because it already runs high order volumes across many channels. Compare Prim.io plans and pricing.

  • Prim.io processes 3.1M+ orders every month.
  • Prim.io connects sales channels and couriers through 50+ native integrations.
  • OhGood runs 3 warehouses in one real-time view.
  • Home Infinity spends 60% less time on order processing.

Frequently asked questions about safety stock

These five answers cover common safety stock and reorder point questions.

What is safety stock?

Safety stock is extra inventory held per SKU to cover demand spikes and supplier delays until the next delivery arrives. It protects you from stockouts when sales beat your forecast. The right amount depends on forecast accuracy and supplier lead time, so recalculate it for each SKU every season.

How do I calculate reorder points?

Calculate a reorder point by multiplying average daily sales across all channels by supplier lead time in days, then adding safety stock. For example, 30 units a day × 14 days + 300 units of safety stock = 720 units. Reorder when available stock (on hand + on order − reserved) falls to that number.

What is the reorder point formula in ecommerce?

The reorder point formula in ecommerce is average daily sales × lead time + safety stock. Ecommerce brands should add up daily sales from every channel, including webshops and marketplaces, before applying it. Using one channel's sales alone understates demand, so purchase orders go out too late and the busiest channels stock out.

Can cloud ERP automate inventory reordering?

A cloud ERP can keep the inputs for reordering current by recording sales, stock and purchase orders in one system. That keeps reorder point calculations based on live data instead of exported sheets. Which steps run automatically, such as alerts or draft purchase orders, depends on the system, so confirm it in a demo. In Prim.io, each warehouse can send a message to chosen user roles when a SKU falls to its minimum quantity; your team then creates the purchase order.

How much does Prim.io cost?

Prim Plus is €180, Prim Pro €540 and Prim Enterprise €1,710 per month, billed annually, excluding VAT, with 3, 5 and 15 users included. Store, marketplace and courier connectors are priced per connector (€20 to €50 per month); finance connectors are free.

Conclusion: safety stock and reorder point checklist

This safety stock and reorder point checklist turns the formulas into a seasonal routine. Right-sized buffers protect revenue and cash at once.

  • Calculate average daily usage and supplier lead time in days for every key product.
  • Use a standard reorder point formula to trigger purchase orders before stock runs critically low.
  • Adjust safety stock buffers seasonally based on actual historical sales trends.
  • Review inventory turnover ratios regularly to avoid overbuying slow moving goods.

Run these numbers on live stock and sales data with Prim.io.

Open a free demo account

Free demo account, no credit card needed, cancel anytime.

Categories

Business tips
News
Publications

Meet an expert

Assess your project & get a tailored demo

Prefer to talk? Call our team directly.

Mon–Fri, 9am–6pm EET

Ready to see it for yourself?

The best way to understand Prim.io is to try it. Start with a free demo account and explore at your own pace.