Price Management | Filters
The first part of each set of rules consists of none, one or several filters that determine how the price table is to be filtered in order to obtain the desired data.
All filters consist of the following components:
The column to which the filter is to be applied. Enter the filter name here.
Comparison operator: equal to (=), greater than (>), less than (<) etc.
The value with which the column is to be compared.
You will find the filter parameters in the overview of the price records.
Filter types
Filter type | Parameter | Example | Description |
|---|---|---|---|
Simple text filter | Comparative value: Value in quotation marks (double or single) |
PHP
| In this example, records are selected that have the value "net" in the "PriceType" column. |
OR text filter | Separator: | Comparative value: Value in quotation marks (double or single) |
PHP
| In this example, records are selected that have the value "€" or "$" in the "Currency" column. |
Concatenation filter | Separator: -> Comparative value 1: ID of the comparative attribute Comparative value 2: in quotation marks (double or single) |
PHP
| In this example, records are selected that have the value of the "123" attribute in the "Market" column. If the attribute is "123" empty, the value "EU" is set.
When concatenating filters, the value of the attribute with the specified ID is read from the current product. If the attribute is not empty, its value is used for comparison. If the attribute is empty, the next concatenation element is used. The end of the concatenation can either be a string (as in the example) or a keyword. |
Keyword filter | Separator: -> Comparative value: see simple text filter or concatenation filter Possible keywords: NOW, TODAY, TOMORROW |
PHP
| In order to be able to use dynamic values, keywords can be used in queries, which are replaced by other values when the query is performed. Keywords can be recognised by the fact that they are values that are not enclosed in quotation marks. Therefore, it is also important to always use quotation marks for normal values. Otherwise, the parser will assume that it is a keyword. |