The following fields are available in the Order Report.
This list is not exhaustive. Additional fields might be available for the order report. For more information, go to CustomisationInfo and CustomerOrderInfo Fields.
|Order-id||Amazon's unique identifying number for the order. Used for shipping confirmation and post-order processing.||736-3563777-5518068|
|order-item-id||Amazon's unique identifying number for the item in an order. Used for shipping confirmation and post-order processing.||0583563777345|
|purchase-date|| Date the order was placed.
Note: Unless you specify a different delivery lead time, you have agreed to ship the order within 2 working days of this date.
|payments-date||Date that the buyer's credit card was charged and order processing completed.||05-17-2011|
|buyer-name||Buyer's full name.||Joe Smith|
|buyer-email||Buyer's email address.||
|sku||Stock Keeping Unit. Seller-defined unique identifier for a product.||sku123|
|item-name||Short title for the product, displayed on the product detail page and in the browser title bar.||Snowboard|
|currency||The currency used for the transaction.||
|sales-channel|| Website on which the order was placed.
Note: The sales-channel column will only be included if you selected the "Include Sales Channel Column?" box when requesting the report.
|item-price||The amount that the buyer paid for the item. All amounts are aggregates of the quantity, not unit prices.||349.99|
|Gift-wrap-price||Price a buyer paid for gift wrap. All amounts are aggregates of the quantity, not unit prices.|
|shipping-price||Price a buyer paid for shipping. All amounts are aggregates of the quantity, not unit prices.||19.99|
|ship-service-level||Fulfilment service level paid for by the buyer when ordering the item. For example, standard or expedited.||Standard|
|Name field of "Ship To" address|
|Recipient name + PO Number||Enables the purchase order (PO) number to be appended to the Recipient name field in Order Details, Order Reports and Marketplace Web Service when a business customer provides a PO number for seller fulfilled orders. Disable this if you are already including the PO number on the shipping label and packing slip, or do not want to include the PO number for other reasons. For more information, see our Help page, What do I need to know about packing slips and purchase order numbers?|
|ship-address-1||The first line of the "Ship To" address.||
11 Main St
|ship-address-2||Name field of "Ship To" address.||Apt. 12|
|ship-address-3||First line of "Ship To" address.||c/o Joe's Company|
|ship-city||Second line of "Ship To" address.||
|ship-state||Third line of "Ship To" address.||
|ship-postal-code||City of "Ship To" address.||
|ship-country||The international standard two-letter country code (ISO 3166-compliant).||
|item-promotion-discount||Money amount discounted from orders that qualify for either a money-off or a percent-off promotion.|
|item-promotion-id||Promotion ID associated with money-off and percent-off promotions.|
|shipping-promotion-discount||Money amount discounted from orders that qualify for free delivery.|
|shipping-promotion-id||Promotion ID associated with free delivery promotions.|
|delivery-start-date||Earliest possible delivery date.|
|delivery-end-date||Latest possible delivery date.|
|delivery-time-zone||Time zone for the delivery dates.|
|delivery-instructions||Additional instructions for delivering to a specific address.|
|order-channel||Information about how an order was placed.|
|order-channel-instance||Information about how an order was placed.|
|Is business order?
Indicates if the order is from an Amazon Business customer.
|Purchase order number
The buyer's purchase order number (for orders from Amazon Business customers).
|default-ship-from-address-name||The warehouse or the business name used in the Seller Central account shipping settings/template|
|Default Ships From Location (3 columns) default-ship-from-address-field-1||First line of "Default Ship From" address|
|default-ship-from-address-field-2||Second line of "Default Ship From" address|
|default-ship-from-address-field-3||Third line of "Default Ship From" address|
|default-ship-from-address-city||City of "Default Ship From" address|
|default-ship-from-address-state||State of "Default Ship From" address|
|default-ship-from-address-country||Country of "Default Ship From" address|
|default-ship-from-address-postal-code||ZIP code or postal code of "Default Ship-From" address; value format depends on destination country.|
|actual-ship-from-address-name||The warehouse or the business name that is chosen while confirming the order|
|Actual Ships From Location (3 columns) actual-ship-from-address-1||First line of "Actual Ship From" address|
|actual-ship-from-address-field-2||Second line of "Actual Ship From" address|
|actual-ship-from-address-field-3||Third line of "Actual Ship From" address|
|actual-ship-from-address-city||City of "Actual Ship From" address|
|actual-ship-from-address-state||State of "Actual Ship From" address|
|actual-ship-from-address-country||Country of "Actual Ship From" address|
|actual-ship-from-address-postal-code||ZIP code or postal code of "Actual Ship-From" address; value format depends on destination country|
|TCM||Tax Collection Model, Tax Collection Responsible Party|
|IOSS Number||Import One Stop Shop (IOSS) number for the marketplace. Sellers dispatching to the EU from non-EU must provide this IOSS number to their carrier where Amazon has collected the VAT on the sale. 12 alphanumeric characters with the following structure: IMXXXYYYYYYZ||IMXXXYYYYYYZ|
|Buyer Requested Cancel||The toggle button for Buyer Requested Cancel should be turned on for getting the status of the Buyer-requested cancellation requests in the order reports|