Display stock quantity in product info

cloudchaser · September 10, 2006

Hi all

How do I get the product info to show the product stock quantity figure along with the description?

Not sure if this is shown by default since my product info page has been tweaked a little and I want to make sure that I am not missing something basic in the admin settings or the product_info.php file itself which I can simply switch on i.e product_stock display = YES

Any tips?

♥Monika in Germany · September 10, 2006

nope, this is not a click parameter ;-)

just add the products_quantity to the query that pulls the product and then you can display it just like modle is displayed by calling the column name from the resultset

cloudchaser · September 10, 2006

Thanks for that Monika but being a non-coder I am not sure what I should do to get it to display.

I am pasting my current product_info.php code in here - can you please point out which bit I have to change?

thanks for your help

<?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);
?>
<!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; ?>">
<?php 
# cDynamic Meta Tags
/*<title><?php echo TITLE; ?>*/
require(DIR_WS_INCLUDES . 'meta_tags.php');
#
?>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link href="images/style22.css" rel="stylesheet" type="text/css">
<script language="javascript"><!--
function popupWindow(url) {
 window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,re
sizable=yes,copyhistory=no,width=100,height=200,screenX=10,screenY=30,top=20,left
=30')
}
//--></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 //-->

<!-- body //-->
<!--Add this part -->

<table width="780" border="0" align="center" cellpadding="0" cellspacing="0">
 <tr> 
<td width="14" background="images/body-left-bg.gif">?</td>
<td valign="top" background="images/inner-body-bg.gif">
  <table width="752" border="0" cellspacing="0" cellpadding="0">
  <tr>
  <td width="184" valign="top" bgcolor="#0E81B6"> 

 <table width="184" border="0" cellspacing="0" cellpadding="0">
 <tr> 
 <td class="verdana-10-maroon">

<!--End of Add this part --><!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td width="100%" valign="top" align="center"><?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="95%" cellspacing="0" cellpadding="0">
<?php
 if ($product_check['total'] < 1) {
?>
  <tr>
	<td class="smalltext"><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?><b class="pageHeading1">Ooopsss, we're sorry</b><br><br>
The product or page you requested has either been sold out or discontinued.<br><br>
Please visit our shop home page by clicking Continue or use the menus to find what you need.</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_subimage1, p.products_subimage2, p.products_subimage3, p.products_subimage4, p.products_subimage5, p.products_subimage6, 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);

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']));
}

if (tep_not_null($product_info['products_model'])) {
  $products_name = $product_info['products_name']; 
	  //. '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>';
} else {
  $products_name = $product_info['products_name'];
}
?>
  <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="main1">
<?php
if (tep_not_null($product_info['products_image'])) {
?>
	  <table border="0" cellspacing="0" cellpadding="2" align="left">
		<tr>
		  <td align="center" width="250" class="smallText">
<script language="javascript"><!--
document.write('<?php echo '<a class="verdana-12-black" href="java script: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']), '250','178', 'hspace="5" vspace="5"') . '<br>' . tep_image(DIR_WS_IMAGES . 'button_quick_find.gif','Click to enlarge') . ' click to enlarge </a>'; ?>');
//--></script>
<noscript>
<?php echo '<a  class="verdana-12-black" href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], '250','178', 'hspace="5" vspace="5"') . '<br>' .  tep_image(DIR_WS_IMAGES . 'button_quick_find.gif') . '</a>'; ?>
</noscript>
		  </td>
		</tr>
	  </table>
<?php
}
?>
	  <div align="left" class="pageHeading1"><?php echo $products_name; ?></div><hr>
	  <div align="justify"><?php echo stripslashes($product_info['products_description']); ?></div>
<?php

$show_attributes = 0;   //It will disable the display option of product attributes
						// Make it 1 to enable display.


$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 && $show_attributes==1) {
?>
	  <table border="0" cellspacing="0" cellpadding="2">
		<tr>
		  <td class="main" colspan="2"><?php echo '<b>' . TEXT_PRODUCT_OPTIONS . '</b>'; ?></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="main1"><?php echo $products_options_name['products_options_name'] . ':'; ?></td>
		  <td class="main1"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td>
		</tr>
<?php
  }
?>
	  </table>
<?php
}
?>
	</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" >
	  <tr >
		<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 class="main"><?php //echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></td>
			<td class="pageHeading2" align="right"><?php echo $products_price; ?></td>
			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
		  </tr>



		  <tr>
			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>


			  <td class="main" align="left"><?php echo '<a href="java script:history.go(-1)">' . tep_image_button('button_back.gif', IMAGE_BUTTON_BACK) . '</a>'; ?></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="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
		  </tr>
		</table></td>
	  </tr>
	</table></td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>





<?php
//BOF - Custom hack for extra images ////////////////////////////////////////
?>
		<TR>
			<TD>
<?php
if (tep_not_null($product_info['products_subimage1'])) {
?>
	  <table border="0" cellspacing="0" cellpadding="2" align="left">
		<tr>
		  <td align="center" class="smallText">
<script language="javascript"><!--
document.write('<?php echo '<a class="verdana-12-black" href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id'] . '&invis=1') . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_subimage1'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' .  tep_image(DIR_WS_IMAGES . 'button_quick_find.gif','Click to enlarge')  . ' click to enlarge </a>'; ?>');
//--></script>
<noscript>
<?php echo '<a class="verdana-12-black" href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_subimage1']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_subimage1'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' .  tep_image(DIR_WS_IMAGES . 'button_quick_find.gif','Click to enlarge')  . ' click to enlarge </a>'; ?>
</noscript>
</td>


<?php
}
?>

<?php
if (tep_not_null($product_info['products_subimage2'])) {
?>

		  <td align="center" class="smallText">
<script language="javascript"><!--
document.write('<?php echo '<a class="verdana-12-black" href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id'] . '&invis=2') . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_subimage2'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' .  tep_image(DIR_WS_IMAGES . 'button_quick_find.gif','Click to enlarge')  . ' click to enlarge </a>'; ?>');
//--></script>
<noscript>
<?php echo '<a class="verdana-12-black" href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_subimage2']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_subimage2'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' .  tep_image(DIR_WS_IMAGES . 'button_quick_find.gif','Click to enlarge')  . ' click to enlarge </a>'; ?>
</noscript>
		  </td>

<?php
}
?>
<?php
if (tep_not_null($product_info['products_subimage3'])) {
?>

		  <td align="center" class="smallText">
<script language="javascript"><!--
document.write('<?php echo '<a class="verdana-12-black" href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id'] . '&invis=3') . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_subimage3'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' .  tep_image(DIR_WS_IMAGES . 'button_quick_find.gif','Click to enlarge')  . ' click to enlarge </a>'; ?>');
//--></script>
<noscript>
<?php echo '<a class="verdana-12-black" href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_subimage3']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_subimage3'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' .  tep_image(DIR_WS_IMAGES . 'button_quick_find.gif','Click to enlarge')  . ' click to enlarge </a>'; ?>
</noscript>
		  </td></TR>


<?php
}
?>

<?php
if (tep_not_null($product_info['products_subimage4'])) {
?>

		 <TR> <td align="center" class="smallText">
<script language="javascript"><!--
document.write('<?php echo '<a class="verdana-12-black" href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id'] . '&invis=4') . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_subimage4'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' .  tep_image(DIR_WS_IMAGES . 'button_quick_find.gif','Click to enlarge')  . ' click to enlarge </a>'; ?>');
//--></script>
<noscript>
<?php echo '<a class="verdana-12-black" href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_subimage4']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_subimage4'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' .  tep_image(DIR_WS_IMAGES . 'button_quick_find.gif','Click to enlarge')  . ' click to enlarge </a>'; ?>
</noscript>
		  </td>

<?php
}
?>
<?php
if (tep_not_null($product_info['products_subimage5'])) {
?>

		  <td align="center" class="smallText">
<script language="javascript"><!--
document.write('<?php echo '<a class="verdana-12-black"  href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id'] . '&invis=5') . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_subimage5'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' .  tep_image(DIR_WS_IMAGES . 'button_quick_find.gif','Click to enlarge')  . ' click to enlarge </a>'; ?>');
//--></script>
<noscript>
<?php echo '<a class="verdana-12-black" href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_subimage5']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_subimage5'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' .  tep_image(DIR_WS_IMAGES . 'button_quick_find.gif','Click to enlarge')  . ' click to enlarge </a>'; ?>
</noscript>
		  </td>

<?php
}
?>
<?php
if (tep_not_null($product_info['products_subimage6'])) {
?>

		  <td align="center" class="smallText">
<script language="javascript"><!--
document.write('<?php echo '<a class="verdana-12-black" href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id'] . '&invis=6') . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_subimage6'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' .  tep_image(DIR_WS_IMAGES . 'button_quick_find.gif','Click to enlarge')  . ' click to enlarge </a>'; ?>');
//--></script>
<noscript>
<?php echo '<a class="verdana-12-black" href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_subimage6']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_subimage6'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' .  tep_image(DIR_WS_IMAGES . 'button_quick_find.gif','Click to enlarge')  . ' click to enlarge </a>'; ?>
</noscript> 
		  </td>
		</tr>

<?php
}
?>
<?php
if (tep_not_null($product_info['products_subimage1'])) {
?>
</table>
<?php
	}
			?>
			</td>
		</tr>
<?php
//BOF - Custom hack for extra images ////////////////////////////////////////
?>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
<?php
$reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");
$reviews = tep_db_fetch_array($reviews_query);
if ($reviews['count'] > 0) {
?>
  <tr>
	<td class="main"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></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%', '10'); ?></td>
  </tr>
<?php
}

if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {
?>
  <tr>
	<td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td>
  </tr>
<?php
} else {
?>
  <tr>
	<td align="center" class="smallText"><?php //echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td>
  </tr>
<?php
}
?>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
  <tr>
	<td>
<?php
if ((USE_CACHE == 'true') && empty($SID)) {
  echo tep_cache_also_purchased(3600);
} else {
  include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
}
 }
?>
	</td>
  </tr>
</table></form></td>
<!--Add this part -->		


	</tr>
  </table> </td>
<td width="14" background="images/body-right-bg.gif">?</td>
 </tr>
</table>


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

cloudchaser · October 8, 2006

Just to update this thread - I managed to get the desired result by adding the following piece of code.

<? echo $product_info['products_quantity']; ?>

Since I am not a coder, I was not confident about messing around with the SQL and php code ;)

Hope this helps someone

girl · December 13, 2007

Hi

After much searching I found the topic in a way, but I am wondering and hoping that someone, anyone can help expand on this. I want to Display my stock quantity code in the product info, but would like to do it in a neat little box that says stock 3 etc so if some one can tell me the codes I need and where I need to put them that would be absolutely super.

Thanks

girl · December 13, 2007

Okay I gave it an attempt since I really really need this(quantity) to appear in my product description

in catalog/include/language/english/product_info.php I add this line to the bottom

define('TEXT_PRODUCTS_QUANTITY', '<b>In stock:</b>')

in catalogs/product-info

I added this code

</tr>

</table></td>

</tr>

</table></td>

</tr>

<tr>

<td>

<tr>

</td>

</tr>

<?php

echo $product_info['products_quantity']; ?>

It seems to be working, but I really do not know what I am doing, this is my first attempt at any code and I did it rather via a copy and follow method. I am able to get on my product detail

In Stock: 100 :)

but I can't figure out how to get the 100 in a little white box l. Can anyone help me there pleaseeeee.

Thanks.

girl · December 13, 2007

And where I can put this code in the body of the text so it will appear near my image but under my option values. I did this playing with the code at the bottom of the page.

girl · December 13, 2007

ok so it is not updating itself. soo please help. thanks

clvahlberg · March 20, 2008

ok so it is not updating itself. soo please help. thanks

i don't know how to get the box, but i got this to somewhat work. above my product name it says "In Stock: 1" and counts down. i edited /catalog/products_info.php.

find this code around line 164:

<?php
$reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");
$reviews = tep_db_fetch_array($reviews_query);
if ($reviews['count'] > 0) {
?>

add this just above it:

<?php echo 'In Stock: '?><?php echo $product_info['products_quantity']; ?>

so it should look like this:

		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
<?php echo 'In Stock: '?><?php echo $product_info['products_quantity']; ?>
<?php
$reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");
$reviews = tep_db_fetch_array($reviews_query);
if ($reviews['count'] > 0) {
?>

hope that helps!

Display stock quantity in product info

Recommended Posts

cloudchaser

Link to comment

Share on other sites

♥Monika in Germany

Link to comment

Share on other sites

cloudchaser

Link to comment

Share on other sites

cloudchaser

Link to comment

Share on other sites

girl

Link to comment

Share on other sites

girl

Link to comment

Share on other sites

girl

Link to comment

Share on other sites

girl

Link to comment

Share on other sites

clvahlberg

Link to comment

Share on other sites

Archived

Browse

Activity