使用文本文件模板调整配送设置
注意: 此帮助页面不适用于已迁移到新配送设置的卖家,因为在新配送设置中,配送调整已由配送模板取代。了解如何迁移到新配送设置。
在某些情况下,您可能想要更改商品的默认配送设置。例如,如果您销售电视/音响类商品,那么可能不希望向某些区域配送大型家电(如电视)。您可以使用配送调整文件来调整所选商品的配送设置。
要创建配送调整文件,请执行以下步骤:
下载配送调整模板。
以 Microsoft Excel 或其他电子表格应用程序打开模板。
要在【配送调整】选项卡中输入您的商品数据,请参阅以下表格了解示例和有效的 ShipOption(配送选项)值。
输入数据后,转至【配送覆盖】选项卡并使用唯一文件名将文件保存为 Excel 文件。
使用不同文件名再次将您的工作薄保存为文本 (*.txt) 文件。
您可能会看到一条警告,提示选定的文件格式不支持包含多个工作表的工作簿,或文件包含与选定文本文件格式不兼容的功能。对于这两种情况,请点击【是】。
前往上传商品和库存,然后上传您的文件。
要删除配送覆盖,请按照以下步骤操作:
打开已保存的“配送覆盖”文件(您最初上传的文本文件)。
在 【UpdateDelete】 列中为该 ASIN 输入“删除”。
前往上传商品和库存,然后重新上传您的文本文件。
覆盖
现有两种类型的配送调整:
专用:
创建全新运费。
附加:
在当前运费的基础上增加额外费用。
“IsShippingRestricted”(配送是否受限)值为 False(否)的专用调整
此“专用”设置示例可让运费显示为 0.00。
sku | Currency | ShipOption1 | ShippingAmt1 | 类型1 | IsShippingRestricted1 |
---|---|---|---|---|---|
001 | USD | Std Cont US Street Addr | 0.00 | Exclusive | False |
002 | USD | Std Cont US Street Addr | 0.00 | Exclusive | False |
003 | USD | Std Cont US Street Addr | 0.00 | Exclusive | False |
004 | USD | Std Cont US Street Addr | 0.00 | Exclusive | False |
注意: 在此示例中,【IsShippingRestricted1】 列中的“False”设置允许将调整应用于此 SKU、配送选项(地区)、服务级别等。
这应添加到 IsShippingRestricted2。
“IsShippingRestricted”值为 True(是)的专用调整
在此示例中,“True”设置会阻止在 SKU 列表中提供标准配送。
sku | Currency | ShipOption1 | ShippingAmt1 | 类型1 | IsShippingRestricted1 |
---|---|---|---|---|---|
001 | USD | Std Cont US Street Addr | 0.00 | Exclusive | True |
002 | USD | Std Cont US Street Addr | 0.00 | Exclusive | True |
003 | USD | Std Cont US Street Addr | 0.00 | Exclusive | True |
004 | USD | Std Cont US Street Addr | 0.00 | Exclusive | True |
“IsShippingRestricted”值为 False 的附加调整
此“附加”设置示例允许将运费显示为标准运费额与附加费用额之和。
sku | Currency | ShipOption1 | ShippingAmt1 | 类型1 | IsShippingRestricted1 |
---|---|---|---|---|---|
001 | USD | Std Cont US Street Addr | 18.99 | Additive | False |
002 | USD | Std Cont US Street Addr | 18.99 | Additive | False |
003 | USD | Std Cont US Street Addr | 18.99 | Additive | False |
004 | USD | Std Cont US Street Addr | 18.99 | Additive | False |
由于“Type1”(类型 1)字段的值为“Additive”(附加),系统会将“ShippingAmt1”(运费 1)的值(18.99 美元)与配送设置中的金额加起来。例如,如果正常运费是 5.00 美元,那么,加上 ShippingAmt1 值(18.99 美元)后,总金额将是 23.99 美元,且此金额将在线显示出来。
ShipOption 字段
配送调整文件的【有效值】选项卡中提供的部分配送选项(ShipOption 字段)目前并未向所有卖家开放。请参阅以下表格,了解您加入的卖家计划启用了哪些 ShipOption 值。
自由经济型配送 | 标准配送 | 加急配送 | 隔日达 | 当日达 |
---|---|---|---|---|
|
|
|
亚马逊官网原文详情:
Override shipping settings using a text file template
Note: This help page does not apply to sellers who have migrated to the new shipping settings as shipping overrides are replaced by shipping templates. Learn how to migrate to the new shipping settings.
In some cases you might want to alter your default shipping settings for a product. For example, if you sell electronics, you might not want to ship a 50 lb. television to Canada. You can override shipping for selected products with a Shipping Overrides file, which is similar to the inventory file templates.
To create a shipping override, follow these steps:
Download the Shipping Overrides template.
Open the template in Microsoft Excel or another spreadsheet application.
Enter your product data on the Shipping Overrides tab, referring to the tables below for examples and valid ShipOption values.
After you finish entering your data, go to the Shipping Overrides tab and save the file as an Excel file, giving it a unique name.
Save your workbook again, with a different name, as a text (*.txt) file.
You might see a warning that the selected file format does not support workbooks containing multiple worksheets, or that your file contains features incompatible with the text file format. Click Yes in both cases.
Go to Upload Products & Inventory and upload your file.
To remove a shipping override, follow these steps:
Open your saved Shipping Overrides file (the text file you originally uploaded).
Enter "Delete" for the ASIN in the UpdateDelete column.
Go to Upload Products & Inventory and re-upload your text file.
Overrides
There are two types of shipping overrides:
Exclusive:
Creates an entirely new shipping charge.
Additive:
Adds an extra charge to the current shipping charge.
Exclusive False
This example of an "Exclusive" setting allows shipping to display as 0.00.
sku Currency ShipOption1 ShippingAmt1 Type1 IsShippingRestricted1 001 USD Std Cont US Street Addr 0.00 Exclusive False 002 USD Std Cont US Street Addr 0.00 Exclusive False 003 USD Std Cont US Street Addr 0.00 Exclusive False 004 USD Std Cont US Street Addr 0.00 Exclusive False Note: A "False" setting in column IsShippingRestricted1 in this case allows the overrides to be applied to this SKU, ShipOption (locale), Service Level, and so on.
This should be added to IsShippingRestricted2.
Exclusive True
In this example, the "True" setting prevents standard shipping from being offered on the list of SKUs.
sku Currency ShipOption1 ShippingAmt1 Type1 IsShippingRestricted1 001 USD Std Cont US Street Addr 0.00 Exclusive True 002 USD Std Cont US Street Addr 0.00 Exclusive True 003 USD Std Cont US Street Addr 0.00 Exclusive True 004 USD Std Cont US Street Addr 0.00 Exclusive True
Additive False
This example of an "Additive" setting allows shipping to display the standard shipping amount plus the additive amount.
sku Currency ShipOption1 ShippingAmt1 Type1 IsShippingRestricted1 001 USD Std Cont US Street Addr 18.99 Additive False 002 USD Std Cont US Street Addr 18.99 Additive False 003 USD Std Cont US Street Addr 18.99 Additive False 004 USD Std Cont US Street Addr 18.99 Additive False Since Type1 is "Additive," ShippingAmt1 ($18.99) will be added to the amount found in the shipping settings. For example, if regular shipping is $5.00, ShippingAmt1 ($18.99) is added for a total of $23.99, which will be displayed online.
The ShipOption Fields
The Valid Values tab in the Shipping Overrides file contains some shipping options (for the ShipOption fields) that are not available to all sellers. Refer to the table below for the ShipOption values enabled for your seller subscription level.
Free Economy Shipping Standard Shipping Expedited Shipping Two-Day Shipping Same-Day Delivery
Econ Cont US
Std APO/FPO PO Box
Std APO/FPO Street Addr
Std Alaska Hawaii PO Box
Std Alaska Hawaii Street Addr
Std Asia
Std Canada
Std Cont US PO Box
Std Cont US Street Addr
Std Europe
Std Outside US, EU, CA, Asia
Std US Prot PO Box
Std US Prot Street Addr
Exp APO/FPO PO Box
Exp APO/FPO Street Addr
Exp Alaska Hawaii PO Box
Exp Alaska Hawaii Street Addr
Exp Asia
Exp Canada
Exp Cont US PO Box
Exp Cont US Street Addr
Exp Europe
Exp Outside US, EU, CA, Asia
Exp US Prot PO Box
Exp US Prot Street Addr
Second
Same US
文章来源:亚马逊官方网站