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.