Page 1 of 2 12 LastLast
Results 1 to 10 of 14
  1. #1
    Join Date
    Mar 2009
    Location
    France
    Posts
    158
    Plugin Contributions
    0

    help question Gift certificate cancel : how to ?

    Hello,

    one customer buy a gift certificate and now would like it to be refunded, how to delete/cancel a gift certificate in admin ? I only have option to confirm it ....

    Thank you

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

    Default Re: Gift certificate cancel : how to ?

    If you mailed a Gift Certificates that has not been redeemed yet would need to be manually disabled ...

    In phpMyAdmin, go to the table:
    coupons

    and find the Gift Certificate that you want to disable and set the:
    coupon_active

    to N ...


    If a customer purchased a Gift Certificate that has not been redeemed yet ...

    In phpMyAdmin, go to the table:
    coupon_gv_queue

    and find the Gift Certificate that you want to disable and set the:
    release_flag

    to Y ...
    Last edited by Ajeh; 8 Sep 2011 at 02:46 PM.
    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
    Jan 2010
    Posts
    31
    Plugin Contributions
    0

    Default Re: Gift certificate cancel : how to ?

    Quote Originally Posted by Ajeh View Post
    If you mailed a Gift Certificates that has not been redeemed yet would need to be manually disabled ...

    In phpMyAdmin, go to the table:
    coupons

    and find the Gift Certificate that you want to disable and set the:
    coupon_active

    to N ...

    ...
    can we directly delete it instead of set it to N?

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

    Default Re: Gift certificate cancel : how to ?

    You could delete it but you would not have a record of it and on the wild off chance that the code was ever regenerated you would not want that to happen ...
    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!

  5. #5
    Join Date
    Jan 2010
    Posts
    31
    Plugin Contributions
    0

    Default Re: Gift certificate cancel : how to ?

    oh ok thanks :)

  6. #6
    Join Date
    Oct 2011
    Posts
    1
    Plugin Contributions
    0

    Default Re: Gift certificate cancel : how to ?

    I'm in pspAdmin and do not see a table that says coupon can someone please help me???

  7. #7
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,024
    Plugin Contributions
    3

    Default Re: Gift certificate cancel : how to ?

    Pretty much has to be there - are you sure you're looking in the right database ? (It's coupons, with an s.)

  8. #8
    Join Date
    Dec 2010
    Location
    Thailand
    Posts
    300
    Plugin Contributions
    2

    Default Re: Gift certificate cancel : how to ?

    Quote Originally Posted by Ajeh View Post
    If you mailed a Gift Certificates that has not been redeemed yet would need to be manually disabled ...

    In phpMyAdmin, go to the table:
    coupons

    and find the Gift Certificate that you want to disable and set the:
    coupon_active
    Hi Ajeh, is this also the way to proceed in case the gift certificate has already been redeemed but not yet used to make a purchase?

    A customer says that when she tried to redeem her certificate, she got an error message, whereas the admin shows that she indeed has well redeemed her certificate. I'd like to try and cancel that one certificate and email her a new one.

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

    Default Re: Gift certificate cancel : how to ?

    No this is a way to wipe out all records relating to Discount Coupons and Gift Certificates ...

    How did the customer get her Gift Certificate that she says she cannot redeem that you see in her balance?

    A GV sent from the Admin would show on the Gift Certificate Sent:

    Senders Name Gift Certificate Value Redemption Code Date Sent Date Redeemed
    Admin $27.00 1cf7e04995 12/20/2011 14:00:40 Not Redeemed

    Clicking on that GV you would see on the right panel:
    Senders ID: 0
    Amount Sent: $27.00
    Date Sent: 12/20/2011 14:00:40
    Redemption Code: 1cf7e04995
    Email Addr: someone@some_domain.com

    Not Redeemed
    A redeemed Gift Certificate would look like:

    Senders Name Gift Certificate Value Redemption Code Date Sent Date Redeemed
    Admin $27.00 1cf7e04995 12/20/2011 14:00:40 12/20/2011 14:16:08

    Click on the Gv and you would see on the right panel:
    Senders ID: 0
    Amount Sent: $27.00
    Date Sent: 12/20/2011 14:00:40
    Redemption Code: 1cf7e04995
    Email Addr: someone@some_domain.com

    Date Redeemed: 12/20/2011 14:16:08
    IP Address: 84.139.53.113
    Customer Id: 2

    In the customer's My Account they would see a box containing:

    Gift Certificate Account
    You have a balance available in your Gift Certificate account. You may spend it or send it to someone else. To send click the button below.
    Your Gift Certificate balance is: $27.00

    If they go to the GV FAQ when logged in they would also see:

    Gift Certificate Account
    You have a balance available in your Gift Certificate account. You may spend it or send it to someone else. To send click the button below.
    Your Gift Certificate balance is: $27.00

    When they go to checkout, on the checkout_payment page they would see in the Gift Certificate box:

    Gift Certificates
    To use Gift Certificate funds already in your account, type the amount you wish to apply in the box that says 'Apply Amount'. You will need to choose a payment method, then click the continue button to apply the funds to your shopping cart.
    If you are redeeming a new Gift Certificate you should type the number into the box next to Redemption Code. The amount redeemed will be added to your account when you click the continue button.

    Redemption Code ___ Apply Amount:
    ___ Available balance: $27.00

    To use some or all of their available balance, enter the Apply Amount up to 27.00 in the box.


    Have you looked in the database at the tables that start with:
    coupon

    to see what has happened?

    NOTE: once redeemed, you cannot redeem again, you need to either Apply Amount from the Balance on the checkout_payment page or Send an amount to a Friend.

    NOTE: if you are not really familiar with all that the customer is seeing, create an account and test sending a GV to that email from the Admin and see how all of this looks ...

    NOTE: also check what happens when you, the customer, buys a Gift Certificate (if you sell them) so you know how that works and how the GV Queue works ...
    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!

  10. #10
    Join Date
    Dec 2010
    Location
    Thailand
    Posts
    300
    Plugin Contributions
    2

    Default Re: Gift certificate cancel : how to ?

    How did the customer get her Gift Certificate that she says she cannot redeem that you see in her balance?
    I sent it to them via the admin and it's been well redeemed as it looks like what you've indicated, i.e.:

    Senders Name Gift Certificate Value Redemption Code Date Sent Date Redeemed
    Admin $27.00 1cf7e04995 12/20/2011 14:00:40 12/20/2011 14:16:08

    Click on the Gv and you would see on the right panel:
    Senders ID: 0
    Amount Sent: $27.00
    Date Sent: 12/20/2011 14:00:40
    Redemption Code: 1cf7e04995
    Email Addr: someone@some_domain.com

    Date Redeemed: 12/20/2011 14:16:08
    IP Address: 84.139.53.113
    Customer Id: 2
    I'm quite certain the gift certificates work perfectly as other customers have been using them successfully. Just in case, I've also just sent one to myself and redeemed/used it succesfully.

    The entries shown in the database under that certificate look also normal.

    They didn't give me any feedback as to whether there's any balance in their account. They believe their emails have been hacked but yet confirms that the IP address that has redeemed the certificate (as shown in the admin) is indeed theirs.

    I'm not sure what went wrong but am also getting a little suspicious. Is there any way to cancel that one and just sent them a new one?

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v150 Only show gift certificate option on payment page if customer has a gift certificate
    By ShopVille in forum Templates, Stylesheets, Page Layout
    Replies: 25
    Last Post: 21 Jul 2014, 08:03 PM
  2. v139a Emergency: Gift certificate disaster -- how to cancel?
    By jgold723 in forum General Questions
    Replies: 3
    Last Post: 4 Dec 2013, 02:11 AM
  3. A way to cancel/redeem Gift Certificate
    By ykaldes in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 1
    Last Post: 6 Aug 2009, 01:45 AM
  4. Cancel Gift Certificate Order
    By disciple in forum General Questions
    Replies: 11
    Last Post: 9 Jul 2008, 09:49 PM
  5. Want to use a printed gift certificate (with code) in the gift certificate process?
    By HelenSama in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 9
    Last Post: 15 Apr 2008, 02:04 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