Learn how to run an Aged Inventory Report in CommentSold to identify slow-moving inventory and view inventory costs by size, brand, collection, and age.
The Aged Inventory Report shows the cost value of your inventory based on how long products have been posted. Use it to identify slow-moving inventory, evaluate purchasing decisions, and determine which products may need promotions or price reductions.
Use the table of contents below to navigate to specific sections of this article:
- What Is the Aged Inventory Report
- How Can I Use the Aged Inventory Report
- Run an Aged Inventory Report
- Examine the Aged Inventory Report
- FAQs
What Is the Aged Inventory Report?
The Aged Inventory Report helps you understand how quickly your inventory is moving by showing inventory values across different age ranges.
You can group inventory by:
- Sizes: Compare inventory costs across sizes to identify slow- or fast-moving sizes and purchasing patterns.
- Brands: Identify brands with fast-moving inventory and brands with slower sales.
- Collections: Find collections with older or slow-moving inventory, such as Tops, Home, or Fall.
The report focuses on the financial value of your inventory, rather than simply showing product quantities.
How Can I Use the Aged Inventory Report?
Use the report to:
- Identify slow-moving inventory that may need promotions or price reductions.
- Find fast-moving products that may be good candidates for repurchasing.
- Evaluate purchasing decisions based on how quickly products sell.
- Reduce the cost of holding slow-moving inventory.
- Identify older inventory by brand, size, or collection.
For slow-moving products, retailers can take advantage of CommentSold features like mystery items, secondary offers, and collection-specific coupons to help sell the inventory.
Run an Aged Inventory Report
- Select Reporting in the side menu of your CommentSold dashboard.
- Select Inventory from the report options listed at the top of the page.
- Scroll to Aged Inventory drop-down and expand to view the report.
- Choose Sizes or Brands to change the grouping of products on the report.
Examine the Aged Inventory Report
Rather than emphasizing product quantities, the Aged Inventory report helps retailers like you focus on their financial investment. That's why you'll see dollar values listed in the report.
- Never Posted. Displays the total cost of products you have never posted by their brand, size, or collection.
- Scheduled. Displays the total cost of products you have scheduled but not yet posted by their brand, size, or collection.
- 0-30 Days. Displays the total cost of products you posted in the last 30 days by their brand, size, or collection.
- 31- 60 Days. Displays the total cost of products you first posted 31 to 60 days ago by their brand, size, or collection.
- 61- 90 Days. Displays the total cost of products you first posted 61 to 90 days ago by their brand, size, or collection.
- Over 90 Days. Displays the total cost of products you first posted 90 or more days ago by their brand, size, or collection.
FAQs
What does the Aged Inventory Report show?
It shows the cost value of inventory based on how long products have been posted. You can group the data by size, brand, or collection.
How do I run an Aged Inventory Report in CommentSold?
Go to Reporting > Aged Inventory, then choose Sizes, Brands, or Collections to organize the report.
What does 90+ Days mean in the Aged Inventory Report?
90+ Days represents the total cost of products that were first posted 90 or more days ago.
What does Never Posted mean?
Never Posted represents the total cost of products that have never been posted, grouped according to the selected report view.
What is the difference between Scheduled and Never Posted?
Scheduled inventory consists of products that are scheduled but have not yet been posted. Never Posted inventory consists of products that have not been posted.
Can I see the products included in an inventory value?
Yes. Select a hyperlinked value in the report to view the products included in that figure.
How can I use aged inventory data to improve purchasing?
Review older and slower-moving inventory by brand, size, and collection to identify purchasing patterns. You can use this information to make more informed decisions about which products to reorder and which inventory to reduce.