decimal place error

[icehokz]

hello see i have this problem when i tried to change the decimal place in the admin --> localisation --> currencies to 2. The price of my product shows up as $2917 dollars instead of $29.17. Any help is deeply appreciated, thanks!!!!

[stevesh]

What does the 'value'say in the Localization setup?

[icehokz]

"Value: 1.00000000"

any ideas?

[stevesh]

If the decimal places is 2 it should work - how is the price listed in your product setup? 2917 or 29.17?

[icehokz]

it doesn't work for me it appears as $2917 instead of $29.17

[Ajeh]

If you edit your Product with the wrong price, do you see in the field:
A $2917
B $29.17
C 2917
D 29.17

the correct answer should be D ... 29.17

If you have the correct answer, and switch to the Classic Template, do you have the correct display for the price now?

[icehokz]

actually it is 29.1775. when i changed it to the classic green it is still 29.1775

[AMATKINS]

I have a similar problem -- I have site where the quantity discounts module is installed and code is added to have the prices display as "as low as $xxx" to pull the minimum discount price. When the code is added the prices display with 4 decimal places rather than 2. The settings are correct in localization>currencies. The code being added to the files (includes>modules>featured_products.php, >new_products.php, etc)is:

// show only when 1 or more

if ($num_products_count > 0) {

if ($num_products_count < SHOW_PRODUCT_INFO_COLUMNS_FEATURED_PRODUCTS || SHOW_PRODUCT_INFO_COLUMNS_FEATURED_PRODUCTS == 0) {

$col_width = floor(100/$num_products_count);

} else {

$col_width = floor(100/SHOW_PRODUCT_INFO_COLUMNS_FEATURED_PRODUCTS);

}

while (!$featured_products->EOF) {

$res = mysql_query("select min(discount_price) from zen_products_discount_quantity where products_id ='" . $featured_products->fields['products_id'] . "'");

$row1 = mysql_fetch_array($res);

if($row1[0] != ""){

$products_price = "As low as $" . $row1[0];

} else {

$products_price = "As low as " .zen_get_products_display_price($featured_products->fields['products_id']);

}

//$products_price = zen_get_products_display_price($featured_products->fields['products_id']);



Can anyone please tell me where the error is? Thanks in advance!!

[Ajeh]

You need to look at the currency display function for this ...

Try a search in the Developers Tool Kit on:
$currencies->display_price

for examples of how this is used to obtain the right format for prices ...

[AMATKINS]

Ajeh-
Thank you for the quick reply! I have went through Localization>Currencies twice and everything is set correctly. The extra decimal places only appear when I add the code posted in the thread. The only thing which is different is that the site is using Singapore Dollars and not USD, but I'm not sure that should make any difference.