Inventory how-to

How to calculate a reorder point for a new product with no sales history

Without sales history you cannot calculate a real reorder point, so you estimate one using a comparable product or a planning number, then replace it with actual data as soon as you have a few weeks of sales.

Short answer: Without sales history you cannot calculate a real reorder point, so you estimate one using a comparable product or a planning number, then replace it with actual data as soon as you have a few weeks of sales. Treat the first estimate as a placeholder, not a fact.

Why you need a stand-in number first

A reorder point is daily sales multiplied by lead time plus safety days. With no sales, you have no daily sales figure, so the formula has a hole in it. You fill that hole with a reasonable guess, watch what actually happens, and correct it quickly.

Where to get the first estimate

The best source is a similar product you already sell: same category, similar price, similar audience. Use its daily sales rate as a stand-in. If nothing compares well, use a planning estimate from your own sales target for the item, or ask the supplier what similar customers typically sell in the first month. Round down rather than up if you are unsure, since overstocking a new SKU is harder to fix than reordering a bit early.

Rebuild the reorder point once you have real data

After roughly 2 to 4 weeks of actual sales, stop using the stand-in and calculate daily sales from real orders. Recalculate the reorder point with that figure and your supplier's lead time and safety days. Keep checking weekly for the first couple of months, since early sales patterns for a new product can shift fast.

Step by step

  1. Pick a comparable product already in your catalog with similar price and audience.
  2. Use that product's daily sales rate as your stand-in daily sales figure.
  3. Get the lead time and safety days from your supplier for the new product.
  4. Calculate a placeholder reorder point: stand-in daily sales x (lead time + safety days).
  5. Set an initial order quantity using case pack and minimum order rules from the supplier.
  6. After 2 to 4 weeks of real sales, recalculate daily sales from actual orders.
  7. Replace the placeholder reorder point with the real one and review weekly for two months.

Worked example

Say you are launching a new ceramic mug. You already sell a similar mug that averages 3 units a day. You use 3 units a day as your stand-in daily sales for the new mug. The supplier's lead time is 10 days and you set 4 safety days. Reorder point = 3 x (10 + 4) = 42 units. Three weeks after launch, actual sales show the new mug is selling 5 units a day, so you recalculate: 5 x (10 + 4) = 70 units, and update your reorder point to that.

How SteadyShelf helps

SteadyShelf forecasts from a 28-day sales window, so a brand new product with zero history has nothing for it to forecast from yet. You will need to set an initial order manually using a comparable product or planning estimate, and once the new SKU has a few weeks of sales, SteadyShelf will start generating its own forecast and order-by dates automatically.

$29/month flat, unlimited products and suppliers, 30-day free trial. Run the numbers now with the free reorder point calculator.

SteadyShelf is launching on the Shopify App Store. Join early access to get the install link first.

Related guides

All inventory how-to guides ยท Inventory glossary

FAQ

What if I have no comparable product at all to base an estimate on

Ask your supplier for a typical first order quantity for similar customers, or set a conservative initial order based on your sales target for the item and the supplier's minimum order quantity. Treat it as a test batch and watch the first few weeks of sales closely so you can reorder or adjust fast.

How much safety stock should I add for a brand new product

Lean toward more safety days than you would use for an established product, since your sales estimate is a guess. A few extra days of safety stock costs less than running out during a launch, but do not overdo it since you also do not want to overcommit cash to an unproven SKU.

Let SteadyShelf do this math for every SKU

Order-by dates per supplier, seasonal forecasts and draft POs for your Shopify store. $29/month after a 30-day free trial.

Get early access