Arthur Vander Voort
Mar 10, 2023
  307
(1 votes)

Optimizely PIM - How to Auto-Assign Assets to Products During Import

Assets can be assigned to products manually, via spreadsheet import, and during initial import leveraging the auto-assignment option. This article will go into detail on how the auto-assignment functionality can work with several use cases.

When to use the auto-assignment functionality

In order for the auto-assignment functionality to work, the following must be true:

  1. The products must already exist in PIM
  2. The file names of the assets you're importing must at least partially match some existing product data (such as product number)

Auto-assignment overview

To access the auto-assignment functionality, you must choose the advanced import option from the asset list page by clicking the import button. After selecting your files, you will see several several options that you can configure before initiating the import including the auto-assign toggle. Once you enable auto-assignment, you will choose a property that the file names will be matched with for auto-assignment. In cases where you will match on a partial file name, you will toggle the match partial file name option on and then configure the exact matching logic, which will be further outlined in use cases below.

AutoAssign2.gif

Use Case 1: Auto-assigning with exact file name match

Match1.png

For this scenario, you only have a single image for each product and the file name matches the product number exactly.

  1. Click the import option and select the assets you want to import.
  2. Enable the auto-assignment toggle.
  3. Select product number as the "auto assign based on" property.
  4. Proceed with the import.
UseCase1.png

Use Case 2: Auto-assigning with partial match for multiple images per product

Match2.png

In this scenario, you have multiple assets that will be assigned to the same product, and the file name includes the product number plus an incrementing number.

  1. Click the import option and select the assets you want to import.
  2. Enable the auto-assignment toggle.
  3. Select product number as the "auto assign based on" property.
  4. Toggle the "Match partial file name" option on.
  5. Set the starts with option to start at position 0.
  6. Update the ends with options to end before the 1st occurrence of _.
  7. Proceed with the import.
UseCase2.png

Use Case 3: Auto-assigning with partial match within file name

Match3.png

In this use case, you received assets from a supplier that include the name of the product's brand, as well as the product number and image number.

  1. Click the import option and select the assets you want to import.
  2. Enable the auto-assignment toggle.
  3. Select product number as the "auto assign based on" property.
  4. Toggle the "Match partial file name" option on.
  5. Update the starts with options to start after the 1st occurence of -..
  6. Update the ends with options to end before the 1st occurrence of _.
  7. Proceed with the import. If any of the selected files do not match products based on the selected property, a warning will display asking if you wish to proceed.
UseCase3.png

Notes & Caveats:

  • The auto-assignment capability currently only works during the import process and cannot be applied for already imported assets.
  • The asset import will be slower when using the auto-assignment option and since it has to evaluate each product for matches, the more products you have, the more it will affect the performance.
  • When using partial matching logic, the same asset can be assigned to multiple products. There are cases where this is intentional (e.g. many products have the same document attached), but it is also possible to set up matching logic that is not restrictive enough and assigns assets to the wrong products.

For more information on the asset management capability in PIM, check out our full documentation.

Mar 10, 2023

Comments

Please login to comment.
Latest blogs
Zombie Properties want to Eat Your Brains

It’s a story as old as time. You work hard to build a great site. You have all the right properties – with descriptive names – that the content...

Joe Mayberry | Mar 29, 2023 | Syndicated blog

Optimizely finally releases new and improved list properties!

For years, the Generic PropertyList has been widely used, despite it being unsupported. Today a better option is released!

Tomas Hensrud Gulla | Mar 28, 2023 | Syndicated blog

Official List property support

Introduction Until now users were able to store list properties in three ways: Store simple types (int, string, DateTime, double) as native...

Bartosz Sekula | Mar 28, 2023

New dashboard implemented in CMS UI 12.18.0

As part of the CMS UI 12.18.0 release , a new dashboard has been added as a ‘one stop shop’ to enable editors to access all of their content items,...

Matthew Slim | Mar 28, 2023