thanks Ray
no not doing inventory control. It is a site that sells replacement parts for screen pool enclosures and patios.
example of item would be an aluminum panel. item is exactly the same except for the color. i do not know for sure yet, but i think the sku would be different.
if that is the case, then the best way would be just a database row for each sku?
I am trying to think about the display of the items and each item would display just a different color.
A shopper would first be looking for the item and then the color.
I am having a hard time explaining it, but i want it to be easy to shop.