Option Set Calculations

  • Automatically Add Option Values:
    When Automatically Add Option Values is Checked, the application will add all values for all options within the option set together and set the products price.

    When Automatically Add Option Values is Unchecked, you can write your own custom formula for the option set. Any option that is part of the option set, will be available for use in the calculation. The value returned from this calculation will be the final price of your product.

You can use any of the following mathematical expressions in a calculation:

SymbolDescription
+Addition
Subtraction
*Multiplication
/Division
( )Open and close parenthesis
All Functions below are only available for Elite Plan only
math.round(x,n)Round a value towards the nearest integer.

x = Number to be rounded
n = Number of decimals.

https://mathjs.org/docs/reference/functions/round.html
math.abs(x)Calculate the absolute value of a number.

x = Number for which to get the absolute value

https://mathjs.org/docs/reference/functions/abs.html
math.ceil(x,n)Round a value towards plus infinity.

x = Number to be rounded
n = Number of decimals.

https://mathjs.org/docs/reference/functions/ceil.html
math.exp(x)Calculate the exponential of a value.

x = Number to exponentiate

https://mathjs.org/docs/reference/functions/exp.html
math.pow(x, y)Calculates the power of x ^ y.

x = The base
y = The exponent

https://mathjs.org/docs/reference/functions/pow.html
math.sqrt(x)Calculate the square root of a value.

x = Value for which to calculate the square root.

https://mathjs.org/docs/reference/functions/sqrt.html
math.square(x)Compute the square of a value, x * x

x = Number for which to calculate the square

https://mathjs.org/docs/reference/functions/square.html

All Formulas will follow BEDMAS.

Brackets – First Priority
Exponents – Second Priority
Division – Third Priority
Multiplication – Third Priority
Addition – Fourth Priority
Subtraction – Fourth Priority

Calculation Variables allow you to insert other options, lookup tables and product variables in to the formula.

Below is a list of all option variable types available

Example column shows how an option named “size” would be included in a calculation or formula.

VariablesExampleDescription
Dropdown
Text
Paragraph
Email
File Upload
sizereturns value or calculated formula value
Single Select
Swatch
Radio
Button
sizereturns value or calculated formula value
Multi Select
Swatch
Radio
Button
size
size.selectedcount
returns value or calculated formula value
returns the number of items selected
Numbersize
size.inputvalue
returns value or calculated formula value
returns user input number
Datenoneno value or calculation available for date options
Instructionnoneno value available for Instruction options but it can calculate a formula and display inline.
Lookupsize
size.input1
size.input2
returns the number found in associated pricing table
returns user input number for input 1
returns user input number for input 2
Lookup Tablessizetable[ ]
sizetable[ 25, 55 ]
sizetable[size.input1,size.input2]
sizetable[variable, 20]
sizetable[variable, variable]
sizetable[6*variable, 30]
returns the number found in the pricing table (sizetable) based on the values provided in the brackets [ ]
Can accept another option variable or calculation as inputs.
Shopify Product Priceproduct_pricereturns the price of the product from Shopify
Shopify Product Quantity
or
OPC Quantity Option
product_quantityreturns the quantity in the product page quantity selector
Shopify Metadata metadata01
metadata02
metadata03
metadata04
metadata05

metadata01
metadata02
metadata03
metadata04
metadata05
returns the value set from the option block settings. could be any product meta data.


Writing a calculation formula

To write a formula enter a combination of variables, mathematical expressions and your own number inputs.