Amazon has two sales reports. The Amazon Vendor Report and the Kindle KDP Royalties Report.
This lesson covers the field mappings for the Amazon Vendor Report. This report shows of digital and physical products in a single report.
This file is a multi-currency report. During the import process the software will prompt for the exchange rates for each foreign currency in the report. The Amazon Vendor report includes the exchange rates used in the invoice row(s) for each currency. Before importing the Amazon report we recommend that you review the report and list the exchange rates used.
Sales Import Mappings
The Amazon Vendor Report includes dates in multiple formats (MDY, YMD and DMY). Enter the last date of the date range for the report in the “or use this value” field mapping column to record the sale date.
|Insert into:||From (your column headers):||or use this value:|
|SaleCurrency||Payment Amount Currency|
Ignore when any of the following fields are blank should have a value of Net Units and the ProductID field. This will cause the royalty software to ignore the invoice line items.
The Amazon Vendor Report has separate fields for ASIN, Physical-ISBN-13 and Digital ISBN.
If your sales file only has sales for Format: Kindle eBook you can use the Digital ISBN as the ProductID.
If your sales files has sales for physical and digital products you can use the Amazon ASIN; if you mapped this to the edition’s SKU field or Vendor code field. If not, you will need to import the sales file twice; once using the Physical-ISBN-13 and once with the Digital ISBN.