Lists feature

Use the Lists feature to define how specific rules boxes help you optimize your product data. Include or exclude, replace, or map values in your product feed using lists in Productsup.

Introduction

Use lists to define how specific rules boxes help you optimize your product data. You can include or exclude, replace, or map values in your product feed using lists. For example, suppose you want to include or exclude a list of items from your inventory. In that case, the Standard Inclusion/Exclusion rule box explicitly uses the values you first defined in Lists.

In other words, If you want to exclude, replace, or connect values to different values for several products in a column, you must first create a list. A list contains all the terms or values you want to apply rules to. You can edit replacement terms from a dynamic source with the Dynamic Inclusion/Exclusion or Dynamic Replacement list for efficiency. For example, upload, drag and drop, or link a CSV file to this list type via URL, rather than entering terms manually in the platform.

After creating a list, you then add a rule box in Data View that tells the platform how to treat the intended products. A small pop-up message in each rule box explains which list types you need to create first and which rule boxes require a list.

For example, to exclude products from your product feed, you can use the Blacklist rule box. It works with the Standard Inclusion/Exclusion list, formerly known as the Default List.

The Lists feature offers you list types from the three categories: Inclusion/Exclusion, Replacement, and Mapping. See the following tables:

Table 1. Inclusion/Exclusion lists category

List category

New list name

Former list name

Inclusion/Exclusion

Standard Inclusion/Exclusion

Default List

Dynamic Inclusion/Exclusion

Default List URL



Table 2. Replacement lists category

List category

New list name

Former list name

Replacement

Standard Replacement

Normalization List

Dynamic Replacement

Normalization List URL

Attribute-based Replacement

Mapping



Table 3. Mapping lists category

Category

New list name

Former list name

Mapping

Partner Taxonomy Mapping

Category Mapping

Classification Mapping

Classification List



Important

Productsup updated the following three rule box names:

Table 4. Rule box name changes

New rule box name

Former rule box name

Replacement

Normalization

Replacement Sensitive

Normalization Sensitive

Taxonomy Mapping

Category Mapping



See Optimize your product data with rule boxes for more information.

The following topics give you an overview of each list type.

List types

In the platform, you can create the following list types in Lists:

  • Standard Inclusion/Exclusion - Create a list of values you want to include or exclude from your feed.

  • Dynamic Inclusion/Exclusion - Import a list of values you want to include or exclude from your feed via a CSV file upload or URL.

  • Standard Replacement - Create a list of values in your feed that you want to replace by applying your defined values.

  • Dynamic Replacement - Import a list of dynamic values you want to replace from a CSV file upload or URL.

  • Attribute-based Replacement - Create a list of values for a selected import or intermediate attribute where you can replace them with your choice of values.

  • Partner Taxonomy Mapping - Create a list of all values included in a selected import/intermediate attribute and replace them with categories from a partner's taxonomy.

  • Classification Mapping - Create a list of all included values in a selected import or intermediate attribute and replace them with categories from a classification system.

lists_page.png

Inclusion/Exclusion lists

Standard Inclusion/Exclusion

The Standard Inclusion/Exclusion list feature, formerly known as the Default List, lets you define products in your data feed that you want to include or exclude from your export. It's a list containing terms that the Productsup platform accepts or skips when it matches your previously specified words. You can share this list with all sites in a project or an account. And when you modify your data feed, the platform automatically updates the list.

With the Standard Inclusion/Exclusion list, you manually enter all the values used for inclusion or exclusion in Lists. See Exclude products with the Standard Inclusion/Exclusion list for the setup.

Dynamic Inclusion/Exclusion

The Dynamic Inclusion/Exclusion list feature, formerly known as the Default List (URL), works similar to the Standard Inclusion/Exclusion list. But instead of manually entering values for inclusion or exclusion in Lists, you upload a CSV file or access the list of values via URL. See Exclude products with the Dynamic Inclusion/Exclusion list for the setup.

Replacement lists

Standard Replacement

The Standard Replacement list, formerly known as the Normalization List, lets you efficiently edit terms within the product feed to:

  • Standardize specific terms or keywords

  • Minimize redundancy

  • Replace low-volume search terms with high-volume search terms

You create a list of terms to replace existing terms in the data feed. This list ensures that there is always one standard variation of a specific word used in a particular context. See Replace feed terms with the Standard Replacement list for the setup.

Dynamic Replacement

The Dynamic Replacement list, formerly known as the Normalization List (URL), is similar to the Standard Replacement list, although it lets you upload or import a list file from a CSV file or via URL. See Replace feed terms dynamically with the Dynamic Replacement list for the setup.

Attribute-based Replacement

Use the Attribute-based Replacement list, formerly known as the Mapping list feature, to replace existing attributes with your choice of new values. This list of unique values replaces your import and intermediate feed attributes. See Replace feed attributes with the Attribute-based Replacement list for the setup.

Mapping lists

Partner Taxonomy Mapping

Partner Taxonomy Mapping, formerly known as Category Mapping, lets you create a list of all values included in a selected import or intermediate attribute and replace them with categories from a partner's taxonomy.

For some export channels, you can match shop categories with a channel partner taxonomy. In some cases, it's mandatory, for example, with Google Merchant Center (GMC). Matching a partner taxonomy ensures that your product categorizations are correct in export channels. See Replace attributes with Partner Taxonomy Mapping list for the setup.

Classification Mapping

The Classification Mapping list, formerly known as Classification List, lets you create a list of all included values in a selected import or intermediate attribute and replace them with categories from a classification system.

For example, manufacturers in the electrical, heating and ventilation, and building and construction industries often need to provide product data to trade and industry partners. These products follow an international classification standard, which structures product information by class. See Set up the Classification Mapping list for the setup.

View list information and edit settings

Search and filter lists

  1. Enter a list name in the search field to perform a search. Or select Type and choose the list type from the drop-down menu.

  2. You can also select the Used lists and Unused lists filter buttons to quickly display specific lists.

    lists_filter_png.png

Get detailed information for each list in the Lists' main view.

  • Names - Shows custom list names and list types.

  • Number of items - Displays the number of items in the list. It also displays the number of unmapped objects.

  • Shared with - Displays if and where you shared the list across accounts or projects.

  • Used in - View if none, one, or several rule boxes use the list.

    detailed_list_info.png

Edit list settings

  1. You can choose a list to view its settings. Under List settings, select Edit to modify list options for your chosen list on the right.

    • Source - For dynamic lists, you can see where the list file originates, in Import or Intermediate. See source information by selecting a list. For taxonomy lists, you can see the selected partner taxonomy source and attribute.

    • Reset list on every import - Only available for the Dynamic Replacement and Dynamic Inclusion/Exclusion lists. Displays the status if you have activated this setting.

      This setting removes all data whenever an import and downloads new data from the defined source while leaving all configurations unchanged.

    • Share list - Displays if you shared this list with a project or account. You can select the hyperlink(s) to visit the account or project that shares the list.

      list_settings.png
  2. From within a list, you can edit the list name. Select the edit icon to the right of the list name, and enter a new list name.

  3. You can also perform some quick operations by selecting the Actions button in the top-left ribbon to:

    • Download the list

    • Reset the list - Removes all data but leaves all configurations untouched.

    • Delete all unmapped list items

    • Delete the list

      actions_menu.png

Edit list terms

Review the following to see which list types let you modify the list terms or values within the list:

  • Standard Replace list - Select the Search and Replace term input fields to modify the attributes or values and replacement terms.

  • Dynamic Replacement list - Select the Replace term input field to modify the replacement term.

  • Standard Inclusion/Exclusion list - Select the Term input field to modify the term.

  • Dynamic Inclusion/Exclusion list - Modify the list from the CSV or URL source, or activate the Reset the list option to remove all data except the configuration.

  • Attribute-based list - Select the Replace term input field to modify the term.

  • Partner Taxonomy Mapping list - Select the Replace term input field and enter a term to choose from an auto-complete list of categories.

  • Classification Mapping list - Select the Replace term input field to choose a different classification from an auto-complete list of classifications.

    modify_class_mapping_class.png

View box connections per list

If you set up rule boxes to use your list, you can see the site and the number of rule boxes that use your list.

  1. Select the list, and a message above List settings displays the number of rule boxes that use the list.

    see_rule_box_where_list_used_.png
  2. Select the hyperlinked rule box text in the message, and a window appears to illustrate the stages of your defined list values, what they map to, and the box names using the list.

  3. Select the hyperlinked rule box to land in Data View. Here you can get a better view or manage your impacted product data.

    hyperlink_to_data_view.png
  4. In this example, the Negative Blacklist and the Blacklist Entire Word rule boxes use your list values in the Import to Intermediate stages. Both stages map to the attribute day.

    rule_box_use_list_message.png