Related Videos/Articles
Videos
Lookup Tables #1 Introduction to Comestri Lookup Tables
Lookup Tables #3 Create Lookup Table in Comestri Channel
Articles
Video Summary
This video shows you how to use Lookup Tables with Lookup Links in the Comestri PIM.
Video Transcript
In this video, you’ll be shown how to use Lookup Tables in the Comestri PIM.
You’ll see how Lookup Tables use Lookup Links to populate Attribute values in the PIM, automatically.
Lookup Tables provide a way of storing product data in a tabulated form consisting of rows and columns.
Lookup Links on Lookup Tables allow you to automatically populate a destination Attribute based on the value of a source Attribute.
You can also use Lookup Tables with Liquid Rules in the Comestri PIM.
(See the end of the video for a link to an article with more details on Lookup Tables.)
Before creating a Lookup Link for a Lookup Table, you’ll need to ensure that the Attributes that correspond to the Lookup Table’s columns have already been created in the Comestri PIM.
The Lookup Link on a Lookup Table is triggered when the value of the Attribute matched against the Lookup Table’s source column is added or modified via:
- the Comestri UI
- the Comestri API
- Product CSV file upload to Comestri
The Lookup Table in this example will show how you can use the value of a source Attribute (Colour) to automatically populate the value of a destination Attribute (Colour Family) using a women’s dress as the example product.
This is useful for retailers, as products are frequently given a special fashion colour name (e.g. Daffodil) for branding or marketing purposes. External platforms, however, often require these products to have a generic colour (e.g. Yellow) to optimise search.
Before creating the Lookup Table and Lookup Link, you’ll be shown the example product (Betsy Dress Apricot) along with its assigned Attributes.
You’ll then see how using a Lookup Table with a Lookup Link automatically populates the Colour Family Attribute value for the dress.
Welcome to Comestri. To begin, we will sign in to the Comestri application.
Click Products on the main menu. Then click Manage Products on the expanded menu.
The Manage Products page opens.
Here you can see the example product – Betsy Dress Apricot.
Next, you’ll see the Attributes currently assigned to this dress before you create the Lookup Table and the Lookup Link.
Click the Product Code ‘betsy-dress-apricot’.
The Edit Product page opens showing the General tab for the product.
Click the Attributes tab.
You’ll see the Attributes ‘Colour’ and ‘Colour Family’ have been assigned to this product, but they don’t yet have values.
Next, you’ll create the Lookup Table.
Click Product Configurations on the main menu. Then click Lookup Tables on the expanded menu.
The Lookup Tables page opens. Here you can see all the existing Lookup Tables.
To create your Lookup Table, click the New Lookup Table button. The New Lookup Table dialog box opens.
This Lookup Table will use the Colour Attribute value to populate the Colour Family Attribute value.
Next, enter a unique Name. Here, you’ll enter ‘Colour to Colour Family’.
In the Columns field, you’ll enter the names of the columns you want to create in the Lookup Table.
First, you’ll type in ‘Colour’ and then press Enter to add it as a column name.
Then, you’ll type in ‘Colour Family’ and press Enter to add it as the second column name.
Click Save.
The Lookup Table is now listed on the Lookup Tables page.
Next, to add Lookup Values, click the ellipsis and select Edit from the dropdown list.
The Edit Lookup Table page opens. Here you’ll see the columns you have created.
Next, you’ll add rows for this Lookup Table. Click the New Row button.
The New Lookup Row dialog box opens.
Enter ‘Apricot’ in the Colour field. This will be your value in the first column.
Next, enter ‘Orange’ in the Colour Family field. This will be your value in the second column.
Click Save.
A slide-in message appears confirming the Lookup row has been created.
The new Lookup Row is now listed on the Edit Lookup Table page.
Repeat this process to create a new Lookup Row for each additional fashion colour.
Here you can see more Lookup rows have been created.
Next, you’ll set up a Lookup Link to associate the source Attribute with the destination Attribute.
Return to the Lookup Tables page. Click the ellipsis and select Manage lookup links from the dropdown list.
The Lookup Links For Lookup Table page opens.
To create your Lookup Link, click the New Lookup Link button.
The New Lookup Link dialog box opens.
To start creating your Lookup Link, select a Link type.
Here you’ll select ‘Value generation’ as the Link type.
A Value generation Lookup Link looks up a source Attribute value and populates a destination Attribute value.
Next, select Attribute as the Input Object type.
From the Input Object dropdown list, select the source Attribute Colour.
Next, select Attribute as the Output Object type.
From the Output Object dropdown list, select the destination Attribute Colour Family.
Next, select Colour as the Input Column, which is the Lookup Table column the source Attribute value is compared to.
Then, select Colour Family as the Output Column, which is the Lookup Table column that provides the destination Attribute value.
NB: If there’s no match for the source Attribute value in the Lookup Table, the destination Attribute value is given a blank value.
Click Save.
The Lookup Link is now listed on the Lookup Links For Lookup Table page.
Next, to check that your Lookup Table will generate the expected result, click Manage Products under Products in the main menu.
The Manage Products page opens. Here you can see the example product – Betsy Dress Apricot.
Click the Product Code ‘betsy-dress-apricot’.
The Edit Product page opens showing the General tab for the product.
Click the Attributes tab.
Now, select ‘Apricot’ from the Colour Attribute’s dropdown list.
Click the Update Product button.
A slide-in message appears confirming the product has been successfully updated.
Notice that the Colour Family Attribute has been automatically populated by the Lookup Link.
The Colour Family Attribute has now been populated with the value ‘Orange’.
This ends the example of using a Lookup Link on a Lookup Table to populate an Attribute based on the value of another Attribute.