Reorder points turn inventory data into a clear purchasing signal. This guide shows how to calculate safety stock, account for changing demand and supplier lead times, and build a repeatable review process that helps small ecommerce businesses reduce avoidable stockouts without buying more inventory than they can support.
Overview
An ecommerce inventory reorder point is the stock level at which you should begin replenishment. It is not necessarily the quantity you want to keep on hand. Instead, it is a trigger designed to cover expected sales while a supplier prepares and delivers the next shipment.
The basic reorder-point formula is:
Reorder point = average demand during supplier lead time + safety stock
For example, if a product sells an average of 8 units per day and the supplier normally takes 10 days to deliver, expected lead-time demand is 80 units. If you hold 20 units as safety stock, the reorder point is 100 units. When your usable inventory reaches that level, a purchase order review should begin.
This calculation is only as useful as the inputs behind it. Averages can hide promotion spikes, seasonal demand, supplier delays, returns, damaged goods, and inventory already committed to open orders. Treat the reorder point as a planning control, not an automatic instruction to buy the same quantity every time.
For a broader operational view, connect inventory planning to your order fulfillment process and capacity planning. A replenishment decision affects receiving, storage, picking, packing, and shipping—not just the purchasing record.
What to track
Start with one product or stock-keeping unit (SKU) and collect a consistent set of fields. A simple worksheet can include:
| Field | What it tells you | Practical note |
|---|---|---|
| Units sold by day or week | Recent demand velocity | Separate normal sales from promotions or unusual events. |
| Average daily demand | Expected units sold per day | Use a defined lookback period and document it. |
| Peak daily demand | Possible demand during a busy period | Useful for products with volatile sales. |
| Average supplier lead time | Typical time from order placement to usable stock | Measure from actual purchase orders when possible. |
| Longest recent lead time | Exposure to supplier variability | Do not assume the best-case delivery time. |
| On-hand inventory | Units physically recorded in stock | Investigate discrepancies before relying on the number. |
| Committed inventory | Units allocated to paid or approved orders | These units are not freely available for new demand. |
| Confirmed incoming inventory | Units already ordered and expected | Account for expected receipt dates and partial shipments. |
| Minimum order quantity and pack size | Purchasing constraints | A calculated quantity may need to be rounded up. |
Use usable inventory rather than a raw on-hand figure when deciding whether to reorder. One practical definition is:
Usable inventory = on-hand stock − committed stock + confirmed incoming stock
Some businesses exclude incoming stock until it has been received, inspected, and made available for sale. Choose one rule and apply it consistently. If supplier reliability is poor, treating unreceived inventory as unavailable can create a more cautious trigger.
Choosing a safety stock method
Safety stock protects against uncertainty in demand, lead time, or both. For a small business without advanced forecasting, a transparent range-based method is often easier to maintain than a complex model:
Safety stock = (peak daily demand × longest lead time) − (average daily demand × average lead time)
Suppose a product sells 12 units on an average day, with a peak of 20 units. The supplier averages 10 days but has recently taken as long as 15 days. Estimated safety stock is:
(20 × 15) − (12 × 10) = 180 units
The result is deliberately protective. Review whether the peak and longest lead time represent a recurring risk or a one-off event. If the result produces an inventory level that is not financially or operationally reasonable, investigate the underlying problem instead of accepting the number without question.
Cadence and checkpoints
Inventory planning works best as a recurring order-management routine. A weekly review is appropriate for fast-moving, seasonal, or promotion-sensitive products. A monthly review may be sufficient for slower-moving items with stable demand. Review high-risk SKUs more often than low-risk ones.
Weekly low-stock review
- Update on-hand quantities after receiving, picking, returns, adjustments, and cycle counts.
- Subtract allocated or committed units and identify orders that are on hold.
- Update sales velocity using the same lookback period as the previous review.
- Check open purchase orders, expected receipt dates, and supplier communications.
- Compare usable inventory with the current reorder point.
- Record the decision: order, monitor, change the forecast, or investigate a data problem.
Monthly or quarterly planning checkpoint
At a broader checkpoint, compare the assumptions used in the worksheet with actual results. Ask whether demand has shifted, whether lead times have changed, and whether safety stock is creating too many aged units. Review product variants separately where sales patterns differ. A popular color or size can require a different trigger from the rest of the product family.
Before a promotion, product launch, holiday period, or marketplace event, run an additional review. Estimate incremental demand separately rather than blending it into a normal average. Also confirm that receiving, storage, picking, and shipping can handle the extra units. The fulfillment capacity planning guide can help connect purchase decisions to warehouse throughput.
How to interpret changes
A rising reorder point does not always mean you should place a larger order immediately. It may indicate faster sales, longer supplier lead times, a temporary promotion, or inaccurate inventory records. Diagnose the cause first.
- Demand rises while lead time is stable: update average demand and check whether the increase is permanent, seasonal, or promotion-related.
- Lead time rises while demand is stable: increase the coverage period cautiously, confirm the supplier's expected schedule, and consider whether alternate sourcing or earlier ordering is practical.
- Both demand and lead time rise: treat the SKU as higher risk and review cash flow, storage space, and fulfillment capacity before increasing the target.
- Stockouts occur above the reorder point: check inventory accuracy, order allocation, unrecorded damage, overselling across sales channels, and whether incoming stock was counted too early.
- Excess stock accumulates: check whether the sales window has passed, whether the safety stock is based on an isolated peak, or whether the purchase quantity exceeds realistic demand.
- Sales are intermittent: use a longer observation period, review demand by season, and avoid treating a single large order as normal daily velocity.
Purchase quantity is a separate decision from the reorder point. After deciding to replenish, consider expected demand over the planning horizon, current usable stock, confirmed incoming units, supplier minimums, pack sizes, cash limits, and storage capacity. A simple planning expression is:
Suggested purchase quantity = target stock level − usable inventory − confirmed incoming inventory
Round the result to the supplier's case or minimum order quantity only after checking that the additional units are justified. Keep a record of why the quantity was adjusted so the next review is easier to audit.
When to revisit
Recalculate or review an ecommerce inventory reorder point whenever a recurring input changes materially. At minimum, revisit fast-moving and high-value SKUs weekly, review the full catalog monthly or quarterly, and conduct a focused check before any planned promotion or seasonal demand period.
Use this action checklist:
- Export recent sales, current inventory, open orders, and purchase-order data.
- Mark unusual periods such as promotions, stockouts, channel launches, and temporary supplier delays.
- Recalculate average demand, peak demand, average lead time, and longest relevant lead time.
- Update safety stock and the reorder point, documenting the lookback period and assumptions.
- Compare the result with cash, storage, minimum-order, and fulfillment constraints.
- Assign an owner and next review date for each high-risk SKU.
Keep the worksheet alongside your order-management records rather than treating it as a one-time calculation. If a product repeatedly approaches zero before replenishment arrives, address the root cause: inaccurate data, a weak supplier estimate, a missed purchase-order step, or a forecast that no longer reflects the business. Pair inventory reviews with your order cancellation and edit workflow so changes in demand are captured before fulfillment. A consistent review habit is usually more valuable than a complicated formula that nobody updates.