Import and export translations in Optimizely Product Information Management

You can export all translatable data from Optimizely Product Information Management (PIM) and then reimport the files for properties, assets, categories, and products. Exports allow you to easily work with an external translation provider, and imports allow you to quickly translate large amounts of data.

Export information for translation

You can export properties, property values (dropdown, radio button, or multi-select), categories, assets, and product information for translation. Use the following steps:

1. Locate the properties, categories, assets, or products to export for translation.
2. Click the Export icon, then select Export for Translation.
3. Make the following selections:
   1. 1. Select whether to export the Properties or Property values, if applicable.
      2. Select the Target Language(s) to which you want to translate the content.
      3. Select the type of Records to include based on your filters and preferences.
      4. Select the types of Properties to Include in the export if you are export products.
      5. Click Export. The export window appears in the lower right corner. Do not close the window before the file is ready for download.
      6. Click the Download exported file link that appears.

Import translated properties, categories or assets

Once your exported files have been translated, you can import the files back into the PIM to update content for multi-language. On the Import screen or each of the relevant screens for properties, categories or assets, use the following steps.

1. Click the Import icon and select Import Translations.
2. Select the Target Language(s).
3. Click Choose File and locate the translated file.
4. Verify that the properties are mapped correctly and adjust as needed in the Map Translated Fields table that displays. (Adjustments should be necessary only if the column headers were modified in the exported file.)

   Only core properties for identification and translated fields must be mapped. All other fields, particularly default language fields, have Don't Import selected by default.

5. Click Import.

Import translated products

The import process for translated products is largely similar to the standard import process. The key difference is the inclusion of the Language column on the Mapping step. A drop-down list in the Language column lets you select the language for mappings to any multi-language properties. When importing files with column headers that include language codes, the field mappings select the language code by default. For instance, if you have column for "Product Title - EN" and "Product Title - ES", the columns auto-map to Product Title with EN and ES selected. If no language code is specified, the Language uses the default language.

1. Go to Imports > Products and select Add/Update Products.
2. Click Choose File and locate your translated file.
3. Click Continue.
4. Leave the Add or update records radio button and the Ignore blank cells checkbox selected.
5. Select the checkboxes beside the properties to include for the products in Available Fields.
6. Click Add to move the selected properties or Add All to move all properties to the Selected Fields area. If you selected an import template in the Initialization step, the Selected Fields will pre-fill.
7. Click Continue.
8. Verify that the Target Properties and Language columns are appropriately mapped for each field.
9. Click Continue.
10. Verify the data mappings and click Import.