Quote Originally Posted by VDecalS View Post
You can round all your product prices with Techicant's MySQL from this thread #58:
https://www.zen-cart.com/showthread....t=price+change
Wanted to be sure at least someone spoke to this. That method of SQL rounding would be helpful for those that:
1) entered prices using the local currency and as such a decimal number that needed the additional rounding.
2) for cases where the database price needed to be changed.

That said, the issue being observed here is not related to what was originally entered in the database, but how the database information is used to make a purchase. Pretty standard things but the output/result seen is not even close to what is expected.
I.e.:
add product to cart
begin shipping process
begin payment process and apply coupon code
taxes applied
see results/confirmation
make purchase
data stored in database about purchase
review of data indicates a "problem" as the total for the purchase does not match the amount charged to the customer.

It just happens that the coupon applies a 15% discount and local taxes are 8% which might lead one to think that there is a "larger" change being applied like described in that post/thread.