Dislplay related products

This message was sent from: Suggestions and Proposals
http://forums.oscommerce.com/viewtopic.php?p=180302#180302
----------------------------------------------------------------

We'd like to be able to display products in a box like the whats_new.php box that are related to the current product page displayed instead of cycling through "new" or "all" products.

For example, we might have products that have add-ons or accessories that could be bought at the same time if the customer knew about them. If one arrives at a product page and the box displays an accessory for that product, we feel that would be a good upsell opportunity.

I have an idea or two for doing this. It would require a table of product associations, and the info box code would retrieve the rows (consisting of producs ids) from that table that match the product id of the displayed page and then take one of them at random to show in the box. Perhaps if not on product page, then the whats_new box code could be used.

Anyone like this idea? I am almost ready to dive in to code this.