Change Theme, Language, Currerncy in Database – Opencart |

Congrats, You are Subscribed to Receive Updates.

Change Theme, Language, Currerncy in Database – Opencart

Sometimes, opencart admin setting is not working properly. It may be a script error or conflicting in nature. So when we want to change the theme or lanuguage or currency. It can’t possible from the admin panel .So here I am going to give you the easy method of changing default theme, language, currency by accessing database. Even you can change the store details, such as store title, meta description, keyword, and owner name and contact details too.

The first step is to open your cpanel and get your database access and get the listed database tables, Than open your ” oc_settings” . Here “oc_” your table prefix, it may be varied.  Now you need to find the following details and change it as like the image.



config_template      –    is your current theme name, just change it with your new one. It  must the folder name of your new theme directory

config_language     –    is your language, you need to change the language name here you can enter the language shortcode to enable the next language” default- en”   – This is for front end.

config_admin_language – This is for your back end ( admin panel).

config_currency    –  USD  is your store currency, you need to enter the currency code in Caps, than you need to specify the “config_currency_auto”.


config_title, config_meta_description, keywords, are the store details, you can change it here.


That’s it to change the opencart setting from your database,


About Varadharaj V

The founder of Kvcodes, Varadharaj V is an ERP Analyst and a Web developer specializing in WordPress(WP), WP Theme development, WP Plugin development, Frontaccounting(FA), Sales, Purchases, Inventory, Ledgers, Payroll & HRM, CRM, FA Core Customization, PHP and Data Analyst. Database Management Advance Level

Comment Below

Your email address will not be published. Required fields are marked *


Current ye@r *