Platform Guides

Inventory Forecasting for Shopify Merchants: Beyond Native Reports

Shopify's built-in inventory reports show what sold. Demand forecasting tells you what will sell — and when to reorder to stay ahead of it. Here's where native tools fall short.

7 min read

Abstract illustration of e-commerce platform data connecting to forecasting analysis

Shopify's analytics suite has improved meaningfully over the past several years. The inventory reports surface stock levels, low-inventory alerts, and sell-through rates. The sales analytics give you units sold by product and variant over custom date ranges. For a brand at early stage — 50 SKUs, one channel, predictable demand — that's workable data to make manual reorder decisions.

But Shopify's reporting was built for visibility, not prediction. It shows you what happened. It doesn't tell you what's going to happen — and for brands at 300+ SKUs with seasonal demand and multi-week supplier lead times, the gap between those two questions is where inventory problems are created or avoided.

What Shopify analytics actually gives you

Before discussing the gap, it's worth being precise about what Shopify does well. Under Reports → Inventory, you get:

  • Month-end inventory snapshot: on-hand quantities by SKU at the end of each month, useful for reconciliation and accounting
  • Inventory sell-through rate report: percentage of starting inventory sold over a period — a useful sell-through metric, though it requires you to define the period manually
  • Days of inventory remaining: a calculated field that takes on-hand quantity and divides by average daily sales over a trailing window — the window length is fixed, not configurable to your lead time
  • ABC analysis: Shopify Plus includes product performance grouping by revenue contribution, which is a useful starting point for prioritizing which SKUs to focus on

The sales analytics layer adds units sold by product, order volume trends, and channel attribution (Shopify Online Store vs. POS vs. external channels). If you've enabled the Shopify Markets feature for international sales, you get geographic demand breakdowns too.

This is solid transactional reporting. What it isn't is demand forecasting.

Where the native reporting falls short

No forward-looking demand projection

Shopify's inventory reports are retrospective. The "days of inventory remaining" calculation uses trailing average sales divided into current stock — a trailing average that doesn't know about your upcoming seasonal shift, a planned promotion, or the fact that a competitor just discontinued their comparable product. If your demand pattern is about to change, Shopify's report doesn't signal that. It just tells you how many days your current inventory would last at the recent rate.

No lead time awareness

Shopify stores a "lead time" field on product variants (added via some inventory management apps), but the native analytics don't incorporate lead times into reorder logic. The "days of inventory remaining" metric doesn't tell you whether 22 days of remaining inventory is fine (if your supplier ships in 10 days) or critical (if your supplier needs 30 days and you're about to enter a peak period).

Lead time awareness is the difference between a useful alert and an actionable one. Without it, you're watching a countdown without knowing when the deadline is.

Single-channel view by default

A Shopify merchant who also sells on Amazon Seller Central is managing two demand streams from two platforms that don't share inventory data natively. Shopify reports Shopify sales; Amazon Seller Central reports Amazon sales. The combined demand on a shared SKU — the number you actually need to forecast against if inventory is pooled — requires manual consolidation or a third-party integration.

This is particularly acute for brands that fulfill Amazon orders from the same physical stock they fulfill Shopify orders from. Without a combined demand view, your Shopify-side reorder logic is missing 30%, 40%, or 50% of actual demand on that SKU. That's a structural blind spot, not a reporting detail.

No seasonality or trend modeling

Shopify's trailing average smooths demand into a single recent-period number. It has no mechanism to recognize that this SKU does 4× volume in November compared to July, or that overall catalog velocity has been trending up 12% quarter-over-quarter for three quarters. Those patterns exist in your data — they're just not surfaced as a forecast.

The Shopify Plus context

Shopify Plus merchants get a few additional capabilities that narrow the gap slightly. The Shopify Flow automation tool can create reorder alerts based on inventory threshold triggers, and some merchants build custom automations that fire notifications to their buying team. The Stocky app (now largely deprecated in favor of third-party integrations) offered basic replenishment recommendations. Shopify Plus also includes enhanced API access, which makes building or connecting a third-party forecasting layer technically easier.

But none of this changes the fundamental architecture: Shopify is a commerce platform, not a planning system. Its design decisions optimize for storefront performance, checkout conversion, and order management — not demand forecasting accuracy. That's the right trade-off for a commerce platform to make. It just means the forecasting function needs to live somewhere else.

What a dedicated forecasting integration adds

A mid-market apparel brand on Shopify Plus managing around 900 SKUs went through a common planning evolution in 2024. They started with Shopify's native reports, moved to a Google Sheets-based process that pulled data via the Shopify API, and eventually connected a dedicated forecasting tool. The Sheets approach worked for a year before catalog growth and a new Amazon channel made it unmanageable — the multi-channel merge logic alone was breaking once a month.

When they connected a purpose-built forecasting layer, the core difference wasn't the algorithm sophistication — it was the automated data consolidation from Shopify and Amazon Seller Central into a single demand view, combined with a forecast that incorporated their actual supplier lead times. The first actionable insight surfaced in week two: two of their top-10 SKUs were inside the lead time window with less than 21 days of combined-channel cover. They'd been showing fine in the Shopify dashboard because Shopify was only seeing the Shopify demand half.

We're not saying Shopify's analytics are inadequate for their purpose — they're well-suited to what they're designed for. We're saying that demand forecasting and replenishment planning require a different type of tool, and expecting a commerce platform to also be a planning system leads to systematic blind spots as you scale.

What to look for in a Shopify-connected forecasting tool

If you're evaluating options, the integration depth matters as much as the algorithm. Specifically:

  • Does it pull historical sales at the variant/SKU level, not just product level? Shopify treats variants (size, color) as separate inventory items — your forecasting tool needs to model them at that granularity.
  • Does it handle Shopify's inventory location model? If you have inventory at multiple locations (your own warehouse, a 3PL, a retail store), does the tool see location-level stock and demand, or does it aggregate everything into a single pool?
  • Can it incorporate demand from non-Shopify channels? If you also sell on Amazon Seller Central, WooCommerce, or through wholesale, those demand streams need to feed the same model.
  • Does the replenishment output push back to your OMS or ERP? A forecast recommendation that lives only in a dashboard requires manual action to become a purchase order. Closing that loop — pushing to Linnworks, Cin7, or NetSuite — is where ops teams save the most time.

Stockorlo connects natively to Shopify and ingests historical sales data at the variant level. See the full integrations list, including Amazon Seller Central, WooCommerce, and OMS connections. If you're specifically a Shopify merchant wanting to understand the connection process, the product walkthrough covers the setup from platform connection to first forecast.

Shopify + Stockorlo: the full picture

Stockorlo connects natively to Shopify and adds SKU-level demand forecasting on top of your existing store data.

Request Early Access