How to handle bras
No, this isn't spam despite the title! :o)
Last year I started building a commerce site for lingerie but for various reasons, this got put on hold but is hopefully coming back to life shortly. However, I did get a reasonable distance but I was finding the data load rather taxing. Bras are very similar to T-shirts (honest!). They have sizes and colours but the combinations are enormous. They come in back sizes and cup sizes and different colours so, for example, you get back sizes 28, 30, 32, 34, all the way up to 48, and for each of these you get A, AA, B, BB, C all the way up to J. And every bra comes in, say, black, white and nude. I loaded up some sample data where I had a product for each unique combination: 28A black, 28A white, 28A nude, 28B black etc and each had its image. And remember you get this for each manufacturer and range.
So you can imagine how many different products I had. I tied all of the products in each manufacturer/range to a single product display and it worked well (the add to cart functioned beautifully when, say, a user selected a black bra, the image changed to the black bra). However, this seems overly complex. Despite all the combinations, there are in fact in the example above only three images, selected only by colour.
I recently started looking at OpenCart after a suggestion by a friend and it certainly has a slightly simpler mechanism, allowing images to be associated with options like colour. But again I'd have to have a different set of colour options for each manufacturer/range.
So my question is, is there a relatively easy way to handle this complexity?
Thanks in advance.