ecommerce - multiple products one image

[suarve]

Hi,

It's late an my brain really isn't working as it should

Am doing a ecommerce store and need to have a single image representing 4 different products - the image shows of 4 prouducts.

So on my product detail page I'd have:

- Image
- List of products it represents with buy now links.

This is to basically save the order having to upload the image 4 times and create 4 different products - as he has loads of them.

Basically, I can't get the high level logic sorted in my head - one I can get it sorted I'll be fine

At the min I have a normal product table (prod ID, name, desc, price etc.) and was thinking of adding some sort of 'is multiple' field.

Can anyone post a link or advise how to start this?

Many Thanks

Toodle pip.

 

[GravyMonster]

I'd add a ProductGroup table like this...

ProductGroup
---------------------------
ProductGroupID
Image

And then you can specify another table which contains the products in this group.

ProductGroupContent
---------------------------
ProductGroupContentID
ProductGroupID
ProductID

Doing it this way you can have many Product Groups, and you can have a product in more than one Product Group.

 

[suarve]

Ah cool. That'll work