What Is the Never Sold Products Report?
The Never Sold Products report lists every product and variant in your Shopify store with a Net Quantity Sold of zero for the period you select. It applies one filter, Net Quantity Sold is 0, and returns the items that filter catches, along with their SKU, price, and current inventory quantity.
A "never sold" result is tied to the date range, not to the product's entire history. An item can show zero across a short window because it is new or seasonal, then show sales once you widen the range. Reading the report over a meaningful period is what separates a genuinely dead item from a slow starter.
The report pairs that zero-sales signal with Inventory Quantity, so you can tell the difference between a listing that simply is not moving and one that is holding stock you have already paid for. That pairing is why merchants reach for this report instead of a general sales report.
Which Fields Are Included in the Never Sold Products Report?
These fields let you identify each non-selling item and gauge how much stock it is holding.
You can customize the pre-made report by adding, removing, or rearranging columns, for example bringing in vendor, product type, or inventory cost so the view matches how you review your catalog.
Important Insights You Can Find in This Report
Which non-selling products are holding the most inventory?
Sort the results by Inventory Quantity to move the highest-stock, zero-sale items to the top. A product with no sales and a large inventory quantity is where your idle capital is concentrated, and it is a stronger candidate for a markdown, bundle, or clearance decision than a non-seller with only a unit or two on hand. This ranking turns a flat list of unsold items into a priority order for action.
Is the whole product dead, or only certain variants?
Because the report breaks out Variant Title and SKU, you can see when a product sells in one size or color while other variants sit at zero. That distinction changes the decision. A product with a few dead variants may only need those variants retired or their stock reallocated, while a product where every variant is unsold points to a listing, pricing, or demand problem across the item.
Do unsold items share a common price point?
Scan the Price column across the returned rows. When non-selling products cluster around a similar price, it can point to a positioning issue at that tier rather than a problem with any single product. That is a different read from looking at one item in isolation, and it is worth checking before you assume each unsold product failed for its own reason.
THE ANALYST'S READ: The Signal Most Merchants Miss
A zero in Net Quantity Sold is only half the story. The value worth reading next to it is Inventory Quantity. A never-sold item with almost no stock is usually a listing or demand issue that costs you little to leave alone. A never-sold item holding a large inventory quantity is money already spent and sitting still, and it carries holding cost for as long as it stays.
Before acting, check the date range. An item may read as unsold simply because the window is short, or because it is new or seasonal. Widening the range separates the products that are genuinely dead from the ones that are slow to start, so you clear real dead stock without discounting an item that was only waiting for its season.
How Can You Automate the Never Sold Products Report?
Open the pre-made Never Sold Products report in Report Pundit, where the columns and filter are already set, and save it. You can sort or filter the results, switch to a chart view to rank items visually, and add or remove columns to fit your catalog.
To reuse it without rebuilding, schedule it to email you daily, weekly, or monthly, and have it sent to your team or accountant on the same schedule. You can also export it as Excel, CSV, or PDF, or push it to Google Sheets or Google Drive.
Frequently Asked Questions
How does the report decide a product has never sold?
It applies a filter where Net Quantity Sold equals zero for the period you select, then returns every product and variant that meets that condition. Net Quantity Sold is units sold minus units returned, so an item is included only when it recorded no net units sold in that window.
Does the report cover my whole catalog or a specific period?
It reflects the date range you choose. A product showing zero over a short window can show sales once you widen the range, so running the report over a longer period gives a truer picture of what is genuinely not selling.
How is this different from the Best Selling Products report?
Best Selling Products ranks your top performers by sales, while Never Sold Products isolates the opposite end: items with no net sales at all. One tells you what to promote and reorder; this one tells you what to review, discount, or discontinue.
Why does the report include Inventory Quantity?
Because a non-selling item matters far more when it is holding stock. Inventory Quantity lets you separate zero-sale listings with little stock behind them from zero-sale items tying up capital you have already paid for.
Can I schedule this report to run automatically?
Yes. You can set it to email you daily, weekly, or monthly, send it to your team or accountant, and export it to Excel, CSV, PDF, Google Sheets, or Google Drive.