Forums / Discounts/Coupons, Gift Certificates, Newsletters, Ads / Single recipient and removing credit

Single recipient and removing credit

Locked

Views: 1,750

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
9 Jun 2009, 10:45 AM
#1
dreamwater avatar

dreamwater

New Zenner

Join Date:
Jan 2008
Location:
NSW, Australia
Posts:
5
Plugin Contributions:
0

Single recipient and removing credit

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 :D

DW

9 Jun 2009, 12:58 PM
#2
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Single recipient and removing credit

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.

20 years a Zencart User

9 Jun 2009, 1:08 PM
#3
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Single recipient and removing credit

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`;

20 years a Zencart User

12 Jun 2009, 4:28 AM
#4
dreamwater avatar

dreamwater

New Zenner

Join Date:
Jan 2008
Location:
NSW, Australia
Posts:
5
Plugin Contributions:
0

Re: Single recipient and removing credit

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

13 Nov 2009, 10:36 PM
#5
cspan27 avatar

cspan27

New Zenner

Join Date:
Jun 2009
Location:
Saskatoon, SK Canada
Posts:
20
Plugin Contributions:
0

Re: Single recipient and removing credit

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!:clap: