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.