Product and stock metrics explained
How stock on hand, sell-through, dead stock and reorder needed are counted, and how every product is scored and placed in a tier: HERO to LIQUIDATE.
9 min readUpdated 4 November 2026
The Products pages show what you hold, what it is worth and what is selling through. Stock figures come from your Shopify catalogue and the stock changes Shopify sends; sales figures come from your orders, through the brand's Shopify data filters.
Before you start
- A connected Shopify store with stock tracked on your products.
- Product costs filled in on your products in Shopify for the figures valued at cost.
- The Products pages need a role that can view commerce and a plan that includes them (Growth or higher). Agency staff and brands covered by their agency's plan are never locked.
The figures
| Figure | How it is worked out |
|---|---|
| Units sold | Units on orders placed in the period. |
| Stock on hand | Units on hand across every variant whose stock level is known: the last catalogue sync, moved by each stock change Shopify has sent since. |
| Stock value | Units on hand times retail price, added across variants. |
| Average retail price | The average listed price across variants. |
| Sell-through | For each product, units sold divided by units sold plus units on hand, times 100, then averaged across products. |
| Out of stock | Products whose known stock is zero at the last sync. |
| Dead stock value | Stock at retail on products with stock on hand and no units sold in the period. |
| Overstock at cost | Stock at cost on lines with more weeks of cover than the brand's Overstock line (26 weeks, about 6 months, unless changed in Settings) at the period's rate of sale. Lines with no cost are counted but not valued. |
| Reorder needed | Products whose weeks of cover fall below the lead time in the brand's merchandising settings, among those selling at least 5 units in the period at a sell-through of 15% or more and a positive margin. |
A worked example
Fellwick's waxed jacket sold 60 units in the period and has 40 on hand. Sell-through for that product is 60 divided by 100 = 60%. Its 40 units at a retail price of 200 add 8,000 to stock value.
How products are scored and tiered
Every product gets a tier once a day. The tier says what to do next with ad spend; it is not a ranking of who sold most last month. Since 14 October 2026 every brand is scored by one engine with one set of weights, and you can open the same definitions in the app from Scoring guide on the Tiering page.
The tiers
| Tier | What it means | What earns it | What to do |
|---|---|---|---|
| HERO | Your top earners right now, with the stock in their key sizes to take more spend. | Taken in forward-score order, the fewest ready products that together cover 50% of the brand's positive daily contribution. | Give them the most spend and never let a key size run out. |
| GROWTH | Products that earn money and are ready to sell more: the next HEROs, and launches worth backing. | From the rest, ready products that earn money: the top 20% of active products by growth score (the forward score with 30% weight on stock headroom), plus ready products live for under 45 days. | Test more spend and watch them for HERO. |
| MAINTAIN | Products that sell steadily but are not top earners, or are not ready to scale yet. | Every other active product. A strong seller with key sizes out of stock sits here until they are back. | Keep listed at steady spend; restock key sizes before scaling. |
| LIQUIDATE | Products tying up stock and spend for little or no return. | The bottom 25% of active products with stock by forward score, and any product with stock whose contribution is zero or below. | Mark down, bundle or take out of paid channels. |
| DORMANT | Products in stock that have stopped selling and are not waiting for their season. | In stock, no sales in 90 days and live for 30 days or more. A product that sold in the same window last year is held in MAINTAIN instead. | No spend until it sells or its season starts. |
| EXCLUDE | Products that should not be in paid promotion at all. | Draft or archived; losing money on 5 or more units sold; or a return rate well above the brand's usual. | Keep out of paid promotion. |
| OOS | Products with nothing to sell in any size. | No stock in any size. When only some sizes are out, the product keeps its tier and each sold-out size is marked out of stock. | Pause spend until restocked. |
The forward score
Each input is ranked from 0 to 1 against your other active products, and the forward score is the weighted mean of those ranks. The weights are one set for every brand, fitted on every brand together against what products earned the following month. Weights are rounded to whole percentages.
| Input | Weight | What it measures | From |
|---|---|---|---|
| Contribution after costs | 31% | What the product earned over the last 90 days after cost of goods, refunds, payment fees and its own Google and Meta ad spend. | Shopify, Google Ads and Meta |
| Units in the last 30 days | 20% | What is selling now. | Shopify |
| Same season last year | 14% | Units sold in the coming 90 days' window, one year ago. It lifts seasonal products before their season. | Shopify |
| Newness | 9% | Days since the product first went live: newer ranks higher. | Shopify |
| Price | 8% | The typical selling price. Higher-priced products earn more per sale. | Shopify |
| Discount depth | 6% | Discounts as a share of full price over 90 days. Products that sell on promotion keep selling. | Shopify |
| Return rate | 5% | Units returned as a share of units sold. In fashion the most bought products are also the most returned, so this ranks higher; very high returns still exclude a product. | Shopify |
| Margin | 3% | Gross profit as a share of revenue over 90 days. | Shopify |
| Share to new customers | 1% | Share of its units bought by first-time customers. | Shopify |
| Google Shopping CTR | 1% | Clicks over impressions on its Google Shopping ads, from 100 impressions. | Google Ads |
| Momentum | 1% | Units in the last 30 days against the 60 days before. | Shopify |
Contribution is weighted by its evidence: a product's own 90 days are blended with 21 days at half the brand's typical product, so a product with three sales cannot look like a star.
The size gate and key sizes
A product can be HERO or GROWTH only when it is ready: in stock, with at least 40% of its sizes in stock, at least 2 weeks of stock at its rate of sale, and at least 50% of its key-size demand in stock.
A key size is a size that sells a large share of its style's units over the last 90 days; each colour or fit is its own style. Key-size demand in stock is the share of those key sizes' sales whose size has stock. A product with no size curve, such as a one-size accessory, is not held back by this rule. Across the brands studied, a product with a key size sold out converted about 30% worse per visit, so more spend on it buys visits that cannot convert.
Why tiers do not flip daily
A tag that changed every day would reshuffle product sets and campaigns before any spend change had time to work. So a product moves between HERO, GROWTH, MAINTAIN, LIQUIDATE and DORMANT only after its new tier has held for 3 daily scores in a row, and only after at least 14 days in its current tier. Out of stock and EXCLUDE apply at once.
What changed on 14 October 2026
- Before, a product's tag came from one figure, its profit over 90 days, with stock rules that counted every size the same.
- Now one forward score ranks every product on 11 inputs, with one set of weights for every brand.
- Contribution now comes after each product's own Google and Meta ad spend.
- HERO and GROWTH need the sizes that sell: at least 50% of key-size demand in stock.
- In the first 7 days, at most 25% of a brand's products change tier on any day, so campaigns move over gradually.
A worked example: tiers
Fellwick's waxed jacket earned well over 90 days and ranks near the top of the forward score, but its M and L, which take most of its sales, have sold out. Only 30% of its key-size demand is in stock, so it cannot be HERO or GROWTH and sits in MAINTAIN. When the M and L are restocked it becomes ready, and moves up once the new tier has held for three days.
Step by step: find them
- Open the brand and choose Products. The Overview's tiles show units sold, sell-through, stock value, reorder needed and dead stock value, with their change since the nightly stock snapshots began.
- Choose Stock for the Reorder, Dead stock and Capital tied up lists.
- Choose Sizes to see how each size is selling.
- Choose Catalogue to open any product's record.
- Choose Tiering for each product's tier, and Scoring guide there for these definitions.
Troubleshooting
- Stock looks wrong for a product. Check the product tracks stock in Shopify. Products Shopify does not track are left out of stock figures.
- Overstock shows lines but no value. Those lines have no unit cost in Shopify. Add costs in Shopify and they are valued on the next sync.