Inventory aging measures how long a piece sits on your shelf before it sells, tracked through days sales in inventory, sometimes called average inventory age. A healthy range for most fashion jewelry falls between 60 and 90 days, so your first move is simple: run an aging report today and start working through the SKUs that have overstayed their welcome.
TL;DR:
- Jewelry categories like bridal and engagement typically have longer inventory ages, often around 12 to 18 months, unlike fashion jewelry, which aims for 60 to 90 days.
- Running an accurate aging report requires tracking SKU, received date, cost, retail price, vendor, and category, then sorting SKUs into aging buckets for focused action.
- Addressing aged inventory is more effective through operational improvements, such as cleaning and redisplaying pieces, rather than immediate price cuts.
- Using a price ladder and exploring secondary channels, wholesale lots, or consignment can recover cash without heavily damaging margins.
- Implementing vendor-synced virtual inventory reduces future aging risk by expanding assortment without increasing upfront stock investment.
Table of Contents
- Inventory aging defined for jewelry: DSI and category differences
- How to run an inventory aging report and read its signals
- Store playbook: tactics that move aged jewelry without gutting margin
- Pricing and accounting: when to mark down and how to document it
- Assortment and vendor levers to reduce future aging
- Metrics to track: turnover, GMROI, and realistic targets
- A 30/60/90 day plan to free up cash
- Balancing cash flow and margin when tackling aged inventory
- Lower your on-hand risk with vendor-synced inventory
- Sources
- FAQ
Inventory aging defined for jewelry: DSI and category differences
Days sales in inventory answers one question: at your current sales pace, how long would it take to sell through what you have right now? The formula is (Average Inventory Cost divided by Cost of Goods Sold) multiplied by 365. Say your average inventory cost is $500,000 and your annual cost of goods sold is $2,000,000. Divide the two, multiply by 365, and you land at roughly 91 days, meaning your typical piece takes about three months to sell.
That number means something different depending on what you sell. Fashion jewelry, the pieces bought on impulse or for a specific outfit, should move close to that 60 to 90 day window. Bridal and engagement pieces play by different rules entirely: buyers research for months, compare settings, and save before they commit, so a 12 to 18 month sell-through is common and not a red flag on its own.
The practical takeaway is that one benchmark will not work across your whole case. Build separate targets by category, track them separately, and judge your bridal case against bridal norms, not against how fast your charm bracelets move.
How to run an inventory aging report and read its signals
An aging report is only useful when it has the right fields and you know how to read them. At minimum, pull SKU, date received, unit cost, current retail price, days on hand, vendor, and category for every active item.
Once the export is in front of you, work it in order:
- Bucket every SKU into 0 to 30, 31 to 60, 61 to 90, and 90-plus days on hand.
- Sort each bucket by cost, so the dollars at risk rise to the top rather than getting lost among low-value stock.
- Flag consignment items and recent returns separately, since they distort true aging if counted the same as owned inventory.
- Prioritize the SKUs where both age and margin exposure are high: those are the ones tying up the most cash for the least return.
Data quality problems show up fast once you start this process. Point-of-sale numbers and accounting records often disagree, usually because a sale posted in one system before the other caught up, or because a SKU got renamed mid-season and now shows as two separate items. Reconcile received dates against vendor invoices before you trust the report, and reconcile counts monthly rather than quarterly, so small mismatches never compound into a report you cannot trust.
Store playbook: tactics that move aged jewelry without gutting margin
Once you know what is aged, the next question is what to do about it, and the honest answer is that price is your last lever, not your first. Operational fixes often outperform price cuts: a piece that looks tired sells slowly even at a fair price, while a piece that looks fresh can sell at full price simply because it was presented well.
- Get it ready to sell. Clean, polish, retag, and reshoot every aged piece before it goes back on the floor or online; a scratched setting or an outdated photo kills conversion before a shopper even asks the price.
- Redisplay with intent. Move aged pieces next to your best-sellers, build a seasonal case around them, or feature them as a limited-time spotlight so regular shoppers see them as new rather than leftover.
- Train your floor team to sell them. A spiff on aged SKUs, a short story about the piece’s design or stone origin, and a light sense of urgency (“this setting won’t be reordered”) all raise close rates without touching the tag price.
- Use a price ladder, not a single markdown. Start with a bundle offer or a VIP preview discount, then step down to a visible markdown only if the piece is still sitting after 60 to 90 days in that bucket.
- Move stubborn pieces to a different channel. Secondary marketplaces, consignment, estate and auction channels, or wholesale lots each recover cash differently: consignment preserves more margin but takes longer, while wholesale lots convert fast at the lowest recovery rate.
Pro Tip: Before marking anything down, try a bundle or a VIP preview sale first: you often recover more margin from a fresh presentation than from a price cut.
Pricing and accounting: when to mark down and how to document it
Retail accounting requires you to carry inventory at the lower of cost or market, meaning that once a piece’s realistic selling price drops below what you paid for it, your books need to reflect that, not the original cost. Aging inventory is exactly the kind of stock that triggers this adjustment, since a piece sitting for 18 months rarely commands its original retail price anymore.
You have two practical ways to record markdowns: as they happen, item by item, or in batches once management reviews and approves a bucket of aged stock. Neither is mandated by accounting standards, but whichever you choose, apply it consistently so your financials stay comparable month to month.
A workable set of thresholds by bucket: at 31 to 90 days, focus on merchandising and training rather than price. At 91 to 180 days, take a targeted markdown and record it. Past 180 days, consider liquidation or consignment rather than continuing to discount in place. Whatever you decide, document who approved each markdown and why: it protects your margin reporting and gives you a paper trail when you review buying decisions later.
Assortment and vendor levers to reduce future aging
Fixing today’s aged stock matters less than preventing next year’s. Buying discipline is where that starts:
- Set min and max stock levels by category so open-to-buy dollars do not quietly pile up in slow-moving lines.
- Allocate a fixed share of your budget to bridal versus fashion, based on your own turnover history rather than habit.
- Reorder on a frequency tied to actual sell-through, not a fixed calendar schedule.
Vendor terms matter just as much as your own discipline. When you negotiate with suppliers, ask directly about return windows, consignment options, buy-back terms, and markdown protection, where a vendor shares the cost if a piece needs to be discounted. These clauses shift some of the aging risk off your balance sheet and onto the relationship.
Vendor data sync and virtual inventory are a newer lever worth understanding on their own terms. Instead of buying physical stock upfront, a retailer displays a supplier’s catalog directly, sourced only once a customer commits to buy. This lowers the capital sitting on your shelves and lets you expand what you show shoppers without expanding what you own. JewelCloud is one platform built around this model, structuring vendor product data so it can sync into a retailer’s own catalog.
If you want to test this before committing broadly, run a 90-day pilot and measure four things: how much your assortment breadth grew, how much incremental sales came from the new SKUs, how much your average inventory days dropped, and how much working capital you freed up. Run the store and online channel numbers separately, since they rarely move at the same pace.
Metrics to track: turnover, GMROI, and realistic targets
Two numbers tell you whether your aging fixes are actually working. Inventory turnover is cost of goods sold divided by average inventory cost: for example, if your COGS is $2,000,000 and average inventory is $500,000, you turn your stock approximately four times a year.
GMROI, gross margin return on inventory investment, adds margin into the picture: gross margin dollars divided by average inventory cost at cost. A store with slower turns but higher margin per piece can still outperform a faster-turning competitor with thinner margins, which is why comparing raw turnover across different jewelry categories without adjusting for margin is misleading.
Realistic targets differ sharply by segment. Luxury and bridal jewelry commonly runs 0.7 to 2 turns a year, reflecting longer consideration cycles, while fashion jewelry should turn considerably faster. Track these numbers over several years rather than one season: a single slow year can reflect a deliberate inventory build or a seasonal dip, not a structural problem worth overreacting to.
A 30/60/90 day plan to free up cash
You do not need a full year to see progress. A focused quarter is usually enough to know if your changes are working.
- Days 1 to 30: Run your aging report, clean up data mismatches, pull your top 20 aged SKUs by cost, refresh their cleaning and display, and launch a sales spiff to get staff attention on them.
- Days 31 to 60: Apply targeted markdowns where the display refresh alone hasn’t worked, list eligible pieces on secondary channels, reach out to consignment or auction partners, and test a bundle offer on two or three aged categories.
- Days 61 to 90: Renegotiate vendor terms around returns and markdown protection, evaluate a small pilot of vendor-synced or virtual inventory, and set new min and max buying rules based on what the last quarter taught you.
Balancing cash flow and margin when tackling aged inventory
Aging inventory is not a one-time cleanup project, it is an ongoing discipline that rewards small, measured steps over dramatic overhauls. We have seen retailers get better results from testing one tactic on one category before rolling it out store-wide, because it protects margin while you learn what actually moves your specific customers.
The payoff goes beyond cash flow. A case that turns over at a healthy pace feels different to walk into, and a staff that is not constantly working around dead stock tends to sell with more confidence.
— Anthony
Lower your on-hand risk with vendor-synced inventory
A few places to start:
- Explore the JewelCloud® Product Feed to see how vendor catalogs sync into your store.
- Look at DiamondLink® if loose stones and diamond assortments are part of your aging problem.
- Compare the Jewelry Vendor Membership - Gold and Jewelry Vendor Membership - Silver tiers to find the right entry point for your store.
Request a walkthrough to see whether a vendor-synced pilot fits your next buying cycle.
Sources
The formulas, benchmarks, and accounting guidance above draw on Extensiv’s aging inventory analysis, Ambrook’s lower of cost or market explainer, and JCK’s reporting on aged jewelry inventory tactics.
FAQ
What does “inventory aging” mean?
Inventory aging refers to how long a piece of stock has sat unsold, typically measured in days on hand or through days sales in inventory. Retailers use it to spot slow-moving SKUs before they tie up too much cash.
What is the best app for jewelry inventory management?
There is no single tool that fits every store, since needs vary by catalog size and whether you sell online, in-store, or both. Platforms like JewelCloud focus specifically on vendor data syncing and virtual inventory for jewelers, which is worth considering if reducing physical stock risk is your priority.
How is inventory aging calculated?
The standard formula is average inventory cost divided by cost of goods sold, multiplied by 365, giving you average days on hand. Jewelry stores then compare that figure against category-specific targets, since bridal and fashion jewelry age at very different paces.
How do I inventory jewelry?
Start by recording each piece’s SKU, received date, cost, retail price, vendor, and category in a consistent system, whether a dedicated inventory platform or a well-structured spreadsheet. Reconcile those records against your point-of-sale system regularly so aging reports reflect what is actually on your shelves.