How to Add New Region for Specific Country in Magento 2 for Egypt

How to Add New Region for Specific Country in Magento 2 for Egypt

As we know Magento don’t provide list of Egypt regions we can add them by below method

Method to Add New Region for Specific Country in Magento 2:
Run the below SQL query:

INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("country_code","region_code","region_name");

For example, I want to add a new region “Cairo” for India as shown below:

INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","CAI","القاهرة");

Use bellow code to add them all in 1 time

INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","NOSINA","شمال سيناء");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","SOSINA","جنوب سيناء");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","MTROH","مرسي مطروح");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","NEWWADI","الوادي الجديد");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","REDSEA","البحر الأحمر");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","AQSR","الأقصر");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","ASWAN","أسوان");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","QENA","قنا");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","SWHAG","سوهاج");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","ASEUT","أسيوط");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","ALMENEA","المنيا");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","ALFEUM","الفيوم");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","BANYSUEF","بني سويف");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","ALGEZA","الجيزة");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","ISMALIA","الاسماعيلية");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","ALBHERA","البحيرة");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","ALMNUFIA","المنوفية");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","ALGHARBIA","الغربية");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","KAFRALSHEKH","كفر الشيخ");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","ALQALYUBIA","القليوبية");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","ALSHARQIA","الشرقية");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","ALDAQHLIA","الدقلهلية");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","DUMIAT","دمياط");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","SEUZ","السويس");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","OS","بورسعيد");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","ALEX","الاسكندرية");
INSERT INTO directory_country_region(country_id, code, default_name) VALUES ("EG","CAI","القاهرة");

Download the code from github: https://github.com/itc4u/magento2egyptregions/

Thanks for reading my post.

Share this post


0
    0
    السلة
    السلة فارغةالعودة للمتجر