Sell-Through Rate Calculator for Fashion and Retail
This sell-through calculator shows what share of the available stock has sold, net of returns: units sold minus returns, divided by opening stock plus units received. It also gives the rate on receipts only, the version many buying teams quote for a new delivery.
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.
How to Use the Sell-Through Calculator
- Choose the period and the scope: one style, a category or a whole season.
- Enter the stock at the start of the period and the units received during it.
- Enter the units sold and the units returned in the same period.
- Read the sell-through on available stock; use the receipts-only rate when the product had no opening stock or when you compare deliveries.
Sell-Through Rate Formulas
The first formula is the one I use for seasonal fashion, because it counts every unit the business could have sold. The second is common for a single delivery or a new style. Both are only comparable if everyone agrees which one the report shows, so write the definition next to the number. My sell-through rate article covers typical ranges by category and how to build the measure in Excel and Power BI.
Sell-Through Rate Worked Example
An illustrative knitwear style starts the month with 200 units and receives 800 more, so 1,000 units are available. The stores and the website sell 640 units and 40 come back, which leaves 600 net sales. Sell-through on available stock is 600 ÷ 1,000 = 60%. Sell-through on receipts is 600 ÷ 800 = 75%. The fifteen-point gap is simply the opening stock, which is why two teams using different formulas can both be right and still disagree.
Common Mistakes in Sell-Through Rate Calculations
- Leaving returns in sales, which inflates sell-through in categories with high online returns.
- Dividing by closing stock instead of the stock that was available to sell.
- Comparing a four-week sell-through with a full-season one.
- Mixing the receipts-only rate and the available-stock rate in one report.
- Reading a high sell-through as success when the product sold out early and lost sales.
Sell-Through Calculator FAQ
Divide the units sold, minus returns, by the units that were available to sell: opening stock plus units received. 600 net units sold from 1,000 available is a 60% sell-through. Always state the period.
Yes, for fashion I always deduct them. A unit that comes back is available to sell again, and online return rates can be high enough to distort the figure. If a report does not deduct returns, the definition should say so.
It depends on the category, the season length and the markdown plan, so there is no single benchmark. Compare a style with its own category and with the plan for the same week of the season. A very high rate early in the season can mean the buy was too shallow.
Sell-through is the share of available units that sold in a period. Stock turn shows how many times the average inventory was sold over a period, usually at cost. Sell-through suits seasonal products, stock turn suits continuous ranges.
Related Retail Analytics Articles
Retail KPIs for Fashion Brands: Sell-Through, Stock Turn, GMROI and Weeks of Cover
The retail KPIs a fashion brand should review every week, with formulas for stock turn, GMROI and weeks of cover and two calculators.
Power BI Dashboard Examples for Retail and Fashion Sales
Three Power BI dashboard examples for retail, described page by page: weekly trading, category review and end-of-season review, with KPIs and design rules.
Row-Level Security in Power BI for Multi-Market Retail Reporting
How to set up row-level security in Power BI so that each market sees only its own figures in one shared retail report.
Free Retail Calculators for Margin, Sell-Through and Stock
GMROI Calculator
Gross margin return on inventory investment from gross margin and average inventory at cost.
Margin Calculator
Gross margin, markup and gross profit from cost and price, plus the price you need for a target margin.
Stock Turn and Weeks of Cover Calculator
Stock turn, days of stock and weeks of cover from cost of goods sold, inventory and weekly sales.