阅读订单报告

订单报告生成完毕后，点击【下载】按钮，并将文件保存到您的本地硬盘。然后您可以在数据库或电子表格程序（例如 Microsoft Access 或 Microsoft Excel）中打开此文件。

在您的报告中，一个订单可能会列出几行信息。如果无法将订单的全部信息放入一行中（例如对一个订单应用多种促销时），信息将分为多行列出。

如果您使用亚马逊的可选税费计算服务，那么商品税、礼品包装税和配送税金额将列在订单报告中。关于所收税费的其他信息已包含在“税收文档库”的“销售税”报告中。

媒介类商品（图书、音乐、影视）卖家

当您为媒介类商品（图书、音乐、影视）的 标准和加急配送启用了缩短处理和运输时间时，您的【订单报告】中将永久显示四个新的列：

• 最早发货日期

• 最迟配送日期

• 最早送达日期

• 最迟送达日期

订单报告字段定义

【订单报告】中包含下列字段。

此列表并不详尽。订单报告可能还包含其他字段。请参阅定制信息和买家订单信息字段。

Notes：

• 【purchase-order-number】是默认添加的选项，面向所有 Amazon Business 买家，可使用订单报告列选择器开启或关闭该字段。买家包裹装箱单或包裹货件标签上必须包含亚马逊订货单编号。有关更多信息，请点击此处。Amazon Business 买家可以同时选择或取消选择【企业买家】和【企业商品价格】，也可以单独选择或取消选择【公司名称】 。

• 如果您使用 MWS API 检索采用 XML 上传数据的报告，则订单报告还包含其他字段。请访问定制信息和买家订单信息字段。

重要： 您的订单报告现包含电子邮箱地址，您可以利用该地址联系买家商谈您与该买家之间的交易。请注意，如果您选择使用该电子邮件地址与买家沟通，亚马逊将会复制和存储该电子邮件以及您与买家之间使用该服务进行的所有后续沟通。使用这项服务表示您同意我们的做法。详细了解买家与卖家消息服务。

CustomizationInfo 和 CustomerOrderInfo 字段

为了简化订单报告，“订单”报告上传数据中仅包含以下 【CustomizationInfo】 和 【CustomerOrderInfo】 字段。

注意： 报告中的字段因卖家账户类型而异，因此，您在“订单”报告上传数据中只会看到下面的部分字段。

CustomizationInfo 字段

CustomerOrderInfo 字段

亚马逊官网原文详情：   

Read an Order Report

When an Order Report is ready, click the Download button and save the file to your local hard drive. You can then open it in a database or spreadsheet program, such as Microsoft Access or Microsoft Excel.

There may be several rows for an individual order in your report. If all of the order information does not fit on one row (such as when multiple promotions are applied to an order), the information will be split over multiple rows.

If you use Amazon’s optional tax calculation services, item tax, gift wrap tax, and shipping tax amounts will be shown in the Order Report. Additional information regarding taxes collected can be found in the Sales Tax report in the Tax Document Library.

BMVD sellers

When you enable reduced handling and transit times for Standard and Expedited shipping for your Books, Music, Video, and DVD (BMVD) products, four new columns will appear permanently on your Order Report:

• earliest ship date

• latest ship date

• earliest delivery date

• latest delivery date

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. See CustomizationInfo and CustomerOrderInfo Fields.

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 Example: USD
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 = $10 Quantity = 2 Item price displayed = $20
Gift wrap price gift-wrap-price	Price a buyer paid for gift wrap. All amounts are aggregates of the quantity, not unit prices.
Shipping price shipping-price	Price a buyer paid for shipping. All amounts are aggregates of the quantity, not unit prices.
Item tax item-tax	Tax a buyer paid connected to the item. All amounts are aggregates of the quantity, not unit prices.
Gift wrap tax gift-wrap-tax	Tax a buyer paid connected to the gift wrap. 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. For more information, see our Help page, What do I need to know about packing slips and purchase order numbers?
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 postal code ship-postal-code	ZIP code or postal code of "Ship To" address. Value format depends on destination country.
Ship country ship-country	International Standards Organization two-letter country code (ISO 3166-2 compliant). Example: US
Gift wrap type gift-wrap-type	Type of gift wrap selected by the buyer. Example: Birthday balloons.
Gift message text gift-message-text	Buyer's gift message.
Gift wrap price gift-wrap-price	The price of the gift wrap selected by the buyer.
Gift wrap tax gift-wrap-tax	The amount of tax paid on the gift wrap.
Item promotion discount item-promotion-discount	Amount discounted from orders that qualify for either a money-off or a percent-off promotion.
Item promotion ID item-promotion-id	Promotion ID associated with money-off or percent-off promotion.
Shipping promotion discount shipping-promotion-discount	Amount discounted from orders that qualify for free shipping.
Shipping promotion ID shipping-promotion-id	Promotion ID associated with free shipping promotion.
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.
Is business order? is-business-order	Indicates if the order is from an Amazon Business customer. Example: true, false
Purchase order number purchase-order-number	The buyer's purchase order number (for orders from Amazon Business customers). This must be included on the customer package packing slip or on the package shipping label. For more information on packing slips and purchase order numbers, click here.
Price designation price-designation	Indicates the type of business price that the buyer used. Learn more about business prices. (Amazon Business Seller Program only.)
Buyer company name buyer-company-name	The registered company name of the Amazon Business customer who created the order. This is a freeform text field for alphanumeric characters. (Amazon Business Seller Program only.) Example: Acme Business Supplies, Inc.
Licensee name licensee-name	Name of the individual on the professional license that has been provided by the customer. Example: Jane Doe 12345
License number license-number	Professional license number provided by the customer. Example: 12345
License state license-state	State where professional license number is valid. Example: TX
License expiration date license-expiration-date	Professional license expiration date provided by the customer. Example: 2016-08-20
Address-Type Address-Type	Informs you as to whether the customer Ship to address is commercial or residential.
Number-of-items Number-of-items	Indicates the total number of items that are included in an ASIN.
Is Transparency?	Example: true, false; Indicates if ASIN is enrolled in Transparency. Learn more.
Global Express is-global-express	Indicates if the order is from Global Express Program Example: true, false

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. For more information, clickhere. Amazon Business customers can select or deselect business-buyer and business-price in a group, and select or deselect company-name separately.

• 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. Please 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.

CustomizationInfo and CustomerOrderInfo fields

To simplify the Order Report, only the following CustomizationInfo and CustomerOrderInfo fields are available in Orders report feeds.

Note: The fields in your report will vary based on your seller account type, therefore you will see only a subset of the following fields in your Orders reports feeds.

CustomizationInfo fields

All sellers
Condition	Indicates the condition of the item
ConditionType	Sub-type of Condition: provides extra detail about the item's condition
SD-EndTime	Provides the scheduled delivery end time of an order
SD-StartTime	Provides the scheduled delivery start time of an order
SD-WindowTZ	Indicates the time zone of the scheduled delivery end and start times
ListingID	An identifier created by Amazon when you create a listing; consists of 4 digits, a capital letter, and 6 more digits
DateListed	Date when the item was listed on Amazon
UPC	Universal Product Code
MarketplaceID	Amazon marketplace identifier
CompoundTitle	The title of the ASIN, which may include extra information such as product-type

Checkout by Amazon
CBAShipLabel	Provides shipping information for Checkout by Amazon orders
orderChannel	The sub channel through which a sale was made for CBA orders
SKU	A seller-defined unique identifier for a product
PromotionId	Provides the Promotion ID associated with an order
sales-channel	Channel through which the order was purchased
Weight	Indicates the weight of the item
PromotionCode	Provides the Promotion Code associated with an order
url	The primary domain of the marketplace the order was placed through

CustomerOrderInfo fields

All sellers
GiftOption	Giftwrap description

文章来源：亚马逊官方网站