SKU Count Calculator

How many SKUs a catalogue really has.

Calculate total SKU count from product variants and options, with the inventory investment each additional variant adds.

Written and maintained by Mohit PatelLast checked August 4, 2026How we build these

Styles or products

Colours or variants

Sizes or options

Safety stock per SKU

units

Average unit cost

Currency

Total SKUs

3 × 5 × 6

Safety stock across all SKUs1,350 units

Buffer inventory value$18,900

Adding one more colour108 SKUs

That adds18 SKUs, $3,780

Variants multiply rather than add. One extra colour here creates a whole row of new SKUs, each needing its own buffer stock.

How the SKU Count Calculator works

SKU count multiplies rather than adds. Five colours in six sizes is thirty SKUs, each needing its own safety stock, its own forecast and its own shelf space. Variant decisions that feel small at the design stage set the inventory investment for years.

Also known as: how many SKUs · stock keeping unit count · product variant count · sku count

The calculation itself

SKU count is the number of distinct stock-keeping units carried: every combination of product, size, colour and pack that has to be held, counted and reordered separately.

The figure worth calculating alongside it is the multiplier: a product in 5 sizes and 4 colours is 20 SKUs, not one. Ranges expand multiplicatively and the operational cost expands with them.

Running the numbers

A range of 12 products in 5 sizes and 3 colours is 180 SKUs. At an average of 174 units of stock each and $18 cost, that is $563,760 of inventory to hold the range.

Cut the colour range to two and the SKU count falls to 120, releasing $187,920 of capital, a third of the investment, while removing a third of the counting, receiving and forecasting work.

Whether that is right depends on whether the third colour sells. If it accounts for 30% of units, nothing is saved; if it accounts for 8%, the capital released is worth far more than the sales foregone.

What gets missed

SKU count says nothing about whether the SKUs are earning. A business with 40 SKUs generating $2m is in better shape than one with 400 generating the same, and the count alone cannot distinguish them.

It also understates the cost of the tail. Each additional SKU adds not just stock but a forecast to maintain, a location to hold, a line on every count, and a reorder decision, and those costs are close to constant regardless of how little the SKU sells.

What to do next

Rank SKUs by contribution and look at the bottom quartile. In most catalogues the bottom 25% of SKUs generate under 5% of contribution and consume a proportionate share of working capital and attention.

Then rationalise deliberately rather than across the board. Some low-volume SKUs exist to complete a size run or serve a specific customer and removing them costs more than they contribute, which is a judgement, not a calculation.

Where SKU proliferation comes from

It accumulates rather than being decided. A colour added for a season, a size extension for one customer, a pack variant for one retailer, a bundle created for a promotion, each is individually reasonable and none is ever removed.

The structural fix is a rule that adding a SKU requires retiring one, or at least requires a stated expectation of volume that gets checked a year later. Without a mechanism for removal, the count only goes one way.

The measurement that makes the case is inventory value per SKU against contribution per SKU, plotted together. The chart nearly always shows a long tail of SKUs holding meaningful stock and generating almost nothing, and it is far more persuasive than any general argument about complexity, because the capital involved is specific and nameable.

One measure worth adding alongside the count: SKUs per product family. A catalogue where the average product carries fifteen variants has a different problem from one carrying two hundred products with one variant each, and the total count reads the same.

The variant-heavy case is usually where rationalisation is easiest, because the sales data shows plainly which sizes and colours never move, and removing them costs nothing in the customer's ability to find something suitable.

Where to go next

The SKU Count question rarely arrives on its own. These are the ones that usually come with it:

ABC Inventory Analysis Calculator — Which lines deserve the attention.
Dead Stock Calculator — Value trapped in stock that is not moving.
Inventory Value Calculator — Stock value at cost and at retail.
Etsy Fee Calculator — Every Etsy fee on one sale, itemised.

Not financial advice. Marketplace fees change, and they vary by country, plan and seller status. Every rate here is an editable default, not a quoted price, check the platform's current fee schedule before you price a product against it. This is not tax or business advice.

Frequently asked questions

How is SKU count calculated?

Multiply the options in each dimension. Three styles × 5 colours × 6 sizes is 90 SKUs. Adding one colour to that range does not add one SKU. It adds eighteen.

Why does SKU count matter so much?

Because every SKU needs its own safety stock. Doubling variants roughly doubles the buffer inventory even if total demand is unchanged, since demand is now split across more lines and each needs its own protection.

How many SKUs is too many?

When the long tail stops earning its carrying cost. Run an ABC analysis: if the bottom band is 30% of SKUs and 3% of value, it is consuming attention and capital far out of proportion to what it returns.

How do I reduce SKU count sensibly?

Drop the weakest variants rather than whole products, since demand usually consolidates onto the survivors rather than disappearing. Discontinuing the two slowest sizes in a range typically loses far less revenue than the SKU count suggests.