States can't be selected while configuring Tax Rates

[cmpugay]

I'm trying to configure Tax Rates base on home state and other states but after selecting home country, unable to select States.

I'm able to select State if change ountry to US or other except India.

Please help

[Damian Culotta]

Hi @cmpugay,

The reason is not all regions are included by default into Magento.

If you want to add new regions you'll need to add those values into the directory_country_region table (with the country association).

[cmpugay]

@ Damian,

Thanks for the help. Could you please help me on how to add States Values in directory_country_region table and associate with country.

[Damian Culotta · Accepted solution]

@cmpugay,

There isn't an interface so you'll need to execute mysql queries. If you are not familiar with databases maybe you'll prefer to get some tech help to do the work. Isn't too complex but is better if you can request qualified help.

Just an example for one new region:

INSERT INTO directory_country_region(country_id, code, default_name) VALUES ('AR','ba', 'Buenos Aires');

In my example, values are:

• AR: Argentina country code. This value is present into directory_country database table. You'll need to find your country code there. (India code is IN)
• ba: code for my region (in my example, the name is Buenos Aires so I've choosed ba)
• Buenos Aires: region name.

You'll need one query per region that you want to add.