Advanced Selection
Advanced selection allows you to quickly mark or unmark several items in a table that you have stored, for example, in an Excel spreadsheet or in a text document.
This tool enables you to:
You can open the Advanced Selection window via clicking on the icon above the table.
Advanced Selection
Various parameters are set in the advanced selection window:
- In the first selection, you choose from several options that determine what you want to do with the products: add to selection, remove from selection, select exactly, select all except.
- In the second selection, you choose the format in which you have the product attributes listed in the file.
- Only Visible Rows checkbox
- checkbox is checked: the selection will be applied only to the filtered data, i.e. only to visible rows (example here)
- checkbox is unchecked: the selection will be applied to all data regardless of the filters.
- Exact Match checkbox
- checkbox is checked: the selection will only be applied to rows that exactly match the specified value. For example, if you enter Primary ID N0500820 in the values, Quant will select only one product that has ID N0500820 (example here).
- checkbox is unchecked: the selection will be applied to all rows that contain the specified value. E.g. if you enter Primary ID N01 in the values, Quant will select all products that contain this value in their ID (example here).
Only Visible Rows and Exact Match
1. Add to Selection
Use this option if you want to mark several products whose ID or EAN you have in a table or in another document. At the same time, you may already have several products selected in the table and you do not want to deselect them, but only add new products to the selection.
In Quant we have 20 products marked in the table. At the same time, we would need to add another 9 products to these products that we have listed in the Excel spreadsheet under their ID. The procedure is described in the figures below.
Advanced selection
Marked products
2. Remove from Selection
You can use this option if you have marked products in the table and you want to exclude several products whose ID or EAN you have in the table or in another document.
In Quant we have 30 products marked in the table and we need to remove 9 of them from the selection. In the Word document we have the products that we want to remove from the selection - their IDs are separated by semicolons in the row. The procedure is described in the figures below.
Product IDs in Word
Remove from selection
Unmarked products
3. Select Exactly
Use this option if you want to mark several products whose ID or EAN you have in a table or in another document. If you have already marked some products in the table, this action will overwrite the marking and if these products were not listed among the values, the marking in the table will be cancelled.
We have several product IDs listed in the Excel spreadsheet that we need to mark in Quant so that we can, for example, bulk-edit them. The procedure is described in the figures below.
Product IDs in Excel
Select Exactly
Marked products
4. Select All Except
Enter the products you do not want to mark in the values. Quant will then mark all products except those you specify in the values.
This option can be useful in combination with the Only Visible Rows check box when you have several products filtered in the table and want to mark most of them except for a few products.
We have filtered products from the group N0102. There are 446 products in total. From this group we want to select all products except those that contain "N01" in the ID.
Filtered products
Select All Except
Marked products