macromedia.dreamweaver.appdev
[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: Lee
Date: Thu, 12 Jul 2007 16:16:02 -0500
Newsgroups: macromedia.dreamweaver.appdev


We do that somewhat already but it could, of course, be improved.

Or fake it. Have the marketing types put together a list of things they'd like you to push (product300 -> product1421; product2 -> product87; ...). Then when you throw a page, look in marketing's database for what else to promote on the page. It would be a simple table (prodprod), just two columns (product1 and product2). You'd then do a query similar to:

SELECT p2.productDescription, p2.productPrice
FROM prodprod JOIN products AS p2 ON prodprod.product2 = p2.productNum
WHERE prodprod.product1 = [visitor's selected product]


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