Jump to content

Archived

This topic is now archived and is closed to further replies.

iizzo

Related Products

Recommended Posts

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

Share this post


Link to post
Share on other sites

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"

Share this post


Link to post
Share on other sites

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.


The king of kluge...

? Do you really know what is and isn't working in your store? ≡ ?

Share this post


Link to post
Share on other sites
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"

Share this post


Link to post
Share on other sites

×