The Pro Bulk Price Editor features a built-in Formula Builder that lets you perform complex, custom pricing adjustments using mathematical operations, product properties, and functions.
Example Formula: (cost_per_item * 1.5) + (item_weight * 0.5)
Supported Variables
Variable Name | Description | Example Use |
|---|---|---|
| The current selling price of the product variant. |
(10% increase) |
or
| The compare-at (original, pre-discount) price, or current selling price when an active discount exists. |
(20% off original price) |
| The cost price of the item variant set in Wix. |
(30% markup on cost) |
| The weight of the product variant. |
(weight-based markup) |
Notes:
- If a variable value is missing or not set in Wix (such as cost price), it defaults to 0 at execution time.
- Calculated prices are clamped to a minimum of 0 (prices cannot be negative).
Supported Functions
Function Name | Description | Examples |
|---|---|---|
MOD(number, divisor) | Returns the remainder after dividing a number by a divisor. |
returns 3 .
|
RANDOM(min, max) | Generates a random integer value between min and max (inclusive). |
Returns a random value between 5 and 15.
|
Tip: Need support for a specific mathematical function or product property? Reach out to our support team, and we will be happy to evaluate adding it for you!