I have a niche site as you know and I'm looking to add multiple colours to advertise the fact that a specific product comes in more than 1 colour.
The only way I have thought about doing it is to add another table to the database and then add the additional colours along with links to the associated products
Database table as follows: -
id products_map_name colour
Am I on the right track or is there an easier way?