Quick note: this uses the classic reorder-point formula, which assumes fairly steady demand. It's a great manual estimate. Real sales are lumpy and seasonal โ handling that automatically (per SKU) is exactly what we're building StockPilot to do. StockPilot is pre-launch / early access, not yet live on the Shopify App Store.
How the reorder point formula works
Your reorder point is simply the stock level at which you should place a new order โ calculated so that fresh stock arrives just before you run out. There are two pieces: the stock you'll sell while you wait for the supplier (lead-time demand), plus a buffer for the unexpected (safety stock).
Using the calculator's defaults โ 10 units/day, a 14-day lead time, and a 7-day safety buffer:
- Lead-time demand = 10 ร 14 = 140 units (what you'll sell while waiting for the order)
- Safety stock = 10 ร 7 = 70 units (your cushion for spikes or supplier delays)
- Reorder point = 140 + 70 = 210 units โ when stock hits 210, it's time to reorder.
How much should I actually order?
The reorder point tells you when; the order quantity tells you how much. A simple, practical approach is to order enough to cover a chosen period (say 30 days), then round up to your supplier's minimum order quantity (MOQ):
Use the free spreadsheet template
Want to do this for every product at once? Click "Download free spreadsheet template" above. It opens in Google Sheets or Excel with the columns already laid out, plus a worked example row. Drop the formula below into the Reorder point column and copy it down for all your SKUs:
It's a handy stopgap while Stocky winds down. The catch with any spreadsheet: you have to keep the daily-sales numbers current and remember to check it. That manual upkeep โ recalculating as sales shift, flagging which SKUs crossed their reorder point this week โ is the part StockPilot is designed to take off your plate.
Frequently asked questions
What is a reorder point, in plain terms?
How do I find my average daily sales?
How much safety stock should I keep?
Is this the same as Stocky's reorder suggestions?
What's the limitation of this formula?
Does this calculator store my data?
Built by the team at Kyrabase Technologies Pvt Ltd, makers of StockPilot. Spotted a mistake or have a suggestion? Tell us โ we'll fix it.