What Is the Never Sold Products Report?
The Never Sold Products report in Data Export lists Shopify products and variants where Net Quantity Sold is 0 for the period you choose. It puts product name, variant, SKU, selling price and inventory quantity in one place.
Use this view to find items that recorded no net units sold during the selected period, particularly those that still have stock on hand. You can review a specific size, color or SKU without treating every variant of the same product as one item.
A zero net quantity is not always the same as never receiving an order. A shorter date range excludes older sales, and sales and returns can offset one another. Check the time window and underlying activity before calling a product never sold.
Report Overview
- Report type
- Product & Variant Reports.
- Reporting basis
- Products and variants with Net Quantity Sold = 0 in the selected period.
- Data included
- Product Title, Variant Title, SKU, Price, Net Quantity Sold and Inventory Quantity.
- Best for
- Reviewing zero-net-sale items, unsold stock on hand and individual variant performance.
- Export and delivery
- Excel, CSV, TXT or PDF; scheduled delivery can be set daily, weekly or monthly.
What Can You Learn from Products with Zero Net Sales?
1. Find Stocked Items with No Net Units Sold
Compare Inventory Quantity with Net Quantity Sold to identify products sitting in stock while their net sales remain at zero for the chosen period. This gives merchandising teams a practical list to review.
Example: A candle SKU has 24 units in inventory and 0 net units sold this month.
What you can do: Check its listing, discoverability and promotion plan before ordering more.
2. Review Unsold Variants Separately
Product Title, Variant Title and SKU help you see exactly which size, color or configuration is in the zero-net group. This prevents different variants being grouped into one decision.
Example: An XXL jacket appears as its own row with 0 net units sold.
What you can do: Review that variant individually, then compare its wider sales history before changing the full product range.
3. Check the Selling Prices of Zero-Net Items
Price lets you quickly inspect the listed selling prices of products that meet the zero-net filter. The report cannot establish whether price caused low demand.
Example: An unsold decorative lamp is listed at $90.
What you can do: Review its price and product presentation alongside other evidence before changing an offer.
4. Separate Unsold Stock from Zero-Stock Items
Some rows have stock on hand while others have none. Looking at Inventory Quantity helps separate the two situations.
Example: Two accessories each show 0 net units; one has 18 units in stock and the other has 0.
What you can do: Prioritize the stocked item for a demand review and check availability for the zero-stock item.
What Should You Check First in This Report?
Begin with these four checks before making inventory or merchandising decisions:
- Date range and Net Quantity Sold: Confirm the period and that the filter is set to exactly 0.
- Inventory Quantity: Separate rows with stock on hand from items with no recorded units available.
- Product Title, Variant Title and SKU: Make sure a specific variant is not mistaken for an entire product.
- Price: Note the listed selling price as context, without treating it as cost or lost revenue.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Reviewing items with zero net units sold | Find products and variants with zero net units sold in the chosen period. |
| Planning promotions for stocked items | Identify stocked items to review for placement, descriptions or promotions. |
| Checking stock on zero-net-sale items | Compare zero-net-sale rows with reported inventory quantities. |
| Reviewing items before increasing stock | Check items with no net movement before increasing quantities. |
| Preparing a weekly list for SKU follow-up | Share a consistent SKU-level list of items needing investigation. |
Before a seasonal campaign, review stocked variants in the zero-net group and decide which listings need attention.
How to Create This Report in Data Export
Start with the prepared Never Sold Products report rather than building the six-column view from scratch.
- Open Data Export and select the Never Sold Products premade report under Product & Variant Reports.
- Review the prepared columns: Product Title, Variant Title, SKU, Price, Net Quantity Sold and Inventory Quantity.
- Select the reporting period and confirm the filter Net Quantity Sold = 0.
- If useful, sort or filter by Inventory Quantity or SKU, then select Save.
- Export to an available file format or set a daily, weekly or monthly schedule for delivery to the people reviewing the list.
Make the Most of This Report
These four checks make a zero-net-sales report more useful and less likely to be misread.
01 / PERIOD / Choose the right window: Zero sales this month does not establish that a product has never sold.
02 / NET SALES / Check the zero: Sales and returns can offset. Verify order activity before labeling an item never purchased.
03 / INVENTORY / Prioritize stock on hand: Sort by Inventory Quantity to find zero-net items that still occupy shelf space.
04 / SHARING / Keep the export focused: Share the relevant SKU-level fields, and schedule recurring reviews only for the people who need them.
Frequently Asked Questions
Does zero Net Quantity Sold mean a product has never had an order?
No. The filter is based on net quantity for the selected period. An item may have sold earlier, or sales and returns may offset to zero. Review order activity if you need to confirm no historical orders.
Can I find zero-net-sale products that still have inventory?
Yes. Use Inventory Quantity alongside Net Quantity Sold = 0 to identify rows with units on hand. You can sort or apply available filters to focus on stocked items.
Does this report show the value or cost of unsold inventory?
No. The listed fields include Price and Inventory Quantity but not product cost, inventory valuation or profit. Price alone is not a measure of inventory cost.
Can I customize and export the Never Sold Products report?
Yes. Review or adjust the columns and filters, save the report, and export in Excel, CSV, TXT or PDF as available in Data Export.
Can the report be sent automatically?
Yes. After saving it, set up delivery daily, weekly or monthly. The supplied report setup describes email delivery and supported destinations such as Google Sheets, Google Drive and FTP.
