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

Order 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.

Column Name Definition
Order ID

order-id

Amazon's unique identifying number for the order. Used for shipping confirmation and post-order processing.

Example: 058-3563777-5518068

Order item ID

order-item-id

Amazon's unique identifying number for the item in an order. Used for shipping confirmation and post-order processing.
Purchase date

purchase-date

Date the order was placed, in yyyy-mm-dd format.
Note: Unless you specify a different shipping lead time, you have agreed to ship the order within two business days of this date.
Payment date

payments-date

Date that the buyer's credit card was charged and order processing completed, in yyyy-mm-dd format.
Buyer email

buyer-email

Buyer's email address

Example: johndoe@somecompany.com

Buyer's full name

buyer-name

Buyer's full name

Example: John Doe

SKU

sku

Stock Keeping Unit. The seller-defined unique identifier for a product.

Example: AA786936215595

Product name

product-name

Short title for the product, displayed on the product detail page and in the browser title bar.

Example: Snowboard

Quantity purchased

quantity-purchased

Quantity purchased.
Currency

currency

Currency type

AED

Item price

item-price

Price a buyer paid for the item(s). All amounts are aggregates of the quantity, not unit prices.

Example:

Item Price = AED10
Quantity = 2
Item price displayed = AED20

Shipping price

shipping-price

Price a buyer paid for shipping. All amounts are aggregates of the quantity, not unit prices.
Ship service

ship-service-level

Type of shipping selected by the buyer when ordering the item; for example, standard, expedited.
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.
Ship address (3 columns)

ship-address-1

First line of "Ship To" address.
ship-address-2 Second line of "Ship To" address.
ship-address-3 Third line of "Ship To" address.
Ship city

ship-city

City of "Ship To" address.
Ship state

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.
Ship country

ship-country

International Standards Organization two-letter country code (ISO 3166-2 compliant).

Example: US

Delivery instructions

delivery-instructions

Additional delivery instructions.
Order channel

order-channel

Information about how an order was placed.
Order channel instance

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
Buyer Requested Cancel The toggle button for Buyer Requested Cancel should be turned on for getting the status of the Buyer requested cancellation requests in the order reports
Notes:
  • purchase-order-number is added by default for all Amazon Business customers and can be toggled on or off using the Order Report Column Picker. The purchase-order-number must be provided on the customer package packing slip or on the package shipping label.
  • 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.
Important: Your order reports now include an email address that you can use to contact your buyer regarding your transaction with the buyer. Note that if you choose to use this email address to communicate with your buyer, that email message and all further communications between you and your buyer using this service will be copied and stored by Amazon. By using this service, you consent to this action. Learn more about Buyer-Seller Messaging.
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