Replace feed attributes with the Attribute-based Replacement list

Use the Attribute-based Replacement list, formerly known as the Mapping list feature, to replace attributes for selected imports or intermediate attributes in Productsup.

Introduction

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. If you do not want to use one of the pre-defined taxonomies from the Category Mapping list, use the Attribute-based Replacement list to create your values.

Set up the Attribute-based Replacement list:

  1. Go to Lists from your site's main menu and select ADD LIST.

    site_lists_page.png
  2. Next, choose Attribute-based Replacement and select Continue.

    new_list_types_attr_repl.png
  3. In Name, give your Replacement List a custom name to help you identify it. You can later edit the custom name.

  4. In Stage, choose the Import or Intermediate column to replace attributes.

  5. In Attribute, select the field and begin entering an attribute to select it from a list of pre-defined results.

    Note

    Attribute values from the selected column appear in the list for the initial run only. The platform does not update the list with the new attribute values after the initial run unless the list uses the Taxonomy Mapping rule box.

  6. (Optional) Toggle on the Share list button and choose one of the following:

    1. Account level - Share this list with all sites across all projects under this account.

    2. Project level - Share this list with all sites under this project.

    Note

    Values within any other columns that you add the Taxonomy Mapping rule box to update the category values in the list. These updates impact values from other sites if you share the list at the account or project level.

  7. Select Add.

    add_attr-based_rep.png

Add replacement terms to the list

  1. In the Attribute-based Replacement list terms view, enter the replacement terms in the Replace term fields for your chosen stage or column. You can confirm the stage by viewing the List settings field on the far-right side.

    list_settings_menu.png
    • Import - Displays attributes from your import feed

    • Intermediate - Displays attributes from the Intermediate feed

    The replacement term list displays the attribute name on the left side. Underneath the attribute name, it lists every value belonging to the attribute. For example, see the following values under category:

    add_replacement_terms.png
  2. In the Replace term column, add an alternative value for categorization.

    add_replacement_terms2.png

Add the Taxonomy Mapping rule box

Once you have finished setting up your Attribute-based Replacement list, use the Taxonomy Mapping rule box for the attribute column that contains your new categories.

  1. Go to Data View from your site's main menu and select the Edit button for the column you want to edit.

  2. In the edit view, search for and add the Taxonomy Mapping rule box for the column. Now, choose your desired replacement list from the drop-down menu.

    The Taxonomy Mapping rule box
  3. The On No match option lets you choose the matching behavior where values are not in the Search field on the list. If the box cannot find the value in the list, you can choose between set to empty string, which leaves the cell open, or set original value not to replace the cell value.

  4. Select Save. The Taxonomy Mapping rule box now matches your newly-entered replacement terms found in your chosen list.

    For example, the Taxonomy Mapping rule box modified the google_product_category column by replacing the original values with the matching category term from the Intermediate stage that the list defined:

    taxonomy_mapping_result.png

(optional) Add the Replacement rule box

It is best to use the Taxonomy Mapping rule box for the Attribute-based Replacement list.

You can add the Replacement rule box to change your feed attribute values in Data View. This rule box affects specific values that you specify in your desired replacement list.

Note

Productsup suggests using the Taxonomy Mapping rule box when replacing category terms.

  1. Go to Data View and select Intermediate to choose the stage where you wish to add a box.

  2. Select Edit for the column where you want to add a box. You can now see an open tab on the right-hand side.

  3. Select the Add Box drop-down menu.

  4. Search for the Replacement rule box and select it to add the rule box to the attribute column.

    The Replacement rule box
  5. Choose your desired Attribute-based Replacement list from the Select an Option drop-down menu.

  6. Select Save. The Replacement rule box changes the values in your selected attribute column to those specified in your replacement terms.

    The result of applying the Replacement rule box in Data View