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
- 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
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.
- 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 (above)
- 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
6.) Price: The Price for the individual product variant.
For example, the Avocado Ahoy product variant has a Price of $19.99
7.) 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
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 - 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 Report - Return Rate Reports
Order/Product/Product Variant/Vendor Return Rate Return Rate Reports are used to compare how much of something has been sold vs how much has been returned. These reports all follow a very similar format - tracking your Return Rate on a per-order, ...
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 - Sales by Device Type
Sales by Device Type Sales by Device Type is used to see a breakdown of which devices customers are using when they place orders at your store. This report relies on pulling information from the User Agent field on the Order. From this report, you ...