Configuring Weight - destination shipping rates

Configuring worldwide shipping rates in Magento can be little tricky. I’ve just finally manage to set up shipping rates and here is how I’ve done it.

Get an example file

First You need an example CSV file to edit. You can download it from

System/Configuration/(Main Website)/Shipping methods/Table rates

Tool to edit the Shipping Rules

You are fine to use Excel/Open Office/etc, as then you will be able to view columns easily. If you are on a Mac then make sure you save as Windows file type else the upload will blank out the table underneath.

What's in Shipping Rules

The first row is the header, here you know the name for the columns you need to fill up.

“Country”,”Region/State”,”Zip/Postal Code”,”Weight (and above)”,”Shipping Price”

Country This can be the ISO 2 Letters (ISO 3166-1-alpha-2) or 3 Letters (ISO 3166-1-alpha-3).

Note: You’re able to see all codes in Magento database under the “directory_country” table.

Region/State This is the Regions or State used in the Shipping Address

Zip/Postal Code This is the Zip Code used in the Shipping Address

Weight (and above) This is the minimum weight

Shipping Price This is the final Shipping price

Editing the Shipping Rules

In my file I inserted this entrances:

(It’s not my full table but, just an example)

Test

Tricks

The tricky part that I come across in order to successfully create a fully working shipping rates in Magento was to set the MINIMUM weight to something more that just 0 (zero).

You can see minimum weight are set to 10 grams

“US”,”*”,”*”,“0.010”,”81.50”

All shipping rates are then stored in Magento database under “shipping_tablerate” table.