Using Formulas

Modified on Mon, 22 Jul, 2019 at 3:20 AM

Pricing templates or Formulas allow creating pricing rules in form of formulas, using any numeric fields of the product (such as setting cost, gemstone cost and amount, overhead rate, added value and more)

Create Formulas

  1. Go to Catalog -> Generators -> Formulas
  2. Add new / edit existing Pricing Template (Formula)
  3. In the Formula page
    • set the Formula title
    • create the Formula
      • create any standard mathematical functions
      •  select any of existing numeric product fields
    • Click Save to update the Formula

Apply Formulas

To apply formulas to the products:

  1. Open Catalog
  2. Filter and select the products
  3. Click System Action  -> Calculate Values
  4. In the pop-up "Calculate Values":
    • "Fields to set" - select the price field for the update
      • Only "numeric type fields are displayed
    • Template - select the Formula to apply to the fields
    • "Use price improvements" - the Price Improvements algorithms will be applied for calculated prices if checked.
    • Check "Overwrite" in case of changing existing prices
    • Click Set to update the products
  5. Check the results in the relevant Batch


  1. Keeping "Overwrite" option unchecked allows quickly complete the missing information.
    Run "Calculate Prices" for all products with Overwrite unchecked will skip the products with existing values and update products without values in a "Price to set" field.
  2. For simple calculation of prices, use Price Calculation

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article