How can I apply multiple price calculations (markup, VAT, fees) using conditions?

You can apply multiple price modifications—such as markup, VAT, or fixed fees—by multiplying and adding values inside the Price (Then) field of a price condition.

Examples from real use cases:

• To apply both markup and VAT: 11.13*1.15 (first takes feed price, then applies 13% markup and 15% VAT).

• To add fixed and percentage increases based on a condition (e.g., price < 300): *1 + 7 *1.20 *1.22

• To set tiered rules, create multiple conditions (top to bottom priority) such as:
cost <= 5 → *1.9055 + 3
cost > 5 and cost < 10 → *1.648 + 3
... and so on.

For purchase-price ranges, make each condition mutually exclusive by using matching lower and upper boundaries. For example:

col4_f >= 0 and col4_f <= 100   *2.5
col4_f > 100 and col4_f <= 200  *2.3
col4_f > 200 and col4_f <= 300  *2.1
col4_f > 1000 and col4_f <= 5000 *1.5
col4_f > 5000                  [formula]

Replace col4_f with the actual feed column containing the purchase or cost-per-unit value. Columns are numbered from left to right starting with col1; the _f suffix is used for numeric comparisons. Avoid overlapping ranges and gaps unless they are intentional. Rules are evaluated from top to bottom, so place the most specific or highest-priority rule first and use Any only as the final fallback. A boundary written with >= in more than one rule can cause the earlier rule to capture values intended for another range.

These rules allow full flexibility for combining multipliers, additions, or conditional branching depending on feed values or store values.

Updated on: 23/07/2026