Sell-through rate answers one question: of everything we put in front of customers, how much has sold? It sounds trivial until two people in the same trading meeting quote different numbers. In almost every case I have looked into, the reason is the same: one of them divides by units received, the other by units received plus opening stock.
Sell-Through Rate Definition Used in Retail Reporting
In retail reporting, sell-through rate is the percentage of available units sold within a period, usually a season or a number of weeks since launch. It is measured in units, not value, because it describes how the buy performed, not how much money it made. Price and margin sit in other KPIs next to it.
Pick one definition per brand, write it down and put it in the report description. The version I use by default divides net sales units, after returns, by the total units made available in the period.
Sell-Through Rate Formula with Two Denominators
The first formula is the one I recommend for most reports. It counts everything customers could buy, including carry-over stock from the previous season, so the rate can never pass 100%. The second formula ignores opening stock. Buyers like it for new-season styles, where opening stock is zero anyway and both versions give the same answer.
The trouble starts with continuity lines and carry-over. For example, a basic T-shirt starts the season with 200 units in stock, receives 800 more and sells 640, of which 40 come back. On the first formula the sell-through is 600 ÷ 1,000 = 60%. On the second it is 600 ÷ 800 = 75%. Both are correct; they just answer different questions. Try your own numbers in the calculator below.
Formula: (sold − returned) ÷ (opening stock + received). The second result divides by received units only.
The numbers stay in your browser and are not sent anywhere.
What Is a Good Sell-Through Rate in Fashion Retail
There is no single good sell-through rate. It depends on the category, the season length and how much markdown the plan allows. The ranges below are rules of thumb I use as a starting point for seasonal fashion, measured on the first formula. Treat them as a sense check, not as a target to copy.
- Seasonal fashion at full price, end of the full-price period: around 50–70%. Below 40% the buy was probably too deep or the price too high.
- Seasonal fashion at the end of the season, including markdown: around 75–90%. Much higher often means lost sales from stock-outs.
- Trend or fashion-forward styles: a fast start matters more than the final number; about 20–30% in the first four weeks is a healthy signal.
- Outerwear and heavy knitwear: slower until the weather turns, so compare with last year’s curve by week rather than a flat target.
- Continuity and basics: sell-through is the wrong lens; judge them on weeks of cover and availability instead.
A rate that is too high is a warning too. If a style sells 95% in six weeks, you ran out of sizes, and the sales you did not make never appear in the report.
The most useful benchmark is your own history. Save the weekly curve of every category each season, and next year compare the new line with the old one at the same week since launch.
How to Calculate Sell-Through Rate in Excel
In Excel, keep one row per style or option with four columns: opening stock, received, sold and returned. The formula then fits in one cell, and IFERROR stops new styles with no stock from showing an error.
' Columns: A = style, B = opening stock, C = received, D = sold, E = returned
=IFERROR((D2-E2)/(B2+C2), 0)
' Sell-through for one category from a flat sales table
=IFERROR(
(SUMIFS(Sales[Units], Sales[Category], H2) - SUMIFS(Sales[Returns], Sales[Category], H2))
/ (SUMIFS(Stock[Opening], Stock[Category], H2) + SUMIFS(Receipts[Units], Receipts[Category], H2)),
0)Do not average the percentages of individual styles to get a category rate. A style with 10 units counts as much as one with 2,000. Sum units first, then divide, as the SUMIFS version does.
DAX Measures for Sell-Through Rate in Power BI
In Power BI I build three measures: net units, available units and the ratio. Keeping them separate makes the number easy to audit, and while the definition is still being agreed you can show both denominators side by side.
Net Units :=
SUM ( Sales[Units] ) - SUM ( Sales[ReturnUnits] )
Available Units :=
CALCULATE (
SUM ( Stock[OpeningUnits] ) + SUM ( Receipts[Units] ),
REMOVEFILTERS ( 'Date'[Week] )
)
Sell-Through % :=
DIVIDE ( [Net Units], [Available Units] )
Sell-Through on Receipts % :=
DIVIDE ( [Net Units], CALCULATE ( SUM ( Receipts[Units] ), REMOVEFILTERS ( 'Date'[Week] ) ) )REMOVEFILTERS on the week keeps the denominator fixed for the whole season. Without it, a weekly visual divides each week’s sales by that week’s receipts, which is a different and rarely useful number.
Weekly Sell-Through Curve in a Retail Dashboard
A single percentage tells you little. The curve does: cumulative sell-through by week since launch, against last season. Too flat and the buy was too deep or the price is wrong. Too steep and you will be out of sizes before the season ends. For the cumulative line, wrap Net Units in a season-to-date pattern and plot it by week number since launch, not by calendar week.
| Category | Units received | Sell-through, wk 8 | Gross margin |
|---|---|---|---|
| Dresses | 1,240 | 68% | 42% |
| Knitwear | 980 | 54% | 38% |
| Denim | 1,510 | 74% | 47% |
| Outerwear | 640 | 39% | 31% |
| Accessories | 720 | 61% | 55% |
| Footwear | 560 | 33% | 29% |
In a table like this, outerwear and footwear stand out at once. Whether that is a problem depends on their curve: at week 8 outerwear is often still waiting for cold weather, so I would check last year’s line before proposing a markdown.
Common Sell-Through Rate Calculation Mistakes
- Filtering the denominator by week, so availability resets every week and the curve looks flat.
- Leaving returns in sales units, which inflates sell-through in categories with high return rates such as dresses bought online.
- Averaging style-level percentages instead of dividing total units by total units.
- Mixing markets with different season start weeks in one cumulative view.
- Counting stock in transit to stores as available before it reaches the shop floor or the online warehouse.
- Comparing a rate on receipts with last year’s rate on available stock.
If your team reports sell-through in three different ways today, agreeing one definition is usually the first step of a Power BI dashboard project, and it is where I start when I set up retail reporting.