Shopify ABC Inventory Analysis: Focus on the 20% That Drives 80% of Revenue
Not all inventory deserves the same attention, safety stock, or reorder frequency. ABC analysis is the framework that tells you which products to manage tightly and which to manage loosely — based on how much of your revenue each one actually drives. Applied correctly, it reduces both stockouts on your best sellers and dead stock on your slowest movers simultaneously.
What ABC Analysis Is (And Where the 80/20 Rule Comes From)
ABC analysis applies the Pareto principle to inventory: roughly 20% of your SKUs drive 80% of your revenue. The analysis classifies every product into one of three tiers based on cumulative revenue contribution:
The percentages are approximate — the exact split varies by business. What matters is the principle: a small number of products is responsible for a large share of revenue. Managing all products with the same level of attention wastes time on C items while under-resourcing the A items that actually keep the business running.
How to Calculate ABC Classifications From Shopify Data
Shopify gives you everything you need. The calculation takes about 20 minutes with a spreadsheet:
- Export sales data. Go to Shopify Analytics → Reports → Sales by Product. Set the date range to the last 12 months. Download the CSV. You need: product/variant name, SKU, and total revenue (not units — revenue, because a $5 item selling 1,000 units and a $100 item selling 50 units contribute the same $5,000 and should be treated equally).
- Sort by revenue descending. The highest-revenue product goes to the top.
- Add a cumulative revenue column. Row 1 = Product 1 revenue. Row 2 = Row 1 + Product 2 revenue. And so on.
- Add a cumulative % column. Each row's cumulative revenue ÷ total revenue × 100.
- Classify by threshold. Cumulative % up to 80% = A. 80–95% = B. 95–100% = C.
Use revenue for ABC classification, not units sold. A high-volume, low-price item and a low-volume, high-price item can have the same revenue impact but very different unit counts. Revenue reflects actual business contribution; units doesn't. Use units sold only if you're classifying for operational capacity (picking, packing) rather than financial impact.
The Inventory Strategy for Each Tier
ABC classification is only useful if it changes how you manage each tier. Here is the specific strategy difference:
| Tier | Safety Stock | Reorder Frequency | Supplier Priority | Review |
|---|---|---|---|---|
| A items | 20–30 days | Weekly review | Preferred lead time, direct contact, backup supplier | Monthly |
| B items | 10–14 days | Bi-weekly review | Standard | Quarterly |
| C items | 0–7 days | Monthly review or on demand | Low priority | Annually |
A item strategy: zero tolerance for stockouts
A stockout on an A item has an outsized revenue impact. If one A item is out of stock for two weeks and it drives 15% of your monthly revenue, you've lost 7.5% of your monthly revenue from a single product. A items deserve:
- Higher safety stock — 20–30 days of buffer vs the standard 7–14 days
- Weekly reorder point checks — not monthly, not when you happen to notice
- A backup supplier — if your primary supplier can't deliver, you need an alternative ready
- Priority PO follow-up — if an A item PO hasn't shipped by the expected date, call the supplier
C item strategy: minimize inventory investment
C items drive 5% of revenue but often represent 30–40% of your SKU count and inventory investment if you manage them the same as A items. For C items:
- Minimal safety stock — a stockout on a C item costs far less than the carrying cost of excess C inventory
- Order only when needed — just-in-time reordering for C items reduces dead stock risk
- Review for discontinuation quarterly — C items with zero velocity for 90 days should be considered for removal from your catalog
- Reduce SKU proliferation — if you have 5 color variants of a C item and only 2 sell, discontinue the other 3
How EZstock Velocity Data Enables ABC Classification
EZstock calculates 30-day rolling sales velocity for every product variant in your Shopify store. Velocity (units sold per day) is a closely correlated proxy for revenue contribution — your highest-velocity products are almost always your A items.
In the EZstock Products dashboard, sorting by velocity descending immediately surfaces your top performers. These are the products to prioritize for tight safety stock configuration, frequent reorder point reviews, and supplier relationship investment. The lowest-velocity products at the bottom of the list are your C candidates — review them for discontinuation or minimal safety stock treatment.
Unlike a quarterly spreadsheet analysis, EZstock's velocity updates daily. This means a product that goes viral or gets a major press mention will surface in your top-velocity list within 48 hours — long before a quarterly ABC recalculation would catch it. You can adjust its reorder point and safety stock before the sudden demand spike depletes your buffer.
Product tiers shift constantly. A seasonal product might be a C item in January and an A item in November. A new product launch can jump from C to A in a week if it trends. Review your classifications quarterly using trailing 12-month revenue data, and watch your daily velocity dashboard for sudden upward shifts that signal tier changes before the quarterly review catches them.
Know Your A Items. Never Let Them Stock Out.
EZstock tracks 30-day rolling velocity per SKU — your highest-velocity products are your A items. Configure tighter safety stock and reorder points for them in minutes.
Start Free 14-Day TrialNo credit card required · Installs in 60 seconds · Cancel anytime