Import PIM translations

3 min

You can translate large amounts of data by importing it.

Help with formatting your data

If you need to download the template to help format your data, go to Import Templates > Download Import Templates and click Download for Translations.

Import translated properties, categories, or assets

You can import translated content for properties, categories, or assets.

Note

URL segments for categories must be unique for the translated languages.

Go to Imports > Imports tab. The Imports list page displays.

Click Import and select the file you want to upload. (You also can drag and drop the file onto the Imports page or click Browse to locate your file.) The page automatically detects the Import Type and asks you in the Notes column to verify the import type selected. If the columns match a previously saved template, the page selects that template under Import Template.

Click Open to start the upload.

The import validates the file for issues. If there is an issue, it displays a validation error message with a downloadable file. If there are no issues, the translations successfully import for the properties, categories, or assets in the file.

Import translated products

The import process for translated products is similar to the standard import process, except you also include a 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 products. 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.

Go to Imports > Imports tab. The Imports list page appears.

Click Import. The Import Wizard displays. (You also can drag and drop the file onto the Imports page or click Browse to locate your file.) The page automatically detects the Import Type and asks you in the Notes column to verify the import type selected. If the columns match a previously saved template, the page selects that template under Import Template.

Drag and drop the file onto the Imports page. You can also click Browse or Import, locate your file, and click Open. The page automatically detects the Import Type and asks you in the Notes column to verify the import type selected. If the columns match a previously saved template, the page selects that template under Import Template.

Select an option for handling new or existing records:

Add or update records

Only add new records

Only update existing records

Choose whether to Ignore blank cells. If you ignore blank cells when updating, the import does not overwrite existing data with a null value.

Click Select Source Fields to map.

Select File includes name/value pairs if your data has columns for a series of names and values, where many properties may exist within any 'name' column. Select the columns with the names and values. You can then map unique values within the name columns to properties.

Select the check boxes beside the columns you want to import in Available Fields.

Click Continue. The wizard maps the source fields to the target properties.

Change or select any Target Properties if needed.

Select Hide mapped fields if you want to hide fields and focus on the unmapped fields.

Add a Static Value to import a specific value for all imported records if desired. For example, the vendor or supplier name.

Select Save this option as an import template if you want to save these field mappings and import options. The wizard automatically uses the file name plus "Template".

Click Import.