Morning

I currently manage a rather large web based commerce site selling items of clothing.

Currently we have 'Products' and 'Product Options'. Products maybe something like 'Stripey Sweater', and each product option would be colour. Each colour has its own barcode.

We're looking at adding sizes to the site. 'Stripey Sweater - Blue - Small' would really need to be a different product option to 'Stripey Sweater - Blue - Large'. However ideally I'd need to tie the two together.

I have a few ideas floating around my head, but was just wondering whether anybody could give me some alternatives or suggestions?

Thanks
Jay

size would be another product option

Yes I know, however I need a mechanism to say they're related somehow. Then the user can select a size from a dropdown box. I could either use a pigear approach or a linking table.

product_id should do nicely