Item price does not show up on categories page

[jetskeem]

I'm wondering what the problem is with my categories page that it doesn't show the price of the items. All other attributes are fine in that quantities, model number, product name, product image and buy now button appear.

 

The price comes up when I am inserting the item, but it isn't there when the item is saved.

 

Is this a common problem, or is it in my application, as I have not altered anything in the files themselves, other than through inserting the data in the "categories/products" page.

 

Also, I have used PayPal standard as a payment option, but when checking out, the items default to USD, and I have me account in AUD.

 

I will greatly appreciate any help that can be offered.

 

Best Regards,

 

Norman :blink:

[spooks]

Have you disabled 'display price' in admin?

[jetskeem]

Have you disabled 'display price' in admin?

 

Hi Sam, In "Configuration" under "Product Listing" the title "Display Product Price" I click on the button on the right side asking "Do you want to display the product price?". I click the edit button and it asks for a value. This "value" seems to relate to the column I want the price to display at as the price changes from left to right on the page if i put in 1, 2, 3 or 4. I can't seem to find an enable or disable button for the price to display.

 

Help would greatly be appreciated.

 

Thanks

[jetskeem]

Hi Sam, In "Configuration" under "Product Listing" the title "Display Product Price" I click on the button on the right side asking "Do you want to display the product price?". I click the edit button and it asks for a value. This "value" seems to relate to the column I want the price to display at as the price changes from left to right on the page if i put in 1, 2, 3 or 4. I can't seem to find an enable or disable button for the price to display.

 

Help would greatly be appreciated.

 

Thanks

 

Hi again,

 

Does anyone have any idea what may be the problem with my products not showing their prices? I am unable to find what I may have done wrong, and whether I have disabled the price function. The quantity, Model, Manufacturer and product name all appear other than the price.

 

Any help or guidance would be most appreciated.

 

Thanks in advance.

 

Norman

[jetskeem]

Hi again,

 

Does anyone have any idea what may be the problem with my products not showing their prices? I am unable to find what I may have done wrong, and whether I have disabled the price function. The quantity, Model, Manufacturer and product name all appear other than the price.

 

Any help or guidance would be most appreciated.

 

Thanks in advance.

 

Norman

 

OK, I don't seem to be getting any replies to these posts regarding a "0" price showing on my products, but can anyone tell me of there is supposed to be any text on line 33 in catalog/includes/modules/new_producrs.php?

 

The text below is what I have for that page. Please advise if this is correct or if there is to be any text for this page on line 33:

 

<?php

/*

$Id: new_products.php 1806 2008-01-11 22:48:15Z hpdl $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2008 osCommerce

 

Released under the GNU General Public License

*/

?>

<!-- new_products //-->

<?php

$info_box_contents = array();

$info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')));

 

new contentBoxHeading($info_box_contents);

 

if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {

$new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

} else {

$new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

}

 

$row = 0;

$col = 0;

$info_box_contents = array();

while ($new_products = tep_db_fetch_array($new_products_query)) {

$info_box_contents[$row][$col] = array('align' => 'center',

'params' => 'class="smallText" width="33%" valign="top"',

'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a><br>' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])));

 

$col ++;

if ($col > 2) {

$col = 0;

$row ++;

}

}

 

new contentBox($info_box_contents);

?><!-- new_products_eof //-->