Shopify shows you what you have in stock — but never tells you what to reorder or when. Here's the exact method, free, using only two CSV exports. No app required.
Shopify tracks current inventory well, but it has no native concept of a reorder point — the stock level at which you should place a new order so you don't run out while you wait for the shipment. Merchants who used the free Stocky app got a version of this; Stocky is being retired on August 31, 2026, leaving many stores with no forecasting at all.
The good news: everything you need is already in two exports you can pull in about a minute.
Shopify admin → Orders → Export → CSV. Choose the last 3+ months so the sales rate is meaningful. This tells you how fast each product actually sells.
Shopify admin → Products → Export → CSV → all products. The Variant Inventory Qty column is your current stock on hand.
Three simple quantities do the whole job:
Lead time is how long your supplier takes to deliver. Safety stock is a buffer for demand spikes and late shipments. If you don't know your lead time yet, 14 days for each is a sane starting point — tighten it once you know your suppliers.
When stock on hand drops to or below the reorder point, it's time to order. A reasonable order quantity targets about 30 days of cover:
| Product | Sold (90d) | Sold/day | On hand | Reorder point | Order now? |
|---|---|---|---|---|---|
| Blue Widget | 270 | 3.0 | 40 | 84 | Yes |
| Red Gadget | 45 | 0.5 | 60 | 14 | No |
The widget sells 3/day; at a 28-day combined lead-plus-safety window it should never drop below 84, but only 40 remain — reorder today. The gadget is comfortable.
Doing this by hand across hundreds of SKUs is a spreadsheet slog. Our free browser tool does the whole calculation from the same two exports — nothing is uploaded, it all runs on your device — and hands you a ready-to-use workbook: what to order now, suggested quantities, and days of stock left for every product.
Open the Reorder Report tool →Drop your Orders + Products CSVs, get your reorder plan. Name your price — free if you need it.