Data Translation

In this article

Initial Configuration

Translate Item Description and Item HTML

Translate Item Variants

Translate Attributes

Translate Attribute Names in XML table

Translate Extended Text to Item Description

eCommerce - Shopify provides a feature to sync data translation from LS Central to Shopify for products, variants, and attributes values.

This feature lets you ensure consistency in product details by synchronizing translated names, descriptions, and other relevant data across Shopify and LS Central.

Initial Configuration

  1. Before you sync data translation to Shopify, you must configure Data Translation Setup to set up tables and fields to be translated.

    For Variant values, add table fields 5401 and 10001412/13 as shown in the image. For Options (Attribute Meta Data) add table 10000785.

  2. Click the Languages action, select your preferred language code from the list, and fill in the table.

  3. Go to the Shopify Administration page, and click Related - Mapping - Locale.

  4. You are redirect to the Locale Mapping card. To configure the locale mapping, go to Actions > Get Locale. Once the locale code is retrieved, select the appropriate Language Code from the drop-down. This step is simplified as the language codes were already configured in the Data Translation Setup earlier.

  5. Next, to customize the language switcher in the Shopify online store, navigate to Online Store > Themes, then click Customize on the active theme.

  6. Navigate to the App embeds section, located at the bottom of the left sidebar. If not installed, download the T Lab – AI Language Translate app from the Shopify App Store.

  7. Then, enable the Language Switcher extension (from T Lab) under the App embeds section. Position it at the bottom-left corner of your storefront.

    Note: Once enabled, the language switcher appears on your online store, allowing customers to select their preferred language.

Translate Item Description and Item HTML

  1. Go to the Data Translation Setup page, click the three dots in the Actions menu, and then click Run Table Viewer. In the Dyn. Table Viewer page, click the Data Translation action.

  2. In the Data Translation Link page, click Description and Item Category Code. In the Language Code field, select ISL, and type the translation of the text:

  3. Go to the Retail Item List, click Related - Master Data - Item HTML. In the Item HTML card, select your preferred language in the Language Code field, and type the text to be translated in the HTML section.

  4. Go to he Shopify Administration page, click Related - Mapping - Locale. In the Locale Mapping card, click Action - Send Translations. This action sends the translation to Shopify.

    Note: Make sure to select the correct language before you click the Send Translation option. In this example, ISL is selected in the Item HTML and Data Translation Link cards.

  5. Go to Shopify, and navigate to Products. Select Blue Cheese from the list, and click More Actions - Localize.

  6. The translated texts are displayed in Shopify as shown below, before they are published to the online store.

After publishing to the online store, Blue Cheese is translated as shown below when the customer switches the language from English to Icelandic.

Translate Item Variants

  1. Start with Variant Dimension, go to the Data Translation Setup page, click the three dots in the Action menu, and select Run Table Viewer.
  2. In the Dyn. Table Viewer page, select WOMEN;;COLOUR and WOMEN;;SIZE, and click the Data Translation action. Select the color line first, then the size line.

  3. In the Data Translation Link card, click Description. In the Language Code field, select ISL, and type the translation:

  4. Continue with Variant Value, and follow the steps above. Here you select WOMEN;;COLOUR;;BLUE & CREAM.

  5. In the Data Translation Link card, select Value Description. Select ISL, and type the translation:

  6. Go to the Shopify Administration page, and click Related - Mapping - Locale.

    In the Locale Mapping section, click Action - Send Translation to send the translation to Shopify.

  7. Go to Shopify, and navigate to Products. Select Jeans Shirt Linda Line from the list, and click More Actions - Localize. The translation is displayed in Shopify as shown below before publishing to the online store.

After publishing to the online store, the Jeans Shirt Linda Line is translated as shown below when the customer switches the language from English to Icelandic.

Translate Attributes

  1. Go to the Data Translation Setup page. Select the Attribute option value, and click the three dots In the Action menu, and then click Run Table Viewer.
  2. In the Dyn. Table Viewer page, click the Data Translation action.

  3. In the Data Translation Link card, select Option Value. In the Language Code field, select ISL and type the translation:

  4. Repeat these steps for other attribute option values as shown in the example below.

  5. Go to the Shopify Administration page, and click Related - Mapping - Locale.

    In the Locale Mapping section, click Actions - Send Translations to send the translation to Shopify.

  6. Go to Shopify, and navigate to Products. Select Linda casual dress from the list, and click More Actions - Localize.

  7. Go to Shopify, and navigate to Products. Select Linda casual dress from the list, and click More Actions - Localize. The translation is displayed in Shopify as shown below before publishing to the online store.

After publishing to the online store, the Linda casual dress is translated when the customer switches the language from English to Icelandic.

Translate Attribute Names in XML table

  1. Go to the Data Translation Setup page. Select Extended Variant Values, click the three dots in the Action menu, and select Run Table Viewer. Click Data Translation.
  2. In the Data Translation Link card, select Option Value.
  3. In the Data Translation Link Card, the Language Code field, select ISL, and type the translation:

  1. Repeat the same steps for other attribute option values as shown below.

  2. Go to the Shopify Administration page, and click Related - Mapping - Locale. In the Locale Mapping section, click Action - Send Translations to send the translation to Shopify.

  3. Go to Shopify, navigate to Products. Select Linda casual dress from the list, and click More Actions - Localize. The translation is displayed in Shopify as shown below before publishing to the online store.

After publishing to the online store, the Linda casual dress is translated as shown below when the customer switches the language from English to Icelandic.

Note: Text in the yellow box cannot be translated because it is hard-coded.

Translate Extended Text to Item Description

  1. To add extended text to an item, go to the Retail Item List in LS Central, search and select the item (e.g., Bag Linda), then navigate to Related - Master Data - Extended Text. and click +New to create a new entry.

  2. Create a new entry, enable All Language Codes, and set English as the default. Enter the description, start date, and end date. Complete the Lines section, as each line is displayed in Shopify as entered.

  3. Next, continue by selecting your preferred Language Codes (for example, Icelandic - ISL), then enter the description, start date, and end date as shown in the screenshots. In the Lines section, add the translated text accordingly.

    Note: Maximum character length per line is 80. Text that exceeds this limit may fail to process correctly.

  4. After saving, you can view the added text in the Extended Text List page as confirmation of successful entry.

  5. Go to the Shopify Administration page, and click Related - Mapping - Locale. In the Locale Mapping section, click Action - Send Translations to send the translation to Shopify.

  6. Go to Shopify, navigate to Products. Select Bag Linda from the list, and click More Actions - Localize. The translation is displayed in Shopify as shown below before publishing to the online store.

After publishing to the online store, the extended text for Bag Linda is translated as shown below when the customer switches the language from English to Icelandic.