Getting Table Rates to work with v1.1.6 was trivial. Magento has a great tool built-in for uploading a spread-sheet that contains your table rates. I tried this about 3-4 times before realizing that there must be a bug after seeing the words “Sorry, no quotes are available for this order at this time.” displayed on the website where the shipping methods are usually located. I did some research on the magento forums and found that some other users had similar issues.

The solution was to export the .csv document from magento to your desktop, then open in a text editor (NOT EXCEL), then make you adjustments, then re-upload. Voila, it works.

Here is a sample of what my .csv file looked like:
“Country”,”Region/State”,”Zip/Postal Code”,”# of Items (and above)”,”Shipping Price”
“USA”,”*”,”*”,”1”,”3.95″
“USA”,”*”,”*”,”3”,”5.95″
“USA”,”*”,”*”,”5”,”7.95″
“*”,”*”,”*”,”1”,”7.95″
“*”,”*”,”*”,”3”,”9.95″
“*”,”*”,”*”,”5”,”12.95″

At the time of writing this post, v1.1.8 has just been released and one of the bug fixes looks like a table shipping rates fix. I haven’t tried it yet, but wouldnt be surprised if this was fixed now. Good Job Magento!

Categories: MagentoOpen SourceWeb

6 thoughts on “Magento: Getting Table Rates to work with v1.1.6”

Brady · December 10, 2008 at 9:12 pm

When you say “export the .csv document”. What are you exporting and from where?

I am looking for a way to export order information and the CSV you have in the blog post looks promising.

Thanks!

PAUL · April 17, 2009 at 10:35 am

http://www.magentocommerce.com/knowledge-base/entry/how-do-i-set-up-table-rate-shipping

Hi hope this is of help as i am puting this web site on to a MAGENTO Platform

raul · December 29, 2009 at 6:13 am

If do I haven't able table rates?, I only have UPS and USPS shipping methods but I have the same problem

Melissa · April 4, 2010 at 1:05 am

The table rates are not working for me-even uploaded as a word doc. Help please!

shyamji · October 4, 2010 at 6:21 am

form where i can upload my csv from magento admin.

Hotel w Krakowie · September 14, 2011 at 5:47 pm

Have you considered adding some social bookmarking links to these sites. At least for twitter.

Leave a Reply

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

Related Posts

Web

Angular JS Magazine on Flipboard

I have been working with AngularJS for about a year now, trying to learn as much as I can about this growing framework. It’s been a wild ride and I’m going to post a summary Read more…

GruntJS

My First GruntJS Plugin: Bust My Cache

GruntJS is a JavaScript Task runner that has been around for about 2+ year, at least as far as I can remember. I started playing around with GruntJS which uses Node.js about a year ago, Read more…

Top 5

Top 5 Articles : Week of November 25

During the the week of November 25th, I really started to dive into Angular JS. My top 5 articles of the week are mainly about AngularJS, an MVC framework by Google. #1 : AngularJS WebInspector Read more…