The report Lists all of your products from your Products database without any qualifiers. Products with sales only by default or list all products regardless of sales. This report features Gross Margin (GM) and Gross Margin Percent (GM %).
Click here to view the video for the Amazon Product Listing report.
Column Headings & Field Mappings
Column
|
Table
|
Data Field
|
Type
|
Description
|
Product SKU
|
Prods
|
ProdSKU
|
Data
|
Product SKU
|
ASIN
|
Prods
|
ASIN
|
Data
|
Amazon Standard Identification Number (ASIN)
|
FN SKU
|
Prods
|
ProdFNSku
|
Data
|
Amazon Fulfillment Network SKU
|
Barcode
|
Prods
|
Barcode
|
Data
|
Product Barcode
|
UPC
|
Prods
|
UPC
|
Data
|
Universal Product Code (UPC)
|
Product Name
|
Prods
|
ProdName
|
Data
|
Product name or listing title
|
Qty OH
|
Prods
|
QtyOH
|
Data
|
Quantity On Hand
|
Qty OO
|
Prods
|
QtyOO
|
Data
|
Quantity On Order
|
Qty FBA
|
Prods
|
QtyFBA
|
Data
|
Quantity at FBA
|
Qty Tot
|
Prods
|
QtyOH + QtyFBA
|
Calculated
|
Quantity Total
|
Nbr Ords
|
OrdersDetail
|
Proprietary Algorithm
|
Calculated
|
Number or orders containing the SKU
|
Last Date
|
OrdersDetail
|
Proprietary Algorithm
|
Calculated
|
Last Date Sold
|
Last Order
|
OrdersDetail
|
Proprietary Algorithm
|
Calculated
|
Last Order ID Sold
|
Qty Sold
|
OrdersDetail
|
Proprietary Algorithm
|
Calculated
|
Total number of units sold
|
Cogs
|
OrdersDetail
|
CostPerUnit * Units Sold
|
Calculated
|
Total cost of goods sold (Cogs) for the product
|
Sales
|
OrdersDetail
|
PricePerUnit * Units Sold
|
Calculated
|
Total sales for the product
|
GM
|
|
Proprietary Algorithm
|
Calculated
|
Total Gross Margin (GM)
|
GM %
|
|
Proprietary Algorithm
|
Calculated
|
Total Gross Margin Percent (GM %)
|
Days Since
|
|
Proprietary Algorithm
|
Calculated
|
Days since last sale
|
Brand
|
Prods
|
BrandID
|
Data
|
Brand/Product Line assignment
|
Category
|
Prods
|
CatID
|
Data
|
Category assignment
|
Supplier
|
Supps
|
SuppName
|
Data
|
Supplier Name
|
Supplier SKU
|
Prods
|
SuppSKU
|
Data
|
Supplier SKU
|
|