I attempting to build a CMS framework with a simple ecommerce solution. Primarily aimed at band merch (t-shirts, hats etc). I’m primarily following the code and concepts used by the Novice To Ninja book
I’m just wondering how to structure the databse to allow the user to add an item that would have a drop down option for size / colour, and have the options customisable by the user.
The only way I can conceive of doing it is via a couple of lookup tables offering options for colour and size respectively. I’m just wondering if theire might be a simpler or accepted way of doing it