Skip to main content
Product variables use formulas to compute new values from existing product data. Unlike other variable types, these aren’t static — they recalculate per product based on that product’s fields. Set them up on the Products tab in Settings > Content Logic.

How to use them

  1. Add a variable — Give it a label, key, and formula.
  2. 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.
  3. Check the preview — The live preview shows the formula resolved with sample data.
  4. 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:
round({{product.price}} * 1.21 * 100) / 100
Result: €129.99 → €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:
round(({{product.price}} - {{product.cost}}) / {{product.price}} * 100)
Result: Price €129.99, Cost €75.00 → 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:
round({{product.price}} / {{product.weight}} * 100) / 100
Result: €2.45 / 0.085 kg → €28.82/kg

4. Display name with SKU and brand

Build a standardized display name for exports and catalogs. Formula:
{{product.brand}} — {{product.name}} ({{product.sku}})
Result: 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):
round(({{product.price}} - {{product.special_price}}) * 100) / 100
Result: €30.00 Formula (savings percentage):
round(({{product.price}} - {{product.special_price}}) / {{product.price}} * 100)
Result: 23%

6. Volume / dimensional weight

Calculate the volumetric weight for shipping cost estimation. Formula (volume in cm³):
{{product.length}} * {{product.width}} * {{product.height}}
Result: 50 × 17 × 17 → 14450 cm³ Formula (dimensional weight in kg, using 5000 divisor):
round({{product.length}} * {{product.width}} * {{product.height}} / 5000 * 100) / 100
Result: 2.89 kg

7. Minimum selling price based on target margin

Calculate the floor price that maintains a minimum margin. Formula:
round({{product.cost}} / (1 - 0.30) * 100) / 100
Result: Cost €75.00, Target margin 30% → €107.14 Change 0.30 to your desired minimum margin.

8. Stock value (cost × quantity)

Calculate the inventory value per product for reporting. Formula:
round({{product.cost}} * {{product.stock_quantity}} * 100) / 100
Result: Cost €2.45, Stock 500 → €1225.00

9. Formatted product specifications string

Build a standardized specs line from multiple fields. Formula:
concat({{product.weight}}, " ", {{product.weight_unit}}, " | ", {{product.length}}, "×", {{product.width}}, "×", {{product.height}}, " ", {{product.dimension_unit}})
Result: 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:
round({{product.cost}} * 1.60 * 100) / 100
Result: Cost €75.00, 60% markup → €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)/100 to 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.