Orders Report Field Definitions

The following fields are available in the Order Report.

This list is not exhaustive. Additional fields may be available for the order report. See CustomizationInfo and CustomerOrderInfo Fields.

Field name	Definition	Example
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.	05-17-2011
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.	a222d34b3891234b@marketplace.amazon.co.uk
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
quantity-purchased	Quantity purchased.	1
currency	The currency used for the transaction.	GBP
sales-channel	Website on which the order was placed. Note: The sales-channel column will be included only if you ticked the "Include Sales Channel Column?" box when requesting the report.	Amazon.co.uk
item-price	The amount 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
Recipient name recipient-name	Name field of "Ship To" address
Recipient name + PO Number	Enables the purchase order (PO) number to append 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 if you are already including the PO number on the shipping label and packing slip or don’t 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.	Slough
ship-state	Third line of "Ship To" address.	Berks. Berkshire
ship-postal-code	City of "Ship To" address.	SL1 1QP
ship-country	The international standard two-letter country code (ISO 3166 compliant).	UK
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? is-business-order	Indicates if the order is from an Amazon Business customer.	true, false
Purchase order number purchase-order-number	The buyer's purchase order number (for orders from Amazon Business customers).	BT1231456
Price designation price-designation	Indicates the type of business price that the buyer used.Learn more about business prices. (Amazon Business Seller Program only.)
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 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

Reach Hundreds of Millions of Customers

Start Selling on Amazon