Help! My client accidentally sent $500 gc to ALL customers

[snowkrash]

My client accidentally sent a $500 gift cert to ALL hundreds of customers when she forgot to use the pull-down list to select just one. I have taken the site down for maintenance, and we have sent apology emails with a $5 coupon code to everyone, but now I am stuck with 20 people that "redeemed" their gift certificates, but haven't placed orders.

How do I get that gc $ out of their accounts???? How do I disable all 415 of the gc that were sent out so no one can redeem them? The site is DOWN until we can figure this out, and my client is losing $ because the site is down. I'm really at a loss, please help.

Thank you,
Kristin

[wilt]

Hi,

To get your site back up quickly, you should disable the GV module in admin.

admin->modules-order_total

This will ensure that those who have GV's cannot redeem them

(BTW drbyte came up with that quick fix - not me)

As far as fixing the other stuff, this depends. Do you have access to phpMyAdmin on your host.

Are there likely to be others that have Gv's apart from those that you sent the $500 to.

I am looking at the DB now, for an easy way of 'nulling' those accounts

[wilt]

In terms of stopping those that have received the gv's from redeeming them, u will need to run this query in phpmyadmin

update coupons set coupon_active = 'N', coupon_amount=0 where  coupon_amount=500;

This assumes that you do not expect anyone else to have a GV for $500, apart from those that you sent the GV too.

This will not affect those that have already redeemed the GV.

Amending those orders with Gv's already used, may prove to be much more of a challenge

[wilt]

Hi Again

To zero the accounts of those that have already redeemed the Gift Certificate, but not used it. you will need to run this query in phpMyAdmin

update `coupon_gv_customer` set amount=0 where amount=500;

Again that assumes that you do not expect to have any legitimate customers with a GV balance of $500

[snowkrash]

Okay, yep the first thing I did was to uninstall the GC module in Order Total. But when I clicked on my email to redeem it after I did that, redeeming it worked!

So, I am going to run those queries now on the db. Man, thanks for answering so fast. I'm posting the results when I'm done.

Thanks!

Kristin

[wilt]

Just to clarify as well,

when I said

Hi,

To get your site back up quickly, you should disable the GV module in admin.

admin->modules->order_total

This will ensure that those who have GV's cannot redeem them

It also means that those who have redeemed their GV, will not be able to use them as payment either.

[snowkrash]

Okay, wow!

I did that and it worked!

We happened to have some legitimate GC redeemed in there with the highest amount being $300, so what I did was change one of those queries you gave me... the one that wiped out the balance if it equaled 500, I said if it is greater than 400 (because a few had multiple customer accounts with separate email addresses and had redeemed 2 and three of these totalling 1000 and 1500!) so I did this instead:

update `coupon_gv_customer` set amount=0 where amount>400;

Wow! it all worked! So, now I can reinstall the GC module and turn the site back on!

THANK YOU!!!!!!

[snowkrash]

Just to clarify as well,

when I said

<quote>Hi,

To get your site back up quickly, you should disable the GV module in admin.

admin->modules->order_total

This will ensure that those who have GV's cannot redeem them
</quote>

It also means that those who have redeemed their GV, will not be able to use them as payment either.

that happens to be ok in this case!