How to Temporarily disable gift certificate?

[amy2]

I have despatched some gift certificates to a customer (printed out ones I've produced using my own email address) Unfortunately there has been a problem with payment and until this is sorted I would like to disable the gift certificates I sent. (I want to keep other gift certificates working) Does anyone know how to do this.
I'm using version 1.3.8a and the gift certificates are all unredeemed in the "gift certificates sent" section. Thanks

[Ajeh]

You could edit the coupons table and browse it for these Gift Certificates, you will see the field:
coupon_active

Change from Y to X ...

Now it cannot be redeemed ...

Later, if you want them active, just change from X to Y ...

[amy2]

Many thanks for your help, this has worked! I just hope to recieve payment now.

[Ajeh]

Thank you for the update that you were able to temporarily disable the Gift Certificates by changing the coupon active field to X ...