Replace feed terms with the Standard Replacement list

Use the Standard Replacement list feature, formerly known as Normalization List, to replace existing terms in your feed with Productsup.

Introduction

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

The Standard Replacement list is similar to the Map-Replace rule box. You create a list of terms to replace existing terms in the data feed. This approach ensures that there is always one standard variation of a specific word used in a particular context.

One advantage of using the Standard Replacement list is that you do not duplicate your replacement rules under an account. In other words, you can create a list for a specific feed and use it in other feeds within the same account.

For simple upper or lower case term replacements, use one of the Replacement rule boxes.

Note

Replacement-sensitive rules are case-sensitive and do not return exact matches. The Replacement Sensitive rule box does not replace complete words, as it is not similar to the Text Replace or Map-Replace rule box.

Here are some examples using a text replacement rule:

Search term

Replacement term

banana

apple

ape

gorilla

Original text:

  • The ape eats bananas and grapes.

Result:

  • The gorilla eats apples and grapes.

Set up the Standard Replacement list:

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

    site_lists_page.png
  2. Next, choose Standard Replacement and select Continue.

    new_list_types_stan_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. (Optional) Toggle on the Share list button and select 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

    If you share the list at the account or project level, the platform updates the list during an import from the original site where you created the list.

  5. Select Add.

    add_stand_repl.png

Add terms to the Standard Replacement list

The following example demonstrates how you can replace brand names with standardized terms. Replacement rules give you the option to share your list for replacing terms across all sites in an account or project.

add_terms_stand_repl.png
  • Hewlett Packard replaced HP and H.P.

  • Productsup replaced Products up.

You could do the same for colors and replace unknown or low-volume searched colors with better-known values. For example:

  • magenta > red

  • amethyst > purple

  • bleu De France > blue

  • flame > orange

After adding your Standard Replacement list, see the following to add terms:

  1. Within your newly-created list, enter an existing term that you want replacing in Search with a term you want to replace it with, in Replace term. Select Add to save your terms. Repeat this step as necessary to continue adding values to your Standard Replacement list.

  2. After importing your feed again, your replacement terms now appear in your Standard Replacement list.

Add replacement rule boxes in Data View

Tip

If you manage different retailing sectors, for example, electronics and fashion, you should create other replacement lists for each industry. By separating or segmenting lists, you can define the industry where the Replacement rule box should apply. This approach helps you avoid problems with terms having two different meanings.

For example, HP stands for Hewlett Packard in the electronics industry, while HP could refer to Handley Page in the aircraft industry.

Turning the HP brand into Hewlett Packard using the Replacement rule box

The Replacement rule box

Once you have finished setting up your Standard Replacement list, add the Replacement rule box to your feed attributes in Data View to change their values to the ones specified in the Standard 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 Standard Replacement list from the Select an Option drop-down menu.

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

    The result of applying the Replacement rule box in Data View

The Replacement Sensitive rule box

To define the conditions for value replacement and determine what Productsup should do with the values that don't match your replacement terms, use the Replacement Sensitive box.

  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 Sensitive rule box and select it to add the rule box to the attribute column.

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

  6. Select the Case Sensitive drop-down menu to determine whether the replacement terms should consider the letter case of the values in the attribute column.

  7. Select the Exact Word drop-down menu to decide whether the replacement terms should match the values in the attribute column word for word.

  8. Select the Set value if no match drop-down menu to choose what to do about the values that don't match your replacement terms set in the Standard Replacement list. Set value if no match leaves unmatched values unchanged, while Set empty if no match changes the unmatched values to empty fields.

  9. Select Save. The Replacement Sensitive rule box now uses the specified conditions to change the values in your selected attribute column to the values given in your replacement terms.

    The result of applying the Replacement Sensitive rule box