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.

Note

Also, see Replace feed terms with the Standard Replacement list.

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 the feature is active, the platform resets the list every run deleting all values and then re-importing them into the list.

    • When the feature is inactivate, the platform re-imports the list, adding only new items and ignoring changed or deleted items.

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

    • Account level shares this list with all sites across all projects under this organization.

    • Project level share this list with all sites under this project.

    Note

    If you share the list at the organization 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 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.

  1. Go to Data View from your site's main menu and select Intermediate or a needed export from the drop-down menu on the left side of the upper ribbon.

  2. Select Edit for the needed attribute.

  3. Select the Select an Option drop-down menu, search for and select the Replacement rule box.

  4. Take steps from Replacement.

In this section: