Items With No Sales
Find products in your inventory that have not generated any sales data.
Written by Michael Cook
Updated at June 25th, 2025
Table of Contents
Items With No Sales Report
What This Report Is
This report shows items in your store that have not sold during a specific time period. You can filter it by department and by how many days you want to check. You can also deactivate (make inactive) any items directly from this report.
Why It Matters
- Helps you spot products that aren't selling
- Prevents you from wasting money on dead inventory
- Keeps your store’s item list clean and up to date
- Makes restocking decisions easier by showing which items don’t move
What to Look For
| Column | What It Tells You | What to Watch Out For |
|---|---|---|
| Description | The name of the product | Look for old or duplicate items |
| Department | Where the item belongs (e.g. Candy, Snacks) | Check if certain departments have many unsold items |
| Supplier | Who provides the item | See if some vendors have more non-selling items |
| QOH (Qty on Hand) | How much you have in stock | Negative or high numbers mean you may be overstocked |
| Status | If the item is Active or Inactive | Active items with no sales may need review |
What to Do
- Clean Up Inventory: Mark items as inactive if they haven’t sold and you don’t plan to restock them.
- Avoid Reordering: Stop ordering items that aren’t selling to free up cash and shelf space.
- Investigate High QOH: If you have many units in stock but no sales, check for stocking issues, placement problems, or wrong pricing.
- Export and Review: Download the report to Excel for easy review with your team or supplier meetings.