Magento

Importing a new table works OK and no errors reported, but the table is ignored.

Exporting the same table gives a blank table, except for column headers included in the default table..

Anyone else have the same problem?

(The import problem was supposed to have been fixed in 19700)

no works correct with my version, only in the front-end the rates are scrambled.

is your csv file correctly saved? I had trouble with that in the beginning.

Gui - 10 May 2008 04:32 AM

is your csv file correctly saved? I had trouble with that in the beginning.

As far as I know it’s saved correctly and Magento reports “Configuration successfully saved”.

What problems did you have in the beginning?

Are you able to export what you imported?

my pc used a wrong character for the csv files, so that broke the table.

yes I can export the table. However when I request a quote or at checkout I always get the highest rate.

Works fine in mine too.  I have the latest version, but it worked in 1.0.19700 as well, for me.

i spent yesterday on this battle.

i downloaded the csv file, opened using excel, added some figures, saved and uploaded - but I think excel messed up the file, as it was always blank when i downloaded it again.

I opened the file in textedit, and it seemed to resolve the problem.  Also, putting “quotes” around the header data seemed to help things along.  Here are the first few lines of my file that has been uploaded and is now working.  hope it helps.

“Country”,"Region/State","Zip/Postal Code","Weight (and above)","Shipping Price”
GBR,*,*,0,0.7
GBR,*,*,0.1,1.1
GBR,*,*,0.25,1.4

Stoo, when you request a quote and at checkout do you get the correct price?

I was having the exact same problem, here’s how I fixed it:  In excel, do a “save as” and instead of the standard CSV file, pick CSV(Windows).

I don’t know if its my OSX version of Excel or what, but picking the windows CSV type (rather than a standard csv or msdos csv) fixed it for me.

Hope that helps someone!

I’m having the same issue and I have tried everything you have said.  It will not show up.  I downloads and then doesn’t show up. 
“Country” “Region/State” “Zip/Postal Code” “Order Subtotal (and above)” “Shipping Price”
USA OH 45002 35 4.99
USA OH 45030 35 4.99
USA OH 45051 35 4.99
USA OH 45052 35 4.99
USA OH 45111 35 4.99
USA OH 45174 35 4.99
USA OH 45202 35 4.99
USA OH 45203 35 4.99
USA OH 45204 35 4.99
USA OH 45205 35 4.99
USA OH 45206 35 4.99
USA OH 45207 35 4.99
USA OH 45208 35 4.99
USA OH 45209 35 4.99

Any suggestions would be great!

Thanks

Finally it work ! The problem is EXCEL messing with the file !!!

Download from this link CSVed (CSV file editor) : http://home.hccnet.nl/s.j.francke/csved/csvedsetup.exe

After export the CSV file from your magento admin and sepcify to open it with CSVed and not Excel. Once CSVed is opened click on ‘’EDIT’’ and ‘’ADD RECORD’’, then put in the colums the entry that you would like to put according the value example : USA, *, *, 0, 100

Save as and import.

sorry for my english !

Hope it help !

I’m having real problems getting my table rates to work!

I have followed every ‘guide’ and still cannot get the estimate shipping to show up accurately.

As you can see in my attached csv file I have set up shipping rates for my requirements.
They are as follows

Rest of the World ( *, *, *, shipping values)
UK (iso code GBR)
Shipping values for Europe ( iso codes ESP, FRA, DEU, FIN etc)
Shipping values for Canada and US (USA, CAN)

I believe that if I set value for the whole world eg (*, *, 5, 10) I can then over ride this value for the UK or EU specific countries? and this is shown in the CSV.

I have the latest version of Magento, I have edited my shipping in CSV ed and not Excel but when I estimate shipping for the UK, which is cheaper than FRANCE, it always shows up the values for FRANCE.

When I pick an obsucre country like ‘TOGO’ it still shows up the values which I have assigned for the EU countries!

HELP!

I am having the exact same issues with shipping table rates, version 1.0.19870. I have tested every single potential solution and I can’t fix this out. I suspect that this feature was fixed in the previous version 1.0.19700 but for those who have upgraded or installed the patch, the table rates broke again. I really hope this gets fixed again and would appreciate if someone is running the 1.0.19870 with the table rates working properly, could share some details with us.

As far as I know we are still waiting for the promised fix for table rate shipping that was mooted when 1.0 came out. Currently it only seems to work with a single country.

Hello people, are your table rate import working now? I need to set it up for multiple countries as well but it kept reverting to the US amount.