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

Importing Table Rates csv Format. 
 
SoapMedia
Member
 
Avatar
Total Posts:  32
Joined:  2008-03-28
 

IVe tried importing a CSV (see attached) of table rates however i get an error for each line e.g.

# Invalid Country “Afghanistan” in the Row #2
# Invalid Country “Albania” in the Row #3
# Invalid Country “Algeria” in the Row #4
# Invalid Country “American Samoa” in the Row #5
# Invalid Country “Andorra” in the Row #6
# Invalid Country “Angola” in the Row #7
# Invalid Country “Anguilla” in the Row #8
# Invalid Country “Antarctica” in the Row #9

could someone check the format of my csv or let me know what the correct format is. im using :

Country,Region/State,Zip/Postal Code,Order Subtotal (and above),Shipping Price
USA,*,*,0,15
Afghanistan,*,*,0,15
Albania,*,*,0,15
Algeria,*,*,0,15
American Samoa,*,*,0,15
Andorra,*,*,0,15

etc.etc

 
Magento Community Magento Community
Magento Community
Magento Community
 
hydra
Guru
 
Avatar
Total Posts:  378
Joined:  2008-08-26
Amsterdam
 

You need to use the 3 character country codes for country.
check the attachment.

File Attachments
directory_country.xml  (File Size: 48KB - Downloads: 509)
 
Magento Community Magento Community
Magento Community
Magento Community
 
kiatng
Enthusiast
 
Total Posts:  875
Joined:  2008-09-03
Kuala Lumpur, Malaysia
 

I made exactly the same mistake.  Thanks for the 3 char codes. It works great.

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