"Best seller went out of stock for 2 weeks. Killed my Amazon ranking. Two months later, still only at 60% of previous velocity."
— Source: r/ecommerce (234 upvotes)
Stockouts seem like a simple problem—just order more inventory. But the damage extends far beyond lost sales:
- Amazon/search rankings drop (momentum matters)
- Customers find alternatives (and don't come back)
- Ad spend wasted on products you can't sell
- Cash flow whiplash when you finally restock
This guide covers the data-driven approach to preventing stockouts: demand forecasting, safety stock calculations, and early warning systems.
The True Cost of Stockouts
| Cost Category | Impact | Recovery Time |
|---|---|---|
| Lost sales (direct) | 100% of potential revenue | Immediate |
| Amazon ranking drop | 20-50% velocity loss | 2-4 weeks post-restock |
| Customer defection | 10-30% won't return | Permanent |
| Ad waste | Full spend, zero conversion | Immediate |
| Rush shipping (restock) | 2-3x normal shipping cost | One-time |
| Competitor gain | They capture your customers | Long-term |
A 2-week stockout on a product selling 10 units/day at $50 = $7,000 lost revenue + ranking recovery costs + customer acquisition to replace lost buyers.
Demand Forecasting Basics
Simplest approach: Average daily/weekly sales over past 60-90 days.
When it works: Stable products without seasonality.
When it fails: Seasonal products, growing/declining products, products with promotions.
- Compare same period last year
- Apply seasonal multipliers (e.g., December = 1.8x average)
- Account for holidays and events in your category
- Factor in planned promotions (2-5x normal velocity)
- Account for advertising increases
- Consider competitor promotions that might reduce your sales
Safety Stock Calculation
Safety stock protects against demand spikes and supply delays.
Basic formula: Safety Stock = (Max daily sales × Max lead time) - (Avg daily sales × Avg lead time)
Example:
- Max daily sales: 15 units
- Max lead time: 21 days
- Avg daily sales: 10 units
- Avg lead time: 14 days
- Safety Stock = (15 × 21) - (10 × 14) = 315 - 140 = 175 units
- Conservative (99% service level): Safety stock × 1.5
- Moderate (95% service level): Standard formula
- Aggressive (90% service level): Safety stock × 0.7
Higher service levels = more capital tied in inventory but fewer stockouts.
Reorder Point Formula
Reorder Point = (Average daily sales × Lead time) + Safety Stock
Example:
- Average daily sales: 10 units
- Lead time: 14 days
- Safety stock: 175 units
- Reorder point = (10 × 14) + 175 = 315 units
When inventory hits 315 units, place a new order.
- Calculate separately for each warehouse/fulfillment center
- Account for transfer times between locations
- Consider FBA restock limits when calculating Amazon inventory
Early Warning Systems
Automated alerts catch problems before they become stockouts:
| Alert Level | Trigger | Action |
|---|---|---|
| Green | >30 days inventory | No action |
| Yellow | 14-30 days inventory | Review reorder |
| Orange | 7-14 days inventory | Place order immediately |
| Red | <7 days inventory | Emergency restock/expedite |
- Days of inventory remaining (most important)
- Sales velocity changes (sudden spike = adjust forecast)
- Lead time changes (supplier delays)
- FBA restock limits (Amazon-specific)
- Seasonal factors approaching
Catch inventory problems before they cost you.
Niblin's AI agent analyzes your sales velocity and inventory levels, alerting you when products approach stockout risk. Morning Briefing flags issues overnight. $299/mo to start.
Start Free Trial — 15 Minute Setup
Key Takeaways
- Stockouts cost more than lost sales—rankings, customer loyalty, and ad efficiency all suffer
- Calculate safety stock based on demand variance and lead time variance
- Set reorder points at (daily sales × lead time) + safety stock
- Use tiered alerts: yellow (14-30 days), orange (7-14), red (<7)
- Account for seasonality and promotions in forecasts
- Recovery from stockouts can take weeks—prevention is cheaper