Single recipient and removing credit

[Dreamwater]

Hi All....

Just curious if it is possible to make GC's only redeemable by the original recipient, so they are not able to pass the GC credit to another customer....?

And are you able to remove the credit from a customers account? As in my test customer account has credit from the GC, is there a way to remove the credits?

Cheers

DW

[schoolboy]

Best way to remove GV Queue data is to do so via phpMyAdmin, where in TABLE = `coupon_gv_queue`, you select any/all records that you want to delete. Your table may have a PREFIX... eg: `zen_coupon_gv_queue`

If it is still a TEST shop, and the only data in that table is stuff you've put there for testing, then run the following via your webshop admin panel "Install SQL Ptches" (under TOOLS).

1. BACKUP database before running SQL commands.

2. Run this to EMPTY the whole table:

TRUNCATE TABLE `coupon_gv_queue`;

(No need to use prefixes here as your zc shop will know if it needs to put in a prefix or not.)

Gift Certificates are not so much "products" as they are a PAYMENT METHOD. This is also true in a physical shop too. If I buy a GC over the counter of my local bookshop, they don't care a hoot what I do with it after I take possession of it. I can give it to anyone, who then uses it as if it were cash, in the shop.

Gift Certificates are a way of issuing CREDIT, and, just as they are in physical shops, the value is NEGOTIABLE and TRANSFERABLE - just like real money.

If you want to offer a single customer a voucher that can only be used by them, then set up a COUPON that can only be redeemed by one person once only. E-mail the coupon code to that person and remind them that should they let others see the code, it can be used by a third party.

[schoolboy]

If you moved a GV from the queue to a customer, then you may also need to remove them (via phpAdmin) from the:
`zen_coupon_gv_customer` Table

If you want to completely empty that table, run:

TRUNCATE TABLE `coupon_gv_customer`;

[Dreamwater]

Geez, thanks for that Schoolboy!
I must apologise for the late reply, but I was used to use another well known cart add on for a well used open source CMS, and am used to 3 weeks + wait until you MAY get a reply....to a simple question

Just another feather in the cap for the ZC community!

Cheers!

DW

[cspan27]

Thank you as well!!!

I was looking everywhere in this forum to solve this exact problem with no answers as to how to do it.

Thankfully I stumbled onto this post with exactly the information I needed to solve this problem.

Thanks soo much again...I love the ZC community!