eCom recognizes only English system column titles. To ensure Lightspeed eCom can map each column to a field automatically, do not translate the system column name. For example, a Dutch user's product worksheet should contain
XX_Title_Short in English, even though they have a Dutch interface.
To import translations for multiple languages, make sure to add to them to the eCom Back Office first. You can add languages by going to your eCom Back Office > Settings > Store Country.
Inside each section of this article, found by clicking the buttons at the top of the page, you will find column titles that contain XX, like this:
XX_Title_Short. These column titles have placeholder for their language abbreviation represented here as XX. When creating your data file, use this Language table to add the correct abbreviation for your translated columns.
These product columns support multiple translations using language codes.
- Full title
- Variant title
- Category titles
- Meta title
- Meta description
- Meta keywords
An export with a title in English (UK) will have EN_ written before Title_Short to indicate it's language, like: EN_Title_Short. Likewise, a Dutch title would be: NL_Title_Short.
|Language||How the language is displayed in eCom||How the language is abbreviated in exports|
|09||English (US)||English (US)||US|
|10||French (CA)||Français (CA)||FC|
Setup languages before importing
Configure languages before importing by logging into your eCom Back Office and click Settings > Store Country.