Bulk Reorder Point Calculator

Upload your catalog's sales history as a CSV and calculate the reorder point and safety stock for every SKU at once, using your actual demand variability instead of a single fixed average.

Formula per SKU: Reorder point = (Average daily demand × Lead time) + Safety stock, where Safety stock = Z (from service level) × Standard deviation of demand × √Lead time.

Bulk reorder point FAQ

How is this different from the single-SKU reorder point calculator?

The single-SKU calculator asks you to type in a fixed average demand and lead time by hand, for one product. This tool uploads your actual sales history as a CSV and calculates, SKU by SKU, both the average demand and its real variability (standard deviation) — so each product's safety stock reflects how genuinely erratic its demand is, instead of assuming the same variability across your whole catalog.

Worked example with service level

If a SKU sells 20 units/day on average with a standard deviation of 6 units, a 12-day lead time, and a 95% service level (Z ≈ 1.65): Safety stock = 1.65 × 6 × √12 ≈ 34 units. Reorder point = (20 × 12) + 34 = 274 units. A SKU with the same average demand but much more erratic (standard deviation of 15) would need safety stock of 1.65 × 15 × √12 ≈ 86 units — almost triple, despite selling the same on average.

What if I don't have sales data for every day, including zero-sales days?

This is the most common CSV mistake: if you only upload rows with actual sales and skip zero-sales days, average demand comes out inflated and standard deviation comes out artificially low (it looks less erratic than it is). Always include one row per SKU per day, with 0 on no-sales days — that's what makes the variability calculation reliable.

Which service level should I pick?

95% is a reasonable starting point for most catalogs: it covers roughly 19 out of 20 replenishment cycles without a stockout. Raise it to 99% for SKUs where a stockout is expensive (a key customer, a seasonal product, high opportunity cost), and you can afford to drop to 90% on low-margin or low-risk items, where tying up less capital is worth the extra occasional stockout risk.

How often should I re-upload the catalog?

When a product's demand changes in a sustained way (growing, falling, or becoming more seasonal), a reorder point calculated from old data stops being reliable. As a rule of thumb, re-upload your history whenever you close a quarter or notice a significant shift in a SKU's sales — you don't need to do it weekly if your demand is stable.

Related reading

Other calculators