Skip to main content

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 Partner Taxonomy Mapping list, use the Attribute-based Replacement list to create your values manually.

When you create an Attribute-based Replacement list, you define the new values that should replace the current values in your feed. To let your list replace all mapped values in your feed, you must add the Taxonomy Mapping or Replacement rule box to any desired attribute in Data View or Dataflow. See Add the Taxonomy Mapping rule box and (optional) Add the Replacement rule box for more information.

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 Import or Intermediate based on what stage contains the attribute where you want to replace values.

  5. In Attribute, select the field and begin entering an attribute to choose it from a list of pre-defined results. The platform later populates the list with the values of this attribute to let you define and map alternative values.

  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

When you add a new list, the platform opens it and only once populates it with the values of the selected attribute. If you add new values to this attribute in your data source and run your site, the platform doesn't update the list with new values. You must use the Taxonomy Mapping rule box to apply your list to the attribute containing the new values, which lets the platform update your list. See Add the Taxonomy Mapping rule box for the setup information.

  1. In the terms view of the Attribute-based Replacement list, 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 the Import stage

    • Intermediate - Displays attributes from the Intermediate stage

    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.

    add_replacement_terms2.png

Add the Taxonomy Mapping rule box

Once you have finished setting up your Attribute-based Replacement list, apply the Taxonomy Mapping rule box to the attribute column where you want to replace values.

  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 list from the drop-down menu List.

    The Taxonomy Mapping rule box
  3. The On No Match option lets you choose the matching behavior for values that aren't in the Search field on the list. If the box can't 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

    Tip

    If you want to update your list with new rows added to your data source, select Run in the upper-right corner of your view.

(optional) Add the Replacement rule box

Tip

It is best to use the Taxonomy Mapping rule box for the Attribute-based Replacement list, especially when replacing category terms. The Replacement rule box also replaces current attribute values with the values from the list, but it doesn't let the platform update your list with new rows added to your data source.

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

  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 to those specified in your replacement terms.

    The result of applying the Replacement rule box in Data View