The eCom import only recognizes English column titles. In order for Lightspeed eCom to automatically map each column to a field, do not translate the column name. For example, a Dutch user's import file must contain XX_Title_Short English, even though he has a Dutch interface.

To import translations for multiple languages, you must first add them to the eCom Back Office. You can add languages in the eCom Back Office > Settings > Internationalization.

Example 1

In each section of this article, you'll find column titles that contain XX, like this: XX_Title_Short. Here the abbreviation XX stands for the language abbreviation. Use this language table to add the correct abbreviation for your translated columns when creating your import file.

These product columns support multiple translations using language codes.

Title
Full title
Description
content
URL
Variant title
Category titles
Meta title
Meta description
Meta keywords

Example 2

An export with a title in English (UK) will have EN_ written before Title_Short to indicate its language, such as: EN_Title_Short. Also a Dutch title: NL_Title_Short.

Language table

	Language	How the language is displayed in eCom	How the language is abbreviated in the export
01		X-taal	XX
02	Dutch	Nederlands	NL
03	German	Deutsch	DE
04	English (UK)	English	EN
05	French (FR)	Français	FR
06	Spanish	Español	EN
07	Italian	Italiano	IT
08	Danish	Dansk	DA
09	English (US)	English (US)	US
10	French (CA)	Français (CA)	FC
11	Norwegian	Norsk	NO
12	Polish	Polski	PL
13	Portuguese	Português	PT
14	Russian	Pусский	RU
15	Swedish	Svenska	SV
16	Turkish	Türkçe	TR
17	Greek	ελληνικά	EL
18	Bulgarian	Български	BG

Set languages for import

Configure languages before importing by logging into your eCom Back Office and clicking Settings > Internationalization.