[Top] [All Lists]

Re: "Up-selling" "People who looked at x also looked at..."

Subject: Re: "Up-selling" "People who looked at x also looked at..."
From: "darrel"
Date: Fri, 13 Jul 2007 11:23:10 -0500
Newsgroups: macromedia.dreamweaver.appdev
> Unfortunately, I've never done a "count" in a database. What's the basic 
> concept behind that? I use MS SQL & asp.

Well, when a transaction for a purchase of a product is completed, I'd do a 
DB call to update a table that tracks units sold. It could be as simple as:

table: sales count
productID | productCategory | unitsSold
001           | cat23                  | 24

So, then product 001 is sold, query the 'sales count' table for that item, 
add one to the unitsSold value, then update the table.

THEN, query the same table using a WHERE statement to pull up the top 10 
products listed in this table sorted by unitsSold (in descending order) that 
have the same productCateogory. Using a JOIN statement, you can then get the 
product details from the PRODUCT table and then list these as "other popular 
items in this category" and display that to the end-user.

That's just one way to do it. I'm sure you could do this a number of ways.


<Prev in Thread] Current Thread [Next in Thread>