How to decide what to reorder in Shopify after Stocky
Stocky could fill a purchase order for you. Pick a supplier, choose "Using Suggestion", and it worked out what to reorder from your recent sales. With Stocky gone, Shopify points you to its reports and its AI assistant instead. You can get the same answer in about 15 minutes per supplier, using Shopify's own reports and one simple sum. Here's how, plus the mistake that makes most reorders come in short.
What Stocky's suggestions were doing
Stocky's main suggestion types were simple arithmetic (Shopify Help: Stocky demand forecasting):
- Last X days: average sales per day over a period you chose, multiplied by how many days the order should last. Sold 14 shirts in 7 days, ordering for 14 days: order 28.
- Same period last year: order what you sold in the same dates a year ago. Useful for seasonal products.
- Fill shelves and Target stock level: order up to a maximum you set for each product.
None of this is hard to do yourself. What you lose is the convenience, so the aim is a routine that takes minutes, not an afternoon.
What Shopify gives you instead
Shopify's Stocky migration guide points to three tools: inventory reports, custom fields (metafields) for your minimum and maximum levels, and Sidekick, Shopify's AI assistant, which Shopify says can suggest what to replenish and draft purchase orders. Whichever you use, it helps to know the sum underneath, so you can check the answer.
The reports are under Analytics › Reports. Filter by the Inventory category (Shopify Help: inventory reports). Three of them matter for reordering:
- Inventory remaining per product shows each variant's days of inventory remaining: stock left divided by average sales per day over the last 28 days. Variants with no sales in that time show N/A.
- Inventory sold daily by product gives quantity sold and quantity sold per day for any period you choose, such as the same weeks last year.
- ABC product analysis grades variants by revenue over the last 28 days: A is the top 80% of revenue, B the next 15%, C the last 5%. Running out of an A product costs you the most.
The reorder sum
For each product, you need three numbers:
- Daily sales rate: units sold divided by the days it was in stock (more on this below).
- Lead time: how many days it really takes from placing the order to having stock on the shelf. Use what actually happened on the last few orders, not the supplier's quoted time. If they vary, use the slowest.
- Cover: how many days you want each order to last, for example 30.
Then:
- Reorder when stock you can sell ≤ daily rate × (lead time + a few safety days).
- Order quantity = daily rate × (lead time + cover) − stock you can sell − stock already on order that will arrive in time.
"Stock you can sell" means Available, not On hand. Since October 1, 2026, Shopify's inventory reports measure stock by On hand, which includes units already sold but not shipped and units set aside as damaged. If your Committed or Unavailable numbers are large, the report's days remaining will look better than they are. Our guide to On hand vs Available vs Committed explains the difference.
The mistake: counting days you had nothing to sell
Averages over a fixed period include the days a product was sold out. On those days it sold nothing, not because nobody wanted it, but because you had none. So a product that was out of stock for a week looks slower than it is, and the next order comes in short. Then it sells out again, and the next average is even lower.
A worked example. Over the last 28 days you sold 42 candles, but they were sold out for 7 of those days:
| Average over 28 days | Average over in-stock days | |
|---|---|---|
| Daily rate | 42 ÷ 28 = 1.5 | 42 ÷ 21 = 2.0 |
| Order for 10 days lead time + 30 days cover, with 18 available | 1.5 × 40 − 18 = 42 | 2.0 × 40 − 18 = 62 |
The first order is 20 candles short, about 10 days of sales. Shopify describes its days-remaining report as averaging sales over the last 28 days, and doesn't say it leaves out sold-out days, so check any product that ran out recently.
To find the sold-out days, open the variant's adjustment history. It shows the Available quantity after each change, so you can see the date it hit 0 and the date you restocked. You only need to do this for products that ran out, and the ABC report tells you which ones are worth the effort.
Round to what the supplier sells
If candles come in cases of 12, 62 becomes 72 (6 cases). Round up for A products and down for C products, where running short costs you less than money sitting on the shelf.
Shopify suggests keeping supplier details on each variant as metafields, for example supplier.lead_time_days, supplier.case_quantity and supplier.minimum_order_quantity. These are for reference only: Shopify doesn't use them in purchase orders, so you still convert cases into units yourself.
A 15-minute routine per supplier
- Open Inventory remaining per product and look at that supplier's products. Anything under lead time + safety days needs ordering now.
- For those products, check whether they were sold out in the last 28 days. If so, work out the rate from in-stock days only.
- Do the sum, subtract what's Available and what's already on order, and round to the case size.
- For seasonal products, compare with the same weeks last year in Inventory sold daily by product.
- Create the purchase order. You can also import the lines from a CSV (Shopify Help: purchase orders).
- When it arrives, write down the real delivery date, so your lead time stays honest. Our guide to receiving supplier deliveries covers the receiving side.
If this routine takes too long across many suppliers, a forecasting app may be worth paying for. Our comparison of Stocky replacement apps lists them with prices.
Quick checklist
- Rate = units sold ÷ days in stock, not ÷ days in the period.
- Lead time = what really happened on recent orders, slowest of the last few.
- Order = rate × (lead time + cover) − Available − incoming.
- Use Available, not On hand. Reports count On hand since October 1, 2026.
- Round to case sizes. Check A products weekly.