How to use them
- Add a variable — Give it a label, key, and formula.
- Build the formula — Use
{{product.field}}references, arithmetic operators, and math/text functions. Use the Insert Field and Insert Operator buttons, or type{{for autocomplete. - Check the preview — The live preview shows the formula resolved with sample data.
- Reference in content — Use
{{product.your_key}}anywhere variables are supported.
Available operators and functions
Arithmetic
+ (add), - (subtract), * (multiply), / (divide), % (modulo), ( ) (grouping)
Math functions
round(), floor(), ceil(), min(,), max(,), abs()
Text functions
concat(,), uppercase(), lowercase()
To use an operator as literal text, escape it with a backslash: S\/M\/L renders as “S/M/L”.
Use case examples
1. Price including VAT
Calculate the VAT-inclusive price from the base price. Formula:€157.29
Use 1.21 for 21% VAT, 1.09 for 9%, etc. The round(...*100)/100 pattern ensures two decimal places.
2. Profit margin percentage
Calculate and display the margin as a clean percentage. Formula:42%
Reference as {{product.margin_pct_display}} in internal reports or data quality checks.
3. Price per unit weight
Useful for B2B catalogs where buyers compare price-per-kg or price-per-unit. Formula:€28.82/kg
4. Display name with SKU and brand
Build a standardized display name for exports and catalogs. Formula:Fischer — Stainless Steel Hex Bolt M10x50 (SS-HB-M1050)
5. Savings amount and percentage for promotions
Calculate the actual discount for products on sale. Formula (savings):€30.00
Formula (savings percentage):
23%
6. Volume / dimensional weight
Calculate the volumetric weight for shipping cost estimation. Formula (volume in cm³):14450 cm³
Formula (dimensional weight in kg, using 5000 divisor):
2.89 kg
7. Minimum selling price based on target margin
Calculate the floor price that maintains a minimum margin. Formula:€107.14
Change 0.30 to your desired minimum margin.
8. Stock value (cost × quantity)
Calculate the inventory value per product for reporting. Formula:€1225.00
9. Formatted product specifications string
Build a standardized specs line from multiple fields. Formula:0.085 kg | 50×17×17 mm
10. Markup-based selling price from cost
Calculate the selling price by applying a fixed markup to cost. Formula:€120.00
Tips
- The live preview uses sample values to show how your formula will resolve — check it before saving.
- If a referenced field is empty, the formula resolves to an empty string and math won’t compute. Make sure the fields you reference have values.
- Use
round(...*100)/100to get clean two-decimal results for pricing formulas. - Computed product variables can reference other computed variables, global variables, brand variables, and category variables in their formulas.

