W_LANGUAGES_G Initialization

The W_LANGUAGES_G table controls all the languages supported in the translatable database data. This applies to areas such as product names, location names, attribute values, season/phase descriptions, and other text-based descriptors. Additional languages are used mainly by Retail Insights, which supports displaying data in multiple languages in reporting and analytics. It is required to delete all languages from this table that will not be used because every language code in this table will have records generated for it in some interfaces, creating unnecessary data that can impact system performance. Starting with version 23.1.201.0, new environments will only be created with the ‘US’ language code in place; but if you are on an earlier version then you must manually delete all other entries that will not be used.

For example, product names will automatically have database records initialized for every supported language in this configuration table, even if the data you are providing does not contain any of those languages. This creates significant amounts of data in your product descriptions table, which may not serve any real purpose for your implementation. If you are only using a single primary language, then you can safely delete all but one row from W_LANGUAGES_G. The default row to preserve is the one with a language code of US which is used for American English.