Help Center

Understanding the Aged Inventory Report

Sarah Barr
Sarah Barr
  • Updated

Retail ORBIT® Knowledge Base · Custom Reports

Understanding the Aged Inventory Report

See how long every item has been in your store, find the goods that need to move, and act before old stock ties up your cash.

 

What this report does

The Aged Inventory report lists everything you have on hand right now and shows how long it has been sitting, based on when you actually received it (not when the item was created in your POS). Products are listed oldest first, so the goods that most need attention are at the top.

Each row is a product (style). If the style has more than one size or color, click the arrow next to the name to see each SKU on its own row.

Use it to:

  • Build your markdown and promotion lists (for example, a Black Friday push on goods over 90 days old)
  • Find classes or vendors where inventory is building up and not selling
  • Spot items that have never sold since they arrived
  • Check whether inventory a report says you have is really on the floor

Where to find it

In Retail ORBIT, go to Reports → Custom Reports tab → click the Aged Inventory card.

The report is available for clients connected through Shopify, Lightspeed X, NetSuite and Heartland Retail. It's part of the SKU / Vendor report series, alongside Vendor Performance Analysis, Top Sellers & Item Performance, and Core Item Replenishment.

Reading the report

Key columns

Column What it tells you
Product The style name. Badges flag items that have Never sold and items tagged as Core; a reorder icon marks items tagged for reorder.
Vendor · Class · Size · Color Where the item sits in your business. On a style row, Size shows how many sizes there are (for example "3 sizes").
Units OH Units on hand today.
Retail Value OH · Cost Value OH What that on-hand stock is worth at retail and at cost.
First Received The first time you received this item. Tells you how long you've carried the product overall, even if you've restocked it along the way.
Last Received The most recent time you received it. Tells you how old your newest shipment is, which is usually the more useful date for markdown decisions.
Days on Hand How many days the item has been in your store, colored by its aging tier. On a style row, this is the age of its oldest size or color.
Units Sold (90d) Units sold in the last 90 days.
Sell-Through % Units sold in the last 90 days ÷ (units sold in the last 90 days + units on hand). A low number on an old item is a strong markdown signal.
Aging Tier The age band the item falls in (see below).

Aging tiers

Tier Days on hand
Green 0–90 days: fresh goods
Blue 91–180 days
Amber 181–365 days
Red Over 365 days

Items with no age

If Retail ORBIT has no receive date for an item, its First Received, Last Received and Days on Hand are blank, and the item is listed at the bottom of the report. These items aren't necessarily new. Usually the receiving history simply wasn't recorded in your POS (common for stock that arrived before your POS tracked receiving).

Filters and controls

Control Use it to…
Location · Class · Vendor · Category Narrow the report to one store, department or vendor. Each works the same way it does in Vendor Performance Analysis.
Age threshold Show only items older than a set age, for example everything 90+ days.
Aging tier Show one tier only, for example just the red 365+ items.
Zero-selling only Show only items that haven't sold in the last 90 days.
Exclude core/reorder Hide items tagged as core, basic, basics or reorder in your product catalog. These are stock you keep on purpose, so hiding them leaves the true aged goods.
Search · Columns · Save view · Export CSV Find an item, choose which columns appear, save your setup to reuse, or download what's on screen.

Active filters show as chips above the table. Click a chip's × to remove it, or Clear all to start over.

Step by step: build a markdown list

01 Open the report from Reports → Custom Reports → Aged Inventory.
02 Pick your scope. Filter to a location, class or vendor if you want to work one area at a time.
03 Turn on Exclude core/reorder so the basics you always carry don't crowd the list.
04 Set an Age threshold, such as 90+ days. If you turn your goods quickly, use a shorter threshold.
05 Sort by Sell-Through % (lowest first) or turn on Zero-selling only to find the items that are stuck.
06 Expand styles to see which sizes and colors are left.
07 Save the view so you can run the same list again next week, and Export CSV to share it with your team or mark up your price changes.
Tip: Make this a weekly routine. Run your saved view, mark down what's aged past your threshold, and clear it before it moves into the next tier. Older goods are harder to sell and tie up open-to-buy you could spend on fresh product.
Tip: Use Last Received for markdown decisions. An item you first received two years ago but restocked last month isn't really aged. First Received is better for deciding whether a product line has run its course.

Related reports

  • Top Sellers & Item Performance: what's selling, down to size and color
  • Vendor Performance Analysis: how each vendor's share of sales compares with its share of inventory
  • Core Item Replenishment: keeps the items you always carry in stock

Questions? Contact your M1 Advisor or Retail ORBIT Support.

© ManagementONE® · Retail ORBIT® Powered by Management One

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.