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,