ABC Inventory Analysis for Ecommerce

How ABC Analysis Works

ABC analysis applies the Pareto principle (the 80/20 rule) to inventory management. In most product catalogs, a small number of products generate the vast majority of revenue. A store with 500 SKUs might find that 50 products (10%) account for $800,000 of $1 million in annual revenue. Those 50 products deserve the most careful management: precise demand forecasting, generous safety stock to prevent stockouts, frequent cycle counts, and prime warehouse locations for fast picking. The remaining 450 products, while collectively important, individually contribute so little that the cost of intensive management is not justified.

The classification is straightforward arithmetic. List every SKU with its annual revenue (or annual COGS if you prefer a cost-based analysis). Sort the list from highest to lowest revenue. Calculate each SKU's percentage of total revenue and the cumulative percentage running down the list. Products that fall within the top 70% to 80% of cumulative revenue are A items. Products in the 80% to 95% range are B items. Everything below 95% is C items. The exact cutoff percentages vary by business, so adjust the thresholds to create classifications that feel meaningful for your specific product mix.

For example, consider a store with 200 SKUs doing $500,000 in annual revenue. After sorting by revenue: SKUs 1 through 25 (12.5% of products) generate $375,000 (75% of revenue), classified as A items. SKUs 26 through 70 (22.5% of products) generate $87,500 (17.5% of revenue), classified as B items. SKUs 71 through 200 (65% of products) generate $37,500 (7.5% of revenue), classified as C items. This distribution is typical. A minority of products carry the business, a middle tier provides meaningful but not critical revenue, and a long tail of niche products collectively contributes a small fraction.

Setting Inventory Policies by ABC Classification

A Items: Maximum Attention

Your A items deserve the highest service levels and the most precise management because a stockout on any single A item has a large revenue impact. Set safety stock at a 95% to 99% service level for A items, meaning you carry enough buffer to avoid stockouts 95% to 99% of the time even with demand spikes and supplier delays. Review reorder points monthly or even weekly and adjust based on recent sales trends. Count A items weekly during cycle counts to maintain near-perfect inventory accuracy. Store A items in the most accessible warehouse locations, closest to packing stations, to minimize picking time.

Invest in detailed demand forecasting for each A item individually. Build product-specific forecasts that account for seasonal patterns, promotional impacts, and growth trends rather than using a blanket average across your catalog. Track supplier lead times per A item and maintain relationships with backup suppliers for your top 10 products so that a supplier disruption does not stock out your most critical revenue generators.

B Items: Moderate Management

B items warrant solid management but not the intensive attention of A items. Set safety stock at an 85% to 95% service level. Review reorder points monthly. Count B items every 2 to 3 weeks during cycle counts. Forecast at the product category level rather than individually, unless a specific B item shows signs of becoming an A item (rapid growth, increasing market demand). Store B items in standard warehouse locations with normal picking priority.

B items are worth monitoring for reclassification in both directions. A B item whose sales are growing may deserve promotion to A-level attention and safety stock. A B item whose sales are declining may need to be reclassified as a C item, with reduced inventory investment to match its diminishing revenue contribution. Re-run your ABC analysis quarterly to capture these shifts.

C Items: Simplified Management

C items individually contribute very little to revenue, so the management goal is minimizing the time and capital invested in them while keeping them available for the customers who want them. Set safety stock at a 75% to 85% service level, accepting that occasional brief stockouts on these products are acceptable because the revenue impact is minimal. Use simplified reorder rules rather than precise calculations: reorder a fixed quantity when stock hits a threshold, without the detailed forecasting and safety stock math you apply to A items.

Count C items monthly during cycle counts. Store them in less accessible locations (higher shelves, further from packing stations) because the time savings from premium locations are not justified by their low order frequency. Regularly evaluate whether each C item is worth keeping in your catalog at all. If a C item has not sold in 90 or more days, generates less profit than its carrying cost, or requires disproportionate management effort (special storage requirements, frequent quality issues), consider discontinuing it and freeing the capital and space for products that contribute more.

Running Your First ABC Analysis

Export your sales data for the past 12 months from your ecommerce platform or inventory management software. You need: SKU, product name, total units sold, total revenue, and total COGS for the period. Import the data into a spreadsheet. Sort by revenue descending. Add a column for each SKU's percentage of total revenue, and a cumulative percentage column that adds each row's percentage to the running total. Mark each SKU as A, B, or C based on the cumulative percentage thresholds you choose.

After the initial classification, calculate the total inventory investment (current on-hand value) for each category. In a typical ecommerce business, you will find that C items account for a disproportionately large share of total inventory value relative to their revenue contribution. If C items generate 7% of revenue but hold 30% of your inventory value, that is a clear signal that you are over-investing in slow movers and under-investing in the products that actually drive your business. Rebalancing inventory investment toward A and B items improves both turnover and cash flow.

Beyond Revenue: Multi-Criteria ABC Analysis

Revenue-based ABC analysis is the standard starting point, but some products warrant different classification based on factors beyond revenue. A product that generates modest revenue but extremely high profit margins might deserve A-level attention despite its B-level revenue. A product with razor-thin margins and high revenue might not justify A-level safety stock investment because the cost of carrying extra inventory exceeds the margin earned on incremental sales.

Consider running a secondary classification based on gross profit contribution (revenue minus COGS) and comparing it to your revenue-based classification. Products that are A items by both revenue and profit are your absolute priorities. Products that rank as A by revenue but B or C by profit deserve scrutiny: they drive sales but may not be worth the premium inventory investment. Products that rank as B or C by revenue but A by profit are hidden gems that could benefit from more aggressive stocking and marketing.

Other factors to incorporate into a multi-criteria analysis: customer acquisition value (products that frequently serve as a customer's first purchase, even if the product itself is low-revenue), strategic importance (products that complete a product line and drive sales of related items), and supply risk (products from a single source with no backup supplier, where a stockout is harder to resolve). Multi-criteria analysis is more complex than straight revenue classification, but it produces more nuanced inventory policies that better align investment with business value.

How Often to Re-Run ABC Analysis

Re-run your ABC analysis quarterly. Product sales performance shifts over time as trends change, new products gain traction, marketing shifts focus between product lines, and seasonal patterns cycle through the year. A product that was a B item six months ago may have become your 5th best seller (now an A item) or may have declined to nearly zero sales (now a candidate for discontinuation). Quarterly analysis catches these shifts before they result in misallocated inventory investment.

After each quarterly analysis, update your inventory policies for any products that changed classification. If a product moved from B to A, increase its safety stock, add it to the weekly cycle count schedule, and move it to a more accessible warehouse location. If a product moved from B to C, reduce its safety stock and switch to simplified reorder rules. These policy adjustments should flow naturally from the classification change and take no more than an hour to implement for most operations.