使用上传数据确认多个货件

注意: 此功能仅适用于参与专业销售计划的卖家。

收到订单通知并发出订单后,您必须确认配送。

配送确认模板 可让您在一个文件中上传多个订单的确认信息。

注意: 如果您将一份订单拆分为多个货件,那么只要确认订单的首个货件,系统就会扣除整个订单的费用并为其分配状态付款完成,即使其他货件尚未完成也是如此。


【请按照以下步骤下载、编辑并批量上传配送确认。】

  1. 下载并保存【配送确认模板】的副本。查看【数据定义】选项卡上的说明,尤其是 [ 可接受值 ] 列和表格下方的所有 [ 重要说明 ] 。 另请参阅下方的【配送确认术语表】。


  2. 在【配送确认】选项卡中输入您的配送信息。一些需要记住的常见提示如下:

    • 配送确认模板包含验证宏,可帮助您正确填写模板。这些宏可以关闭,但我们建议您在第一次学习使用模板时将其保持开启状态。

    • 将所有列设置为【文本】格式(包括 ship-date ),以防止 Excel 删除任何前导零。

    • 按以下格式输入 【ship-date】 :【yyyy-mm-dd】。


  3. 更新已经存在的配送信息时,请根据您想要的结果从以下选项中选择:

    注意: 如果一份订单中包含多种商品或多件商品,且您将订单拆分为多个货件,那么您需要在每个配送确认记录中包含以下字段:

    • 【order-id】

    • 【order-item-id】

    • 【quantity】

    • 【发货日期】

    • 【覆盖已经存在的数据:】 新数据会覆盖或替代现有数据。示例: 字段 tracking-number 中的新数据将覆盖现有的追踪编码数据。

    • 【不覆盖已经存在的数据:】 空(空白)字段不会覆盖或作废现有数据。示例: 将 tracking-number 留空,这样之前上传的数据就不会被覆盖或作废。

    • 【删除已经存在的数据:】 按以下格式输入 [ NULL ] (不含引号),该字段中的数据将被删除。示例: 将 [ NULL ] 输入 tracking-number 字段以擦除之前的数据。


  4. 完成操作后,请点击【另存为】,并从文件类型列表中选择【文本(制表符分隔)(*.txt)】。如果您看到“选定的文件格式不支持包含多个工作表的工作簿”的警告,请点击【是】。

  5. 在卖家平台的【订单】菜单中,选择【上传订单相关文件】。

  6. 在【配送确认】选项卡的【上传您的配送确认文件】下,点击【浏览】。

  7. 找到您保存的模板,选择文件,然后点击【打开】。

  8. 点击【立即上传】将您的文件上传到亚马逊。


您可以在上传页面底部的【查看文件状态和历史记录】下,查看已上传文件的状态。您的处理报告将显示上传过程中可能发生的任何错误。


配送确认术语表

并非所有字段都是必填字段。但是,信息越完整,对您越有利。

字段名定义必填可接受值示例
order-id订单的唯一识别编码。您可在“订单报告”和“管理订单”工具中获得此编码。3-7-7 格式的字母数字文本058-3563777-5518068
order-item-id订单中每件商品的唯一识别编码。您可在“订单报告”和“管理订单”的“订单详情”页面中获得此编码。

注意: 此编码和商品的 ASIN 不同。每个订单中的订单商品编号都不同。

字母数字文本,包含 14 个字符05835637773450
quantity此订单中包含的商品数量(如果订购多件商品)。

注意: 如果将订单商品拆开配送,您必须在每个货件的配送确认中写明数量,以方便买家收到包裹时能够知道每件包裹中的商品数量。

正整数1
ship-date您配送订单商品的日期。格式:yyyy-mm-dd2018-11-19
carrier-code亚马逊为配送订单的运输承运人提供的代码,可从下拉菜单中选择。

注意: 如果您要选择的承运人不在列表中,请选择【其他】并在 carrier-name 字段中输入承运人名称。

请参阅配送确认模板的数据定义选项卡,查看承运人代码列表。如果您的承运人不在列表中,请选择其他。UPS、DHL、其他
carrier-name配送订单的运输承运人。仅在选择 carrier-code 【其他】时使用。字母数字文本,包含 1-50 个字符承运人代码下方未列出的任何承运人
tracking-number运输承运人提供的订单追踪编码。字母数字文本,包含 1-50 个字符22344455
ship-method用来配送订单商品的配送方式。最好的做法是提供承运人名称,以确保清楚无误。字母数字文本,包含 1-50 个字符Standard-DHL、Standard-UPS
transparency_codeASIN 的 Transparency 代码(如果注册加入了 Transparency 计划)。对于具有多个商品(“数量”大于 1)的订单,您必须为每件商品提供 Transparency 代码。

字母数字文本,有 2 种格式:

格式 1 - 以 AZ: 或 ZA: 开头,后跟 26 个字符(总长度为 29 个字符)。

格式 2 - 序列化的全球贸易项目代码 (SGTIN),总长度为 38 个字符

格式 1 - AZ:QNZGH88J4RCWPF8EDY3ZACZKEE

格式 2 - 0100376204200301214P1OZMT7D8B81EMF4WW4

注意: 对于提供的优先配送订单,大多数订单都需要一个有效的追踪编码。如果达不到优先配送订单要求的追踪率,您提供优先配送选项的资格可能会受到影响。


亚马逊官网原文详情:   

Confirm multiple shipments with feeds

Note: This feature is only available to sellers with Professional selling plans.

After you receive an order notification and ship the order, you must confirm shipment.

The Shipping Confirmation Template allows you to upload confirmation information for multiple orders in a single file.

Note: If you split an order into multiple shipments, the entire order is charged and assigned the status Payment Complete as soon as the first shipment for the order is confirmed, even if there are more shipments yet to be made.


Follow the steps below to download, edit, and upload shipping confirmations via bulk upload.

  1. Download and save a copy of the Shipping Confirmation template. Review the instructions on the Data Definitions tab, especially "Accepted Values" column and any "Important Notes" below the table. Also, see the Shipping Confirmation Glossary below.


  2. On the ShippingConfirmation tab, enter your shipping information. Some common tips to remember are:

    • The Shipping Confirmation template contains validation macros to help you fill out the template correctly. The macros can be turned off, but we encourage you to keep them on if you are first learning to use the template.

    • Set all of the columns to Text format (including ship-date) to prevent Excel from removing any leading zeroes.

    • Enter ship-date in the following format: yyyy-mm-dd.


  3. When updating previously existing shipping information, select from the following options based on the result you want:

    Note: If an order includes more than one product or more than one unit of a product, and you are splitting the order into more than one shipment, then you need to include the following fields for each of the shipping confirmation records:

    • order-id

    • order-item-id

    • quantity

    • ship-date

    • Overwrite previously existing data: New data will overwrite or replace the existing data. Example: New data in the tracking-number field will overwrite the existing tracking number data.

    • Do not overwrite previously existing data: An empty (blank) field will not overwrite or nullify the existing data. Example: Leave tracking-number blank so the previously uploaded data will not be overwritten or nullified.

    • Delete previously existing data: Enter "NULL" (without quotation marks) and the data in that field will be deleted. Example: Type "NULL" in the tracking-number field to erase previous data.


  4. When you are finished, click Save As and select Text (Tab-delimited) (*.txt) from the file type list. If you see a warning that the selected file format does not support workbooks containing multiple worksheets, click Yes.

  5. In Seller Central, from the Orders menu, select Upload Order Related Files.

  6. On the Shipping Confirmation tab, under Upload Your Shipping Confirmation File, click Browse.

  7. Locate your saved template, select the file, and click Open.

  8. Click Upload Now to upload your file to Amazon.


You can check the status of your uploaded file at the bottom of the upload page under Review File Status and History. Your processing report will indicate any errors that might have occurred during upload.


Shipping confirmation glossary

Not all fields are required. However, it is in your best interest to provide as much information as possible.

Field NameDefinitionRequiredAccepted ValuesExample
order-idUnique identifying number for an order. This number is provided in your Orders report and the Manage Orders tool.YesAlphanumeric text, 3-7-7 format058-3563777-5518068
order-item-idUnique identifying number for an item in an order. This number is provided in your Orders Report and on the Order Details page in Manage Orders.

Note: This is not the same as the product ASIN. The order-item-id differs from order to order.

NoAlphanumeric text, 14 characters05835637773450
quantityItem quantity included in this order if more than one unit of an item was ordered.

Note: If you split an order, you must include a quantity in the shipping confirmation for each shipment so that customers know how many items to expect in each package when it arrives.

NoA positive integer1
ship-dateDate on which you shipped the order.YesFormat: yyyy-mm-dd2018-11-19
carrier-codeAmazon's code for the shipping carrier that delivered the order, chosen from a drop-down menu.

Note: If you are using an unlisted carrier, select Other and then enter the carrier name in the carrier-name field.

NoSee the Data Definitions tab of your Shipping Confirmation Template for a list of carrier codes. If your carrier is not listed, select Other.UPS, DHL, Other
carrier-nameShipping carrier that delivered the order. Use only if carrier-code is Other.NoAlphanumeric text, 1 to 50 charactersAny carrier not listed as an option under carrier code
tracking-numberShipping carrier's tracking ID for the order.NoAlphanumeric text, 1 to 50 characters22344455
ship-methodShipping method used to deliver the order. Best practice is to include the carrier name to ensure clarity.NoAlpha-numeric text, 1 to 50 charactersStandard-DHL, Standard-UPS
transparency_codeThe Transparency code for the ASIN if it is enrolled in the Transparency program. For orders with multiple units ("quantity" is greater than 1), you must provide Transparency codes for each unit.No

Alphanumeric text, in 2 possible formats:

Format 1- Starts with AZ: or ZA: followed by 26 characters (total length is 29 characters).

Format 2- Serialized Global Trade Item Number (SGTIN) with total length is 38 character

Format 1 - AZ:QNZGH88J4RCWPF8EDY3ZACZKEE

or

Format 2 - 0100376204200301214P1OZMT7D8B81EMF4WW4

Note: For Premium Shipping, a valid tracking ID is required for most orders. Failure to meet the required tracking rate for Premium Shipping orders may affect your eligibility to offer Premium Shipping options.


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