Exclude product feed exports with Blacklist (URL)

Exclude product feed exports with Blacklist (URL) in Productsup.

Introduction

The Blacklist feature lets you define the products in your data feed that you want to exclude from your export. It’s a list containing terms that Productsup skips when the defined terms are matched. It works similar to the Skip Row if Value In box, but you can share it with other sites. And if you modify your data feed, the blacklist is automatically updated. This means that you then only need to update the blacklist once for your account.

The Blacklist feature allows you to exclude data feeds by using keywords or a list of product IDs. For example, In Germany, food manufacturers face restrictions on what ingredients they can add to their products. This list allows you to exclude products that contain prohibited ingredients.

You must manually create the Blacklist feature, as it is an individual list.

You can choose between Default List and Default List (URL).

With Default List, you manually enter all the terms. Whereas with Default List (URL), you can import a CSV or TXT file containing all of the used terms in the Blacklist.

Note

The Blacklist is not case sensitive and does not require an exact word match. However, you must enter a complete word to use the Blacklist.

This document contains information about Default List (URL).

Create a Blacklist with Default List (URL)

  1. In a site, select Lists from the main menu, then select ADD A NEW LIST.

    lists_add_new.png
  2. Select Type, choose Default List (URL), then enter a name for your list and select Save.

    lists_add_new_url.png
  3. In the Sharing tab, choose where you want this Blacklist to be visible, in either Site, Project, or Account.

    • Site - The list is only available for this site

    • Project - The list is available for all sites within the project

    • Account - The list is available for all sites within the account

    sharing.png

Add a list file via Google Sheets

To add a list file through Google Sheets, you must first alter the URL that leads to your list. Replace the text that begins with edit, with export?format=csv and add &gid={gid}, in case there is one in your spreadsheet. The modified link should look similar to the following example:

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

In the preceding example, {key} and {gid} are placeholders.

Make sure that the Google Sheets link is accessible to everyone. Read-only is sufficient. Otherwise, the Productsup platform won't be able to download it. Test the link by opening it in a browser. If you set it up correctly, a CSV download begins.

Open the Source tab in your list, and enter the following information to use your Google Sheets list:

  1. Enter the list file source URL in the Source URL field.

  2. (Optional) Enter the username and password.

  3. Confirm that the list file contains a header. The list feature skips the first row in the file regardless.

  4. Enter the delimiter and declare the encoding if it’s not UTF-8.

    list_via_google_sheets.png
  5. 5. You can now select the Import button to begin importing the file. During imports, the platform updates the list each time.

Rename or delete a list

Rename a list by selecting the edit icon located next to the list title. Then enter a new title and save it by selecting the checkmark.

Delete a list by going to the Danger Area tab, then select Delete.

danger_area_def_url.png

Use the Blacklist (URL) in Data View

  1. When you’ve completed your list, go to Data View from the main menu.

  2. Then choose the item, select Edit in the column, and add the Blacklist box.

  3. In the Blacklist field, choose the newly-created list in the dropdown.

blacklist_box.png

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 skipped or excluded items.

List origin

If there is a shared site in a Project or Account, you’ll see the site’s Origin when you view the list for a non-source site. For example,

  • A list originates in site A

  • The shared list is at Account- level

  • A user views the list in site B, where you’ve associated site B with the Account

  • A user sees the site ID origin for site A under Sharing

origin.png