Filter out certain articles in a report export
In some cases, you might want to filter out certain products from a report export. This is possible through the filter settings of any report. you can add a filter by clicking the “Add new filter” button on the top left of the screen. This will open up a new screen that has two components:
Filters have two parts: the IF-statement ('filter variables') and the THEN-statement ('filter action').
1. The If-statementWith the if-statement in a filter, you can define the range of articles that you would like to select. You can add AND/OR operators to further narrow down the selection of articles. An example:
Note - Please note that you can only select the fields that are configured in the mapping section of this specific report.
2. Include or exclude products
You can select whether articles should be excluded or included.
If you select include this product you only retain the articles that are selected by the if-statement. The articles that do not meet the requirements of the if-statement will be excluded.
If you select exclude this product you'll filter out all articles that meet the requirements of the if-statement.
After defining the If-statement and whether to include or exclude products, press "Save" to save the filter. The filter should now appear in the list.
In this article, you can learn how to test your filter.