How to Forecast Ecommerce Inventory Without Stockouts or Overbuying

• Forecast ecommerce inventory at SKU, channel and location level, then turn demand into reorder dates using lead time, MOQ, open purchase orders and safety stock.
• Stockouts make sales history look weaker than real demand, so flag those periods before using averages or automated forecasting reports.
• A simple starting formula is average daily sales = units sold in the period divided by days in the period; reorder point = lead-time demand plus safety stock.
• Forecasting software is often an add-on: Cin7 ForesightAI, Linnworks Forecasting and Katana Planning and Forecasting are separate from base plans.
• Compare total cost before choosing a tool, including users, order-volume limits, inventory volume, locations, integrations, implementation and support.

Inventory forecasting is a cash problem before it is a maths problem. Too little stock means missed sales and annoyed customers; too much stock means money trapped in slow-moving units, storage and markdowns.

Most stockouts and overbuys do not come from one bad formula. They come from messy sales history, disconnected Shopify or Amazon channels, wrong supplier lead times, unmarked promotions, and forecasts that treat stockout weeks as weak demand.

The job is to turn demand signals into buying decisions. For Shopify, WooCommerce, BigCommerce, Amazon and multichannel sellers, that means forecasting by SKU, channel and location, then checking the forecast against what actually happens every week.

What does it mean to forecast ecommerce inventory?

To forecast ecommerce inventory is to estimate future SKU-level demand so the business can decide what to buy, when to buy it, and how much to hold by channel or location. The forecast predicts likely demand; replenishment turns that prediction into purchase orders.

That split matters. A forecast might say a SKU will sell 900 units over the next 90 days, but replenishment also needs supplier lead time, MOQ, case packs, stock on hand, open purchase orders, returns and safety stock.

Granularity matters once sales spread across channels. A SKU that sells steadily on Shopify may behave differently on Amazon, wholesale or a second warehouse, so a single blended number can hide the next stockout.

How do you build a forecasting loop that operators can trust?

Start with clean historical sales by SKU, channel and location. Use units sold, not revenue, because price changes, bundles and discounts can make revenue look stronger or weaker than actual demand.

Then mark the periods that should not be treated as normal demand. Stockouts, launch weeks, influencer spikes, clearance discounts, one-off wholesale orders and fulfilment problems all distort the baseline.

Add supplier reality next. Lead times, MOQs, case packs, production slots, receiving delays and supplier reliability decide whether a forecast can become a usable buying plan.

Business context comes after the raw numbers. Seasonality, planned promotions, new product launches, price changes, returns and channel expansion should be written into the forecast before purchase orders are raised.

The last step is weekly variance review. Compare forecast demand against actual sales, update the assumptions, and look first at SKUs projected to stock out before the next receipt.

Which formulas should you use first?

Use simple formulas before buying complex software. They expose the inputs that matter, and they make it easier to audit whatever a platform recommends later.

Average daily sales is the easiest starting point: units sold in a period divided by the number of days in that period. A 30-day window reacts quickly, a 90-day window smooths noise, and a 60-day window often sits between the two.

Lead-time demand is average daily sales multiplied by supplier lead time in days. If a SKU sells 10 units a day and the supplier lead time is 45 days, expected demand during lead time is 450 units.

Safety stock is the buffer for demand spikes, supplier delays and forecast error. It can be set in units or days of cover, but it should be higher for unreliable suppliers or SKUs that are painful to stock out.

Reorder point is lead-time demand plus safety stock. If lead-time demand is 450 units and safety stock is 150 units, the reorder point is 600 units.

Days of stock is current available stock divided by average daily sales. Sell-through and inventory turnover then help separate winners from slow movers, but they still need context from seasonality and promotions.

Why do stockouts break demand forecasts?

A stockout can make a good SKU look like a weak seller. If the product had zero available units for 14 days, the sales history records zero sales, even though real customer demand may still have existed.

Flag stockout windows before calculating averages. Use the pre-stockout run rate, back-in-stock sign-ups, waitlist demand, paid search demand or comparable SKU performance where those signals are available.

Do not blindly reduce reorder quantities after a stockout period. The history may understate demand, and the next purchase order can bake the same problem into another cycle.

How does overbuying happen even when sales are growing?

Overbuying usually starts with a short spike treated as a new baseline. A discount, creator post or marketplace push can lift sales for a week, but buying six months of stock from that run rate can leave cash stuck on shelves.

Promo demand should be separated from baseline demand. If a SKU sells 300 units in a discount week and 80 units in a normal week, the next buy should reflect both the planned promo calendar and the normal run rate.

MOQs and case packs can create overstock even when the forecast is sensible. If expected demand is 70 units but the supplier requires 200, the buying decision needs a margin, cash and storage check.

Segment inventory before setting rules. Fast movers, steady sellers, seasonal SKUs, launch items and dead stock need different safety stock, review cycles and markdown decisions.

Every overbought unit has an opportunity cost. That cash cannot fund ads, product development or a faster-moving SKU until the stock sells or gets cleared.

Do you need a spreadsheet, an inventory platform or dedicated forecasting software?

A spreadsheet is fine if the catalogue is small, channels are few, lead times are stable and one person updates it every week. The limitation is discipline: spreadsheets go stale quickly when orders, returns and stock receipts live elsewhere.

Platform-native forecasting fits teams already running inventory, purchasing, warehouse or order management in one system. The upside is that forecasting sits closer to stock control, but the catch is that it may be a paid add-on or tied to a higher plan.

Dedicated forecasting software fits larger SKU counts, multi-location planning, buying budgets and teams that need deeper demand planning than basic reorder points. The downside is another system to integrate, check and pay for.

Tool choice should follow operational complexity. SKU count, order volume, channel mix, lead-time variability, purchasing workflow and warehouse setup matter more than a feature list.

How much does ecommerce inventory forecasting software cost?

Forecasting cost is rarely just the base subscription. Model the full monthly cost, including add-ons, order-volume caps, inventory volume, locations, integrations, implementation, users and support.

For comparison, our recorded entry prices are Cin7 at $349/mo, Inventory Planner at $119/mo, Linnworks at $200/mo, Katana at $299/mo and Brightpearl at $1000/mo. Treat those figures as comparison anchors, not proof that every buyer pays the same final bill.

Cin7 lists Core Standard at $349/mo, Pro at $599/mo and Advanced at $999/mo, with Omni on contact-for-pricing. Standard includes 5 users, 2 ecommerce or app integrations, 6,000 sale orders per year and unlimited inventory locations.

Cin7 Pro raises that to 10 users, 4 integrations, 24,000 sale orders per year and Material Requirements Planning. Advanced includes 15 users, 6 integrations, 120,000 sale orders per year and advanced warehouse management.

Cin7 ForesightAI Forecasting is shown as an add-on across Standard, Pro, Advanced and Omni. It requires at least 6 months of sales history in Cin7 Core, calculates new data once daily, and inventory changes may take up to 24 hours to appear.

Inventory Planner says pricing is based on the volume of inventory managed, with unlimited users included at no extra cost. Its pricing page lists multi-location planning, plug-and-play integrations, automated replenishment, inventory-powered marketing and buying-budget planning by month or retail weeks.

Linnworks says plans are priced by monthly order volume rather than revenue, with no percentage fees. Overages apply if the monthly order number is exceeded, add-ons cost extra, and Linnworks Forecasting is a flat-fee add-on to Linnworks Advanced.

Katana lists Core from $299/mo, and Planning and Forecasting at $249/mo. Core includes one inventory location, while usage-based pricing can change with delivered sales orders, additional locations and add-ons.

Brightpearl sells through tailored pricing rather than a public self-serve checkout. Unlimited users are included at no extra cost, but the buying process includes a tailored demo, cost breakdown, Technical Solution Proposal and implementation.

Which forecasting tool fits which type of ecommerce operation?

Cin7 fits teams that want inventory, order management and forecasting close together. The trade-off is that ForesightAI is a paid add-on, and it needs sales history inside Cin7 Core before it can help.

Cin7 ForesightAI reports include Overstock Report, Stockout Report, Sales Forecast, and Winners and Losers Report. The Sales Forecast report forecasts up to 12 months from previous sales history, but daily refresh timing means it is not a real-time control room.

Inventory Planner fits teams that want dedicated demand planning, buying budgets, automated replenishment and multi-location planning. The limitation is cost modelling, because pricing depends on the volume of inventory managed rather than a simple public tier table.

Inventory Planner also says Sage AI powers Sage Copilot to help demand planners spot stock issues, review replenishment priorities and make better purchasing decisions. That can support the workflow, but it still depends on clean stock, sales and supplier data.

Linnworks fits higher-volume marketplace or multichannel sellers that need order, warehouse, channel and fulfilment operations alongside forecasting add-ons. The catch is order-volume pricing and overages, so growth can change the bill.

Katana fits product businesses with manufacturing, BOMs, production planning, materials and finished-goods planning needs. Its Planning and Forecasting add-on generates replenishment suggestions using current stock, projected demand, lead time and MOQ, but it adds $249/mo to the stack.

Brightpearl fits mid-market retail operations that want ERP-like order, inventory, purchasing, fulfilment, warehousing and planning workflows with implementation support. It suits teams that value expert-led rollout, but it is a heavier buying process than self-serve software.

What should your weekly forecasting workflow look like?

Run the process weekly, even if the forecast horizon is monthly or quarterly. Update actual sales, available inventory, incoming purchase orders, supplier changes and stockout annotations before reviewing recommendations.

Review exceptions first. Look at SKUs projected to stock out before the next receipt, SKUs with excess cover, and SKUs where demand has spiked or dropped faster than expected.

Turn the forecast into actions. That might mean expediting a purchase order, reordering, reducing a buy, transferring stock, bundling slow movers, pausing ads or running clearance campaigns.

Then review variance. Compare forecast against actual sales by SKU and category, and adjust lead time, seasonality, safety stock or campaign uplift assumptions before the next buying cycle.

What should you check before buying forecasting software?

Ask whether the tool can forecast by SKU, channel and location. If it cannot, it may still help a single-store operation, but it will struggle with multichannel allocation and warehouse-specific stock decisions.

Check whether it can handle stockout-adjusted demand. If the system treats zero-stock periods as weak sales, it can recommend lower buys for products that customers wanted but could not purchase.

Confirm how it uses lead time, MOQ, supplier constraints, open purchase orders and safety stock. Replenishment advice is only useful if it reflects the way suppliers actually sell to you.

Price the add-ons before committing. Forecasting may be included in some planning tools, but Cin7 ForesightAI, Linnworks Forecasting and Katana Planning and Forecasting are identified as add-ons.

Check what happens when orders, SKUs, users, locations or integrations increase. Cin7 has sale-order limits by tier, Linnworks prices by order volume, and Katana has usage-based pricing elements.

Finally, make sure the team can export data and audit the forecast logic. A forecast nobody can explain is hard to challenge when it recommends a large purchase order.

Frequently asked questions

Can I forecast ecommerce inventory in a spreadsheet?

Yes, if the catalogue is small, sales channels are limited and lead times are stable. A spreadsheet becomes risky when SKU count, locations, returns, open purchase orders and stockout adjustments are too much to update every week.

How much sales history do I need for inventory forecasting?

For simple averages, 30, 60 or 90 days can work depending on how quickly demand changes. Cin7 ForesightAI specifically requires at least 6 months of sales history in Cin7 Core, so check each tool's data requirements before buying.

Is Cin7 forecasting included in the $349/mo Standard plan?

Cin7 lists Core Standard at $349/mo, but its pricing table shows ForesightAI Forecasting as an add-on across Standard, Pro, Advanced and Omni. Budget for the add-on if forecasting is the reason you are choosing Cin7.

Should I choose Inventory Planner or an inventory platform like Cin7?

Inventory Planner fits dedicated demand planning, buying budgets, automated replenishment and multi-location planning. Cin7 fits teams that want forecasting near inventory, order management and warehouse workflows, but ForesightAI is a paid add-on.

How do I avoid overbuying after a promotion?

Separate promotional demand from baseline demand before calculating reorder quantities. Use the promotion's actual lift for future planned campaigns, but do not treat a discount week or influencer spike as the new normal run rate.

Which tools should manufacturing-led ecommerce brands consider?

Katana is the better fit if forecasting needs to connect with manufacturing, BOMs, production planning, materials and finished goods. Its Planning and Forecasting add-on is listed at $249/mo, so include that in the total cost.