Calculating Pricing with Option Add-Ons
We are selling custom books with PowerStore. There are different pricing options that we need to offer. Here is what we want to do:
1. user picks a size, ie> 5x7 photobook
2. user picks their binding option, hard cover or saddle stitch
3. user tells us how many pages are in the book.
price per book is = book size + option uplift + (# pages * price/page)
My thought was to add to the options table an OptionPrice. I also was thinking of adding a ProductPagePrice in the products table for the price/page. But I am confused on how to caclutate the price in the products detail page to automatically reflect the user's selection/input. Can you help me with that?
Also, when I go through the ADMIN option to add options, it looks like is it creating UNIQUE records in many tables (OptionGroups, Options, ProductOptions and Products). I would have thought that the ADMIN tools would be leveraging the value of duplicating unnecessary records in these tables. For instance, when I add "saddle stitch" to a 5x7 book, the admin tools are creating another "saddle stitch" option record again for a 8x10 book. Am I doing something wrong?