Blog

Using formulas to calculate price for each option

Posted by:

You are here:
< Back

There are many fields (like checkboxes and dropdowns) where you can set a fixed value for each item

But you can also use formulas to change the price of each item dynamically, to do se follow these steps:

1.- Select the price type “Formula Per Item”

2.- Define the formula

3.- That’s it now each option will use that formula to calculate its price

Using options information

If you want you can also use the information of each item using the special field “Current Option”

This special field will let you use each option price or any additional column that you configure for each option.

So for example, if you define a price for each option like in the screenshot:

And you use a formula like this:

The price of each item will be its original price (10,20 and 30 respectively) plus the value of the “Number” field (which is just a field that i added to do the example)

And here is the result (notice how each option price changes when i change the value of the number field)

0

About the Author:

Im programmer working for an international company. I have programmed since i was 12 and i have done it professionally for 6 years. Programming for a company is fun and i have learned a lot of things but i have always been interested in running my own business so i decided to give it a shot doing what i do best, programming stuffs.
  Related Posts
  • No related posts found.