[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>