What Is the Out of Stock Product Report
The Out of Stock Product report identifies Shopify products and variants that currently have zero inventory across locations. It brings product names, variant details, SKUs, product status, location names, and cost fields into one export so you can review which items need attention.
Use it to prepare a restocking review or check listings for products without stock. It is a current inventory snapshot when generated, rather than a record of when an item sold out. Variant details help you distinguish a missing size or color from the wider product range.
Report Overview
- Reporting basis
- Current zero-inventory products and variants across locations; not a historical stockout period.
- Data included
- Nine fields covering product identity, status, inventory, publication date, locations, and costs.
- Best for
- Restocking reviews, unavailable variant checks, and listing maintenance.
- Export formats
- Excel, CSV, TXT, and PDF.
- Automation
- Schedule email delivery daily, weekly, or monthly for a recurring stock review.
What Can You Learn from Your Out of Stock Products
1. Which variants need a restocking review
Product Title, Variant Title, and SKU identify the exact items with zero inventory. This gives your purchasing team a specific list to investigate.
Example: A hypothetical linen shirt appears with its medium blue variant at zero stock.
What you can do: Match the SKU to your purchasing records and check whether replenishment is planned.
2. Which listings need attention
Product Status helps you review zero-stock items in the context of their current catalog status. Zero inventory alone does not establish whether customers can still order an item.
Example: A hypothetical active ceramic mug appears in the report with zero inventory.
What you can do: Review its storefront listing and selling settings before promoting it.
3. How to organize the handoff to your team
SKU and Location Names give operations staff context for checking inventory records. Use them to direct follow-up to the people responsible for those items and locations.
Example: A hypothetical skincare variant lists the Main Warehouse among its location names.
What you can do: Send the relevant rows to the warehouse team for a stock-record check.
What Should You Check First in This Report
Start with the fields that determine which item needs attention and how to follow up.
- Inventory Quantity: Confirm the listed items meet the zero-stock condition before building your follow-up list.
- Product Status: Separate active items for listing review from products intentionally kept inactive.
- SKU and Variant Title: Check that each row maps to the correct variant in your purchasing records.
- Location Names: Review the location context before assigning a stock check; do not assume each row represents a separate product.
When Should You Use This Report
| When to Use It | How It Helps |
|---|---|
| Checking availability before a promotion | Review active products with zero inventory before planning promotions or updating listings. |
| Preparing a replenishment review list | Build a SKU-level list for checking replenishment needs against purchasing records. |
| Investigating zero-stock variants by location | Use variant and location details to investigate zero-stock records. |
| Maintaining unavailable product listings | Review product status and publication details when maintaining unavailable listings. |
How to Create This Report in Data Export
Start with the Out of Stock Product premade report so the report fields are already selected.
- Open Data Export and find the premade Out of Stock Product report.
- Open the report and review its product, variant, quantity, location, and cost columns.
- Keep the zero-inventory condition and adjust supported columns or available filters for your review. Treat Published At as a publication date, not a stockout date.
- Save the report and generate an export in your preferred supported format.
- Set up daily, weekly, or monthly email delivery if your team needs a recurring zero-stock list.
Make the Most of This Report
Use these checks to keep your export useful for the people acting on it.
01 / TIMING
Generate before you act Run a fresh report before a replenishment meeting. An earlier export may no longer reflect current stock.
02 / COUNTING
Count variants carefully Review SKUs and location details before counting rows. A row count is not automatically a count of distinct products.
03 / COSTS
Use purchasing records for reorder budgets Zero-stock inventory cost does not tell you how many units to buy. Check order quantities and supplier pricing separately.
04 / SHARING
Share only relevant fields Keep product and inventory costs in purchasing copies. Remove cost fields when recipients only need an operational SKU list.
Frequently Asked Questions
Does this report include low stock products
It is intended for products and variants with zero inventory. It does not serve as a list of items that are merely running low.
Can I identify which variant is out of stock
Yes. Product Title, Variant Title, and SKU help you identify the specific item rather than relying on the product name alone.
Does Published At show when a product sold out
No. Published At is the product publication date. The supplied fields do not include a stockout date or the number of days an item has been unavailable.
Does zero inventory mean the product cannot be ordered
The report shows the zero-inventory condition. Check the product’s selling settings and storefront availability separately to establish whether customers can place orders.
Can I export and schedule the report
Yes. Export it as Excel, CSV, TXT, or PDF, or schedule email delivery daily, weekly, or monthly. Each generated report reflects the inventory data available at that run.
