Magento

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.

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

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

To edit file DO NOT USE Excel/OpenOffice calc/etc. Use a simple Text Editor, like Notepad++ to be sure no other formatting is being applied to CSV file.

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

In my file I inserted this entrances:

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

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.