Forums / Discounts/Coupons, Gift Certificates, Newsletters, Ads / Cancel Gift Voucher from GV QUEUE

Cancel Gift Voucher from GV QUEUE

Started by mshultise on 18 Dec 2015, 10:28 AM · Views: 1,818

Results 1 to 3 of 3
18 Dec 2015, 10:28 AM
#1
mshultise avatar

mshultise

Zen Follower

Join Date:
Feb 2005
Location:
Captain Cook, Hawaii
Posts:
172
Plugin Contributions:
0

Cancel Gift Voucher from GV QUEUE

This is similar to the GV CANCEL thread but slightly different.

I am running 1.5.4.

I created a product with the model "GIFT BASKET-SC" and a customer bought it. However I had forgotten that models with the name starting GIFT would create a voucher and place it in the queue to be released and used by a customer. I sent the customer an actual physical gift basket.

Thus I now have a pending gift voucher in the COUPON_GV_QUEUE with a RELEASE FLAG of N. It is not yet listed in the COUPONS table. I assume once it is released, it moves from COUPON_GV_QUEUE to COUPONS and an email is sent to the customer.

Can I just delete this entry in COUPON_GV_QUEUE with MySQL? If I release it in Admin, the customer gets an email and I'd prefer that doesn't happen. He already received a physical gift basket and I don't want to have to explain to him why he got an email saying he has $50 to spend now, but I am cancelling it.

I have since changed my gift basket models to not start with GIFT :-)

Aloha from Hawaii! (its a dirty job, but SOMEBODY has to live here...)

18 Dec 2015, 2:06 PM
#2
ajeh avatar

ajeh

Oba-san

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

Re: Cancel Gift Voucher from GV QUEUE

The GV that are queued are located in the table:
coupon_gv_queue

These can be cancelled by marking them:
release_flag

as C so that they are not available to be released in the normal manner ...

While marking them Y would also work, I prefer to use the C for Cancel so it stands out differently than the normal flags of Y or N ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

30 Dec 2015, 12:06 AM
#3
mshultise avatar

mshultise

Zen Follower

Join Date:
Feb 2005
Location:
Captain Cook, Hawaii
Posts:
172
Plugin Contributions:
0

Re: Cancel Gift Voucher from GV QUEUE

Mahalo (Thank You)

Aloha from Hawaii! (its a dirty job, but SOMEBODY has to live here...)