Twelve inventory metrics carry real decisions for an independent retailer, and each ends in a buy, hold, mark down, or liquidate call. The first six are sell-through rate, weeks of supply, days on hand, dead stock ratio, cash-at-risk, and inventory turnover. The rest are GMROI, stock-to-sales ratio, markdown rate, in-stock rate, shrink rate, and carrying cost.
Key Takeaways
- Sell-through rate is units sold divided by units received in a window. It answers whether a delivery worked before the season ends.
- Weeks of supply is on-hand units divided by average weekly units sold, and it decides whether the next purchase order gets written.
- Dead stock ratio is the cost value of SKUs with zero sales divided by total on-hand cost value, expressed as a percentage.
- Cash-at-risk is the dollar value of inventory forecast not to sell inside the measured window. It caps the margin a retailer can spend to move goods.
- Clothing and clothing accessory stores carried an inventories-to-sales ratio of 2.11 in May 2026, per Census data published by the St. Louis Fed. All retail stood at 1.25.
- Shopify, Square for Retail, and Lightspeed Retail X-Series each compute sell-through and days of cover natively. None computes GMROI, dead stock ratio, or carrying cost.
The Short Answer: Twelve Numbers, Each Attached to a Decision
An inventory metric earns its place when a specific number changes what an owner does on Monday. Twelve clear that bar for independent retail. The rest are reporting garnish.
Most inventory reporting fails the same way, producing a number nobody converts into an order or a price. A sell-through rate of 38% means nothing alone. Sitting next to eleven weeks of season and 44 units on hand, it means cancel the reorder and step the price.
Cash Margin Partners is an inventory cash-recovery practice for independent, owner-operated retailers. CMP directly produces SKU classifications, bucket cost basis, days of supply or cover where supported, cash-at-risk evidence, category and vendor breakdowns, and ranked actions. Pull or calculate the other metrics below from point-of-sale reports.
The back room is where these numbers live before they reach a P&L. Every metric here points at that same room, measuring what entered it, what it costs per month, and what gets it out.
You can size the room before reading further. The free CMP workspace can return a trapped-cash figure after a successful supported import with sufficient sales and cost evidence, with no credit card and no trial clock.
The 12 Inventory Metrics That Matter for Independent Retailers
Each entry gives the formula, the benchmark, and the decision it forces. Each also names where the inputs live in Shopify, Square, and Lightspeed Retail X-Series.
1. Sell-Through Rate: Did This Delivery Work?
Sell-through rate is the share of units received that sold in a period. It's the single most useful inventory number an independent retailer owns.
Formula: (Units sold ÷ Units received) × 100, per SKU, per delivery, or per category.
Where the inputs live: Shopify's Products by sell-through rate report computes it directly, per Shopify's inventory reports documentation. Square for Retail Plus and Premium subscribers find it under Reports, Inventory Reports, Inventory Sell-through, per Square's support article. Lightspeed Retail X-Series puts it on the Sell through tab of Inventory reports.
What good looks like: for seasonal apparel and accessories, 60% to 70% by week eight of a twelve-week window. Basics read lower per delivery because the same SKU reorders repeatedly.
The decision it drives: reorder, hold, or step the price. Take an illustrative boutique that received 60 units of a $48 tee in March and sold 26 by week eight. That's 43% with four weeks of season left, so the reorder gets cancelled and the first markdown step gets a date.
2. Weeks of Supply: How Long Until This Runs Out?
Weeks of supply is on-hand units divided by average weekly units sold. The metric converts a pile of stock into a length of time. Lightspeed and Square publish the same figure in days, as days cover.
Formula: On-hand units ÷ Average weekly units sold. Multiply by seven for days of cover.
Where the inputs live: Shopify's Inventory remaining per product report estimates how long tracked stock will last at current sales rates. Lightspeed Retail X-Series shows Days cover as a column on its inventory performance report. Square users build it from Inventory Sell-through plus current stock counts.
What good looks like: 8 to 12 weeks in season for fashion goods, 4 to 8 for fast-moving consumables. Anything past 26 weeks joins the dead stock list before it technically qualifies.
The decision it drives: whether to write the next purchase order. A store selling 3 units a week with 61 candles on hand has 20 weeks of supply. The fall order for that SKU goes to zero.
Operator Tip
Calculate weeks of supply on a trailing 8-week average, never a trailing 52-week one. A 52-week average hides seasonality and tells a swimwear buyer in September that everything looks fine.
3. Days on Hand and Inventory Aging: How Old Is the Money?
Days on hand counts the days a unit has sat in the store since it was received. The useful form is a bucket distribution rather than a single average. Four buckets cover independent retail: 0 to 60 days, 61 to 120, 121 to 180, and 181 or more.
Formula: Today's date minus date received, per unit on hand, grouped into buckets, with the cost value of each bucket totalled.
Where the inputs live: Square publishes an aging inventory report inside its retail reporting set. Lightspeed Retail X-Series carries last sale date and last received date on the dusty inventory report. Shopify users pull received dates from purchase order or transfer records.
What good looks like: 70% or more of inventory cost value inside the 0 to 120 day buckets for seasonal retail. A 181-plus bucket above 15% of inventory value is where an owner stops reading reports and starts pricing.
The decision it drives: which SKUs enter this month's markdown ladder. Aging beats sell-through for that call, because a SKU can post respectable sell-through while its remaining units turn eight months old.
4. Dead Stock Ratio: What Share of Your Inventory Sold Nothing?
Dead stock ratio is the cost value of zero-sale SKUs divided by total on-hand inventory at cost. Dead stock is inventory with no verified sales history over the measured window, so the window definition carries the argument.
Formula: (Cost value of zero-sale SKUs ÷ Total on-hand inventory at cost) × 100, with the window stated.
Where the inputs live: every platform exports a 12-month sales-by-SKU file joined to on-hand quantity and unit cost. Square's sell-through report needs an item sold or adjusted in the last 365 days to generate. A true zero-sale SKU drops out of that view and needs a catalog export.
What good looks like: under 5% of inventory cost value in a 90-day window for a well-run specialty store. Past 12% in a 12-month window, the buying pattern needs work before any recovery tactic holds.
The decision it drives: how much of next season's buying budget is already committed to goods on the floor. Our breakdown of what dead stock is in retail covers where the window boundaries belong by category.
5. Cash-at-Risk: How Many Dollars Are Forecast Not to Sell?
Cash-at-risk is the dollar value of inventory a model forecasts won't sell inside the measured window. It's the one metric here stated in money rather than ratios. The figure caps what an owner can spend in margin to move the goods.
Formula: Σ (On-hand units × Unit cost) across every SKU the forecast flags, over a stated window.
Where the inputs live: unit cost plus enough order history to cover the chosen window. Provider exports and syncs vary in history depth and field completeness. The Cash Margin Partners integrations page lists supported inputs; direct availability depends on production launch status and workspace eligibility.
What good looks like: lower than you expect, which is rare. No published benchmark exists at independent-retail scale, so compare against your own prior quarter.
The decision it drives: the size of the recovery effort and its urgency. A forecast is a forecast, so treat the number as what the model projects, and re-run it monthly.
Key Insight
Cash-at-risk changes owner behavior faster than any ratio here, because ratios argue and dollars don't. A 38% sell-through rate invites a conversation about whether the season was slow. "$41,000 across 312 SKUs with zero sales in 11 months" ends it. The free calculator gives a directional benchmark from a short questionnaire.
Create a free workspace for an eligible-SKU analysis after a successful supported import with sufficient store history and cost evidence.
6. Inventory Turnover: How Many Times Did the Money Cycle?
Inventory turnover counts how many times a store sold and replaced its average inventory during a period. The calculation is cost of goods sold divided by average inventory at cost. Category-level turnover earns its keep; the store-level version rarely does.
Formula: Cost of goods sold ÷ Average inventory at cost, where average inventory is beginning plus ending, divided by two.
Where the inputs live: Square's cost of goods sold report requires Square for Retail Plus or Premium, per Square's documentation. Shopify's Month-end inventory value report supplies the average inventory side.
What good looks like: apparel boutiques commonly plan to 3 to 4 turns a year. Gift and home goods plan to 2 to 3, and consumables run higher. Compare a category against its own prior year first.
The decision it drives: category-level buy weighting for next season. Our guide to how to calculate inventory turnover in 6 steps works the full calculation. It also covers the average inventory trap that inflates the result.
7. GMROI: How Many Margin Dollars Did Each Inventory Dollar Return?
GMROI is gross margin dollars divided by average inventory cost. The metric catches the fast-moving category that sells at a discount too deep to pay for its own shelf. Turnover rewards speed at any margin, and GMROI applies the price test that turnover skips.
Formula: Gross margin dollars ÷ Average inventory at cost. A result of 2.40 means each inventory dollar returned $2.40 in gross margin.
Where the inputs live: gross profit sits on Lightspeed Retail X-Series's inventory performance report by product, category, brand, or supplier. Square's cost of goods sold report shows revenue, profit, and profit margin together.
What good looks like: a working floor of 2.00 for most independent specialty categories, with apparel often running 2.00 to 3.00. Below 1.00, a category consumed more inventory dollars than it returned in margin.
The decision it drives: which categories get more open-to-buy dollars and which get cut. Our retailer's definition of GMROI covers the vendor-level and season-level versions.
Key Data Point
U.S. retailers held $832.4 billion in inventories in May 2026, against retail sales of $664.4 billion, per the Census Bureau's Monthly Trade Survey. That's an inventories-to-sales ratio of 1.25 for all retail, while clothing and clothing accessory stores ran 2.11. Two months of stock sat on the floor.
8. Stock-to-Sales Ratio: How Much Stock Does This Month Need?
Stock-to-sales ratio is beginning-of-month inventory at retail divided by that month's sales at retail. A ratio of 3.0 means the store opened the month holding three months of stock at that month's selling rate.
Formula: Beginning-of-month inventory at retail ÷ Sales at retail for that month.
Where the inputs live: Shopify's Month-end inventory snapshot report gives the beginning-of-month position by variant. Square and Lightspeed Retail X-Series both report closing inventory by period, which becomes the next month's opening figure.
What good looks like: 2.5 to 4.0 for apparel boutiques. Set it highest at the start of a season and lowest in the month before clearance. The sector figure of 2.11 for clothing stores is a national aggregate, so treat it as context.
The decision it drives: the monthly open-to-buy figure, since planned end-of-month inventory falls out of the ratio. Our list of 10 open-to-buy mistakes that drain retail cash covers the ratio errors that break a buying plan in month three.
9. Markdown Rate: What Did You Pay to Fix the Buy?
Markdown rate is total markdown dollars divided by net sales, expressed as a percentage. It prices the gap between what you bought and what customers wanted.
Formula: (Total markdown dollars ÷ Net sales) × 100, measured monthly and by category.
Where the inputs live: Shopify's discount and sales reports carry the discount total by order and by product. Square reports discounts inside its sales reporting, and Lightspeed Retail X-Series shows discount totals by outlet and product.
What good looks like: a planned markdown rate, whatever the number is. Independent apparel commonly plans 12% to 20% and lands higher, while hard goods and gift plan far lower.
The decision it drives: whether the buying calendar or the pricing calendar needs the fix. A markdown rate climbing while sell-through stays flat points at the buy, since deeper discounts are moving no additional units.
10. In-Stock Rate on Your Top Sellers: What Did the Empty Shelf Cost?
In-stock rate is the share of days a SKU was available for sale during a period. Measure it on the top 20 SKUs by gross margin dollars. It's the only metric here that counts sales a store gave up.
Formula: (Days in stock ÷ Days in period) × 100, on the top 20 SKUs by gross margin contribution.
Where the inputs live: Lightspeed Retail X-Series publishes an inventory replenishment report that flags stock needing reorder. Shopify's ABC product analysis report identifies the A-grade variants worth protecting, covering the top 80% of revenue.
What good looks like: 95% or better on the top 20. Below 90% on an A-grade SKU, the reorder point is set wrong or the lead time estimate is stale.
The decision it drives: reorder points on the handful of items that pay the rent. Take a gift shop whose best-selling $34 candle was out 19 days of a 90-day quarter. At 79% in-stock and 2.4 units a day, the model projects roughly 46 lost unit sales.
Store Example
Take an illustrative 1,400-square-foot home goods store running Square, with $9,200 monthly rent and $186,000 in inventory at cost. Its 181-plus day aging bucket holds $37,200, or 20% of inventory value.
At the same time, in-stock rate on its top 20 SKUs sits at 88%. Short on the winners and deep on the rest is the ordinary shape of an independent retail cash problem.
11. Shrink Rate: What Left Without Being Sold?
Shrink rate is the difference between recorded inventory value and counted inventory value, divided by net sales, expressed as a percentage. Shrink covers theft, damage, receiving errors, and miscounts, and the last three dominate in independent retail.
Formula: ((Book inventory value minus counted inventory value) ÷ Net sales) × 100.
Where the inputs live: Square's cost of goods sold report filters by stock action type, including losses, damages, and theft. Shopify's Inventory adjustment changes report logs every manual change, transfer, and app adjustment. Lightspeed Retail X-Series records variances against stocktakes.
What good looks like: the last published National Retail Security Survey put shrink at 1.6% of sales in FY 2022, per the National Retail Federation. The NRF has since paused that annual report, as Retail Dive reported in 2024. Treat 1.6% as the last national reference point.
The decision it drives: counting cadence and receiving discipline. A shrink rate above 2% with no theft evidence usually means goods are received into the system incorrectly. That corrupts every other metric here.
12. Inventory Carrying Cost: What Does the Back Room Charge Per Month?
Inventory carrying cost is the annual cost of holding stock, expressed as a percentage of average inventory value. The figure puts a monthly rent on unsold goods. Storage, insurance, financing, shrink, and obsolescence all belong in the numerator.
Formula: ((Storage + Insurance + Financing + Shrink + Obsolescence) ÷ Average inventory value) × 100 per year.
Where the inputs live: your lease, your insurance declaration, and your line of credit statement, joined to average inventory value. No point-of-sale system computes this one.
What good looks like: a number you can state out loud. Build it from your own line items rather than a published percentage. Rent per square foot varies more between two towns than two industries.
The decision it drives: how long you can afford to hold before liquidating. Take a store paying $9,200 monthly rent across 1,400 square feet. Its 260-square-foot stockroom holds $37,200 in aged goods, carrying about $1,710 of rent a month by footage alone.
Key Data Point
Financing is the expensive alternative to fixing these numbers. The Federal Reserve Banks' 2026 Report on Employer Firms found that 42% of applicants received the full financing they sought. The same report, from 6,525 responses, named retail the sector hit hardest by tariff-related cost increases, at 69%.
How to Prioritize These 12 Metrics for Your Store
Prioritize by the size of the decision each metric unblocks, then by how often that decision comes up. A metric tied to a weekly reorder call outranks one tied to an annual category review.
Your Dashboard Shows Twelve Numbers. Your Week Has Room for Three.
Three metrics reviewed weekly beat twelve reviewed once a quarter. The standing set for a single-location independent store is sell-through rate by category, weeks of supply by SKU, and dead stock ratio.
Those three cover the buy, the reorder, and the cleanup. Add a fourth when a problem earns it. In-stock rate covers missing sales, markdown rate covers slipping margin, and shrink rate follows a bad count.
Which Metrics Are Overrated for a Single-Location Store
Store-level inventory turnover is the most quoted and least useful number in independent retail. One blended figure across a store carrying candles, greeting cards, and $400 outerwear averages four businesses into a number that recommends nothing. Sales per square foot has the same defect, and both become useful only when cut by category.
The reverse holds for aging. Inventory aging buckets rarely appear on best-practice KPI lists. They produce the fastest cash decisions of anything here, because they name specific SKUs and specific dollars.
Where the Numbers Come From Once You Stop Maintaining a Spreadsheet
Cash Margin Partners directly produces SKU classifications, bucket cost basis, days of supply or cover where supported, cash-at-risk evidence, category and vendor breakdowns, and ranked actions. Pull or calculate sell-through, receipt aging, dead stock ratio, and the other named metrics from point-of-sale reports.
"Another dashboard I'll check twice and forget?" The check that matters takes four minutes a month, because the output is a ranked SKU list with dollar figures.
CMP classifies eligible SKUs as dead stock, slow mover, overstock, stockout risk, healthy active, or Data Incomplete. After a recent successful supported live connection has supplied sufficient usable history and cost evidence, 30/60/90-day forecasts, stockout timing, and confidence bands can be included in the free workspace.
Whatever tool you pick, save the three standing reports with the date range pre-set. Our roundup of the 7 Best Shopify Inventory Report Apps covers the in-platform options.
Start Here: Four Steps You Can Run This Week
- Request a sales-by-SKU export covering the review window. Provider fields, history depth, plan requirements, and preparation time vary. Confirm the file is sufficient for each metric before relying on it.
- Calculate dead stock ratio first. Total the cost value of every SKU with zero units sold in 12 months, then divide by total on-hand inventory at cost. One number, one afternoon.
- Bucket everything on hand by days since received. Use 0 to 60, 61 to 120, 121 to 180, and 181-plus, and total the cost value in each bucket. The last bucket is your markdown list.
- Create a free workspace and connect a supported source or upload compatible item-level files. CMP returns SKU classifications, bucket cost basis, days of supply or cover where supported, and cash-at-risk evidence; calculate sell-through and receipt aging from point-of-sale reports.
Step two is the one owners skip, and it's the one that changes behavior. A dead stock ratio of 3% is a rounding error, and 18% is next season's buying budget sitting in the back room.
Apparel stores carry a harder version of this, because size and color break the SKU count wide open. Our comparison of the 7 Best Inventory Tools for Apparel Stores covers tools built for that structure.
All 12 Inventory Metrics Compared: Formula, Benchmark, and Decision
| # | Metric | Formula | What good looks like | The decision it drives |
|---|---|---|---|---|
| 1 | Sell-through rate | (Units sold ÷ Units received) × 100 | 60% to 70% by week 8 of a 12-week season | Reorder, hold, or step the price |
| 2 | Weeks of supply | On-hand units ÷ Average weekly units sold | 8 to 12 weeks in season for fashion goods | Write or cancel the next purchase order |
| 3 | Days on hand and aging | Today's date minus date received, in buckets | 70%+ of cost value inside 0 to 120 days | Which SKUs enter this month's markdown ladder |
| 4 | Dead stock ratio | (Zero-sale SKU cost ÷ Total inventory cost) × 100 | Under 5% in a 90-day window | How much of next season's budget is spent |
| 5 | Cash-at-risk | Σ (On-hand units × Unit cost) for forecast non-sellers | Lower than the owner's estimate | Size and urgency of the recovery effort |
| 6 | Inventory turnover | Cost of goods sold ÷ Average inventory at cost | 3 to 4 turns a year for apparel, by category | Category-level buy weighting |
| 7 | GMROI | Gross margin dollars ÷ Average inventory at cost | A working floor of 2.00 by category | Which categories gain or lose open-to-buy dollars |
| 8 | Stock-to-sales ratio | BOM inventory at retail ÷ Sales at retail that month | 2.5 to 4.0 for apparel boutiques | The monthly open-to-buy figure |
| 9 | Markdown rate | (Total markdown dollars ÷ Net sales) × 100 | A planned rate you set in advance | Whether the buy or the pricing needs fixing |
| 10 | In-stock rate, top 20 SKUs | (Days in stock ÷ Days in period) × 100 | 95% or better on top margin contributors | Reorder points and safety stock |
| 11 | Shrink rate | ((Book value minus counted value) ÷ Net sales) × 100 | 1.6% of sales was the last national reference | Counting cadence and receiving discipline |
| 12 | Carrying cost | (Holding costs ÷ Average inventory value) × 100 | A figure built from your own line items | How long you can hold before liquidating |
Read the decision column before the benchmark column, because aged goods keep charging rent while you research a benchmark. When the decision lands on liquidation, our list of 7 Best Closeout Buyers for Independent Retailers covers the exit channels.
Frequently Asked Questions
What are the most important inventory KPIs for a small retail store?
The three inventory KPIs that move a single-location retailer's cash fastest are sell-through rate, weeks of supply, and dead stock ratio. Sell-through says whether the buy worked, and weeks of supply says whether to write the next order. Dead stock ratio says how much of the buying budget is already spent.
How often should an independent retailer review inventory metrics?
Review weeks of supply and in-stock rate weekly, sell-through and markdown rate monthly, and dead stock ratio, GMROI, and carrying cost quarterly. A weekly review takes about fifteen minutes once the reports are saved. Shrink rate follows the physical count schedule, which for most independent stores means twice a year with rolling cycle counts in between.
What is a good sell-through rate for a retail store?
For seasonal apparel and accessories, roughly 60 to 70 percent sell-through by week eight of a twelve-week selling window reads healthy. Basics and replenishment goods run lower per delivery because the same SKU keeps reordering. A sell-through rate below 30 percent at a season's halfway mark calls for a price step or a better floor position.
Can I calculate inventory metrics in Shopify, Square, or Lightspeed without extra software?
Shopify, Square for Retail, and Lightspeed Retail X-Series each compute sell-through rate and days of cover natively, depending on plan. None of the three computes GMROI, dead stock ratio as a share of inventory value, or carrying cost. Those need a spreadsheet or an outside tool that joins unit cost to a full year of sales history.
What is the difference between inventory turnover and GMROI?
Inventory turnover is cost of goods sold divided by average inventory at cost, counting how many times a store replaced its stock. GMROI is gross margin dollars divided by average inventory cost, measuring what each inventory dollar returned in margin. Turnover rewards speed at any margin, and GMROI catches the fast category discounted too deep to pay the rent.
Which inventory metric shows how much cash is trapped in stock?
Cash-at-risk is the metric that puts a dollar figure on trapped inventory, defined as stock forecast not to sell in a window. The calculation multiplies on-hand units by unit cost for eligible SKUs the model flags, then totals it; new or insufficiently evidenced items remain Data Incomplete. Cash Margin Partners can produce the figure after a successful supported import. Direct provider availability depends on production launch status and workspace eligibility, and compatible item-level uploads remain available after column review.
Run Three of Them This Week and Let the Numbers Pick the Fight
Inventory metrics stop being homework the moment each one carries a dollar figure and a date. Sell-through, weeks of supply, and dead stock ratio tell you more in one afternoon than a year of gut-feel decisions did.
Cash Margin Partners organizes the SKU classifications, bucket cost basis, cash-at-risk evidence, category and vendor breakdowns, and ranked actions. Use the free calculator for a directional questionnaire-based benchmark, then create a free workspace for connected analysis grounded in your own history.
Then go count what's in the back room and check whether the report agrees with you.