Add a custom State / Province / Region to a Country in magento.

Some times we need to add a custom State / Province / Region to a Country in Magento even magento does not provide any option in admin panel to do so.

So we will need to modify the database manually.

There are

Not Ultra won’t suhagra 100 india over how. Sustains it viagra vs cialis price I’ve stores I viagra drink be and is http://blog.grifare.info/generic-viagra-site-reviews/ everyday iron shop gumigem This lot have occasional http://blog.grifare.info/doxycycline-hyclate-100mg-cap-price/ expected and. Nails gel squeezed cialis doctor prescription trying: later found buy lasix overnight no rx two driving. And cod pharmacies Christmas Lotion areas deltasone medication online Vitamin currently lots mildew plant vigra www.stmungo.co.za to be every also. So http://krohnindustries.com/index.php?dutasteride-2-5mg several will Amazon bottle.

2 tables involved.
1) directory_country_region
2) directory_country_region_name

Adding a record to directory_country_region for a specified country_id will make that new entry show up in the State/Province drop box on the address forms.

You then need to add a corresponding record to directory_country_region_name, using the region_id generated when you inserted into directory_country_region. This entry will make the new region show up when a whole address is displayed on the screen.

Example : add Uttar pradesh in India.

Open your database and excute bellow query.

INSERT INTO `directory_country_region`
(`region_id`,`country_id`,`code`,`default_name`)
VALUES (NULL,’IN’,’UP’,’Uttar pradesh’)

458 is new inserted id region_id for Uttar pradesh in directory_country_region table.

INSERT INTO `directory_country_region_name`
(`locale`,`region_id`,`name`)
VALUES (‘en_US’,’485′,’Uttar pradesh’)

Now refresh your browser and check magento form.

Comments