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

Fail to Import table rate csv of Malaysia
 
ld1206
Jr. Member
 
Total Posts:  4
Joined:  2009-12-04
 

I am trying to use table rate shipping method, but I fail to import the tablerate.csv into database, I get the following errors

Invalid Region/State West Malaysia
Invalid Region/State Sabah
Invalid Region/State Sarawak

The content of tablerate.csv is

“Country”,"Region/State","Zip/Postal Code","Order Subtotal (and above)","Shipping Price”
“MYS","West Malaysia”,"*”,"0”,"22"
“MYS”,"Sabah”,"*”,"0”,"33"
“MYS”,"Sarawak”,"*”,"0”,"36”

Also I have imported regions of Malaysia into database

Table: directory_country_region

278 MYS JOH West Malaysia
279 MYS SAB Sabah
280 MYS SWK Sarawak

Table: directory_country_region_name

en_US 278 West Malaysia
en_US 279 Sabah
en_US 280 Sarawak

Is there anyone know how to solve it?

Thanks a lot

 
Magento Community Magento Community
Magento Community
Magento Community
 
pling
Member
 
Total Posts:  31
Joined:  2009-05-24
 

Hi,

You should use the short form state name instead of full name and use “ * “ for West Malaysia.

“Country”,"Region/State","Zip/Postal Code","Order Subtotal (and above)","Shipping Price”
“MYS”,"*”,"*”,"0”,"22"
“MYS”,"SAB”,"*”,"0”,"33"
“MYS”,"SWK”,"*”,"0”,"36”

hope this help.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ld1206
Jr. Member
 
Total Posts:  4
Joined:  2009-12-04
 
pling - 08 December 2009 03:25 AM

Hi,

You should use the short form state name instead of full name and use “ * “ for West Malaysia.

“Country”,"Region/State","Zip/Postal Code","Order Subtotal (and above)","Shipping Price”
“MYS”,"*”,"*”,"0”,"22"
“MYS”,"SAB”,"*”,"0”,"33"
“MYS”,"SWK”,"*”,"0”,"36”

hope this help.

Thank you, I tried it, but it still not work, the error is still the same

# Invalid Region/State “SAB” in the Row #2
# Invalid Region/State “SWK” in the Row #3

 
Magento Community Magento Community
Magento Community
Magento Community
 
pling
Member
 
Total Posts:  31
Joined:  2009-05-24
 

Hi

try this country_id for this table should be MY not MYS

Table: directory_country_region

278 MY JOH West Malaysia
279 MY SAB Sabah
280 MY SWK Sarawak

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