Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Related Products


iizzo

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

Link to comment
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"

Link to comment
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.

Link to comment
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"

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...