You have 60 units of a product left. You sell about eight per day, and your supplier takes six days to replenish it. Should you order today or wait?
The answer depends on how much stock you expect to sell before the next delivery and how much extra you want available if demand increases or the shipment arrives late.
Learning how to calculate reorder point for a small online store gives you a practical threshold for making that decision. You can start with a spreadsheet, recent sales records, and actual supplier delivery times.
What Is a Reorder Point?
A reorder point is the inventory threshold that prompts you to replenish a specific product. It covers expected demand during the replenishment lead time plus a reserve called safety stock. Oracle’s inventory documentation uses this same relationship in its reorder-point planning method. docs.oracle.com
Calculate the threshold separately for products or variants whose inventory you manage independently. A medium black T-shirt, for example, may need a different reorder point from a large blue version.
How to Calculate Reorder Point for a Small Online Store
Use this formula when average daily demand reasonably represents the sales you expect during replenishment.
Reorder point = (Average daily demand × Lead time in days) + Safety stock
More generally, the calculation adds safety stock to forecast demand during lead time. If a promotion or seasonal increase is approaching, use the demand you expect during that specific period. docs.oracle.com
Step 1. Estimate Average Daily Demand
Divide units sold by the number of days in a representative period.
Average daily demand = Units sold ÷ Number of days
Suppose your store sold 240 units over 30 calendar days.
240 ÷ 30 = 8 units per day
Include zero-sales days when the product was available. Removing those days would inflate the average.
However, flag days when the product was out of stock. Recorded sales during a stockout can understate customer demand. If you cannot estimate missed sales, use a representative in-stock period and treat the result as provisional.
Also check whether the period included unusual events, such as a clearance sale or a large one-time order.
Step 2. Measure Replenishment Lead Time
Measure the time from placing the purchase order until the new stock becomes available to sell.
Depending on your operation, this may include supplier processing, shipping, customs clearance, receiving, and inspection.
Use recent purchase-order records to check how long replenishment actually takes.
Keep your time units consistent. If customers order every day and your demand estimate uses calendar days, measure lead time in calendar days too. Six supplier business days may span more than six calendar days.
Step 3. Choose a Safety Stock Buffer
Safety stock provides extra inventory for higher-than-expected demand or replenishment delays.
A straightforward starting approach is to choose a number of additional demand days.
Safety stock = Average daily demand × Buffer days
At eight units per day, a two-day buffer gives you this result.
8 × 2 = 16 units
Two buffer days is an illustrative planning choice. Review actual delivery delays and sales fluctuations before deciding whether it fits your product.
A larger buffer ties up more cash and storage space. A smaller buffer gives you less room to absorb unexpected changes. The days-of-cover approach is a simple estimate and does not establish a statistical service level.
Step 4. Calculate the Reorder Point
Using the figures above, with a six-day replenishment lead time.
Reorder point = (8 × 6) + 16
Reorder point = 64 units
Under a rule that triggers replenishment at or below the threshold, review the product for ordering when its inventory position reaches 64 units.
Worked Example for an Online Store
Suppose your store sells reusable packing cubes. All figures below are hypothetical.
| Input | Calculation | Result |
|---|---|---|
| Average daily demand | 240 units ÷ 30 calendar days | 8 units per day |
| Replenishment lead time | Ordering to sellable stock | 6 calendar days |
| Expected lead-time demand | 8 × 6 | 48 units |
| Safety stock | 8 × 2 buffer days | 16 units |
| Reorder point | 48 + 16 | 64 units |
If you have 60 sellable, uncommitted units, no backorders, and no stock on order, you have crossed the threshold.
Under the stated rule, it is time to replenish.
If demand stays at eight units daily and replenishment takes six days, you would expect to sell 48 units while waiting. Ordering at 60 units would leave approximately 12 units when the delivery arrives. That outcome depends on the demand and delivery assumptions holding.
Check Incoming Orders Before Buying Again
A low physical stock count does not always mean you need another purchase order. You may already have replenishment on the way.
For a basic purchasing check, use inventory position.
Inventory position = Sellable on-hand stock + Stock on order − Outstanding customer commitments
Subtract commitments only if they are still included in your on-hand figure. Include outstanding backorders once, without double-counting orders already recorded as commitments.
For example, suppose you have 60 uncommitted units and another 40 confirmed units due tomorrow. Your inventory position is 100 units. With expected demand of eight units before delivery, your current stock should cover the wait.
Check arrival dates separately. A shipment arriving after your expected stockout date will still require attention, even if the total inventory position looks sufficient.
How to Calculate Reorder Point in Excel
Create one row per SKU and use the following columns.
| Column | Heading | Entry or formula for row 2 |
|---|---|---|
| A | SKU | Product identifier |
| B | Average Daily Demand | Enter units per day |
| C | Lead Time | Enter days |
| D | Safety Stock | Enter units |
| E | Reorder Point | =ROUNDUP(B2*C2+D2,0) |
| F | Available On-Hand Stock | Enter sellable units free to allocate |
| G | Confirmed Stock on Order | Enter incoming units |
| H | Inventory Position | =F2+G2 |
| I | Reorder Check | =IF(H2<=E2,"Review reorder","") |
This setup assumes column F already accounts for customer commitments and outstanding backorders. Adjust the calculation if your source data uses a different definition.
The formula in column I flags a purchasing review. Check delivery dates, stock accuracy, and existing purchase orders before placing the order.
Reorder Point vs. Reorder Quantity
These calculations support different purchasing decisions.
| Measure | Question it answers | Main considerations |
|---|---|---|
| Reorder point | When should I replenish? | Demand, lead time, safety stock |
| Reorder quantity | How many units should I buy? | Forecast sales, supplier minimums, pack sizes, cash, storage |
A reorder point of 64 units does not mean every purchase order should contain 64 units.
Choose the order quantity based on the stock you want available after replenishment, accounting for existing inventory and expected demand. Then check supplier minimums, storage capacity, and your purchasing budget.
Common Reorder-Point Mistakes
Using One Threshold for Every Product
Products can differ in sales rate, replenishment time, and demand variability. Calculate thresholds at the level where you make inventory decisions.
Ignoring Promotions and Seasonal Changes
A historical average can understate demand during a planned campaign. Estimate sales for the upcoming replenishment period and revisit the threshold afterward.
Counting Unusable Stock
Damaged items and returns awaiting inspection may appear in physical counts. Exclude units that cannot currently fulfill customer orders.
Reviewing Inventory Too Infrequently
A product can cross its reorder point just after a weekly check.
Use inventory alerts where available. If you purchase only at scheduled reviews, plan a target stock level that covers both the time until the next review and replenishment lead time, plus a buffer.
Leaving Assumptions Unchanged
Review thresholds when supplier performance, demand, or product availability changes. Record why you adjust them so future purchasing decisions have context.
Frequently Asked Questions
1. Can I calculate reorder point without safety stock?
Yes. Set safety stock to zero and use expected demand during replenishment lead time.
This leaves no additional inventory buffer if demand exceeds your estimate or the delivery takes longer than expected.
2. How often should I update reorder points?
A monthly review is a practical starting routine for steady products. Review more frequently when sales change quickly, suppliers become unreliable, or a promotion is approaching.
The appropriate frequency depends on how quickly your assumptions can become outdated.
3. How do I calculate reorder point for a new product?
Start with a provisional demand estimate based on a comparable product or your launch plan. Confirm the expected replenishment time and choose a buffer that fits your budget and tolerance for stockouts.
Update the calculation as actual sales and delivery records become available.
4. Does reaching the reorder point guarantee I will avoid stockouts?
No. Unexpected demand, inaccurate inventory records, and supplier delays can still cause shortages.
The calculation gives you a purchasing threshold based on your assumptions. Review actual outcomes to see whether those assumptions remain reasonable.
5. Should every product have the same safety stock?
Choose buffers according to each product’s demand variability, supplier reliability, storage requirements, and stockout consequences.
A predictable item with dependable replenishment may justify a smaller buffer than a fast-selling item with inconsistent delivery times.
Conclusion
Start with one product that sells regularly. Calculate its daily demand, measure actual replenishment time, and choose a safety stock buffer you can justify.
Use the resulting threshold alongside incoming-order dates and customer commitments. After several replenishments, check how much inventory remained when deliveries arrived. Those records will help you refine the calculation and make purchasing decisions with clearer information.


