Is there a way to control how many decimal places are shown in admin?
I don´t want any decimal places to be show but now it´s showing four.
I want this: 10000
Now it shows this: 10000.0000
Thanks in advance
Decimal places are basically coming from database. To change it, you have to change data type for particular column.
Example, open your database and open coupon table structure, as you can see discount and total has Type decimal(15,4), that means it will add four zeros after digit like 10.0000. If you don't want any zero's than simple change Type to decimal(15,0) it will automatically remove all decimal places.
Example, open your database and open coupon table structure, as you can see discount and total has Type decimal(15,4), that means it will add four zeros after digit like 10.0000. If you don't want any zero's than simple change Type to decimal(15,0) it will automatically remove all decimal places.
Most Useful Extensions || Most Selling Extensions
Opencart Development || Opencart Designing || eCommerce Project
✔ Join more than 5000 Happy Opencart Store Owners enjoying the extensions designed and developed by Opcrat, Opencart Partner.
You welcome. If your issue is solved than please add solved in title of this topic so that others can understand from list that its already solved.
Most Useful Extensions || Most Selling Extensions
Opencart Development || Opencart Designing || eCommerce Project
✔ Join more than 5000 Happy Opencart Store Owners enjoying the extensions designed and developed by Opcrat, Opencart Partner.
opcrat wrote:Decimal places are basically coming from database. To change it, you have to change data type for particular column.
Example, open your database and open coupon table structure, as you can see discount and total has Type decimal(15,4), that means it will add four zeros after digit like 10.0000. If you don't want any zero's than simple change Type to decimal(15,0) it will automatically remove all decimal places.
In my case it did not work. I am using OC Version 1.5.3.1. I changed exactly as you said. May be, do I have to do anything else in the version 1.5.3.1?
Taking back my words - I went to currency table and set the field "decimal_place" from 2 to 0.
If anyone want the change, go to currency table.
Who is online
Users browsing this forum: Amazon [Bot], Bing [Bot], Google [Bot] and 20 guests
