Read the message below and tell us how you can go about it:
It would be great to have a way for customers to find products by colors by adding a "By Color" feature to the menu.
I think this can be done by creating a new database table of "color_groups".
For instance, we could create a color group called "Reds". The "Reds" color group could contain all products with red in them. (for example: red, rose, pink, brick, antique red, etc) We could also create color groups for "Blues", "Greens", "Etc."
IF a product has attribute red, add to "Reds" category
It also would be good to have another submenu under the "Reds" menu that allows the customer to choose the size of their Red item.
To do this we may need to add another field to the product table specifying the size of each product.
So, the customer would go "By Color" > "Reds" > "King" > (All red king products would be shown here at the bottom-level of category menu)
actually, pink should be its own category group, hope you got it. please comment
Require someone who has experience with mysql and oscommerce
No upfront payment till testing is done