The Import Item Name Translation module of the Import Tool can be helpful for enterprise customers who have locations in different countries or regions with different local languages. If your store network is geographically distributed, you may need to maintain descriptions of items in several languages.
To facilitate the process of items setup, you can use the Import Item Name Translation module. This module allows you to import a list of new items together with the item descriptions and cash register descriptions presented in different languages in bulk.
At present, the Import Tool supports import of item name translations from files in the XLSX format. Once the translation data is imported to the draft, it can be saved to the following destinations:
- CStoreOffice® Price Book
- PIM Price Book (if your account has a PIM subscription)
Preparing a File for Importing Translations Data
To import item name translations, you need to prepare a file with the items data in the XLSX format. The file must have the following data structure.
| Field Name | Mandatory (Yes/No) | Description |
|---|---|---|
| SKU | Yes | Item code in one of supported formats: - UPCA - UPCE - EAN8 - EAN13 - PLU |
| SKU Type | Yes | Сode type for the SKU code in the previous column. Must be one of following numbers:
- UPCA = 0 - UPCE = 1 - EAN8 = 2 - EAN13 = 3 - PLU = 4 |
| Description | No Yes, if CR Description is not available |
Item name as it appears in the CStoreOffice® Price Book. Must be no longer than 250 characters. The field is required if the CR Description value is not provided for the item. |
| CR Description | No Yes, if Description is not available |
Item name that will appear on the cash register and in customer receipts. Must be no longer than 20 characters. Longer values will be cropped. The field is required if the Description value is not provided. |
| Language | Yes | Language code to define the language for which the Description/CR Description is provided.
Possible values:
- ar - Arabic (العربية) - de - German (Deutsch) - en - English (English) - es - Spanish (Español) - fr - French (Français) - id - Indonesian (Bahasa Indonesia) - it - Italian (Italiano) - ms - Malay (Bahasa Melayu) - no - Norwegian (Norsk) - pl - Polish (Polski) - pt - Portuguese (Português) - ru - Russian (Русский) - th - Thai (ไทย) - tr - Turkish (Türkçe) If the specified language matches the system language (set up as the display language in CStoreOffice®), the provided Description and/or CR Description will be appropriately updated and displayed in the item form in CStoreOffice®. If this field is left empty, the system will apply the value according to the system language. |
If you need to import the item name translations in different languages at once, you can add several lines for the same item, each with a different language code and the Description and/or CR Description translations in this language. For example, you need to import data for the following item:
- SKU: 12657
- SKU Type: UPCA
- Item name: Strawberry donut
- Languages: English, French and Spanish
In this case, you need to prepare a file with the following structure:
| SKU | SKU Type | Description | CR Description | Language |
|---|---|---|---|---|
| 12657 | 0 | Strawberry donut | Str. donut | en |
| 12657 | 0 | Beignets de fraises | Beignets de fraises | fr |
| 12657 | 0 | Donut de fresa | Donut de fresa | es |
Importing Item Name Translations
To import item name translations:
- In the Import Tool, go to Price Book > Import Tool.
- In the Quick Operations section, select Import Item Name Translations.
- In the right pane, click Browse and select the file with the items data.
To download a sample file that you can populate with items data, in the right pane of the Import Item Name Translations section, click Download Example.
- In the right pane, click Load Data Source.
Result: The items data from the file is loaded in the Import Tool draft.
When the Import Tool loads data from the file, it validates if data for the items is specified correctly and filters items as valid or invalid. Invalid items data is not imported to the system. For more details about data validation, see Validating Objects Data.
- In the items list, review the imported data and correct it, if needed. You can do the following:
- To change the language for the item descriptions, in the item row, click the Language field and select the necessary language from the list.
- To change the item description, in the item row, click the Description or CR Description field and correct the translation as needed.
- In the items list, select check boxes next to items whose data you want to import and in the right pane, click Save To.
Result: The items data with name translations is saved to the CStoreOffice® Price Book and PIM Price Book. CStoreOffice® displays the data import results so that you can review them.
Sorting and Filtering Items
To facilitate work with items, you can sort and filter items in the items list.
- To sort items by a specific value in the ascending or descending order, click the necessary column name once or twice. Alternatively, you can click the arrow icon to the right of the necessary column and select Sort Ascending or Sort Descending.
- To filter items by a specific value, to the right of the necessary column, click the arrow icon and select the check boxes next to the values by which you want to filter the items list.
Exporting Items Data to a File
When working with the Import Tool draft, you can export items data to a file. For example, you can select all items that are marked by the Import Tool as invalid and export them to a file for correction.
For more details, see Exporting Draft Data to a File.
