Add India states in to magento

Here is the process of adding states into Magento site to show into frontend. Here I am giving you example of India’s state. Similar way you can add others.

Copy to Clipboard

INSERT INTO `directory_country_region` VALUES 
(NULL , "IN", "Andaman and Nicobar","Andaman and Nicobar"), 
(NULL , "IN", "Andhra Pradesh","Andhra Pradesh"), 
(NULL , "IN", "Arunachal Pradesh","Arunachal Pradesh"), 
(NULL , "IN", "Assam","Assam"), 
(NULL , "IN", "Bihar","Bihar"), 
(NULL , "IN", "Chandigarh","Chandigarh"), (
NULL , "IN", "Chhattisgarh","Chhattisgarh"), 
(NULL , "IN", "Dadra and Nagar Haveli","Dadra and Nagar Haveli"), 
(NULL , "IN", "Daman and Diu","Daman and Diu"), 
(NULL , "IN", "Delhi","Delhi"), 
(NULL , "IN", "Goa","Goa"), 
(NULL , "IN", "Gujarat","Gujarat"),
(NULL , "IN", "Haryana","Haryana"),
(NULL , "IN", "Himachal Pradesh","Himachal Pradesh"), 
(NULL , "IN", "Jammu and Kashmir","Jammu and Kashmir"), 
(NULL , "IN", "Jharkhand","Jharkhand"), 
(NULL , "IN", "Karnataka","Karnataka"), 
(NULL , "IN", "Kerala","Kerala"), 
(NULL , "IN", "Lakshadweep","Lakshadweep"), 
(NULL , "IN", "Madhya Pradesh","Madhya Pradesh"), 
(NULL , "IN", "Maharashtra","Maharashtra"), 
(NULL , "IN", "Manipur","Manipur"), 
(NULL , "IN", "Meghalaya","Meghalaya"), 
(NULL , "IN", "Mizoram","Mizoram"), 
(NULL , "IN", "Nagaland","Nagaland"), 
(NULL , "IN", "Orissa","Orissa"),
(NULL , "IN", "Pondicherry","Pondicherry"), 
(NULL , "IN", "Punjab","Punjab"), 
(NULL , "IN", "Rajasthan","Rajasthan"), 
(NULL , "IN", "Sikkim","Sikkim"), 
(NULL , "IN", "Tamil Nadu","Tamil Nadu"), 
(NULL , "IN", "Tripura","Tripura"), 
(NULL , "IN", "Uttar Pradesh","Uttar Pradesh"), 
(NULL , "IN", "Uttaranchal","Uttaranchal"), 
(NULL , "IN", "West Bengal","West Bengal"); 
INSERT INTO `directory_country_region_name` 
(`locale` ,`region_id` ,`name` ) 
SELECT 'en_US', tmp.region_id, tmp.default_name FROM 
`directory_country_region` AS tmp WHERE tmp.country_id='IN';

About Author:

Kalpesh Chavada

Kalpesh Chavada is Our Founder & CEO of Akshar Group Technologies. He is serving with 11+ years of experience in different technologies like Magento, WordPress, Laravel, jQuery, Shopify, Branding, and Digital Marketing. He is very good with creative logic and always ready to take on challenges.

About Author:

Kalpesh Chavada

We’re Waiting To Help You

Converting your Ideas into Reality

Quick links

Quick links

Services

Services

Get in touch

Get in touch