Conditional Pricing (Premium)

Written By Floris de Vries

Last updated 3 days ago

Premium feature
Conditional formulas are available on premium plans.

Conditional formulas allow you to apply if / then / else logic to your pricing. This makes it possible to calculate prices differently based on customer input, thresholds, or selected options.


What are conditional formulas?

A conditional formula evaluates one or more conditions and applies a formula only when those conditions are met.
If none of the conditions match, a default (else) formula is used.

This allows you to create advanced pricing rules such as:

  • Tiered pricing

  • Surcharges above certain values

  • Minimum or maximum pricing

  • Option-based logic


Structure of a conditional formula

A conditional formula consists of:

  1. One or more conditions

  2. A Then formula (applied when the condition is true)

  3. An Else (default) formula (applied when no conditions match)

Conditions are evaluated from top to bottom.


Conditions

Each condition is built using variables, comparison operators, and optional math operations.


Available comparison operators

You can use the following comparison operators to define conditions:

  • is greater than

  • is less than

  • is greater or equal

  • is less or equal

  • is equal to

  • is not equal to

These operators are used to compare two values.


Logical operators

To combine multiple rules in a single condition, you can use:

  • AND (all must be true)
    โ†’ All comparisons must be true for the condition to match

  • OR (at least one true)
    โ†’ At least one comparison must be true for the condition to match


Variables in conditions

Conditions can reference:

  • Form field values (from Step 1)

  • Product price or variant price

  • Boolean values (TRUE, FALSE)

Example:

width > 200 AND height > 150 

Then formula

The Then formula defines the price calculation that will be applied when the condition is true.

The same rules apply as for regular formulas:

  • Must return a numeric value

  • Can use all variables

  • Can include rounding helpers

Example:

(product_price + area * 1.2) 

Else (default) formula

The Else formula is applied when none of the conditions match.

This formula is required and acts as a fallback to ensure a price is always calculated.

Example:

product_price + area 

Multiple conditions

You can add multiple conditions using Add condition.

Important behavior:

  • Conditions are evaluated in order

  • The first matching condition is applied

  • Remaining conditions are ignored

This allows you to create tiered logic, such as:

  1. Large size pricing

  2. Medium size pricing

  3. Default pricing


Switching between formula modes

You can switch between:

  • Single formula

  • Conditional formulas (Premium)

Switching back to a single formula will disable conditional logic and use one formula for all cases.


Common use cases

  • Higher price for large dimensions

  • Extra fee when a specific option is selected

  • Minimum price enforcement

  • Different pricing per quantity range


Best practices

  • Keep conditions simple and readable

  • Test conditions from top to bottom

  • Avoid overlapping condition ranges

  • Always define a safe default formula

  • Test with realistic values using preview mode


๐Ÿ’ก Tip:
If your pricing logic starts to feel complex, conditional formulas help keep calculations readable and maintainable.