Zen Cart Logo
Forums / Discounts/Coupons, Gift Certificates, Newsletters, Ads / Setting a specific Redemption Code for Gift Certificates

Setting a specific Redemption Code for Gift Certificates

Views: 1,112

Results 1 to 5 of 5
6 Jun 2015, 7:41 PM
#1
avaadorn avatar

avaadorn

Zen Follower

Join Date:
Feb 2012
Posts:
106
Plugin Contributions:
0

Setting a specific Redemption Code for Gift Certificates

Is there a way to create specific redemption codes for gift certificates/cards? I don't want to create a coupon code because different rules apply for those (such as including tax and shipping). Plus, the coupon code is redeemed in a different redemption box. I want the customer to redeem the code in the gift certificate box. I am having gift cards printed with a different 10-digit redemption code on each. I tried adding the codes in the phpMyAdmin database by copying an existing gift certificate, but when I tested the redemption code, it did not work. Is there any way to do this?

If I send myself the gift certificate, then Zen Cart generates a random 10-digit code and I don't want that. The cards could not be printed that way.

6 Jun 2015, 7:48 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Setting a specific Redemption Code for Gift Certificates

When creating Gift Certificates you need an entry in the tables:
coupons
coupon_email_track

6 Jun 2015, 7:53 PM
#3
avaadorn avatar

avaadorn

Zen Follower

Join Date:
Feb 2012
Posts:
106
Plugin Contributions:
0

Re: Setting a specific Redemption Code for Gift Certificates

Perfect! That works. Thanks again, Ajeh! Is there a way to un-redeem the gift cert that I just tested?

6 Jun 2015, 7:56 PM
#4
avaadorn avatar

avaadorn

Zen Follower

Join Date:
Feb 2012
Posts:
106
Plugin Contributions:
0

Re: Setting a specific Redemption Code for Gift Certificates

I just deleted the entry in coupon_redeem_track and that seemed to work. Thanks!

6 Jun 2015, 10:43 PM
#5
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Setting a specific Redemption Code for Gift Certificates

You should delete from:
coupons
coupon_redeem_track