Almost every e-commerce assortment hides the same uncomfortable truth: a small share of your products drives nearly all of your volume. The rest sits on the shelf, racks up storage costs, and ties up capital. ABC analysis makes exactly that visible. Until now, that meant exporting data, opening Excel, building a pivot, sorting, and accumulating. With byrdAI, it means asking a question.
In this article, we show you what an ABC analysis is, how to build one with byrdAI as an interactive dashboard in under two minutes, and, more importantly, which decisions to draw from it.
ABC analysis splits your assortment into three classes based on the Pareto principle:
It sounds academic, but it is the basis for very concrete questions: which products can never go out of stock? Where is safety stock worth holding? And which 100 or 3,000 SKUs are really just generating storage costs?
Three pain points merchants raise with us again and again:
Stockouts on the wrong products.
When a C-item sells out, almost nobody notices. When your A-item sells out, you lose revenue and rankings every single day. Without ABC classification, you treat both the same.
Dead capital in the long tail.
C-items occupy storage locations you pay for every month. Some of that belongs in your assortment; some of it belongs in a clearance sale, a bundle, or a delisting.
Counting effort with no priorities.
Counting and maintaining every SKU at the same frequency wastes time on products almost nobody orders.
byrdAI is byrd's MCP server. It connects your live fulfillment data directly to Claude or ChatGPT. Once connected, a single prompt is enough:
"Run an ABC analysis of my inventory and explain each class."
Your AI assistant calls the byrd report report_abc_analysis and returns the classification with current numbers. In Claude, you can go one step further. With our ready-made dashboard prompt (copyable with one click on the byrdAI page), Claude builds you an interactive live dashboard that pulls fresh data from byrd every time you open it.
The dashboard shows you at a glance:
The Pareto curve.
Every shipped SKU as a bar, sorted by volume, with the A, B, and C zones colour-coded. In our sample assortment, 107 of roughly 900 SKUs make up a full 80% of volume. The last 620 SKUs combined: 5%.
The concentration of your demand.
A single value (the Gini index) tells you how dependent you are on a handful of products. High concentration means your bestsellers need special protection. Low concentration means your risk is spread out, but your assortment is more complex to manage.
Policy cards per class.
For A, B, and C items, the dashboard suggests a treatment directly: service level, counting cadence, and safety-stock strategy.
The analysis is only as good as what you do next. Proven takeaways per class:
A-items: Service level of 98 to 99%, weekly inventory checks, generous safety stock, preferred storage locations. Every day of stockout here costs real money.
B-items: Monthly checks, moderate safety stock. Watch the SKUs sitting on the border with A in particular: those are your risers.
C-items: Review quarterly. And question them honestly: which C-items earn their storage location? Clearance campaigns, bundles with A-items, or delisting free up capital and space here.
This is the real difference from any dashboard report: you can not only view the analysis, but also process it further and automate it.
Adjust.
"Show me bundles only." "Use 70/90 instead of 80/95 as the thresholds." "Compare this quarter with the last one." Your assistant rebuilds the report live.
Schedule.
Have the ABC analysis rebuilt automatically every quarter and sent to you as a summary, by email or straight into your Slack channel.
Trigger.
Combine the classes with other byrd reports: "If an A-item drops below 14 days of cover, draft the reorder email to my supplier immediately." That gives your most important product class an automatic early-warning system.
Take it further.
With a follow-up prompt, your C-items turn into a clearance list including the capital tied up in them. One of our merchants used this to uncover €442,000 locked up in slow movers and overstock.
If you are already a byrd customer: connect byrdAI to Claude or ChatGPT (it takes around 5 minutes) and copy the ABC prompt from our byrdAI page or from the box below. If you are not a byrd customer yet: byrdAI comes only with byrd fulfillment, as the first European 3PL with an MCP server. Talk to us, and we will show you both together.
Example prompt for the ABC analysis report (adjust it however you like).
How often should I run the ABC analysis?
Quarterly is the right rhythm for most merchants. With byrdAI, rebuilding it costs no time, so a monthly look at movements between the classes is worth it too.
What is the difference from the top-mover report?
The top-mover report shows your bestsellers as a ranking. ABC analysis classifies your entire assortment and turns it into action rules per class.
Do I need Excel or a BI tool for this?
No. byrdAI delivers the analysis directly in Claude or ChatGPT, as an interactive dashboard with filters, charts, and a table if you want.
What does byrdAI cost?
During the beta, byrdAI is included free in your account for byrd customers.