What Is the Shopify Inventory Replenishment Report?
The Shopify Inventory Replenishment report shows, for each product and variant, how long your current stock will last based on how fast it has been selling. For the period you choose, it pairs inventory quantity with net units sold, then factors in your supplier lead time to give a Days to Replenish estimate for every SKU.
The report answers a timing question rather than a counting one. A plain stock count tells you how many units are on the shelf. Days to Replenish tells you how many days those units will last at the current sales pace, which is the figure that actually decides when to reorder. It is also different from a reorder quantity: this report focuses on the runway you have left, not the exact number of units to purchase.
Merchants use it to catch fast sellers before they run out and to spot slow movers that are quietly tying up cash. Because it reads sales velocity and lead time together, it is most useful when you want a quick, forward-looking view of what needs restocking next rather than a static snapshot of what is in the warehouse today.
Which Fields Are Included in the Shopify Inventory Replenishment Report?
These fields work together to turn a raw stock count into a restocking timeline.
You can customize the pre-made report by adding, removing, or rearranging fields so it matches how you plan restocking.
Important Insights You Can Find in This Report
Which fast sellers have the least stock cushion?
Compare Net Units Sold against Days to Replenish. A product can have a healthy-looking Inventory Quantity and still be near the top of your reorder list if it is selling quickly enough that the runway is short. Sorting by Days to Replenish ascending brings these items to the top so you deal with the tightest timelines first, before a strong seller turns into a stockout.
Which items are overstocked relative to how they actually sell?
Look for rows with high Inventory Quantity, low Net Units Sold, and a long Days to Replenish. These are slow movers sitting on weeks or months of stock. They rarely cause a panic, but they quietly hold cash you could put toward faster-moving products. This report makes them easy to separate from items that only look overstocked because sales paused briefly.
Are some variants running out while others pile up?
Because Days to Replenish is calculated per SKU, two variants of the same product often tell very different stories. A popular size may be days from empty while a slow size still has a long runway. Reviewing variants side by side stops you from reordering a whole product line when only one or two variants actually need it.
THE ANALYST'S READ: The Signal Most Merchants Miss
The number to watch is Days to Replenish measured against Lead Days, not Inventory Quantity on its own. If an item has fewer Days to Replenish than Lead Days, it will sell out before a new order can arrive, even when the stock count still looks comfortable. When several rows show that gap at once, it usually points to lead times that have crept up or demand that has outpaced your usual reorder rhythm. Those are the items to order first.
How Can You Automate the Shopify Inventory Replenishment Report?
Open the pre-made Inventory Replenishment report in Report Pundit. The columns are already set, so you can save it as is or adjust the date range and fields first. Once saved, schedule it to email you on a daily, weekly, or monthly cycle so the latest runway figures arrive without rebuilding the report each time. You can also send it automatically to a buyer, a VA, or a supplier contact, and export or push it to Excel, CSV, PDF, Google Sheets, or Google Drive.
Frequently Asked Questions
What does Days to Replenish mean in this report?
It is an estimate of how many days your current stock will last at the recent sales pace, based on Inventory Quantity and Net Units Sold. A low number means the item is close to running out.
How is this different from the Shopify Inventory Reorder Point report?
The Inventory Replenishment report focuses on the timing runway: how many days of stock you have left. The Inventory Reorder Point report adds safety stock and a reorder point quantity, so use that one when you need the exact stock level to reorder at and the number of units to buy.
What period should I choose for Net Units Sold?
Pick a period that reflects normal demand for the item. A longer range smooths out short spikes and dips, while a shorter range reacts faster to a recent change in how fast something is selling.
Why do two variants of the same product show different Days to Replenish?
Each variant has its own stock level and its own sales pace, and the runway is calculated separately for every SKU. A best-selling size will show a shorter runway than a slow one, even within the same product.
Can I focus the report on only the products at risk?
Yes. Sort by Days to Replenish so the shortest runways sit at the top, or filter to a specific product, vendor, or SKU to review it on its own.