Syntha Lab RU

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.

Season results: brand, category, SKU For whom: Category managers, buyers, merchandise directors, analysts.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Boundary of class A (cumulative share of sales)%80Class 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%95Above 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%60An 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%30An 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 thanpcs0A SKU counts as “no-sale” if not more than this many units were sold in the period.

How it is calculated

StepFormula
Cumulative sharesum of article sales from large to small ÷ all sales
ClassA 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

ArticleSalesCumulative shareClassSell-throughRemainingType
Wool coat9.6 m ₽31 %A66.7 %200Bestseller
Midi dress7.2 m ₽54.2 %A90 %100Bestseller
Straight jeans5 m ₽70.3 %A66.7 %500Bestseller
Basic hoodie3.6 m ₽81.9 %A50 %1,200Middle
Quilted jacket2.4 m ₽89.7 %B25 %600Lowseller
Knit top1.6 m ₽94.8 %B80 %200Middle
Pleated skirt900,000 ₽97.7 %B25 %900Lowseller
Scarf500,000 ₽99.4 %C50 %250Middle
Linen trousers200,000 ₽100 %C6.7 %560Lowseller
Jumpsuit0 ₽100 %C0 %300No-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.

Terms used

Calculate on your data →