Can I see if Gift Certificates were used

Is there a way for me to check a Gift Certificates to see if a user has used it and which used has used it?

Do you know the GV redemption code?

Ajeh:

Do you know the GV redemption code?
Yes, I can find the redemption code. If I know it, is there a way to find out who used the Cert?

Might be a bit, but I have been fooling around with code for that and I just have to look through 5-10 domains and 6-20 installs on each of those to remember where I put that code to see this kind of information ... :lookaroun

Prior to this mircle discovery ...

In phpMyAdmin, find the coupon code in the table:
coupon

and get the coupon_id ...

Then, to find who it was sent from/to look in the table:
coupon_email_track

Then to see who redeemed it look in the table:
coupon_email_track

Then to find the customer look in the table:
customers

then .... pray I find this code I was working on, as I was building it all into the gv_sent to make life easier ...

Granted now, I have to add a search on GV code/Customer/etc. because of you ... but that is a great idea ... thud :blink:

I tried what you said and here is what I came up with

get the coupon_id ...
11

Then, to find who it was sent from/to look in the table:
coupon_email_track
from: ADIM to: [email protected]

Then to see who redeemed it look in the table:
coupon_email_track
I don't see what your talking about here. I have included an attached image

Then to find the customer look in the table:
customers

And if you then look at the table:
customers

for the matching email address you saw in the field:
emailed_to

And if redeemed, in the table:
coupon_redeem_track

you should find a match for the coupon_id with a listing for the customer_id that you can match to the table:
customers