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.
