ABC analysis for your inventory: where to focus when you have 3,000 items and one afternoon
A handful of items make most of your revenue; a long tail makes almost none. ABC analysis sorts them in an hour so you can guard the winners, simplify the tail and stop treating every item the same.
5 min read
In short: ABC analysis ranks your items by value and splits them into three classes:A (about 10–20% of items producing about 70–80% of revenue),B (the next 20–30% producing about 15–20%) andC (the long tail, about half the items, producing 5–10%). Run it by exportingsales by item for 6–12 months, sorting by revenue, and calculating cumulative percentages. Then treat the classes differently:A gets tight reorder points, weekly counts and never runs out;B gets standard rules;C is bought on demand, counted rarely and pruned. The exact percentages vary; the principle does not.
You cannot give 3,000 items equal attention. ABC tells you where attention pays.
The principle
The Pareto rule says a small share of causes produces most of the effect. In a shop, a small share of items produces most of the revenue (and often the profit). Managing all items the same wastes effort on the tail and under-protects the head.
How to run it, step by step
Step 1: get the data
Exportsales by product for the last 6–12 months, with units, revenue and, if possible, margin. Wameed’s sales and inventory reports give you sales by product, stock valuation and turnover that you can export to a spreadsheet. Seereports that matter.
Step 2: sort by revenue
Sort descending by revenue (or by margin if you want a profit-based ABC).
Step 3: calculate cumulative share
For each item:
- Share = item revenue ÷ total revenue.
- Cumulative share = running total of shares.
Step 4: draw the lines
| Class | Cumulative revenue | Typical share of items |
|---|---|---|
| A | up to about 70–80% | 10–20% |
| B | next about 15–20% | 20–30% |
| C | last about 5–10% | 50–70% |
Use the thresholds that suit your trade; a boutique and a supermarket differ.
Step 5: add context
Before you act, flag:
- New items that have not had time to sell.
- Seasonal items in the off-season.
- Items sold out during the period.
- Strategic items (traffic drivers, loss leaders).
A worked example
A shop sells 1,000 items with SAR 1,000,000 in revenue.
| Class | Items | Revenue | Share of revenue |
|---|---|---|---|
| A | 150 (15%) | SAR 780,000 | 78% |
| B | 250 (25%) | SAR 170,000 | 17% |
| C | 600 (60%) | SAR 50,000 | 5% |
Six hundred items produce SAR 50,000: SAR 83 each over the year. Those C items take shelf space, counting time and cash. Meanwhile, a stock-out on one A item may cost more than the revenue of fifty C items.
How to manage each class
| A | B | C | |
|---|---|---|---|
| Availability goal | Never out | High | Acceptable to be out |
| Reorder point | Tight, with safety stock | Standard | Order on demand |
| Count frequency | Weekly | Monthly | Quarterly or at annual count |
| Supplier | Best terms, a backup supplier | Standard | Consolidate or drop |
| Pricing | Watch competitors | Review quarterly | Clearance candidates |
| Display | Prime position | Standard | Back or online only |
| Review | Monthly | Quarterly | Twice a year |
Seereorder points and safety stock,stock count how-to andslow-moving stock clearance.
Variations
A profit-based ABC
Rank bygross margin rather than revenue. A product with low revenue and high margin may matter more than it looks; a high-revenue, low-margin item may be a traffic driver rather than a profit centre.
XYZ: how predictable is demand?
Add a second dimension,X (steady),Y (variable),Z (erratic). An AX item (high value, steady demand) is easy to automate; a CZ item (low value, erratic) should be bought only when a customer asks.
ABC by category
Run the analysis within each category, so a niche category is not overwhelmed by a larger one.
What to do with the C tail
- Prune. Remove items that have not sold in a year, after clearance.
- Consolidate suppliers and order less often, together.
- Special-order rather than stock.
- Check for hidden winners: some C items are new or were out of stock.
- Keep a few for range, where they bring customers in.
What to do with the A items
- Never let them stock out. Safety stock and a backup supplier.
- Protect margin. Negotiate; watch price changes.
- Count them weekly, because errors here matter most.
- Secure them against theft. Seeshrinkage in Saudi retail.
- Feature them in the shop and online.
Common mistakes
- Running it once and forgetting it.
- Treating new items as C.
- Pruning strategic items.
- Ignoring seasonality.
- Using revenue only when margin tells a different story.
A 90-minute plan
| Minutes | Task |
|---|---|
| 0–20 | Export sales by product, 12 months |
| 20–40 | Sort, calculate shares, assign classes |
| 40–60 | Flag exceptions |
| 60–80 | Set count frequency and reorder rules per class |
| 80–90 | List 20 C items to clear |
Frequently asked questions
What are the A, B and C percentages?
Roughly 70–80%, 15–20% and 5–10% of revenue; the exact split depends on your trade.
Does Wameed produce an ABC report automatically?
You can export sales by product, valuation and turnover reports and classify in a spreadsheet.
How often should I redo it?
Quarterly, and before peak seasons.
Should I stop selling C items?
Not automatically. Prune the dead ones and keep those that serve a purpose.
- #تحليل ABC
- #تصنيف المخزون
- #قاعدة باريتو للمخزون
- #ترتيب أولويات المخزون
- #ABC analysis
- #inventory classification
- #Pareto stock
Share this article
Ask about your own shop
Thirty minutes on your products, your tax setup and your hardware — not a slide deck.
Keep reading
5 min read
POS for a stationery, toys and gifts shop: back-to-school peaks, thousands of SKUs and gift wrap
A stationery and gift shop lives on a few intense weeks: school return, Eid, graduation and National Day. The rest of the year, a long tail of small items. The system must handle peaks, bundles and gifting without drowning staff.
6 min read
Supplier terms that protect your cash: payment terms, returns and sale-or-return (consignment) stock
The cheapest finance a shop can get is a supplier who lets it pay late or send back what does not sell. Knowing the options, writing them down and tracking them in the system turns negotiation into cash flow.
5 min read
The price-change workflow: change once, print the right labels, and never let the shelf disagree with the till
A shelf that says SAR 8 while the till charges SAR 9 is a complaint, a refund and sometimes a regulator’s question. A short routine keeps the system price, the label and the display in step.

