Sell on Amazon Sign in
This article applies to selling in: Canada

Orders Report Field Definitions

The following fields are available in the Order Report.

Field Name Definition Example
order-id Amazon's unique identifying number for the order. Used for shipping confirmation and post-order processing. 058-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 shipping lead time, you have agreed to ship the order within two business days of this date.
2002-11-19
payments-date Date that the buyer's credit card was charged and order processing completed. 2002-11-19
buyer-email Buyer's email address. JoeSmith@somecompany.ca
buyer-name Buyer's full name. Joe Smith
sku Stock Keeping Unit. The seller-defined unique identifier for a product. sku123
product-name Short title for the product, displayed on the product detail page and in the browser title bar. Snowboard
quantity-purchased Quantity purchased. 1
currency Currency type. CND
item-price Price a 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
item-tax Tax a buyer paid connected to the item. All amounts are aggregates of the quantity, not unit prices. 9.99
gift-wrap-tax Tax a buyer paid connected to the gift wrap. All amounts are aggregates of the quantity, not unit prices.

shipping-tax Tax a buyer paid connected to the shipping. All amounts are aggregates of the quantity, not unit prices. 1.99
ship-service-level Type of shipping selected by the buyer when ordering the item. standard
recipient-name Name field of "Ship To" address. Joe Smith
ship-address-1 First line of "Ship To" address. 11 Main St
ship-address-2 Second line of "Ship To" address. Apt. 12
ship-address-3 Third line of "Ship To" address. c/o Joe's Company
ship-city City of "Ship To" address. Springfield
ship-state State, province, or region of "Ship To" address. Varies with country of origin.
Note: Abbreviations can vary depending on how it was entered by the buyer.
AB Alberta
ship-postal-code ZIP code or postal code of "Ship To" address. Value format depends on destination country. T1A 403
ship-country International Standards Organization two-letter country code (ISO 3166-2 compliant). CA
gift-wrap-type Type of gift wrap selected by the buyer. Christmas trees
gift-message-text Buyer's gift message. Merry Christmas!
sales-channel Website on which the buyer placed the order. Amazon.ca
item-promotion-discount 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 or percent-off promotion.

shipping-promotion-discount Amount discounted from orders that qualify for free shipping.

shipping-promotion-id Promotion ID associated with free shipping promotion.

delivery-start-date Earliest possible delivery date.

delivery-end-date Latest possible delivery date.

delivery-time-zone Time zone for the delivery start and end dates. PST
delivery-instructions Additional delivery instructions.

order-channel Information about how an order was placed.

order-channel-instance Information about how an order was placed.

default-ship-from-address-name The warehouse or the business name used in the Seller Central account shipping settings/template

Default Ship 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 chose while confirming the order

Actual Ship 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-Nummer Import one-stop shop (IOSS) number for the marketplace. Sellers shipping to the EU from non-EU countries 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

Note: Additional fields are available for the Orders Report if you use the MWS API to retrieve the report using an XML feed. Visit CustomizationInfo and CustomerOrderInfo Fields.
Sign in to use the tool and get personalized help (desktop browser required). Sign in


Reach Hundreds of Millions of Customers

Start Selling on Amazon


© 1999-2021, Amazon.com, Inc. or its affiliates