I wonder if anyone has any information on an extension that can handle a cumulative price formula.
My configurable products have a base price (which is entered manually) and 3 attributes. In simple maths, the sales price should be a cumulative multiplication formula:
sale price = base price x metal percentage x width percentage x size percentage
For example, if choosing a product with an initial price of $500, option 1 increment of 50%, option 2 increment of 25% and option 3 increment of 30%
500 x 1.5 x 1.25 x 1.3 = 1,218.75
((500x150/100)*125/100))*130/100 = 1218.75
Can anyone recommend an extension or does this sound like a custom job?
I believe that this Product Price Formula extension for Magento can help to achieve what you need. With the module you are able to use product attributes within conditions and price formulas, as well as control the final price via conditions.
Please, check out the demo here.
Hope this helps!