Exclude product feed exports with boxes

Exclude product feed exports with boxes in Productsup.

Introduction

Use boxes or lists to exclude items from being exported from your final export data feeds. For example, you can exclude an out-of-stock product that you don’t want being advertised from your Google Merchant Center feed. And when the product is back in stock, you can resume exporting the data feeds back to Google.

Exclude items using boxes

Excluding and whitelisting items from your export feed is a crucial part of data optimization. To accomplish this, there are several boxes that’ll allow you to skip, blacklist, or whitelist items based on a set of conditions. All boxes can be prioritized as necessary by altering their exclusion logic.

Prioritization

You can prioritize all of the Skip, Blacklist, and Whitelist boxes. Enter positive and negative numeric values in the boxes to define which rule has priority, or weight, over another.

At default, boxes are set to 0 priority and Whitelist boxes have the highest priority over other exclusion boxes. Whitelist boxes overwrite Blacklist, Skip, and ROI rules.

Use Case

In this use case, you want to exclude out-of-stock products of a certain brand, but whitelist top-selling products that sell from blacklisted brands.

Problem with not using prioritization:

In Data View, by adding two (2) Skip Row if Value In boxes, one in the brand column and one in the availability column, you could satisfy your blacklist requirements. When adding the Whitelist Row if Value In box for your top sellers, it has more weight than both of the skip boxes. This results in the out-of-stock, top-selling products being included in the feed.

Add prioritization:

  1. Add a Skip Row if Value In box in the brand column. Add the brand names and set the priority to 10.

  2. Add a Whitelist Row if Value In box in the id column. Add the IDs of the products you want to whitelist, even if they are one of the blacklisted brands. Set the priority to 20.

  3. Add a Skip Row if Value In box in the availability column. Add an out of stock box and set the priority to 30.

The higher the priority is, the stronger the box.

Best Practices:

  1. It’s recommended that you leave some space between your priority values if you add prioritized rules in between preexisting rules. Leaving a value of 10 in between two priorities is sufficient.

  2. If you want to make all of your Skip and Blacklist boxes stronger than a Whitelist box, don't update them all. Only change the priority of the Whitelist to a negative value. The other boxes keep the default value of 0, which automatically makes them stronger.

  3. Adding a Comment box to the connection where you added a rule and priority, allows you to review the priorities directly in Dataflow. Remember, the Comment box does not change the feed data, but is solely used for documentation purposes. The Comment box displays speech bubbles in Dataflow, allowing you to see content when hovering over them.

Box Overview

Blacklist

A blacklist is a list of products that are not for export because of specific attributes. You either specify the attributes or an export channel restriction specifies them.

The Blacklist box refers to an individual list that you first need to create in Lists, located in the main menu. The blacklist feature skips all items matching the defined words contained in that list. You can learn more about Blacklists in the following sections:

blacklist_box.png

Negative Blacklist

The Negative Blacklist box helps you define which items to exclude from your export. You must first set up Lists, accessed from the main menu, containing words and terms. The Negative Blacklist box skips all items from the export that don't match one or more given words. This box works similar to the Skip Row If Value Not In box.

Learn more about this feature in the Negative Blacklist document.

negative_blacklist_box.png

Skip multi-condition

Use the Skip Multicondition box to exclude items when two defined conditions are met. Set both conditions by:

  1. Selecting an entry in Column

  2. Selecting a condition in Operator (less/greater than, less/greater or equal, equal/not to, contains/not)

  3. Entering text/numeric values in Value

Note: The items are only skipped if both conditions are met.

skip_multi_box.png

Skip Row By Content Length

Use the Skip Row By Content Length box if the content length is greater than, less than, equal to or is not the compare value you entered.

skip_row_content_length_box.png

Skip Row If Empty

Use the Skip Row If Empty box to exclude items if there is a missing value in a relevant or mandatory field.

skip_row_if_empty_box.png

This box is useful if your item is missing an image, a link, or a price.

Skip Row If Isn't URL

Use the Skip Row If Isn’t URL box to skip items from the export if there is no valid URL in a column.

skip_row_if_isnt_empty_box.png

Skip Row If Match

Use the Skip Row If Match box to exclude items because of certain values in a specific column. This box uses a preg_match. Read about expressions from the Regular Expressions document.

skip_row_if_match_box.png

Example:

Title: Brother DCP 660 CN printer cartridge compatible Lc-1000-Y red

To exclude items compatible with Lc, enter the following regular expression: #compatible Lc#

Skip Row If Not Empty

Exclude items using the Skip Row If Not Empty box if there is a value present. This box exports items with no values in the column.

skip_row_if_not_empty_box.png

Skip Row If Value In

Use the Skip Row If Value In box to exclude an item that has a specific value in the column. You can choose if the match should be broad or exact. Both options allow you to add multiple search terms to this box, one term per line.

Example:

Rocket Science Starter Kit + Apollo 13 (Bundle)

To exclude all bundled items, in the Match field, choose either broad or exact.

Broad match

Broad match skips the item from the export if the column contains the term bundle.

skip_row_if_value_in_box.png

Exact match

If you choose the exact match option, the search term must match the entire string. Use this match for more specific exclusions.

Instead of only searching for Bundle, you must search Rocket Science Starter Kit + Apollo 13 (Bundle) to return an exact match.

Note: Exact match is case sensitive.

An advanced approach using various conditions

To exclude items with a price lower than 10 EUR, as well as out-of-stock items, you can combine the Skip Row If Value In box with the Set Value If Contains box. For example, add all boxes and their assigned values to a separate column for a better overview.

set_value_if_contains_box.png

Note

Get an overview of the excluded items by pausing the Skip Row If Value In box.

Skip Row If Value Not In

Use the Skip Row IF Value Not In box to skip a row from export if one or more values are not in the column. Insert multiple search terms in different lines.

Be certain to select the correct match type, exact or broad.

skip_row_if_value_not_in_box.png

Whitelist

A whitelist is a list of exportable items because of the attributes, terms, or values they contain. The whitelist has the highest priority. This means that any item from the data feed that an ROI Strategy rule, box, or a Blacklist box can exclude, is still exported.

The Whitelist box refers to an individual list that you first create in Lists, which you can access from the main menu. This box detects all defined matching items in that list. Learn more in the Whitelist section.

whitelist_box.png

Whitelist Row If Value In

Use the Whitelist Row IF Value In Row IF Value In box to whitelist specific items, regardless if they’ve been marked for skipping during export because of an ROI Strategy rule, box, or a Blacklist. Use this box if you have a few terms in your whitelist. Insert the terms per line and choose if the match should be exact or broad.

whitelist_row_if_value_in_box.png

Whitelist Row If Value Not In

Use the Whitelist Row If Value Not In box to whitelist specific items, regardless if they’ve been marked for skipping and don’t contain one or more terms. Use this box if you only have a few relevant terms. Insert the terms per line and choose if the match should be exact or broad.

whitelist_row_if_value_not_in_box.png