SKU classification: ABC and sell-through, bestsellers, slow sellers, no-sale
Ranks SKUs by net sales, assigns class A, B or C by the cumulative share and compares it with sell-through. A bestseller is class A with a high sell-through, a slow seller is one with a low sell-through, “no-sale” is a SKU with no sales. You set the thresholds; the calculation shows the quartiles of your data as a hint.
At a glance
- What question does it answer?
- Which SKUs are bestsellers, which are slow sellers and which do not sell at all, and how much stock lies in them.
- What data is needed?
- Net sales, units sold and delivered for each SKU, including SKUs with no sales.
- How to read the result?
- On the example of 10 SKUs worth 31m three bestsellers (class A and a sell-through of 60% or more) give 70.3% of sales. Three slow sellers (a sell-through below 30%) give 11.3% of sales and one SKU did not sell at all. Lowsellers and no-sale SKUs hold 49.1% of all remaining stock (2,360 of 4,810 pieces). The quartiles of your SKUs’ sell-through, 25% and 66.7%, hint where to set the thresholds. Example on the default values: Bestsellers: 3 SKUs · 70.3% of sales; Lowsellers: 3 SKUs · 11.3% of sales; No-sale: 1 SKUs · 300 pcs left; Share of remaining stock in slow sellers and no-sale: 49.1%. The figures are illustrative: enter your own to see your result.
Why and how to reason
An assortment divides into those that make money and those that occupy space. ABC analysis ranks items by sales and assigns a class by cumulative share: A is the top giving up to 80% of sales, B the next up to 95%, C the rest. But sales alone do not say whether an item sells well relative to what was delivered. For that sell-through = sold ÷ delivered is added. A bestseller is class A with high sell-through, a low seller is any item with low sell-through, “no sales” is an item where sold is no more than a threshold. In the example ten items on 31 million: four fell into A (cumulative share before the coat 0%, before the dress 31%, before the jeans 54%, before the hoodie 70%, all below 80%), three bestsellers, three low sellers, one with no sales (the jumpsuit). Low sellers and no-sales items hold 49% of the remaining stock in units.
When to use it
Use it mid and end of season to decide what to reorder, what to clear and what to remove from the assortment. It suits a brand and a retailer. It does not suit new arrivals in the first weeks of sales: they have no statistics yet. Assumptions: A/B and sell-through thresholds are set by you, the calculation shows the quartiles of your data only as a hint; sales are net of VAT.
How to read the result
First look at “bestsellers”: candidates for restock and protection from stock-outs. Then “share of stock in low sellers and no-sales items”: if it is half the inventory you have an assortment problem, not a sales problem. A class C item with good sell-through can be a niche worth keeping; a class A item with low sell-through means you bought too much. Compare sell-through quartiles with your thresholds: if your thresholds are stricter than the data, you call almost everything a problem. The decision: restock, promotion, removal from the assortment, revision of next season’s buying. Check each conclusion by eye: open the item card and look at price, sizes, photos.
Common mistakes
Setting thresholds by feel and then wondering why there are no bestsellers. Counting as “no sales” what arrived just a week ago. Applying ABC to sales of one channel when the stock lies in another: sell-through will be falsely low. Another trap: dropping class C items with good sell-through: they may hold loyal buyers and fill size gaps.
What data is needed?
- Net sales, units sold and delivered for each SKU, including SKUs with no sales.
- Your ABC boundaries and sell-through thresholds; a hint: the quartiles of your data in the result.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Boundary of class A (cumulative share of sales) | % | 80 | Class A: SKUs while the cumulative share before them is below the boundary. The Pareto 80/95 rule is an example, not a standard: change it for your range. |
| Boundary of class B | % | 95 | Above the A boundary and up to this boundary is class B, the rest is C. It must be above the A boundary. |
| High sell-through from | % | 60 | An example, not a standard: there is no single standard in Russia, enter your own threshold from your own data. A hint: the third quartile of your SKUs in the result. |
| Low sell-through below | % | 30 | An example, not a standard: there is no single standard in Russia, enter your own threshold from your own data. A hint: the first quartile of your SKUs in the result. |
| “No-sale”: sold not more than | pcs | 0 | A SKU counts as “no-sale” if not more than this many units were sold in the period. |
How it is calculated
| Step | Formula |
|---|---|
| Cumulative share | sum of article sales from large to small ÷ all sales |
| Class | A if the cumulative share before the article is below the A boundary; B if below the B boundary; otherwise C |
| Type | “no-sale” (sold not above the threshold); bestseller (class A and sell-through not below the high one); slow seller (sell-through below the low one); otherwise middle |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Bestsellers
- 3 articles · 70.3 % of sales
- Lowsellers
- 3 articles · 11.3 % of sales
- No-sale
- 1 articles · 300 pcs left
- Share of remaining stock in slow sellers and no-sale
- 49.1 %
- Sell-through of the range
- 51.4 %
- Quartile 1 of your articles’ sell-through
- 25 %
- Quartile 3 of your articles’ sell-through
- 66.7 %
- Class A articles
- 4 · 81.9 % of sales
Articles by descending sales
| Article | Sales | Cumulative share | Class | Sell-through | Remaining | Type |
|---|---|---|---|---|---|---|
| Wool coat | 9.6 m ₽ | 31 % | A | 66.7 % | 200 | Bestseller |
| Midi dress | 7.2 m ₽ | 54.2 % | A | 90 % | 100 | Bestseller |
| Straight jeans | 5 m ₽ | 70.3 % | A | 66.7 % | 500 | Bestseller |
| Basic hoodie | 3.6 m ₽ | 81.9 % | A | 50 % | 1,200 | Middle |
| Quilted jacket | 2.4 m ₽ | 89.7 % | B | 25 % | 600 | Lowseller |
| Knit top | 1.6 m ₽ | 94.8 % | B | 80 % | 200 | Middle |
| Pleated skirt | 900,000 ₽ | 97.7 % | B | 25 % | 900 | Lowseller |
| Scarf | 500,000 ₽ | 99.4 % | C | 50 % | 250 | Middle |
| Linen trousers | 200,000 ₽ | 100 % | C | 6.7 % | 560 | Lowseller |
| Jumpsuit | 0 ₽ | 100 % | C | 0 % | 300 | No-sale |
Class A with a sell-through below the high threshold: Basic hoodie. This is the core of revenue, but stock is high: check the buy.
There is no single standard for the sell-through thresholds and ABC boundaries in Russia: use the quartiles of your own articles or the thresholds from the last season. The class names in your company may differ (top, core, tail).
Nuances and limits
- Taking other people’s bestseller and lowseller thresholds: there is no single standard in Russia.
- Not entering SKUs with no sales: then no-sale will not be found.
- Class A with a low sell-through is not a success: check the buy.