Import PIM properties
3 min
Format properties data for import to PIM
You can import properties and values or update existing property details using an import file. You can also import properties without values in the file and add them later.
- Select Import Template > Download Import Properties.
- Download the Properties template (PropertyImportTemplate.xlsx).
Although the PIM import template is multi-sheet, the previous single-sheet template file is still supported.
The import template provided in the PIM has two sheets: Properties and Property Values. An asterisk (*) indicates a required column on the sheets.
Properties sheet
You can provide information in the following columns on the Properties sheet:
- Name* – Identifies the property in the application. This value must be unique and any spaces are converted to underscores.
- Display Name – Identifies the property throughout the PIM. The website uses the display name if the property is a customer-facing attribute. If no value is entered, the value from the name field is used.
- Property Group* – Used to visually group similar properties together when editing product data in the PIM. The property group will display as a fieldset when editing products. If the property group listed doesn't exist, then it is created.
- Description – Describes the property and displays it as a tooltip when editing products in the PIM.
- Globally Required – Indicates whether or not this property is required for all products. If no value is entered, this defaults to No.
- Externally Managed – Indicates whether this property is managed within the PIM or if the data is pushed from Commerce via a recurring integration job. If no value is entered, this defaults to No.
- Control Type* – Determines the control type used to edit this property within the PIM. (Options: Text Feld, Text Area, Radio Button, Multi Select, Dropdown, HTML, Decimal, Date Picker, Date/Time Picker, Toggle)
- Default Value – Used by default for products created or imported without data for this property. (Optional for Text Field, Text Area, Radio Button control types, and Number data type.)
- Minimum Character Length – Defines the minimum character length allowed. Only valid for text field and text area control types. If no value is entered, this is set to 0. (Optional for Text Field and Text Area control types)
- Maximum Character Length – Defines the maximum character length allowed. If no value is entered, this is set to 250 for Text Field and 1000 for Text Area. (Optional and only valid for Text Field and Text Area control types)
- RegEx – Can be used to add property-specific validation rules. (Optional and only valid for Text Field and Text Area control types.)
- Template Specific Values – Determines whether or not each template uses the full list of values or if they are restricted to using a subset of these values. If no value is entered, this defaults to No. (Optional for dropdown, radio button, and multi-select control types)
- Allow Adhoc Values – Determines if users can add additional values when editing products or importing data or select only from pre-defined ones. If no value is entered, this defaults to No. (Optional for Dropdown control type)
- Minimum Value – Defines the minimum value allowed for numbers. If no value is entered, this defaults to 0. (Optional for Number data type)
- Maximum Value – Defines the maximum value allowed for numbers. (Required for Number data type)
- Number of Decimals – Defines the number of decimals allowed for numbers. If no value is entered, this defaults to 0. (Optional for Number data type)
- Boolean Label – Defines the label for boolean controls. Options are Yes/No, True/False and On/Off. (Required for Boolean data type)
- Mapped to Commerce Field – Defines what this property maps to in Commerce. Data that will not be published to Commerce should not be mapped.
- Attribute is Filterable – Determines whether the attribute displays as a filter on product lists. If no value is entered, this defaults to Yes.
- Attribute is Comparable – Determines whether the attribute can be used for product comparisons. If no value is entered, this defaults to Yes.
- Include Attribute on Product – Determines whether the attribute displays for the product on the product list and product detail pages. If no value is entered, this defaults to Yes.
- Attribute is Searchable – Determines whether search results on the website include matches for the attribute values. If no value is entered, this defaults to Yes.
Property Values sheet
You can provide information in the following columns on the Property Values sheet:
- Property Name* – Provide the name of the property to which the value is being added. Must match a Property Name established on the Properties sheet.
- Values* – Defines the available options for properties with Radio Button, Multi Select, and Dropdown control types. Values must be 255 characters or less.
Import properties
You can import and export your Optimizely Product Information Management (PIM) data in bulk.
- Click Imports. The Imports list page displays.
- Select Import Template > Download Import Properties.
- Download the Properties template if you have not already formatted your import file. See Format properties data for import.
- Drag and drop the file onto the Imports page. You can also click Import, locate your file, and click Open. The system automatically detects the file and sets the Import Type to Properties. If it selects a different import type, verify the file matches the template and reupload it.
- Click Import. If you receive any validation errors, resolve them before importing again. You can download the provided file to view error messages specific to each row.
- View your import progress on the Imports list page. A log of the import also displays on the page when it is complete.