HELP : Cancel Voucher!!

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...

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

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.

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 ...

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 ...

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. :-)

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 ...

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.

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?

So no one has created a plugin to edit GV amounts without going to the tables?

I am working on something for the Gift Certificates ...

What tables do you usually find yourself touching and what changes are you making manually?

Thanks for the response. I haven't edited the table values yet but I haven't found a way to zero out a customer's gift voucher amount using the admin pages yet. I understand that we can manage gift certificates but can we manually clear GV amounts? I have a couple of customers purchase gift vouchers as products online and they couldn't figure out to send the vouchers to themselves to get the codes to write on a printed gift certificate and at the time I didn't realize that is what they had to do. I manually created gift certificate codes which they have now used but they still have GV amounts which need to be deleted.

As I say, I am working on something for this ...

Currently, these changes would have to be manually done with phpMyAdmin ...

To Cancel a Gift Certificate, what I will be using in the table:
coupons

is setting the field:
coupon_active

to C for Canceled ... and this will prevent the Gift Certificate from being redeemed by anyone ...

What version of Zen Cart are you using? I am building this for v1.6, and will probably be adapting it for v1.5.4 ...