Import product variants in Optimizely Product Information Management

  • Updated

Before this feature can be added to your instance, your commerce connector code must be on the December 2022 version or newer. Contact your Customer Success Manager for more information.

Use features in Optimizely Product Information Management (PIM) to import product variants types, assign their properties and values, and assign variants to products during the product import process.

Import variant types, properties and value

  1. Click Import on the Variant Type List page or click Variant Types on the Import list.
  2. Choose your import file or click Download Template to ensure your data is formatted properly. The template includes a sheet for Variant TypeVariant Properties and Variant Values.
  3. Click Import.
    • New variant types are created, and existing variant types may be updated.
    • Variant properties are assigned to variant types with the display style, number of swatches visible, show swatch description and unselected value as defined for each row. If no data is entered, Show Swatch Description defaults to No, and the Number of Swatches Visible defaults to 4.
    • Variant values are assigned to variant properties with the swatch options and color/image as defined for each row. If no swatch style is selected, the default is no swatch setup. These can be configured within the application after the import is complete.
    • If any required column headers are missing, an error message displays asking you to download the template, update your data and try again. If the system finds any errors with data for specific rows, an error message displays to review and resolve the issues. Click Download to view the errors.
  4. Close the modal when finished importing.

Assign variant types in product import

You can also convert a product to a parent or child product during the product import process. Assign a variant type to a product to convert it to a parent product or assign a parent product to a product to convert it to a child. For example, if your import file has a column for a variant type and a column for parent product, rows with a variant type listed will be converted to a parent product and rows with parent product values listed will be converted to child products. The mapping step of the product import process allows you to map your columns to target properties.

If the variant type value does not match existing variant type names in the PIM, then an error displays and you can select from the list of variant types. Variant types cannot be assigned to products already configured as a parent or child.

When assigning a parent product, the PIM validates the child data for the variant properties of the variant type used by the parent. Child products must have data for each variant property, and the combination of values must be unique for each child product.