How do I sort data in this case?
I am building my first eCommerce site using MySQL.
This is more of a conceptual question rather than technical.
ProductID 1 (Bolt) - this bolt has 6 different sizes, and a tricky part is only option #6 is in different price.
Option for ProductID 1;
(#1 to #5 are $2, but #6 is $3)
Eventually I'd like to set up the site using eCart. When I do that, I am planning to put dropdown menu so I can save space. And when you choose #6, I'd like the price to be changed as well.
In my limited ability I guessed that an easy way is that separately input #6 as another product, but if possible, I'd like to put this #6 together with others since they are the same products.
I have a feeling this is not what I can do on MySQL, but even so, I'd like to know how to prepare data (in option table) on MySQL so I can eventually make in the way I mentionted. I hope I made my question clear enough...
I really appreciate this forum to solve each questions. Very helpful and educational.
Thank you in advance.