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. |
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.
Comments
0 comments
Please sign in to leave a comment.