Advanced Marking
Advanced marking allows you to mark all items that you have listed, for example, in a table in Excel or in a text document.
This tool enables you to:
You can open the Advanced Marking window via clicking on the icon above the table.
Advanced Marking
Various parameters are set in the advanced marking window:
- In the first selection, you choose from several options that determine what you want to do with the products: add to marking, remove from marking, mark exactly, mark 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 marking will be applied only to the filtered data, i.e. only to visible rows (example here)
- checkbox is unchecked: the marking will be applied to all data regardless of the filters.
- Exact Match checkbox
- checkbox is checked: the marking 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 mark only one product that has ID N0500820 (example here).
- checkbox is unchecked: the marking will be applied to all rows that contain the specified value. E.g. if you enter Primary ID N01 in the values, Quant will mark all products that contain this value in their ID (example here).
- Only Visible Rows checkbox
Only Visible Rows and Exact Match
1. Add to Marking
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 marked in the table and you do not want to unmarked them, but only add new products to the marking.
In Quant we have 6 products marked in the table. At the same time, we would need to add another 6 products to these products that we have listed in the Excel spreadsheet under their ID. The procedure is described in the figures below.
Advanced marking
Marked products
2. Remove from Marking
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 marking. In the Word document we have the products that we want to remove from the marking - their IDs are separated by semicolons in the row. The procedure is described in the figures below.
Product IDs in Word
Remove from Marking
Unmarked products
3. Mark 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
Mark Exactly
Marked products
4. Mark 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 mark all products except those that contain "N01" in the ID.
Filtered products
Mark All Except
Marked products