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.
First You need an example CSV file to edit. You can download it from
System/Configuration/(Main Website)/Shipping methods/Table rates
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.
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”
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
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
All shipping rates are then stored in Magento database under “shipping_tablerate” table.