Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2007
    Posts
    85
    Plugin Contributions
    0

    Default Clear gift certificate queue

    Hi,
    In my admin, I have the message "2 waiting approval", but my gift queue is empty.I deleted a testorder without approving the coupled gifts... .

    I assume I have to empty a table of my database? Which?
    Thanks!

  2. #2
    Join Date
    Dec 2007
    Posts
    85
    Plugin Contributions
    0

    Default Re: Clear gift certificate queue

    Anyone have any idea?
    Thanks!

  3. #3
    Join Date
    Mar 2008
    Location
    Cape Town & London (depends on the season)
    Posts
    2,975
    Plugin Contributions
    0

    Default Re: Clear gift certificate queue

    If you have phpMyAdmin, look at:-

    coupon_gv_customer

    and

    coupon_gv_queue

    If there are records in these two, open them to edit/change (click the pencil icon) and remove the references as needed.

  4. #4
    Join Date
    Dec 2007
    Posts
    85
    Plugin Contributions
    0

    Default Re: Clear gift certificate queue

    Thanks for your reply.
    Database noob here...

    This is what I have for the coupon_gv_customer:


    This is what I have for the coupon_gv_queue:


    What should I alter? I have 2 GV's queued.
    Hope you can help me out.
    Thanks!

  5. #5
    Join Date
    Mar 2008
    Location
    Cape Town & London (depends on the season)
    Posts
    2,975
    Plugin Contributions
    0

    Default Re: Clear gift certificate queue

    In phpMyAdmin, you need to display the CONTENT, not the STRUCTURE. Click on the folder icon NEXT TO the table name - not the name itself.

  6. #6
    Join Date
    Dec 2007
    Posts
    85
    Plugin Contributions
    0

    Default Re: Clear gift certificate queue

    Ah, thanks!

  7. #7
    Join Date
    Dec 2006
    Location
    Bucharest, Romania
    Posts
    50
    Plugin Contributions
    0

    Default Re: Clear gift certificate queue

    Sorry to post in this old thread but I accidentally deleted (dropped) the customer_id in phpmyadmin from zen_coupon_gv_customer and zen_coupon_gv_queue
    (ALTER TABLE `zen_coupon_gv_customer` DROP
    `customer_id`
    and the same for the other one), is there anything I can do to put it back? Thanks.

  8. #8
    Join Date
    Dec 2006
    Location
    Bucharest, Romania
    Posts
    50
    Plugin Contributions
    0

    Default Re: Clear gift certificate queue

    I restored it from a backup :) And I emptied both tables and I got rid of the gift certificate queue waiting approval ...

 

 

Similar Threads

  1. v150 Gift Certificate E-mail & Queue Issue
    By angellionel in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 10
    Last Post: 7 Feb 2012, 05:39 AM
  2. 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
  3. Gift Certificate order does NOT come up in queue
    By blakemiller in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 2
    Last Post: 14 Jun 2008, 02:19 AM
  4. Bypass Gift Certificate Queue
    By sparrish in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 3
    Last Post: 20 Sep 2006, 06:26 AM
  5. How do I delete a gift certificate in the queue?
    By takeaclass in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 3
    Last Post: 24 Jun 2006, 06:34 AM

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