Inactive/Active Items Report
View which items are active or inactive in your inventory.
Written by Michael Cook
Updated at June 18th, 2025
Inactive/Active Items Report
What This Report Is
This report shows a list of all your inventory items, broken into two groups:
- Active Items: Items currently for sale in the store.
- Inactive Items: Items no longer being sold or available.
You can filter the report by department and by how many days back you want to review.
Why It Matters
- Helps you keep your inventory list clean and up-to-date
- Identifies items that should be discontinued or reactivated
- Helps you spot old or dead inventory taking up shelf or storage space
- Prevents ordering mistakes on items you no longer carry
What to Look For
| Column | What It Tells You | What to Watch Out For |
|---|---|---|
| Description | The item name | Look for items you no longer sell |
| Department | Which area of the store the item belongs to | Watch for wrong department assigned |
| Current QOH | Quantity On Hand (in stock) | Negative QOH may signal inventory issues |
| Qty Sold | How much was sold during the selected days | Zero sales could mean poor performers |
| Status | Active or Inactive | Ensure status matches reality |
What to Do
- Switch inactive items back to active if you plan to restock them.
- Remove old inactive items from your ordering system to keep inventory clean.
- Review active items with low or zero sales — consider running promotions or discounts.
- Fix negative QOH values — may need an inventory adjustment or recount.