The Price Range Variance report lists only those products whose selling price has a variance during the date period selected meaning there is a low and a high price. This reports provides pricing analysis for products so you get a better understanding of the price range variances for product sales. If you are using a re-pricer, this report is a must use.
Click here to view the video for the Amazon Price Range Variance report.
Column Headings & Field Mappings
Column
|
Table
|
Data Field
|
Type
|
Description
|
Product SKU
|
Prods
|
ProdSKU
|
Data
|
Product SKU
|
FN SKU
|
Prods
|
ProdFNSku
|
Data
|
Amazon Fulfillment Network SKU
|
ASIN
|
Prods
|
ASIN
|
Data
|
Amazon Standard Identification Number (ASIN)
|
Barcode
|
Prods
|
Barcode
|
Data
|
Product Barcode
|
UPC
|
Prods
|
UPC
|
Data
|
Universal Product Code (UPC)
|
EAN
|
Prods
|
EAN
|
Data
|
International Article Number (EAN)
|
Product Name
|
Prods
|
ProdName
|
Data
|
Product name or listing title
|
Nbr Ords
|
OrdersDetail
|
Proprietary Algorithm
|
Calculated
|
Number or orders containing the SKU
|
Qty Sold
|
OrdersDetail
|
Proprietary Algorithm
|
Calculated
|
Total number of units sold
|
Low
|
|
Proprietary Algorithm
|
Calculated
|
Lowest Selling Price
|
High
|
|
Proprietary Algorithm
|
Calculated
|
Highest Selling Price
|
Avg
|
|
Proprietary Algorithm
|
Calculated
|
Average Selling Price
|
Variance
|
|
High - Low
|
Calculated
|
Difference between High and Low Price
|
Variance %
|
|
Proprietary Algorithm
|
Calculated
|
Percent difference between High and Low Price
|
Category
|
Prods
|
CatID
|
Data
|
Category assignment
|
Brand
|
Prods
|
BrandID
|
Data
|
Brand/Product Line assignment
|
Supplier SKU
|
Prods
|
SuppSKU
|
Data
|
Supplier SKU
|
Supplier
|
Supps
|
SuppsName
|
Data
|
Supplier Name
|
|