Inventory Forecasting for Ecommerce: A Practical Guide

Inventory forecasting for ecommerce means using your historical sales data, seasonal trends, and current sell rates to predict how much stock you'll need — and when. Done well, it tells you exactly when to reorder each SKU before you run out, without tying up cash in excess inventory that sits for months.

This guide covers the practical mechanics: the formulas, the methods, when to use each one, and what to watch out for.

---

Why Most Ecommerce Stores Get Forecasting Wrong

The most common mistake isn't using the wrong formula — it's using no formula at all. Most Shopify brands start by reordering based on gut feel: "we're getting low, better order more." That works when you have 10 SKUs and a slow, predictable catalog. It falls apart fast once you cross 50+ SKUs, have seasonal products, or start running promotions that spike demand unpredictably.

The second most common mistake is over-relying on simple averages without accounting for trend or seasonality. If you sold 100 units/month for six months, then ran a 30% off sale in month seven that moved 400 units, an average over all seven months will overstate your "normal" demand. You'll overorder and tie up cash.

Good forecasting separates signal from noise.

---

The Core Formula: Days of Stock and Sell Rate

Before getting into forecasting methods, you need two baseline numbers for every SKU:

Sell rate = Units sold ÷ Number of days in the period

Days of stock remaining = Current inventory ÷ Daily sell rate

For example: You have 240 units of a product. Over the last 30 days you sold 120 units. Your sell rate is 4 units/day. Days of stock remaining = 240 ÷ 4 = 60 days.

If your supplier lead time is 21 days and you want a 7-day buffer, you need to reorder when you have 28 days of stock left — meaning you should be placing that order in about 32 days from now.

This is the foundation everything else builds on. Tools like Alertr track this per-SKU automatically and alert you when you're approaching your reorder threshold, so you're not manually running these numbers across hundreds of products every week.

---

The Four Main Forecasting Methods (and When to Use Each)

1. Simple Moving Average

Best for: Stable, non-seasonal products with consistent demand.

Take the average units sold across a defined lookback window — typically 30, 60, or 90 days.

Formula: Forecast = Sum of units sold over N days ÷ N

A 45-day trailing average is a solid default for most ecommerce stores. It's long enough to smooth out weekly noise, short enough to respond to genuine demand shifts. This is the approach frequently recommended by experienced operators on communities like r/ecommerce, and it's a reasonable starting point for most catalogs.

Limitation: Moving averages lag. If your product is trending up or down, a moving average will underestimate or overestimate demand because it weights recent and older data equally.

---

2. Weighted Moving Average

Best for: Products with a clear upward or downward trend in demand.

Instead of treating every week equally, you assign more weight to recent data.

Example weights for a 4-week forecast:

• Week 1 (most recent): 40%
• Week 2: 30%
• Week 3: 20%
• Week 4: 10%

If you sold 200, 180, 160, and 140 units over those weeks (most recent first):

Forecast = (200 × 0.4) + (180 × 0.3) + (160 × 0.2) + (140 × 0.1) = 80 + 54 + 32 + 14 = 180 units

Compare this to a simple average: (200+180+160+140) ÷ 4 = 170 units. The weighted average captures the upward trend better.

---

3. Seasonal Adjustment

Best for: Products with predictable seasonal demand — holiday gifts, summer apparel, back-to-school items.

The core idea: compare this period's sales to the same period last year and apply a multiplier.

Seasonality index = Units sold in a period ÷ Average monthly units (over the full year)

If your average monthly sales are 500 units and you typically sell 900 in November, your November seasonality index is 1.8. Apply that to your baseline forecast for November to get a seasonally adjusted number.

This requires at least 12 months of sales history to be reliable. If you're a newer store, lean on industry benchmarks (most verticals have published seasonal curves) and adjust as you accumulate your own data.

---

4. Reorder Point Calculation

This isn't a standalone forecasting method so much as the output you're working toward — the inventory level that triggers a reorder.

Reorder point = (Average daily sales × Lead time in days) + Safety stock

Safety stock = Z-score × Standard deviation of daily sales × √Lead time

For most Shopify stores, a simplified version works well:

Safety stock = (Max daily sales − Average daily sales) × Lead time

If your average daily sales are 10 units, your maximum recent daily sales are 18 units, and your lead time is 14 days:

Safety stock = (18 − 10) × 14 = 112 units

Reorder point = (10 × 14) + 112 = 252 units

When your inventory hits 252, place your order.

---

Adjusting for Promotions and One-Off Events

This is where forecasting gets messy — and where most models fail.

If you're running a sitewide sale next month, your historical average is essentially useless as a standalone input. You need to estimate your promotion lift and build it into your forecast explicitly.

A practical approach:

1. Pull your sell rate during similar past promotions (same discount depth, same channel)
2. Calculate the lift ratio: promo sell rate ÷ baseline sell rate
3. Apply that multiplier to your baseline forecast for the promotion period

For a store doing 500 orders/month with an average of 2 items per order, a 20% off sale might produce 1.5x–2x normal volume based on industry benchmarks. If you've run that sale before, use your own data — it'll be far more accurate.

Also account for:

• Marketing campaigns: New ad creative or influencer posts can spike demand for specific SKUs with almost no warning
• Bundle changes: If you start bundling a product, its individual sell rate becomes irrelevant
• Listing on new channels: Amazon or TikTok Shop demand won't show up in Shopify historical data

---

How to Forecast Inventory for Your Ecommerce Store

Here's a practical workflow you can start with today:

Step 1: Pull 60–90 days of sales data by SKU Export from Shopify or your analytics tool. Include units sold per day, not just totals.

Step 2: Calculate your daily sell rate per SKU Exclude any days a product was out of stock — those zeros will drag your average down and cause you to underforecast.

Step 3: Identify your lead time for each supplier Be honest here. If your supplier says 14 days but it's been 21 days twice in the last three months, use 21.

Step 4: Calculate reorder points using the formula above

Step 5: Set alerts at your reorder points This is the step most stores skip. Knowing your reorder point intellectually doesn't help if you're not monitoring stock levels daily. Set up automated alerts — email or Slack — so you're notified when a SKU crosses the threshold, not after it runs out.

Step 6: Review and adjust monthly Your sell rates will drift. Products launch, die, go viral. A monthly review cadence catches issues before they become stockouts.

---

Spreadsheet vs. Dedicated Tool: When to Make the Switch

A well-built Google Sheet can handle forecasting for stores with up to 50–100 SKUs if someone is diligently maintaining it. Beyond that, manual spreadsheets become a liability:

• They only update when someone updates them
• They don't alert you — you have to remember to check
• Human error in formulas compounds across hundreds of rows
• They don't account for variants cleanly

Dedicated tools automate the data pull, recalculate sell rates continuously, and push alerts to you rather than waiting for you to log in.

On the Shopify App Store, options range from lightweight alert tools like Alertr ($0–$29/mo) to full inventory planning platforms like Prediko ($49+/mo) and Fabrikatör ($79+/mo). The right choice depends on your complexity:

• Under 200 SKUs, single location, no manufacturing: A focused tool like Alertr handles low stock alerts, sell rate tracking, days of stock estimates, and reorder suggestions without the overhead of a full planning suite.
• 200–2000 SKUs, multi-location, need purchase order automation: Look at Prediko or Inventory Planner by Sage — though note that Inventory Planner runs around $4k/year at full scale and has reported data syncing issues worth investigating before committing.
• Manufacturing involved: Katana ($299/mo) is built for this use case.

Be wary of tools with buggy Shopify syncing — inFlow Connector has persistent complaints about this, and a forecasting tool that doesn't accurately reflect your real inventory is worse than no tool at all.

---

The One Number to Track Every Week

If you only track one metric, make it days of stock remaining by SKU, sorted ascending.

Your top 10 most urgent products — the ones closest to zero days — deserve your attention every single week. Everything else can be reviewed monthly. This triage approach keeps you out of stockout emergencies without turning inventory management into a full-time job.

---

Inventory forecasting doesn't have to be complicated, but it does have to be consistent. Start with your sell rate, set a reorder point, and automate the alerts so the system does the watching instead of you.

If you're on Shopify and want to get this running without building a spreadsheet from scratch, Alertr has a free tier covering up to 50 SKUs — with sell rate tracking, days of stock estimates, configurable reorder thresholds, and alerts via email or Slack. The Pro plan is currently in beta at $19/month (locked in forever). Worth trying before you invest in a heavier platform.