Ecommerce Inventory Forecasting Guide

The demand planning system that tells you exactly what to order, when to order it, and how much to keep on hand

What Is Ecommerce Inventory Forecasting?

Dead stock kills quietly.

Ecommerce inventory forecasting is the practice of using historical sales data, lead times, and seasonal patterns to predict future demand and determine optimal stock levels. According to IHL Group, global retailers lose $1.77 trillion annually to overstock and out-of-stock combined. Forecasting replaces gut feelings with math — and the math works.

Most store owners order inventory one of two ways: they buy what they bought last time, or they buy what feels right. Both approaches fail eventually. The first ignores growth trends. The second ignores everything.

We audit Shopify stores across Malaysia regularly, and inventory mismanagement is one of the top three cash flow killers we find. A store doing RM500K in annual revenue with 30% of that tied up in slow-moving stock is not a revenue problem. It is a forecasting problem.

The good news: forecasting does not require a data science degree. It requires three inputs — historical sales velocity, supplier lead time, and a safety stock buffer. Get those right, and you stop guessing.

ecommerce inventory forecasting overview

Why Does Poor Inventory Forecasting Cost So Much?

Two words: opportunity cost.

Poor ecommerce inventory forecasting costs retailers 4.1% of annual revenue in lost sales from stockouts alone, according to a 2023 Harvard Business Review supply chain study. Add overstock markdowns (averaging 31.5% margin erosion per Coresight Research), and the combined hit ranges from 8-12% of total revenue for typical DTC brands.

When you run out of a bestseller, you lose more than one sale. You lose the repeat purchase, the word-of-mouth referral, and the customer's trust. They bought from a competitor. They might not come back.

When you overstock, the damage is slower but equally painful. Cash sits on shelves instead of funding ads or product development. Then the markdowns start. Then the storage fees pile up.

Here is what the numbers look like for a typical Shopify store:

Inventory Problem	Average Revenue Impact	Hidden Costs
Stockouts	4.1% lost revenue (HBR, 2023)	Lost customers, damaged brand trust, ad spend wasted on out-of-stock products
Overstock / dead stock	3-5% margin erosion (Coresight Research)	Warehousing fees, markdowns, cash trapped in unsold units
Manual counting errors	1-3% inventory shrinkage (NRF, 2024)	Mis-shipments, customer complaints, returns
Missed reorder windows	Variable (2-8% per incident)	Expedited shipping costs, supplier rush fees, lost bundle opportunities

Sources: HBR, Coresight Research, National Retail Federation

A store doing RM1M/year that fixes just stockouts and overstock recaptures RM80,000-RM120,000 annually. That is not a marginal improvement. That is a new hire or an entire ad budget.

How Do You Calculate Demand Forecast for Your Store?

Start with what you already have.

The basic demand forecast formula multiplies your average daily sales velocity by the planning period: Forecast = Average Daily Units Sold x Days in Planning Period. For most Shopify stores, a 90-day rolling average adjusted for seasonality produces forecasts accurate within 15-20%, based on Shopify's own merchant data. That accuracy beats gut instinct by a factor of three.

You do not need machine learning for this. You need a spreadsheet and three months of order data.

Step 1: Calculate your average daily sales velocity

Pull your Shopify analytics for the last 90 days. For each SKU, divide total units sold by 90. That is your baseline velocity.

Example:

SKU: Vitamin C Serum 30ml
Units sold in 90 days: 270
Daily velocity: 3.0 units/day

Step 2: Adjust for seasonality

Look at the same period from last year. If Q4 sales were 40% higher than Q3, apply a 1.4x multiplier to your Q4 forecast.

Seasonality multiplier formula:

Seasonal Multiplier = (Same Period Last Year Sales) / (Annual Average for That Period Length)

Step 3: Factor in growth rate

If your store is growing 10% quarter-over-quarter, your forecast should reflect that. Multiply the seasonally adjusted velocity by your growth coefficient.

Growth-adjusted forecast:

Forecast = Daily Velocity x Planning Days x Seasonal Multiplier x (1 + Growth Rate)

Example with all factors:

Daily velocity: 3.0 units
Planning period: 90 days
Seasonal multiplier: 1.4 (Q4)
QoQ growth: 10%
Forecast: 3.0 x 90 x 1.4 x 1.1 = 416 units

Without the adjustments, you would have ordered 270 units and run out by mid-November. With the adjustments, you order 416 and cover the holiday spike.

demand forecasting formula example

What Is the Reorder Point Formula?

This is where forecasting meets execution.

The reorder point formula is: Reorder Point = (Average Daily Sales x Lead Time in Days) + Safety Stock. When your stock level hits this number, you place a new order. IHL Group data shows stores using reorder point automation reduce stockouts by 30-50%. Our reorder point calculator runs this math instantly for any SKU.

The reorder point tells you the exact inventory level at which you need to trigger a purchase order. Go below it, and you risk a stockout before your supplier delivers.

The formula

Reorder Point = (Daily Sales Velocity x Lead Time) + Safety Stock

Safety stock calculation

Safety stock is your buffer against variability — both in demand and supply. The standard formula:

Safety Stock = Z-score x Standard Deviation of Daily Demand x Square Root of Lead Time

For most ecommerce stores, a Z-score of 1.65 (95% service level) is the right balance between protection and capital efficiency.

Practical example:

Daily sales: 3.0 units
Standard deviation: 0.8 units
Lead time: 21 days (typical for Southeast Asian suppliers)
Z-score: 1.65

Safety Stock = 1.65 x 0.8 x sqrt(21) = 1.65 x 0.8 x 4.58 = 6 units

Reorder Point = (3.0 x 21) + 6 = 69 units

When your Vitamin C Serum hits 69 units in stock, you order. Not before (tying up cash), not after (risking a stockout).

Run this for every SKU using our reorder point calculator. It takes 30 seconds per product.

Does this sound like your store? Find out where you're leaking revenue — take the free Revenue Score. 3 minutes. Free. No pitch.

How Do You Handle Seasonal Demand Spikes?

Seasonality is not a surprise. It happens every year.

Seasonal demand spikes account for 25-40% of annual ecommerce revenue for most product categories, according to Shopify's 2025 Commerce Trends report. Stores that pre-position inventory 6-8 weeks before peak periods see 23% fewer stockouts than those that react in real time, per McKinsey's retail operations data.

The stores that struggle with seasonal spikes are the ones that treat them as unpredictable. They are not. Your data already tells you when they are coming.

Build a seasonal calendar

Map your last 12-24 months of sales data by week. You will see patterns:

Season / Event	Typical Spike	Pre-Order Window	Notes
Chinese New Year (Jan/Feb)	30-60% above baseline	8-10 weeks prior	Gift sets, premium packaging
Ramadan / Hari Raya (varies)	40-80% for food, fashion, beauty	6-8 weeks prior	Peak is final 2 weeks of Ramadan
Mid-Year Sales (6.6, 7.7)	50-100% above baseline	4-6 weeks prior	Marketplace-driven, plan bundles
Back to School (Aug/Sep)	20-40% for relevant categories	4-6 weeks prior	Often overlooked by DTC brands
11.11 / Black Friday (Nov)	100-300% above baseline	8-12 weeks prior	Longest lead time needed
12.12 / Christmas (Dec)	80-200% above baseline	6-8 weeks prior	Gift wrapping, holiday SKUs

Sources: Shopify Commerce Trends 2025, WebMedic client data (Malaysian Shopify stores)

The pre-positioning rule

Order your seasonal inventory based on this timeline:

12 weeks out: Confirm demand forecast using last year's data + growth rate
8 weeks out: Place purchase orders with suppliers
4 weeks out: Verify shipment tracking, prepare marketing assets
2 weeks out: Stock received, QC complete, listings updated
Week of: Focus on fulfillment speed, not scrambling for stock

Malaysian suppliers typically need 14-21 days. Chinese suppliers need 30-45 days including shipping. Factor this into your pre-order window or you will be placing emergency air freight orders at 5x the cost.

seasonal inventory planning calendar

Which Tools Automate Inventory Forecasting on Shopify?

Spreadsheets work until they do not.

Inventory forecasting tools for Shopify range from free spreadsheet templates to AI-powered platforms like Prediko (from $125/month) and Inventory Planner by Sage (from $249/month). According to a 2024 Gartner survey, companies using automated demand planning tools reduce forecast error by 20-30% compared to manual methods. For stores managing 50+ SKUs, automation pays for itself within the first quarter.

Once you pass about 50 active SKUs, manual forecasting in spreadsheets becomes error-prone and time-consuming. Here is what we recommend at different stages:

Store Stage	SKU Count	Recommended Tool	Monthly Cost	Best Feature
Startup ($0-$10K/mo)	1-30	Google Sheets + formulas	Free	Full control, learn the math
Growth ($10K-$50K/mo)	30-100	Inventory Planner by Sage	From $249/mo	Demand forecasting + replenishment recommendations
Scale ($50K-$200K/mo)	100-500	Prediko	From $125/mo	AI-driven forecasting, automated POs
Enterprise ($200K+/mo)	500+	Brightpearl by Sage	Custom pricing	Full ERP with warehouse + forecasting

Pricing as of March 2026

What to look for in a forecasting tool

Shopify-native integration — no CSV exports, no sync delays
Lead time awareness — the tool should factor in supplier delivery windows
Seasonality detection — automatic identification of cyclical patterns
Multi-location support — if you stock in Malaysia and Singapore, the tool should forecast per warehouse
Reorder alerts — notifications when stock hits the reorder point, not when it hits zero

The best Shopify apps for inventory automation post covers the app-level details. Here, the point is simpler: pick the tool that matches your SKU complexity and stop doing this manually.

What Is the ABC Analysis for Ecommerce Inventory?

Not every SKU deserves the same attention.

ABC analysis segments your inventory into three tiers based on revenue contribution: A items (top 10-20% of SKUs generating 70-80% of revenue), B items (30% of SKUs, 15-20% of revenue), and C items (50% of SKUs, 5-10% of revenue). This Pareto-based framework, validated by the Institute for Supply Management, lets you focus forecasting effort where it generates the most return.

Most stores forecast every product with the same effort. This is a mistake. Your top 20 products probably generate 80% of your revenue. Spend 80% of your forecasting energy there.

How to run an ABC analysis

Export your Shopify sales report for the last 12 months
Sort SKUs by total revenue, highest to lowest
Calculate cumulative revenue percentage
Classify:
- A items: Top SKUs that collectively account for 70-80% of revenue
- B items: Next group accounting for 15-20%
- C items: Everything else

Forecasting rules by tier

Tier	Revenue Share	Forecasting Approach	Review Frequency	Safety Stock Level
A (Top 10-20%)	70-80%	Full formula with seasonality + growth adjustment	Weekly	Higher (Z=1.96, 97.5% service)
B (Next 30%)	15-20%	Rolling 90-day average with seasonal multiplier	Bi-weekly	Moderate (Z=1.65, 95% service)
C (Bottom 50%)	5-10%	Simple reorder point, minimal safety stock	Monthly	Low (Z=1.28, 90% service)

Your A items get the full forecasting treatment — weekly reviews, seasonal adjustments, growth factors, generous safety stock. Your C items get a simple reorder point and monthly checks. This is not about neglecting products. It is about allocating attention proportionally to revenue impact.

An ecommerce business plan that accounts for inventory tiers scales far more efficiently than one that treats every SKU equally.

ABC analysis inventory tiers

How Do You Reduce Dead Stock Without Killing Cash Flow?

Dead stock is money in a coma.

The average ecommerce store carries 20-30% dead stock — inventory that has not sold in 90+ days, according to a 2024 Statista supply chain report. Reducing dead stock by even 10% frees cash equivalent to 3-5% of annual revenue, which can be redirected to marketing or inventory for A-tier products. The key is identifying slow movers early, not after they have been sitting for six months.

Dead stock does not announce itself. It accumulates quietly while you focus on bestsellers. By the time you notice, the cash is already locked.

The 90-day rule

Any SKU that has not sold a single unit in 90 days is dead stock. Run this report monthly:

0-30 days without a sale: Watch list. Reduce ad spend, check listing quality.
31-60 days: Markdown candidate. Bundle with A-tier products or offer as a free gift with purchase.
61-90 days: Liquidate. Flash sale, marketplace clearance, or donate for tax write-off.
90+ days: Stop reordering. Clear remaining units at any margin.

Prevention beats liquidation

The real fix is not better clearance sales. It is better forecasting. If you are running the ABC analysis and reorder point formulas above, dead stock drops dramatically because you stop ordering products that do not sell.

Here is a practical prevention checklist:

Test new products with minimum viable quantities — order 30-50 units before committing to 500
Set kill criteria before launch — "If this SKU does not sell 10 units in 30 days, we do not reorder"
Track sell-through rate weekly for A items — Sell-Through Rate = Units Sold / Units Received x 100
Use pre-orders for seasonal or limited products — validate demand before you buy inventory

What Are the Most Common Inventory Forecasting Mistakes?

Every mistake here costs real money.

The three most expensive inventory forecasting mistakes are: ignoring lead time variability (causes 35% of stockouts according to Supply Chain Dive), using averages without accounting for demand variability (inflates safety stock by 40-60%), and failing to exclude promotional spikes from baseline forecasts (skews future orders upward by 15-25%). All three are fixable with basic formula adjustments.

We see these repeatedly in Shopify store audits:

Mistake 1: Using a single average without variability

A product that sells exactly 3 units every day and a product that sells 0 on Monday and 6 on Friday have the same average. But they need very different safety stock levels. Always calculate standard deviation alongside your average.

Mistake 2: Ignoring supplier lead time changes

Your supplier quoted 14 days. The last three orders took 21, 18, and 25 days. Use the actual average, not the quoted one. Better yet, use the worst-case lead time for your reorder point and the average for your forecast.

Mistake 3: Counting promotional sales as normal demand

That 11.11 sale moved 500 units in one day. If your forecast model treats that as a normal sales day, your next order will be wildly inflated. Flag promotional periods and exclude them from baseline velocity calculations.

Mistake 4: Forecasting at the category level instead of SKU level

"Skincare sells 200 units a month" is useless. You need to know that Vitamin C Serum sells 90, Moisturizer sells 70, and Eye Cream sells 40. Aggregate forecasts hide the SKU-level signals that actually drive purchase orders.

Mistake 5: Never updating the forecast

A forecast is not a one-time exercise. Markets shift, trends change, competitors launch. Review and update your forecasts at least monthly for A items and quarterly for B and C items.

Frequently Asked Questions

What is ecommerce inventory forecasting?

Ecommerce inventory forecasting uses historical sales data, lead times, and seasonal patterns to predict how much stock to order and when. According to IHL Group, retailers lose $1.77 trillion globally each year to overstock and stockout problems. Accurate forecasting reduces both by matching purchase orders to actual demand rather than gut instinct.

How do you calculate reorder point for a Shopify store?

The reorder point formula is: Average Daily Sales x Lead Time in Days + Safety Stock. For a product selling 3 units daily with a 21-day lead time and 6 units of safety stock, the reorder point is 69 units. WebMedic's free reorder point calculator at /tools/reorder-point-calculator runs this formula instantly for any SKU.

What is the best inventory forecasting tool for Shopify?

For stores with 30-100 SKUs, Inventory Planner by Sage (from $249/month) offers strong demand forecasting with Shopify-native integration. For 100+ SKUs, Prediko (from $125/month) uses AI-driven forecasting and automated purchase orders. Both reduce forecast error by 20-30% compared to manual spreadsheet methods, according to Gartner's 2024 supply chain survey.

How much safety stock should an ecommerce store carry?

Safety stock depends on demand variability and desired service level. The formula is: Z-score x Standard Deviation of Daily Demand x Square Root of Lead Time. For most Shopify stores, a Z-score of 1.65 (95% service level) balances stockout prevention against excess inventory cost. A-tier products should use 1.96 (97.5%) for tighter protection.

How often should you update inventory forecasts?

Review A-tier products (top 10-20% of SKUs by revenue) weekly and update forecasts monthly. B-tier products need bi-weekly monitoring with quarterly forecast updates. C-tier products can be reviewed monthly. According to McKinsey retail operations research, companies that update forecasts monthly reduce overstock by 15-25% compared to quarterly reviewers.

Ecommerce Inventory Forecasting: Stop Guessing, Start Planning