A stockout costs more than a missed sale. It costs the ad spend that drove the customer to an empty listing, the search ranking momentum lost during downtime, and the repeat buyer who found a competitor while waiting. On the other side, overordering ties up cash in boxes that sit in a warehouse, accumulating storage fees and collecting dust while payroll and ad budgets compete for the same dollars.
The reorder point formula exists to solve both problems at once. It tells founders the exact inventory level at which to trigger a new purchase order, so stock arrives before it runs out but not so early that cash gets trapped in excess product. The math itself is straightforward. The challenge for ecommerce founders is that most explanations of the reorder point were written for manufacturing and wholesale environments where lead times are predictable, demand is steady, and cash is rarely a constraint. Online selling breaks all three of those assumptions.
This guide covers the reorder point formula as it applies to ecommerce businesses specifically, with adjustments for variable demand, long supplier lead times, and the cash availability question that most inventory guides ignore entirely.
What the Reorder Point Formula Is (and What It Is Not)
The reorder point is the inventory level at which a business should place a new purchase order. When on-hand stock drops to this number, it signals that the remaining units will cover demand during the time it takes for the next shipment to arrive.
The standard reorder point formula:
Reorder Point = (Average Daily Sales x Lead Time in Days) + Safety Stock
Each variable does specific work:
- Average daily sales establishes the baseline velocity at which inventory depletes.
- Lead time accounts for the gap between placing a purchase order and receiving the goods.
- Safety stock provides a buffer against demand spikes or supplier delays.
What the reorder point does not do: it does not tell founders how much to order. That is the job of the economic order quantity (EOQ) formula, which optimizes order size based on holding costs and ordering costs. The reorder point answers "when," and EOQ answers "how much." Used together, they form the foundation of a repeatable restocking system.
Why Generic Reorder Point Calculations Fail in Ecommerce
Most reorder point tutorials treat the formula as if its inputs are stable numbers. In ecommerce, they are not. Three factors make the standard calculation unreliable without adjustment.
Demand Is Not Steady
A product that sells 10 units per day on average might sell 4 on Monday and 25 on Friday during a promotional push. Seasonality, advertising spend, marketplace algorithm changes, and competitor stockouts all create demand variability that a simple average obscures. Founders who set a reorder point using a flat daily average will either reorder too early (during slow periods) or too late (during spikes).
The fix is to calculate average daily sales over a window that matches the business cycle. For most ecommerce sellers, a rolling 30-day average works better than a 90-day average because it captures recent trends. During known seasonal periods (Q4 holiday, Prime Day, back-to-school), founders should use the prior year's same-period data as a secondary reference rather than relying on the trailing average alone.
Lead Times Are Long and Variable
A domestic supplier with a five-day lead time behaves like a textbook example. An overseas manufacturer with a 45-day production window, 30-day ocean freight, and 7-day customs clearance does not. Total lead time for many ecommerce products runs 60 to 120 days, and any step in the chain can add weeks without warning.
For products with long lead times, the reorder point shifts from a signal to act soon to a signal that should have been acted on weeks ago. Founders sourcing from overseas need to calculate lead time as the worst-case realistic scenario, not the best-case quoted timeframe. If a supplier quotes 45 days but has delivered in 45, 52, 60, and 48 days across the last four orders, the planning lead time should be closer to 55 or 60 days.
Cash Availability Is the Missing Variable
This is where ecommerce reorder points differ most from textbook inventory management. The formula might say to reorder 2,000 units when stock hits 500, but if the purchase order costs $18,000 and the business only has $12,000 in available cash flow, the formula's output is irrelevant.
Reorder point calculations in ecommerce need a cash filter. Before triggering a purchase order, founders should confirm that the order total fits within available working capital after accounting for other near-term obligations (payroll, ad spend, rent, software). A reorder point that ignores cash position is a recipe for either stockouts (because the founder cannot afford the PO) or cash crunches (because the founder funds the PO at the expense of operations).
How to Calculate Safety Stock for Ecommerce
Safety stock is the buffer that protects against the two biggest risks in inventory management: demand exceeding the forecast and lead time exceeding the plan. The standard safety stock formula is:
Safety Stock = (Maximum Daily Sales x Maximum Lead Time) - (Average Daily Sales x Average Lead Time)
For an ecommerce product that averages 15 units per day, peaks at 25 units per day, has an average lead time of 50 days, and a maximum lead time of 65 days:
- Maximum daily sales x maximum lead time = 25 x 65 = 1,625 units
- Average daily sales x average lead time = 15 x 50 = 750 units
- Safety stock = 1,625 - 750 = 875 units
That safety stock number feeds directly into the reorder point calculation. Using the same example:
- Reorder Point = (15 units/day x 50 days) + 875 = 1,625 units
When on-hand inventory drops to 1,625 units, the founder should place the next purchase order.
Adjusting Safety Stock Without Overcommitting Cash
An 875-unit safety buffer might feel excessive for a small ecommerce operation, and for good reason. That buffer has a dollar value. If each unit costs $9 from the supplier, safety stock alone represents $7,875 sitting in a warehouse. Founders running lean should consider a few adjustments:
- Tighten the demand ceiling. Instead of using the absolute maximum daily sales, use the 90th percentile. This reduces safety stock while still covering most demand scenarios.
- Negotiate shorter lead times. Even a five-day reduction in lead time can cut safety stock by hundreds of units. Paying a slight premium for faster shipping may cost less than the capital locked in extra inventory.
- Use days inventory outstanding as a check. If DIO is climbing while sales are flat, safety stock levels are probably too high.
Building a Reorder Point Worksheet
A reorder point formula is only useful if founders track and update the inputs regularly. Here is a practical framework for maintaining reorder points across a product catalog.
Step 1: Gather the Data Per SKU
For each product (or product variant), collect:
- Average daily sales over the last 30 days
- Maximum daily sales over the last 90 days (or 90th percentile)
- Average supplier lead time (in days, from PO to warehouse receipt)
- Maximum lead time experienced in the last 12 months
- Unit cost of goods (what the supplier charges per unit)
Step 2: Calculate Safety Stock and Reorder Point
Apply the formulas from the previous section for each SKU. Products with high demand variability or long lead times will have higher reorder points relative to their sales velocity.
Step 3: Add the Cash Check
For each SKU's reorder point, calculate the estimated PO cost:
Estimated PO Cost = EOQ (or standard order quantity) x Unit COGS + Shipping + Duties
Then compare that cost against projected available cash at the time the reorder point would be triggered. Founders who build a 13-week cash flow forecast can map expected PO timing against cash availability week by week.
If the PO cost exceeds available cash, founders have three options:
- Reduce the order quantity and accept a shorter coverage window
- Shift the reorder point earlier to split a large order into two smaller ones
- Adjust marketing spend downward during the lead time period to slow demand and stretch current inventory
Step 4: Review Monthly
Reorder points are not set-and-forget numbers. Demand patterns shift with seasonality, marketing activity, and competitive dynamics. Lead times change as suppliers adjust production schedules. A monthly review of reorder points, with a special review before peak seasons, keeps the numbers useful rather than decorative.
Reorder Points for Multi-Channel Sellers
Founders selling on Amazon, Shopify, and wholesale channels face an added layer of complexity: inventory allocation. A single reorder point per SKU assumes all stock sits in one pool. In practice, units might be split across an FBA warehouse, a 3PL for DTC orders, and a distributor's facility.
The simplest approach is to calculate the reorder point at the total inventory level (all channels combined) and then apply allocation rules when the purchase order arrives. For example, if the reorder point triggers a 1,500-unit order, the founder might allocate 800 units to FBA, 500 to the 3PL, and 200 to wholesale based on each channel's share of recent sales.
Founders who want channel-specific reorder points will need separate demand and lead time calculations for each location, which adds accuracy but also tracking overhead. For most ecommerce businesses under $5M in revenue, a single combined reorder point with channel-level allocation is the right trade-off between precision and practicality.
Common Reorder Point Mistakes
Even with the right formula, a few patterns trip up ecommerce founders repeatedly.
Using supplier-quoted lead times instead of actual lead times. Suppliers quote optimistic timelines. Track actual receipt dates and use those for calculations.
Ignoring holding costs in the safety stock decision. Safety stock is not free. Every unit on the shelf has a cost, including warehouse fees, insurance, and capital opportunity cost. The inventory turnover ratio is a useful check here. If turnover is declining while reorder points stay the same, the business is sitting on too much stock.
Setting reorder points once and forgetting them. A reorder point calculated during a product's Q4 peak will cause chronic overordering during a slow Q1. Seasonal adjustment is not optional.
Treating all SKUs equally. An 80/20 analysis of the product catalog will almost always reveal that a small number of SKUs drive most of the revenue. These high-velocity products deserve tighter, more frequently updated reorder points. Slow movers can use wider safety margins and less frequent reviews.
Running the formula without checking the bank account. This is the most expensive mistake. A reorder point might correctly signal that it is time to buy, but if the purchase order creates a cash shortfall that forces the founder to cut ad spend or delay payroll, the "optimal" inventory decision becomes a cash flow crisis.
From Formula to System
The reorder point formula is one calculation. A restocking system is the combination of reorder points, order quantities, cash flow forecasting, and supplier management that runs continuously without requiring the founder to hold every variable in their head.
Founders who track reorder points in a spreadsheet are doing better than those who restock by gut feel. Founders who connect their inventory data to their cash position are doing better still. The gap between "I know the formula" and "I never stock out or overbuy" is the gap between a one-time calculation and an ongoing system.
Futureproof connects ecommerce financial data, including cash flow, COGS, and working capital, into a single view so founders can make restocking decisions with full visibility into both inventory needs and cash availability. When reorder points and cash forecasts live in the same place, the guesswork disappears.
