Magento Table Rates – Creator

As Magento Developers we work on a lot of Magento Sites. Magento Table Rates are something which often tends to confuse our clients. With the range of complex magento country codes, region codes and no example format easily downloadable, it can be a little more difficult than necessary.

So we have created an Easy to Use Magento Table Rate Creator to create a Magento table rate CSV’s . Click the images to download below:
Magento Table rates Creator

Here’s How to to use it:

  1. Download the Magento Table Rate Creator
  2. Open the Excel Document
  3. Be Sure to enable Macros (See slide for more info if necessary)
  4. Select the Country you’d like to ship to from the dropdown menu
  5. Select the Region from the dropdown
  6. Enter Order Subtotal
  7. If you’d like to match Postcodes, enter all the postcodes you’d like to match. One below each other in the postcodes section
  8. Enter the Shipping Cost for this Country, Region, Order Subtotal & Postcodes
  9. Click Populate
  10. Repeat until you have all the shipping config required.
  11. Copy and paste from the Output tab into the Magento Sample Table Rate CSV.
  12. Save this file
  13. Upload into your Magento Admin. (found at Admin > System > Configuration > Shipping Methods > Table rates ). If the upload option is not available change the Current Configuration Scope to Main Website

Or view the below slideshows for step by step instructions:

If you have any issues or need any help with this, just let us know in the comments below.

About BeetleJeremy

Spend most of my time working and researching SEO and have an interest in everything Digital. Particularly SEO, PPC and Digital Marketing. But have a particular penchant for doing Magento SEO within our Magento Development Company. Check out my Google + profile:
This entry was posted in Ecommerce, Magento and tagged , . Bookmark the permalink.

2 Responses to Magento Table Rates – Creator

  1. BB says:

    i have exel 2008 and the dropdown bar doesn’t appear for country…any ideas?

  2. BeetleJeremy says:

    Hello BB,

    I’ve created a 97-2003 compatible version. I hope it works for you. Here’s a link to it Magento Table Rate Creator 97-2003 compatible. I’ve just tested it and it doesn’t. :(

    Work around: Instead just type in the country you want and the code should be generated. For the exact name of the countries refer to our Magento Country Codes.

    Let me know if you need anymore help.


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>