Fix 19 of 60 · Inventory & reorders

Which products will sell out first on Black Friday?

A low-stock alert tells you when something is already running low. Before Black Friday you need to know earlier: which products will run out before your supplier can get more to you. Shopify's built-in inventory reports answer that.

Published Updated By Kishore, Axioprax5 min read
An inventory report where one best seller has 6 days of stock left against a 14 day supplier lead time and is flagged to reorder, one is borderline, and one has plenty of stock.

Why is a low-stock alert not enough before Black Friday?

A low-stock alert tells you when a product has already dropped below a number you picked. That works on a normal week. Before a big sale it can come too late: if your supplier needs two weeks and the alert fires with five days of stock left, you will sell out before the new delivery lands.

The better question is time, not units. How many days will this product last, and how many days does my supplier need? Shopify's built-in inventory reports give you the first number. You already know the second.

How do I know which products are at risk?

  • A product sells steadily every day, but you reorder it only when someone notices the shelf is thin.
  • Your supplier is overseas or makes to order, so restocks take weeks.
  • Last year a best seller sold out during the sale and you lost the rest of the weekend.

If any of these sound familiar, run the check below. You only need the products that bring in most of your revenue, so it is a short check.

How do I fix it? (step by step)

Work through it with your Shopify admin open, and tick each step as you go.

0 of 7 done

  1. Open the inventory reports.

    From your Shopify admin, go to Analytics > Reports, click the Category filter and click Inventory. On the mobile app, tap the menu icon, then Analytics > Reports, and filter Category by Inventory.

  2. Open Inventory remaining per product.

    Read the Days of inventory remaining column. Shopify works it out as ending quantity divided by the variant's average daily sales over the last 28 days.

  3. Add each supplier's lead time.

    Note how many days each supplier takes from order to stock on your shelf. We could not find a lead time field in Shopify's supplier details, so keep it in a simple sheet next to the report.

  4. Flag anything that runs out before restock.

    Mark every variant whose days of inventory remaining is lower than its supplier's lead time. Those will sell out before new stock can arrive, even at normal pace.

  5. Rank the flagged list by revenue.

    Open ABC product analysis in the same Inventory category and start with A-grade variants, the ones that make up about 80% of your revenue. Use Products by sell-through rate to see which of them have already sold the largest share of their stock.

  6. Raise purchase orders.

    Go to Products > Purchase orders, click Create purchase order, select the supplier, add the flagged products and quantities, then click Save as draft. To send it, click More actions > Export PDF and email the PDF to your supplier, then click Mark as ordered once they confirm.

  7. Check again before the sale.

    Open Inventory remaining per product again a few days before Black Friday on 27 November, because the 28 day window updates as you sell.

Flow from left to right: open the Inventory remaining per product report, compare each variant's days of inventory remaining with the supplier lead time, rank the flagged variants with ABC product analysis, then raise a purchase order before Black Friday.
Fewer days left than your supplier needs? Reorder it now.

How should I read the sell-through rate?

Products by sell-through rate shows what share of your stock you sold: items sold divided by items sold plus items still in inventory. Shopify uses the most recent 30 day period available, which usually lags by about two days. A high rate on an A-grade product is a good reason to check its days of inventory remaining first. Shopify treats untracked products as having sold 0 units, so turn on tracking for anything you want to see here.

When is this not the right fix?

Be honest about the main limit. Both reports look backwards. Days of inventory remaining uses your last 28 days of sales, so it assumes Black Friday will sell at the same pace as an ordinary week. It will not. If your sale brings a spike, stock runs out faster than the report says, so add your own buffer on top of the lead time for anything you are promoting.

It also cannot help a product with no recent sales, which shows N/A. And since 1 October 2026 the reports count On hand stock, which includes units already committed to orders, so the real days left can be lower than shown. If your counts are wrong to begin with, fix tracking before trusting any of this.

What does it cost?

Nothing extra on top of your plan. The inventory reports are included (Shopify lists them even on the Starter plan), and purchase orders are built into the Shopify admin under Products > Purchase orders. The cost is the time to note each supplier's lead time once. After that, the check is a short read of one report.

Want this set up for you?

Our Stocky Replacement kit includes a supplier sheet and a reorder sheet that work with Shopify's own purchase orders, so lead times live in one place. To see how we rebuilt a weekly reorder routine on our demo store, read the demo build.

Do it yourself, or have it done?

Done for you

We set it up in your store through a collaborator account, and tell you what it takes before you pay anything.

Frequently asked questions

How is this different from a low-stock alert?

A typical low-stock alert fires when stock drops below a fixed number you set. This check compares how many days of stock you have left with how long your supplier takes, so it catches fast sellers while they still look well stocked.

Why does a product show N/A for days remaining?

Shopify sets it to N/A when the variant had no sales in the last 28 days, because there is not enough data to predict. For a new product launching on Black Friday, estimate by hand.

Why did my stock numbers go up in these reports?

Since 1 October 2026, Shopify's inventory reports measure On hand quantity instead of Available. On hand includes Committed and Unavailable stock, so figures can be higher than what you can actually sell.

Which plans have these reports?

Shopify lists inventory reports on the Starter plan, and says the Basic plan comes with access to all reports.

Get the week's fixes by email

One email a week with the new fixes and their checklists. No sales emails. Unsubscribe any time.

Got a store problem we haven't fixed yet? Send it to us and it may become a future fix.

All fixes