“Filter” tab

Using filters you can limit the selection of exported product datasets by certain criteria. These are particular product numbers, particular categories or particular attribute values. The filter criterias can even be combined. And you can limit the export to products that match the selected filter criteria or you can exclude them from the export.

Product filter

Using product filters you can limit the export to products with particular product numbers or you can exclude them from the export.

2. Select the product respectively the products. To do so, either use the single search or the list search:
   • Single search:
     1. In order to activate the single search, move the toggle switch to the position.
     2. Enter a product number in the search field. You can also enter item numbers. Even partial numbers are possible. While you enter a number, the products which match the entered sequence of digits appear in the result list.
   • List search:
     1. In order to activate the list search, move the toggle switch to the position.
     2. Enter a list of product numbers in the search field. You can separate the numbers by semicolons or line breaks. While you enter the numbers list, the products respectively items which match a number from the entered list appear in the result list.

4. In the result list, tick the product. You can also tick multiple products. In this case, multiple product filters are created. It is even possible to tick individual items in order to create filters for the superordinate products*.

• In order to finish the process, click on the ACCEPT button. If the process was successful, a corresponding message appears. The product filter(s) is/are now set up.
• In order to cancel the process, click on the CANCEL button.

* You can tick individual products, but the filters are created for the superordinate products. Filters for individual items can not be set up.

Enter names

You can enter names for each product filter. To do so, proceed as follows:

1. In the row of the respective product filter, double-click in the table cell of the “Name” column.
2. Enter a name and leave the table cell.
3. Possibly enter names for further product filters.

• In order to save your input, click on the SAVE button. If the process was successful, a corresponding message will appear.
• In order to cancel the process, click on the RESET button.

1. In the row of the respective product filter, double-click in the table cell of the “Whitelist” column.
2. Make the desired setting:
   • To include the respective product in the export, select the option YES from the menu.
   • To exclude the respective product from the export, select the option NO from the menu.
3. Leave the table cell.

• In order to save your selection, click on the SAVE button. If the process was successful, a corresponding message will appear.
• In order to cancel the process, click on the RESET button.

• When creating a product filter, the option “NO” is set by default. Thus, if you want to exclude the respective product from an export, no further settings need to be made.
• Using the “INVERT VALUES” button you can change multiple product filters at once. To do so, tick the respective filters and click on the “INVERT VALUES” button. Following this, the chip in the “Whitelist” column changes. Then click on the “SAVE” button to save your changes.

Delete product filters

In order to delete a product filter, proceed as follows:

1. In the table, tick the product filter you want to delete. You can also tick multiple entries.
2. Click on the DELETE button in the footer.
   The CLICK TO CONFIRM button is shown.
3. Click on the CLICK TO CONFIRM button to confirm the deleting of the product filter.
   A success message is shown.

Category filter

Using category filters you can limit the data export to products from particular categories or you can exclude products from particular categories from the export.

1. Click on the CREATE button in the footer of the “Category filter” card to call up the corresponding dialog box.
2. In the directory structure, tick a category. You can also tick multiple categories.

• In order to finish the process, click on the SAVE button. The category filter is now created and it appears in the table of the “Category filter” card.
• In order to cancel the process, click on the CANCEL button.

If you ticked multiple categories, a separate category filter for each category is created.

Enter names

You can enter names for each category filter. To do so, proceed as follows:

1. In the row of the respective category filter, double-click in the table cell of the “Name” column.
2. Enter a name and leave the table cell.
3. Possibly enter names for further category filters.

• In order to save your input, click on the SAVE button. If the process was successful, a corresponding message will appear.
• In order to cancel the process, click on the RESET button.

Include or exclude categories

Via the setting in the “Whitelist” column you can specify for every category filter if products from the respective category are included or excluded from the export:

1. In the row of the respective category filter, double-click in the table cell of the “Whitelist” column.
2. Make the desired setting:
   • To include the products of the respective category in the export, select the option YES from the menu.
   • To exclude the products of the respective category from the export, select the option NO from the menu.
3. Leave the table cell.

• In order to save your selection, click on the SAVE button. If the process was successful, a corresponding message will appear.
• In order to cancel the process, click on the RESET button.

• When creating a category filter, the option “NO” is set by default. Thus, if you want to exclude products of the respective category from an export, no further settings need to be made.
• Using the “INVERT VALUES” button you can change multiple product filters at once. To do so, tick the respective filters and click on the “INVERT VALUES” button. Following this, the chip in the “Whitelist” column changes. Then click on the “SAVE” button to save your changes.

Delete category filters

In order to delete a category filter, proceed as follows:

1. In the table, tick the category filter you want to delete. You can also tick multiple entries.
2. Click on the DELETE button in the footer.
   The CLICK TO CONFIRM button is shown.
3. Click on the CLICK TO CONFIRM button to confirm the deleting of the category filter.
   A success message is shown.

2. Optional: Enter a search term in the search field to filter the list of attributes by a search term.
3. Select the attribute by transfering it from the left column to the right column . To do so, click on the attribute .
   Possibly use the text search to filter the list of attributes by a search term.
4. Click on the ACCEPT button to create the attribute filter.The dialog box closes and the new attribute filter appears in the table of the “Attribute filter” card.

4. Specify a filter value:
   1. In the row of the respective attribute filter, double-click in the table cell of the “Value” column .
   2. Enter the filter value and leave the table cell.
5. Click on the SAVE button to save your input.

6. Specify a filter condition:
   1. In the row of the respective attribute filter, double-click in the table cell of the “Condition” column .
   2. From the menu, select a filter condition:
      • equals: The export is limited to products where the value of the selected attribute equals the filter value.
      • not: The export is limited to products where the value of the selected attribute does not equal the filter value.
      • greater than: The export is limited to products where the value of the selected attribute is greater than the filter value.
      • lesser than: The export is limited to products where the value of the selected attribute is smaller than the filter value.
      • not exists: The export is limited to products where the attribute does not possess a value (since version 5.6.4).
      • not empty: The export is limited to products where the attribute has any given value (since version 5.6.4).
7. Click on the SAVE button to save your selection.

The attribute filter is now created and set up.

The filter conditions “greater than” and “lesser than” only work for numerical values.

Delete attribute filters

In order to delete an attribute filter, proceed as follows:

1. In the table, tick the attribute filter you want to delete. You can also tick multiple entries.
2. Click on the DELETE button in the footer.
   The CLICK TO CONFIRM button is shown.
3. Click on the CLICK TO CONFIRM button to confirm the deleting of the attribute filter.
   A success message is shown.

Action menu

Via the action menu in the footer you can apply different actions on the listed filters. To do so, proceed as follows:

• To call up the action menu, click on the "Action menu" icon () in the footer.
• To invert the selection of ticked table cells, click on the "Invert selection" option of the action menu.
• To export selected filters as a .xlsx or .csv file, use the "Export" action. Further information you can find here.
• To copy selected filters to the clipboard, use one of the "Clipboard" actions. Further information you can find here.

FAQ

What are filters used for in the datafeed export?

Using filters you can limit the selection of exported product datasets by certain criteria. The filter criteria are particular product numbers, particular categories, or particular attribute values. You can limit the export to products that match the selected filter criteria, or you can exclude them from the export.

Can different filter criteria be combined?

Yes, product filters, category filters, and attribute filters can be combined. The filter criteria can even be combined to narrow down the selection of exported product datasets even further.

What are the radiobuttons under “Data levels” used for in the product selection dialog box?

Via the radiobuttons you can select a data level. By this, you can choose whether the result list shows either products or items. Your selection does not have any effect on the search itself.

What happens if I tick individual items instead of whole products in the result list of the product selection dialog box?

You can tick individual items, but the filters are created for the superordinate products. Filters for individual items can not be set up.

What happens if I select multiple products at once in the product selection dialog box?

If you tick multiple products, multiple product filters are created. In this case, one filter is created for each selected product.

What happens if I tick multiple categories at once?

If you ticked multiple categories, a separate category filter for each category is created.

What can be limited using an attribute filter?

Using attribute filters you can limit the export to products where certain attributes have particular attribute values: where a selected attribute has a particular filter value, does not have it, or where the value of the attribute is smaller or greater than the filter value.

Which filter conditions are available for attribute filters?

The following conditions are available: equals (the value of the selected attribute equals the filter value), not (the value does not equal the filter value), greater than, lesser than, not exists (the attribute does not possess a value), and not empty (the attribute has any given value). The conditions not exists and not empty are available since version 5.6.4.

Why do some conditions not work as expected for certain attributes?

The filter conditions greater than and lesser than only work for numerical values.