Skip to main content

Replace feed terms with the Dynamic Replacement list

Use the Dynamic Replacement list feature to replace existing terms dynamically in your feed via uploading a CSV file or URL in Productsup.

Introduction

The Dynamic Replacement list feature lets you create an extensive list of terms to update them dynamically via a CSV file or URL.

Set up the Dynamic Replacement list

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

    Lists in the main menu
  2. Next, choose Dynamic Replacement and select Continue.

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

  4. Choose the way of adding the terms between two (2) options.

    Option 1 - Upload a source file
    1. Create a CSV file with a header and the following structure:

      3d729c0b1564133351ad099d38fdf5f0.jpeg

      Note

      The CSV file must contain a header since the platform skips the first row.

    2. Drag your CSV list file to the Drag and drop a CSV file field, or select Browse to upload the file.

      Dynamic Replacement - Option 1
    3. Select Add at the bottom of the page.

    Option 2 - Add the source URL
    1. Enter a source file URL in Source URL. To add a Google Sheets 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 a delimiter. The platform selects the tab (\t) by default.

      Note

      If you use a Google Sheet as a list source file, choose comma (,) as a delimiter.

    4. Optionally, in Encoding, add the encoding if it isn't UTF-8.

    5. Optionally, in Enclosure, choose a desired enclosure, for example, ( ‘’ or ““ or || ).

      Dynamic Replacement - Option 2
    6. Select Add.

  5. Toggle on Reset list on every import to remove all previous data from the feed after each new import. When toggled on, it also leaves all settings unchanged during an import.

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

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

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

Once the platform uploads your CSV file, the list of defined values appears in the Replace term column.

Note

Whenever you change the source CSV file, select Import to update the list.

Add a list source file via Google Sheets

To add a list file in Google Sheets, you must modify the URL that leads to your list as follows:

  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 the Google Sheets URL accessible to everyone. Productsup can only import publicly accessible sheets. Viewer mode is enough.

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

  3. Continue the setup in Option 2 - Add the source URL.

Add replacement rule boxes in Data View

Add the Replacement rule box

To apply your Dynamic Replacement list to your feed, add the Replacement rule box to your feed attributes 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 a desired Dynamic Replacement list from the Select an Option drop-down menu.

  6. Select Save.

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