How To

Using Lookup Lists

Lookup lists are very flexible and powerful options to customize your feeds. They can perform several functions including:

  • Allowing you to get additional data
  • Replacing existing data
  • Building a list of products to exclude from feeds

You may create as many lookup lists as you need. Lookup lists can be created individually or uploaded in bulk.

 

Prerequisites


You should be familiar with the following topics before continuing:

Most applications of lookup lists require that they are paired with a business rule . This is because the lookup list needs the expression portion of a business rule to perform an action. Some lookup lists (that are not exclusion lists) can be mapped directly within a template in order to substitute an inventory field based on a lookup list.

 

Video


Lookup List Overview – This video is for ChannelAdvisor customers who wish to use lookup lists to transform data for channels and reviews how to add lookup lists and apply them in the system. View Transcript

 

The Lookup List View


You can view the following in the Lookup List view:

  • Name – The name of the lookup list
  • Description – The description of the list created.
  • # Items – Indicates the number of entries or mappings in this list.
  • Date Created  – The date the list was created.
  • Updated By – The username of the person who updated the list.
  • Date Updated – The date for the last update to the list.
  • Actions  – Allows you to copy or delete user-created lists. Delete is not an option for system created (default) lists.

 

Tasks to Complete


Complete the following tasks related to this topic:

  1. Creating a New Lookup List
  2. Updating a Lookup List via File Upload 
  3. Applying a Lookup List

 

Reference


Refer to the following for additional reference information:

Lookup lists are very flexible and powerful options to customize your feeds. They can perform several functions including:

  • Allowing you to get additional data
  • Replacing existing data
  • Building a list of products to exclude from feeds

You may create as many lookup lists as you need. Lookup lists can be created individually or uploaded in bulk.

 

Prerequisites


You should be familiar with the following topics before continuing:

Most applications of lookup lists require that they are paired with a business rule . This is because the lookup list needs the expression portion of a business rule to perform an action. Some lookup lists (that are not exclusion lists) can be mapped directly within a template in order to substitute an inventory field based on a lookup list.

 

Video


Lookup List Overview – This video is for ChannelAdvisor customers who wish to use lookup lists to transform data for channels and reviews how to add lookup lists and apply them in the system. View Transcript

 

The Lookup List View


You can view the following in the Lookup List view:

  • Name – The name of the lookup list
  • Description – The description of the list created.
  • # Items – Indicates the number of entries or mappings in this list.
  • Date Created  – The date the list was created.
  • Updated By – The username of the person who updated the list.
  • Date Updated – The date for the last update to the list.
  • Actions  – Allows you to copy or delete user-created lists. Delete is not an option for system created (default) lists.

 

Tasks to Complete


Complete the following tasks related to this topic:

  1. Creating a New Lookup List
  2. Updating a Lookup List via File Upload 
  3. Applying a Lookup List

 

Reference


Refer to the following for additional reference information:

0
Your rating: None Average: 3 (2 votes)
0
Your rating: None Average: 3 (2 votes)