Calculator

ABC-XYZ Analysis for Shopify: Add Demand Variability to Your Product Ranking

Revenue rank alone hides which best sellers are unpredictable. Add demand variability and see where to focus.

The ABC analysis on its own ranks products by revenue, and it treats a best seller that sells 40 units every week the same as one that sells nothing for a month and then 200 in a weekend. They need very different buying. ABC-XYZ analysis adds a second question: how steady is the demand? Paste each product's revenue and its units per period into the tool below, and it returns the ABC class, the XYZ class and a nine-cell matrix, so you can see which products need tight control, which need a buffer and which need a different approach altogether. The products and numbers shown are examples.

The ABC-XYZ Tool

2 of your 4 class A products have erratic demand (Z). Plan those with extra care: they carry the most revenue and are the hardest to predict.
ProductRevenueShareCumulativeABCVariationXYZClass
Cloud Hoodie12,00036.5%36.5%A5.6%XAX
Everyday Tee8,50025.8%62.3%A5.1%XAX
Canvas Tote5,20015.8%78.1%A45.4%ZAZ
Wool Beanie3,1009.4%87.5%A120.5%ZAZ
Ceramic Mug1,8005.5%93%B6.5%XBX
Enamel Pin Set1,2003.6%96.7%B142.3%ZBZ
Sticker Pack7002.1%98.8%C12.9%YCY
Phone Strap4001.2%100%C223.6%ZCZ
ProductsXYZ
A202
B101
C011

Example values only. Variation is the standard deviation of your period units divided by their average, as a percentage. Nothing you paste leaves your browser.

Nine-cell ABC-XYZ matrix: rows A, B and C for revenue importance and columns X, Y and Z for demand stability, with a short note in each cell on how to buy that group
Revenue tells you how much a product matters. Variation tells you how hard it is to plan.

How the XYZ Class Works

For each product, take the units sold in every period, find the average and the standard deviation, and divide the second by the first. The result is the coefficient of variation: a product that sells almost the same amount every week has a low value, and one that lurches between zero and a spike has a high one. This tool uses the population standard deviation, so every period you paste counts equally.

The cutoffs are a convention, not a law. Published sources use different ones, for example 10 and 25 percent in one and 15 and 30 percent in another, which is why the tool lets you change them. Pick a pair, write it down and use it every time, so changes in a product's class mean something. Shopify's inventory segmentation guide describes XYZ in qualitative terms: steady demand, demand that follows a pattern and sporadic demand.

What Each Group Needs

Traps to Avoid

What Waiting Lists Add

Sales history only counts sales. When a product is sold out, the demand shows up as signups instead. Griffin, a Shopify back-in-stock app, adds a Notify Me popup or inline form to sold-out products, and shoppers sign up for the variant they want. Because signups are recorded per product and variant, a Z product with a long waiting list tells you the real demand was higher than its sales; our guide to tracking demand on out-of-stock products shows how to read it. The free plan includes 100 notifications a month. Griffin does not rank or classify products. For the revenue half of this analysis, start with the ABC analysis tool.

Your erratic best sellers will sell out. Griffin makes sure the demand you cannot serve still shows up as signups.

Install Griffin on Shopify

FAQ

What is ABC-XYZ analysis?

It combines two rankings. ABC sorts products by how much revenue they bring in, and XYZ sorts them by how stable their demand is from period to period. Crossing them gives nine groups, such as AX for a high-revenue, steady seller and AZ for a high-revenue product with erratic demand.

How is the XYZ class calculated?

Take the units sold in each period, work out the average and the standard deviation, and divide one by the other to get the coefficient of variation. Low values mean steady demand (X) and high values mean erratic demand (Z). The cutoffs are a convention that differs between sources, so choose them and keep them fixed.

How many periods of sales do I need?

Use at least six weekly or monthly periods per product if you can, and the same window for every product. With very few periods one unusual week can swing the result.

Does Griffin classify products this way?

No. Griffin captures restock signups on sold-out products and variants and emails those shoppers when the item is back. It does not rank products, though waiting lists can show demand a sales history cannot.

The Bottom Line

ABC tells you which products matter, and XYZ tells you which are hard to plan. Together they point your attention at the AZ group first and let you relax about the rest. Griffin is a Shopify back-in-stock app you can install from the Shopify App Store, free to start.