iizzo Posted September 11, 2002 Share Posted September 11, 2002 Is there a way to add related product of an item on the same page as the original Item? Let me explain myself better: lets say I sell a CAMCORDER, now on the same page that I display the CAMCORDER I want to display related pruduct such as lenses for the camera, bags, cables bataries...and whatever.. is it possible? I need an answer ASAP PLEASE!!! Link to comment Share on other sites More sharing options...
mattice Posted September 11, 2002 Share Posted September 11, 2002 There was a solution provided in the old forum (before we moved to this one) They're still available (bottom of Forum Index). Search for 'crossselling' and you'll find it. Mattice "Politics is the art of preventing people from taking part in affairs which properly concern them" Link to comment Share on other sites More sharing options...
iizzo Posted September 12, 2002 Author Share Posted September 12, 2002 Old Forum ??? link where??? Link to comment Share on other sites More sharing options...
Guest Posted September 12, 2002 Share Posted September 12, 2002 1) take the contribution randomize and set it up 2) change the following SQL statement //$sql = "SELECT * FROM `products` ORDER BY RAND() LIMIT 1"; $sql = "SELECT * FROM `products` where products_id = $getproduct "; 3) create something like this: <table align=center width=100%> <tr> <td> <? $getproduct=33; include('randomize.php'); ?></td> <td> <? $getproduct=40; include('randomize.php'); ?></td> <td> <? $getproduct=50; include('randomize.php'); ?></td> </tr></table> This will allow you to include upsell/crossell Now, what has to be done to make this work better? 1) create a table that has the product ID of the product you are displaying and then up to three other product IDs 2) in the bottom of product_info.php add a call to a /include/module that makes a query to the database and then creates a table to be added to the bottom of the page. That part is the simple part. The hard part is creating a module that will allow you to manage the upsell/crosssell linkages through the admin. Link to comment Share on other sites More sharing options...
mattice Posted September 12, 2002 Share Posted September 12, 2002 Old Forum ??? link where??? They're at the bottom of the Forum Index, General Forum and Developers Forum [/b] "Politics is the art of preventing people from taking part in affairs which properly concern them" Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.