Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 ECommerce Database

Author  Topic 

mapidea
Posting Yak Master

124 Posts

Posted - 2009-09-24 : 04:19:08
I am thinking about the steps to be followed to implement the following functionalities into an ecommerce systems.

1. Recommended Products for a Particular Product

I can think of creating a table with ProductID and RecommededProductID. and then displaying on the web page the recommended products for the particular products.

How can we implement the following.

2. Customer who bought this also bought

3. Most viewed Products.

Thanks a lot.
   

- Advertisement -