如何阅读亚马逊订单报告?-ESG跨境

如何阅读亚马逊订单报告?

亚马逊观察
亚马逊观察
2022-03-26
点赞icon 0
查看icon 1238

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

阅读订单报告

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

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

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


媒介类商品(图书、音乐、影视)卖家

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

  • 最早发货日期

  • 最迟配送日期

  • 最早送达日期

  • 最迟送达日期


订单报告字段定义

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

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

列名定义
订单编号

订单编号

亚马逊为订单设置的唯一识别号码。用于发货确认和下单后的处理。

示例: 058-3563777-5518068

订单商品编号

订单商品编号

亚马逊为订单中的商品提供的唯一识别号码。用于发货确认和下单后的处理。
购买日期

购买日期

下单日期,采用“年/月/日”的格式。

注意: 如果不另行指定配送备货时间,则表示您同意在此日期后的 2 个工作日内配送订单。

付款日期

付款日期

买家信用卡付款且订单处理完毕的日期,采用“年/月/日”的格式。
买家电子邮箱

买家电子邮箱

买家的电子邮箱地址

示例:johndoe@somecompany.com

买家的全名

买家姓名

买家的全名

示例: John Doe

SKU

SKU

库存单位。卖家为商品定义的唯一标识。

示例: AA786936215595

商品名称

商品名称

商品详情页面和浏览器标题栏中显示的简短商品名称。

示例: 滑雪板

购买数量

购买数量

购买数量。
货币

货币

币种

示例: 美元

商品价格

商品价格

买家为商品支付的价格。所有金额均为所有商品的对应费用总和,而非单价。

示例:

商品价格 = $10
数量 = 2
显示的商品价格 = $20


礼品包装价格

礼品包装价格

买家为礼品包装支付的价格。所有金额均为所有商品的对应费用总和,而非单价。
配送价格

配送价格

买家支付的配送费用。所有金额均为所有商品的对应费用总和,而非单价。
商品税

商品税

买家为商品支付的相关税费。所有金额均为所有商品的对应费用总和,而非单价。
礼品包装税

礼品包装税

买家为礼品包装支付的相关税费。所有金额均为所有商品的对应费用总和,而非单价。
配送服务

配送服务级别

买家在订购商品时选择的配送类型;例如:标准、加急。
收件人姓名

收件人姓名

“收货”地址的姓名字段。
收件人姓名 + 订货单编号当企业买家为卖家自配送订单提供亚马逊订货单时,可将此订货单编号附加到订单详情、订单报告和商城网络服务中的【收件人姓名】字段。如果货件标签和装箱单上已包含订货单编号,或者出于其他原因而不想包含订货单编号,请禁用此功能。有关更多信息,请参阅我们的“帮助”页面:我需要了解哪些有关装箱单和订货单编号的信息?
配送地址(3 列)

配送地址 1

“收货”地址的第一行。
配送地址 2“收货”地址的第二行。
配送地址 3“收货”地址的第三行。
配送城市

配送城市

“收货”地址所在的城市。
配送州

配送州

“收货”地址所在的州、省或地区。因原产国而异。

注意: 缩写可能因买家的输入方式而异。

配送邮政编码

配送邮政编码

“收货”地址的邮政编码。值的格式取决于目的国家。
配送国家

配送国家

国际标准组织双字母国家代码(符合 ISO 3166-2 标准)。

示例: US

礼品包装类型

礼品包装类型

买家选择的礼品包装类型。

示例: 生日气球。

礼品赠言文本

礼品赠言文本

买家的礼品赠言。
礼品包装价格

礼品包装价格

买家选择的礼品包装价格。
礼品包装税

礼品包装税

礼品包装支付的税费。
商品促销折扣

商品促销折扣

对符合满减或折扣促销条件的订单减免的金额。
商品促销编号

商品促销编号

与满减或折扣促销相关的促销编号。
配送促销折扣

配送促销折扣

对符合免费配送条件的订单减免的金额。
配送促销编号

配送促销编号

与促销相关的促销编号。
配送说明

配送说明

其他配送说明。
订单渠道

订单渠道

关于下单方式的信息。
订单渠道实例

订单渠道实例

关于下单方式的信息。
是否为企业订单?

是否为企业订单

表示订单是否为 Amazon Business 买家所下。

示例:true、false

订货单编号

亚马逊订货单编号

买家的订货单编号(适用于 Amazon Business 买家所下订单)。买家包裹装箱单或包裹货件标签上必须包含此类订货单编号。有关装箱单和亚马逊订货单编号的更多信息,请点击此处。
价格标示

价格标示

表示买家所使用的类型。了解有关企业商品价格的更多信息。(仅适用于 Amazon Business 卖家计划。)
买家公司名称

买家公司名称

创建订单的 Amazon Business 买家的注册公司名称。这是一个自由形式文本字段,可以输入字母数字字符。(仅适用于 Amazon Business 卖家计划。)

示例: Acme Business Supplies, Inc.

许可证持有人姓名

许可证持有人姓名

买家提供的专业许可证上的个人姓名。

示例: Jane Doe 12345

许可证号

许可证号

买家提供的专业许可证号。

示例: 12345

许可证状态

许可证状态

专业许可证号有效的状态。

示例: TX

许可证有效期

license-expiration-date

买家提供的专业许可证的有效期。

示例: 2016-08-20

Address-Type

Address-Type

告知您买家的收货地址是办公地址还是住宅地址。

Number-of-items

Number-of-items
表示 ASIN 中包含的商品总数。
是否加入 Transparency 计划?示例:true、false;表示 ASIN 是否加入 Transparency 计划。了解更多信息。
全球快递

is-global-express

表明订单是否来自全球快递计划

示例:true、false

Notes:

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

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

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


CustomizationInfo 和 CustomerOrderInfo 字段

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

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


CustomizationInfo 字段

所有卖家
Condition指示商品的状况
ConditionType状况的子类型:提供关于商品状况的额外详细信息
SD-EndTime提供订单的预计配送结束时间
SD-StartTime提供订单的预计配送开始时间
SD-WindowTZ指明预计配送结束时间和开始时间的时区
ListingID您创建商品信息时由亚马逊创建的编码;由 4 个数字、1 个大写字母和 6 个以上的数字组成
DateListed商品在的日期
UPC通用商品编码
MarketplaceID编号
CompoundTitleASIN 的名称,它可能包含商品类型等额外信息
Checkout by Amazon
CBAShipLabel为 Checkout by Amazon 订单提供配送信息
orderChannel销售 CBA 订单的子渠道
SKU卖家为商品定义的唯一编号
PromotionId提供与订单相关的促销编号
sales-channel订单的购买渠道
Weight指示商品的重量
PromotionCode提供与订单相关的促销代码
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 NameDefinition
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 NumberEnables 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-2Second line of "Ship To" address.
ship-address-3Third 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
ConditionIndicates the condition of the item
ConditionTypeSub-type of Condition: provides extra detail about the item's condition
SD-EndTimeProvides the scheduled delivery end time of an order
SD-StartTimeProvides the scheduled delivery start time of an order
SD-WindowTZIndicates the time zone of the scheduled delivery end and start times
ListingIDAn identifier created by Amazon when you create a listing; consists of 4 digits, a capital letter, and 6 more digits
DateListedDate when the item was listed on Amazon
UPCUniversal Product Code
MarketplaceIDAmazon marketplace identifier
CompoundTitleThe title of the ASIN, which may include extra information such as product-type
Checkout by Amazon
CBAShipLabelProvides shipping information for Checkout by Amazon orders
orderChannelThe sub channel through which a sale was made for CBA orders
SKUA seller-defined unique identifier for a product
PromotionIdProvides the Promotion ID associated with an order
sales-channelChannel through which the order was purchased
WeightIndicates the weight of the item
PromotionCodeProvides the Promotion Code associated with an order
urlThe primary domain of the marketplace the order was placed through


CustomerOrderInfo fields

All sellers
GiftOptionGiftwrap description


点击咨询现在有哪些新兴平台值得关注 >>>


特别声明:以上文章内容仅代表作者本人观点,不代表ESG跨境电商观点或立场。如有关于作品内容、版权或其它问题请于作品发表后的30日内与ESG跨境电商联系。

全球最大电商平台
查看更多
搜索 放大镜
韩国平台交流群
加入
韩国平台交流群
扫码进群
欧洲多平台交流群
加入
欧洲多平台交流群
扫码进群
美国卖家交流群
加入
美国卖家交流群
扫码进群
ESG跨境专属福利分享群
加入
ESG跨境专属福利分享群
扫码进群
拉美电商交流群
加入
拉美电商交流群
扫码进群
亚马逊跨境增长交流群
加入
亚马逊跨境增长交流群
扫码进群
《开店大全-全球合集》
《开店大全-主流平台篇》
《开店大全-东南亚篇》
《CD平台自注册指南》
《开店大全-俄罗斯篇》
《韩国站内推广指南》
《韩国热销品预测》
《开店大全-日韩篇》
《开店大全-拉美篇》
《开店大全-欧洲篇》
通过ESG入驻平台,您将解锁
绿色通道,更高的入驻成功率
专业1v1客户经理服务
运营实操指导
运营提效资源福利
平台官方专属优惠
联系顾问

平台顾问

平台顾问 平台顾问

微信扫一扫
马上联系在线顾问

icon icon

小程序

微信小程序

ESG跨境小程序
手机入驻更便捷

icon icon

返回顶部