Order Report field definitions

The following fields are available in the Order Report.

Field Name	Definition	Example	Notes
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.	2007-07-14T18:54:21+00:00	Time zone shown in GMT. Add 9 hours for Japan local time.
payments-date	Date that the buyer's credit card was charged and order processing completed.	2007-07-14T18:54:21+00:00	Time zone shown in GMT. Add 9 hours for Japan local time.
buyer-email	Buyer's email address.	JoeSmith@somecompany.com
buyer-name	Buyer's full name.	Joe Smith	Up to 16 two-byte characters
buyer-phone-number	Buyer's phone number	3236612304	Up to 50 digits
sku	Stock Keeping Unit. The seller-defined unique identifier for a product.	sku123	1 to 40 digits
product-name	Short title for the product, displayed on the product detail page and in the browser title bar.	Snowboard	Up to 70 two-byte characters
quantity-purchased	Quantity purchased.	1
currency	Currency type.	JPY
item-price	Price a buyer paid for the item. All amounts are aggregates of the quantity, not unit prices.	1500
item-tax	Tax a buyer paid connected to the item. All amounts are aggregates of the quantity, not unit prices.	0	Not used in Amazon.co.jp
shipping-price	Price a buyer paid for shipping. All amounts are aggregates of the quantity, not unit prices.	600	Up to 18 digits
shipping-tax	Tax a buyer paid connected to the shipping. All amounts are aggregates of the quantity, not unit prices.	0	Not used in Amazon.co.jp
gift-wrap-price	Price a buyer paid for gift wrap. All amounts are aggregates of the quantity, not unit prices.	300	Available only when gift option is turned on. Up to 18 digits.
gift-wrap-tax	Tax a buyer paid connected to the gift wrap. All amounts are aggregates of the quantity, not unit prices.	0	Not used in Amazon.co.jp. Available only when gift option is turned on.
ship-service-level	Type of shipping selected by the buyer when ordering the item. Standard delivery: Standard Scheduled Delivery: Scheduled Next Day Delivery: NextDay Same Day Delivery: SameDay	standard
recipient-name	Name field of "Ship To" address.	Joe Smith	16 two-byte characters (50 bytes)
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	First line of "Ship To" address.	11 Main St	20 two-byte characters (60 bytes)
ship-address-2	Second line of "Ship To" address.		20 two-byte characters (60 bytes)
ship-address-3	Third line of "Ship To" address.		20 two-byte characters (60 bytes)
ship-city	City of "Ship To" address.	Meguro-ku
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.	Tokyo	16 two-byte characters
ship-postal-code	ZIP code or postal code of "Ship To" address. Value format depends on destination country.	150-0002	Up to 50 alphanumeric characters
ship-country	International Standards Organization two-letter country code (ISO 3166-2 compliant).	JP
ship-phone-number	Recipient's phone number when it's available.		Up to 50 digits
gift-wrap-type	Type of gift wrap selected by the buyer.	Christmas trees	Available only when gift option is turned on. Up to 16 two-byte characters.
gift-message-text	Buyer's gift message.	Merry Christmas!	Available only when gift option is turned on. 160 two-byte characters.
item-promotion-discount	Amount discounted from orders that qualify for either a money-off or a percent-off promotion.	-600	Available only when promotion is turned on.
item-promotion-id	Promotion ID associated with money-off or percent-off promotion.	90103summer	Available only when promotion is turned on. Up to 50 byte.
ship-promotion-discount	Amount discounted from orders that qualify for free shipping.	-400	Available only when promotion is turned on. Up to 18 digits.
ship-promotion-id	Promotion ID associated with free shipping promotion.	100103freeship50	Available only when promotion is turned on. Up to 50 bytes.
delivery-start-date	Earliest possible delivery date, in yyyy-mm-dd format.	2008-08-11T00:00:00+00:00	Not used in Amazon.co.jp. Once scheduled delivery is turned on, this field is removed.
delivery-end-date	Latest possible delivery date, in yyyy-mm-dd format .	2008-08-11T00:00:00+00:00	Not used in Amazon.co.jp. Once scheduled delivery is turned on, this field is removed.
delivery-time-zone	Time zone for the delivery start and end dates.	JST	Not used in Amazon.co.jp. Once scheduled delivery is turned on, this field is removed.
delivery-instructions	Additional delivery instructions.		Not used in Amazon.co.jp.
payment-method	Payment method selected by the buyer.	COD	Available only when "cash on delivery" is turned on. Will appear blank if COD is not selected.
cod-collectible-amount	Amount to be collected through a carrier. If partially payed in advance, the deducted amount will be shown. For multiple items in one order, the total amount will be shown in each item line.	555	Available only when "cash on delivery" is turned on.
already-paid	Partial amount prepaid by a buyer using Amazon Gift Cards or Amazon Points. If partially payed in advance, the deducted amount will be shown. For multiple items in one order, the total amount will be shown in each item line.		Available only when "cash on delivery" is turned on.
payment-method-fee	Cash On Delivery fee.	315	Available only when "cash on delivery" is turned on.
scheduled-delivery-start-date	The scheduled delivery start date. Japan local time entered by the buyer will be shown in yyyy-mm-dd format.	2008-08-11T00:00:00+09:00	Available only when "scheduled delivery" is turned on.
scheduled-delivery-end-date	The scheduled delivery end date. Japan local time entered by the buyer will be shown in yyyy-mm-dd format.	2008-08-11T00:00:00+09:00	Available only when "scheduled delivery" is turned on.
points-granted	Cost of Amazon Points granted to customer.	100	Available only when "adding Amazon Points to order report" is enabled. Up to 18 digits.
Is business order? is-business-order	Indicates if the order is from an Amazon Business customer.	true, false	If the order is from an Amazon Business verified customer, "true" is shown in the column.
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 Number	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

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.

Reach hundreds of millions of customers

Start selling on Amazon