I am setting up a website selling cast iron radiators and have run into an issue and would like to see if there is anyone out there who can solve this for us. Basically we have 25 different radiators and the prices are charged per section from 3 - 30 sections, I accept that we will have to add products for each model and number of sections but the issue arises with the different finishes - there are over 30 different colour finishes which have to be offered as an option and will be charged per section.
So this means 25 radiators x 27 section options x 30 finishes = over 20,000 options.
I am thinking of 2 drop down boxes with a relationship between them, for example select number of section would then populate the drop down finishes box with the prices for the number of sections.
One drop down box for each product but somehow is sensitive to the number of sections in that product and will dispaly the correct prices.
Which one is best?
Please give us your ideas/solutions when replying to this post - we will only respond to those that make an effort to answer our questions