Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Custom Table Rate Shipping Not working
 
mychoicegames
Member
 
Total Posts:  64
Joined:  2010-01-24
 

I tried importing this as a Microsoft Excel file (csv), but it isn’t working. It keeps saying “Invalid Table Rates File Format”

Please tell me what I am doing wrong.

Country Region/State Zip/Postal Code Weight (and above) Shipping Price
USA * * 45 27.49
USA * * 44 26.99
USA * * 43 26.49
USA * * 42 25.99
USA * * 41 25.49
USA * * 40 24.99
USA * * 39 24.49
USA * * 38 23.99
USA * * 37 23.49
USA * * 36 22.99
USA * * 35 22.49
USA * * 34 21.99
USA * * 33 21.49
USA * * 32 20.99
USA * * 31 20.49
USA * * 30 19.99
USA * * 29 18.99
USA * * 28 18.49
USA * * 27 17.99
USA * * 26 17.49
USA * * 25 16.99
USA * * 24 16.49
USA * * 23 15.99
USA * * 22 15.49
USA * * 21 14.99
USA * * 20 14.49
USA * * 19 13.99
USA * * 18 13.49
USA * * 17 12.99
USA * * 16 12.49
USA * * 15 11.99
USA * * 14 10.49
USA * * 13 9.99
USA * * 12 9.49
USA * * 11 8.99
USA * * 10 8.49
USA * * 9 7.99
USA * * 8 7.49
USA * * 7 6.99
USA * * 6 6.49
USA * * 5 5.99
USA * * 4 5.49
USA * * 3 4.99
USA * * 2 3.99
USA * * 1 2.99

 
Magento Community Magento Community
Magento Community
Magento Community
 
sanjaypapinazath
Jr. Member
 
Total Posts:  23
Joined:  2010-06-15
 

did u figure this out yet?  try this http://www.magentocommerce.com/wiki/manually_creating_shipping_table_rates

I tried both ways and i still cant get it to calculate shipping. All is says is no shipping method available. Any one know how to get it to work?

 
Magento Community Magento Community
Magento Community
Magento Community
 
quicoto
Member
 
Avatar
Total Posts:  39
Joined:  2010-06-15
 

mychoicegames, I think you’re missing (at least) the “,” between items.

You should save the file as a “csv comma separated”.

 
Magento Community Magento Community
Magento Community
Magento Community
 
sanjaypapinazath
Jr. Member
 
Total Posts:  23
Joined:  2010-06-15
 

i got the CSV to upload. But ths shipping still doesnt calculate. I have no idea why and just spent the whole day trying out different things.

 
Magento Community Magento Community
Magento Community
Magento Community
 
pezomatic
Sr. Member
 
Avatar
Total Posts:  190
Joined:  2008-11-05
 

I have also been trying to get this to work for hours. As everything Magento, using table Rates is as clear as mud.

Even if I get it working I do not know how it\’s supposed to handled different shipping methods.

We base all of our shipping on order total not weight. And we need to give the customer all of the UPS options, not just one. The documentation for Magento is so damn poor, it drives me crazy!

I tried the free WebShopApps extension, which sounded promising but I cannot get it to load either.

\"WebShopApps MatrixRate\” http://snipurl.com/10m65o

 
Magento Community Magento Community
Magento Community
Magento Community
 
quicoto
Member
 
Avatar
Total Posts:  39
Joined:  2010-06-15
 
sanjaypapinazath - 12 August 2010 12:57 PM

i got the CSV to upload. But ths shipping still doesnt calculate. I have no idea why and just spent the whole day trying out different things.

When you upload the CSV what it says? everything OK?

Are you using the correct country codes? http://php.quicoto.com/magento-country-codes-for-table-rate/

Here’s a fully working CSV lines:

"Country","Region/State","Zip/Postal Code","Weight (and above)","Shipping Price"
ESP,*,*,0.0100,9.0000
pezomatic - 12 August 2010 09:25 PM

I have also been trying to get this to work for hours. As everything Magento, using table Rates is as clear as mud.

Even if I get it working I do not know how it\’s supposed to handled different shipping methods.

We base all of our shipping on order total not weight. And we need to give the customer all of the UPS options, not just one. The documentation for Magento is so damn poor, it drives me crazy!

I tried the free WebShopApps extension, which sounded promising but I cannot get it to load either.

\"WebShopApps MatrixRate\” http://snipurl.com/10m65o

You can handle diferent shipping methods within the same table rate.

In your admin panel you have “free shiping” “table rate” and a couple more. You can use them all but not from the same table rate system.

There is a few extensions wich allows you to add a text to each CSV line and faking diferent shipping methods.

I got an example from the same extension:

CountryRegion/StateZip/Postal CodeWeight fromWeight toShipping PriceDelivery Type
ESP
, *, *, 20.000012000.000025.0000Standard
 
Magento Community Magento Community
Magento Community
Magento Community
 
sanjaypapinazath
Jr. Member
 
Total Posts:  23
Joined:  2010-06-15
 

hey. I had the same problem with the stupid CSV. but i found a csv example in another thread i think and got it to work.
This is what i did.

- copy the csv data
- paste it into a text doc and save the doc as a csv
- upload this csv for table rate shipping

u can check if its uploaded by going into ur php myadmin and looking at the db shipping_tablerate.

Hope it helps.

File Attachments
tablerates.txt  (File Size: 1KB - Downloads: 223)
 
Magento Community Magento Community
Magento Community
Magento Community
 
quicoto
Member
 
Avatar
Total Posts:  39
Joined:  2010-06-15
 

Do not edit the CSV with excel. Use a text editor (dreamweaver...)

Watch out the codification. Take an example and just edit it.

 
Magento Community Magento Community
Magento Community
Magento Community
 
pezomatic
Sr. Member
 
Avatar
Total Posts:  190
Joined:  2008-11-05
 

I decided to bypass the entire import CSV file step and wrote a FileMaker database that imports and manipulate the MySQL database directly. Boy, this is much better. Being able to see what is actually on the server really helps.

 
Magento Community Magento Community
Magento Community
Magento Community
 
diablo2001
Jr. Member
 
Total Posts:  1
Joined:  2010-10-04
 

My working table (edited with Notepad):

Country,Region/State,Zip/Postal Code,Weight (and above),Shipping Price
IT
,*,*,0,10
IT
,*,*,1,15
IT
,*,*,5,18
IT
,*,*,10,20
IT
,*,*,15,25
IT
,*,*,20,30
IT
,*,*,30,35
IT
,*,*,50,40
IT
,*,*,80,100
IT
,*,*,100,120
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top