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 sale Price differs from its Compare at Price - the Shopify equivalent of the Recommended Retail Price (RRP).

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

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

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

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

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

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

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

6.) Discount Percentage: The Markdown Amount divided by Variant / Compare at Price x100.

7.) Variant / Compare at Price: The Compare at Price for the individual product variant.

8.) Variant / Price: The Price for the individual product variant.

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

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.