we have a large number of calculations in our SKU product.
Definition of functions and price creation:
- Product (SKU)
- Subproduct (start price in €)
- Variation (corrector as multiplication factor or %)
- Add-ons (fixed in €)
- Quantity as Discount (at 10 pcs 5%, at 20 pcs 7% etc.)
We want to generate a final price of about 20 certain Subproducts depending on about 50 specific Variations (Variations are ranked into 10 price ranges with a simple multiplication factor).
Subproduct 10 have a start price 5,00 €, in next step buyer select in dropdown menu certain …
Variation C or D or any other from 0,4 factor price range = 2,00 € (end price of SKU)
or Variation G or H or any other from 0,8 factor price range = 4,00 € (end price of SKU)
or Variation I or J or any other from 1,0 factor price range = 5,00 € (end price of SKU)
etc. Subproduct 12 have identical price to Subproduct 10 .
Subproduct 14 have a start price 8,00 €, in next step buyer select in dropdown menu certain …
Variation A or B or any other from 0,2 factor price range = 1,60 € (end price of SKU)
or Variation E or F or any other from 0,6 factor price range = 4,80 € (end price of SKU)
or Variation I or J or any other from 1,0 factor price range = 8,00 € (end price of SKU)
etc. for Subproducts 16, 20, 30, 32, 40, 50, 60, 70, 80.
Value of the Variations should not be visible to the customer. Exactly which app (preferably "Free") is capable of processing this calculation method and SKU generating like this: Prod_Variat_Subprod_Add1_Add2_Quant ?