What Is the Inventory Replenishment Report
The Inventory Replenishment report in Data Export helps you plan when to restock Shopify products. It brings current inventory quantity, net units sold, supplier lead days, and Days to Replenish into one view, so you can review stock coverage alongside the time needed to replenish it.
Product title, variant title, and SKU identify the item on each row. Choose a sales period to give demand context to the stock you hold, then review which variants need attention before your next purchasing cycle. The report supports restock planning; review supplier commitments before placing an order.
Report Overview
- Report period
- A selected sales period provides the context for Net Units Sold and demand trends.
- Data included
- Seven fields covering product and variant identity, stock, sales, and replenishment timing.
- Best for
- SKU-level restock reviews and purchasing priorities.
- Export formats
- Excel, CSV, TXT, or PDF.
- Frequency
- Generate for each review or schedule daily, weekly, or monthly email delivery.
What Can You Learn from Replenishment Timing
1. Which items need a purchasing review
Compare estimated stock coverage with Lead Days. Coverage at or below the restocking lead time is a reason to review the item promptly.
Example: Hypothetically, a SKU has 8 days of coverage and a 12-day lead time.
What you can do: Confirm availability with the supplier and review replenishment options.
2. Which variants need separate decisions
Review variants individually so a product total does not hide a shortage in one size or color. SKU and Variant Title keep the purchasing review specific.
Example: Hypothetically, medium shirts have little stock while large shirts remain well stocked.
What you can do: Prioritize the affected variant when preparing your restock list.
3. Where demand changes the priority
Read Net Units Sold alongside Inventory Quantity. Similar stock quantities can require different attention when recent sales differ.
Example: Hypothetically, two SKUs each hold 30 units, but one sold much faster in the chosen period.
What you can do: Review the faster-selling SKU first and validate whether that demand is likely to continue.
What Should You Check First in This Report
Start with the figures that determine whether a restock decision is timely and reliable.
- Days to Replenish and Lead Days: Compare stock coverage with the time required to receive more stock.
- Inventory Quantity: Review low or negative quantities and confirm the stock figure before ordering.
- Net Units Sold and reporting period: Check that the sales window reflects the demand you want to plan for.
- SKU and Variant Title: Match the exact variant to your supplier records to avoid ordering the wrong option.
When Should You Use This Report
| When to Use It | How It Helps |
|---|---|
| Reviewing stock coverage before purchasing | Review stock coverage and decide which items need attention before the next purchasing cycle. |
| Discussing supplier restock timing | Compare Lead Days with estimated coverage when discussing restock timing. |
| Checking replenishment needs by variant | Use SKU and Variant Title to distinguish replenishment needs within a product. |
| Updating the restock list after a demand review | Compare net units sold and stock quantities before updating the restock list. |
How to Create This Report in Data Export
Start with the premade Inventory Replenishment report so the listed fields are already available.
- Open Data Export in your Shopify admin and find the premade Inventory Replenishment report.
- Open the report and review its seven fields, including Lead Days and Days to Replenish.
- Choose your sales date range. Apply a relevant product or SKU filter to narrow the review, and check the lead-time values and replenishment calculation.
- Save the report and generate it. Review the figures, then download your preferred supported format.
- Set daily, weekly, or monthly email delivery if you want the report sent to your team on a regular schedule.
Make the Most of This Report
Use these checks to keep each replenishment review consistent.
01 / SALES PERIOD
Choose a representative window. A promotion can change recent sales velocity; review the date range before treating that pace as normal demand.
02 / SUPPLIER TIMING
Validate Lead Days. Confirm the lead time with your supplier before relying on the comparison with estimated stock coverage.
03 / NO RECENT SALES
Investigate blank estimates. If a SKU has no recent sales, review its history and calculation settings rather than interpreting a blank as unlimited coverage.
04 / PURCHASING HANDOFF
Keep identifiers visible. Include SKU and Variant Title in the export so the person preparing a purchase can match the correct item.
Frequently Asked Questions
What does Days to Replenish mean
It estimates how long existing inventory will last based on demand trends. Review it alongside Lead Days to assess restock timing, and check the configured calculation before acting.
How is Lead Days different from Days to Replenish
Lead Days describes how long restocking takes. Days to Replenish describes estimated stock coverage. Comparing them helps you identify items that may need an earlier purchasing review.
Does this report calculate how many units I should order
The listed fields support restock timing, but do not include a recommended order quantity. Decide order size separately using your purchasing requirements and supplier constraints.
Can I change the sales period
Yes. Set the date range when configuring the report. Use a period that suits the demand pattern you want to review, especially after promotions or seasonal changes.
Can I export and schedule this report
Yes. Download it as Excel, CSV, TXT, or PDF, or schedule daily, weekly, or monthly email delivery to support recurring stock reviews.
