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

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. For more information, go to 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.fr

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.

EUR

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

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 Rue Rollin

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.

Bordeaux

ship-state Third line of "Ship To" address.

Aquitaine

ship-postal-code City of "Ship To" address.

33000

ship-country The international standard two-letter country code (ISO 3166 compliant).

FR

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 if the buyer received a business price. (Amazon Business Seller Program only.)

Number-of-items

Number-of-items

Indicates the total number of items that are included in an ASIN.

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

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

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