- 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:
| Symbol | Description |
|---|---|
| + | 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.
| Variables | Example | Description |
|---|---|---|
| Dropdown Text Paragraph File Upload | size | returns value or calculated formula value |
| Single Select Swatch Radio Button | size | returns 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 |
| Number | size size.inputvalue | returns value or calculated formula value returns user input number |
| Date | none | no value or calculation available for date options |
| Instruction | none | no value available for Instruction options but it can calculate a formula and display inline. |
| Lookup | size 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 Tables | sizetable[ ] 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 Price | product_price | returns the price of the product from Shopify |
| Shopify Product Quantity or OPC Quantity Option | product_quantity | returns 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.