I'm trying to build price calculator for print products with a lot variables (size, paper type, binding options, single or double-sided, number of sets, quantities, turnaround and etc.).
Honestly, I don't know where to start. I read articles and watched some videos how to build simple things, but this is much more complicated.
Also, variable information for calculation should be easy to update.
I have an idea how it may work:
1. I have to fill out all possible options of the estimate in the database. (see simple example below).
2. Setup new page with dropdown menus (see below) and connect them to columns (specified with the red shape in the above image).
The mechanic of this estimation process should look like:
To get the price, you have to choose all the options in the dropdown menus. And price will show up from the line in database, where all the specs will match (please see the first image, I specified price in database with the green shape).
Is it even posible?
The only conflict I see here, when the dropdown menus shows all duplicated items from all lines. For example: look at the paper options, each line has either 14pt Coated Cover or 10 pt Uncoated Cover. And this how it may look like on the user side (please see image below).
Is it possible to avoid? Make it look like on image below.
There is no code behind it yet. I just visualized it to explain an idea.
Also, I found something similar on another website.
Dear Wix Corvid Gurus,
Please let me know if I'm going right direction? If not, what is the best way to realize it.
Any information will be very helpful.
Thank you in advance.