ABC Analysis for a D2C Catalog: Stop Managing Equally

Most D2C brands give every SKU the same amount of inventory attention, and that is the mistake ABC analysis fixes. In a typical catalog a small group of products drives most of the revenue, and a long tail contributes almost nothing. ABC analysis ranks your SKUs by revenue contribution, splits them into three classes, and tells you where tight stock control pays off and where it is wasted effort. The A class earns a near-perfect in-stock policy. The C class does not deserve the same care, and treating it like it does ties up cash and shelf space.

This guide covers what ABC analysis does, the five steps to classify your own catalog, a worked 10-SKU example with cumulative-revenue cutoffs, the different stocking policy each class should get, and where the method quietly misleads you.

What ABC Analysis Actually Does

ABC analysis is a way to rank SKUs by revenue contribution and sort them into three tiers, so inventory effort follows value instead of being spread evenly. It is a direct application of the Pareto principle: roughly 80% of revenue tends to come from about 20% of products. Those high-earning products are the A class. The next band is B, and the long tail of low-earners is C.

The classes are not about how "good" a product is. They are about where a stockout or an overstock costs you the most. Running out of an A-class bestseller loses real revenue every day it is unavailable. Running out of a C-class sticker pack loses almost nothing. Overstocking that same C item, on the other hand, is how brands end up with a warehouse full of dead stock they have to discount to clear.

How to Do ABC Analysis in Five Steps

The whole method is a sorted spreadsheet with a running total. Before you set any stocking rules, you need the ranking, so start there.

1. Pull revenue per SKU for a trailing 12 months. Use net revenue, not units. Twelve months smooths out seasonality so a single strong month does not misclassify a product. Pull it from Shopify or wherever your orders live.
2. Sort descending and compute each SKU's share of total revenue. Divide each SKU's revenue by total catalog revenue to get its percentage.
3. Compute the cumulative percentage down the list. Add each SKU's share to the running total above it. The top SKU's cumulative equals its own share. The bottom SKU's cumulative equals 100%.
4. Draw the class lines on the cumulative column. A common split: A is every SKU up to roughly 80% cumulative, B is the next band up to about 95%, and C is the rest. The lines are conventions, not laws. Move them to fit your catalog.
5. Assign each SKU its class and stop there for now. You now have three groups. The stocking policy comes next, and it is different for each.

ABC Analysis Example: A 10-SKU Coffee Catalog

Here is the method on a small catalog. A coffee brand does $1,000,000 in trailing-12-month revenue across 10 SKUs. Sorted by revenue, with each SKU's share and the running cumulative, it looks like this.

Rank	SKU	Revenue	% of revenue	Cumulative %	Class
1	House Blend Whole Bean 340g	$380,000	38.0%	38.0%	A
2	Cold Brew Concentrate 1L	$240,000	24.0%	62.0%	A
3	Single Origin Sampler	$110,000	11.0%	73.0%	A
4	Espresso Roast 340g	$78,000	7.8%	80.8%	A
5	Decaf Blend 340g	$60,000	6.0%	86.8%	B
6	Ceramic Pour-Over Dripper	$44,000	4.4%	91.2%	B
7	Travel Mug	$40,000	4.0%	95.2%	B
8	Branded Tote Bag	$22,000	2.2%	97.4%	C
9	Coffee Filters 100-pack	$15,000	1.5%	98.9%	C
10	Sticker Pack	$11,000	1.1%	100.0%	C

Read the cumulative column. The first four SKUs cross 80% at 80.8%, so they are the A class: four products, $808,000, about 81% of revenue. SKUs 5 through 7 take the cumulative from 80.8% to 95.2%, so they are B: three products, $144,000, about 14% of revenue. The last three SKUs are C: $48,000, under 5% of revenue, but 30% of the catalog by SKU count.

That last line is the whole point. Three of your ten products earn less than 5% of revenue combined. They should not get the same reorder attention, safety stock, or spreadsheet time as the House Blend.

Set an Inventory Stocking Policy Per Class

Once SKUs are classified, the payoff is giving each class a different service level and reorder discipline. Service level is the probability you want of not stocking out, and it drives how much safety stock you carry.

Class	Target service level	Reorder review	Safety stock	Forecasting effort
A	97-99%	Weekly, close watch	Generous	Forecast each SKU carefully
B	90-95%	Monthly	Moderate	Lighter-touch forecast
C	85-90% or lower	Quarterly or bulk-and-hold	Minimal	Simple rule of thumb

For A-class SKUs, a stockout is expensive, so carry enough safety stock to almost never run out, review them often, and forecast each one on its own. The House Blend going out of stock for a week is lost revenue you cannot recover and a chance for a customer to try a competitor.

B-class SKUs get a lighter touch. A 90-95% service level is usually fine, and a monthly review catches problems before they cost much.

C-class SKUs should cost you the least attention. Set a low service level, review them rarely, and prefer bulk orders you hold rather than frequent small reorders that eat labor. For the slowest C items, the real question is whether to carry them at all. Watch their sell-through rate; a C-class SKU with slow sell-through is a discontinuation or clearance candidate, not something to keep restocking.

Where ABC Analysis Misleads You

Revenue-only ranking is simple, which is its strength and its blind spot. A few caveats keep it from steering you wrong.

It ignores margin. A high-revenue SKU sold at a thin margin can matter less to profit than a smaller SKU with a fat one. If your margins vary a lot across the catalog, run the analysis a second time on gross profit instead of revenue and compare the two rankings. A SKU that is A on revenue but B on profit deserves a second look.

It ignores demand variability. Two A-class SKUs can behave differently: one sells steadily, one spikes and crashes. The steady one is easy to stock, the volatile one needs more safety stock at the same service level. Pairing ABC with an XYZ analysis, which classifies SKUs by how predictable their demand is, gives you a fuller picture. An AX item is a high-revenue, predictable workhorse. An AZ item is high-revenue but erratic, and it is the one most likely to burn you with a stockout.

It penalizes new products. A SKU launched two months ago has low trailing-12-month revenue and lands in C by default, even if it is growing fast. Flag recent launches and judge them on velocity, not on a full-year total they never had the chance to earn.

How Often to Re-Run ABC Analysis

Re-run ABC analysis quarterly for most catalogs, and after any major launch or seasonal peak. Product mix drifts. A B-class item can climb into the A class over two quarters, and a former A-class hero can fade. If your reorder policies are still based on last year's classification, you are protecting products that no longer earn it and under-protecting ones that now do. A quarterly re-rank keeps the classes current without turning into busywork.

The classification is only useful if it changes what you do. Tie it to your reorder points and safety-stock settings directly, and keep an eye on overall inventory turnover so you can see the ABC policy working: A items should turn fast on tight control, and your C tail should stop quietly accumulating cash you cannot get back.

Frequently Asked Questions

What is ABC analysis in inventory management?

ABC analysis ranks SKUs by revenue contribution and sorts them into three classes. A items are the roughly 20% of products that drive about 80% of revenue, B items are the next band, and C items are the low-earning long tail. The point is to match inventory effort to value, giving A items tight stock control and high service levels while spending far less attention on the C tail.

How do you calculate ABC classes for a catalog?

Pull trailing 12-month revenue per SKU, sort descending, and compute each SKU's share of total revenue. Then compute a cumulative percentage down the list. Assign A to SKUs up to about 80% cumulative, B to the next band up to roughly 95%, and C to the rest. The cutoffs are conventions you can adjust to fit how your catalog's revenue is distributed.

What service level should each ABC class get?

Give A-class SKUs a 97-99% service level with generous safety stock and frequent reorder reviews, since stockouts on them lose real revenue. B-class SKUs work at 90-95% with a monthly review. C-class SKUs can run at 85-90% or lower with minimal safety stock and infrequent reordering. Service level sets your target probability of not stocking out, which drives how much buffer you carry.

Should ABC analysis use revenue or profit?

Revenue is the standard input and the simplest place to start. But revenue ignores margin, so a high-revenue, thin-margin SKU can rank above a smaller product that contributes more profit. If margins vary widely across your catalog, run the analysis a second time on gross profit and compare the two rankings. SKUs that shift class between the two are the ones worth examining closely.

How often should you redo ABC analysis?

Re-run it quarterly for most catalogs, and again after a major launch or a seasonal peak. Product mix drifts over time, so a B item can climb into the A class and a former bestseller can fade. If your reorder points still reflect last year's classes, you are over-protecting faded products and under-protecting rising ones. Quarterly keeps the classes accurate without becoming busywork.

Conclusion

ABC analysis works because it stops you from spreading inventory attention evenly across a catalog where value is not spread evenly. Rank SKUs by trailing revenue, compute the cumulative percentage, and cut the list into A, B, and C at roughly 80% and 95%. Then give each class a stocking policy that matches its value: near-perfect service and close watch for A, a lighter touch for B, and minimal effort plus a discontinuation eye for C. Re-run it quarterly, and check it against margin and demand variability before you trust it blindly.

For the wider system this fits into, see the inventory analytics guide. To pressure-test your classes, watch inventory turnover and sell-through rate, and read how to identify and clear dead stock for the C-class tail.