What Is the Inventory Re-order Report?
The Inventory Re-order report in Data Export brings product and variant names, SKUs, vendors and available inventory into one Shopify reorder review. It helps you find stock that needs attention before you place your next supplier order.
The Net Quantity Sold column adds sales context for your selected period. Reviewing stock alongside recent demand can help you decide which variants to investigate first. Exact purchase quantities still depend on your supplier lead times, incoming stock and buying rules, which are not included in the report fields.
Report Overview
- Report type
- Inventory; review products and variants by SKU and vendor.
- Period
- Available stock at report generation, with a sales period you choose for Net Quantity Sold.
- Data included
- Product Title, Variant Title, SKU, Vendor, Inventory Available and Net Quantity Sold.
- Best use
- Preparing supplier orders and checking low-stock variants.
- Delivery
- Export as Excel, CSV, TXT or PDF, or schedule delivery by email, Google Sheets or Google Drive.
What Can You Learn from Your Reorder Review?
1. Which variants need attention
Review availability at variant level so stock in one option does not hide a shortage in another.
Example: For example, a shirt has two medium units available and 30 large units.
What you can do: Check the medium variant before placing a size-wide reorder.
2. Where recent demand may outpace stock
Compare Net Quantity Sold for the chosen sales period with available inventory to prioritize a closer buying review.
Example: For example, a serum has six units available after selling 40 in the selected period.
What you can do: Check delivery time and incoming stock before deciding how much to buy.
3. Which items belong in the same vendor review
Grouping or filtering by vendor brings related SKUs together for your next supplier discussion.
Example: For example, three low-stock candle variants share the same vendor.
What you can do: Review those SKUs together and check supplier minimums before ordering.
What Should You Check First in This Report?
Check these details before turning the export into a purchase list.
- Available stock: Sort from lowest to highest and review variants that are near zero.
- Variant and SKU: Confirm the exact option and identifier so you reorder the right item.
- Sales period: Use a consistent period and consider unusual promotions or seasonal demand.
- Vendor and buying context: Check supplier details, incoming purchase orders and lead times in your own records.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Preparing a supplier order | Review available stock and SKUs for products associated with that vendor. |
| Checking size or color shortages | Find variants that need attention even when other options remain in stock. |
| Reviewing stock after a promotion | Compare remaining availability with sales from the selected period. |
| Holding a weekly buying review | Give your buyer a consistent export to check against incoming stock and supplier timing. |
| Sharing a reorder shortlist | Export selected products so purchasing or warehouse staff can review the same items. |
How to Create This Report in Data Export
Start with the Inventory Re-order premade report and review its settings before saving.
- Open Data Export and go to Prebuilt Reports. Find Inventory Re-order.
- Open the report and review the product, variant, SKU, vendor, available inventory and Net Quantity Sold columns.
- Choose the sales date range. Apply available vendor, product type or tag filters, and sort low-stock variants first.
- Save the report and generate an export. Check a few SKUs against your current stock records before sharing the buying list.
- Set up hourly, daily, weekly or monthly delivery to your email recipients or a Google Sheets or Google Drive destination.
Make the Most of This Report
Use these checks to make each buying review more useful.
01 / SALES PERIOD
Keep the period consistent. Separate promotional demand from ordinary sales when interpreting Net Quantity Sold.
02 / VENDOR REVIEW
Filter before ordering. Review one vendor at a time, then check supplier minimums and delivery schedules.
03 / STOCK CONTEXT
Check incoming stock separately. The listed columns do not show pending purchase orders or supplier lead times.
04 / EXPORT REVIEW
Chart with care. In Excel or Google Sheets, label available stock as a snapshot and sales with its selected period.
Frequently Asked Questions
Does this report calculate exactly how much to reorder?
The report fields support a reorder review but do not include a recommended order quantity. Check lead times, incoming stock, safety stock and supplier minimums before buying.
Can I review individual product variants?
Yes. Product Title, Variant Title and SKU help you review specific sizes, colors or other options separately.
What does Net Quantity Sold mean in this report?
It shows the net units sold for each variant in the sales period you choose. Compare it with Inventory Available to see where recent demand may outpace stock.
Can I export or schedule the report?
Yes. Export it as Excel, CSV, TXT or PDF. You can also schedule hourly, daily, weekly or monthly delivery by email or to a Google Sheets or Google Drive destination.
Does the report place purchase orders automatically?
No. The report is a review and export tool. It helps you prepare a buying list, but purchase orders are created separately with your supplier or purchasing tool.