[contribution] Category & Manufacturers name in Product_Info Page

edtiger · March 10, 2006

the contribution can be found here:

Category & Manufacturer's name in Product_Info Page

AntiqueStoreBuilder · March 12, 2006

the contribution can be found here:
Category & Manufacturer's name in Product_Info Page

Is there any easy way for me to create a link to the category in product_info? (Similar to how it's done in the header). I'm trying to leverage the "no buy button if quantity = 0" contrib (contrib 3703) so that if the product quantity = 0, rather than just hide the buy button (which is what the original contrib does), it says something like "Product Sold Out, but you can browse more items in the [CategoryName] category."

Using this contrib I've gotten the category name to display correctly, but am beat down to a pulp when I try to figure out how to generate the associated tep_href_link.

Any help would be appreciated - realize this is somewhat unreleated to this contrib itself but hope it's within the realm of requesting assistance.

Edited March 12, 2006 by AntiqueStoreBuilder

btunow · March 29, 2006

The contribution works great except all the products are listed as the same catagory... is there anyway to fix this

jaminunit · April 17, 2006

The contribution works great except all the products are listed as the same catagory... is there anyway to fix this

Yeah I get the same,

Any bright spark know whats going on?

J

web4luke · May 7, 2006

Yeah I get the same,

Any bright spark know whats going on?

J

Hi,

the query is listing all the categories. I changed the query in product_info.php

from

$categories_name_query = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id left join " . TABLE_CATEGORIES . " c on p2c.categories_id = c.categories_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

to

$categories_name_query = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd inner join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p2c.categories_id = cd.categories_id where p2c.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and cd.language_id = '" . (int)$languages_id . "'");

I hope it fits for you

w4l

Kjolebutikken · May 10, 2006

Hi,

I just installed this contribution, but only the category shows below the modelnr (varenr). The manufacturer does not show.

What is wrong? Cannot figure it out. Hope somebody can help me out here.

Here is my product_info.php file for you to see:

<?php
/*
 $Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO);


 $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
 $product_check = tep_db_fetch_array($product_check_query);

// MOD 2389 oscStudio.com ic 20050803 - Category & Manufactureres Name in Product_info
 $categories_name_query  = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id left join " . TABLE_CATEGORIES . " c on p2c.categories_id = c.categories_id, " . TABLE_PRODUCTS_DESCRIPTION . "  pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

 $category = tep_db_fetch_array($categories_name_query);	
 // END 2389

?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
<script language="javascript"><!--
function popupWindow(url) {
 window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res
izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le
ft=150')
}
//--></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<? include(DIR_WS_MODULES . 'thumb_bar.php'); ?>
<!-- body //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3">
 <tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->


<td width="100%" valign="top"><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">


<?php
 if ($product_check['total'] < 1) {
?> 
  <tr>
	<td><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr> 
  <tr>
	<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
	  <tr class="infoBoxContents">
		<td><table border="0" width="100%" cellspacing="0" cellpadding="2"> 
		  <tr>
			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
			<td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>
			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
		  </tr>
		</table></td>
	  </tr>
	</table></td>
  </tr>
<?php
 } else {
$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, p.products_image_pop, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
$product_info = tep_db_fetch_array($product_info_query);
$manufacturer_info_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name from " . TABLE_MANUFACTURERS . " m where m.manufacturers_id = '" . (int)$product_info['manufacturers_id'] . "'"); //qty discount GoddardHewett.com
$manufacturer_info = tep_db_fetch_array($manufacturer_info_query);
tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'");

if ($new_price = tep_get_products_special_price($product_info['products_id'])) {
  $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s><span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';
} else {
  $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));
}



// MOD 2389 oscStudio.com ic 20050803 - Category & Manufactureres Name in Product_info
if (tep_not_null($product_info['products_model'])) {
  $products_name = $product_info['products_name'] . '<span class="smallText"><br><br>Varenr.: </span><span class="smallText">' . $product_info['products_model'] . '  </span>' . ' <span class="smallText"><br>Kategori: </span><span class="smallText">' . $category['categories_name'] . '</span>';
  if (tep_not_null($$manufacturer_info_info['manufacturers_name'])) {
	  $products_name = $products_name . ' <span class="smallText">[Mfg:' . $manufacturer_info['manufacturers_name'] . ']</span>';
  }
} else {
  $products_name = $product_info['products_name'] . '<br><span class="smallText">' . ' <span class="smallText"> ' . $category['categories_name'] . '</span>';
  if (tep_not_null($product_info['manufacturers_name'])) {
	  $products_name = $products_name . ' <span class="smallText">[Mfg:' . $manufacturer_info['manufacturers_name'] . ']</span>';
  }
}
// END 2389

?>
  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
	  <tr>
		<td class="pageHeading" valign="top"><?php echo $products_name; ?></td>
		<td class="pageHeading" align="right" valign="top"><?php echo $products_price; ?></td>
	  </tr>
	</table></td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
  <tr>
	<td class="main">
<?php
if (tep_not_null($product_info['products_image'])) {
?>
	  <table border="0" cellspacing="0" cellpadding="2" align="right">
		<tr>
		  <td align="center" class="smallText">
<script language="javascript"><!--
document.write('<?php echo '<a href="javascript:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), DISPLAY_IMAGE_WIDTH, DISPLAY_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>');
//--></script>
<noscript>
<<?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image_pop']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image_pop'], $product_info['products_name'], DISPLAY_IMAGE_WIDTH, DISPLAY_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>
</noscript>
<tr>
	<td>
	  <?php require(DIR_WS_MODULES . FILENAME_ADDITIONAL_IMAGES); ?>   
	</td>
  </tr>
		  </td>
		</tr>
	  </table>
<?php
}
?>
	 <?php
$products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'");
$products_attributes = tep_db_fetch_array($products_attributes_query);
if ($products_attributes['total'] > 0) {
?>
	  <table border="0" cellspacing="0" cellpadding="2">
		<tr>
		  <br><td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td>
		</tr>
<?php
  $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name");
  while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {
	$products_options_array = array();
	$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'");
	while ($products_options = tep_db_fetch_array($products_options_query)) {
	  $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']);
	  if ($products_options['options_values_price'] != '0') {
		$products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';
	  }
	}

	if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) {
	  $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']];
	} else {
	  $selected_attribute = false;
	}
?> 
	   <tr>
		  <td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td>
		  <td class="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td>
		</tr>


<?php
  }
?>

	  </table>
<p><?php echo stripslashes($product_info['products_description']); ?></p>

<?php
}
?>
	 </td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
<?php

if (tep_not_null($product_info['products_url'])) {
?>
  <tr>
	<td class="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td>

  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '20'); ?></td>
  </tr>

<tr>
<td class="main">
<?php 
 $search_string_array = explode(" ",$product_info['products_name']);
 foreach($search_string_array AS $search_entry) {
if(strlen($search_entry) > 3) {
  $search_entry = ereg_replace("[^a-z0-9]", "", strtolower($search_entry));
  $search_string .= '<a href="'.tep_href_link(FILENAME_ADVANCED_SEARCH_RESULT,'keywords='.$search_entry).'">'.$search_entry.'</a> ';
}
 }
 echo 'S?k etter andre tilsvarende varer.<br>Klikk p? s?keordene som f?lger her: '.$search_string;
?>
</td>
</tr>

<tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
  <tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0" class="infoBox">
	  <tr class="infoBoxContents">			 
		<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
		  <tr>
<//td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
<td class="main" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_PRINT, tep_get_all_get_params()) . '" target="_blank">Utskriftsvennlig side HER.</a>' ?></td>	   
		  </tr>
		</table></td>
	  </tr>
	</table><br></td>



<?php
}

if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {
?>
  <tr>
	<td align="left" class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td>
  </tr>
<?php
} else {
?> 
  <?php
}
?>
		<tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
  <tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0" class="infoBox">
	  <tr class="infoBoxContents">			 
		<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
		  <tr>
<td align="left" class="smallText"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td>
<td class="main" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td>
<td width="1"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>		
		  </tr>
		</table></td>
	  </tr>
	</table><br></td>

</tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '30'); ?></td>
  </tr>


<?php include(DIR_WS_BOXES . 'manufacturer_info.php'); ?>
  </tr>
  <tr>
		 <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>	
  </tr>
  <tr>
	<td>
<br><?php include(DIR_WS_MODULES . 'thumb_bar_join.php'); ?>
</td> 
 </td>
  </tr>
</table></form>



<?php
if ((USE_CACHE == 'true') && empty($SID)) {
  echo tep_cache_also_purchased(3600);
} else {
//include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
}
 }
?>


<!-- body_text_eof //-->
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
</table></td>
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Thanks:-)

Kjolebutikken

Kjolebutikken · May 11, 2006

Hi,
I just installed this contribution, but only the category shows below the modelnr (varenr). The manufacturer does not show.

What is wrong? Cannot figure it out. Hope somebody can help me out here.

Here is my product_info.php file for you to see:

Thanks:-)

Kjolebutikken

Hi, I solved my problem with changing a little the some of code in the product_info.php to:

// MOD 2389 oscStudio.com ic 20050803 - Category & Manufactureres Name in Product_info
if (tep_not_null($product_info['products_model'])) {
  $products_name = $product_info['products_name'] . '<span class="smallText"><br><br>Varenr.: </span><span class="smallText">' . $product_info['products_model'] . ' </span>' . ' <span class="smallText"><br>Kategori: </span><span class="smallText">' . $category['categories_name'] . '</span>' . ' <span class="smallText"><br>Designer: </span><span class="smallText">' . $manufacturer_info['manufacturers_name'] . '</span>';
  if (tep_not_null($$manufacturer_info_info['manufacturers_name'])) {
	  $products_name = $products_name . ' <span class="smallText">' . $manufacturer_info['manufacturers_name'] . '</span>';
  }
} else {
  $products_name = $product_info['products_name'] . '<span class="smallText">' . ' <span class="smallText">' . $category['categories_name'] . '</span>';
  if (tep_not_null($product_info['manufacturers_name'])) {
	  $products_name = $products_name . '<span class="smallText">' . $manufacturer_info['manufacturers_name'] . '</span>';
  }
}
// END 2389

Not a proper change I think, don't know much about it, but it works.

I have a little cosmetic problem however. I want the space between the modelnb (varenr in my case) and the category to be the same as between the category and the manufacturer (Designer in my case). Now there are more room between the fisrt two. Not much, but if it is possible to change, I would like to do that:-)

Here you can see on my page:

http://www.kjolebutikken.com/oscdemo1/prod...?products_id=29

Thanks

Kjolebutikken

msbee · June 8, 2006

hi, don't know what i do wrong... 've got the same problem as kjolebutikken so checked code again .. and again and find nothing.. still no manufacturer in my product_info >_< any ideas?

msbee · June 8, 2006

hi, don't know what is wrong... 've got the same problem as kjolebutikken so checked code again .. and again and find nothing everything looks fine but .. still no manufacturer in my product_info >_< any ideas?

Kjolebutikken · June 9, 2006

hi, don't know what is wrong... 've got the same problem as kjolebutikken so checked code again .. and again and find nothing everything looks fine but .. still no manufacturer in my product_info >_< any ideas?

Have you tried to change the code like I did? Worked for me:-)

Look at my post above for the changes.

Kjolebutikken.

msbee · June 9, 2006

Have you tried to change the code like I did? Worked for me:-)
Look at my post above for the changes.

Kjolebutikken.

yes i've tried, still nothing. should i paste my code?

godino1 · June 11, 2006

I get the same no manufacturer name shows up added kjolebutikken code fix no change still doesn't show up.

godino1 · June 11, 2006

Here you go a fix

use the following

Find these lines:

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_price1,p.products_price2,p.products_price3,p.products_price4,p.produc

ts_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_price4_qty,p

.products_qty_blocks, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); //qty discount GoddardHewett.com

$product_info = tep_db_fetch_array($product_info_query);

Add below:

$manufacturer_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image from " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS . " p where p.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and p.manufacturers_id = m.manufacturers_id");

$manufacturer = tep_db_fetch_array($manufacturer_query);

Find these lines:

if (tep_not_null($product_info['products_model'])) {

$products_name = $product_info['products_name'] . ' [' . $product_info['products_model'] . ']';

} else {

$products_name = $product_info['products_name'];

}

Replace with these lines:

// MOD - Category & Manufactureres Name in Product_info

if (tep_not_null($product_info['products_model'])) {

$products_name = $product_info['products_name'] . ' ' . $product_info['products_model'] . ' ' . ' ' . $category['categories_name'] . '';

if (tep_not_null($manufacturer ['manufacturers_name'])) {

$products_name = $products_name . ' [' . $manufacturer['manufacturers_name'] . ']';

}

} else {

$products_name = $product_info['products_name'] . ' ' . ' ' . $category['categories_name'] . '';

if (tep_not_null($product_info['manufacturers_name'])) {

$products_name = $products_name . ' [' . $manufacturer_info['manufacturers_name'] . ']';

}

// END

and that it

all other parts of original contribution are fine.

the above works for me.

tell me how it goes please.

godino1 · June 11, 2006

Sorry the above only works when model is in use but if not in use it doesn't so here is a fix so it now works on both

Find these lines:

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_price1,p.products_price2,p.products_price3,p.products_price4,p.produc

ts_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_price4_qty,p

.products_qty_blocks, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); //qty discount GoddardHewett.com

$product_info = tep_db_fetch_array($product_info_query);

Add below:

$manufacturer_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image from " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS . " p where p.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and p.manufacturers_id = m.manufacturers_id");

$manufacturer = tep_db_fetch_array($manufacturer_query);

Find these lines:

if (tep_not_null($product_info['products_model'])) {

$products_name = $product_info['products_name'] . ' [' . $product_info['products_model'] . ']';

} else {

$products_name = $product_info['products_name'];

}

Replace with these lines:

// MOD - Category & Manufactureres Name in Product_info

if (tep_not_null($product_info['products_model'])) {

$products_name = $product_info['products_name'] . ' ' . $product_info['products_model'] . ' ' . ' ' . $category['categories_name'] . '';

if (tep_not_null($manufacturer ['manufacturers_name'])) {

$products_name = $products_name . ' [' . $manufacturer['manufacturers_name'] . ']';

}

} else {

$products_name = $product_info['products_name'] . ' ' . ' ' . $category['categories_name'] . '';

if (tep_not_null($manufacturer['manufacturers_name'])) {

$products_name = $products_name . ' [' . $manufacturer['manufacturers_name'] . ']';

}

// END

carolinagirl · September 26, 2006

Can these fields also be added to the shopping cart and the order information?

nahi_sonu · July 17, 2007

hi,

i just want to add manufacturer name on the product_info! i dont want sub category or model name!! just a manufacturer name!

how can i do that? plz i need help as soon as possible!

thanx in advance

Johnatan · January 9, 2009

the contribution can be found here:
Category & Manufacturer's name in Product_Info Page

Please if someone can help me with some changes. This contrib shows my second subcategory, model and manufacturer, but I also whant to show primary categorie (i mean first category)

Can someone can help me?

BR

Johnatan

[contribution] Category & Manufacturers name in Product_Info Page

Recommended Posts

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Create an account or sign in to comment

Create an account

Sign in