The classic reorder point is simple: average daily sales, times the supplier's lead time in days, plus a safety stock. It works for a shop with steady footfall. It does not work for a store where demand is set each morning by whoever is adjusting the ad budget.
The story I have seen most often: a product starts working on Meta, the budget goes from £400 a day to £2,400 a day over a fortnight, sales triple, and the reorder point, built on last quarter's average, is still telling everyone there are weeks of stock left. Then the product sells out eleven days before the next container lands, the ads keep running for two of those days, and the customers who ordered get an apology email.
Days of cover, not units
Start by changing the unit. Stock on hand in units tells you nothing. Days of cover does: units on hand divided by the current daily sales rate. The word current matters. Use the last seven days, not the last ninety, because the last seven are the ones the ad budget is shaping.
Then compare days of cover to the days until the next delivery actually lands. Not the promised date, the real one. If cover is shorter than the gap, you have a problem that no amount of safety stock fixes.
Three numbers that have to be in the same place
- Daily sales rate for the last seven days, per product. Shopify or WooCommerce has this.
- Days until the next delivery lands, per product. Your purchase orders have the promised date; your receiving history has the real one. Use the real one, or an average of the last few.
- Tomorrow's ad budget on that product. The ad platform has this, and it is the number that changes the first one.
Most stores keep these in three different tools, and the person who adjusts the ad budget cannot see the other two. The fix is organisational before it is technical: whoever changes a budget needs to see days of cover at the moment they change it.
The rule
Before raising the budget on a product, check that days of cover is greater than the days until the next delivery lands, at the sales rate the new budget will produce.
The last clause is the one that needs a guess. A rough rule that holds up in practice: if you raise the budget by 50%, plan for sales to rise by about 30 to 40% in the first week. It is not precise, but it is far closer than assuming demand stays flat.
A worked example
Nova Sneaker (an example product): 1,320 units on hand, selling 220 a day, so six days of cover. The next container is promised for day 15 and this supplier has averaged eight days late over the last six deliveries, so plan on day 23. Spend on this product is €2,400 a day and the budget is set to rise.
Textbook reorder point says you are fine for weeks, because its average daily sales is 90. Days of cover says you run out on day six, seventeen days before the container. Your choices are: throttle the spend to stretch the stock to day 23, or air-freight a few hundred units to cover the gap. In this example air freight for 700 units costs about €4,900 and protects the margin on 682 orders you would otherwise not be able to ship, which is about €28,000. The decision is obvious once the three numbers are side by side. It is invisible when they are not.
Doing it by hand
A weekly sheet works: one row per product with the seven-day rate, units on hand, days of cover, next real delivery date and this week's ad spend. Sort by days of cover, ascending. The top of that list is your morning.
What does not work by hand is doing it daily across sixty products and three ad accounts, which is where PixL comes in. It does this calculation every morning, and when the best ad is scaling into a product that is about to run out, it tells you in one line with the two options priced. But the sheet is the right first step, and it will catch your next stockout on its own.
