A stock record nobody has checked
The available figure is wrong, so the rate is too.
Stock audit glossary · Retail
noun · also written sell-thru rate
Sell-through rate is the share of stock available in a period that was sold in that period, shown as a percentage. It measures how quickly goods are clearing, not how much was sold in total, which makes it the usual measure for seasonal ranges, where stock left at the end of the season may have to be sold at a discount.
Meaning
Total sales hide what a buyer most needs to know: is stock clearing at the pace the buying plan assumed? Showing sales as a share of what was available answers that, and it makes ranges of very different sizes comparable. A large delivery selling slowly and a small one selling out look alike on volume but not on sell-through.
It matters most where goods lose their market before they wear out: seasonal clothing, festival ranges and promotions. The rate part-way through a season is an early guide to what will be left, and so to mark-downs and any write-down. The figure is only as good as the stock record behind it, which is where a count comes in.
Where it is used
It suits goods with a selling window.
In practice
Opening stock plus everything received in the period is the bottom of the fraction.
From till or order data for the same period, net of returns where the business does so.
Style, colour and size, not the whole department.
Against the curve the buying plan assumed for the season.
Cutting early on a clearly lagging line can recover more than clearing it at the end; the same data feeds the provision on unsold stock.
Worked example
Sample figures.
| Style | Sold of received | Sell-through and reading |
|---|---|---|
| Style A | 1,044 of 1,200 | 87: under-bought |
| Style B | 468 of 900 | 52: on plan |
| Style C | 405 of 1,500 | 27: over-bought |
| Style D | 588 of 600 | 98: lost sales likely |
Style C, selling 27 of every 100 received, is heading for a price cut, and that cost is easy to see. Style D, at 98, looks like a success but has almost sold out with a third of the season left, so its cost is the sales it can no longer make.
Neither figure means much without the clock: 52 at week eight of twelve is healthy, but the same 52 at week eleven is not. And every one of these rates depends on the received and sold figures being right.
Watch out
The rate is easy to work out and easy to misread.
The available figure is wrong, so the rate is too.
The early warning is wasted.
Ranges with different selling lives look better or worse than they are.
Available stock is understated and the rate flattered.
Selling out early can mean the range was bought too thin.
Fast and slow styles cancel each other out.
Question
Sell-thru is another spelling of sell-through. A sell-thru rate shows how much of the stock a store had to sell in a period was actually sold, as a share of that stock: a rate of 60% over four weeks means 60 of every 100 units on hand or received in those weeks were sold.
Sell through means stock actually selling to the end customer, as opposed to being shipped into stores. A product that sells through is clearing off the shelf rather than sitting there.
Divide the units sold in a period by the units available in that period, which is opening stock plus units received, then multiply by 100. For a new range with no opening stock, it is units sold divided by units received.
Sell in is what a supplier sells into a retailer or distributor. Sell through is what that retailer then sells on to end customers. High sell in with low sell through means stock is building up in the channel.
Patron Accounting LLP. This page makes no regulatory statement.
Sources: general retail merchandising and stock-control practice; no statutory statement is made on this page. General information, not professional advice.
Need help with sell-through rate? See our retail stock audit service. A retail stock audit tests the stock record that sell-through figures are worked out from.