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.

Example 1

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.

• 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 it's language, like: EN_Title_Short. Likewise, a Dutch title would be: NL_Title_Short.

Language table