# How to change default language in shopware6 from backend?

**URL:** https://forum.shopware.com/t/how-to-change-default-language-in-shopware6-from-backend/64220
**Category:** Programming (EN)
**Created:** [24. Januar 2020 um 10:02 UTC](https://forum.shopware.com/t/how-to-change-default-language-in-shopware6-from-backend/64220 "2020-01-24T10:02:54Z")
**Posts on this page:** 1
**Showing post:** 7

<div class="post-metadata">

### Author: ![pait](https://avatars.discourse-cdn.com/v4/letter/p/9fc348/32.png) [@pait](https://forum.shopware.com/u/pait)
#### Post date: [18. November 2020 um 13:19 UTC](https://forum.shopware.com/t/how-to-change-default-language-in-shopware6-from-backend/64220/7 "2020-11-18T13:19:39Z")

</div>

Hey guys! I had the same problem and i finally found a solution without touching the code!

The id of the default language is the same since the start of shopware 6 (2fbb5fe2e29a4d70aa5854ce7ce3e20b) and the db contains foreign-key-references with “on update cascade” for every reference on language\_id (language-table). I just updated the id of the english language in the language-table to a new random uuid and afterwards updated the id of the german language to 2fbb5fe2e29a4d70aa5854ce7ce3e20b (see code below).

```
mysql --user={{ sw_db_user }} --password={{ sw_db_user_password }}
    {{ sw_database_name }} --host={{ sw_database_host }} --batch --skip-column-names
    --execute="
    UPDATE language SET id = UNHEX(REPLACE(UUID(), '-','')) WHERE name='English';
    UPDATE language SET id = UNHEX('2FBB5FE2E29A4D70AA5854CE7CE3E20B') WHERE name='Deutsch';"

```

I did this shortly after setting up the db with the command **_bin/console system:install --create-database --basic-setup_** and before building the application for the first time. I also did the following the make it working as expected:

- changed the default language for the admin-user to german

- &nbsp;changed the default language, currency AND snippet-set for all SalesChannel-Domains

- changed the default language, currency and country for all SalesChannels

Afterwards you only have to give your storefront-channel a new name (german) because the db-setup-process only inserts a translation for english.

The parent\_id-field in the language-table is NULL for all entries (german and english)

---

_[View the full topic](https://forum.shopware.com/t/how-to-change-default-language-in-shopware6-from-backend/64220)._