Zen Cart Logo
Forums / Bug Reports / Gift certificate decimals in database...

Gift certificate decimals in database...

Locked

Views: 1,230

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
19 Apr 2007, 7:34 PM
#1
pasi avatar

pasi

Zen Follower

Join Date:
Mar 2004
Location:
Finland
Posts:
435
Plugin Contributions:
1

Gift certificate decimals in database...

Been setting up GVs in my shop tonight...

Had some figuring out to do with the tax calculations but finally got it right...

While testing things (tax calculations) I kept buying the same GV and the tax was calculated each time differently untill I got it right... after the experiment, I tested to send the 146,97€ to my friend ... it worked fine, except that now it shows the GV balance thingy in my shopping cart with 0.00€ in it!

not a big thing but annoying ... After some checking I went to see the database, and there it is... my GV balance is not 0.00€ but actually in the database it's 0.0008€ ... an ammount that I can't send nor use!

This might not be a problem in tested and working production enviroment shop, but could the code be changed so that when the balance is under, let's say 0.01, the system would round it always down to zero so that the GV box is not shown in the shopping cart box!?

21 Apr 2007, 2:02 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Gift certificate decimals in database...

I am not sure if this is due to testing or an actual problem as I have not seen it before ...

For now, you can fix this by going to phpMyAdmin and browsing the table coupon_gv_customer and clean out the amount for the customer where it it set to 0.008 ...