OpenCart中文化之後資料表的部分因為仍是以內建的羅馬拼音為主，所以如果要把資料表中的"國家"和"地區"選項，針對台灣、中國、日本等...進行字元的改變，則可以進入資料庫，將表單 "zone" 和 "country" 的內容由以下的代碼進行覆蓋即可:
進入SQL的輸入畫面，然後貼上以下的程式碼:
REPLACE INTO `zone` VALUES ('684', '44', '安徽省', 'AN', '1');
REPLACE INTO `zone` VALUES ('685', '44', '北京市', 'BE', '1');
REPLACE INTO `zone` VALUES ('686', '44', '重庆市', 'CH', '1');
REPLACE INTO `zone` VALUES ('687', '44', '福建省', 'FU', '1');
REPLACE INTO `zone` VALUES ('688', '44', '甘肃省', 'GA', '1');
REPLACE INTO `zone` VALUES ('689', '44', '广东省', 'GU', '1');
REPLACE INTO `zone` VALUES ('690', '44', '广西壮族自治区', 'GX', '1');
REPLACE INTO `zone` VALUES ('691', '44', '贵州省', 'GZ', '1');
REPLACE INTO `zone` VALUES ('692', '44', '海南省', 'HA', '1');
REPLACE INTO `zone` VALUES ('693', '44', '河北省', 'HB', '1');
REPLACE INTO `zone` VALUES ('694', '44', '黑龙江省', 'HL', '1');
REPLACE INTO `zone` VALUES ('695', '44', '河南省', 'HE', '1');
REPLACE INTO `zone` VALUES ('696', '44', '香港', 'HK', '0');
REPLACE INTO `zone` VALUES ('697', '44', '湖北省', 'HU', '1');
REPLACE INTO `zone` VALUES ('698', '44', '湖南省', 'HN', '1');
REPLACE INTO `zone` VALUES ('699', '44', '内蒙古自治区', 'IM', '1');
REPLACE INTO `zone` VALUES ('700', '44', '江苏省', 'JI', '1');
REPLACE INTO `zone` VALUES ('701', '44', '江西省', 'JX', '1');
REPLACE INTO `zone` VALUES ('702', '44', '吉林省', 'JL', '1');
REPLACE INTO `zone` VALUES ('703', '44', '辽宁省', 'LI', '1');
REPLACE INTO `zone` VALUES ('704', '44', '澳门', 'MA', '0');
REPLACE INTO `zone` VALUES ('705', '44', '宁夏回族自治区', 'NI', '1');
REPLACE INTO `zone` VALUES ('706', '44', '陕西省', 'SH', '1');
REPLACE INTO `zone` VALUES ('707', '44', '山东省', 'SA', '1');
REPLACE INTO `zone` VALUES ('708', '44', '上海市', 'SG', '1');
REPLACE INTO `zone` VALUES ('709', '44', '山西省', 'SX', '1');
REPLACE INTO `zone` VALUES ('710', '44', '四川省', 'SI', '1');
REPLACE INTO `zone` VALUES ('711', '44', '天津市', 'TI', '1');
REPLACE INTO `zone` VALUES ('712', '44', '新疆维吾尔自治区', 'XI', '1');
REPLACE INTO `zone` VALUES ('713', '44', '云南省', 'YU', '1');
REPLACE INTO `zone` VALUES ('714', '44', '浙江省', 'ZH', '1');
REPLACE INTO `zone` VALUES ('1410', '96', '港島中西區(Central and Western, Hong Kong Island)', 'HCW', '1');
REPLACE INTO `zone` VALUES ('1411', '96', '港島東區(Eastern, Hong Kong Island)', 'HEA', '1');
REPLACE INTO `zone` VALUES ('1412', '96', '港島南區(Southern, Hong Kong Island)', 'HSO', '1');
REPLACE INTO `zone` VALUES ('1413', '96', '港島灣仔區(Wan Chai, Hong Kong Island)', 'HWC', '1');
REPLACE INTO `zone` VALUES ('1414', '96', '九龍九龍城區(Kowloon City, Kowloon)', 'KKC', '1');
REPLACE INTO `zone` VALUES ('1415', '96', '九龍觀塘區(Kwun Tong, Kowloon)', 'KKT', '1');
REPLACE INTO `zone` VALUES ('1416', '96', '九龍深水埗區(Sham Shui Po, Kowloon)', 'KSS', '1');
REPLACE INTO `zone` VALUES ('1417', '96', '九龍黃大仙區(Wong Tai Sin, Kowloon)', 'KWT', '1');
REPLACE INTO `zone` VALUES ('1418', '96', '九龍油尖旺區(Yau Tsim Mong, Kowloon)', 'KYT', '1');
REPLACE INTO `zone` VALUES ('1419', '96', '新界離島區(Islands, New Territories)', 'NIS', '1');
REPLACE INTO `zone` VALUES ('1420', '96', '新界葵青區(Kwai Tsing, New Territories)', 'NKT', '1');
REPLACE INTO `zone` VALUES ('1421', '96', '新界北區(North, New Territories)', 'NNO', '1');
REPLACE INTO `zone` VALUES ('1422', '96', '新界西貢區(Sai Kung, New Territories)', 'NSK', '1');
REPLACE INTO `zone` VALUES ('1423', '96', '新界沙田區(Sha Tin, New Territories)', 'NST', '1');
REPLACE INTO `zone` VALUES ('1424', '96', '新界大埔區(Tai Po, New Territories)', 'NTP', '1');
REPLACE INTO `zone` VALUES ('1425', '96', '新界荃灣區(Tsuen Wan, New Territories)', 'NTW', '1');
REPLACE INTO `zone` VALUES ('1426', '96', '新界屯門區(Tuen Mun, New Territories)', 'NTM', '1');
REPLACE INTO `zone` VALUES ('1427', '96', '新界元朗區(Yuen Long, New Territories)', 'NYL', '1');
REPLACE INTO `zone` VALUES ('1657', '107', '愛知県', 'AI', '1');
REPLACE INTO `zone` VALUES ('1658', '107', '秋田県', 'AK', '1');
REPLACE INTO `zone` VALUES ('1659', '107', '青森県', 'AO', '1');
REPLACE INTO `zone` VALUES ('1660', '107', '千葉県', 'CH', '1');
REPLACE INTO `zone` VALUES ('1661', '107', '愛媛県', 'EH', '1');
REPLACE INTO `zone` VALUES ('1662', '107', '福井県', 'FK', '1');
REPLACE INTO `zone` VALUES ('1663', '107', '福岡県', 'FU', '1');
REPLACE INTO `zone` VALUES ('1664', '107', '福島県', 'FS', '1');
REPLACE INTO `zone` VALUES ('1665', '107', '岐阜県', 'GI', '1');
REPLACE INTO `zone` VALUES ('1666', '107', '群馬県', 'GU', '1');
REPLACE INTO `zone` VALUES ('1667', '107', '広島県', 'HI', '1');
REPLACE INTO `zone` VALUES ('1668', '107', '北海道', 'HO', '1');
REPLACE INTO `zone` VALUES ('1669', '107', '兵庫県', 'HY', '1');
REPLACE INTO `zone` VALUES ('1670', '107', '茨城県', 'IB', '1');
REPLACE INTO `zone` VALUES ('1671', '107', '石川県', 'IS', '1');
REPLACE INTO `zone` VALUES ('1672', '107', '岩手県', 'IW', '1');
REPLACE INTO `zone` VALUES ('1673', '107', '香川県', 'KA', '1');
REPLACE INTO `zone` VALUES ('1674', '107', '鹿児島県', 'KG', '1');
REPLACE INTO `zone` VALUES ('1675', '107', '神奈川県', 'KN', '1');
REPLACE INTO `zone` VALUES ('1676', '107', '高知県', 'KO', '1');
REPLACE INTO `zone` VALUES ('1677', '107', '熊本県', 'KU', '1');
REPLACE INTO `zone` VALUES ('1678', '107', '京都府', 'KY', '1');
REPLACE INTO `zone` VALUES ('1679', '107', '三重県', 'MI', '1');
REPLACE INTO `zone` VALUES ('1680', '107', '宮城県', 'MY', '1');
REPLACE INTO `zone` VALUES ('1681', '107', '宮崎県', 'MZ', '1');
REPLACE INTO `zone` VALUES ('1682', '107', '長野県', 'NA', '1');
REPLACE INTO `zone` VALUES ('1683', '107', '長崎県', 'NG', '1');
REPLACE INTO `zone` VALUES ('1684', '107', '奈良県', 'NR', '1');
REPLACE INTO `zone` VALUES ('1685', '107', '新潟県', 'NI', '1');
REPLACE INTO `zone` VALUES ('1686', '107', '大分県', 'OI', '1');
REPLACE INTO `zone` VALUES ('1687', '107', '岡山県', 'OK', '1');
REPLACE INTO `zone` VALUES ('1688', '107', '沖縄県', 'ON', '1');
REPLACE INTO `zone` VALUES ('1689', '107', '大阪府', 'OS', '1');
REPLACE INTO `zone` VALUES ('1690', '107', '佐賀県', 'SA', '1');
REPLACE INTO `zone` VALUES ('1691', '107', '埼玉県', 'SI', '1');
REPLACE INTO `zone` VALUES ('1692', '107', '滋賀県', 'SH', '1');
REPLACE INTO `zone` VALUES ('1693', '107', '島根県', 'SM', '1');
REPLACE INTO `zone` VALUES ('1694', '107', '静岡県', 'SZ', '1');
REPLACE INTO `zone` VALUES ('1695', '107', '栃木県', 'TO', '1');
REPLACE INTO `zone` VALUES ('1696', '107', '徳島県', 'TS', '1');
REPLACE INTO `zone` VALUES ('1697', '107', '東京都', 'TK', '1');
REPLACE INTO `zone` VALUES ('1698', '107', '鳥取県', 'TT', '1');
REPLACE INTO `zone` VALUES ('1699', '107', '富山県', 'TY', '1');
REPLACE INTO `zone` VALUES ('1700', '107', '和歌山県', 'WA', '1');
REPLACE INTO `zone` VALUES ('1701', '107', '山形県', 'YA', '1');
REPLACE INTO `zone` VALUES ('1702', '107', '山口県', 'YM', '1');
REPLACE INTO `zone` VALUES ('1703', '107', '山梨県', 'YN', '1');
REPLACE INTO `zone` VALUES ('1933', '125', '澳門半島花地瑪堂區(Our Lady of Fatima Parish)', 'OLF', '1');
REPLACE INTO `zone` VALUES ('1934', '125', '澳門半島聖安多尼堂區(St. Anthony Parish)', 'ANT', '1');
REPLACE INTO `zone` VALUES ('1935', '125', '澳門半島望德堂區(St. Lazarus Parish)', 'LAZ', '1');
REPLACE INTO `zone` VALUES ('1936', '125', '澳門半島大堂區(Cathedral Parish)', 'CAT', '1');
REPLACE INTO `zone` VALUES ('1937', '125', '澳門半島風順堂區(St. Lawrence Parish)', 'LAW', '1');
REPLACE INTO `zone` VALUES ('3135', '206', '彰化縣', 'TW-CHA', '1');
REPLACE INTO `zone` VALUES ('3136', '206', '嘉義縣', 'TW-CYQ', '1');
REPLACE INTO `zone` VALUES ('3137', '206', '新竹市', 'TW-HSZ', '1');
REPLACE INTO `zone` VALUES ('3138', '206', '花蓮縣', 'TW-HUA', '1');
REPLACE INTO `zone` VALUES ('3139', '206', '宜蘭縣', 'TW-ILA', '1');
REPLACE INTO `zone` VALUES ('3140', '206', '高雄縣(舊制)', 'KH', '0');
REPLACE INTO `zone` VALUES ('3141', '206', '金門縣', 'KM', '1');
REPLACE INTO `zone` VALUES ('3142', '206', '連江縣', 'LC', '1');
REPLACE INTO `zone` VALUES ('3143', '206', '苗栗縣', 'TW-MIA', '1');
REPLACE INTO `zone` VALUES ('3144', '206', '南投縣', 'TW-NAN', '1');
REPLACE INTO `zone` VALUES ('3145', '206', '澎湖縣', 'TW-PEN', '1');
REPLACE INTO `zone` VALUES ('3146', '206', '屏東縣', 'TW-PIF', '1');
REPLACE INTO `zone` VALUES ('3147', '206', '台中縣(舊制)', 'TG', '0');
REPLACE INTO `zone` VALUES ('3148', '206', '台南市', 'TW-TNN', '1');
REPLACE INTO `zone` VALUES ('3149', '206', '新北市', 'TW-TPQ', '1');
REPLACE INTO `zone` VALUES ('3150', '206', '台東縣', 'TW-TTT', '1');
REPLACE INTO `zone` VALUES ('3151', '206', '桃園縣', 'TW-TAO', '1');
REPLACE INTO `zone` VALUES ('3152', '206', '雲林縣', 'TW-YUN', '1');
REPLACE INTO `zone` VALUES ('3153', '206', '嘉義市', 'TW-CYI', '1');
REPLACE INTO `zone` VALUES ('3154', '206', '基隆市', 'TW-KEE', '1');
REPLACE INTO `zone` VALUES ('3155', '206', '新竹縣', 'TW-HSQ', '1');
REPLACE INTO `zone` VALUES ('3156', '206', '台中市', 'TW-TXG', '1');
REPLACE INTO `zone` VALUES ('3157', '206', '台南縣(舊制)', 'TN', '0');
REPLACE INTO `zone` VALUES ('3158', '206', '高雄市', 'TW-KHH', '1');
REPLACE INTO `zone` VALUES ('3159', '206', '台北市', 'TW-TPE', '1');
REPLACE INTO `zone` VALUES ('3970', '44', '青海省', 'QH', '1');
REPLACE INTO `zone` VALUES ('3971', '44', '西藏自治區', 'TB', '1');
REPLACE INTO `zone` VALUES ('3972', '125', '氹仔(Taipa)', 'TP', '1');
REPLACE INTO `zone` VALUES ('3973', '125', '路環(Coloane)', 'CO', '1');
REPLACE INTO `zone` VALUES ('3974', '125', '路氹城(Cotai)', 'CT', '1');
REPLACE INTO `zone` VALUES ('3975', '240', 'Andrijevica', 'ME-01', '1');
REPLACE INTO `zone` VALUES ('3976', '240', 'Bar', 'ME-02', '1');
REPLACE INTO `zone` VALUES ('3977', '240', 'Berane', 'ME-03', '1');
REPLACE INTO `zone` VALUES ('3978', '240', 'Bijelo Polje', 'ME-04', '1');
REPLACE INTO `zone` VALUES ('3979', '240', 'Budva', 'ME-05', '1');
REPLACE INTO `zone` VALUES ('3980', '240', 'Cetinje', 'ME-06', '1');
REPLACE INTO `zone` VALUES ('3981', '240', 'Danilovgrad', 'ME-07', '1');
REPLACE INTO `zone` VALUES ('3982', '240', 'Herceg-Novi', 'ME-08', '1');
REPLACE INTO `zone` VALUES ('3983', '240', 'Kolašin', 'ME-09', '1');
REPLACE INTO `zone` VALUES ('3984', '240', 'Kotor', 'ME-10', '1');
REPLACE INTO `zone` VALUES ('3985', '240', 'Mojkovac', 'ME-11', '1');
REPLACE INTO `zone` VALUES ('3986', '240', 'Nikšić', 'ME-12', '1');
REPLACE INTO `zone` VALUES ('3987', '240', 'Plav', 'ME-13', '1');
REPLACE INTO `zone` VALUES ('3988', '240', 'Pljevlja', 'ME-14', '1');
REPLACE INTO `zone` VALUES ('3989', '240', 'Plužine', 'ME-15', '1');
REPLACE INTO `zone` VALUES ('3990', '240', 'Podgorica', 'ME-16', '1');
REPLACE INTO `zone` VALUES ('3991', '240', 'Rožaje', 'ME-17', '1');
REPLACE INTO `zone` VALUES ('3992', '240', 'Šavnik', 'ME-18', '1');
REPLACE INTO `zone` VALUES ('3993', '240', 'Tivat', 'ME-19', '1');
REPLACE INTO `zone` VALUES ('3994', '240', 'Ulcinj', 'ME-20', '1');
REPLACE INTO `zone` VALUES ('3995', '240', 'Žabljak', 'ME-21', '1');
REPLACE INTO `zone` VALUES ('3998', '241', 'Beograd', 'RS-00', '1');
REPLACE INTO `zone` VALUES ('3999', '241', 'Borski okrug', 'RS-14', '1');
REPLACE INTO `zone` VALUES ('4000', '241', 'Braničevski okrug', 'RS-11', '1');
REPLACE INTO `zone` VALUES ('4001', '241', 'Jablanički okrug', 'RS-23', '1');
REPLACE INTO `zone` VALUES ('4002', '241', 'Južnobački okrug', 'RS-06', '1');
REPLACE INTO `zone` VALUES ('4003', '241', 'Južnobanatski okrug', 'RS-04', '1');
REPLACE INTO `zone` VALUES ('4004', '241', 'Kolubarski okrug', 'RS-09', '1');
REPLACE INTO `zone` VALUES ('4005', '241', 'Kosovski okrug', 'RS-25', '1');
REPLACE INTO `zone` VALUES ('4006', '241', 'Kosovsko-Mitrovački okrug', 'RS-28', '1');
REPLACE INTO `zone` VALUES ('4007', '241', 'Kosovsko-Pomoravski okrug', 'RS-29', '1');
REPLACE INTO `zone` VALUES ('4008', '241', 'Mačvanski okrug', 'RS-08', '1');
REPLACE INTO `zone` VALUES ('4009', '241', 'Moravički okrug', 'RS-17', '1');
REPLACE INTO `zone` VALUES ('4010', '241', 'Nišavski okrug', 'RS-20', '1');
REPLACE INTO `zone` VALUES ('4011', '241', 'Pčinjski okrug', 'RS-24', '1');
REPLACE INTO `zone` VALUES ('4012', '241', 'Pećki okrug', 'RS-26', '1');
REPLACE INTO `zone` VALUES ('4013', '241', 'Pirotski okrug', 'RS-22', '1');
REPLACE INTO `zone` VALUES ('4014', '241', 'Podunavski okrug', 'RS-10', '1');
REPLACE INTO `zone` VALUES ('4015', '241', 'Pomoravski okrug', 'RS-13', '1');
REPLACE INTO `zone` VALUES ('4016', '241', 'Prizrenski okrug', 'RS-27', '1');
REPLACE INTO `zone` VALUES ('4017', '241', 'Rasinski okrug', 'RS-19', '1');
REPLACE INTO `zone` VALUES ('4018', '241', 'Raški okrug', 'RS-18', '1');
REPLACE INTO `zone` VALUES ('4019', '241', 'Severnobački okrug', 'RS-01', '1');
REPLACE INTO `zone` VALUES ('4020', '241', 'Severnobanatski okrug', 'RS-03', '1');
REPLACE INTO `zone` VALUES ('4021', '241', 'Srednjebanatski okrug', 'RS-02', '1');
REPLACE INTO `zone` VALUES ('4022', '241', 'Sremski okrug', 'RS-07', '1');
REPLACE INTO `zone` VALUES ('4023', '241', 'Šumadijski okrug', 'RS-12', '1');
REPLACE INTO `zone` VALUES ('4024', '241', 'Toplički okrug', 'RS-21', '1');
REPLACE INTO `zone` VALUES ('4025', '241', 'Zaječarski okrug', 'RS-15', '1');
REPLACE INTO `zone` VALUES ('4026', '241', 'Zapadnobački okrug', 'RS-05', '1');
REPLACE INTO `zone` VALUES ('4027', '241', 'Zlatiborski okrug', 'RS-16', '1');
REPLACE INTO `zone` VALUES ('4028', '242', 'Central Equatoria', 'SS-EC', '1');
REPLACE INTO `zone` VALUES ('4029', '242', 'Eastern Equatoria', 'SS-EE', '1');
REPLACE INTO `zone` VALUES ('4030', '242', 'Jonglei', 'SS-JG', '1');
REPLACE INTO `zone` VALUES ('4031', '242', 'Lakes', 'SS-LK', '1');
REPLACE INTO `zone` VALUES ('4032', '242', 'Northern Bahr el-Ghazal', 'SS-BN', '1');
REPLACE INTO `zone` VALUES ('4033', '242', 'Unity', 'SS-UY', '1');
REPLACE INTO `zone` VALUES ('4034', '242', 'Upper Nile', 'SS-NU', '1');
REPLACE INTO `zone` VALUES ('4035', '242', 'Warrap', 'SS-WR', '1');
REPLACE INTO `zone` VALUES ('4036', '242', 'Western Bahr el-Ghazal', 'SS-BW', '1');
REPLACE INTO `zone` VALUES ('4037', '242', 'Western Equatoria', 'SS-EW', '1');
執行後，資料表zone的值將會被取代
然後進行國家資料值得修改:
REPLACE INTO `country` VALUES ('242', 'Republic of South Sudan', 'SS', 'SSD', '', '0', '1');
REPLACE INTO `country` VALUES ('241', 'Republic of Serbia', 'RS', 'SRB', '', '0', '1');
REPLACE INTO `country` VALUES ('240', 'Montenegro', 'ME', 'MNE', '', '0', '1');
REPLACE INTO `country` VALUES ('206', '台灣', 'TW', 'TWN', '', '0', '1');
REPLACE INTO `country` VALUES ('125', '中國澳門(Macau, China)', 'MO', 'MAC', '', '0', '1');
REPLACE INTO `country` VALUES ('107', '日本国', 'JP', 'JPN', '', '0', '1');
REPLACE INTO `country` VALUES ('96', '中國香港(Hong Kong, China)', 'HK', 'HKG', '', '0', '1');
REPLACE INTO `country` VALUES ('44', '中华人民共和国', 'CN', 'CHN', '', '0', '1');
一樣執行後，資料表country的值就會被修改成新的
資料修改後，必須進入後台進行更新資料，只需要進入 [系統設定] > [參數設定] > [國家設定] ，隨便選一個點選[編輯]，進入編輯畫面按儲存即可。
同樣的動作也要在地區參數進行，即 [系統設定] > [參數設定] > [國家地區] ，一樣隨便選一個然後按[編輯]，進入編輯畫面後按儲存即可。
