A useful first step. No signup.

Free ABC Analysis Calculator for Inventory

Find the few products that carry most of your value. Open a WooCommerce Analytics export or paste a list, then download the classes. Your data stays in your browser.

Free to useNo email requiredYour entries stay in this page

Classify your products

Example values are shown. Your file is read in this page and never uploaded.

What ABC analysis does

ABC analysis ranks your products by value, then splits them into three groups, so you can spend your attention where the money is. It rests on the observation that a small part of a range usually accounts for most of its value.

  1. Work out each product's yearly value, usually units sold × unit cost.
  2. Sort from highest to lowest and keep a running total.
  3. Products up to the first limit are A, those up to the second are B, and the rest are C.

The usual limits are 80% and 95%, and you can change them above. They're conventions rather than rules. A product belongs to the class it starts in, so one best seller holding 90% of your value is still an A when the limit is 80%.

A worked example

A store's yearly value is 40,000, and its five products are worth 22,000, 10,000, 5,000, 2,000 and 1,000.

  1. The first starts at 0% and ends at 55%, so it's an A.
  2. The second starts at 55%, still under 80%, so it's also an A. The running total reaches 80%.
  3. The third starts at exactly 80%, so it's a B. The total reaches 92.5%.
  4. The fourth starts at 92.5%, under 95%, so it's a B too. The total reaches 97.5%.
  5. The last starts above 95%, so it's a C.

Getting the data out of WooCommerce

Go to Analytics, then Products, choose a year as the date range, and click Download. WooCommerce's export has columns called "Product title", "SKU", "Items sold" and "N. Revenue". You can open that file here as it is, and products will be ranked by net revenue. A product with no SKU uses its title instead. Products that didn't sell in that period don't appear in the report, so also look through your catalogue for dead stock.

Revenue is fine for deciding what to watch, but it can flatter low-margin products. To rank by what you've tied up in stock, use your own file with "Units" and "Unit cost" columns. If a file has both, the tool uses units × cost.

What to do with each class

  • A: watch closely. Count these most often, keep your supplier lead times current, and review their safety stock and reorder points regularly.
  • B: run on a routine. Standard reorder rules and regular counts are enough, with a closer look if one is moving up.
  • C: keep it simple. Order less often and count less often. Check the slowest for products to discount or drop.

Value isn't everything. A cheap part that stops a best seller from shipping deserves more attention than its class suggests, and a new product has no history yet. Run the analysis again as the year goes on, since classes change. It also gives you a schedule for cycle counting, counting A items more often than C items.

Frequently asked questions

What is ABC analysis in inventory management?

A way to rank products by value and split them into three groups. A items are the small group that holds most of the value, B items are the middle group, and C items are the many products that add up to little. Each group then gets a suitable level of attention.

How do you calculate ABC analysis?

Multiply each product's yearly units by its unit cost, sort from highest to lowest, and keep a running percentage of the total. Products up to the first limit, usually 80%, are A. Those up to the second, usually 95%, are B. The rest are C.

What percentages should I use?

80% and 95% are the common starting points, but they are conventions rather than rules. Use limits that give you an A group small enough to manage closely.

Can I use revenue instead of cost?

Yes. Revenue is easier to get, and it's what a WooCommerce Analytics export contains. It can flatter low-margin products, though, so use units × cost if you're deciding where your cash is tied up.

How often should I redo an ABC analysis?

Often enough to catch changes in your range, so at least once a year, and more often if your range or sales change quickly. New products have no history, so review those by hand.

Is my file uploaded?

No. The file is read by JavaScript in this page and doesn't leave your computer.

Take the next step

Count your A items more often.

Stocktake lets you count WooCommerce stock with a phone scanner, review the differences in units and money, then apply them with a backup and one-click undo.

Explore Free and Pro →Read the step-by-step guide

More free tools

Free browser tool

Inventory count sheet

Open a WooCommerce stock CSV, count products in a browser worksheet, or download a printable inventory count sheet PDF. Review differences and export your count record.

Open tool →
Free browser tool

EOQ calculator

Find the cheapest order size, rounded to your pack size and supplier minimum, and compare it with what you order now.

Open tool →
Free browser tool

SKU generator

Turn product names and attributes into readable, unique SKUs, with a list or a WooCommerce import file to download.

Open tool →