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?