發佈於

OPENCART 3.0.1.2 版中文化修正

//***********************************************************************************************//
中文化操作
//***********************************************************************************************//
選擇: [System] > [Localisation] > [Languages] > [Insert]

填入如下資料:

Language Name: 正體中文
Code: zh-TW
Locale: zh-TW,zh_TW.UTF-8,zh_TW,zh-tw,chinese
Status: Enabled
Sort Order: (建議輸入 2)

填好點擊 [Save] 儲存
—————————————————————

3. 把中文語系設置為預設語系。

選擇: [System] > [Settings] > [(Store) Edit] > [Local]

找到以下項目,都設定為 [正體中文]

前台語言Language: 正體中文
後台語言Administration Language: 正體中文

填好點擊 [Save] 儲存,儲存後後台介面將立即切換為正體中文。
//***********************************************************************************************//

#繁體中文修正
TRUNCATE `oc_language`;
INSERT INTO `oc_language` (`language_id`, `name`, `code`, `locale`, `image`, `directory`, `sort_order`, `status`) VALUES
(1, ‘繁體中文’, ‘zh-TW’, ‘zh-TW,zh_TW.UTF-8,zh_TW,zh-tw,chinese’, ‘zh-TW.png’, ‘zh-TW’, 1, 1);

#雙語的話
(1, ‘English’, ‘en-gb’, ‘en-US,en_US.UTF-8,en_US,en-gb,english’, ‘gb.png’, ‘english’, 1, 1);
(2, ‘正體中文’, ‘zh-TW’, ‘zh-TW,zh_TW.UTF-8,zh_TW,zh-tw,chinese’, ‘zh-TW.png’, ‘zh-TW’, 2, 1);

#前後台語言預設為1

//***********************************************************************************************//
#缺貨狀態名稱修正
TRUNCATE `oc_stock_status`;
INSERT INTO `oc_stock_status` (`stock_status_id`, `language_id`, `name`) VALUES
(7, 1, ‘有貨’),
(8, 1, ‘預購’),
(5, 1, ‘缺貨’),
(6, 1, ‘等待2 – 3天’);

TRUNCATE `oc_return_reason`;
INSERT INTO `oc_return_reason` (`return_reason_id`, `language_id`, `name`) VALUES
(1, 1, ‘商品運送途中已毀損’),
(2, 1, ‘商品不符’),
(3, 1, ‘訂單有錯誤’),
(4, 1, ‘故障, 請詳述’),
(5, 1, ‘其它, 請詳述’);

TRUNCATE `oc_return_status`;
INSERT INTO `oc_return_status` (`return_status_id`, `language_id`, `name`) VALUES
(1, 1, ‘待處理’),
(3, 1, ‘完成’),
(2, 1, ‘等待商品到貨’);

TRUNCATE `oc_return_action`;
INSERT INTO `oc_return_action` (`return_action_id`, `language_id`, `name`) VALUES
(1, 1, ‘退款’),
(2, 1, ‘退款至信用帳戶’),
(3, 1, ‘更換商品’);

#節日名稱修正
TRUNCATE `oc_voucher_theme_description`;
INSERT INTO `oc_voucher_theme_description` (`voucher_theme_id`, `language_id`, `name`) VALUES
(6, 1, ‘聖誕節’),
(7, 1, ‘生日’),
(8, 1, ‘基本’);

#尺寸名稱修正
TRUNCATE `oc_length_class_description`;
INSERT INTO `oc_length_class_description` (`length_class_id`, `language_id`, `title`, `unit`) VALUES
(1, 1, ‘公分’, ‘cm’),
(2, 1, ‘公厘’, ‘mm’),
(3, 1, ‘英吋’, ‘in’);

#重量名稱修正
TRUNCATE `oc_weight_class_description`;
INSERT INTO `oc_weight_class_description` (`weight_class_id`, `language_id`, `title`, `unit`) VALUES
(1, 1, ‘公斤’, ‘kg’),
(2, 1, ‘公克’, ‘g’),
(5, 1, ‘磅 ‘, ‘lb’),
(6, 1, ‘盎司’, ‘oz’);

#錢幣修正
TRUNCATE `oc_currency`;
INSERT INTO `oc_currency` (`currency_id`, `title`, `code`, `symbol_left`, `symbol_right`, `decimal_place`, `value`, `status`, `date_modified`) VALUES
(1, ‘新台幣’, ‘TWD’, ‘NT’, ”, ‘0’, 1.00000000, 1, ‘2017-07-13 12:13:16’),
(2, ‘人民幣’, ‘CNY’, ‘¥’, ”, ‘2’, 0.22229999, 1, ‘2017-07-12 16:24:23’),
(3, ‘港幣’, ‘HKD’, ‘HK’, ”, ‘2’, 0.25590000, 1, ‘2017-07-12 16:24:23’),
(4, ‘英鎊’, ‘GBP’, ‘£’, ”, ‘2’, 0.02560000, 1, ‘2017-07-12 16:24:23’),
(5, ‘美元’, ‘USD’, ‘$’, ”, ‘2’, 0.03280000, 1, ‘2017-07-12 16:24:23’),
(6, ‘歐元’, ‘EUR’, ”, ‘€’, ‘2’, 0.02870000, 1, ‘2017-07-12 16:24:23’);

#幣別預設

#商店資訊修正
TRUNCATE `oc_information_description`;
INSERT INTO `oc_information_description` (`information_id`, `language_id`, `title`, `description`, `meta_title`, `meta_description`, `meta_keyword`) VALUES
(4, 1, ‘關於我們’, ‘<p>\r\n 關於我們</p>\r\n’, ‘關於我們’, ”, ”),
(5, 1, ‘政策 & 條款’, ‘<p>\r\n 政策 & 條款</p>\r\n’, ‘政策 & 條款’, ”, ”),
(3, 1, ‘隱私權聲明’, ‘<p>\r\n 隱私權聲明</p>\r\n’, ‘隱私權聲明’, ”, ”),
(6, 1, ‘配送說明’, ‘<p>\r\n 配送說明</p>\r\n’, ‘配送說明’, ”, ”);

#模板名稱修正
TRUNCATE `oc_layout`;
INSERT INTO `oc_layout` (`layout_id`, `name`) VALUES
(1, ‘首頁(Home)’),
(2, ‘商品(Product)’),
(3, ‘目錄(Category)’),
(4, ‘預設(Default)’),
(5, ‘品牌(Manufacturer)’),
(6, ‘帳戶(Account)’),
(7, ‘結帳(Checkout)’),
(8, ‘聯絡(Contact)’),
(9, ‘網站導覽(Sitemap)’),
(10, ‘推薦帳戶(Affiliate)’),
(11, ‘商店訊息(Information)’),
(12, ‘商品比較(Compare)’),
(13, ‘商品搜尋(Search)’);

UPDATE `oc_layout` SET `name` = ‘快速結帳Quick Checkout’ WHERE `oc_layout`.`name` = ‘Quick Checkout’;

#訂單狀態
#SELECT * FROM `oc_order_status` 保留原版 16狀態
#修改 注意 狀態3 已出貨 和狀態5 已完成交易 不能更動名稱
TRUNCATE oc_order_status;
INSERT INTO `oc_order_status` (`order_status_id`, `language_id`, `name`) VALUES
(1, 1, ‘待處理’),
(2, 1, ‘訂單處理中’),
(3, 1, ‘已出貨 ‘),
(4, 1, ‘到店取貨–等待中’),
(5, 1, ‘已完成交易’),
(6, 1, ‘貨到付款–處理中’),
(7, 1, ‘已取消’),
(8, 1, ‘已拒絕’),
(9, 1, ‘取消恢復’),
(10, 1, ‘失敗’),
(11, 1, ‘已返還’),
(12, 1, ‘退款處理中…’),
(13, 1, ‘已退款’),
(14, 1, ‘已過期’),
(15, 1, ‘已處理’),
(16, 1, ‘空訂單’),
(17, 1, ‘ATM轉帳–請匯款’);

//***********************************************************************************************//
#國家修正
UPDATE `oc_country` SET `name` = ‘台灣’ WHERE `oc_country`.`country_id` = 206;

#`oc_geo_zone` 原本有2筆資料
#(3, ‘UK VAT Zone’, ‘UK VAT’, ‘2009-01-06 23:26:25’, ‘2010-02-26 22:33:24’),
#(4, ‘UK Shipping’, ‘UK Shipping Zones’, ‘2009-06-23 01:14:53’, ‘2010-12-15 15:18:13’);
TRUNCATE `oc_geo_zone`;
INSERT INTO `oc_geo_zone` (`geo_zone_id`, `name`, `description`, `date_modified`, `date_added`) VALUES
(1, ‘台灣本島’, ‘台灣本島’, ‘2016-01-26 15:39:54’, ‘2015-09-22 23:13:56’),
(2, ‘離島地區’, ‘澎湖金門離島地區’, ‘2016-01-26 15:40:49’, ‘2016-11-07 23:13:56’),
(3, ‘中國大陸’, ‘中華人民共和國’, ‘2016-11-07 23:05:47’, ‘2016-01-26 16:16:44’),
(4, ‘香港區’, ‘香港自治區’, ‘2016-11-07 23:09:55’, ‘2016-11-07 23:06:38’);

#地區修正3135~3159 舊中文版 3135~3156
#全台灣有22個縣市 英文版卻說我們有26個縣市
#先刪除再新增
DELETE FROM `oc_zone` WHERE `country_id` = 206;
INSERT INTO `oc_zone` (`zone_id`, `country_id`, `name`, `code`, `status`) VALUES
(3135, 206, ‘台北市’, ‘TPC’, 1),
(3136, 206, ‘基隆市’, ‘KLC’, 1),
(3137, 206, ‘新北市’, ‘NPC’, 1);
(3138, 206, ‘宜蘭縣’, ‘YL’, 1),
(3139, 206, ‘新竹市’, ‘HCC’, 1),
(3140, 206, ‘新竹縣’, ‘HC’, 1),
(3141, 206, ‘桃園市’, ‘TYC’, 1),
(3142, 206, ‘苗栗縣’, ‘ML’, 1),
(3143, 206, ‘台中市’, ‘TCC’, 1),
(3144, 206, ‘彰化縣’, ‘CH’, 1),
(3145, 206, ‘南投縣’, ‘NT’, 1),
(3146, 206, ‘嘉義市’, ‘CYC’, 1),
(3147, 206, ‘嘉義縣’, ‘CY’, 1),
(3148, 206, ‘雲林縣’, ‘YLI’, 1),
(3149, 206, ‘台南市’, ‘TNC’, 1),
(3150, 206, ‘高雄市’, ‘KHC’, 1),
(3151, 206, ‘澎湖縣’, ‘PH’, 1),
(3152, 206, ‘屏東縣’, ‘PT’, 1),
(3153, 206, ‘台東縣’, ‘TT’, 1),
(3154, 206, ‘花蓮縣’, ‘HL’, 1),
(3155, 206, ‘金門縣’, ‘KM’, 1),
(3156, 206, ‘連江縣’, ‘LC’, 1);
SELECT * FROM `oc_zone` WHERE `country_id` = 206

/*****************************************************************************************/
英文版卻有 25個
(3135, 206, ‘Chang-hua’, ‘CH’, 1),
(3136, 206, ‘Chia-i’, ‘CI’, 1);
(3137, 206, ‘Hsin-chu’, ‘HS’, 1),
(3138, 206, ‘Hua-lien’, ‘HL’, 1),
(3139, 206, ‘I-lan’, ‘IL’, 1),
(3140, 206, ‘Kao-hsiung county’, ‘KH’, 1),
(3141, 206, ‘Kin-men’, ‘KM’, 1),
(3142, 206, ‘Lien-chiang’, ‘LC’, 1),
(3143, 206, ‘Miao-li’, ‘ML’, 1),
(3144, 206, ‘Nan-t\’ou’, ‘NT’, 1),
(3145, 206, ‘P\’eng-hu’, ‘PH’, 1),
(3146, 206, ‘P\’ing-tung’, ‘PT’, 1),
(3147, 206, ‘T\’ai-chung’, ‘TG’, 1),
(3148, 206, ‘T\’ai-nan’, ‘TA’, 1),
(3149, 206, ‘T\’ai-pei county’, ‘TP’, 1),
(3150, 206, ‘T\’ai-tung’, ‘TT’, 1),
(3151, 206, ‘T\’ao-yuan’, ‘TY’, 1),
(3152, 206, ‘Yun-lin’, ‘YL’, 1),
(3153, 206, ‘Chia-i city’, ‘CC’, 1),
(3154, 206, ‘Chi-lung’, ‘CL’, 1),
(3155, 206, ‘Hsin-chu’, ‘HC’, 1),
(3156, 206, ‘T\’ai-chung’, ‘TH’, 1),
(3157, 206, ‘T\’ai-nan’, ‘TN’, 1),
(3158, 206, ‘Kao-hsiung city’, ‘KC’, 1),
(3159, 206, ‘T\’ai-pei city’, ‘TC’, 1),
英文版卻有 25個 非常神奇
3135 Chang-hua
3154 Chi-lung
3136 Chia-i
3153 Chia-i city
3137 Hsin-chu
3155 Hsin-chu
3138 Hua-lien
3139 I-lan
3158 Kao-hsiung city
3140 Kao-hsiung county
3141 Kin-men
3142 Lien-chiang
3143 Miao-li
3144 Nan-t’ou
3145 P’eng-hu
3146 P’ing-tung
3147 T’ai-chung
3156 T’ai-chung
3148 T’ai-nan
3157 T’ai-nan
3159 T’ai-pei city
3149 T’ai-pei county
3150 T’ai-tung
3151 T’ao-yuan
3152 Yun-lin 雲林
/*****************************************/
好奇多了哪3個
2010年12月25日,直轄市高雄市與臺灣省高雄縣合併為一新直轄市,仍名為「高雄市」
臺中縣市合併改制為臺中市。
臺南縣市合併改制為臺南市。
高雄縣市合併改制為高雄市。
/*****************************************/
#英文版卻有 25個
#先刪除再新增
DELETE FROM `oc_zone` WHERE `country_id` = 206;
INSERT INTO `oc_zone` (`zone_id`, `country_id`, `name`, `code`, `status`) VALUES
(3135, 206, ‘彰化縣’, ‘CH’, 1),
(3136, 206, ‘嘉義縣’, ‘CI’, 1),
(3137, 206, ‘新竹縣’, ‘HS’, 1),
(3138, 206, ‘花蓮縣’, ‘HL’, 1),
(3139, 206, ‘宜蘭縣’, ‘IL’, 1),
(3140, 206, ‘高雄縣’, ‘KH’, 0),
(3141, 206, ‘金門縣’, ‘KM’, 1),
(3142, 206, ‘連江縣’, ‘LC’, 1),
(3143, 206, ‘苗栗縣’, ‘ML’, 1),
(3144, 206, ‘南投縣’, ‘NT’, 1),
(3145, 206, ‘澎湖縣’, ‘PH’, 1),
(3146, 206, ‘屏東縣’, ‘PT’, 1),
(3147, 206, ‘臺中縣’, ‘TG’, 0),
(3148, 206, ‘臺南縣’, ‘TA’, 0),
(3149, 206, ‘新北市’, ‘TP’, 1),
(3150, 206, ‘台東縣’, ‘TT’, 1),
(3151, 206, ‘桃園市’, ‘TY’, 1),
(3152, 206, ‘雲林縣’, ‘YL’, 1),
(3153, 206, ‘嘉義市’, ‘CC’, 1),
(3154, 206, ‘基隆市’, ‘CL’, 1),
(3155, 206, ‘新竹市’, ‘HC’, 1),
(3156, 206, ‘台中市’, ‘TCC’, 1),
(3157, 206, ‘台南市’, ‘TNC’, 1),
(3158, 206, ‘高雄市’, ‘KHC’, 1),
(3159, 206, ‘台北市’, ‘TPC’, 1);

OPENCART 3.0.1.2 版中文化修正” 有 2 則迴響

  1. 請問一下,我想要實現鄉鎮市區的選單。如果將原本的地區(台灣本島、離島地區、香港…)改成縣市(台北市、新北市…);而將原本的縣市改成鄉鎮市區(中正區、萬華區…)可行嗎?會不會出現什麼問題?還是您有更好的建議?謝謝~

    1. 那是會動到資料庫的修改,請別自行嘗試

發表迴響

你的電子郵件位址並不會被公開。 必要欄位標記為 *