Specials Price does not show in Product Info

frannyp · October 31, 2006

I have made specials but the specials price does not show up when you go to the product_info.php page. HOw do I get the specials price to show up. It shows in the cart, and on the rotating specials box. Any suggestions?

Thanks,

Fran :(

Gameprodigy · October 31, 2006

the easiest thing i can think since I don't know what your site is or what mods you made, first thing would be did you change the stylesheet, if the background of your specials box is say brown and your text is white, it will show, but if your product info page has a white background the white text will be disguised. You can try highlighting the price in your product info page and see if the text is being hidden. If this is the case then you just need to change your stylesheet so the text is a different color.

If you did any recent changes no matter how small you may want to let us know. It may help find out what went wrong.

frannyp · October 31, 2006

the easiest thing i can think since I don't know what your site is or what mods you made, first thing would be did you change the stylesheet, if the background of your specials box is say brown and your text is white, it will show, but if your product info page has a white background the white text will be disguised. You can try highlighting the price in your product info page and see if the text is being hidden. If this is the case then you just need to change your stylesheet so the text is a different color.

If you did any recent changes no matter how small you may want to let us know. It may help find out what went wrong.

Here is the link to the site: http://www.orangecandies.com/store/product...;products_id=44

I tried to highlight the price and do not see the specials price there.

Thanks

Gameprodigy · October 31, 2006

Could you post your catalog/product_info.php file

I think there might be an issue with this code

	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>';

Since it shows up everywhere else except for the product page, I am guessing it the code on the product info page.

frannyp · October 31, 2006

Could you post your catalog/product_info.php file

I think there might be an issue with this code
	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>';
Since it shows up everywhere else except for the product page, I am guessing it the code on the product info page.

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

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);

$category_query = tep_db_query("select categories_name from products_to_categories pc, categories_description cd where pc.categories_id = cd.categories_id and pc.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and cd.categories_name <> ''");

$category = tep_db_fetch_array($category_query);

$category = $category["categories_name"];

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

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>

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

</table></td>

<?php

if ($product_check['total'] < 1) {

?>

<tr>

<td><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td>

</tr>

<tr>

</tr>

<tr>

<tr>

<td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></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, 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'];

}

*/

$products_name = $product_info['products_name'];

?>

<tr>

<tr>

</tr>

</table></td>

</tr>

<tr>

<td>

<tr>

</tr>

</table>

<tr>

<td>

<tr>

<td>

<?php

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

?>

document.write('<?php echo '<a 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']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>');

//--></script>

<?php echo '<a 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'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>

</noscript>

<?php

}

?>

</td>

<td>

<tr>

</tr>

<tr>

</tr>

</table>

</td>

</tr>

<tr>

<td style="color:#E45EA3; font-size:14px; font-weight:bold">More about my new tops</td>

</tr>

<tr>

</tr>

<tr>

<tr>

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

</tr>

<?php

}

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

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

</table></td>

</tr>

</table>

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Gameprodigy · October 31, 2006

did you notice the change after you started commenting out areas such as

<td class="pageHeading" align="right" valign="top"><?php //echo $products_price; ?></td>

Commenting out lines may of had an affect, commenting this price spot out may not be allowing the special price to show.

You could always change it see if it affected it or not, then change it back if it made no different.

frannyp · October 31, 2006

did you notice the change after you started commenting out areas such as
<td class="pageHeading" align="right" valign="top"><?php //echo $products_price; ?></td>
Commenting out lines may of had an affect, commenting this price spot out may not be allowing the special price to show.

You could always change it see if it affected it or not, then change it back if it made no different.

When I do that it puts the price correctly in the header, not next to "Your's For"

Here is the code for that area:

</tr>

Do you see anything in there that is wrong?

Thanks

Gameprodigy · October 31, 2006

I am not exactly sure if this will work but its easily reversable if it doesn't, I would take your code

<td style="font-size:12px; font-weight: bold; color:#E45EA3;" align="center"><span style="color:#000000">$<? echo number_format($product_info["products_price"],2); ?></span></td>

And add this right after it.

<td>
<span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';
</td>

All I did was add the "td" and "/td" and pasted part of the special product code, from what i can see the part that would display the price, that may get the price to show but it might now cross out the old price but it may get you closer, I am not php code expert I am just looking at the section that shows the special price, since you changed the coding to show the regular price, I am guessing you have to do the same to get the special price to show also. If it doesnt work just delete the part i had you add.

Specials Price does not show in Product Info

Recommended Posts

frannyp

Gameprodigy

frannyp

Gameprodigy

frannyp

Gameprodigy

frannyp

Gameprodigy

Archived

Browse

Activity