What Is Demand Forecasting (And Why Should You Care)?
Demand forecasting sounds like something only big brands need to worry about. But if you run a Shopify store with inventory, you're already doing it — you just might not be doing it well.
At its core, demand forecasting is simple: looking at how much you've sold in the past to predict how much you'll sell in the future. Then you use that number to decide how much stock to keep on hand.
Right now, you might be making that decision by gut feel. You watch your sales, notice what's popular, and reorder when things feel low. That works at very small scale. But once you're managing more than a handful of SKUs, it becomes a guessing game — and guessing wrong costs you money in two very different ways.
The Real Cost of Getting Demand Wrong
Stockouts hurt in ways you might not measure. When you run out of a popular product, you lose the immediate sale. But you also lose the customer's trust, their likely second purchase, and the SEO impact of having it back in stock. Google's crawlers notice when products are unavailable, and search visibility can dip.
Overstocking is the flip side. Extra inventory ties up cash that could go into ads, new products, or operations. Slow-moving SKUs age in your warehouse, become outdated, or need clearance pricing that kills your margins.
Demand forecasting helps you walk that line: having enough to meet what customers actually want without guessing wrong.
Two Approaches to Predicting Demand
There are fundamentally two ways to forecast demand for Shopify stores:
1. Velocity-Based Forecasting
This is the most practical approach for small to mid-size Shopify stores. It answers a straightforward question: How many units do I sell per day, and how many days of stock do I need?
Velocity-based systems look at your actual sales over a chosen period (14 days, 30 days, 60 days, or longer), calculate your average daily sales rate, and then multiply that by the number of days of stock you want to keep.
Example: If you sold 100 units in 30 days, your velocity is about 3.3 units per day. If your supplier takes 14 days to deliver and you want 7 days of safety stock on hand, you'd keep roughly (3.3 × 21 days) = 70 units in stock. When it drops below that, reorder.
Sensible Forecasting uses this approach because it's transparent, easy to understand, and works with real Shopify data without needing months of historical patterns.
2. Machine Learning-Based Forecasting
Some larger platforms use ML algorithms to find patterns in your sales data — seasonality, weekly trends, or product correlations. These can be accurate if you have lots of historical data and consistent patterns.
However, ML forecasting can be overkill for most Shopify stores. It's more expensive, requires more data, and when your business changes (new marketing channel, product update, seasonal shift), the model needs retraining. For stores under a few thousand orders per month, velocity-based forecasting is usually just as accurate and much simpler to work with.
How Velocity-Based Forecasting Actually Works (Step by Step)
Let's walk through the real mechanics so you understand what's happening behind the scenes:
- Gather sales history. Pull your sales data for a chosen period — typically 14, 30, 60, or 90 days. Most tools, including Sensible Forecasting, connect directly to Shopify to get this automatically.
- Calculate average daily sales. Divide total units sold by number of days. This is your velocity. If you sold 150 units in 30 days, your velocity is 5 units per day.
- Account for lead time. How many days does it take your supplier to deliver once you order? This is critical — your forecast needs to cover not just customer demand, but also the gap while you're waiting for new stock. If your lead time is 21 days and your velocity is 5/day, reordering when you have 105 units left keeps you covered during the wait.
- Add safety stock. This is buffer stock for unpredictable spikes in demand. A common approach is to keep an additional 7-14 days of sales on hand. This keeps you out of stockout trouble on your best sales days. Learn more about calculating safety stock for your store.
- Set your reorder point. This is the magic number: when stock hits this level, place a new order. It's roughly (daily velocity × lead time) + safety stock. Here's a deeper dive into reorder points.
- Adjust for your sales period. Different products might need different lookback windows. A trending item might need a shorter window (14 days) to catch current momentum, while a stable SKU might use 60 or 90 days for steadier forecasts. This guide covers choosing the right period for each product.
That's it. No algorithms, no complex math — just your actual sales data, lead time, and a bit of buffer. Sensible Forecasting automates all of this, tracking it across your entire catalog and sending weekly reports so you know exactly what to reorder.
When Do You Actually Need Demand Forecasting?
Honest answer: it depends on your catalog size.
If you're managing fewer than 20 SKUs and you're manually tracking inventory anyway, demand forecasting might feel like overkill. You probably have a good feel for what moves. Spreadsheets might serve you fine.
But once you hit 50+ products — which happens faster than you'd think with variants — manual tracking breaks down. You can't mentally track velocity, lead time, and reorder points for dozens of SKUs. You'll miss products, over-stock by accident, or face surprise stockouts.
At that scale, even a simple velocity-based tool pays for itself by preventing just a few stockouts or catching overstocks before cash gets tied up.
For guidance on demand planning scaled to small stores, read this post.
What to Look For in a Shopify Demand Forecasting Tool
If you decide to move beyond spreadsheets, here's what matters:
- Native Shopify integration. The tool should pull data directly from your store, not ask you to upload CSVs. This keeps your data current and removes manual work.
- Configurable sales periods. Different products need different lookback windows. You want control over 14, 30, 60, and 90-day options — or weighted averages that blend them.
- Lead time support. The tool must account for supplier lead times in its calculations. Without this, reorder points are just guesses.
- Email reports. You shouldn't have to log in daily to check what needs restocking. Weekly summaries that list low-stock products are much more practical.
- Product snoozing. For seasonal items or products you're intentionally running down, you need the ability to pause forecasting without deleting the product.
- Transparent math. You should understand how the tool is calculating your reorder points. Black-box forecasting is hard to trust and harder to debug when something feels off.
If you're comparing tools, this post covers the trade-offs between spreadsheets and apps in detail.
Getting Started with Demand Forecasting
You don't need perfect data or months of history to start. Begin with what you have:
- Pick your most important products — the ones that drive revenue or cause problems when you stockout.
- Gather your last 30 days of sales data from Shopify (or 60-90 days if you have high variance).
- Find out your exact supplier lead times. Call or email if you don't know — this is critical.
- Pick a reorder point strategy: simple (velocity × lead time + buffer), or with a defined safety stock amount.
- Run the numbers on paper or in a spreadsheet for one product. See how the forecast performs over the next few weeks. Adjust if needed.
- If manual tracking works, great. If it starts to feel tedious or you're worried you'll miss something, that's when a forecasting tool becomes worth the investment.
The goal isn't perfection — it's consistency and less guessing.
The Bottom Line
Demand forecasting for Shopify stores doesn't have to be complicated. Velocity-based forecasting — taking your average daily sales, accounting for lead time and safety stock — is simple, transparent, and effective for most stores.
For small catalogs, spreadsheets are fine. For larger ones, automating the math with a tool saves time and prevents the costly mistakes that come from manual tracking.
Ready to Stop Guessing on Inventory?
Sensible Forecasting calculates the exact reorder points for each product in your Shopify store based on your actual sales velocity, lead time, and safety stock. Get weekly reports telling you exactly what to reorder — no spreadsheets needed.
Start Free Trial →