Install Sana Commerce Webshop on Web and Database Server

Configure Languages

Sana Commerce also supports multi-language per website. This can be configured in the 'Languages' and 'WebsiteLanguages' tables of the Sana Commerce SQL database. Out of the box, Sana Commerce comes with two languages: Dutch and English. These languages are specified in the 'Languages' table:

 
The 'Languages' Table
 

ID	The Windows Code Page Id of the Language
DisplayName:	The name of the language that will be shown in the 'Language' dropdown in the frontend.
IsDefault:	A Boolean value indicating if the language is used as the default language in the backoffice.

In order to add languages for a website:

Step 1: Open the 'Languages' table and add the language ID and name. The list of the Windows language IDs can be found here.

Step 2: Open the 'WebsiteLanguages' table and add the extra records here:

 
The 'WebsiteLanguages' Table 

When the languages are in place in the 'WebsiteLanguages' table, you add the relations between the websites and the languages. To specify the default language for the frontend, open the 'Websites' table again and set the 'LanguageId' of the default language in the 'defaultLanguageId' field.

General configuration of the frontend languages is done in the Sana Commerce backoffice. Please follow this link for more information.

When the language is added you can also edit language-specific Sana texts using frontend editor. More detailed information can be found here.