Sell on Amazon Sign in
This article applies to selling in: United States

Customize shipping settings with the shipping override 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.
Individual sellers: This feature is available to sellers with Professional selling plans.

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 200-pound television to Canada. You can override shipping for selected products with a Shipping Overrides file, which is similar to the inventory file templates.

There are two types of shipping overrides:

Exclusive

Creates an entirely new shipping charge.

Additive

Adds an extra charge to the current shipping charge.

For examples and valid values, see the Overrides Examples section below.

Create or remove a shipping override

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 our data, make sure you are on 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.
    Note: You might see a warning that the selected file format does not support workbooks containing multiple worksheets. Or you might see a warning that your file contains features incompatible with the text file format. Click Yes in both cases.
  6. 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 Excel file you originally uploaded, or import the text (*.txt) file back into Excel).
  2. Enter "Delete" for the ASIN in the UpdateDelete column.
  3. After you finish entering our data, make sure you are on the Shipping Overrides tab and save the file as an Excel file, giving it a unique name.
  4. Save your workbook again, with a different name, as a text (*.txt) file.
  5. Go to Upload Products & Inventory and re-upload your file.

Additive false override example

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

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.

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

Exclusive false override example

This example of an Exclusive setting allows shipping to display as $0.00.

A "False" setting in this case allows the overrides to be applied to this SKU, ShipOption (locale), Service Level, and so on.

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

Exclusive true override example

In this example, a "True" setting prevents ShipOption 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

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 Second 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
Sign in to use the tool and get personalized help (desktop browser required). Sign in


Was this article helpful?
Thank you for your feedback
How can we improve this help page? Note: This form doesn’t create a support case. Please specify what you think is wrong with the content itself.
1000
What was helpful?
1000
Thanks again for your help!
Thank you for your feedback. If you have more questions, please Contact Us.

Reach Hundreds of Millions of Customers

Start Selling On Amazon


© 1999-2020, Amazon.com, Inc. or its affiliates