Gift Certificate Help Please

[kevinw]

How can I determine how much is in the Gift Certificate bank of a customer?
I can see when they email gifts to another, but I don't see their amount.
I am sure everything works perfectly, it is just a check..
Short of looking in the mysql db.

We got our website live and the 3rd order was for a gift certificate... Cool..


Thanks...

[Ajeh]

How can I determine how much is in the Gift Certificate bank of a customer?
I can see when they email gifts to another, but I don't see their amount.
I am sure everything works perfectly, it is just a check..
Short of looking in the mysql db.

We got our website live and the 3rd order was for a gift certificate... Cool..


Thanks...

You can browse, in phpMyAdmin, the table coupon_gv_customer

In the upcoming v1.3.8 you will see the customers' balance on the customers.php in the Admin if Gift Certificates are installed ...

[kevinw]

Thank You, now I can see the balance of current Gift Vouchers...
Be Well

[wendyshirai]

I am selling Physical Gift Cards and Virtual Gift Certs and i just discovered that both of them are crediting as a Gift Cert value to the customers gift cert balance.

This is a disaster! This CANNOT happen - how do i fix it?

[wendyshirai]

I figured out that they both had model numbers that started with GIFT but how do I reverse the values from a customer's account now for the gift cards that got in the mail and then they got a credit on their gift cert balance too?

Please help! I can't open my store again until i fix this!

[Ajeh]

You would need to go into your phpMyAdmin and manually update the customer balance for any affected customer in the table for the coupon_gv_customer ...

[wendyshirai]

yes, after i calmed down from my panic attack, i realized that. i was very careful to back up my database first and then i went in and edited that table. It always makes me so nervous to touch the tables, it's like touching the cart's eyeball! Anyways, i'm back in business now. Thanks. :)

[Ajeh]

Thanks for the update that you were able to fix this problem and for posting the cause of this issue ...

[dano2004]

Make sure you use GIFT-xxxxx . I only had 4 x's and it would not show the shopping cart! About drove me crazy!

[Tagyourbaby]

I have a question im trying to do a dummy purchase of a gift voucher however the only payment option available for it is paymate and i want to be able to offer internet banking (direct deposit) what do i need to do? They are all activated but only showing paymate.

Thanks