Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Location
    Captain Cook, Hawaii
    Posts
    179
    Plugin Contributions
    0

    Default 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 :-)
    Last edited by mshultise; 18 Dec 2015 at 11:31 AM.
    Aloha from Hawaii! (its a dirty job, but SOMEBODY has to live here...)

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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: v1.5.5]
    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!

  3. #3
    Join Date
    Feb 2005
    Location
    Captain Cook, Hawaii
    Posts
    179
    Plugin Contributions
    0

    Default Re: Cancel Gift Voucher from GV QUEUE

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

 

 

Similar Threads

  1. HELP : Cancel Voucher!!
    By Fett in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 11
    Last Post: 5 Jan 2015, 04:07 PM
  2. Change all references of 'Gift Certificate' to 'Gift Voucher'
    By crashtackle in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 24 Jan 2010, 08:21 PM
  3. Gift Certificate OK Queue, Doesn't send to Gift SENT
    By paperthreads in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 4
    Last Post: 11 Sep 2008, 09:33 PM
  4. Gift Voucher Queue
    By Prellyan in forum Templates, Stylesheets, Page Layout
    Replies: 5
    Last Post: 20 Sep 2006, 06:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR