Running out of a best seller loses sales and pushes customers to competitors. Buying too much of a slow seller ties up cash and storage. Inventory forecasting is how you avoid both: knowing when to reorder each product and how much to buy.
You don't need complex software to start. Here's the method, with examples.
The three numbers you need
| Number | What it is | Where to get it |
|---|---|---|
| Average daily sales | Units sold per day, recently | Your shop platform's sales reports |
| Lead time | Days from placing an order to stock being ready to sell | Your supplier history |
| Variability | How much daily sales and lead times swing | Your records |
Step 1: Calculate average daily sales
Use the last 30–90 days, adjusted for anything unusual (a one-off promotion, a stockout).
Example: you sold 540 units of a mug in the last 90 days, but it was out of stock for 10 of those days. Daily sales = 540 ÷ 80 selling days = 6.75 units a day.
Don't divide by days you had no stock. That understates demand.
Step 2: Work out the reorder point
Reorder point = (average daily sales × lead time in days) + safety stock
If your supplier takes 20 days: 6.75 × 20 = 135 units sold while you wait.
Add safety stock (below), and when stock falls to that level, you reorder.
Step 3: Set safety stock
Safety stock protects you against busier-than-usual days and late deliveries.
Simple method
Keep a number of extra days of sales, for example seven: 6.75 × 7 ≈ 47 units.
Reorder point = 135 + 47 = 182 units.
More precise method
Safety stock = Z × standard deviation of daily sales × √lead time
Z depends on how often you're willing to run out:
| Target in-stock level | Z |
|---|---|
| 90% | 1.28 |
| 95% | 1.65 |
| 98% | 2.05 |
If daily sales vary with a standard deviation of 2.5 units, lead time is 20 days and you want 95%: 1.65 × 2.5 × √20 ≈ 1.65 × 2.5 × 4.47 ≈ 18 units.
If lead times also vary, add a buffer for that too, or use the simple method with more days.
Spend your highest safety stock on best sellers and products with long lead times. Slow, cheap or easily replaced items need less.
Step 4: Decide how much to order
A practical approach: order enough to cover the time until your next order plus the lead time, minus what you have.
Order quantity = (daily sales × (review period + lead time)) + safety stock − current stock − stock already on order
If you review stock every 30 days: 6.75 × (30 + 20) + 47 − 160 − 0 ≈ 225 units.
Then round to the supplier's case size or minimum order quantity.
Economic order quantity (optional)
For products with significant ordering costs (shipping, admin) and holding costs (storage, cash), the economic order quantity formula balances the two:
EOQ = √(2 × annual demand × cost per order ÷ annual holding cost per unit)
It's useful for larger catalogues, but supplier minimums and price breaks often matter more in practice.
Step 5: Adjust for seasonality and events
Averages miss predictable peaks. Before Black Friday, Christmas, summer or a planned campaign:
- Look at last year's sales for the same period.
- Multiply your daily sales by the seasonal uplift you saw (e.g. 2.5× in late November).
- Order earlier, because suppliers and shipping are busier too.
Read our Black Friday 2026 checklist for peak-season timing.
Step 6: Classify products (ABC)
Not every product deserves the same attention:
| Class | Share of revenue | How to manage |
|---|---|---|
| A | Top ~80% of revenue from ~20% of products | Review weekly, higher safety stock |
| B | Next ~15% | Review every two to four weeks |
| C | Last ~5% | Review monthly; consider discontinuing slow items |
Warning signs to watch
- Stockouts on A products: reorder point too low or lead times longer than you think.
- Stock older than six months: over-buying; discount, bundle or stop reordering.
- Frequent emergency orders: safety stock too low or forecasts not updated.
- Cash tied up in stock: check stock value against sales. Your balance sheet shows it.
Let software do the maths
Spreadsheets work for a few products. Beyond that, Zelvorm Stock forecasts each product's sales from your history, tells you exactly when and how much to reorder and writes the purchase order for you. It's free.
The short version
Reorder when stock falls to your reorder point: daily sales × lead time + safety stock. Calculate daily sales over days you had stock, set safety stock by how often you can afford to run out, order enough to cover the next review period plus lead time, adjust for seasonality and focus most attention on your best sellers.
Running a growing shop? Our e-commerce team can connect stock, sales and suppliers so reorders happen on time.




