Page 1 of 1

Webshop Question

Posted: Mon Jan 20, 2003 9:54 am
by wizzard81
Hi

I'm working on a php webshop but i have a question i saw on some sites like this here: http://www.soundsonline.com/sophtml/det ... =TASCD-120

A right column with bundle offers. Does anyone knows how i can program something like this that some products have bundle offers?

Another questions i have is i'm looking for a function to see the most bought products. If someone can helps me?

Cheers
Kris

Posted: Mon Jan 20, 2003 11:56 am
by wizzard81
anyone?

Posted: Mon Jan 20, 2003 12:03 pm
by volka
where any how do you store the shopping info?

Posted: Mon Jan 20, 2003 12:08 pm
by wizzard81
what do you mean.

I store everything in table products, orders

Posted: Mon Jan 20, 2003 12:38 pm
by puckeye
You might want to create another table which will hold the product ids of the product you wish to bundle.

Each row in this new table could represent a bulndled product with fields for internal id (autoincrement) bundle id, product id, discount price (and more).

You would then have at least 2 rows for each bundle. It could look like the following:

id = 0 internal id
bundle_id = 0 Bundle id
product_id = 12 Product id
price = 24.95 Price of this product while bundled

id = 1
bundle_id = 0
product_id = 23
price = 22.95

This would produce a bundle (id 0) with 2 products (id 12 and 23) with a bundled price of 47,90$.

Of course there are many more ways to do this but this should give you a few ideas.