Если кому нужно такое решение - перевод зон на русский язык, путем удаления старых и добавления новых через phpMyAdmin. Зоны взяты из русской сборки OpenCart 3.0.3.4 (Май 26, 2020).
В этой сборке не все регионы присутствуют, а только по странам:
• Белоруссия (Беларусь);
• Грузия;
• Казахстан;
• Киргизия (Кыргызстан);
• Российская Федерация;
• Украина;
• Узбекистан.
По ним, названия регионов на русском (кроме Грузии, Киргизии, и Узбекистана).
1. Сначала удаляем старые (меняем префикс "oc_" на свой, если нужно. Желательно убедиться, что "country_id" в таблице "oc_country" (20,80,109,115,176,220,226) соответствуют данным странам):
DELETE FROM `oc_zone` WHERE `oc_zone`.`country_id` IN(20,80,109,115,176,220,226)
2. Затем добавляем новые строки (меняем префикс "oc_" на свой, если нужно). zone_id будет проставлен автоматически, начиная со следующего числа последнего id, для этого в запросе мы его не указываем:
INSERT INTO oc_zone (country_id, name, code, status) VALUES (20,"Брест","BR",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (20,"Гомель","HO",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (20,"Минск","HM",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (20,"Гродно","HR",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (20,"Могилев","MA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (20,"Минская область","MI",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (20,"Витебск","VI",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (80,"Abkhazia","AB",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (80,"Ajaria","AJ",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (80,"Tbilisi","TB",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (80,"Guria","GU",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (80,"Imereti","IM",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (80,"Kakheti","KA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (80,"Kvemo Kartli","KK",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (80,"Mtskheta-Mtianeti","MM",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (80,"Racha Lechkhumi and Kvemo Svanet","RL",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (80,"Samegrelo-Zemo Svaneti","SZ",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (80,"Samtskhe-Javakheti","SJ",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (80,"Shida Kartli","SK",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (109,"Алматинская область","AL",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (109,"Алматы - город республ-го значения","AC",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (109,"Акмолинская область","AM",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (109,"Актюбинская область","AQ",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (109,"Астана - город республ-го значения","AS",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (109,"Атырауская область","AT",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (109,"Западно-Казахстанская область","BA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (109,"Байконур - город республ-го значения","BY",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (109,"Мангистауская область","MA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (109,"Южно-Казахстанская область","ON",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (109,"Павлодарская область","PA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (109,"Карагандинская область","QA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (109,"Костанайская область","QO",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (109,"Кызылординская область","QY",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (109,"Восточно-Казахстанская область","SH",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (109,"Северо-Казахстанская область","SO",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (109,"Жамбылская область","ZH",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (115,"Bishkek","GB",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (115,"Batken","B",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (115,"Chu","C",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (115,"Jalal-Abad","J",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (115,"Naryn","N",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (115,"Osh","O",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (115,"Talas","T",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (115,"Ysyk-Kol","Y",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Республика Хакасия","KK",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Московская область","MOS",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Чукотский АО","CHU",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Архангельская область","ARK",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Астраханская область","AST",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Алтайский край","ALT",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Белгородская область","BEL",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Еврейская АО","YEV",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Амурская область","AMU",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Брянская область","BRY",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Чувашская Республика","CU",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Челябинская область","CHE",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Карачаево-Черкесия","KC",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Забайкальский край","ZAB",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Ленинградская область","LEN",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Республика Калмыкия","KL",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Сахалинская область","SAK",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Республика Алтай","AL",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Чеченская Республика","CE",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Иркутская область","IRK",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Ивановская область","IVA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Удмуртская Республика","UD",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Калининградская область","KGD",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Калужская область","KLU",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Республика Татарстан","TA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Кемеровская область","KEM",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Хабаровский край","KHA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Ханты-Мансийский АО - Югра","KHM",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Костромская область","KOS",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Краснодарский край","KDA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Красноярский край","KYA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Курганская область","KGN",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Курская область","KRS",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Республика Тыва","TY",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Липецкая область","LIP",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Магаданская область","MAG",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Республика Дагестан","DA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Республика Адыгея","AD",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Москва","MOW",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Мурманская область","MUR",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Республика Кабардино-Балкария","KB",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Ненецкий АО","NEN",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Республика Ингушетия","IN",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Нижегородская область","NIZ",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Новгородская область","NGR",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Новосибирская область","NVS",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Омская область","OMS",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Орловская область","ORL",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Оренбургская область","ORE",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Пензенская область","PNZ",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Пермский край","PER",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Камчатский край","KAM",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Республика Карелия","KR",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Псковская область","PSK",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Ростовская область","ROS",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Рязанская область","RYA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Ямало-Ненецкий АО","YAN",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Самарская область","SAM",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Республика Мордовия","MO",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Саратовская область","SAR",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Смоленская область","SMO",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Санкт-Петербург","SPE",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Ставропольский край","STA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Республика Коми","KO",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Тамбовская область","TAM",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Томская область","TOM",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Тульская область","TUL",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Тверская область","TVE",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Тюменская область","TYU",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Республика Башкортостан","BA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Ульяновская область","ULY",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Республика Бурятия","BU",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Республика Северная Осетия","SE",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Владимирская область","VLA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Приморский край","PRI",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Волгоградская область","VGG",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Вологодская область","VLG",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Воронежская область","VOR",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Кировская область","KIR",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Республика Саха","SA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Ярославская область","YAR",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Свердловская область","SVE",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Республика Марий Эл","ME",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Республика Крым","CR",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Черкассы","CK",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Чернигов","CH",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Черновцы","CV",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Днепропетровск","DN",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Донецк","DO",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Ивано-Франковск","IV",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Харьков","KH",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Хмельницкий","KM",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Кировоград","KR",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Киевская область","KV",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Киев","KY",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Луганск","LU",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Львов","LV",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Николаев","MY",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Одесса","OD",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Полтава","PO",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Ровно","RI",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Севастополь","SEV",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Сумы","SU",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Тернополь","TE",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Винница","VI",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Луцк","VO",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Ужгород","ZK",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Запорожье","ZA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Житомир","ZH",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (220,"Херсон","KE",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (226,"Andijon","AN",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (226,"Buxoro","BU",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (226,"Farg'ona","FA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (226,"Jizzax","JI",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (226,"Namangan","NG",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (226,"Navoiy","NW",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (226,"Qashqadaryo","QA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (226,"Qoraqalpog'iston Republikasi","QR",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (226,"Samarqand","SA",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (226,"Sirdaryo","SI",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (226,"Surxondaryo","SU",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (226,"Toshkent City","TK",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (226,"Toshkent Region","TO",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (226,"Xorazm","XO",1);
INSERT INTO oc_zone (country_id, name, code, status) VALUES (176,"Байконур - город республ-го значения","BY",1);
3. Если нужно заменить названия стран на русский, то лучше это сделать вручную через БД, не удаляя их, чтобы country_id остались прежними.
4. После этого очищаем кэш, удалив файлы внутри директории storage/cache/ через FTP или файловый менеджер на хостинге.
P.S. насчет старых привязок зон к каким-либо параметрам на сайте сказать ничего не могу, у меня их не было, данное решение помогло.
