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)
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.
- Installing Yotpo Reviews Extension
- Magento-SugarCRM integration guide
- Configure Magento error page
- UK Delivery Shipping Table Rates
- How To Setup UPS shipping for negotiated rates
- Magento Sitemap - steps to improve
- SEO: Improving Magento sitemap
- How to work with Magento Url Rewrite rules
- Creating Google Sitemaps for Magento sites
- Using Google Checkout with Magento
Recommended Web Hosting For Bloggers and Designers
I recoomended Webhostings for Bloggers and Designers because I am freelancer, working with thousand clients in the worlds. Most of them will use those hosts.
- Fast, Reliable, Affordable
- 100% Satisfaction Guarantee
- And More...