I'm creating copies of attribute sets for various products because their marketing color names vary across all the products.
I've done two ranges of products and already I have about 20 attribute sets for 20 configurable products for the sole purpose of listing the right variations of colors for the respective products and I've done about 20% of all products.
I'm sure I'm going about this the wrong way.
It would make more sense to have a table of products and a comma delineated list for each color which is generated in admin when I create a product. This would then mean I have one single configurable product attribute set.
Also there would need to be another table for the filter so that I have a general color list where for each color I have a corresponding comma delineated list of equivalent colors
for eg.
White | "Arctic, Cream. Off White, Snow, Bone"
When white is selected in the filter any corresponding colors from the table would generate a match and the respective products would be displayed.
This should be a relatively common issue yet I've found nothing on the subject. What/Where should I be searching for - What am I missing
Thanks
