Skip to main content

Replace feed terms with the Standard Replacement list

Use the Standard Replacement list feature to replace existing terms in your feed in 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 lets you create an extensive list of terms to replace existing words in the data feed with only one standard variation of a specific term.

Note

To replace just a few terms, you can also use the Map-Replace rule box.

You can create one Standard Replacement list for a specific feed and then use it in other feeds within the same account.

Tip

For only upper- or lower-case replacements, use rule boxes that change word capitalization. See Change capitalization.

Example of a replacement:

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 a Standard Replacement list

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

    Lists in the main menu
  2. Choose Standard Replacement and select Continue.

    new_list_types_stan_repl.png
  3. In Name, give your replacement list a custom name.

  4. To share the list at the account or project levels, toggle on Share list and select:

    • Account level – Share the list with all sites across all projects under this account.

    • Project level – Share the list with all sites under this project.

    add_stand_repl.png

    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 terms to the Standard Replacement list

  1. Enter an existing term you want to replace in Search.

  2. Enter a replacement term in Replace term.

  3. Select Add to save your pair of terms.

    Add replacement term
  4. Repeat the steps to add more terms.

  5. Select Import in the top-right corner of your site's view.

Tip

You may manage different retailing sectors, for example, electronics and fashion, where the same terms may have different meanings. To prevent replacement with the wrong term, you should create separate replacement lists for each industry. When applying the replacement list with the Replacement rule box, you can choose the appropriate list.

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

Add the Replacement rule box in Data View

To apply your Standard Replacement list to the feed, add the Replacement rule box to a feed attribute in Data View:

The Replacement rule box doesn't replace the entire string in the attribute but only changes the parts of the string that match the list terms.

To add the Replacement rule box:

  1. Go to Data View and select the intermediate or export stage from the drop-down menu in the top ribbon.

  2. Select Edit for the attribute where you want to replace terms.

  3. Select the Add Box drop-down menu.

  4. Search for and select the Replacement rule box.

    Replacement rule box
  5. Choose the appropriate replacement list from the Select an Option drop-down menu.

  6. Select Save.