Import PIM product templates

  • Updated

Format product template data for import to PIM

The import template (SampleProductTemplateImport.xlsx) provided in PIM has three sheets: Product Templates, Template Properties, and Template Property Values. 

An asterisk (*) denotes a required column on the below-mentioned sheets.

Product templates

You can provide information in the following columns on the Product Templates sheet:

  • Template Folder – Name a folder to which this template is added. Folders are for organizational purposes. The folder is created if it does not already exist.
  • Template Name* – Provide the name for each template.
  • Require Product Image – Set Yes if products with this template must have an image before they can be published. The default value is No.
  • Include Starter Template Properties – Set Yes if the properties that are included on the starter template are included on the template. If No, only the defined and globally required properties are included. The default value is No.

Template properties

You can provide information in the following columns on the Template Properties sheet:

  • Template Name* – Provide the name of the template. Must match a template name established on the Product Templates sheet or the name of a previously created template.
  • Property* – Provide the property name included in the template matching an existing property name.
  • Property Requirement Level – Determines if the property is Required, Recommended or Optional for this template. The default is Optional.

Template property values

You can provide information in the following columns on the Template Property Values sheet:

  • Template Name* – Provide the name of the template. Must match a Template Name established on the Product Templates sheet or the name of a previously created template.
  • Property* – Provide the name of the property included in the template matching an existing property name with template-specific values.
  • Property Value* – Define the valid values for the specified property for this template.

Import product templates

You can import product templates in bulk. Use the provided import template (SampleProductTemplateImport.xlsx) to add product templates or update details for existing product templates. See Format product template data for import to PIM.

The import template provided in PIM has multiple sheets to define the template, assign its properties and assign property values when appropriate. Data defined on the different sheets does not need to be imported together, allowing you to create templates and update them with properties and property values later. Older single-sheet import template files can still be supported. 

  1. Click Imports. The Imports list page displays.
  2. Select Import Template > Download Import Properties.
  3. Download the Properties template if you have not already formatted your import file. See Format properties data for import.

    download-import-templates-product-templates.png

  4. 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.

  5. Click Import.

    If you receive any validation errors, the tabs/sheets with errors will be red in the generated file. Resolve the errors before importing again. You can download the provided file to view error messages specific to each row.

  6. View your import progress on the Imports list page. A log of the import also displays on the page when it is complete.