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. 

As a Premium Report, this is available on all Paid Plans of Report Toaster. If you aren't signed up, follow these steps to upgrade your account. 

Please note - This report relies on Formula fields, which means that you will need to download the report to CSV and open in a program like Excel to see the results for ABC Grade (%) and ABC Grade

If you add any other columns to the report, be sure to only add them AFTER the two formula fields (or amend the formulas yourself in Excel).

Otherwise, the formulas will no longer be pointing at the correct columns and thus won't calculate correctly!

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.

For example, if I sold 906 Drifting Ducks in the last 30 days, then 906 would appear in the field. 

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

For example, if the Drifting Ducks made $31,700.94 in Gross Sales out of $646,882.76, that represents 4.90% of the total Gross Sales for the period. 

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

For example, if I sold 906 Drifting Ducks in the last 30 days for 34.99 apiece , then $31,700.94 would appear in the field. 

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

For example, the sum total of all the Gross Sales of these items will reach a cumulative total of 1 (100%)

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. 

For example, the Drifting Duck is one of the best selling product over these last 30 days.

Collectively, it and the other best selling items make up the top 80% of our revenue, so it is given a grade of A.

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.

For other premium reports you can add to your account, check out our other article guides here. 

• Related Articles

• Premium Report - Inventory Value by Location

  Inventory Value by Location Inventory Value Reports are used by merchants to see how much the amounts and value of their current stock. For merchants who store inventory at multiple locations however, sometimes it's important to see your stock on a ...

• Premium Report - Stock Report

  Stock Reports Stock Reports are used to compare how much of something has been sold vs how much you have in stock at each of your different locations. These reports follow a similar format to the Sell Through Reports, but the available quantity ...

• Premium Reports - Inventory Turnover

  Inventory Turnover These reports are used for measuring how much inventory has been sold and replaced over a given period of time. You can customize this time period via the date range (top right). Inventory History needs to be enabled by our Report ...

• Premium Report - Sell Through Reports

  Sell Through Rate (By Product, By Variant, By Vendor) Sell Through Reports are used to compare how much of something has been sold vs how much you have in stock. These reports all follow a very similar format - tracking your Sell Through Rate on a ...

• Premium Report - Stock Intake & Sales Velocity

  Stock Intake & Sales Velocity This report is for merchants who are looking to measure their stock vs. sales in any given month. Using this report, you can see exactly how much you sold of each item, how much you stocked, key metrics like Resale Ratio ...