Ecommerce Inventory Planning: Complete 2026 Guide + Formulas

TL;DR

Ecommerce inventory planning is the process of deciding what to buy, how much to order, and when to place that order so you never run out of stock or drown in excess. It is not the same as inventory management, which tracks what you already have. Good planning uses demand forecasts, reorder point formulas, safety stock calculations, and cash flow targets to keep your business profitable. Bad planning costs the global retail industry $1.73 trillion a year.

Running an ecommerce brand means making constant bets on the future. Every purchase order is a prediction: this many units, arriving by this date, selling at this rate. Get the prediction right and you compound growth. Get it wrong and you bleed cash through storage fees, lost rankings, or empty shelves while customers buy from competitors.

Ecommerce inventory planning is the discipline that turns those bets from gut feelings into calculated decisions. This guide breaks down exactly what it means, how it differs from inventory management, the formulas that drive it, and the mistakes that make it expensive.

If your brand sells on Amazon, Shopify, or both, an ecommerce brand audit can reveal planning gaps you may not realize exist.

What Is Ecommerce Inventory Planning?

Ecommerce inventory planning is the forward-looking process of determining what products to buy, in what quantities, and on what timeline, based on demand forecasts, lead times, cash flow constraints, and channel-specific requirements.

It covers:

Demand forecasting (predicting how fast each SKU will sell)
Reorder decisions (when to place the next purchase order)
Safety stock sizing (how much buffer to hold against uncertainty)
Channel allocation (splitting inventory between FBA, 3PLs, and D2C warehouses)
Seasonal pre-buys (committing to volume ahead of predictable demand spikes)
Open-to-buy budgeting (capping purchases based on projected revenue and cash flow)

Planning answers the question: What should we buy next, and how much?

It does not answer: Where is the stuff we already have? That is inventory management’s job.

Inventory Planning vs. Inventory Management

Most content on this topic blurs these two concepts together. They are different problems solved by different systems.

	Inventory Planning	Inventory Management
Focus	Future decisions	Current operations
Core question	What, when, and how much to buy?	Where is my stock and how do I fulfill orders?
Key inputs	Demand forecasts, lead times, cash targets, seasonality	Stock counts, warehouse locations, order statuses
Key outputs	Purchase orders, restock schedules, budget allocations	Pick/pack/ship instructions, channel sync, stock updates
Time horizon	30 to 120+ days out	Real-time to near-term
Tools	Demand planning software, spreadsheets, open-to-buy models	WMS, OMS, channel integration platforms

Here is why the confusion matters: brands that invest heavily in management systems (tracking, syncing, fulfilling) but skip the planning layer end up with perfectly organized warehouses full of the wrong products. They can tell you exactly how many units of a slow-moving SKU sit on shelf B3, row 7. They just can’t tell you why they ordered 2,000 of them.

Planning is the brain. Management is the body. You need both, but the brain has to come first. For a deeper look at the execution side, our guide on setting restock levels walks through the operational steps.

Why Ecommerce Inventory Planning Matters

The Cost of Getting It Wrong

Inventory distortion (the combined cost of stockouts and overstocks) drains $1.73 trillion annually from global retail, according to IHL Group research. That figure represents 6.5% of total retail sales, roughly equivalent to South Korea’s entire GDP.

The number is abstract until you zoom in on what it looks like for a single brand.

Stockout costs:

69% of online shoppers abandon the purchase entirely when an item is out of stock
On Amazon, a one-week stockout on a mid-volume product often exceeds $10,000 in total losses when you account for lost sales, ranking drops (requiring 2 to 4 weeks of recovery), wasted PPC spend on ads pointing to unavailable listings, Buy Box loss, and competitor gains
Brands that lose page-one ranking during a stockout routinely spend $15,000 to $30,000 in PPC over the following quarter just to rebuild position

Overstock costs:

Amazon FBA standard-size storage runs $0.87 per cubic foot from January through September and $2.40 per cubic foot during peak season
Long-term storage fees kick in after 365 days at $6.90 per cubic foot, making aged inventory extraordinarily expensive
Misjudged inventory decisions account for an estimated 53% of unplanned markdown costs according to Coresight Research

If aged inventory is already eating into your margins, this guide on managing aged inventory and reducing storage fees explains a practical protocol for dealing with it.

The Ads-Inventory Feedback Loop

This is one of the most underappreciated aspects of ecommerce inventory planning: your advertising and your inventory are connected. When a brand ramps up Amazon PPC spend or launches an aggressive Meta campaign, demand spikes. If inventory wasn’t planned for that spike, one of two things happens.

Either you stock out (losing rank, wasting the ad spend that drove those sales, and handing momentum to competitors) or you panic-order via air freight (destroying margins to keep up with demand you created but didn’t prepare for).

Marketing teams should never operate independently from inventory visibility. The brands that scale profitably treat inventory and paid media as two sides of the same engine. Every decision to increase ad budgets should trigger a corresponding inventory check: do we have enough stock to absorb the projected demand lift for the next 60 to 90 days?

For more on connecting ad strategy with profitability, see our guide on mapping ad spend to contribution margin.

Amazon Has Made Bad Planning More Expensive

Amazon introduced a low-inventory-level fee in 2024 that applies when both your 30-day and 90-day historical days of supply fall below 28 days for eligible FBA products. Combined with IPI-score-driven restock limits and aged inventory surcharges, the platform now financially penalizes planning errors in both directions: too little stock and too much.

This is not just about avoiding lost sales anymore. It is about avoiding direct fees that Amazon charges when your planning falls outside their acceptable window.

Core Metrics and Formulas

Good ecommerce inventory planning runs on a handful of metrics. These are not optional. Skip them and you are planning on hope.

Days of Supply (DoS)

Formula: Units in stock ÷ Average daily sales = Days of supply

Example: 200 units in FBA ÷ 10 units sold per day = 20 days of supply

Days of supply tells you how long your current inventory will last at the present sell rate. For most FBA sellers, the recommended range is 60 to 120 days depending on lead times and demand stability. Drop below 28 days and you risk Amazon’s low-inventory-level fee.

Sell-Through Rate

Formula: Units sold in the last 90 days ÷ Average units in stock over that period

Amazon uses sell-through rate to calculate your IPI score and determine storage limits. A healthy sell-through rate for most ecommerce categories is 80% within 90 days. Anything below 50% in 90 days is a warning sign. Below 2.0 on Amazon’s scale is a red flag that triggers capacity restrictions.

Reorder Point

Formula: Daily sales × Lead time (in days) × Safety factor (1.3 to 2.0) = Restock threshold

Example: 10 units/day × 40 days lead time × 1.5 safety factor = 600 units

When your stock hits 600 units, it is time to place the next order. The safety factor accounts for demand variability and supplier reliability. Use 1.3 for stable products with reliable suppliers. Push toward 2.0 for seasonal items, new products, or suppliers with inconsistent timelines.

Safety Stock

Safety stock is your buffer against uncertainty. Size it by analyzing three variables: demand variability (how much your daily sales fluctuate), supplier reliability (how often deliveries arrive late), and lead time risk (how unpredictable your total replenishment cycle is).

Link buffers to service-level targets. If you want 95% product availability, your safety stock needs to be larger than if you are comfortable with 85%. Critical, high-margin SKUs deserve larger reserves. Slow movers can run leaner.

Lead Time

Lead time is the total number of days between placing an order with your supplier and having that inventory available for sale. It includes production time, shipping time, customs clearance, and warehouse receiving.

Example: 10 days manufacturing + 25 days ocean freight + 5 days Amazon check-in = 40 days lead time

Underestimating lead time is one of the most common planning errors. Practitioners on Reddit frequently mention supplier delays as a recurring source of stockouts, particularly for brands sourcing from overseas.

Cash Conversion Cycle (CCC)

The cash conversion cycle calculates exactly how many days pass between the moment you pay your supplier and the moment your customer’s payment hits your account. If your cycle drops from 60 days to 30 days, you have effectively doubled your available cash flow without selling a single extra item.

This metric belongs in every inventory planning conversation because it reframes inventory as a cash flow problem, not just a logistics problem. The goal is not simply fast-moving inventory. It is profitable inventory velocity.

Inventory Turnover

Formula: Cost of goods sold ÷ Average inventory value

Higher turnover generally means healthier planning, but “good” varies by category. Fashion brands might target 6 to 8 turns per year. Consumables often hit 10 to 12. Hardware or specialty goods might be healthy at 3 to 4.

Amazon Business recommends tracking five core KPIs together: fill rate, stockout rate, inventory turnover, days on hand, and landed cost variance. No single metric tells the whole story.

For a broader look at the profit metrics that should inform planning decisions, see how to lower TACOS on Amazon.

How Ecommerce Inventory Planning Works in Practice

Amazon FBA Planning

Amazon sellers face a unique planning environment because the platform actively manages (and restricts) your storage.

IPI Score: Amazon’s Inventory Performance Index grades how well you manage FBA inventory. It factors in sell-through rate, excess inventory percentage, stranded inventory, and in-stock rate. Scores below 400 can trigger storage capacity limits. Scores above 550 generally earn more generous limits.

Target excess inventory rate: As a general guideline, aim for 10% or less. That means at most 10% of your inventory should be unsold and sitting in fulfillment centers beyond a reasonable sales window.

Restock limits: Amazon caps how much you can send in based on your IPI score, storage type, and sales velocity. Planning has to account for these caps, because you cannot always send inventory when you want to.

Aged inventory surcharges: Items sitting in FBA for over 181 days start incurring additional fees, with the steepest penalties hitting after 365 days. Any SKU that has not sold in 90 days should enter a formal review: discount by 20%, hold for 30 days, and if it still is not moving, liquidate, bundle, or donate. Never let dead stock sit without a plan.

Brands selling on Amazon and need hands-on support with inventory, advertising, and catalog management can explore Amazon services built around these exact challenges.

Shopify and D2C Planning

D2C brands using Shopify or WooCommerce typically fulfill through a 3PL or self-managed warehouse. The planning challenges differ from FBA:

No platform-imposed storage limits, but 3PL contracts often include storage overages
Longer fulfillment windows mean safety stock calculations need to account for picking and shipping variability
Returns handling directly impacts available inventory counts
No IPI score to worry about, but cash tied up in slow inventory is equally costly

Multichannel Allocation

For brands selling across Amazon, Shopify, and potentially Walmart or other marketplaces, the hardest planning question is: how do you split inventory?

The answer starts with sell-through velocity by channel. If Amazon moves 70% of your volume with a 15-day sell-through, it gets the lion’s share of each replenishment cycle. If your D2C site sells more slowly but at higher margin, allocate enough to avoid stockouts but do not over-invest.

Practitioners on Reddit consistently flag multichannel sync as a top frustration. Selling an item on Amazon while Shopify still shows it as available (or vice versa) creates oversells, customer complaints, and operational chaos. Planning for multichannel means maintaining a unified view of inventory across all channels, not just planning within each silo.

Our unified DTC and marketplace playbook covers how to align strategy across channels.

Seasonal Planning

Seasonal inventory planning requires decisions made 90 or more days in advance. Brands that treat Q4 as a separate planning exercise starting in July consistently outperform those that react to demand in real time.

The process looks like this:

Pull year-over-year sales data for the seasonal period
Factor in planned promotions, ad spend increases, and marketplace events (Prime Day, Black Friday)
Add a seasonal safety factor (often 1.5x to 2x normal levels for proven products)
Place orders early enough to account for full lead time plus potential delays
Pre-position inventory across fulfillment centers before carrier and warehouse capacity constraints hit

For a step-by-step approach to peak season preparation, see how to plan inventory depth and restock schedules for peak sales.

Common Ecommerce Inventory Planning Mistakes

1. Planning on Gut Feel Instead of Data

The single most common regret shared by sellers on Reddit: “I ordered based on hope, not data.” Without demand forecasts grounded in historical sales, seasonality patterns, and trend analysis, purchase orders are just guesses with financial consequences.

For brands under $1M in revenue, spreadsheet-based planning is often sufficient. Once you pass the $500K to $3M range, purpose-built tools like Inventory Planner, SoStocked, or Forecastly become necessary to handle SKU-level complexity.

2. Ignoring Lead Time Variability

Your supplier’s quoted lead time is a best-case scenario. Ocean freight delays, customs holds, factory shutdowns, and Amazon receiving backlogs can add days or weeks. Build variability into your safety stock calculations rather than assuming every shipment arrives on schedule.

3. Not Factoring In Ad-Driven Demand

Launching a major PPC push or a viral social campaign without coordinating with inventory is a recipe for stockouts. Every ad budget increase should come with a corresponding inventory check. Related: our Amazon PPC glossary explains the key advertising terms that connect to inventory decisions.

4. Holding Dead Stock Without a Liquidation Protocol

Dead stock does not fix itself. Brands need a formal protocol: flag SKUs that have not sold in 90 days, apply a markdown, set a timeline, and commit to liquidation if the markdown fails. Holding and hoping is one of the most expensive decisions in ecommerce.

5. Treating All SKUs the Same

Not every product deserves the same planning attention. ABC analysis segments your catalog:

A items (top 20% of SKUs driving 80% of revenue): tight monitoring, higher safety stock, frequent reorder reviews
B items (next 30%): moderate attention, standard reorder cycles
C items (bottom 50%): lean stock, longer reorder cycles, candidates for discontinuation

6. Skipping Open-to-Buy Budgeting

Open-to-buy is a financial discipline that caps how much inventory you can purchase in a given period based on projected revenue, current stock levels, and cash flow targets. Without it, brands over-order in optimistic months and find themselves cash-strapped when they need to invest in growth.

Contribution Margin: The Missing Lens

Most inventory planning advice focuses on availability: keep products in stock, avoid fees, hit restock points. That is necessary but not sufficient.

Smart brands plan inventory around which SKUs are actually profitable. A product with a 60% margin and moderate velocity deserves more planning attention (and more capital) than a fast-moving product with a 10% margin that barely covers its ad spend and storage costs.

This is contribution-margin-based planning. It means looking at each SKU’s revenue minus COGS, fulfillment fees, storage costs, ad spend, and returns, then allocating your open-to-buy budget toward the products that actually generate profit.

If you have ever wondered why ROAS looks good but profit is negative, the answer often traces back to inventory decisions that prioritized volume over margin.

Frequently Asked Questions

What is ecommerce inventory planning?

Ecommerce inventory planning is the process of deciding what products to order, in what quantities, and on what schedule. It uses demand forecasts, lead time data, safety stock calculations, and cash flow constraints to make purchasing decisions. It is the decision-making layer that sits above inventory tracking and warehouse management.

How is inventory planning different from inventory management?

Inventory planning is forward-looking: it determines what to buy next. Inventory management is present-focused: it tracks where your stock is, syncs quantities across channels, and manages order fulfillment. Planning tells you what to order. Management tells you what you already have.

What is a good sell-through rate for ecommerce?

A healthy sell-through rate for most ecommerce categories is 80% within 90 days. Anything below 50% in a 90-day window signals a problem, either with demand forecasting, pricing, or product-market fit. On Amazon specifically, a sell-through rate below 2.0 can negatively impact your IPI score and storage limits.

How do you calculate a reorder point?

Multiply your average daily sales by your total lead time in days, then multiply by a safety factor between 1.3 and 2.0. For example, if you sell 10 units per day with a 40-day lead time and use a 1.5 safety factor, your reorder point is 600 units. When stock hits that number, place your next order.

How much safety stock should an ecommerce brand carry?

It depends on demand variability, supplier reliability, and your target service level. Brands targeting 95% product availability need larger buffers than those comfortable with 85%. Critical, high-margin SKUs warrant bigger reserves, while slow-moving items can run leaner. There is no universal number, only a calculation specific to each SKU.

What are the biggest inventory planning mistakes on Amazon?

The costliest mistakes include letting stock drop below 28 days of supply (triggering Amazon’s low-inventory-level fee), holding aged inventory past 365 days ($6.90/cubic foot penalties), ramping ad spend without confirming inventory depth, and failing to account for Amazon receiving delays in lead time calculations.

How far in advance should I plan for seasonal inventory?

At minimum 90 days. Brands that perform well during Q4 typically start their seasonal planning in July, placing purchase orders early enough to account for full production and shipping lead times plus potential delays. Waiting until demand is already spiking means you are too late.

Do I need inventory planning software?

For brands under $500K in annual revenue, well-structured spreadsheets often work. Between $500K and $3M, the complexity of SKU-level forecasting, multichannel allocation, and seasonal planning usually outgrows spreadsheets. At that point, tools like Inventory Planner, SoStocked, or similar platforms become necessary.

Ecommerce inventory planning is not glamorous. It does not get the attention that advertising strategy or product launches receive. But it determines whether those investments pay off or get wasted. Every dollar spent on ads that drives a sale you cannot fulfill is a dollar burned. Every dollar trapped in excess inventory is a dollar that cannot fund growth.

The brands that win treat planning as a financial discipline, not just a supply chain task.

If you want a clear picture of where your inventory planning stands today, request a free brand audit and get a detailed assessment with a 90-day action plan.