Sell on Amazon Sign In
This article applies to selling in: Japan

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.
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-2022, Amazon.com, Inc. or its affiliates