I have spent time trying to fix this and now come looking to you "gurus" for help.

My clients cart is rounding product prices that end in zero to only have one decimal place (like $5.20 is showing as $5.2) I tried editing the price in the cart admin area and it still drops off the trailing zero. The admin>states area and the includes file are both set to 2 decimal places.

Please help.

Thanks in advance.

Ray Cramblit

Hi Ray, can you let us know what country is set in the admin main setting more recent versions no longer use the includes for currency setting as that based on the admin main country setting. It can be over-ridden in the includes if needed.

Winners never quit, quitters never win
CSS and Responsive Designs
User Manual for Ecommerce Templates

Country is United States.

Just updated to version 6.84.

BOTH admin area and includes.php are set to 2 decimal places.

Ray Cramblit

Hi Ray, can you comment out the parameters in the includes as they are no longer needed and see if that makes a difference.

Winners never quit, quitters never win
CSS and Responsive Designs
User Manual for Ecommerce Templates

Commented it out and it made no difference.

Ray Cramblit

I looked inside the cart database in phpMyAdmin.

The pPrice field in the products table of the database has a "type" of DOUBLE. I'm a MySQL novice. I never heard of DOUBLE. It seems like it ought to be DECIMAL or something.

Could that be an issue?

Ray Cramblit

Hi Ray

Can you have a look in the admin countries page and make sure the Decimal Places is set to 2?

Andy

Please feel free to review / rate our software

Just checked again and it is set to 2.

Ray Cramblit

If you have access to PHPmyadmin, can you check if the price is being stored as 5.20 or 5.2?

Andy

Please feel free to review / rate our software

Product price in database is 5.2 and the field type is set to DOUBLE

Ray Cramblit

This issue only seems to occur when the last number is a zero. 5.20 is saved as 5.2, 6.50 is saved as 6.5 etc

Ray Cramblit

Hi Ray,
The field type 'double' is correct.

Can you try going into your countries admin, set the decimal place to zero from the drop down and submit, then reset it back to two places and see if that sorts it out?



* Database Migrations and Conversions*
* ASP to PHP Cart Conversions*
*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

I reset to zero then back to 2 with no change.

In the database it shows 2 decimal places. Would it work to change the price field type from DOUBLE to decimal or something?

Ray Cramblit

I don't think you should change the field type. Do you know what version of PHP / mySQL is running on the server - this shouldn't be a problem unless perhaps it was very old.

Andy

Please feel free to review / rate our software

I just realized that the issue is in my coding.

I have products on the clients index page that features the product image and the price. My PHP script is calling the price directly from the cart database. In the cart database the trailing zero is not visible (like $5.20 is in the database as $5.2). My script just echos the $5.2 from the database. But I see that the price on the product detail page is showing $5.20 so the cart is working correctly showing the $5.20 price.

Sorry for bothering you folks with what is a code issue on my part. I have edited my code and all is well.

Thanks for all who tried to help.

Ray Cramblit