Skip to content

Shopify Inventory Forecasting From Your Own Reports

Forecast stock in Shopify using sell-through, days of inventory remaining and daily sales reports, with a worked reorder example and the limits.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed October 27, 2026 · 4 min read

Shopify doesn't have a forecasting screen, but three of its reports get you most of the way: Inventory sold daily by product shows the rate you sell at, Inventory remaining per product divides what's left by average daily sales over the last 28 days, and Products by sell-through rate shows what's moving and what's sitting. Multiply the daily rate by your supplier's lead time, add a safety margin, and you have a reorder point. Shopify's assistant, Sidekick, can also suggest what to reorder and draft the purchase order.

The short version

  • Daily rate: from Inventory sold daily by product, or units sold over 28 days divided by 28.
  • Days of inventory remaining = ending quantity ÷ average daily sales over the last 28 days.
  • Sell-through rate = units sold ÷ (units sold + units still in inventory). The report runs about two days behind.
  • Reorder when days remaining falls to lead time plus a few days of safety stock.
  • The reports forecast finished products only, and they assume next month looks like the last 28 days.

The reports that do the work

Report What it tells you Use it for
Inventory sold daily by product Units sold per day Your rate, and spotting weekend or market-day spikes
Inventory remaining per product Days of stock left at the 28-day average What to reorder or make first
Products by sell-through rate Share of stock sold in the period Slow movers, and products to stop making
ABC product analysis Which products bring in most revenue Where to spend counting and ordering effort

ABC analysis isn't available on the Basic plan. The others are under Analytics > Reports, in the inventory category. From October 1, 2026, Shopify's inventory reports measure on-hand stock rather than available.

A worked example

Hilo Hot Sauce, a made-up hot sauce maker, sells its Smoked Habanero online. The last 28 days show 168 bottles sold, so the daily rate is 6. There are 70 bottles on hand. Days remaining: 70 ÷ 6 = 11.7.

The co-packer needs 10 days from order to delivery. Six bottles a day for 10 days is 60 bottles. Add four days of safety stock, 24 bottles, and the reorder point is 84. At 70 on hand, the order is already late. The owner orders today and asks for the run to be expedited.

Reorder point example and safety stock formula go further into the arithmetic, including how to size safety stock when sales jump around.

Making the forecast less wrong

  • Look at the shape, not just the average. A Saturday market can be a third of the week's sales. If the next 28 days include a holiday, the last 28 won't predict them.
  • Use the same window as the lead time is long. A 28-day average suits a two-week lead time. For a supplier that takes two months, look at a longer stretch too.
  • Remove one-offs. A wholesale order of 200 bottles inflates the daily rate for a month. Note it and take it out.
  • Check stockouts. A product at zero for five days sold nothing those days. The average then understates demand.

Where this stops working

Shopify forecasts the bottle, not what's in it. If you make your own sauce, the real question is whether there are enough peppers, vinegar, bottles and caps for the next batch, and when to order each one with its own lead time. Shopify has no record of those. It also can't tell you that 30 of your 70 bottles expire next month and won't sell in time. Shopify production planning covers the step from "sell 6 a day" to "make 120 on Thursday".

How TaroStack does it

TaroStack for Shopify runs inside your Shopify admin and turns your Shopify sales into a reorder list in days of cover, for finished products and for everything that goes into them. Each batch takes its ingredients and packaging off stock by recipe, so the list knows the peppers will run out before the bottles do, and it suggests reorder points from how stock actually moves. Lots and best-before dates mean it warns about stock that will expire unsold. Free for 14 days.

Questions people also ask

Does Shopify have demand forecasting?

Not as a feature with that name. Its reports give you the daily sales rate and days of inventory remaining, and Sidekick can suggest reorders. Forecasting beyond that needs an app or a spreadsheet.

How does Shopify calculate days of inventory remaining?

Ending quantity divided by the average daily units sold over the last 28 days, per product.

What's a good sell-through rate on Shopify?

There's no single good number. Compare products against each other: one far below your others is tying up cash. Shopify dead stock covers what to do with it.

Sources

  1. Shopify Help Center: Inventory reports · read October 27, 2026
  2. Shopify Help Center: ABC inventory analysis · read October 27, 2026
  3. Shopify Help Center: Migrating from Stocky to Shopify inventory management · read October 27, 2026
  4. Shopify Help Center: Creating and managing purchase orders · read October 27, 2026

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

TaroStack for Shopify

Free for 14 days.