m0ttan Posted July 12, 2019 Share Posted July 12, 2019 Hy all. I have a strange issue: On back office i have set number of decimals to 0 and no effect on front office or back office also (decimals are shown in FO with 2 decimals and in BO number of decimals for price without tax is 6! and with tax is 2). On root/translations/cldr/main--ro-RO--numbers i have "standard":"#,##0\u00a0\u00a4 (i use RO language). I have tried to change into 1, 2, or any value for decimals in BO also on cldr but no result. This problem appeared after updating from 1.7.5 to 1.7.6. Cleared cached, etc.. Similar problems or just me? Link to comment Share on other sites More sharing options...
joseantgv Posted July 12, 2019 Share Posted July 12, 2019 They changed (again) currency management so /translations/cldr/ are not used anymore. And it's supposed to manage currency format but in next versions. Link to comment Share on other sites More sharing options...
m0ttan Posted July 12, 2019 Author Share Posted July 12, 2019 So until then the only option is to... wait? Link to comment Share on other sites More sharing options...
jonmestev Posted July 17, 2019 Share Posted July 17, 2019 I have the same problem Link to comment Share on other sites More sharing options...
Gerardo Martinez G Posted July 28, 2019 Share Posted July 28, 2019 the same thing happened to me, 6 decimals appeared to me ... go directly to the database .. and edit this table ps_currency in the precision column is where you will put the number of decimals you want to appear also take a look at this new ps_currency_lang table where you can change the symbol, ... in my case it was $ to MXN 1 1 Link to comment Share on other sites More sharing options...
hitabnet Posted July 31, 2019 Share Posted July 31, 2019 Thank you very much! I had similar problem with my Turkish website. Also i had to clear the numeric_iso_code because of my payment module it was bugging the bank's website. I mean I cleared the (0) number... And everything went normal... 1 Link to comment Share on other sites More sharing options...
Sebastiaan2019 Posted July 31, 2019 Share Posted July 31, 2019 On 7/28/2019 at 8:25 PM, Gerardo Martinez G said: the same thing happened to me, 6 decimals appeared to me ... go directly to the database .. and edit this table ps_currency in the precision column is where you will put the number of decimals you want to appear also take a look at this new ps_currency_lang table where you can change the symbol, ... in my case it was $ to MXN Thanks! this solved my problem! Link to comment Share on other sites More sharing options...
Danikcorp Posted September 11, 2019 Share Posted September 11, 2019 Thank you. I had a problem with this on my site officeplushome.com on PS 1.7.6.2 It tooks 3 days to find this solution. Thanks again Link to comment Share on other sites More sharing options...
ahmed.guermazi Posted September 30, 2019 Share Posted September 30, 2019 (edited) Hi I had similar problem with my website I must display 3 decimals (Tunisian Dinars ) I update ps_currency (precision = 3 ) but nothing changed Any Idea ? Edited September 30, 2019 by ahmed.guermazi (see edit history) Link to comment Share on other sites More sharing options...
bouskdav Posted October 6, 2019 Share Posted October 6, 2019 Sure, the trick is - instead of /translations/cldr/ use /localization/CLDR/core/common/main Link to comment Share on other sites More sharing options...
Amorino Posted December 13, 2019 Share Posted December 13, 2019 Hello, Same problem as @ahmed.guermazi here Any advice please? Ahmed did you find solution please? Thanks Link to comment Share on other sites More sharing options...
joseantgv Posted December 13, 2019 Share Posted December 13, 2019 This precision is to calculate prices, not for displaying prices. 1 Link to comment Share on other sites More sharing options...
Amorino Posted December 13, 2019 Share Posted December 13, 2019 Hello, Thank you @joseantgv How to display .000 then please ? Link to comment Share on other sites More sharing options...
diverest Posted January 15, 2020 Share Posted January 15, 2020 On 7/31/2019 at 5:30 PM, Sebastiaan2019 said: Thanks! this solved my problem! Hello guys, Are you on 1.7.6.x? In my ps_currency table I dont have any "precision" field... Link to comment Share on other sites More sharing options...
Amorino Posted January 15, 2020 Share Posted January 15, 2020 Hello, Still blocked on this point 1.7.6 Link to comment Share on other sites More sharing options...
diverest Posted January 17, 2020 Share Posted January 17, 2020 On 9/11/2019 at 7:02 PM, Danikcorp said: Thank you. I had a problem with this on my site officeplushome.com on PS 1.7.6.2 It tooks 3 days to find this solution. Thanks again Hi Danikcorp, I am also on 1.7.6.2... Did you find a solution for this issue? I dont have a precision column on ps_currency table... How did you manage it? Link to comment Share on other sites More sharing options...
Danikcorp Posted March 1, 2020 Share Posted March 1, 2020 (edited) Hi Diverest, I used solution from Gerardo Martinez to mu site officeplushome.com Best regards On 7/28/2019 at 8:25 PM, Gerardo Martinez G said: the same thing happened to me, 6 decimals appeared to me ... go directly to the database .. and edit this table ps_currency in the precision column is where you will put the number of decimals you want to appear also take a look at this new ps_currency_lang table where you can change the symbol, ... in my case it was $ to MXN Edited March 1, 2020 by Danikcorp (see edit history) Link to comment Share on other sites More sharing options...
salem82 Posted March 21, 2020 Share Posted March 21, 2020 Hallo Any solution? @Amorino did you find a solution? I have the situation for Kuwait dinar Link to comment Share on other sites More sharing options...
diverest Posted March 21, 2020 Share Posted March 21, 2020 Unfortunately still no solution for the issue..... Just let me know if you find some Link to comment Share on other sites More sharing options...
Gerardo Martinez G Posted March 22, 2020 Share Posted March 22, 2020 hace 10 horas, diverest dijo: Unfortunately still no solution for the issue..... Just let me know if you find some hace 10 horas, salem82 dijo: Hallo Any solution? @Amorino did you find a solution? I have the situation for Kuwait dinar put a screen where is your error, and version of prestashop Link to comment Share on other sites More sharing options...
salem82 Posted March 22, 2020 Share Posted March 22, 2020 4 hours ago, Gerardo Martinez G said: put a screen where is your error, and version of prestashop The Kuwaiti dinar is sub-divided into 1,000 fils, so the price must displayed as follow: 1.540 this equal one dinar and 540 fils, in prestashop this showed as 1.54 We are working on the last version 1.7.6.4 and we tried to modify the xml files in 'root/localization/CLDR/core/common/main' with no effect. Link to comment Share on other sites More sharing options...
joseantgv Posted March 22, 2020 Share Posted March 22, 2020 There is a module in Addons that could help you with this: https://addons.prestashop.com/en/price-management/27821-change-or-remove-the-decimals-and-format-currency.html Link to comment Share on other sites More sharing options...
Amorino Posted May 10, 2020 Share Posted May 10, 2020 We should pay for every little option !! Link to comment Share on other sites More sharing options...
leonnel Posted July 24, 2020 Share Posted July 24, 2020 merci beaucoup les frères , cette solution m'à vraiment sauvé la vie 😀 Link to comment Share on other sites More sharing options...
Amorino Posted August 4, 2020 Share Posted August 4, 2020 (edited) Hello, when I put in precision column in the database 1 it shows 1 2 shows 2 But 3 shows 2 The problem appear when the last number is 0 For example: 58.550 will show 58.55 But 58.555 will be OK Any help please ?? Thank you a lot Edited August 4, 2020 by Amorino (see edit history) Link to comment Share on other sites More sharing options...
pdasou1968 Posted November 27, 2020 Share Posted November 27, 2020 (edited) You can use sprintf command to fix the problem in invoice if you want. example : {sprintf("%.3f", $var)} 3f = 3 decimals - 2f = 2 decimals - 0f = 0 decimals etc. $var is your variable that you want to fix. Invoice variables are in folder pdf under prestashop root folder and they begin with invoice. If someone wants help how to create specific invoice , don't hesitate to send me your needs. I'll be happy to help you. Edited November 27, 2020 by pdasou1968 (see edit history) Link to comment Share on other sites More sharing options...
lipo999 Posted January 11, 2021 Share Posted January 11, 2021 Hello All. Simple solution: |replace:',00':'' So for example: {$product.price|replace:',00':''} On Front Office prices are without decimals. On BO are still with decimals (its good for invoices, where you shoud have 2 or more decimals) But you have to change it everywhere, where you want remove decimals. Cheers Link to comment Share on other sites More sharing options...
gopresta.pl Posted February 25, 2021 Share Posted February 25, 2021 In database: UPDATE `ps_currency` SET `precision` = '0'; works perfectly for me Link to comment Share on other sites More sharing options...
bolomanu Posted June 30, 2022 Share Posted June 30, 2022 Tenia exactamente ese problema y se ha solucionado. Version 1.7.6 Moneda Euro (round a 2 e iso code a 978). tabla ps_currency Mil gracias por el aporte Saludos Link to comment Share on other sites More sharing options...
pandorrah Posted January 1, 2023 Share Posted January 1, 2023 Let me help you: in DBAdmin go directly to the database .. and edit this table:ps_product in the columns:price change value 20,6 to 20,2. Do the same in columns:excotax andwholesale_price You're welcome. Link to comment Share on other sites More sharing options...
pandorrah Posted January 1, 2023 Share Posted January 1, 2023 Update: there also seem to be some 6 decimal stuff hardcoded in: PS/js/admin/price.js You should check that one out aswel. 1 Link to comment Share on other sites More sharing options...
DorianS Posted March 30, 2023 Share Posted March 30, 2023 You just need to go to International --> Localization --> Currencies --> Edit your currency --> Set "decimal" to any number (can be 0) 1 Link to comment Share on other sites More sharing options...
pandorrah Posted April 11, 2023 Share Posted April 11, 2023 That did nót solved the case. These extra zero's are hardcoded in scripts, they are not solved by your suggestion. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now