HELP : Cancel Voucher!!

[Fett]

I tried to send a coupon code out to members of my store, but mistakenly sent them each a $15.00 credit for the site...

I emailed them all immediately to state the error I had made - not something I liked doing...

Is there a way to remove the codes the site generated - so if the user does click on the link to apply the credit to their account, that nothing happens...

[dbltoe]

Head over to the admin and go to the Gift Certificate/Coupons menu. Select Coupon Admin and edit or delete as you see fit.

[Fett]

It's not a coupon. It's a voucher for $15.00.
I see the voucher codes listed to each user - but no way to remove them.

[Ajeh]

Gift Certificates that are created in the Admin create a record in the table:
coupons

You might look, via phpMyAdmin, to see if there is a gang of them in the coupons table for the
coupon_type G
coupon_amount 15.00

And, rather than delete them, set the
coupon_active

to be: N

so that future Gift Certificates can never use these coupon_code values ...

[Fett]

Gift Certificates that are created in the Admin create a record in the table:
coupons

You might look, via phpMyAdmin, to see if there is a gang of them in the coupons table for the
coupon_type G
coupon_amount 15.00

And, rather than delete them, set the
coupon_active

to be: N

so that future Gift Certificates can never use these coupon_code values ...

Thanks!
I also found that if I just shut off the GV section, then all is well. ;-)

I offer discounts, and those codes work - so I'll have no use for the GV section anyway. :-)

[Ajeh]

Be aware ... going the the Modules ... Order Totals ... and uninstalling the Gift Certificates ot_gv does NOT prevent a customer from redeeming the Gift Certificates sent to them in email ...

While they will not be able to checkout with the Gift Certificates that they redeemed, this can cause issues for those who redeem the Gift Certificates that you sent where they would get a successful redemption, following the link in the email ...

Setting those Gift Certificates to:
coupon_active N

would result in a failure on any attempt to redeem them ...

[wildchick]

I too made the same mistake of sending $5 gift certificates to all customers who purchased w/ subscription(total 71 people). Now I want to send it to all customers who puchased(100), which means I will end up resending it to 71 cusomters.

Now some people have already claimed the $5 GC. Is it possible for me to delete all the GV from PHPmyadmin and If I do, for the ones that claimed the $5, will there voucher still be valid?

Then I can resend to all 100, and I dont mind if 5 people get an extra $5.

[clutch_kick]

I followed this thread and I cannot quite fix my problem yet.

I had offered a 10 euro gift voucher to a customer, he utilised it in a transaction, but after paying with Paypal, I guess he did not confirm the order on my Zen Cart Site. This resulted in the order not being processed but I still received the money from Paypal, and the voucher was used. My problem is this, since the order did not register, he is still showing as having a gift voucher to his name.

I followed this thread, and did go to phpMyAdmin, looked at coupon_type and the status is showing as N ... how can i remove this record?