How to Set Reorder Points for E-Commerce: The Formula That Prevents Stockouts

Your inventory reorder point is like the warning light on your gas gauge. It doesn't tell you to fill up when the tank is empty, that's too late. It tells you to fill up while you still have enough fuel to reach the next gas station.

For e-commerce sellers, that "next gas station" is your supplier's delivery. And running out of fuel means stockouts, lost sales, tanked search rankings on Amazon, and customers who find a competitor and never come back.

The fix sounds simple: figure out the right moment to reorder. But most sellers either guess, reorder too late, or order too much and tie up cash in slow-moving pallets. This guide gives you the exact formula, real worked examples, and the common mistakes that quietly drain your margins.

What Exactly Is a Reorder Point?

A reorder point (ROP) is the specific inventory level at which you need to place a new purchase order with your supplier. When your stock-on-hand drops to this number, it's time to reorder, no sooner, no later.

Get it right, and you maintain a smooth flow of product without excess inventory eating your warehouse budget. Get it wrong in either direction, and you're dealing with one of two expensive problems:

• Too low: You stock out. On Amazon, a single stockout can drop your Best Seller Rank by 30-50% and take weeks to recover. On your own store, that's a lost customer, 91% of whom won't come back after a bad experience (Emplifi, 2023).
• Too high: You overstock. You're paying for warehouse space, your cash is locked in product you can't sell fast enough, and if demand shifts, you're stuck with deadstock.

The reorder point sits at the sweet spot between these two extremes.

The Reorder Point Formula

Here's the core formula:

Reorder Point = (Average Daily Sales × Lead Time in Days) + Safety Stock

Or written more concisely:

ROP = (D × LT) + SS

That's it. Three variables. But each one requires careful calculation, and getting any of them wrong cascades into either stockouts or overstocking.

Let's break down each variable.

Variable 1: Average Daily Sales (D)

Your average daily sales rate is the foundation of the formula. This number tells you how fast inventory is moving out the door.

How to Calculate It

Pull your sales data for a defined period and divide total units sold by the number of days.

D = Total Units Sold ÷ Number of Days

For example, if you sold 1,800 units of a product in the last 30 days:

D = 1,800 ÷ 30 = 60 units/day

Which Time Window Should You Use?

This is where most sellers go wrong. The time window you choose matters enormously.

Time Window	Best For	Watch Out For
30 days	Fast-moving products, trending items, post-promotion analysis	Too reactive to short-term spikes
60 days	General-purpose products with moderate demand	May lag behind recent trend changes
90 days	Stable, evergreen products	Smooths over real demand shifts you need to catch
Same period last year	Seasonal products	Assumes this year mirrors last year exactly

The best approach: Use a weighted average that gives more importance to recent data. For most products, a 60-day window weighted 60/40 toward the most recent 30 days gives you both stability and responsiveness.

For example, if your product sold 50 units/day over the past 60 days overall, but 58 units/day in the last 30 days:

Weighted D = (58 × 0.6) + (50 × 0.4) = 34.8 + 20 = 54.8 ≈ 55 units/day

Account for Trends

A flat average can hide important signals. If sales have been climbing 10% month-over-month, a backward-looking average will undercount your actual demand at the time your next shipment arrives. Adjust upward for growth trends, and downward if you're seeing a deceleration.

Variable 2: Lead Time in Days (LT)

Lead time isn't just "how long my supplier takes to make the product." It's the total number of days from the moment you place a purchase order to the moment those units are available for sale.

The Full Lead Time Breakdown

Stage	Description	Typical Range
Supplier production time	Time to manufacture or prepare your order	3-30 days (domestic) / 15-60 days (overseas)
Shipping/freight time	Transit from supplier to your warehouse or prep center	2-7 days (domestic ground) / 25-45 days (ocean freight)
Customs & clearance	For international shipments	2-10 days
Receiving & inspection	Unloading, counting, quality check	1-3 days
Prep & shelving	Getting units into sellable, pick-ready status	1-2 days

Total Lead Time = Production + Shipping + Customs + Receiving + Prep

A domestic supplier might give you a 10-day total lead time. An overseas manufacturer shipping by sea could easily be 60-90 days.

Use Realistic Lead Times, Not Optimistic Ones

Your supplier says "15 business days." But in your last four orders, actual delivery took 15, 18, 22, and 17 days. Using 15 days in your formula means you'll stock out roughly half the time.

Use your actual average lead time from recent orders. Better yet, track it per supplier and update it quarterly. If you're just getting started with a new supplier, add a 20-30% buffer until you have reliable data.

Variable 3: Safety Stock (SS)

Safety stock is your buffer, the extra inventory you keep on hand to protect against two types of uncertainty:

• Demand variability: Sales could spike unexpectedly (a product goes viral, a competitor stocks out, a promotion over-performs).
• Supply variability: Your supplier could ship late, a shipment could be held in customs, or a quality issue could make part of a batch unsellable.

The Basic Safety Stock Formula

Safety Stock = (Maximum Daily Sales × Maximum Lead Time) − (Average Daily Sales × Average Lead Time)

This gives you a buffer sized to your worst-case scenario minus your normal scenario.

For example, if your max daily sales are 75 units, max lead time is 20 days, average daily sales are 60 units, and average lead time is 15 days:

SS = (75 × 20) − (60 × 15) = 1,500 − 900 = 600 units

That means you keep 600 extra units as a cushion.

A Quick Note on Service Level

Some businesses set safety stock based on a desired service level, the percentage of time you want to be in stock. A 95% service level means you accept stockouts roughly 5% of the time. Higher service levels require more safety stock and more cash tied up in inventory. For most e-commerce sellers, 95% is a solid target for top sellers and 90% is acceptable for long-tail items.

Putting It All Together: 3 Worked Examples

Let's walk through the full reorder point calculation for three different product types.

Example 1: Fast-Moving Consumer Product

Product: Bestselling phone case

Sales: 100 units/day average

Max daily sales: 130 units/day

Average lead time: 14 days (domestic supplier)

Max lead time: 18 days

Step 1, Safety Stock:

SS = (130 × 18) − (100 × 14)

SS = 2,340 − 1,400

SS = 940 units

Step 2, Reorder Point:

ROP = (100 × 14) + 940

ROP = 1,400 + 940

ROP = 2,340 units

What this means: When your warehouse stock hits 2,340 units of this phone case, place your next purchase order. You have enough inventory to cover 14 days of normal sales plus a buffer for demand spikes or a delayed shipment.

Example 2: Seasonal Product

Product: Insulated water bottle (peaks in summer)

Off-season sales: 20 units/day

Peak-season sales: 80 units/day average, 110 units/day max

Average lead time: 21 days (overseas supplier, air freight)

Max lead time: 28 days

This is where a single reorder point fails. You need to calculate separate ROPs for each season.

Peak Season ROP:

SS = (110 × 28) − (80 × 21) = 3,080 − 1,680 = 1,400 units

ROP = (80 × 21) + 1,400

ROP = 3,080 units

Off-Season ROP:

SS = (30 × 28) − (20 × 21) = 840 − 420 = 420 units

ROP = (20 × 21) + 420

ROP = 840 units

What this means: If you use your off-season reorder point of 840 during peak season, you'll stock out catastrophically. You need to switch your reorder point at least 1 full lead time (21+ days) before peak season starts. Mark that transition date on your calendar.

Example 3: Slow-Moving Long-Tail Product

Product: Specialty leather journal

Sales: 3 units/day average

Max daily sales: 7 units/day

Average lead time: 45 days (overseas supplier, ocean freight)

Max lead time: 60 days

Step 1, Safety Stock:

SS = (7 × 60) − (3 × 45)

SS = 420 − 135

SS = 285 units

Step 2, Reorder Point:

ROP = (3 × 45) + 285

ROP = 135 + 285

ROP = 420 units

What this means: Even at 3 units/day, the long lead time means you need 420 units on hand before reordering. This is why long-tail products with overseas suppliers are deceptively expensive to manage, the slow sales rate lulls sellers into thinking they don't need much stock, but the long lead time demands a surprisingly large buffer.

5 Common Reorder Point Mistakes That Cost You Money

1. Using Average Lead Time Instead of Tracking Actual Variability

Your supplier quotes "2 weeks." But your actual order history shows deliveries ranging from 12 to 22 days. If you calculate your ROP using 14 days and your shipment takes 22 days, you just burned through 8 extra days of inventory you didn't account for.

Fix: Track every PO's actual lead time. Use the average for your base calculation and the maximum for your safety stock formula.

2. Not Updating Reorder Points as Sales Velocity Changes

A product selling 50 units/day in January might sell 80 units/day by March if it's trending. If your ROP is still based on January data, you're reordering too late every single time.

Fix: Recalculate reorder points monthly at minimum. For your top 20% of SKUs (which likely drive 80% of revenue), review weekly.

3. Setting the Same Reorder Point for All Channels

Your Shopify store, Amazon FBA, Walmart Marketplace, and wholesale accounts all have different lead times, different demand patterns, and different consequences for stocking out. A single reorder point across all channels is a recipe for overselling.

Amazon FBA, for instance, requires you to ship inventory to their fulfillment centers well in advance. Your FBA reorder point needs to account for Amazon's inbound shipping time, receiving delays (which can stretch to 2+ weeks during peak season), and their storage fee deadlines.

Fix: Calculate separate reorder points per channel, per warehouse, per fulfillment method. This is where multichannel inventory management software becomes essential, doing this manually in spreadsheets across thousands of SKUs is a full-time job.

4. Forgetting Supplier Minimum Order Quantities (MOQs)

Your formula says reorder 500 units. Your supplier's MOQ is 1,000. Now you're forced to order double what you need, tying up cash and warehouse space.

Fix: Factor MOQs into your reorder strategy from the start. If your ROP triggers an order for 500 units but the MOQ is 1,000, you may need to adjust your reorder point downward so you hit the trigger later, when you actually need closer to 1,000 units to cover the next cycle.

5. Not Accounting for In-Transit Inventory

You have 600 units in your warehouse and your ROP is 800. Time to reorder, right? Not if you already have 1,200 units on a container ship arriving in 5 days.

Fix: Your inventory position should include on-hand stock plus in-transit inventory minus any committed/allocated stock. The formula becomes:

Effective Inventory = On-Hand + In-Transit − Committed Orders

Only trigger a reorder when your effective inventory drops below the ROP.

Channel-Specific Reorder Points: Why Amazon FBA Is Different

Selling on multiple channels makes reorder points significantly more complicated. Here's why each channel needs its own calculation.

Factor	Your Own Warehouse	Amazon FBA	Wholesale/B2B
Lead time includes	Supplier → your warehouse	Supplier → your warehouse → Amazon FC (add 7-21 days)	Supplier → your warehouse → customer delivery window
Demand pattern	Based on your store traffic	Based on Amazon search volume and Buy Box share	Based on retailer PO schedules
Stockout cost	Lost sale + potential SEO impact	Lost sale + BSR drop + potential ad spend wasted	Chargebacks, strained retailer relationships
Storage cost pressure	Your warehouse rate	Amazon's aged inventory surcharges (escalating fees after 181+ days)	Minimal if drop-shipping

For Amazon sellers specifically, your FBA reorder point formula looks more like:

FBA ROP = (Average Daily FBA Sales × Total FBA Lead Time) + FBA Safety Stock

Where Total FBA Lead Time = supplier production + shipping to your warehouse + prep/labeling + shipping to Amazon FC + Amazon receiving time.

That last item, Amazon receiving time, can be wildly unpredictable. During Q4, Amazon's receiving delays can stretch past 2 weeks. Build that into your lead time calculation from September onward.

"Finally, a solution that actually prevents overselling during Black Friday.": James Chen, E-commerce Director, Urban Wear

The challenge of managing reorder points across multiple channels is exactly why tools that sync inventory across Shopify, Amazon, and other marketplaces in real time have become a necessity rather than a luxury. When a sale on Amazon should instantly reduce available stock on Shopify, manual processes can't keep up.

How Automated Inventory Platforms Handle Reorder Points

Calculating reorder points in a spreadsheet works when you have 20 SKUs. At 200 SKUs across 3 channels, it breaks down. At 2,000 SKUs, it's impossible.

Modern inventory platforms automate the process by:

• Pulling real-time sales data across all channels to calculate average daily sales with up-to-date accuracy.
• Tracking actual supplier lead times from every purchase order, not just the quoted lead time.
• Adjusting for seasonality using historical data patterns, automatically shifting reorder points up before peak periods and down after.
• Monitoring in-transit inventory so you don't accidentally double-order.
• Sending alerts when stock levels hit the reorder point, or even generating draft POs automatically.

Platforms like Nventory connect your sales channels and calculate reorder points dynamically based on actual performance data rather than static spreadsheet formulas. The system accounts for each channel's unique lead times, demand patterns, and fulfillment requirements, updating as conditions change rather than waiting for your monthly spreadsheet review.

The difference between a static spreadsheet ROP and a dynamic one is significant. A spreadsheet tells you to reorder at 500 units based on last quarter's data. A dynamic system tells you to reorder at 620 units because your sales velocity has increased 12% over the past three weeks and your supplier's last two shipments arrived 3 days late.

Reorder Points and Days of Supply: The Relationship

Days of supply (DOS) is a closely related metric that tells you how many days your current inventory will last at the current sales rate.

Days of Supply = Current Inventory ÷ Average Daily Sales

Your reorder point and days of supply are two ways of looking at the same question: "When do I run out?"

Here's the connection:

• If your ROP is 1,400 units and you sell 100 units/day, your reorder point represents 14 days of supply.
• If your lead time is 14 days, you're reordering with exactly enough supply to last until the next shipment (assuming no safety stock).
• Your safety stock adds extra days of supply as a buffer.

Days of supply is useful for quick prioritization. Sort your entire catalog by DOS, and the products with the fewest days of supply are the ones that need attention first. If you see a SKU at 5 days of supply and its lead time is 14 days, you're already too late.

Many sellers use DOS thresholds as a management dashboard:

Days of Supply	Status	Action
< Lead Time	Critical: will stock out	Expedite existing PO or place emergency order
= Lead Time + Safety Stock days	At reorder point	Place standard PO
1.5 - 2× Lead Time	Healthy	Monitor normally
> 3× Lead Time	Overstocked	Consider promotions, reduce next order

A Brief Note on Economic Order Quantity (EOQ)

Your reorder point tells you when to order. Economic Order Quantity tells you how much to order.

The EOQ formula balances two competing costs:

• Ordering costs: Processing a PO, shipping, receiving, inspection. Fewer, larger orders reduce per-unit ordering costs.
• Holding costs: Warehouse rent, insurance, depreciation, tied-up capital. Smaller, more frequent orders reduce holding costs.

EOQ = √(2DS ÷ H)

Where D = annual demand, S = cost per order, and H = holding cost per unit per year.

ROP and EOQ work together. The ROP triggers the order. The EOQ determines the order size. Together, they form the backbone of an efficient replenishment system.

In practice, your actual order quantity will often differ from the theoretical EOQ due to supplier MOQs, container capacity constraints, volume discounts, or cash flow limitations. But EOQ gives you a useful baseline for evaluating whether your order sizes are roughly optimal.

When to Review and Update Your Reorder Points

A reorder point is not a set-it-and-forget-it number. Markets shift, suppliers change, and your sales velocity evolves. Here's a practical review schedule:

Monthly Reviews (All SKUs)

• Recalculate average daily sales using the most recent data.
• Update lead times based on recent PO performance.
• Check if any new SKUs need reorder points set for the first time.
• Archive reorder points for discontinued products.

Weekly Reviews (Top 20% of SKUs by Revenue)

• Your bestsellers deserve more attention. A stockout on a top seller has an outsized revenue impact.
• Check for velocity changes that could indicate a trend shift.
• Monitor in-transit inventory against expected arrival dates.

Event-Driven Reviews

• Before peak season: Increase safety stock and adjust reorder points upward at least 1 full lead time before the anticipated demand increase.
• After a major promotion: Recalculate if the promotion changed your baseline demand.
• After a supplier change: Reset lead time data and add extra buffer until you have 3-4 orders of data with the new supplier.
• After expanding to a new channel: Set channel-specific reorder points from day one. Use conservative (higher) estimates until you have real data from that channel.

Having a platform that tracks inventory levels and reorder triggers across all your channels and warehouses takes these reviews from a multi-hour spreadsheet exercise to a quick dashboard check.

Your Reorder Point Action Plan

Here's how to implement everything in this guide, starting today:

• Export your sales data for the last 90 days, broken down by SKU and channel.
• Calculate average daily sales for each SKU using a weighted 60-day window.
• Document actual lead times from your last 3-5 purchase orders per supplier.
• Calculate safety stock using the max/average formula above.
• Apply the ROP formula to every active SKU.
• Set separate reorder points for each channel where lead times or demand differ.
• Build a review calendar, monthly for all SKUs, weekly for top sellers.
• Automate, once your catalog exceeds 50-100 SKUs across multiple channels, move from spreadsheets to an inventory management platform that updates dynamically.

The reorder point formula itself is straightforward. The challenge is keeping it accurate across hundreds or thousands of SKUs, multiple sales channels, and suppliers with varying reliability. Nail the formula, keep the inputs current, and you'll stop both stockouts and the cash drain of overstocking.

Your inventory is the engine of your e-commerce business. The reorder point is the gauge that keeps it running.