This report shows sale price fluctuations for all active products during the selected time period. Price history can be further filtered by location, price tier, year, quarter, month and invoice date.
This report is only available to users with Sales Reporting permissions.
Prerequisite
Table of Contents
Data from this report can be exported in Excel, PDF or RTF format.
Input:
Reporting Period | Allows the user to select the reporting period from a list of options or set a custom date range. This report is filtered by invoice date. |
Currency | Allows the user to select the currency to be used in the report. |
Layout | Set to the Default layout. Allows selection of saved layouts, if any. |
Save Layout As | Allows saving a layout for potential future use. |
Reset Layout | Resets the layout to the default layout or selected saved layout. |
Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters.
Output:
The following output fields are available for this report. You may have to open the Configure Layout menu to add some of them to your report.
Fields | |
SKU | Product SKU |
Product | The name of the product |
Unit | Product unit of measure |
Invoice Date | Date of the invoice when price changed to a new value |
Year | Year of the price change date |
Quarter | Quarter of the price change date |
Month | Month of the price change date |
Location | Location this sale is dispatched from |
Category | Product category |
Brand | Product brand |
Product Tags | Comma-separated product tags |
Family | Product family name |
Currency | Currency code this quote is created in |
Price Tier | Name of the price tier the sale is made in |
Product Additional Attribute 1-10 | Values of product additional attributes |
Data Headers | |
Price | Price without discount in customer currency specified in the Currency field |
FAQs
How do we find out the last time we increased a price on a product?
The Sale Price History report shows when a product was sold for a new price (and can show invoice date, invoice month or invoice quarter. There is no other current DEAR feature that shows this information. This can be voted for on our feature request forum, depending on its popularity it will be considered for implementation in a future release.
A product appears in the filter for "This year" but does not appear in the filter for "Last 366 days". Why is this happening? Shouldn't the product appear in both?
This report shows sale price fluctuations. This means that if the price changes, DEAR shows the line with invoice date and price value. In this case, there were sales through the time period, but DEAR only shows the earliest sale for the same price amount. For 366 days period, there was an earlier sale in 2019, so the date is shown as 2019, if you select This year, the earliest date DEAR checks is January 1st 2020, so the first sale for that price was in January as shown.
Still no answer to your question? Please do not hesitate to get in touch with DEAR support.