Importing and Exporting Product Translations via Excel

Part 1: Exporting Products With Their Translations

1. Navigate to “Products & Services.”
2. Select the checkbox next to each product you want to export (or select the top checkbox to select all products at once).
3. Click the “Actions” button, then choose “Export.”

Since the secondary language is enabled, the resulting export file includes two additional columns alongside the usual ones, appearing directly after the primary “Name” and “Description” columns respectively:

• Name (Secondary): Contains the translated name for each product.
• Description (Secondary): Contains the translated description for each product.

These cells are automatically populated with the stored translation for each product, and remain completely empty for any product that hasn’t been translated yet — with no default value or error.

For example, the “Accounting Services” product appears with “Services comptables” in the “Name (Secondary)” column and “Services” in the “Description (Secondary)” column, while another untranslated product shows completely empty cells in both columns.

Part 2: Downloading and Filling In the Import Template

1. Navigate to “Products & Services.”
2. Click “Import.”
3. Download the available template “Download Sample“.

Since the secondary language is enabled, the template includes the “Name (Secondary)” and “Description (Secondary)” columns directly after the primary “Name” and “Description” columns, respectively.

When filling in the template:

• Both columns are optional — you can leave any cell empty without issue, in which case no secondary value will be stored for that product/field.
• The existing validation rules on the primary “Name” and “Description” columns remain unchanged.
• If you enter a value in the secondary column without entering its corresponding primary value, the entire row will be rejected — the primary field is always required, regardless of whether its translation is available.

Part 3: Uploading the File and Mapping Fields

1. After filling in the template, upload the file from the same “Import” page.
2. On the field mapping screen, you’ll find two additional fields to map the secondary name and description columns to the corresponding columns in your file.
3. Complete the mapping and proceed to import the file.

Import Behavior Based on Operation Type

When Updating an Existing Product

• If the secondary cell contains a value → the existing translation for that field/language is updated (or created if none exists).
• If the secondary cell is empty → the existing translation is preserved and not deleted (an empty field does not erase a previously stored translation).

When Creating a New Product

• Non-empty secondary cells → new translation records are created for the product.
• Empty secondary cells → no translation records are created.

Notes

• Error messages for import operations follow the same pattern currently used for other import error reports in the system.
• Column order in both the import and export files is fixed: the secondary name column appears directly after the primary name column, and the secondary description column appears directly after the primary description column.