İl ve İlçe kavramları Magento için biraz farklı oluyor, bu yüzden Region’ı il olarak ve City’i ilçe olarak düşünebiliriz, eğer translate dosyasında problem yaşarsanız dosyadaki çevirileri değiştirebilirsiniz.


INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '01', 'Adana');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Adana');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '02', 'Adıyaman');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Adıyaman');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '03', 'Afyon');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Afyon');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '04', 'Ağrı');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Ağrı');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '68', 'Aksaray');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Aksaray');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '05', 'Amasya');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Amasya');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '06', 'Ankara');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Ankara');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '07', 'Antalya');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Antalya');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '75', 'Ardahan');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Ardahan');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '08', 'Artvin');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Artvin');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '09', 'Aydın');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Aydın');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '10', 'Balikesir');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Balikesir');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '74', 'Bartın');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Bartın');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '72', 'Batman');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Batman');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '69', 'Bayburt');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Bayburt');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '11', 'Bilecik');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Bilecik');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '12', 'Bingöl');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Bingöl');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '13', 'Bitlis');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Bitlis');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '14', 'Bolu');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Bolu');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '15', 'Burdur');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Burdur');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '16', 'Bursa');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Bursa');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '17', 'Çanakkale');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Çanakkale');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '18', 'Çankırı');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Çankırı');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '19', 'Çorum');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Çorum');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '20', 'Denizli');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Denizli');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '21', 'Diyarbakir');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Diyarbakir');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '81', 'Düzce');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Düzce');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '22', 'Edirne');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Edirne');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '23', 'Elazığ');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Elazığ');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '24', 'Erzincan');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Erzincan');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '25', 'Erzurum');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Erzurum');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '26', 'Eskişehir');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Eskişehir');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '27', 'Gaziantep');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Gaziantep');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '28', 'Giresun');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Giresun');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '29', 'Gümüşhane');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Gümüşhane');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '30', 'Hakkari');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Hakkari');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '31', 'Hatay');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Hatay');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '76', 'Iğdır');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Iğdır');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '32', 'Isparta');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Isparta');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '33', 'İçel');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'İçel');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '34', 'İstanbul');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'İstanbul');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '35', 'İzmir');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'İzmir');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '78', 'Karabük');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Karabük');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '36', 'Kars');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kars');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '37', 'Kastamonu');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kastamonu');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '38', 'Kayseri');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kayseri');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '71', 'Kırıkkale');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kırıkkale');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '39', 'Kırklareli');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kırklareli');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '40', 'Kırşehir');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kırşehir');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '79', 'Kilis');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kilis');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '41', 'Kocaeli');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kocaeli');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '42', 'Konya');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Konya');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '43', 'Kütahya');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kütahya');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '44', 'Malatya');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Malatya');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '45', 'Manisa');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Manisa');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '46', 'Kahramanmaraş');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kahramanmaraş');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '70', 'Karaman');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Karaman');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '47', 'Mardin');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Mardin');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '48', 'Muğla');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Muğla');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '49', 'Muş');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Muş');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '50', 'Nevşehir');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Nevşehir');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '51', 'Niğde');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Niğde');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '52', 'Ordu');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Ordu');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '80', 'Osmaniye');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Osmaniye');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '53', 'Rize');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Rize');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '54', 'Sakarya');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Sakarya');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '55', 'Samsun');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Samsun');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '56', 'Siirt');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Siirt');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '57', 'Sinop');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Sinop');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '58', 'Sivas');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Sivas');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '73', 'Şırnak');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Şırnak');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '59', 'Tekirdağ');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Tekirdağ');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '60', 'Tokat');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Tokat');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '61', 'Trabzon');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Trabzon');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '62', 'Tunceli');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Tunceli');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '63', 'Şanlıurfa');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Şanlıurfa');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '64', 'Uşak');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Uşak');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '65', 'Van');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Van');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '77', 'Yalova');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Yalova');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '66', 'Yozgat');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Yozgat');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '67', 'Zonguldak');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Zonguldak');