How To

Creating a New Lookup List

Lookup lists allow you to substitute one value for another. For example, if your inventory data contains the manufacturer codes "01", "02", and "03", you could substitute those codes with values such as "Nike", "Reebok" and "Adidas". In your lookup list, the manufacturer codes would go in the “Name” field and the brand names would go in the “Value” field, so now 01 = Nike, 02 = Reebok, and 03 = Adidas.

Important points to remember:

  • You may create as many lookup lists as you need. 
  • You need to apply your lookup list in an inventory or marketplace template or within a business rule for it work.

 

Prerequisites


You should be familiar with the following topics before continuing:

 

Tasks to Complete


 

How to Create Lookup Lists via the User Interface

Lookup lists can be created for use with inventory, marketplaces, or feeds.

  1. Select Lookup List from the menu in which you'd like to use it.
    1. Inventory > Product Mapping > Lookup Lists
    2. Marketplaces > {Marketplace} > Product Mapping > Lookup Lists
    3. Digital Marketing > Marketing Management > Lookup Lists
    4. Webstores > {Webstore} > Lookup Lists
  2. Select the New Lookup List button.
  3. Supply the following information:
    1. Name (Required)
    2. Description (Optional)
    3. Name/Value – Names are required. Values are optional. You typically use both the name and value to create a data pair that will work together.
  4. Select the Add button to add the Name/Value pair to the list.
  5. Select either the Save button to save the list or the Save and Exit button to save the list and return to the Lookup Lists View.

 

How to Create Lookup Lists by Pasting from Excel

Lookup list items can be pasted directly from Excel into your lookup list.

A list should contain two columns – one for Name and one for Value. You can add your Excel data using the Paste from Excel button located at the top of the lookup list table. A window will open within the Lookup List page, so you may provide the following information:

  1. Select how you want to add your information:
    1. Merge to an Existing List
    2. Delete All Items and Replace an Existing List
  2. Paste – Paste your lookup list items in the text box.
  3. Add – Select the Add button to add your Excel information to your lookup list.

 

Related Task to Complete


Complete the following task related to this topic:

Lookup lists allow you to substitute one value for another. For example, if your inventory data contains the manufacturer codes "01", "02", and "03", you could substitute those codes with values such as "Nike", "Reebok" and "Adidas". In your lookup list, the manufacturer codes would go in the “Name” field and the brand names would go in the “Value” field, so now 01 = Nike, 02 = Reebok, and 03 = Adidas.

Important points to remember:

  • You may create as many lookup lists as you need. 
  • You need to apply your lookup list in an inventory or marketplace template or within a business rule for it work.

 

Prerequisites


You should be familiar with the following topics before continuing:

 

Tasks to Complete


 

How to Create Lookup Lists via the User Interface

Lookup lists can be created for use with inventory, marketplaces, or feeds.

  1. Select Lookup List from the menu in which you'd like to use it.
    1. Inventory > Product Mapping > Lookup Lists
    2. Marketplaces > {Marketplace} > Product Mapping > Lookup Lists
    3. Digital Marketing > Marketing Management > Lookup Lists
    4. Webstores > {Webstore} > Lookup Lists
  2. Select the New Lookup List button.
  3. Supply the following information:
    1. Name (Required)
    2. Description (Optional)
    3. Name/Value – Names are required. Values are optional. You typically use both the name and value to create a data pair that will work together.
  4. Select the Add button to add the Name/Value pair to the list.
  5. Select either the Save button to save the list or the Save and Exit button to save the list and return to the Lookup Lists View.

 

How to Create Lookup Lists by Pasting from Excel

Lookup list items can be pasted directly from Excel into your lookup list.

A list should contain two columns – one for Name and one for Value. You can add your Excel data using the Paste from Excel button located at the top of the lookup list table. A window will open within the Lookup List page, so you may provide the following information:

  1. Select how you want to add your information:
    1. Merge to an Existing List
    2. Delete All Items and Replace an Existing List
  2. Paste – Paste your lookup list items in the text box.
  3. Add – Select the Add button to add your Excel information to your lookup list.

 

Related Task to Complete


Complete the following task related to this topic:

0
Your rating: None Average: 1 (1 vote)
0
Your rating: None Average: 1 (1 vote)