A reorder point is the stock level that tells you to order or make more. The formula is daily sales × lead time in days + safety stock. Get daily sales from Shopify's Inventory sold daily by product report, lead time from your supplier (or, for things you make, from ordering ingredients to finished product), and safety stock from how much those two vary. Shopify doesn't store reorder points, so keep them in a metafield, a tag or a sheet, and set up an alert that compares stock against them.
The short version
- Reorder point = average daily sales × lead time (days) + safety stock.
- Daily sales: Inventory sold daily by product, or the 28-day average Shopify uses for days remaining.
- Lead time: order to sellable, not order to shipped.
- Safety stock covers busier days and slower deliveries.
- Shopify has no reorder point field. Store it yourself and alert on it.
A worked example
Makawao Mustard, a made-up condiment maker, works out two products:
| Lilikoi Mustard | Whole Grain Mustard | |
|---|---|---|
| Average daily sales | 6 | 2 |
| Lead time (days) | 12 | 12 |
| Lead-time demand | 72 | 24 |
| Safety stock | 30 | 10 |
| Reorder point | 102 | 34 |
Lilikoi has 140 on hand: no action. Whole Grain has 31: start a batch today. Reorder point example and Shopify safety stock cover each part in more depth.
Getting lead time right
For resold products, lead time runs from placing the order to having it on the shelf: the supplier's processing, shipping, and your receiving. For things you make, it runs from deciding to make a batch to sellable product: ordering any missing ingredients, waiting for them, making, cooling or curing, labelling. A sauce that takes a day to make but needs bottles with a 10-day lead time has a 12-day lead time if you don't keep bottles on hand.
Storing and using it in Shopify
- Metafield: a number field on each variant called "Reorder point". Workflows can read it.
- Tag: "rop-34". Simple, but harder to compare.
- Sheet: a list beside the Inventory export.
Then alert on it with Shopify Flow, or check a saved Inventory view weekly. Shopify low stock alert covers both.
How much to order when you hit it
The reorder point says when; the reorder quantity says how much. A simple rule: enough for the time until your next regular order or batch, plus the lead time, minus what's still on hand above safety stock. Round up to the supplier's case size or your batch size. Lilikoi Mustard, made in batches of 120 jars every two weeks, orders one batch each time the point is hit; a slower seller may make one batch a month.
When to recalculate
- Each season. Daily sales in December aren't March's.
- When a supplier or recipe changes. New lead times.
- After a stockout or a pile of overstock. Either the sales or the lead time was wrong.
Where this stops working
A reorder point on finished mustard assumes you can make mustard whenever the point is hit. That depends on mustard seed, vinegar, jars and labels, each with its own lead time and reorder point, none of which Shopify holds. Two products sharing one ingredient can both hit their points the same week and compete for it. Shopify raw materials inventory covers reorder points for what's upstream.
How TaroStack does it
TaroStack for Shopify runs inside your Shopify admin and suggests reorder points from how stock actually moves, for ingredients, packaging and finished products. It compares each supplier's promised lead time with how long deliveries really take, and keeps a reorder list in days of cover. Free for 14 days.
