GranWizard Posted September 9, 2021 Share Posted September 9, 2021 Hello, I have been searching a lot on the internet and forums, but I can't find the solution. I use PS 1.7 and have products that have specific prices. Buy 5, get 10% off Buy 10, get 15% off Buy 25, get 25% off In the total price, the calculation is wrong. (please see attachment) Product price after 15% discount is € 4,68. Multiplied by 10 is € 46,80 and not € 46,75 I think what happens is: Discount is applied on base price ex. VAT - then gets multiplied with the order amount - then TAX is added. Due to rounding difference in the start, it ends in bigger difference in the end... What should happen is: Discount is applied to product incl. VAT, rounded to 2 decimals - then multiply by order amount Is there a solution in default settings? Is this a prestashop bug? Or what is recommded? Link to comment Share on other sites More sharing options...
GranWizard Posted September 9, 2021 Author Share Posted September 9, 2021 another example Link to comment Share on other sites More sharing options...
Daresh Posted September 10, 2021 Share Posted September 10, 2021 I think this is a Prestashop bug. Link to comment Share on other sites More sharing options...
Knowband Plugins Posted September 10, 2021 Share Posted September 10, 2021 Actually, 15% of 5.50 is 4.675 and not 4.68. 4.675 is rounded off to 4.68 according to the precision setting for your selected Currency. You have to change the precision value of the Currency in the "ps_currency" table in your Prestashop database. Screenshot: https://nimb.ws/3CE27D Change the value from 2 to 3 so it will be displayed as 4.675. After that the Cart will be shown like this:https://nimb.ws/eyUTu3 Link to comment Share on other sites More sharing options...
GranWizard Posted September 10, 2021 Author Share Posted September 10, 2021 That sounds like a pretty good workaround, but unfortunately it does not make a difference to my shop. See attachment. (Cleared cache) Link to comment Share on other sites More sharing options...
gstar Posted March 23, 2022 Share Posted March 23, 2022 On 9/10/2021 at 4:13 PM, GranWizard said: That sounds like a pretty good workaround, but unfortunately it does not make a difference to my shop. See attachment. (Cleared cache) Did you manage to solve this? Link to comment Share on other sites More sharing options...
GranWizard Posted March 24, 2022 Author Share Posted March 24, 2022 No, still not solved. I do understand what is happeing. Price ex VAT = € 4.545454 with 15% discount = € 3.863636 Times 10 = € 38,63636 Incl VAT (21%) = € 46.74999 It looks like it would not be too hard to display the calculated pirce of € 46,75. That would also work for me, but I don't know how.... Link to comment Share on other sites More sharing options...
gstar Posted March 28, 2022 Share Posted March 28, 2022 On 3/24/2022 at 9:38 AM, GranWizard said: It looks like it would not be too hard to display the calculated pirce of € 46,75. That would also work for me, but I don't know how.... Very odd and frustrating. We keep searching., Link to comment Share on other sites More sharing options...
Talas Posted July 15, 2022 Share Posted July 15, 2022 On 3/24/2022 at 9:38 AM, GranWizard said: No, still not solved. I do understand what is happeing. Price ex VAT = € 4.545454 with 15% discount = € 3.863636 Times 10 = € 38,63636 Incl VAT (21%) = € 46.74999 It looks like it would not be too hard to display the calculated pirce of € 46,75. That would also work for me, but I don't know how.... Did you find a solution to your problem? Link to comment Share on other sites More sharing options...
GranWizard Posted July 18, 2022 Author Share Posted July 18, 2022 No, still not solved... 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