Sell on Amazon Sign in
This article applies to selling in: Canada

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 major appliance such as a television to certain regions. You can override shipping for selected products with a Shipping Overrides file.

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.

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

SKU Currency ShipOption1* ShippingAmt1 Type1 IsShippingRestricted1
001 CAD Std CA Dom 0.00 Exclusive False
002 CAD Std CA Dom 0.00 Exclusive False
003 CAD Std CA Dom 0.00 Exclusive False
004 CAD Std CA Dom 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.
SKU Currency ShipOption1* ShippingAmt1 Type1 IsShippingRestricted1
001 CAD Std CA Dom 0.00 Exclusive True
002 CAD Std CA Dom 0.00 Exclusive True
003 CAD Std CA Dom 0.00 Exclusive True
004 CAD Std CA Dom 0.00 Exclusive True
Note: In this example, the "True" setting prevents standard delivery from being offered on the list of SKUs.

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 CAD Std CA Dom 18.99 Additive False
002 CAD Std CA Dom 18.99 Additive False
003 CAD Std CA Dom 18.99 Additive False
004 CAD Std CA Dom 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 "Valid Values" tab for the template (2.0) includes some delivery options that are currently not available to all sellers. Below is a list of current delivery options:

Standard Shipping Expedited Shipping
  • Std CA Dom
  • Std CA US
  • Std CA Asia
  • Std CA Europe
  • Std CA Row
  • Exp CA Dom
  • Exp CA US
  • Exp CA Asia
  • Exp CA Europe
Sign in to use the tool and get personalized help (desktop browser required). Sign in


Reach Hundreds of Millions of Customers

Start Selling on Amazon


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