Create templates from product data sheets

  • Updated

You can use a master product file to generate product templates. This can save you time because you no longer need to manually make your data conform to match the import format or create a custom extract transform load (ETL) tool to evaluate product data and generate the files. This method can also be useful when adding large sets of products, such as growing through acquisition or adding product lines.

As PIM evaluates the data and displays warnings if appropriate. You can then review the generated files, make necessary tweaks, and import the properties and templates.

  1. Go to Data Setup > Properties
  2. Click Generate Import File.
  3. Click Choose File.
    generate-import-file-4.png
  4. Select Product Template.
  5. Click Next.
  6. Select which column represents the template in the product file. When generating the file, PIM identifies properties that have product data with the same value for the selected column and includes those in the template. For example, all products in the same category will likely have data for the same properties.
    generate-import-file-5.png
  7. Click Next.
  8. Review the information and click Download.
    generate-import-file-6.png
  9. After the file is generated, review any warnings and import the file using the product template import process to create the templates.