Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Finland
    Posts
    488
    Plugin Contributions
    3

    Default 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!?
    Working with Zen Cart since 2003 :: www.prr.fi
    Author of the original Finnish language pack for Zen Cart since 2004

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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 ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

 

 

Similar Threads

  1. v150 Only show gift certificate option on payment page if customer has a gift certificate
    By ShopVille in forum Templates, Stylesheets, Page Layout
    Replies: 25
    Last Post: 21 Jul 2014, 08:03 PM
  2. v150 Database updated incorrectly when Gift Certificate covers order value?
    By boardshorts in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 3
    Last Post: 25 Dec 2013, 03:00 AM
  3. Want to use a printed gift certificate (with code) in the gift certificate process?
    By HelenSama in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 9
    Last Post: 15 Apr 2008, 02:04 PM
  4. Insert Gift Certificate manualy to database
    By kalleMD in forum General Questions
    Replies: 10
    Last Post: 12 May 2007, 05:29 AM
  5. Gift Certificate Order with no Gift Certificate?
    By Jeff_Mash in forum Bug Reports
    Replies: 20
    Last Post: 14 Oct 2006, 09:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg