Documentation

Dusty Inventory

This report lets you see the age of your inventory with a focus on old, low-selling stock. Quickly find the items that need to be put on clearance or moved out to free up assets.

  • Role

    Inventory Manager

  • Job

    Increase Inventory Turns

  • Recommended Use

    Monthly

Benefits to You:

Increase profit by:
  • Move out products you have in stock that aren’t selling.
  • Identify problem categories or vendors and take action to fix them.
Save time by:
  • Correcting inaccurate inventory counts quickly.

How it's calculated:

(Uses a Per Store Metric: Items will appear on this list if they meet the criteria for any of your stores.)

Is Dusty
  • By default, we define dusty as an item whose last received date is >180 days, and whose last sold date is >180 days. In other words, items that have been in stock but have not sold for at least 180 days.
  • The last received date is the last positive change date from the inventory history tab, so includes items received by purchase order, transfer, or manual adjustment.
  • This definition of dusty can be customized for your store (and for each of your categories) by going to Admin>Configuration
Item Metrics Is Included
  • This filter relates to your inventory configuration as set up in Admin>Configuration. You can set it so only certain categories are included in your inventory alert reports (like dusty inventory, or low stock alerts).
  • This filter means we are only showing items that you want to report upon, as based on your configuration.

Available Variations:

With Counts
  • The default report with an added column for "Days Since Counted". Sort by this column to highlight stock that may not exist anymore as they have not been physically counted for an extended period of time.
By Vendor
  • The default report, but grouped by default vendor instead of by item description, so you can compare how much each of your vendors contribute to your dusty inventory.
By Top Level Category.
  • The default report, but grouped by top level category instead of by item description, so you can compare how much each of your categories contribute to your dusty inventory.
By Manufacturer
  • The default report, but grouped by manufacturer instead of by item description, so you can compare how much each of your manufacturers contribute to your dusty inventory.
Pivot by Shop
  • For multi-shop owners, displays the default report but pivoted by shop location, so you can see the exact store that is holding the dusty stock (or if a single item is dusty in multiple locations).

Next Steps:

  • Count inventory to make sure product actually exists
    • Days since counted column and inventory count helps prioritize your effort.
  • Re-merchandise
    • Move old stock physically to boost sales velocity.
  • Mark down
    • Sort by total cost and compare to retail value
    • Review your price rules.
    • Physically change price on the items.
  • Create a Marketing Plan
    • Commonly bought together report and targeted marketing reports can help identify marketing options.
  • Adjust purchase plan for future