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 |