ABC Inventory Analysis for Shopify: Prioritize Stock, Cut Dead Weight

The 80/20 Rule Applied to Your Stock Room

In most Shopify stores, 20% of SKUs generate 80% of revenue. The remaining 80% of SKUs consume capital, warehouse space, and operational attention — while contributing marginal returns.

ABC inventory analysis is the systematic process of classifying your product catalog by contribution to revenue (or profit), enabling you to allocate resources rationally: maximum attention and capital to A-category products, minimum to C-category, and a structured decision framework for everything in between.

The ABC Classification Framework

Category A — critical SKUs (top 10-20% of SKUs, ~70-80% of revenue): These are your revenue engines. Stock-outs on A-category SKUs are existential problems — they cost you sales, hurt customer satisfaction, and damage your organic search rankings (out-of-stock products lose their conversion rate signals). The operational imperative: always have sufficient stock, with reorder points set conservatively and safety stock buffers maintained.

Category B — important SKUs (next 30% of SKUs, ~15-20% of revenue): These contribute meaningfully but aren't critical. They require regular monitoring and moderate safety stock, but stock-outs are recoverable. Review reorder points quarterly and optimize based on seasonal demand patterns.

Category C — low-priority SKUs (remaining 50-60% of SKUs, ~5-10% of revenue): These are candidates for rationalization. Carrying C-category SKUs has real costs: capital tied up in inventory, storage space, fulfillment complexity, and catalog management overhead. The decision framework: for each C-category SKU, choose one of: liquidate existing stock and discontinue, consolidate into a B/A variant, or move to a made-to-order model to eliminate stock risk.

Running the Analysis in Shopify

Data extraction: Navigate to Shopify Admin → Analytics → Reports → Products → Sales by product (or use the Inventory reports). Export to CSV. You need: SKU, product title, units sold, total revenue, and optionally COGS to calculate contribution by gross profit rather than gross revenue.

Classification calculation:

1. Sort all SKUs by descending revenue (or gross profit if COGS is available)
2. Calculate cumulative revenue as a percentage of total revenue
3. SKUs in the 0-70% cumulative bucket = Category A
4. SKUs in the 70-90% cumulative bucket = Category B
5. SKUs in the 90-100% cumulative bucket = Category C

For a Shopify store with 500 SKUs, you'll typically find:

• ~80-100 A-category SKUs
• ~130-150 B-category SKUs
• ~270-300 C-category SKUs

Reorder Point Optimization by Category

Reorder Point (ROP) = Daily Demand × Lead Time (in days) + Safety Stock

Safety stock formula: Safety Stock = Z × Standard Deviation of Daily Demand × √Lead Time

Where Z = service level factor (1.65 for 95% service level, 2.33 for 99%)

Category-differentiated ROP settings:

• A-category: High service level (95-99%). Generous safety stock. Reorder when stock reaches 14-21 days of demand at average daily sales rate.
• B-category: Standard service level (90-95%). Moderate safety stock. Reorder at 7-14 days coverage.
• C-category: Lower service level (80-90%). Minimal safety stock. Reorder at 3-7 days coverage, or manage as make-to-order if lead times allow.

Shopify Inventory Management Tools

Shopify's native inventory management is sufficient for catalogs under ~200 active SKUs with simple replenishment needs. For larger catalogs or multi-location inventory:

Inventory planner (app): Integrates with Shopify to calculate reorder points, generate purchase orders automatically, and surface low-stock alerts based on actual sales velocity. Highly recommended for stores with 200+ SKUs.

Cin7 / fishbowl / brightpearl: Full inventory management systems that integrate with Shopify via API for complex multi-location, multi-channel inventory needs.

Custom n8n automation: For stores that want maximum control, an n8n workflow can pull Shopify inventory data daily, run the ABC classification automatically, and send reorder alerts to Slack or email for A-category items approaching their reorder point. See our n8n automation guide for the pattern.

Dead Stock:The Capital Trap

C-category SKUs that haven't sold in 90+ days are dead stock. Every day they sit in your warehouse (or 3PL), they're costing you:

• Storage fees (3PL charges per cubic foot per month)
• Tied-up capital that could fund A-category inventory investment
• Catalog complexity that makes your store harder to navigate and manage

Dead stock liquidation options:

1. Deep discount flash sale (50-70% off) — fastest clearance, lowest margin recovery
2. Bundle with A-category products — pairs dead stock with a best-seller, recovering some margin
3. Wholesale channel clearance — sell at cost to liquidators or resellers
4. Donation write-off — for slow-moving goods where the tax benefit exceeds liquidation value

At Verdant Mindset, we help Shopify merchants build data-driven inventory operations. See our Shopify analytics and operations services.