Skip to content

Reorder point formula, and the order-by date that matters more

inventoryreorder pointwoocommerce

The reorder point is the stock level at which you place a new order, so that the delivery arrives before the shelf is empty. In the UK it's usually called the reorder level. The formula fits on one line, and there's a worked example below.

But on its own, the reorder point answers a different question from the one most small online stores face. You don't watch every SKU all day and order the moment one crosses its line. You order from each supplier every week or two, and what you need to know is when: the last day you can order and still have the goods before you run out. So this guide goes one step further and turns the reorder point into that date, the order-by date, and then into a date per supplier.

All of it works in a spreadsheet. If you'd rather see it worked out for every SKU each morning, DemandPilot, our WooCommerce inventory forecasting tool, does that; more at the end.

The reorder point formula

Reorder point = average daily sales × lead time in days + safety stock

  • Average daily sales: units per day, counted over the days the product was in stock. On the days it was out of stock it sold nothing because there was nothing to sell; counting them makes the average too low.
  • Lead time: days from placing the order to having the goods on the shelf, ready to sell. Not the supplier's shipping estimate: include their processing time, transport, customs if any, and your own receiving.
  • Safety stock: the buffer for busy days and late deliveries. The safety stock formula guide compares four ways to size it.

The first part, average daily sales × lead time, is the lead-time demand: what you expect to sell while you wait. Without safety stock, the reorder point is just that, and you run out on about half of your cycles, whenever sales or the delivery are a little worse than average.

Worked example

Example numbers for one product:

InputValue
Average daily sales, in-stock days4 units
Supplier lead time9 days
Safety stock12 units (3 days of sales)

Reorder point = 4 × 9 + 12 = 36 + 12 = 48 units.

When stock falls to 48, you order. Over the next nine days you sell about 36, and the delivery arrives with about 12 left: the safety stock, untouched on an average cycle and used up on a busy one.

Reorder point or reorder level?

Both names mean the stock level that triggers an order. "Reorder level" is the usual UK term, and it's the one taught in accounting courses, often with a different formula:

Reorder level = maximum daily usage × maximum lead time

With a busiest day of 8 units and a longest lead time of 12 days, that's 8 × 12 = 96 units: twice the 48 above. This version builds the buffer in by assuming the worst day and the slowest delivery happen together, all the time. You'll rarely run out, but across a whole catalogue it holds a lot of stock. The same courses define a minimum level, the reorder level − (average usage × average lead time), here 96 − 36 = 60 units. That's the safety stock the method implies.

If you're studying for an exam, use your course's formula. If you're running a store, the average-plus-safety-stock version lets you choose how much buffer you pay for.

Why a stock level isn't what you act on

The reorder point assumes continuous review: you see every SKU's stock at all times and order the moment it crosses its line. A small online store rarely works that way.

  • You order by supplier, not by SKU. One supplier, a few hundred SKUs, one order every week or two, often with a minimum order value or a shipping cost that makes small orders pointless.
  • The line gets crossed between orders. If a SKU reaches its reorder point on a Tuesday and you order from that supplier on Fridays, the safety stock pays for the three-day wait. On a fortnightly rhythm it may not last.
  • A stock level doesn't say when. "48 units" doesn't tell you whether to order today or whether it can wait until next week.

What you can act on is a date for each SKU, and from those, a date for each supplier.

From reorder point to the last day to order

Two steps, both simple.

1. Days of cover: how long the stock lasts.

Days of cover = stock on hand ÷ average daily sales

2. The last day to order: when the order has to go out.

Last day to order = today + days of cover − lead time − safety days

Safety days are the safety stock expressed in days of sales: 12 units ÷ 4 a day = 3 days.

Worked example, continued

Same product. Today is 1 March and you have 100 units.

  • Days of cover: 100 ÷ 4 = 25 days. You run out around 26 March.
  • Last day to order with no buffer: 26 March − 9 days = 17 March.
  • Last day to order keeping 3 days of safety stock: 14 March.

Check it against the reorder point. By 14 March you've sold 13 days × 4 = 52 units, and 48 are left, exactly the reorder point. Same rule, but now it's a date you can put in a calendar, and you can see two weeks ahead which orders are due.

Two adjustments keep the date honest:

  • Count stock on order on the day it arrives, not today. Units due on 10 March push the run-out date back because they land before the shelf is empty. Units due on 30 March don't stop a stock-out on 26 March, even though adding them to today's stock would say they do.
  • Use a forecast when sales are changing. If a seasonal peak starts inside the lead time, a flat average puts the date too late. Count the cover with the sales you expect over the coming weeks, not with last month's pace.

One date per supplier

Each SKU now has its own last day to order. A supplier's order date is the earliest of its SKUs' dates. When that day comes, you order the urgent SKU and top up the others from the same supplier in the same order, so that they all last until the next one. That's how ordering by supplier and per-SKU reorder points fit together.

How much to order when the date comes

The reorder point says when, not how much. A practical rule for a small store:

Order quantity = forecast sales over (lead time + days of stock) + safety stock − stock on hand − stock on order

Days of stock is how long the delivery must last: at least the gap until your next order from that supplier, longer if you prefer fewer, bigger orders. Then round up to the supplier's minimum order quantity and to whole case packs.

Example: you order from this supplier every 14 days. On 14 March you have 48 units and nothing on order. Forecast over 9 + 14 = 23 days: 4 × 23 = 92 units. Add 12 of safety stock: 104. Take off the 48 on hand: 56 units. The supplier packs in cases of 12, so you order 5 cases, 60 units.

Common mistakes

  1. Averages that include out-of-stock days. They make the average too low, so the reorder point drops and you run out again.
  2. The promised lead time instead of the real one. Measure it from your own orders: order date to goods on the shelf.
  3. Forgetting stock already on order, and ordering the same units twice.
  4. Mixing units. Lead time in weeks and sales per day: put both in days, or both in weeks.
  5. Setting it once. A reorder point from last spring is wrong by autumn. Recalculate monthly and before a seasonal peak.
  6. Using it on slow sellers. A product that sells twice a month can have a reorder point below one unit. Keep a fixed minimum instead, such as "always 2 on the shelf".

How DemandPilot turns this into a morning list

DemandPilot reads your WooCommerce catalogue, orders and stock with a read-only REST key. Nothing is installed in WordPress, and it never changes your shop's stock.

  • Each night it measures each SKU's rate of sale on in-stock days only, so out-of-stock days don't look like falling demand. The forecast uses recent sales and their trend, and seasonal peaks when there is history.
  • It forecasts over the supplier's lead time plus the days of stock you want, and projects stock at the end of that period: today's stock, minus forecast sales, plus orders arriving on their expected day. The shortfall becomes the suggested quantity, raised to the supplier's minimum order quantity and whole case packs.
  • Every morning it shows what to reorder, how much, the last day to order in time, how many days your stock covers, and the sales lost until a delivery ordered today arrives.
  • It prepares draft purchase orders, one per supplier.

It's priced per shop, by quote.

Frequently asked questions

What is the reorder point formula?

Reorder point = average daily sales × lead time in days + safety stock. With 4 sales a day, a 9-day lead time and 12 units of safety stock, it's 48 units.

How do I calculate the reorder level?

The reorder level is the UK name for the reorder point, so the same formula works: average daily sales × lead time, plus safety stock. Accounting courses often use maximum daily usage × maximum lead time instead, which gives a higher, more cautious figure: 96 units instead of 48 in the example.

What happens if I hold no safety stock?

The reorder point is then just the lead-time demand, and you'll run out on about half of your cycles: whenever sales or the delivery are a little worse than average.

What lead time should I use?

The one you measure: the average number of days from placing an order to having the goods on the shelf, over the last several orders from that supplier. If it varies a lot, allow for that in the safety stock.

How often should I recalculate reorder points?

Monthly is a sensible rhythm for a small store, plus before every seasonal peak and whenever a supplier changes its delivery times.