Skip to content
Help centre

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

FigureHow it is worked out
Units soldUnits on orders placed in the period.
Stock on handUnits on hand across every variant whose stock level is known: the last catalogue sync, moved by each stock change Shopify has sent since.
Stock valueUnits on hand times retail price, added across variants.
Average retail priceThe average listed price across variants.
Sell-throughFor each product, units sold divided by units sold plus units on hand, times 100, then averaged across products.
Out of stockProducts whose known stock is zero at the last sync.
Dead stock valueStock at retail on products with stock on hand and no units sold in the period.
Overstock at costStock 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 neededProducts 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

TierWhat it meansWhat earns itWhat to do
HEROYour 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.
GROWTHProducts 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.
MAINTAINProducts 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.
LIQUIDATEProducts 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.
DORMANTProducts 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.
EXCLUDEProducts 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.
OOSProducts 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.

InputWeightWhat it measuresFrom
Contribution after costs31%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 days20%What is selling now.Shopify
Same season last year14%Units sold in the coming 90 days' window, one year ago. It lifts seasonal products before their season.Shopify
Newness9%Days since the product first went live: newer ranks higher.Shopify
Price8%The typical selling price. Higher-priced products earn more per sale.Shopify
Discount depth6%Discounts as a share of full price over 90 days. Products that sell on promotion keep selling.Shopify
Return rate5%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
Margin3%Gross profit as a share of revenue over 90 days.Shopify
Share to new customers1%Share of its units bought by first-time customers.Shopify
Google Shopping CTR1%Clicks over impressions on its Google Shopping ads, from 100 impressions.Google Ads
Momentum1%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

  1. 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.
  2. Choose Stock for the Reorder, Dead stock and Capital tied up lists.
  3. Choose Sizes to see how each size is selling.
  4. Choose Catalogue to open any product's record.
  5. 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.

Frequently asked questions

Is stock value at cost or at retail?

At retail. Stock value is units on hand times each variant's retail price. Overstock at cost is the one stock figure valued at cost.

Why are some products missing from sell-through?

Products whose stock Shopify does not track are left out, because with no stock level they would always read as 100% sold through.

How does Fabrik decide a product needs reordering?

A product needs reordering when its weeks of cover fall below the lead time in the brand's merchandising settings, and it sold at least 5 units in the period at a sell-through of 15% or more with a positive margin.

How up to date is stock on hand?

It starts from the last catalogue sync and moves with every stock change Shopify sends after it, so it is close to live.

Why do the stock tiles show no change?

Change needs a daily snapshot of stock from the comparison date. Snapshots are taken every night, so a change appears once there is a snapshot for the earlier date.

Why is my best seller in MAINTAIN and not HERO?

Most often a key size has sold out. HERO and GROWTH need at least half of a product's key-size demand in stock, because a product missing its key sizes converts far worse. It moves up once those sizes are back and the new tier has held for three days.

Why did a product not change tier when its sales jumped?

Tiers change slowly on purpose. A product moves only after its new tier holds for 3 daily scores in a row, and only after at least 14 days in its current tier, so product sets and campaigns are not reshuffled every day.

Are the scoring weights different for my brand?

No. Every brand is scored by one engine with one set of weights, fitted on every brand together. Each input is ranked within your own catalogue, so the same weights mean the same thing at every brand.

Is product revenue with or without VAT?

Without. Since 14 October 2026 every product figure, the tier inputs included, uses the line's net sales as Shopify counts them: VAT and duties out, discounts taken off, refunds valued at the goods refunded without tax. A product's revenue, margin and tier no longer depend on whether it sold in a market whose prices include VAT.

Where do the scoring inputs come from?

Sales, refunds, discounts, costs, stock and sizes come from Shopify. Ad spend comes from Google Ads and Meta, and Google Shopping clicks and impressions from Google Ads.

Recent changes

Every change, in the changelog

Still need help?

Email us with a link to the page you were on and what you expected to see. A screenshot helps us answer first time.

support@fabrikanalytics.com