Who this guide is for
Operators and planners at Shopify brands managing 50+ SKUs or variants who feel their current forecasting approach is fragile - especially those dealing with seasonality, new product launches, or multiple suppliers.
The challenges of scale
Forecasting is still done with 30–90 day rolling averages in spreadsheets, which break as soon as you have stockouts, promotions, or seasonal shifts that distort historical averages.
Existing content on 'Shopify demand forecasting' explains theoretical models but rarely shows how to connect Shopify's actual reports to a real reorder decision.
Forecasts are not tied to cash or purchasing constraints - you can build a demand plan but it doesn't translate into a budget or a purchase order.
Edge cases like new SKUs with no history, seasonal items, and intermittently selling variants are handled ad hoc, which undermines trust in the overall plan.
Stocky - Shopify's bundled forecasting app - is being discontinued in 2026, leaving merchants who relied on it without automated replenishment suggestions and 'back to guessing or building spreadsheets.'
There is no native Shopify place to store a service-level target, lead-time distribution, or open-to-buy budget that feeds into a forecast - all of this lives outside the platform.
Fundamental concepts
Average Daily Demand (ADD)
The baseline input to most inventory forecasts - units sold per day over a defined lookback window, adjusted to remove days when the product was out of stock or heavily discounted.
Formula
ADD = Total Units Sold in Period / Number of Days in Period (excluding stockout days)Example: A product sold 840 units over a 60-day period, but was out of stock for 5 days. Adjusted ADD = 840 / 55 = ~15.3 units/day - not 14/day, which would be the naive calculation.
Reorder Point (ROP)
The stock level at which a new purchase order must be placed, such that inventory arrives before the existing stock runs out. Directly derived from forecasted demand during lead time plus safety stock.
Formula
ROP = (Average Daily Demand × Lead Time in Days) + Safety StockExample: ADD = 20 units/day, lead time = 14 days, safety stock = 60 units. ROP = (20 × 14) + 60 = 340 units. When on-hand hits 340, trigger a new PO.
Moving Average Forecast
The simplest forecasting method - takes the average demand over a trailing window (e.g., 30, 60, or 90 days). Good for stable products; poor for seasonal items or products with a clear trend.
Formula
Forecast = Sum of Daily Sales in Window / Number of Days in WindowExample: A candle brand uses a 90-day moving average - but this smooths out a 3x spike in December and underestimates November replenishment needs by 40%.
Seasonal Demand Adjustment
A multiplier applied to a base forecast to account for predictable seasonal swings - e.g., Q4 holiday uplift, summer slowdown, or back-to-school surge. Calculated from prior year performance relative to the annual average.
Formula
Seasonal Forecast = Base Forecast × Seasonal IndexExample: A product's November average demand is historically 2.4x the annual monthly average. Seasonal Index = 2.4. If base forecast is 300 units/month, November forecast = 720 units.
Open-to-Buy (OTB)
A financial planning framework that determines how much merchandise a brand can purchase in a given period, given planned sales, beginning and ending inventory targets, and already-committed orders. Prevents over-ordering that ties up cash.
Formula
OTB = Planned Sales + Planned End-of-Month Inventory + Planned Markdowns – Planned Beginning-of-Month Inventory – On-Order InventoryExample: Planned sales $80K, planned EOM inventory $50K, markdowns $5K, BOM inventory $40K, on-order $30K. OTB = $80K + $50K + $5K – $40K – $30K = $65K available to spend.
Forecast Accuracy
A measure of how closely your demand forecast matches actual sales, commonly expressed as Mean Absolute Percentage Error (MAPE). High MAPE means your forecasts are driving either overstock or stockouts.
Formula
MAPE = (1/n) × Σ |Actual – Forecast| / Actual × 100%Example: If your forecast was 200 units but actual demand was 250, your MAPE for that SKU that period = |250–200|/250 = 20%. World-class operations target <15% MAPE across the catalog.
Why native Shopify isn't enough
While Shopify is a strong commerce engine, its native inventory tooling often reaches a limit once brands need better forecasting, replenishment logic, supplier workflows, and purchasing discipline.
- Shopify provides sales-by-product and inventory history reports, but there is no built-in demand forecasting engine, regression model, or automated replenishment suggestion logic.
- There is no structured per-SKU lead-time field in native Shopify that feeds into any inventory calculation; it must be stored in product metafields, notes, or external tools.
- Advanced planning concepts like open-to-buy are documented on Shopify's blog as educational content, but are not implemented as native features - merchants must build OTB logic themselves or use third-party apps.
- Merchants who want forecasts must export data to spreadsheets or planning apps; Shopify itself is a data source and transactional UI, not a planning engine.
- Shopify's 'Days of Inventory Remaining' uses a 28-day average and does not account for seasonality, open POs, or upcoming promotions - making it a lagging indicator rather than a true forecast.
- Shopify's ABC analysis (available on higher plans) classifies products by revenue share but provides no guidance on how to adjust ordering strategies for each class.
Key stats and benchmarks
Forecasting vendors targeting Shopify consistently note that manual tracking breaks down at approximately 50 SKUs or 50 variants - beyond that, catalog complexity requires systematic tooling.
Poor inventory alignment (stockouts plus overstock together) costs retailers an estimated 11% of annual sales - meaning a $2M brand leaves $220K on the table through preventable inventory errors.
The Stocky app discontinuation in 2026 affects thousands of Shopify POS merchants who relied on its min/max replenishment logic; these merchants now have no native automated forecasting within Shopify.
Ecommerce brands targeting a 4–6x annual inventory turnover rate typically need rolling demand forecasts of at least 13 weeks to inform purchasing decisions without chronic stockouts.
Carrying cost benchmarks of 20–30% annually mean that even modest over-forecasting - holding 2 extra months of supply - can quietly absorb 4–5% of that product's margin.
AI-assisted demand forecasting tools for ecommerce have been shown to reduce stockout incidents by up to 40% and cut overstock by up to 28% versus spreadsheet-based planning.
Practical angles to explore
- The Shopify demand forecasting starter kit: how to pull usable data from Shopify reports and build your first forecast in a day
- Why your 30-day average is lying to you - and how to build a stockout-adjusted baseline
- Seasonal forecasting for Shopify: how to build a seasonal index from last year's data and apply it forward
- New SKU forecasting: how to generate a demand estimate when you have no history
- How to translate a demand forecast into an actual purchase order - the step most guides skip
How Synplex helps
Synplex turns Shopify order histories, lead times, and supplier constraints into SKU-level demand forecasts and buying tables. It surfaces which products will run out within your lead-time window, flags overstock risk, and can generate POs aligned with open-to-buy budgets - all within a Shopify-native interface that eliminates the spreadsheet-to-Shopify round trip.
- Demand forecasting engine that uses Shopify sales data and adjusts for stockout periods, promotions, and seasonality
- Per-SKU reorder point and safety stock calculations driven by forecasted demand and stored lead times
- Open-to-buy budget framework that prevents over-ordering while ensuring bestsellers stay in stock
- New SKU onboarding with analog-based demand priming
- Forecast accuracy reporting to identify which SKUs need model tuning
Suggested guide outline
- 1Intro: Why Shopify brands outgrow gut-feel forecasting - and what it costs them
- 2Section 1: What Shopify analytics can and can't do for demand planning today
- 3Section 2: The forecasting methods that actually work for ecommerce - moving averages, weighted averages, seasonality indexes
- 4Section 3: Building a basic demand forecast from Shopify order data - step by step
- 5Section 4: Handling tricky cases - new SKUs, seasonal items, and promotional distortions
- 6Section 5: Connecting forecasts to purchase orders and open-to-buy budgets
- 7Section 6: How Synplex embeds forecasting and buying into one Shopify-native workflow
- 8Action plan: move from static Shopify reports to living forecasts in 30 days
Frequently asked questions
Common questions about shopify inventory forecasting guide: from gut feel to systematic planning.