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

NumberWhat it isWhere to get it
Average daily salesUnits sold per day, recentlyYour shop platform's sales reports
Lead timeDays from placing an order to stock being ready to sellYour supplier history
VariabilityHow much daily sales and lead times swingYour 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 levelZ
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:

ClassShare of revenueHow to manage
ATop ~80% of revenue from ~20% of productsReview weekly, higher safety stock
BNext ~15%Review every two to four weeks
CLast ~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.