如何閱讀亞馬遜訂單報告？

亞馬遜觀察

2022-03-26

1572

訂單報告生成完畢后，點擊【下載】按鈕，并將文件保存到您的本地硬盤。然后您可以在數(shù)據(jù)庫或電子表格程序（例如 Microsoft Access 或 Microsoft Excel）中打開此文件。

閱讀訂單報告

在您的報告中，一個訂單可能會列出幾行信息。如果無法將訂單的全部信息放入一行中（例如對一個訂單應(yīng)用多種促銷時），信息將分為多行列出。

如果您使用亞馬遜的可選稅費計算服務(wù)，那么商品稅、禮品包裝稅和配送稅金額將列在訂單報告中。關(guān)于所收稅費的其他信息已包含在“稅收文檔庫”的“”報告中。

媒介類商品（圖書、音樂、影視）賣家

當(dāng)您為媒介類商品（圖書、音樂、影視）的標(biāo)準(zhǔn)和加急配送啟用了縮短處理和運輸時間時，您的【訂單報告】中將永久顯示四個新的列：

最早發(fā)貨日期
最遲配送日期
最早送達日期
最遲送達日期

訂單報告字段定義

【訂單報告】中包含下列字段。

此列表并不詳盡。訂單報告可能還包含其他字段。請參閱定制信息和買家訂單信息字段。

列名	定義
訂單編號訂單編號	亞馬遜為訂單設(shè)置的唯一識別號碼。用于發(fā)貨確認(rèn)和下單后的處理。示例： 058-3563777-5518068
訂單商品編號訂單商品編號	亞馬遜為訂單中的商品提供的唯一識別號碼。用于發(fā)貨確認(rèn)和下單后的處理。
購買日期購買日期	下單日期，采用“年/月/日”的格式。注意：如果不另行指定配送備貨時間，則表示您同意在此日期后的 2 個工作日內(nèi)配送訂單。
付款日期付款日期	買家信用卡付款且訂單處理完畢的日期，采用“年/月/日”的格式。
買家電子郵箱買家電子郵箱	買家的電子郵箱地址示例：johndoe@somecompany.com
買家的全名買家姓名	買家的全名示例： John Doe
SKU SKU	庫存單位。賣家為商品定義的唯一標(biāo)識。示例： AA786936215595
商品名稱商品名稱	商品詳情頁面和瀏覽器標(biāo)題欄中顯示的簡短商品名稱。示例：滑雪板
購買數(shù)量購買數(shù)量	購買數(shù)量。
貨幣貨幣	幣種示例：美元
商品價格商品價格	買家為商品支付的價格。所有金額均為所有商品的對應(yīng)費用總和，而非單價。示例：商品價格 = $10 數(shù)量 = 2 顯示的商品價格 = $20
禮品包裝價格禮品包裝價格	買家為禮品包裝支付的價格。所有金額均為所有商品的對應(yīng)費用總和，而非單價。
配送價格配送價格	買家支付的配送費用。所有金額均為所有商品的對應(yīng)費用總和，而非單價。
商品稅商品稅	買家為商品支付的相關(guān)稅費。所有金額均為所有商品的對應(yīng)費用總和，而非單價。
禮品包裝稅禮品包裝稅	買家為禮品包裝支付的相關(guān)稅費。所有金額均為所有商品的對應(yīng)費用總和，而非單價。
配送服務(wù) 配送服務(wù)級別	買家在訂購商品時選擇的配送類型；例如：標(biāo)準(zhǔn)、加急。
收件人姓名收件人姓名	“收貨”地址的姓名字段。
收件人姓名 + 訂貨單編號	當(dāng)企業(yè)買家為賣家自配送訂單提供亞馬遜訂貨單時，可將此訂貨單編號附加到訂單詳情、訂單報告和商城網(wǎng)絡(luò)服務(wù)中的【收件人姓名】字段。如果貨件標(biāo)簽和裝箱單上已包含訂貨單編號，或者出于其他原因而不想包含訂貨單編號，請禁用此功能。有關(guān)更多信息，請參閱我們的“幫助”頁面：我需要了解哪些有關(guān)裝箱單和訂貨單編號的信息？
配送地址（3 列）配送地址 1	“收貨”地址的第一行。
配送地址 2	“收貨”地址的第二行。
配送地址 3	“收貨”地址的第三行。
配送城市配送城市	“收貨”地址所在的城市。
配送州配送州	“收貨”地址所在的州、省或地區(qū)。因原產(chǎn)國而異。注意：縮寫可能因買家的輸入方式而異。
配送郵政編碼配送郵政編碼	“收貨”地址的郵政編碼。值的格式取決于目的國家。
配送國家配送國家	國際標(biāo)準(zhǔn)組織雙字母國家代碼（符合 ISO 3166-2 標(biāo)準(zhǔn)）。示例： US
禮品包裝類型禮品包裝類型	買家選擇的禮品包裝類型。示例：生日氣球。
禮品贈言文本禮品贈言文本	買家的禮品贈言。
禮品包裝價格禮品包裝價格	買家選擇的禮品包裝價格。
禮品包裝稅禮品包裝稅	禮品包裝支付的稅費。
商品促銷折扣商品促銷折扣	對符合滿減或折扣促銷條件的訂單減免的金額。
商品促銷編號商品促銷編號	與滿減或折扣促銷相關(guān)的促銷編號。
配送促銷折扣配送促銷折扣	對符合免費配送條件的訂單減免的金額。
配送促銷編號配送促銷編號	與促銷相關(guān)的促銷編號。
配送說明配送說明	其他配送說明。
訂單渠道訂單渠道	關(guān)于下單方式的信息。
訂單渠道實例訂單渠道實例	關(guān)于下單方式的信息。
是否為企業(yè)訂單？是否為企業(yè)訂單	表示訂單是否為 Amazon Business 買家所下。示例：true、false
訂貨單編號亞馬遜訂貨單編號	買家的訂貨單編號（適用于 Amazon Business 買家所下訂單）。買家包裹裝箱單或包裹貨件標(biāo)簽上必須包含此類訂貨單編號。有關(guān)裝箱單和亞馬遜訂貨單編號的更多信息，請點擊此處。
價格標(biāo)示價格標(biāo)示	表示買家所使用的類型。了解有關(guān)企業(yè)商品價格的更多信息。（僅適用于 Amazon Business 賣家計劃。）
買家公司名稱買家公司名稱	創(chuàng)建訂單的 Amazon Business 買家的注冊公司名稱。這是一個自由形式文本字段，可以輸入字母數(shù)字字符。（僅適用于 Amazon Business 賣家計劃。）示例： Acme Business Supplies, Inc.
許可證持有人姓名許可證持有人姓名	買家提供的專業(yè)許可證上的個人姓名。示例： Jane Doe 12345
許可證號許可證號	買家提供的專業(yè)許可證號。示例： 12345
許可證狀態(tài) 許可證狀態(tài)	專業(yè)許可證號有效的狀態(tài)。示例： TX
許可證有效期 license-expiration-date	買家提供的專業(yè)許可證的有效期。示例： 2016-08-20
Address-Type Address-Type	告知您買家的收貨地址是辦公地址還是住宅地址。
Number-of-items Number-of-items	表示 ASIN 中包含的商品總數(shù)。
是否加入 Transparency 計劃？	示例：true、false；表示 ASIN 是否加入 Transparency 計劃。了解更多信息。
全球快遞 is-global-express	表明訂單是否來自全球快遞計劃示例：true、false

Notes：

【purchase-order-number】是默認(rèn)添加的選項，面向所有 Amazon Business 買家，可使用訂單報告列選擇器開啟或關(guān)閉該字段。買家包裹裝箱單或包裹貨件標(biāo)簽上必須包含亞馬遜訂貨單編號。有關(guān)更多信息，請點擊此處。Amazon Business 買家可以同時選擇或取消選擇【企業(yè)買家】和【】，也可以單獨選擇或取消選擇【公司名稱】。
如果您使用 MWS API 檢索采用 XML 上傳數(shù)據(jù)的報告，則訂單報告還包含其他字段。請訪問定制信息和買家訂單信息字段。

重要：您的訂單報告現(xiàn)包含電子郵箱地址，您可以利用該地址聯(lián)系買家商談您與該買家之間的交易。請注意，如果您選擇使用該電子郵件地址與買家溝通，亞馬遜將會復(fù)制和存儲該電子郵件以及您與買家之間使用該服務(wù)進行的所有后續(xù)溝通。使用這項服務(wù)表示您同意我們的做法。詳細了解買家與賣家消息服務(wù)。

CustomizationInfo 和 CustomerOrderInfo 字段

為了簡化訂單報告，“訂單”報告上傳數(shù)據(jù)中僅包含以下【CustomizationInfo】和【CustomerOrderInfo】字段。

注意：報告中的字段因賣家賬戶類型而異，因此，您在“訂單”報告上傳數(shù)據(jù)中只會看到下面的部分字段。

CustomizationInfo 字段

所有賣家
Condition	指示商品的狀況
ConditionType	狀況的子類型：提供關(guān)于商品狀況的額外詳細信息
SD-EndTime	提供訂單的預(yù)計配送結(jié)束時間
SD-StartTime	提供訂單的預(yù)計配送開始時間
SD-WindowTZ	指明預(yù)計配送結(jié)束時間和開始時間的時區(qū)
ListingID	您創(chuàng)建商品信息時由亞馬遜創(chuàng)建的編碼；由 4 個數(shù)字、1 個大寫字母和 6 個以上的數(shù)字組成
DateListed	商品在的日期
UPC	通用商品編碼
MarketplaceID	編號
CompoundTitle	ASIN 的名稱，它可能包含商品類型等額外信息

Checkout by Amazon
CBAShipLabel	為 Checkout by Amazon 訂單提供配送信息
orderChannel	銷售 CBA 訂單的子渠道
SKU	賣家為商品定義的唯一編號
PromotionId	提供與訂單相關(guān)的促銷編號
sales-channel	訂單的購買渠道
Weight	指示商品的重量
PromotionCode	提供與訂單相關(guān)的促銷代碼
url	下單時所在商城的主域

CustomerOrderInfo 字段

所有賣家
GiftOption	禮品包裝描述

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

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

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