[solved FIX INSIDE] PS 1.6.0.9 wrong rounded value using combinations

[angelistudio]

Hi there,

I'm using version 1.6.0.8

 

I'm adding a price of 14,00 euro taxes included for a combination; when I display the generated combination the taxes included price becomes 14,01

 

How to get rid of that "01"?

 

I found this post: http://forge.prestashop.com/browse/PSCFI-6693

...should I modify DB tables? 

[PrestaHeroes USA]

Hi there,

I'm using version 1.6.0.8

 

I'm adding a price of 14,00 euro taxes included for a combination; when I display the generated combination the taxes included price becomes 14,01

 

How to get rid of that "01"?

 

I found this post: http://forge.prestashop.com/browse/PSCFI-6693

...should I modify DB tables? 

 

that fix is for 1.4, so unless they dropped the fix one would hope in 1608.  check it but probably not able to apply..

 

is this an upgrade shop?

 

I would open bug ticket, (forge.prestashop.com) post link back here for community to follow/comment/vote up.

 

(also consider upgrading to 1609, loads of fixes)

[angelistudio]

Hi El Patron,

 

thanks for your advice.

 

1) it's not an upgrade shop.

2) I upgraded to 1.6.0.9 but the issue still remains.

 

I'll open a ticket, in the meantime any other suggestions are welcome

[angelistudio]

Update:

In the end I followed the instructions I found on forge, and that did the trick!!!

 

To summarize: I changed the format of the column price in the "ps_attribute_impact" table, from DECIMAL 17,2 to DECIMAL 17,3

 

Just one thought: since I'm not DB expert I was thinking if a future system update could overwrite my custom changes...

[kokosmin]

I have 1.6.0.8 and this didn't work for me. The Price stayed at 23,99 instead of 24,00

 

 

Edited August 14, 2014 by kokosmin (see edit history)

[PrestaHeroes USA]

I have 1.6.0.8 and this didn't work for me. The Price stayed at 23,99 instead of 24,00

 

 

 

this is fix for 1609, so that may be the reason.  consider upgrading to 1.6.0.9

[kokosmin]

I can't upgrade for now, because of another bug I discovered and was resolved locally and on forge (http://forge.prestashop.com/browse/PSCSX-2394), but was not implemented in 1.6.0.9 (I uppgraded but then replaced from backup).

 

Still grateful for the coders work, though. I have patience

[angelistudio]

@kokosmin

I tested on both installations (1.6.0.8 and 1.6.0.9) and I can confirm it worked for me...but I was dealing with impact on price in combination generator mode. 

 

You could also check under settings > general > rounding... 

[kokosmin]

Yes, my products are also from Combinations Generator, I have like 120 combinations per product for a few main products...

I have now upgraded with 1-click Upgrade to  1609. No change.

But here's a movie on how it reacts :-)  It says 24,00 for about 1/2 a second, then reverts to 23,99

UPDATE:  Link to a product http://fabricadetricouri.ro/2015/ro/tricouri/8-tricou-heavy-new-bumbac-200-gmp.html

 

https://www.youtube.com/watch?v=pfEDqg-c-EM&feature=youtu.be

Edited August 19, 2014 by kokosmin (see edit history)

[lionxshop]

Hello. I have a big problem. After i make attributes and combinations for a product and then i want for example to add in cart size M or L it doesnt changes. The product is added on cart with the first size(default one) s for example. My website is at outlet if you want to check it out to understand better my problem. What can i do? can anyone help me?

[kokosmin]

Your post does not relate to this thread, please make a new thread.

[kokosmin]

Well, replacing default theme's product.js with this version fron Forge, did the trick for me. Thank you.

 

Also, check this topic http://www.prestashop.com/forums/topic/350813-tax-and-rounding-fixes-testers-needed/

[Xavier du Tertre]

Hi angelistudio,

 

We're currently working on fixing the issues that you may have encountered with rounding on PrestaShop. Actually, there's an updated version of PrestaSthop available here: http://www.prestashop.com/forums/topic/350813-tax-and-rounding-fixes-testers-needed/?p=1777830 

 

Not only do we strongly recommend that you upgrade and get a chance to have your store run exactly the way you want to, but we also need users like you to run some tests and report any rounding-related bug you come across. 

 

First and foremost, we hope this upgrade makes your life easier on PrestaShop.

[angelistudio]

...thank you for the news, Xavier.

[a_smith]

this is fix for 1609, so that may be the reason.  consider upgrading to 1.6.0.9

 

I use 1.6.0.9 (recently upgraded from 1.5.6.2). Altering table from 17.2 to 17.3 didnt work for me either.

 

I have multistore setup.

Some prices of products with attributes are wrong (15.29 instead of 15.30 or 53.51 instead of 53.50). All multi/stores are affected.

 

What is very strange this wrong price is only shown on main product page (product description). The same product price is correctly displayed on left/right collumn blocks (i.e. on RECENTLY VIEWED block or SPECIAL PRODUCTS).

 

I am not mysql/php expert but because of abowe, maybe it is just themes/product.tpl problem (or any related php or js part of the code)...?

 

What is even stranger is that when the product page gets fully loaded into the browser, valid price is shown for a short while (15.30) to get change second later to incorrect one (15.29)....

You can see this here:

http://www.liquidmania.eu/en/aromaty-hangsen/963-arabic-tobacco-hangsen-tobacco-flavour-essence-for-diy-e-liquid.html

 

I did noticed that correct price on product page is shown only up to the moment of when attributes drop down list is loaded and displayed on the screen.

In the same moment when attributes drop down list appear on the screen, product price gets changed at 0.01.

 

Any ideas??

Edited November 21, 2014 by a_smith (see edit history)