Exclude products with the Dynamic Inclusion/Exclusion list

Exclude product feed exports with the Dynamic Inclusion/Exclusion URL list feature, formerly known as Default List (URL), in Productsup.

Introduction

The Dynamic Inclusion/Exclusion list feature, formerly known as the Default List (URL), lets you define products in your data feed that you want to include or exclude from your export. It's a list containing terms that the Productsup platform accepts or skips when it matches your previously specified words. It works similar to the Skip Row if Value In box rule box, but you can share the list with other sites. And when you modify your data feed, the platform automatically updates the list.

You exclude particular products from feeds by using a list of values, including product IDs. For example, In Germany, food manufacturers face restrictions on which ingredients they can add to their products. To exclude products that contain prohibited ingredients, you can use the Dynamic Inclusion/Exclusion list.

With the Standard Inclusion/Exclusion list, you manually enter all the values used for exclusion. With the Dynamic Inclusion/Exclusion list, you can upload or import a list source file in CSV format via URL containing the values.

This document contains instructions on setting up a Dynamic Inclusion/Exclusion list to exclude products from your feed data.

Set up a Dynamic Inclusion/Exclusion list

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

    site_lists_page.png
  2. Next, choose Dynamic Inclusion/Exclusion and select Continue.

    new_list_types_dyna_incl.png
  3. In Name, give your Inclusion/Exclusion 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:

    csv_file_structure.png
  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 Term.

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

  7. Select Add.

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

  9. Once your CSV file completes uploading, you can see your list of defined values under the column Term.

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

Option 2 - Upload 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. As necessary, 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 Term.

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

    add_dyna_incl.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 in step 2.

Add the Blacklist rule box to exclude products

  1. When you have completed your list, go to Data View from the site's main menu and choose the item you want to blacklist.

  2. Next, select Edit in the column containing the item and add the Blacklist rule box.

    Note

    The Blacklist rule box is not case-sensitive and does not require an exact word match.

  3. In the Blacklist field, choose the newly-created list from the drop-down menu.

    blacklist_box.png
  4. Select Save.

If the terms from your blacklist appear for any item, the blacklist prevents the item(s) from being exported. In Data View, skipped items appear orange. When you hover over them, you can see a displayed message that explains why the blacklist excluded items.