Gift Certificate double email/amount

I have managed to set up GC's on my site and I am offering particular amounts (e.g. $10, $25, $50, etc..).

The purchase is made ok and the order confirmation email is received by the customer.

I see the GC in the GC queue and everywhere it appears the amounts is correct for the purchase made.

When I release the GC the customer receives two emails and gets credited twice the amount in their account. The two emails are exactly the same with the same purchase order number. Everywhere in Zencart it only shows the correct amount, it is only the customers gift cart balance that shows double and it allows them the spend double.

As you could imagine this is a major problem.

Could someone please assist me with this.

I have tried playing around with the product quantity minimum and units but still no luck. I don't think it is anything to do with the product set up as the whole transaction looks correct, it is only the certificate release that causes this.

HELP!!

Brad

Never seen this one before ... :eek:

What version of Zen Cart are you running?

Clean install or an upgrade?

How did you install it? How did you upgrade it?

Has this ever worked correctly for you?

When you go to do the release in the Admin do you just see the 1 GV?

If you go to phpMyAdmin and browse the table for:
coupon_gv_queue

Then make an order for a $10 GV ... then browse the table again, how many are added to the table?

Ok thanks for your quick reply I will try and give you all the answers to the questions below.

It was an upgrade from V1.2.x to V1.3.7 (sorry I can't remember exact old V)

I clean installed the files then ran the DB upgrade.
There were a few issues with this and I had to apply a couple of database patches. One of them was to do with the Gift area, the patch I ran was from this thread . As I couldn't even get access to the voucher area before that.

No I have never tried to use GC previously so I don't know whether it worked previously.

Yes I can only see the one GC in the release area.

I did the test you asked below and only one new GC was added to the table and it had the correct $$ value.

Hopefully you can decipher something from this information.

Thanks in advance

Find the balances for the customers in the table:
coupon_gv_customer

Set the current customer to 0 then release the GV ...

Browse again ...

Does the customer who bought it get the right amount?

Do the other records change balances as well?

Ok, i did as you asked and only the correct customers value changed but it changed to double the certificate value.

??

Brad

What version of Zen Cart are you running?

How did you upgrade?

Have you compared your files to:
http://www.zen-cart.com/forum/showthread.php?t=69769

Somewhere it sounds like you have bad data or bad code etc.

Beyond Compare from scootersoftware.com is an excellent tool for comparing files to see if you have something out of date etc.

What add-ons do you have on your site?

AJEH, I hope you are still around to help with this if you can.

I have found out something new that may assist here. I changed the setting to Queue the gift vouchers to false and then purchased a gift voucher and it worked fine. The correct amount was given to the correct customer.
So this tels me the problem is in the code or database somewhere between the GV Queue and assigning it to the customer.

I have used beyond compare to view my modules/order_total/ot_gv.php file to the orginal ZC file and they show exactly the same.

Can you or anyone else think of anything that might be doing this.

cheers

Brad

Hi, I'm having a similar problem.

I just sent a gift certificate through my admin and when I go to the "Gift Certificates Sent" screen it shows that 2 gift certificates sent, although only one email was sent to the customer. The two GC have different redemption codes but the same amount. Also, when you click to get details of the GC's one shows the customer's email address and the other is blank where the email address should be.

I have a fresh install of 1.3.7 with php 4.4.0 and MySQL 4.0.23 server is Linux 2.4.21

Thanks.

I just had this problem also. I have 1.3.8 Fresh install. I was working fine. Not sure if I changed a setting or what. When I emailed a certificate, it sent two to the address (this happened twice) with different redemption codes.

Can anyone point me to the cause of this problem?

Thanks

• Fresh Install 1.3.8

I am also having the same problem on my system and I can't find any fix.

When someone orders a gift certificate, the order is duplicated and the customer receives double the amount, but is only charged once.

I have tried this fix, which is apparently built into 1.3.9, but to no avail.
http://www.zen-cart.com/forum/showpost.php?p=847721&postcount=49

Please assist,

Thank you

Why would you even try a fresh install of the buggy and insecure v1.3.8 ... :unsure:

Or, are you saying you are using a fresh install of v1.3.8 that you have not upgraded yet?

If so, have you applied ALL of the Known Bug Fixes:
http://www.zen-cart.com/forum/showthread.php?t=82619

and all of the Security Patches and Updates at:
http://www.zen-cart.com/forum/showthread.php?t=131115

NOTE: it is strongly recommended that you upgrade to the current version of Zen Cart on our Home page ...

I have been using 1.3.8 for a while, and I have only applied that bug fix. I will try an upgrade to 1.3.9 and see if it resolves my issue.

Thank you for the quick response ~ J

I take it since there is no response that there is not a fix for this.

I have issued 2 gift certificates today and both customers received 2 email with 2 different redemption codes.

I am using v1.3.9.g and just set up the Gift Certificate last night.

I am beginning to think that none of the Order Total Modules work. I have tried for the last 2 months to get the Low Order Fee to work. Now I install the Gift Certificate and it causes nothing but an extra mess to figure out.

Not a happy camper at the moment.

Debbie:no:

bearlymakinit:

I have issued 2 gift certificates today and both customers received 2 email with 2 different redemption codes.

I am using v1.3.9.g and just set up the Gift Certificate last night.
"issued 2 gift certificates today" ... What exactly does that mean?
It could be many things:
a) 2 customers purchased gift certificates that were queued and you approved them from the queue?
b) 2 customers purchased gift certificates and were NOT queued because you have queuing turned off?
c) you used the admin "Mail Gift Certificate" page to send GVs to 2 customers, directly from your admin?
d) you have a GV balance in your customer account, and you forwarded portions of those balances to other customers using the "Send GV" option from your storefront My Account area?

Every one of these scenarios is driven from very different parts of the application, and without knowing exactly what you're really talking about, it's impossible to help let alone "fix" something.

I just tested scenarios a, b, and c from a fresh clean uncustomized install of v1.3.9h, and can only get it to send one email for each action.

Even madly multi-clicking on submit-buttons doesn't seem to be able to cause excess emails to be sent, but then again this server's pretty fast so it doesn't give me much time to click excess times. Maybe your server's slower? Are you impatiently clicking multiple times on a slow server?
Or are you mistakenly double-clicking buttons when a single-click is all that's needed?

Are you clicking the "back" button in your browser and accidentally re-submitting the request to send GVs out?

There are many safeties built-in to prevent things like re-releasing a GV from the GV queue ... for example, as soon as it's released its status is set accordingly, and if someone tries to release it again it finds that the status is already set and therefore refuses to re-release it.

If there really is a problem, we'd like to fix it, but we need as much detail as possible about what you're trying to do, what you're expecting to have happen when you do it, and what actually is happening contrary to your expectations.

bearlymakinit:

I take it since there is no response that there is not a fix for this.Sarcasm noted.
bearlymakinit:

I am beginning to think that none of the Order Total Modules work.Sarcasm noted again.> bearlymakinit:

I have tried for the last 2 months to get the Low Order Fee to work.Er, um, it looks to me like that matter was resolved a long time back, and it was just a setting problem where you were telling it to not apply to virtual items, and yet all you sell are virtual items. http://www.zen-cart.com/forum/showthread.php?t=164047
If you're actually still having problems with it, wouldn't it be more productive to post back saying you've still got problems, instead of bottling it up and exploding about it along with some other issue? :blush:

We really do try hard to help. And Ajeh's actually pretty nice. We're sometimes blunt, but we don't bite!

I have just had the same thing. I used the Mail gift certificates function to do a test certificate before sending them to actual customers. I selected 1 customer (me) and sent the email. It sent 2 emails both with different codes. I clicked them both and now have double the amount in my test account.

I am using zencart 1.3.8a

After sending it says at the top of the screen

Notice: Email sent to: myemail##########################(2)

Any suggestions? Hopefully not too technical ones!

Thanks

Ha ha, i think ive figured it out, i was having a bit of a blonde moment and putting the email address in the second box, as well as selecting the customer from the dropdown list.

Its an either / or, i thought you had to do both!