ecommerce - multiple products one image

Soldato
Joined
8 Oct 2005
Posts
4,184
Location
Midlands, UK
Hi,

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


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
sad.gif


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.
 
I'd add a ProductGroup table like this...

Code:
ProductGroup
---------------------------
ProductGroupID
Image
And then you can specify another table which contains the products in this group.

Code:
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.
 
Back
Top Bottom