[eluser]packetfox[/eluser]
Hello Folks and happy new years,
I am looking for advise on the following Product -> Attribute Problem and how to come up with a sound Database Design:
For each Product in my Database one can assign different attributes (or choices / options)
Example Products:
1. a Hat, no available attributes. Its just a hat.
2. a Shirt, with available attributes
Sizes: Choose from L,XL,XXL
Buttons: Choose Number of Buttons (i.e 1-5) and then for each Button the desired Color;
3. another Shirt, with attributes
Colors: Choose from red, blue or green
And that is the Problem. Not only can the Number of Buttons available for a Product vary, but then they also sort of have attributes themselves, in this case color. Attributes with Attributes..
Id be thankful for any nudge in the right direction!