Full service web hosting, great prices and support. Starts at $1.99/month!
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: product prices not showing on product page

  1. 02-24-2006, 08:41 PM #1
    Dumb_Question
    Guest

    Default product prices not showing on product page

    I have had some customization done by some programmers. Today I looked at the site ....i noticed that prices were not displayed on the product page.

    I checked the config in admin ...the prices are set to be displayed.

    Can someone help.

    Thanks
  2. 02-25-2006, 03:38 PM #2
    met00
    Guest

    Default RE: product prices not showing on product page

    look at the code in /templates/<templatename>/product_info.tpl.php
  3. 02-26-2006, 04:19 PM #3
    Dumb_Question
    Guest

    Default

    looked at the file....couldnt figure out anything...there are too many instances of product price....can you please point to a particular line or something...thanks
  4. 02-28-2006, 06:38 AM #4
    bkpie
    Guest

    Default

    If you figure this one out let me know it just happened to me as well.
  5. 02-28-2006, 01:32 PM #5
    met00
    Guest

    Default

    Okay, here is the problem with distance debugging. I can look at my code and tell you where it is in my template, but my template has a whole bunch of changes in it to handle things like MSRP and display of discount from MSRP that means that what I say is on line 45 in my template may not be in yours, or even on line X if it is in yours at all.

    So telling you what line it's on in my template doesn't mean anything in relation to yours.

    If you were to post your te,plate, then I could tell you what lines I would start investigation on. But that's about the best I can do.
  6. 02-28-2006, 01:51 PM #6
    bkpie
    Guest

    Default

    Ok Here is the template. Latest change was adding quantity box via Met00 code. Thanks by the way.

    Code:
                   <?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) {
   // BOF Separate Price per Customer
     if(!tep_session_is_registered('sppc_customer_group_id')) { 
     $customer_group_id = '0';
     } else {
      $customer_group_id = $sppc_customer_group_id;
     }
   // EOF Separate Price per Customer
?>
      <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, 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'])) {
// BOF Separate Price per Customer

        $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id =  '" . $customer_group_id . "'");
        if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) {
        $product_info['products_price']= $scustomer_group_price['customers_group_price'];
	}
// EOF Separate Price per Customer
      $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 {
// BOF Separate Price per Customer
        $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id =  '" . $customer_group_id . "'");
        if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) {
        $product_info['products_price']= $scustomer_group_price['customers_group_price'];
	}
// EOF Separate Price per Customer
      $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="main">
<?php
		//// BEGIN:  Added for Dynamic MoPics v3.000
    if (tep_not_null($product_info['products_image'])) {
?>
          <table border="0" cellspacing="0" cellpadding="2" align="right">
            <tr>
              <td align="center" class="smallText">
<?php
			$image_lg = mopics_get_imagebase($product_info['products_image'], DIR_WS_IMAGES . DYNAMIC_MOPICS_BIGIMAGES_DIR);
			if ($lg_image_ext = mopics_file_exists(DIR_FS_CATALOG . $image_lg, DYNAMIC_MOPICS_BIG_IMAGE_TYPES)) {
				$image_size = @getimagesize(DIR_FS_CATALOG . $image_lg . '.' . $lg_image_ext);
?>
          <script language="javascript" type="text/javascript"><!--
            document.write('<a href="javascript:popupImage(\'<?php echo tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id'] . '&type=' . $lg_image_ext); ?>\',\'<?php echo ((int)$image_size[1] + 30); ?>\',\'<?php echo ((int)$image_size[0] + 5); ?>\');"><?php echo tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); ?><br /><span class="smallText"><?php echo TEXT_CLICK_TO_ENLARGE; ?></span></a>');
//--></script>
<noscript>
            <a href="<?php echo tep_href_link($image_lg . '.' . $lg_image_ext); ?>" target="_blank"><?php echo tep_image(DIR_WS_IMAGES . $product_info['products_image'], stripslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); ?><br /><span class="smallText"><?php echo TEXT_CLICK_TO_ENLARGE; ?></span></a>
</noscript>
<?php
			} else {
          echo tep_image(DIR_WS_IMAGES . $product_info['products_image'], stripslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT);
			}
?>
              </td>
            </tr>

          </table>
<?php
    }
		//// END:  Added for Dynamic MoPics v3.000
?>
          <p><?php echo stripslashes($product_info['products_description']); ?></p>
<?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) {
//++++ QT Pro: Begin Changed code
      $products_id=(preg_match("/^\d{1,10}(\{\d{1,10}\}\d{1,10})*$/",$HTTP_GET_VARS['products_id']) ? $HTTP_GET_VARS['products_id'] : (int)$HTTP_GET_VARS['products_id']); 
      require(DIR_WS_CLASSES . 'pad_' . PRODINFO_ATTRIBUTE_PLUGIN . '.php');
      $class = 'pad_' . PRODINFO_ATTRIBUTE_PLUGIN;
      $pad = new $class($products_id);
      echo $pad->draw();
//++++ QT Pro: End Changed Code
    }
?>
        </td>
      </tr>
<?php
		//// BEGIN:  Added for Dynamic MoPics v3.000
?>
      <tr>
      	<td>
				<div class="screenshotsHeader">
					<div class="screenshotsHeaderText"><?php echo TEXT_OTHER_PRODUCT_IMAGES; ?></div>
				</div>
				<div class="screenshotsBlock">
					<?php include(DIR_WS_MODULES . 'dynamic_mopics.php'); ?>
   			        </div>
	</td>
      </tr>
<?php
		//// END:  Added for Dynamic MoPics v3.000
?>
      <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><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 class="main" align="right">Qty: <? echo tep_draw_input_field('quantity', '1', 'SIZE=4 maxlength=4'); ?><input type="hidden" name="cart_quantity" value=1 maxlength="6" size="4">  <?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 class="main" align="right"><a href="javascript:history.go(-1)"><?php echo tep_image_button('button_continue_shopping.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>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
        <td>
<?php

//added for cross -sell
   if ( (USE_CACHE == 'true') && !SID) {
    echo tep_cache_also_purchased(3600);
     include(DIR_WS_MODULES . FILENAME_XSELL_PRODUCTS);
   } else {
     include(DIR_WS_MODULES . FILENAME_XSELL_PRODUCTS);
      include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
    }
   }
?>
        </td>
      </tr>
    </table></form>
  7. 03-03-2006, 09:21 AM #7
    Dumb_Question
    Guest

    Default

    Ok...where does it show on your template...i will upload my template in a little while.

    Thanks
  8. 03-03-2006, 10:36 AM #8
    Dumb_Question
    Guest

    Default

    Here is my product_info.tpl.


    <?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) {
    // BOF Separate Price per Customer
    if(!tep_session_is_registered('sppc_customer_group _id')) {
    $customer_group_id = '0';
    } else {
    $customer_group_id = $sppc_customer_group_id;
    }
    // EOF Separate Price per Customer
    ?>
    <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 >
    <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, 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 . "'");
    //Added by Kerul
    if(isset($customer_group_id)){
    $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = '" . $customer_group_id . "'");
    if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) {
    $products_price = $scustomer_group_price['customers_group_price'];
    }
    }
    else{

    $pf->loadProduct((int)$HTTP_GET_VARS['products_id'], (int)$languages_id);
    $products_price=$pf->getPriceString();
    }

    //End by Kerul

    /* if ($new_price = tep_get_products_special_price($product_info['products_id'])) {
    // BOF Separate Price per Customer

    $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = '" . $customer_group_id . "'");
    if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) {
    $product_info['products_price']= $scustomer_group_price['customers_group_price'];
    }
    // EOF Separate Price per Customer
    $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 {
    // BOF Separate Price per Customer
    $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = '" . $customer_group_id . "'");
    if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) {
    $product_info['products_price']= $scustomer_group_price['customers_group_price'];
    }
    // EOF Separate Price per Customer
    $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">Style #' . $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="main">
    <?php
    //// BEGIN: Added for Dynamic MoPics v3.000
    if (tep_not_null($product_info['products_image'])) {
    ?>
    <table border="0" cellspacing="0" cellpadding="2" align="left">
    <tr>
    <td align="center" class="smallText">
    <?php
    $image_lg = mopics_get_imagebase($product_info['products_image'], DIR_WS_IMAGES . DYNAMIC_MOPICS_BIGIMAGES_DIR);
    if ($lg_image_ext = mopics_file_exists(DIR_FS_CATALOG . $image_lg, DYNAMIC_MOPICS_BIG_IMAGE_TYPES)) {
    $image_size = @getimagesize(DIR_FS_CATALOG . $image_lg . '.' . $lg_image_ext);
    ?>
    <script language="javascript" type="text/javascript"><!--
    document.write('<a href="javascriptopupImage(\'<?php echo tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id'] . '&type=' . $lg_image_ext); ?>\',\'<?php echo ((int)$image_size[1] + 30); ?>\',\'<?php echo ((int)$image_size[0] + 5); ?>\');"><?php echo tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); ?><br /><span class="smallText"><?php echo TEXT_CLICK_TO_ENLARGE; ?></span></a>');
    //--></script>
    <noscript>
    <a href="<?php echo tep_href_link($image_lg . '.' . $lg_image_ext); ?>" target="_blank"><?php echo tep_image(DIR_WS_IMAGES . $product_info['products_image'], stripslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); ?><br /><span class="smallText"><?php echo TEXT_CLICK_TO_ENLARGE; ?></span></a>
    </noscript>
    <?php
    } else {
    echo tep_image(DIR_WS_IMAGES . $product_info['products_image'], stripslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT);
    }
    ?>
    </td>
    </tr>
    </table>
    <table border="0" cellspacing="0" cellpadding="2" align="left">
    <tr><td width="5"></td>
    <td align="left" class="smallText">
    <?php
    }
    // END: Added for Dynamic MoPics v3.000
    //<!-- Points/Rewards Module V1.60 show_points_info bof -->

    if ((USE_POINTS_SYSTEM == 'true') && (DISPLAY_POINTS_INFO == 'true')) { // check that the points system is enabled
    if ($new_price = tep_get_products_special_price($product_info['products_id'])) {
    $products_price_points = tep_display_points($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';
    } else {
    $products_price_points = tep_display_points($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));
    }
    $products_points = tep_calc_products_price_points($products_price_poi nts);
    $products_points_value = tep_calc_price_pvalue($products_points);
    if (USE_POINTS_FOR_SPECIALS == 'true' || $new_price == false){
    ?>
    <p><?php echo sprintf(TEXT_PRODUCT_POINTS , $products_points) .TEXT_PRODUCT_POINTS_VALUE . $currencies->format($products_points_value); ?></p>
    <?php
    } else {
    ?>
    <p><?php echo TEXT_PRODUCT_NO_POINTS; ?></p>
    <?php
    }
    }// else do not show points_value
    ?>
    <!-- Points/Rewards Module V1.60 show_points_info eof -->

    <?php echo stripslashes($product_info['products_description']); ?><!--</td></tr></table>-->

    <?php if (OPTIONS_AS_IMAGES_ENABLED == 'false'){
    $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) {
    //++++ QT Pro: Begin Changed code
    $products_id=(preg_match("/^\d{1,10}(\{\d{1,10}\}\d{1,10})*$/",$HTTP_GET_VARS['products_id']) ? $HTTP_GET_VARS['products_id'] : (int)$HTTP_GET_VARS['products_id']);
    require(DIR_WS_CLASSES . 'pad_' . PRODINFO_ATTRIBUTE_PLUGIN . '.php');
    $class = 'pad_' . PRODINFO_ATTRIBUTE_PLUGIN;
    $pad = new $class($products_id);
    echo $pad->draw();
    //++++ QT Pro: End Changed Code
    } }
    ?>
    <?php
    //Options as Images. This whole php clause needs to be added
    if (OPTIONS_AS_IMAGES_ENABLED == 'true') include ('options_images.php');
    ?>
    </td>
    </tr></table>
    <?php
    //// BEGIN: Added for Dynamic MoPics v3.000
    ?>
    <tr>
    <td>
    <div class="screenshotsHeader">
    <div class="screenshotsHeaderText"><?php echo TEXT_OTHER_PRODUCT_IMAGES; ?></div>
    </div>
    <div class="screenshotsBlock">
    <?php include(DIR_WS_MODULES . 'dynamic_mopics.php'); ?>
    </div>
    </td>
    </tr>
    <?php
    // END: Added for Dynamic MoPics v3.000
    ?>
    <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><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
    <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>
    <!-- Wish List 2.3 Start -->
    <td align="center" class="main"><?php echo tep_draw_hidden_field('wishlist_action', 'add_wishlist') . tep_image_submit('button_wishlist.gif', IMAGE_BUTTON_ADD_WISHLIST, 'onClick="document.cart_quantity.action=\''. tep_href_link(FILENAME_WISHLIST, tep_get_all_get_params(array('action')) . 'action=add_wishlist') . '\';document.cart_quantity.submit();"'); ?></td>
    <!-- Wish List 2.3 End -->
    <!-- comment by Kerul
    <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> -->
    <!-- start qty price break -->
    <td class="main" align="right">
    <table border="0" align="right">
    <tr><td align="center">
    <?php echo TEXT_ENTER_QUANTITY . ":" . tep_draw_input_field('cart_quantity', $pf->adjustQty(1), 'size="6"'); ?>
    </td></tr>
    <tr><td align="center">
    <?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?>
    </td></tr>
    </table>
    </td>
    <!-- end qty price break -->
    <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>
    <tr>
    <td>
    <?php

    //added for cross -sell
    if ( (USE_CACHE == 'true') && !SID) {
    echo tep_cache_also_purchased(3600);
    include(DIR_WS_MODULES . FILENAME_XSELL_PRODUCTS);
    } else {
    include(DIR_WS_MODULES . FILENAME_XSELL_PRODUCTS);
    include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
    }
    }
    ?>
    </td>
    </tr>
    </table></form>
  9. 03-05-2006, 12:02 AM #9
    met00
    Guest

    Default

    Here is where the products price display is being set:

    Code:
    // EOF Separate Price per Customer
      $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));

    Here is where the products price is being displayed to the user:

    Code:
      <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>
    for debugging purposes the first place I would put a check in is right after the price is being set. I would add

    Code:
    echo $products_price;
    If there is no price showing up, then the next question is what path is it following through the code. There are three places the products price is changed.

    The inital setting of the price happens at:

    Code:
    $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);
    so a check there would be to immediatly put in a

    Code:
    echo $products_info['products_price'];
    to see if the price was picked up. If you got the initial price, then the next place where it gets changed is

    Code:
     if ($new_price = tep_get_products_special_price($product_info['products_id'])) {
    This is the check on specials.

    The final check is the seperate price per customer mod. again, you can put an echo in here to see what was returned by the query and what the pricing was set.

    I hope that these debugging tips will help you determine

    1) if the price is being picked up at all
    2) if the price is being overwritten, and where.
    3) if none of the above, then I would highlight the entire page and make sure that I wasn't using a CCS class that was printing the price the same colour as my background

    Good luck.
  10. 03-05-2006, 02:00 PM #10
    Dumb_Question
    Guest

    Default

    tried everything but still no luck

    thanks very much for your help though
Page 1 of 2 12 LastLast
« Previous Thread | Next Thread »

Similar Threads

  1. Product Attribute Prices Getting Rid of Extra Chars in (+$8)
    By Dubious in forum osCmax v2 Customization/Mods
    Replies: 1
    Last Post: 11-13-2006, 02:22 PM
  2. HELP!!!! WHOLESALE PRICE NOT SHOWING ON PRODUCT PAGE
    By Judith in forum osCMax v2 Features Discussion
    Replies: 0
    Last Post: 10-26-2005, 02:32 AM
  3. Product prices are all $0
    By adam231 in forum osCommerce 2.2 Installation Help
    Replies: 4
    Last Post: 10-21-2004, 02:08 AM
  4. No product prices in new install?
    By Kristine in forum osCMax v1.7 Installation
    Replies: 3
    Last Post: 04-02-2004, 12:06 PM
  5. one product 3 prices
    By Dumb_Question in forum osCommerce 2.2 Modification Help
    Replies: 6
    Last Post: 01-05-2003, 04:51 PM

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules