You are here: Formula editor for own data fields or product filters
You can find out how to create a new data field here.
The formula editor allows you to create complex data manipulations and filter rules. This allows you to respond to all market requirements with customized data records and product feeds.
... for own data fields
In the formula editor, you will find three different areas where you can select the necessary parameters and enter a formula.
Once you have given your data field a name, you will be taken to the formula editor.
If you want to change the name, click on the cogwheel in the top right-hand corner.
Change the name and click on "Save".
Selecting the "Reference data field"
By selecting the "Reference data field", you define the data fields used in the formula. You can select any number of data fields to use in the formula.
Once you have selected your "Reference data field", it will appear on the left-hand side of the screen. Here you can immediately see which data field is being referred to and also which feed this data field comes from.
You can find out how to select the "Reference data field", what you need to bear in mind and everything important about the "Reference data field" in this article.
Formula input
In the formula area, you can use operators and parameters to create your formula while adhering to the syntax specifications.
If you click on the arrow of the functions, you can display the available functions. If you move the mouse over the corresponding function, a description appears to the right of it.
It briefly describes what this function can be used for, gives one or more examples, and provides information on how the syntax must be structured in order to make the function return a valid result.
An overview of all functions and the syntax to be observed can be found here.
Double-click on the corresponding function to transfer it to the input field. The next step is to enter the parameters (i.e. the data fields you have selected), but you can also enter your own more complex formulas.
When entering formulas, please note that the spelling of the selected parameters must correspond exactly to the spelling in the "Reference data fields". If the spelling is correct, the color in the formula changes to blue.
Further information on formula input can be found here.
... for filters
When you create a filter, you must use the formula to formulate conditions that your products can fulfill. The result of a filter is TRUE if the product fulfills the conditions, or FALSE if it does not fulfill the conditions. This is mainly done using comparative or include/exclude operators. The result is a list of products that fulfill the conditions.
Whitelist: Products that fulfill the conditions of the filter are included/"displayed".
Blacklist: Products that fulfill the conditions of the filter are excluded / "not displayed".
Selecting the "Reference data field"
By selecting the "Reference data field", you define the data fields used in the formula. You can select any number of data fields to use in the formula.
Once you have selected your "Reference data field", it will appear on the left-hand side of the screen. Here you can immediately see which data field is being referred to and also which feed this data field comes from.
You can find out how to select the "Reference data field", what you need to bear in mind and everything important about the "Reference data field" in this article.
Formula input
In the formula area, you can use operators and parameters to create your formula while adhering to the syntax specifications.
If you click on the arrow of the functions, you can display the available functions. If you move the mouse over the corresponding function, a description appears to the right of it.
It briefly describes what this function can be used for, gives one or more examples, and provides information on how the syntax must be structured in order to make the function return a valid result.
An overview of all functions and the syntax to be observed can be found here.
Double-click on the corresponding function to transfer it to the input field. The next step is to enter the parameters (i.e. the data fields you have selected), but you can also enter your own more complex formulas.
When entering formulas, please note that the spelling of the selected parameters must correspond exactly to the spelling in the "Reference data fields". If the spelling is correct, the color in the formula changes to blue.
Further information on formula input can be found here.
If you want to change the name or the listing, click on the cogwheel in the top right-hand corner. There you can also see, which kind of listing the filter is currently running.
Change the name and / or the listing and then click on "Save". Your changes will be applied immediately and synchronized in the background.
