Remove "redeemed" gift certificate

I e-mailed a gift certificate to a customer for information purposes only (only way I know of to generate the code) since they intended to give it to someone else. The problem is, they clicked on the link provided in the email and accidently redeemed the gift into their customer profile.

Is there any way to delete this gift certificate from the system and therefore from their customer profile?

From now on in cases such as this I'll send the code to myself unless there's another solution.

Thanks for your help!

You could just tell them to send it to their friend via email using the Gift Certificate FAQ from the information box or from their My Account ...

That would be the cleanest method to use ...

Hi,
I have a Gift Certificate in the store that is shown as Not Redeemed, but the customer walked into the physical store and used the Gift Certificate.

I need to remove that Not Redeemed Cert from the database, so they don't use it in the online store.

I figured I can find that in the phpmyadmin, but how do you delete it? Or do you set it to zero?

I do not want to cause havic in my database.
I have backed it up...

Thanks
John

elkbow:

Hi,
I have a Gift Certificate in the store that is shown as Not Redeemed, but the customer walked into the physical store and used the Gift Certificate.

I need to remove that Not Redeemed Cert from the database, so they don't use it in the online store.

I figured I can find that in the phpmyadmin, but how do you delete it? Or do you set it to zero?

I do not want to cause havic in my database.
I have backed it up...

Thanks
John

Here's what I did. - Version 1.3.8a

I went to phpmyadmin and found the certificate and edited it to read zero. I did not delete the cert.

I went to the store - logged in - and tried to use the cert code and zowie - it read 0.00.

Hence the method of zeroing out that amount in phpmyadmin apparently works.

Thanks

You could also have just claimed it with your own test account as who ever claims it first ... wins ... :cool:

Thanks for the update on how you handled this ... :smile:

Perfect,

It should of dawned on me after I did make a test with the redeem code and found it to be zero.

Thanks
John

You can in fact delete the entry in the database table zencart_coupon_gv_customer which corresponds with the customer whose gift voucher balance you want to remove.

For example, my test account had a balance of $35. In this database table I found an entry with the customer ID of 2 (my test account) and value of 35.00 ($35). I deleted this entry, and upon refreshing the page my test account was logged in on, the gift voucher balance disappeared completely.

In your case, since they had already redeemed the gift certificate, you would have to either send them another one, after removing the balance from their account, or alternatively you could "un-redeem" the certificate with further database editing, if they wanted to be able to use the same certificate redemption code (for example, if they had already printed it to give to someone), although I haven't been able to get this to work myself.

Dean

Ok, so I did the worst thing possible, I wanted to delete redeemed gift cert info, and deleted the WHOLE coupons_gv_customers table from my DATABASE (php my admin) - Is there ANY way to recover this ONE table? If not, what do I do... and no I didn't have a backup
ugh.... thank you!

staceyx:

Ok, so I did the worst thing possible, I wanted to delete redeemed gift cert info, and deleted the WHOLE coupons_gv_customers table from my DATABASE (php my admin) - Is there ANY way to recover this ONE table? If not, what do I do... and no I didn't have a backup
ugh.... thank you!

Don't know if this will work, but go to phpMyadmin and just click your Zencart database to show all tables. At the bottom you see " Insert Table"

Follow the images:

Thank you SO much for the speedy reply! Ok, first screen create table: coupon_gv_customer - under that what number? 2?

Then the NEXT screen that I get is the one pictured? (not the next on you put up) can you tell me what to do on this one please?

Attachment #5800

staceyx:

Thank you SO much for the speedy reply! Ok, first screen create table: coupon_gv_customer - under that what number? 2?

Then the NEXT screen that I get is the one pictured? (not the next on you put up) can you tell me what to do on this one please?

Attachment #5800

Type in the Field, Type, Null and default.

That would be the values...

Elbow, I CANNOT thank you enough - actually all who has replied - I DID call my host (1and1) they are sending me a backup (48hrs) BUT thanks to your photos and instructions, I WAS ABLE TO RESTORE the table! And yes, shop was NOT live yet , so no info lost!! Now... can anyone tell me how to "empty" sent gift certificates, as we have been in test mode we have a ton in there... thank you thank you! Oh one more thing, and I don't know if you can help - when checking out... Here is the scenarion

They put in code MSJ50 (which is the code i put in the back end for certificate worth $50)
Then they purchased a necklace for $29.99, went to shopping cart. at check out It added shipping of $2.25 and tax of $2.10, all cool so far.
Then it took off the $29.99 and the $2.25 for a total of $32.24 (because they had the gc code of $50) but left them with a balance to pay of $2.10 (tax) when it should have been zero since the GC was worth $50.00.

Are my order total settings in the wrong order?