Premium Report - Sales by Compare at Price

Sales by Compare at Price

These reports is used for seeing which products are selling at Full Price vs Markdown. This is determined by looking for any instances of where the product's actual sold Price differs from its Compare at Price. 

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. 

Using these reports, you can see which products sold at which price level, as well as which products are missing their Compare at Price. 

These reports are essentially the same, it's just that one provides your totals for each pricing tier: 

And the other provides a breakdown by individual product:

Here are a few terms to be familiar with in order to understand our Price Markdown reports, numbered in the screenshots above:

1.) Price Status: The Price level for the specific product. This is broken down into 

1. Markdown. Where the Price the product sold for is less than the Compare at Price. 
   
2. Full Price. Where the Price the product sold for is equal to the Compare at Price.
   
3. Missing Compare At. Where no Compare at Price is set for the product in question

For example, if the Avocado Ahoy product had a Compare at price of $25.99 and sold for $19.99, it would be listed as Markdown. 

2.) Quantity: The quantity of that product sold at that particular price tier. 

For example, if 1,335 of the Avocado Ahoy product sold at Markdown, then 1,335 would populate the field. 

3.) Gross Sales: The Price x Quantity for that product at that particular price tier. 

For example, if 1,335 of the Avocado Ahoy product sold for $19.99 each, then $26,686.65 would appear in the Gross Sales field. 

4.) Gross Sales (Compare at Price): The Compare at Price x Quantity for that product at that particular price tier. 

1. For Markdown products, this represents how much they 'would have sold for' had they actually been bought at the full price. 
   
2. For Full Price Products, this is identical to Gross Sales (above)
   
3. For Missing Compare At, this is 0.00 - because there is no Compare At Price for those products. 

For example, if 1,335 of the Avocado Ahoy product sold, and the Compare at Price is $25.99 each, then $34,696.65 would appear in the Gross Sales (Compare at Price) field.  

5.) Markdown Total: Gross Sales (Compare at Price) minus the Gross Sales

For example, if the Gross Sales (Compare at Price) for the Avocado Ahoy was $34,696.65 and the Gross Sales was $26,686.65, then we know that the Markdown Total was $8,010.00.

6.) Compare at Price: The Compare at Price for the individual product variant. 

For example, the Avocado Ahoy product variant has a Compare at Price of $25.99 

7.) Price: The Price for the individual product variant. 

For example, the Avocado Ahoy product variant has a Price of $19.99 

8.) Markdown Amount: The Compare at Price minus the Price for the individual product variant. 

For example, if the Avocado Ahoy has a Compare at Price of $25.99 and a Price of $19.99, then the Markdown Amount is $6.00. 

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.

If you want to see our other premium reports, check out our main section here.

• Related Articles

• Premium Report - Product Cleanup

  Product Cleanup This report is for merchants who are looking to update and cleanup their products in Shopify. Using this report, you can see exactly which products are missing which values, navigate directly to them in Shopify (click the hyperlink ...

• Whats New? - October 2023

  Another month has passed, and we're now ready to show off a few new Premium Reports! Premium reports are any reports that provide extra data or advanced metrics that assist merchants in making better decisions. For example, here are our Sales by ...

• 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 ...

• Premium Report - Sales by Discounts (All)

  Sales by Discounts (All) A more sophisticated version of our regular Sales by Discounts (Codes Only) report, this report pulls together all of the discounts that can be applied to an order. This includes both: Manual Discounts - Discounts that are ...

• 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 ...