Used for:
1. Excluding all items with duplicate identifiers, or;
2. Excluding all but one item with duplicate identifiers. Choose to keep the item with for example the lowest price.
Used in: "THEN"-statements and "ELSE"-statements.
Option 1: exclude items
The option to exclude all items with duplicate identifiers, for example duplicate GTIN codes, is a quick fix rule for deduplication. Most channels do not accept reuse of GTIN codes for different items, because they are meant to be unique identifiers.
With the option to exclude duplicates, you can choose by which field you want to deduplicate your items. The image below shows the example of excluding all items with duplicate values in the id field.
Applying this rule to the example data below, both The Nike Air Max and The Adidas Classic are excluded from the feed, because they have the same id.
id | title |
123 | The Nike Air Max sneaker |
123 | The Adidas Classic sneaker |
654 | The New Balance sneaker |
Option 2: keep lowest of field < field >
In some cases, you would rather keep one of the "duplicate" items. For example, when you know you want to advertise only one variant with the lowest price. The image below explains how to set this up:
To clarify this rule, view the example data below. The two Round Design Tables have different sizes, but the same id. If you want to advertise with the lowest price only, you can use the deduplicate rule to exclude the items with the higher prices.
id | title | price |
234 | The Round Design Table 100x100cm | 650.00 |
234 | The Round Design Table 120x120cm | 750.00 |
234 | The Round Design Table 140x140cm | 850.00 |
653 | The Square Design Table 50x50cm | 500.00 |
This means, after applying the deduplicate rule, the output data looks like the table below:
id | title | price |
234 | The Round Design Table 100x100cm | 650.00 |
653 | The Square Design Table 50x50cm | 500.00 |
Notice that you should tick the "Sort numbers" box if you want to compare numeric amounts. If you want to compare text values, make sure the "Sort numbers" box is not ticked.