Premium Report - ABC Inventory

ABC Inventory

Much like the Shopify ABC Inventory Analysis report, this report asigns a letter grade (A, B, or C) to each inventory item based on its sales performance.

For those of you who aren't familiar with Shopify's ABC grade for Inventory, the breakdown is as follows:

1. A-grade: These are your top-selling products, that collectively account for around 80% of your revenue (Gross Sales)
2. B-grade: These products collectively account for 15% of your revenue.
3. C-grade: These products collectively account for 5% of your revenue.

This report is useful to see which items contribute towards the bulk of your revenue so you can manage your inventory accordingly.

Here is what you need to be familiar with to understand the ABC Inventory report:

**1.) Quantity:**How many units were sold of the specific product.

**2.) Gross Sales (% Total):**What percentage of the total does the Gross Sales (below) of this item represent.

**3.) Gross Sales:**The Price x Quantity of the units sold within that period.

**4.) ABC Grade (%):**Formula Field - This formula turns Gross Sales (% Total) into a cumulative total so that the Grade (below) can be determined.

**5.) ABC Grade:**Formula Field - The formula assigns an A, B, or C Grade (see intro) to this product based on how it contributes to your overall revenue.

Like all Report Toaster reports, these reports are fully customizable - so you can adjust the date range, add/remove columns, introduce a filter or change the sort to suit your individual needs. See our basic guides here for more info.