Replace feed terms dynamically with the Dynamic Replacement list

Use the Dynamic Replacement list feature, formerly known as Normalization List (URL), to replace existing terms dynamically in your feed via a CSV file upload or URL with Productsup.

Introduction

The Dynamic Replacement list feature is similar to the Standard Replacement list, although it lets you upload a CSV file containing replacement values or import a list file from a URL. See Replace feed terms with the Standard Replacement list for more information on replacement lists.

Set up the Dynamic Replacement list

To set up a Dynamic Replacement list,

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

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

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

Option 1 - Upload a list source file in CSV format

  1. Create a CSV file containing a header since the platform skips the first row. Use a structure similar to the following:

    3d729c0b1564133351ad099d38fdf5f0.jpeg
  2. Next, move your CSV list file to the Drag and drop your CSV file field or select Browse to upload the file.

  3. Select Add.

  4. A message appears stating that the download is in progress.

  5. Once your CSV file completes uploading, you can see your list of defined values under the column Replace term.

  6. If you make changes to the source file, perform an import to update the list.

Option 2 - Add a list source file via a URL

  1. Enter a source file URL in Source URL. To add a Google Sheets list source file, see Add a list source file via Google Sheets and return to this section, step 2.

  2. Enter credentials in Username and Password to access the source file.

  3. In Delimiter, choose the delimiter. The platform selects the tab (\t) as the default.

  4. (Optional) In Encoding, declare the encoding if it is not UTF-8.

  5. (Optional) In Enclosure, choose your desired enclosure, for example, ( ‘’ or ““ or || ).

  6. Toggle on Reset list on every import to remove all data whenever there is an import. When toggled on, it also leaves all configurations unchanged during an import.

  7. (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.

  8. Select Add.

  9. A message appears stating that the download is in progress.

  10. Once your CSV file completes uploading, you can see your list of defined values under the column Replace term.

  11. If you make changes to the source file, perform an import to update the list.

    add_dyna_repl_9.png

Add a list source file via Google Sheets

To add a list file in Google Sheets, you must first modify the URL that leads to your list.

  1. In the URL, replace the text edit with:

    export?format=csv

    If gid exists in the spreadsheet URL, replace it with:

    &gid

    The modified link should look similar to the following example:

    https://docs.google.com/spreadsheets/d/{key}/export?format=csv#&gid={gid}

    • In this example, {key} and {gid} are placeholders.

  2. Make sure the Google Sheets URL is accessible to everyone. Read-only is sufficient. Otherwise, the Productsup platform can't download the Google Sheets file.

    • Test the URL by opening it in a browser. If you set it up correctly, once you hit enter, a CSV download begins.

  3. Now continue with the setup steps in Option 2 - Add a list source file via a URL.

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 Dynamic Replacement list, add the Replacement rule box to your feed attributes in Data View to change their values to the ones specified in the Dynamic 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 Dynamic 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 Dynamic 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 Dynamic 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