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

Table for Shipping Methods
 
Youhitthespot
Jr. Member
 
Total Posts:  6
Joined:  2010-06-08
 

Hi,
I have created a spreadsheet in Microsoft excel and uploaded it to Magento. After uploading the page to Magento I received the message “Configuration successfully saved”. But when I went to checkout in my store, Magento then told me “Sorry, no quotes are available for this order at this time.” Something is not connecting in Magento or maybe I need to make corrections in my spreadsheet…

I cannot use my site until this is worked out.  I have included the excel spreadsheet I have created.

Any help would be appreciated,

Thanks!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Youhitthespot
Jr. Member
 
Total Posts:  6
Joined:  2010-06-08
 

"Country” “Region/State” “Postal Code” “Weight (and above)” “Standard” “Express”

“USA” “*” “*” “1” “4.9” “19.9”
“USA” “*” “*” “250” “7.5” “19.9”
“USA” “*” “*” “500” “9.5” “22.9”
“USA” “*” “*” “750” “10.5” “24.9”
“USA” “*” “*” “1000” “16.5” “28.9”
“USA” “*” “*” “1500” “19.5” “31.9”
“USA” “*” “*” “2000” “28.5” “35.5”
“USA” “*” “*” “3000” “36.5” “38.5”
“USA” “*” “*” “4000” “44.5” “44.5”
“USA” “*” “*” “5000” “50.5” “50.5”
“USA” “*” “*” “6000” “57.5” “57.5”
“USA” “*” “*” “7000” “62.5” “62.5”
“USA” “*” “*” “8000” “70.5” “70.5”
“USA” “*” “*” “9000” “77.5” “77.5”
“USA” “*” “*” “10000” “84.5” “84.5”
“USA” “*” “*” “11000” “90.5” “90.5”
“USA” “*” “*” “12000” “97.5” “97.5”
“USA” “*” “*” “13000” “103.5” “103.5”
“USA” “*” “*” “14000” “110.5” “110.5”
“USA” “*” “*” “15000” “116.5” “116.5”
“USA” “*” “*” “16000” “123.5” “123.5”
“USA” “*” “*” “17000” “129.5” “129.5”
“USA” “*” “*” “18000” “136.5” “136.5”
“USA” “*” “*” “19000” “142.5” “142.5”
“USA” “*” “*” “20000” “162.5” “162.5”
“AU” “*” “*” “1” “4.9” “19.9”
“AU” “*” “*” “250” “7.5” “19.9”
“AU” “*” “*” “500” “9.5” “22.9”
“AU” “*” “*” “750” “10.5” “24.9”
“AU” “*” “*” “1000” “16.5” “28.9”
“AU” “*” “*” “1500” “19.5” “31.9”
“AU” “*” “*” “2000” “28.5” “35.5”
“AU” “*” “*” “3000” “36.5” “38.5”
“AU” “*” “*” “4000” “44.5” “44.5”
“AU” “*” “*” “5000” “50.5” “50.5”
“AU” “*” “*” “6000” “57.5” “57.5”
“AU” “*” “*” “7000” “62.5” “62.5”
“AU” “*” “*” “8000” “70.5” “70.5”
“AU” “*” “*” “9000” “77.5” “77.5”
“AU” “*” “*” “10000” “84.5” “84.5”
“AU” “*” “*” “11000” “90.5” “90.5”
“AU” “*” “*” “12000” “97.5” “97.5”
“AU” “*” “*” “13000” “103.5” “103.5”
“AU” “*” “*” “14000” “110.5” “110.5”
“AU” “*” “*” “15000” “116.5” “116.5”
“AU” “*” “*” “16000” “123.5” “123.5”
“AU” “*” “*” “17000” “129.5” “129.5”
“AU” “*” “*” “18000” “136.5” “136.5”
“AU” “*” “*” “19000” “142.5” “142.5”
“AU” “*” “*” “20000” “162.5” “162.5”
“AT” “*” “*” “1” “4.9” “19.9”
“AT” “*” “*” “250” “7.5” “19.9”
“AT” “*” “*” “500” “9.5” “22.9”
“AT” “*” “*” “750” “10.5” “24.9”
“AT” “*” “*” “1000” “16.5” “28.9”
“AT” “*” “*” “1500” “19.5” “31.9”
“AT” “*” “*” “2000” “28.5” “35.5”
“AT” “*” “*” “3000” “36.5” “38.5”
“AT” “*” “*” “4000” “44.5” “44.5”
“AT” “*” “*” “5000” “50.5” “50.5”
“AT” “*” “*” “6000” “57.5” “57.5”
“AT” “*” “*” “7000” “62.5” “62.5”
“AT” “*” “*” “8000” “70.5” “70.5”
“AT” “*” “*” “9000” “77.5” “77.5”
“AT” “*” “*” “10000” “84.5” “84.5”
“AT” “*” “*” “11000” “90.5” “90.5”
“AT” “*” “*” “12000” “97.5” “97.5”
“AT” “*” “*” “13000” “103.5” “103.5”
“AT” “*” “*” “14000” “110.5” “110.5”
“AT” “*” “*” “15000” “116.5” “116.5”
“AT” “*” “*” “16000” “123.5” “123.5”
“AT” “*” “*” “17000” “129.5” “129.5”
“AT” “*” “*” “18000” “136.5” “136.5”
“AT” “*” “*” “19000” “142.5” “142.5”
“AT” “*” “*” “20000” “162.5” “162.5”

 
Magento Community Magento Community
Magento Community
Magento Community
 
NeilA
Moderator
 
Avatar
Total Posts:  1372
Joined:  2007-09-17
Blue Mountains, Oz
 

I wonder if the country code for the US is causing the problem. There seems to be some issues with whether we use 2 or 3 character country codes, but you may find this useful:
http://www.magentocommerce.com/wiki/configuring_shipping_rates

Either way, I suspect you should use either all 2 letter codes or all 3 letter codes.

Regards

 
Magento Community Magento Community
Magento Community
Magento Community
 
Youhitthespot
Jr. Member
 
Total Posts:  6
Joined:  2010-06-08
 

Hi NeilA,

I changed the country code to 2 letters, and now it all works.
I also changed the format of the excel spreadsheet from a CSV comma delimited to a CSV MS-DOS.

Thank you for your help,
I really appreciate it.

 
Magento Community Magento Community
Magento Community
Magento Community
 
NeilA
Moderator
 
Avatar
Total Posts:  1372
Joined:  2007-09-17
Blue Mountains, Oz
 

Glad it was helpful - thanks for letting us know.

Cheers

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top