Cancel Gift Certificate Order

[disciple]

Hi,

We had a customer purchase a gift certificate and have not received payment. We have cancelled the order but the certificate still shows in the gift que. How can we delete it safely out of the que?

If we release it will it recognize that the order has been cancelled?

Thanks

Rick

[Ajeh]

Don't release it that puts the GVs in the customer's account ...

Gift Certificates were not meant to be deleted as they are cash ...

At this time, there is not a simple method to manage the GVs for deletions because of this ...

You will need to manual edit the database to remove that GV ...

In phpMyAdmin, you can browse the coupon_gv_queue table and find the GV for that order ...

Carefully delete just that 1 record ...

NOTE: Backups are always a nice thing before doing something beyond the norm ...

[mshultise]

However, a common scenerio that leaves a gift cert in the queue that needs to be removed, would be where a person says they will pay for the certificate by sending in a check (which bounces or never arrives).

In that scenerio, I would cancel the original order, and the cert would still be in the queue.

[Ajeh]

That is why we are looking into expanding this code, but we do need to be careful as we are saying to delete cash ...

[mshultise]

Perhaps the cert could be redirected to the Admin's email. Anyway, just a thought.

[giwe101]

Do any one know how to get rid of the coupon and gift certificate page?
I have been going through the admin menys all night!!

[giwe101]

ALRIGHT!!! found the answer in... Configuring the Zen Cart Admin -> Gift Certificate Configuration ... forum

[Ajeh]

Thanks for the update and solution!

[JTCasinoGames]

That is why we are looking into expanding this code, but we do need to be careful as we are saying to delete cash ...

Has this ever been changed?
I set up a gift certificate and manually emailed it to myself to see how it worked.
I used the redemtion link that comes in the email and it put the money into my account. Saying I have a 25$ gift certificate balance...

Is there a way I can set that balance back to zero that I know it worked?

[Ajeh]

Go to phpMyAdmin ...

Find the table:
coupon_gv_customer

Find the correct customers_id ...

Change the amount ...

All done ...

NOTE: This is a bad way to manage this data as you are dealing in CASH and there are NO records of where that CASH went to ...

This will be addressed in a future release ...