Similar Products

[dm18k]

I have just downloaded and installed Similar Products to my OSC page.

 

Similar Products--

This contribution provides a box on the Product Info page showing products that are similar to the product in the main part of the page. It pulls the products from the same category as the main product.

 

Is there a way to make Similar Product Tie into your advanced search results?

[dm18k]

I have a small problem, I get this white space before my header name...

 

 

 

I have checked my english.php / column_right.php for spaces..

I added Bold Text for my box Top, Middle, Bottom maybe I didnt put them in the right place...

 

Edit: Bold doesn't work when you are already useing Code :angry:

 

It's mostly right under my nose, but looking at code all day will drive you insane.. a second set of eyes always does wonders!

 

Thank you,

 

<?php

// Set the sort order for the display
?switch(SIMILAR_PRODUCTS_ORDER){
? ?case 'Random': 
? ? ?$sort_order = 'RAND() ';
? ? ?break;
? ?case 'Products ID': 
? ? ?$sort_order = 'p.products_id ';
? ? ?break;
? ?case 'Model Number': 
? ? ?$sort_order = 'p.products_model ';
? ? ?break;
? ?case 'Price': 
? ? ?$sort_order = 'p.products_price ';
? ? ?break;
? ?case 'Date Added': 
? ? ?$sort_order = 'p.products_date_added ';
? ? ?break;
? ?case 'Last Modified': 
? ? ?$sort_order = 'p.products_last_modified ';
? ? ?break;
? ?case 'Products Ordered': 
? ? ?$sort_order = 'p.products_ordered ';
? ? ?break;
? ?case 'Products Name': 
? ? ?$sort_order = 'pd.products_name ';
? ? ?break;
? ?case 'Products Viewed': 
? ? ?$sort_order = 'pd.products_viewed ';
? ? ?break;
? ?default:
? ? ?$sort_order = 'RAND() ';
?} // switch

?switch(SIMILAR_PRODUCTS_SORT_ORDER){
? ?case 'Ascending': 
? ? ?$sort_order .= 'asc';
? ? ?break;
? ?case 'Descending': 
? ? ?$sort_order .= 'desc';
? ? ?break;
? ?default:
? ? ?$sort_order .= 'asc';
?} // switch

// Find the id # of the category that the current product is in
? ?$category_query = tep_db_query("select categories_id 
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? from " . TABLE_PRODUCTS_TO_CATEGORIES . " 
? ? ? ?	where products_id = '" . (int)$_GET['products_id'] . "'"
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?);
? ?$category = tep_db_fetch_array($category_query);
? ?$category_id = $category['categories_id'];

// Select the other products in the same category
? ?$products_query = tep_db_query("select p.products_id, 
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? p.products_price,
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? p.products_model,
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? pd.products_name
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?from " . TABLE_PRODUCTS . " p, ?
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? " . TABLE_PRODUCTS_DESCRIPTION . " pd, ?
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? " . TABLE_PRODUCTS_TO_CATEGORIES . " pc ?
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?where p.products_id = pc.products_id
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?and p.products_id = pd.products_id
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?and p.products_id != '" . (int)$_GET['products_id'] . "'
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?and p.products_status = '1'
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?and pc.categories_id = '" . (int)$category_id . "'
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?and pd.language_id = '" . (int)$languages_id . "'
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?order by " . $sort_order . " 
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?limit " . MAX_SIMILAR_PRODUCTS
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?);
// Write the output containing each of the products
? ?$products_string = '';
? ?$count_products = 0;
? ?while ($products = tep_db_fetch_array($products_query)) {
? if ($products['products_id'] != $_GET['products_id']) {
? ? ? ?$products_string .= '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products['products_id']) . '">';
? ? ?//$products_string .= tep_image(DIR_WS_IMAGES . $products['products_image'], $products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT);
? ? ? ?$products_string .= '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products['products_id']) . '">';
? ? ? ?if (SIMILAR_PRODUCTS_SHOW_MODEL == 'true' && tep_not_null($products['products_model'])) {
? ? ? ? ?$products_string .= $products['products_model'] . '<br>';
? ? ? ?}
? ? ? ?if ((SIMILAR_PRODUCTS_SHOW_NAME == 'true') && tep_not_null($products['products_name'])) {
? ? ? ? ?$products_string .= $products['products_name'] . '<br>';
? ? ? ?}
? ? ? ?if (SIMILAR_PRODUCTS_SHOW_PRICE == 'true') {
? ? ? ? ?$products_string .= $currencies->display_price($products['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '<br>';
? ? ? ?}
? ? ? ?$products_string .= '</a><br>';
? ? ? ?$count_products++;
? }
? ?}

? ?

?>
<!-- similar_products //-->
? ? ? ? ?<tr>
? ? ? ? ? ?<td>
<?php

? ?$info_box_contents = array();
require(DIR_WS_INCLUDES . 'boxes/boxTop.php');
$info_box_contents[] = array('text' => BOX_HEADING_SIMILAR_PRODUCTS);

? ?new infoBoxHeading($info_box_contents, false, false);

?  require(DIR_WS_INCLUDES . 'boxes/boxMiddle.php');
? ?$info_box_contents = array();
? ?$info_box_contents[] = array('align' => 'center',
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'text' => $products_string
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?);

? ?new infoBox($info_box_contents);

require(DIR_WS_INCLUDES . 'boxes/boxBottom.php');
?>
? ? ? ? ? ?</td>
? ? ? ? ?</tr>
<!-- similar_products_eof //-->

Edited September 7, 2005 by dm18k

[Guest]

I have a small problem, I get this white space before my header name...

 

I have checked my english.php / column_right.php for spaces..

I added Bold Text for my box Top, Middle, Bottom  maybe I didnt put them in the right place...

 

Edit: Bold doesn't work when you are already useing Code  :angry:

 

It's mostly right under my nose, but looking at code all day will drive you insane..  a second set of eyes always does wonders!

 

Thank you,

 

<?php

// Set the sort order for the display
?switch(SIMILAR_PRODUCTS_ORDER){
? ?case 'Random': 
? ? ?$sort_order = 'RAND() ';
? ? ?break;
? ?case 'Products ID': 
? ? ?$sort_order = 'p.products_id ';
? ? ?break;
? ?case 'Model Number': 
? ? ?$sort_order = 'p.products_model ';
? ? ?break;
? ?case 'Price': 
? ? ?$sort_order = 'p.products_price ';
? ? ?break;
? ?case 'Date Added': 
? ? ?$sort_order = 'p.products_date_added ';
? ? ?break;
? ?case 'Last Modified': 
? ? ?$sort_order = 'p.products_last_modified ';
? ? ?break;
? ?case 'Products Ordered': 
? ? ?$sort_order = 'p.products_ordered ';
? ? ?break;
? ?case 'Products Name': 
? ? ?$sort_order = 'pd.products_name ';
? ? ?break;
? ?case 'Products Viewed': 
? ? ?$sort_order = 'pd.products_viewed ';
? ? ?break;
? ?default:
? ? ?$sort_order = 'RAND() ';
?} // switch

?switch(SIMILAR_PRODUCTS_SORT_ORDER){
? ?case 'Ascending': 
? ? ?$sort_order .= 'asc';
? ? ?break;
? ?case 'Descending': 
? ? ?$sort_order .= 'desc';
? ? ?break;
? ?default:
? ? ?$sort_order .= 'asc';
?} // switch

// Find the id # of the category that the current product is in
? ?$category_query = tep_db_query("select categories_id 
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? from " . TABLE_PRODUCTS_TO_CATEGORIES . " 
? ? ? ?	where products_id = '" . (int)$_GET['products_id'] . "'"
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?);
? ?$category = tep_db_fetch_array($category_query);
? ?$category_id = $category['categories_id'];

// Select the other products in the same category
? ?$products_query = tep_db_query("select p.products_id, 
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? p.products_price,
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? p.products_model,
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? pd.products_name
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?from " . TABLE_PRODUCTS . " p, ?
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? " . TABLE_PRODUCTS_DESCRIPTION . " pd, ?
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? " . TABLE_PRODUCTS_TO_CATEGORIES . " pc ?
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?where p.products_id = pc.products_id
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?and p.products_id = pd.products_id
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?and p.products_id != '" . (int)$_GET['products_id'] . "'
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?and p.products_status = '1'
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?and pc.categories_id = '" . (int)$category_id . "'
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?and pd.language_id = '" . (int)$languages_id . "'
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?order by " . $sort_order . " 
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?limit " . MAX_SIMILAR_PRODUCTS
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?);
// Write the output containing each of the products
? ?$products_string = '';
? ?$count_products = 0;
? ?while ($products = tep_db_fetch_array($products_query)) {
? if ($products['products_id'] != $_GET['products_id']) {
? ? ? ?$products_string .= '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products['products_id']) . '">';
? ? ?//$products_string .= tep_image(DIR_WS_IMAGES . $products['products_image'], $products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT);
? ? ? ?$products_string .= '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products['products_id']) . '">';
? ? ? ?if (SIMILAR_PRODUCTS_SHOW_MODEL == 'true' && tep_not_null($products['products_model'])) {
? ? ? ? ?$products_string .= $products['products_model'] . '<br>';
? ? ? ?}
? ? ? ?if ((SIMILAR_PRODUCTS_SHOW_NAME == 'true') && tep_not_null($products['products_name'])) {
? ? ? ? ?$products_string .= $products['products_name'] . '<br>';
? ? ? ?}
? ? ? ?if (SIMILAR_PRODUCTS_SHOW_PRICE == 'true') {
? ? ? ? ?$products_string .= $currencies->display_price($products['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '<br>';
? ? ? ?}
? ? ? ?$products_string .= '</a><br>';
? ? ? ?$count_products++;
? }
? ?}

? ?

?>
<!-- similar_products //-->
? ? ? ? ?<tr>
? ? ? ? ? ?<td>
<?php

? ?$info_box_contents = array();
require(DIR_WS_INCLUDES . 'boxes/boxTop.php');
$info_box_contents[] = array('text' => BOX_HEADING_SIMILAR_PRODUCTS);

? ?new infoBoxHeading($info_box_contents, false, false);

? ?require(DIR_WS_INCLUDES . 'boxes/boxMiddle.php');
? ?$info_box_contents = array();
? ?$info_box_contents[] = array('align' => 'center',
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'text' => $products_string
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?);

? ?new infoBox($info_box_contents);

require(DIR_WS_INCLUDES . 'boxes/boxBottom.php');
?>
? ? ? ? ? ?</td>
? ? ? ? ?</tr>
<!-- similar_products_eof //-->

<{POST_SNAPBACK}>

 

Those are just bitmaps that need to be edited or replaced.

[path to catalog]/images/infobox/corner_right.gif

[path to catalog]/images/infobox/corner_left.gif

[path to catalog]/images/infobox/corner_right_left.gif

 

If you have PhotoShop or Paint Shop Pro, you can just edit your Color Palette.

If you still have problems with this, send me a post.

 

L. Jay