亚马逊配送货件报告
您可以针对亚马逊已配送订单的已完成货件下载一份文本格式的 (.txt) 报告。在这份“亚马逊配送货件报告”中,将列出在您所选择的时段中已完成的亚马逊配送货件。报告数据在商品发出后不久即更新,通常是在几个小时之内。有时,数据可能会在发货 24 小时后填充。
报告将包含在指定时段内所有报告给亚马逊物流的已完成货件。该报告可能无法包括在指定时段内已发货的所有商品,因为可能会有已发货但尚未报告给我们系统的商品。这些商品将在未来的某个时间段内进行报告。这可以确保在任何指定的日期范围内报告数据始终一致。
该报告包括订单、货件,以及包括商品价格和配送地址信息的商品数据。除了下载报告之外,具有开发能力的卖家还可以使用亚马逊商城网络服务(亚马逊 MWS)来请求报告。
请求亚马逊配送货件报告
可针对过去最多 18 个月的货件请求报告,最大日期范围为 31 天。若请求更早或日期范围更大的报告,则可能会被系统取消。如果您的订单数量较多,可能需要一段时间才能生成报告。指定较短的日期范围有助于更快地生成报告。请注意,该报告旨在提供货件级别的信息。如果您想要了解在特定日期范围内发走了哪些订单,请使用“所有订单”报告。
要请求亚马逊配送货件报告,请执行以下步骤:
点击位于报告 > 配送下的订单报告链接。
在请求订单报告部分选择您要包含过去多少天的数据。选择确切日期设置特定时间段。在一份报告中,最多可以请求包含一个月的数据。
从下拉菜单中选择亚马逊配送货件报告。
点击请求报告
下载报告
生成报告后,您可以从已生成报告的列表中找到此报告。在“订单报告”页面上的检查报告状态和下载部分中,找到想要下载的报告。在可以下载的报告旁边,将显示下载按钮。
在您点击下载按钮时,将显示另存为对话框。选择文件夹位置,然后点击保存。
Note: 注意:根据不同的语言,在 Microsoft Excel 之类的电子表格程序中打开报告时,可能会发生乱码的情况。如果遇到这种问题,您可以利用一个 UTF-8 兼容阅读器打开文件。Excel 导入向导提供选择文件原始格式的选项。选择“65001 : Unicode (UTF-8)”,文本就不会错乱了。
如何阅读亚马逊配送货件报告
下载报告后,您可以在任何数据库或电子表格程序(如 Microsoft Access 或 Microsoft Excel)中打开它。
配送日期基于货件报告给系统的时间,一般要比实际的发货日期晚几个小时。其他报告可能会以不同的方式计算配送日期。所有的日期时间都是 GMT。
为遵守隐私政策,报告中不会显示买家电话号码和账单地址。买家电子邮件地址已加密。
以下是货件报告上所显示字段的列表,以及这些字段的定义和各字段的示例值。
字段名 | 定义 | 示例 |
---|---|---|
amazon-order-id | 亚马逊为订单提供的可显示的唯一编号。 | 058-3718414-0463502 或 S01-3718414-0463502 |
merchant-order-id | 卖家为订单提供的唯一编号(可选)。 | my-order |
shipment-id | 加密的亚马逊货件编号 | A13HTCT6TX9QAP |
shipment-item-id | 加密的亚马逊货件商品编号 | AW5K6OE4N1SER |
amazon-order-item-id | 亚马逊为订单内商品提供的唯一可显示编号。 | 37329900000000 |
merchant-order-item-id | 亚马逊为订单内商品提供的唯一编号。 | my-order-item-1 |
purchase-date | 下订单的日期。 | 2003-07-14T18:53:56-07:00 |
payments-date | 买家使用信用卡付款和订单处理完成的日期。 | 2003-07-14T18:53:56-07:00 |
shipment-date | 配送中心完成(配送)货件的日期 | 2003-07-14T18:53:56-07:00 |
reporting-date | 亚马逊物流数据存储可提供报告数据的日期。 | 2003-07-14T18:53:56-07:00 |
buyer-email | 买家的加密电子邮件地址。 | 12345abc@marketplace.amazon.com |
buyer-name | 买家的姓名。 | Sean Dodson |
buyer-phone-number | 买家的电话号码。 | Note: 根据亚马逊的隐私政策规定,将不提供此信息。 |
SKU | 卖家为商品定义的唯一编号。 | HarryPotter3 |
product-name | 商品的简称,在商品详情页面上和浏览器的标题栏以粗体字显示。 | 巧克力松露 |
quantity-shipped | 配送的此商品的数量。 | 1 |
currency | 购物使用的货币。支持的货币包括美元、加元、英镑、欧元和日元。 | 美元 |
item-price | 买家为商品支付的金额。金额是总金额,不是单价。 | 15 |
item-tax | 买家为商品税支付的金额。金额是总金额,不是单价。 | 0 |
shipping-price | 买家支付的运费金额。金额是总金额,不是单价。 | 5.95 |
shipping-tax | 买家为运费税支付的金额。金额是总金额,不是单价。 | 0 |
gift-wrap-price | 买家为礼品包装支付的金额。金额是总金额,不是单价。 | |
gift-wrap-tax | 买家为礼品包装税支付的金额。金额是总金额,不是单价。 | |
ship-service-level | 一个枚举值,确定买家期望卖家使用的配送服务类型(例如,标准配送与加急配送) | 标准 |
recipient-name | 标准地址的姓名字段。 | Sean Dodson |
ship-address-1 | 标准地址的第一行。 | 3151 Glenmanor Place |
ship-address-2 | 标准地址的第二行。 | |
ship-address-3 | 标准地址的第三行。 | |
ship-city | 标准地址的城市。 | 洛杉矶 |
ship-state | 标准地址的州或地区。 | 加利福尼亚州 |
ship-postal-code | 标准地址的邮政编码。 | 90039 |
ship-country | ISO 3166 标准的双字母国家/地区代码。 | US |
ship-phone-number | 与配送地址相关联的电话号码。 | Note: 根据亚马逊的隐私政策规定,将不提供此信息。 |
bill-address-1 | 标准地址的第一行。 | Note: 根据亚马逊的隐私政策规定,将不提供此信息。 |
bill-address-2 | 标准地址的第二行。 | Note: 根据亚马逊的隐私政策规定,将不提供此信息。 |
bill-address-3 | 标准地址的第三行。 | Note: 根据亚马逊的隐私政策规定,将不提供此信息。 |
bill-city | 标准地址的城市。 | Note: 根据亚马逊的隐私政策规定,将不提供此信息。 |
bill-state | 标准地址的州或地区。 | Note: 根据亚马逊的隐私政策规定,将不提供此信息。 |
bill-postal-code | 标准地址的邮政编码。 | Note: 根据亚马逊的隐私政策规定,将不提供此信息。 |
bill-country | ISO 3166 标准的双字母国家/地区代码。 | Note: 根据亚马逊的隐私政策规定,将不提供此信息。 |
item-promotion-discount | 应用于订单商品的促销折扣。 | -6.5 |
ship-promotion-discount | 应用于配送的促销折扣。 | -4.25 |
carrier | 配送包裹的承运人的名称。 | UPS |
tracking-number | 包裹的承运人追踪编号。 | 1Z861E7F0340512285 |
estimated-arrival-date | 交付给买家的预计时间。 | 2003 年 7 月 14 日 |
fulfillment-center-id | 配送订单的运营中心的唯一编号。 | LEX1 |
fulfillment-channel | 说明订单的配送方式:亚马逊配送 (AFN) 或卖家自行配送 (MFN) | AFN 或 MFN |
sales-channel | 订单来源。 | Amazon.com |
亚马逊官网原文详情:
Amazon-Fulfilled Shipments Report
You can download a text file (.txt) report of completed shipments of orders that Amazon has fulfilled. The Amazon- Fulfilled Shipments Report lists completed Amazon-fulfilled shipments for the time period that you select. Report data is updated shortly after an item has been shipped, typically within several hours. At times, data may not populate until 24 hours after shipment.
The report contains all completed shipments reported to FBA during the specified time period. This may not include all items that were shipped during that time frame if they have not yet been reported to our system. Those items will be reported in a future time period. This ensures that the report data will always be consistent for any given date range.
The report includes order, shipment, and item data including price and shipping address information. In addition to downloading the report, sellers with developer capability can use Amazon Marketplace Web Services (Amazon MWS) to request the report.
Request the Amazon-Fulfilled Shipments Report
Reports can be requested for shipments up to 18 months in the past and within a maximum date range of 31 days. Requests for older reports or wider date ranges may be cancelled by the system. If you have a large number of orders, it may take a while to generate your report. Specifying shorter date ranges can help your reports get generated faster. Note that this report is designed to provide information at the shipment level. If you would like to know which orders went out in a specific date range, please use the "All Orders" report.
To request an Amazon-Fulfilled Shipments Report, follow the steps below:
Click the Order Reports link found under Reports > Fulfillment.
In the Request an Order Report section, select the number of prior days you would like to include. Select Exact Dates to set a specific time range. You can request up to one month of data in a single report.
Select Amazon-Fulfilled Shipments Report from the drop-down.
Click Request Report
Download the report
After you generate a report, you can pick up the report from a list of generated reports. On the Order Reports page, in the Check Report Status & Download section, find the report you want to download. If it is ready, a Download button will be available.
When you click the Download button, a Save As dialog box will appear. Choose a folder location and click Save.
Note: When you open the report in a spreadsheet program such as Microsoft Excel, depending on the language you might discover that some of the text is garbled. If you encounter this problem you can open the file using a UTF-8 compatible reader. The Excel Import Wizard provides the option of selecting the File Origin. Select "65001 : Unicode (UTF-8)" and the text will not be garbled.
After you download the report, you can open it in any database or spreadsheet program, such as Microsoft Access or Microsoft Excel.
Shipment dates are based on when the shipment was reported to the system, which is generally a few hours after the actual ship date. Other reports may calculate shipment dates differently. All dates are in GMT.
Customer phone numbers and billing addresses are not shown in the report to comply with our privacy policies. Customer email addresses are encrypted.
Here is a list of the fields that appear on the shipment report, as well as definitions of those fields and examples for each one.
Field Name Definition Example amazon-order-id Amazon's unique, displayable identifier for an order. 058-3718414-0463502 or S01-3718414-0463502 merchant-order-id A unique identifier optionally supplied for the order by the Merchant. my-order shipment-id Encrypted Amazon shipment id A13HTCT6TX9QAP shipment-item-id Encrypted Amazon shipment item id AW5K6OE4N1SER amazon-order-item-id Amazon's unique, displayable identifier for an item within the order. 37329900000000 merchant-order-item-id A unique identifier for an item within the order. my-order-item-1 purchase-date The date the order was placed. 2003-07-14T18:53:56-07:00 payments-date The date the buyer's credit card was charged and order processing was completed. 2003-07-14T18:53:56-07:00 shipment-date The date the shipment was completed (shipped) by the fulfillment center 2003-07-14T18:53:56-07:00 reporting-date The date the data for this report became available in the FBA data store. 2003-07-14T18:53:56-07:00 buyer-email The encrypted email address of the buyer. 12345abc@marketplace.amazon.com buyer-name The full name of the buyer. Sean Dodson buyer-phone-number The phone number of the buyer. Note: This information will not be provided in order to comply with Amazon's privacy policy.
sku A merchant-defined unique identifier for a product. HarryPotter3 product-name The short title for the product, displayed in bold on the detail web page and in the title bar of the browser window. Chocolate Truffles quantity-shipped The number of this item that were shipped. 1 currency The currency used for the purchase. Supported currencies include USD, CAD, GBP, EUR, and JPY. USD item-price The amount that the buyer paid for the item. Amount is aggregate of the quantity, not unit price. 15 item-tax The amount that the buyer paid for item tax. Amount is aggregate of the quantity, not unit price. 0 shipping-price The amount that the buyer paid for shipping. Amount is aggregate of the quantity, not unit price. 5.95 shipping-tax The amount that the buyer paid for shipping tax. Amount is aggregate of the quantity, not unit price. 0 gift-wrap-price The amount that the buyer paid for gift wrap. Amount is aggregate of the quantity, not unit price. gift-wrap-tax The amount that the buyer paid for gift wrap tax. Amount is aggregate of the quantity, not unit price. ship-service-level An enumerated value that determines the type of fulfillment service that the buyer expects the merchant to use (e.g., Standard v. Expedited) Standard recipient-name Name field of a standard address. Sean Dodson ship-address-1 The first line of a standard address. 3151 Glenmanor Place ship-address-2 The second line of a standard address. ship-address-3 The third line of a standard address. ship-city The city of a standard address. Los Angeles ship-state The state or region of a standard address. California ship-postal-code The postal (ZIP) code of a standard address. 90039 ship-country ISO 3166 standard two-letter country code. US ship-phone-number The phone number associated with the ship-to address. Note: This information will not be provided in order to comply with Amazon's privacy policy.
bill-address-1 The first line of a standard address. Note: This information will not be provided in order to comply with Amazon's privacy policy.
bill-address-2 The second line of a standard address. Note: This information will not be provided in order to comply with Amazon's privacy policy.
bill-address-3 The third line of a standard address. Note: This information will not be provided in order to comply with Amazon's privacy policy.
bill-city The city of a standard address. Note: This information will not be provided in order to comply with Amazon's privacy policy.
bill-state The state or region of a standard address. Note: This information will not be provided in order to comply with Amazon's privacy policy.
bill-postal-code The postal (zip) code of a standard address. Note: This information will not be provided in order to comply with Amazon's privacy policy.
bill-country ISO 3166 standard two-letter country code. Note: This information will not be provided in order to comply with Amazon's privacy policy.
item-promotion-discount Promotion discount applied to the order item. -6.5 ship-promotion-discount Promotion discount applied to shipping. -4.25 carrier The name of the carrier the package was shipped with. UPS tracking-number The carrier's tracking number for the package. 1Z861E7F0340512285 estimated-arrival-date The estimated date of delivery to the customer. 7/14/2003 fulfillment-center-id The unique identifier from which fulfillment center the order was shipped. LEX1 fulfillment-channel Indicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN) AFN or MFN sales-channel The source of the order. Amazon.com
文章来源:亚马逊官方网站