使用文本文件模板调整配送设置

注意: 此帮助页面不适用于已迁移到新配送设置的卖家,因为在新配送设置中,配送调整已由配送模板取代。了解如何迁移到新配送设置。

在某些情况下,您可能想要更改商品的默认配送设置。例如,如果您销售电视/音响类商品,那么可能不希望向某些区域配送大型家电(如电视)。您可以使用配送调整文件来调整所选商品的配送设置。

要创建配送调整文件,请执行以下步骤:

  1. 下载配送调整模板。

  2. 以 Microsoft Excel 或其他电子表格应用程序打开模板。

  3. 要在【配送调整】选项卡中输入您的商品数据,请参阅以下表格了解示例和有效的 ShipOption(配送选项)值。

  4. 输入数据后,转至【配送覆盖】选项卡并使用唯一文件名将文件保存为 Excel 文件。

  5. 使用不同文件名再次将您的工作薄保存为文本 (*.txt) 文件。

  6. 您可能会看到一条警告,提示选定的文件格式不支持包含多个工作表的工作簿,或文件包含与选定文本文件格式不兼容的功能。对于这两种情况,请点击【是】。

  7. 前往上传商品和库存,然后上传您的文件。


要删除配送覆盖,请按照以下步骤操作:

  1. 打开已保存的“配送覆盖”文件(您最初上传的文本文件)。

  2. 在 【UpdateDelete】 列中为该 ASIN 输入“删除”。

  3. 前往上传商品和库存,然后重新上传您的文本文件。


覆盖

现有两种类型的配送调整:

专用:

创建全新运费。

附加:

在当前运费的基础上增加额外费用。


“IsShippingRestricted”(配送是否受限)值为 False(否)的专用调整

此“专用”设置示例可让运费显示为 0.00。

skuCurrencyShipOption1ShippingAmt1类型1IsShippingRestricted1
001USDStd Cont US Street Addr0.00ExclusiveFalse
002USDStd Cont US Street Addr0.00ExclusiveFalse
003USDStd Cont US Street Addr0.00ExclusiveFalse
004USDStd Cont US Street Addr0.00ExclusiveFalse

注意: 在此示例中,【IsShippingRestricted1】 列中的“False”设置允许将调整应用于此 SKU、配送选项(地区)、服务级别等。

这应添加到 IsShippingRestricted2。


“IsShippingRestricted”值为 True(是)的专用调整

在此示例中,“True”设置会阻止在 SKU 列表中提供标准配送。

skuCurrencyShipOption1ShippingAmt1类型1IsShippingRestricted1
001USDStd Cont US Street Addr0.00ExclusiveTrue
002USDStd Cont US Street Addr0.00ExclusiveTrue
003USDStd Cont US Street Addr0.00ExclusiveTrue
004USDStd Cont US Street Addr0.00ExclusiveTrue


“IsShippingRestricted”值为 False 的附加调整

此“附加”设置示例允许将运费显示为标准运费额与附加费用额之和。

skuCurrencyShipOption1ShippingAmt1类型1IsShippingRestricted1
001USDStd Cont US Street Addr18.99AdditiveFalse
002USDStd Cont US Street Addr18.99AdditiveFalse
003USDStd Cont US Street Addr18.99AdditiveFalse
004USDStd Cont US Street Addr18.99AdditiveFalse

由于“Type1”(类型 1)字段的值为“Additive”(附加),系统会将“ShippingAmt1”(运费 1)的值(18.99 美元)与配送设置中的金额加起来。例如,如果正常运费是 5.00 美元,那么,加上 ShippingAmt1 值(18.99 美元)后,总金额将是 23.99 美元,且此金额将在线显示出来。


ShipOption 字段

配送调整文件的【有效值】选项卡中提供的部分配送选项(ShipOption 字段)目前并未向所有卖家开放。请参阅以下表格,了解您加入的卖家计划启用了哪些 ShipOption 值。

自由经济型配送标准配送加急配送隔日达当日达
  • 美国大陆经济型配送

  • APO/FPO 信箱标准配送

  • 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




    亚马逊官网原文详情:   

    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:

    1. Download the Shipping Overrides template.

    2. Open the template in Microsoft Excel or another spreadsheet application.

    3. Enter your product data on the Shipping Overrides tab, referring to the tables below for examples and valid ShipOption values.

    4. 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.

    5. Save your workbook again, with a different name, as a text (*.txt) file.

    6. 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.

    7. Go to Upload Products & Inventory and upload your file.


    To remove a shipping override, follow these steps:

    1. Open your saved Shipping Overrides file (the text file you originally uploaded).

    2. Enter "Delete" for the ASIN in the UpdateDelete column.

    3. 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.

    skuCurrencyShipOption1ShippingAmt1Type1IsShippingRestricted1
    001USDStd Cont US Street Addr0.00ExclusiveFalse
    002USDStd Cont US Street Addr0.00ExclusiveFalse
    003USDStd Cont US Street Addr0.00ExclusiveFalse
    004USDStd Cont US Street Addr0.00ExclusiveFalse

    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.

    skuCurrencyShipOption1ShippingAmt1Type1IsShippingRestricted1
    001USDStd Cont US Street Addr0.00ExclusiveTrue
    002USDStd Cont US Street Addr0.00ExclusiveTrue
    003USDStd Cont US Street Addr0.00ExclusiveTrue
    004USDStd Cont US Street Addr0.00ExclusiveTrue


    Additive False

    This example of an "Additive" setting allows shipping to display the standard shipping amount plus the additive amount.

    skuCurrencyShipOption1ShippingAmt1Type1IsShippingRestricted1
    001USDStd Cont US Street Addr18.99AdditiveFalse
    002USDStd Cont US Street Addr18.99AdditiveFalse
    003USDStd Cont US Street Addr18.99AdditiveFalse
    004USDStd Cont US Street Addr18.99AdditiveFalse

    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 ShippingStandard ShippingExpedited ShippingTwo-Day ShippingSame-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


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