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:

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 our data, make sure you are on 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.
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.
Go to Upload Products & Inventory and upload your file.

To remove a shipping override, follow these steps:

Open your saved Shipping Overrides file (the Excel file you originally uploaded, or import the text (*.txt) file back into Excel).
Enter "Delete" for the ASIN in the UpdateDelete column.
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.
Save your workbook again, with a different name, as a text (*.txt) file.
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	Type1	IsShippingRestricted1
001	USD	Std Cont US Street Addr	Exclusive	False
002	USD	Std Cont US Street Addr	Exclusive	False
003	USD	Std Cont US Street Addr	Exclusive	False
004	USD	Std Cont US Street Addr	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	Type1	IsShippingRestricted1
001	USD	Std Cont US Street Addr	Exclusive	True
002	USD	Std Cont US Street Addr	Exclusive	True
003	USD	Std Cont US Street Addr	Exclusive	True
004	USD	Std Cont US Street Addr	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

Was this article helpful?

Yes

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.

This isn’t the help page I was looking for.

The content is confusing or hard to understand.

The content is inaccurate, outdated, or it's missing information.

The issue is about the feature or policy, not 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