Gift Certificate Help Please

[Ajeh]

Using phpMyAdmin, browse your database table:
coupon_gv_queue

and find the GV for the customer and you need to mark the:
release_flag

as X

What this does in keep a record of the GV but not release it to the customer ... now it will not show but if you need to reference it you can see it in the database and in your Admin under the GVs sent ... it will show as not redeemed ...

If you do not want this record of this transaction at all, you can delete it from the:
coupon_gv_queue

[thatonekitten]

Thank you hon !

So much help.

[vwebworld]

Using Zen Car v1.3.9h. Customer purchased gift certificate, but it doesn't appear in the gift queue. Looking at the database table - coupon_gv_queue, the release_flag shows "Y".
he customer says she doesn't have it. How can I tell if it was sent to the customer??

Thanks, ROland

[Mr.Pibb]

I've found various comments and threads regarding this, but I wanted to chime in and request that an option to reject/cancel gift certificates be added to the gift certificate functionality. I've seen some of the previously listed reasons for not having that function available, but as the person managing the store, it is really making things difficult especially for this time of year. I get a fairly large number of people attempting to use stolen credit cards in my store because of the types of items I carry. My fraud filters with PayPal do a pretty good job catching them, but they aren't perfect.

Gift certificates are a common target, as the buyer can enter the actual billing address for the card user, but not worry if the shipping address is correct. This makes it more likely that the purchase will clear the fraud filters. I usually still catch the fraudulent purchases because I just know what to look for, but then I'm stuck with a gift certificate sitting in the queue even if I cancel and refund the original purchase. This has happened when a customer changed their mind as well, and it seems like a lot of extra work that could be solved by simply adding a "reject" button. To me, it's just like any other product that can be canceled. I understand that the gift certificate can be used like money once it's approved, but prior to that it's not any different than any other product.

I really appreciate what the developers have done regarding Zen Cart, but for me it would save a lot of trouble if I had a way to reject the gift certificates. It seems that if I have an option to accept them in the first place, logic would say that I should be able to NOT accept them too!

Thanks!
Tim