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

[Lee]

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]