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.


Table of Contents

Data from this report can be exported in Excel, PDF or RTF format. 


Reporting PeriodAllows 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.
CurrencyAllows the user to select the currency to be used in the report.
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving a layout for potential future use.
Reset LayoutResets 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. 


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. 

SKUProduct SKU
ProductThe name of the product
UnitProduct unit of measure
Invoice DateDate of the invoice when price changed to a new value
YearYear of the price change date
QuarterQuarter of the price change date
MonthMonth of the price change date
LocationLocation this sale is dispatched from
CategoryProduct category
BrandProduct brand
Product TagsComma-separated product tags
FamilyProduct family name
CurrencyCurrency code this quote is created in
Price TierName of the price tier the sale is made in
Product Additional Attribute 1-10
Values of product additional attributes
Data Headers
Price without discount in customer currency specified in the Currency field


[back to top]

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.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.