delete gift certificates

[dcb777]

Hello,

I have looked and I found OLDER versions of what to do, but nothing for the current version.


I'd like to DELETE a gift certificate. I have a customer that personally presented a certificate to me instead of using it with a purchase online, so to keep from any confusion later I'd like to delete it, so it can't be used later OR make the certificate have a balance of $0. Either option is fine I just want to be sure they can't use it later with an on-line purchase.



THANK YOU

[Ajeh]

There are a couple of ways to cancel a GV ...

1 login with your own test account and claim the GV
This method prevents fully deleting the GV for record keeping and you could make your test account just for deleted GVs so that you can track how many are manually claimed.

2 login to you phpMyAdmin and find it in the table:
coupons
and edit it and mark the field:
coupon_active
as: N
The record will still be there but will be marked as in active so it cannot be claimed ...

3 The least desirable method is to delete the record in the database table:
coupons
This destroys all ability to track the GV in any manner ...

[dcb777]

There are a couple of ways to cancel a GV ...

1 login with your own test account and claim the GV
This method prevents fully deleting the GV for record keeping and you could make your test account just for deleted GVs so that you can track how many are manually claimed.

2 login to you phpMyAdmin and find it in the table:
coupons
and edit it and mark the field:
coupon_active
as: N
The record will still be there but will be marked as in active so it cannot be claimed ...

3 The least desirable method is to delete the record in the database table:
coupons

This destroys all ability to track the GV in any manner ...

Thank you for the reply, but I'm a true novice... could you give me a better explanation as where I can find option #2?

I didn't find a file called "coupons" I found coupon-admin and coupon-restrictions

Could you give me more direction please?

THANK YOU

[Ajeh]

The tables are not in the files, your data is all in the database used for your shop ...

To locate your database tables, you would need to use your Control Panel for your domain and use phpMyAdmin, which should be provided by your hosting provider. In the database that you are using for your shop, you will find a database table called:
coupons

If you are not familiar with finding phpMyAdmin, you could contact your hosting provider and see if they can better assist you to locate your database so that you can edit its content ...

[dcb777]

The tables are not in the files, your data is all in the database used for your shop ...

To locate your database tables, you would need to use your Control Panel for your domain and use phpMyAdmin, which should be provided by your hosting provider. In the database that you are using for your shop, you will find a database table called:
coupons



If you are not familiar with finding phpMyAdmin, you could contact your hosting provider and see if they can better assist you to locate your database so that you can edit its content ...

I know how to get to the control panel I was just saying that there's not a file called "coupons"

I found "coupon-admin" and "coupon-restrictions" in my phpMyAdmin on my server, but not a file JUST "coupons" I was hoping someone knew the exact way to get to that file Language/ English/ BLAH BLAH

[Ajeh]

Seriously, you are looking in the wrong place ...

You sound like you got to the Control Panel, but then it sounds like you are using the File Manager ... this is incorrect ... File Manager is for looking at files on your domain ...

NOTE: You would NOT want to use File Manager to work on your files for Zen Cart as you can seriously damage files on your server ...

When you are on your main screen for your Control Panel, look for something called phpMyAdmin ...

phpMyAdmin is for looking at databases ... if you have trouble finding it, try a search with CTRL F for Find and search for:
phpMyAdmin in your browser as it might help you see it in your Control Panel ...

Does that help steer you in the right direction?

[dcb777]

Seriously, you are looking in the wrong place ...

You sound like you got to the Control Panel, but then it sounds like you are using the File Manager ... this is incorrect ... File Manager is for looking at files on your domain ...

NOTE: You would NOT want to use File Manager to work on your files for Zen Cart as you can seriously damage files on your server ...

When you are on your main screen for your Control Panel, look for something called phpMyAdmin ...

phpMyAdmin is for looking at databases ... if you have trouble finding it, try a search with CTRL F for Find and search for:
phpMyAdmin in your browser as it might help you see it in your Control Panel ...

Does that help steer you in the right direction?

You were EXACTLY correct, and with your direction I WAS able to find the correct area and mark the certificates as $0

THANK YOU that was very help, I do appreciate your time and patience!

[Ajeh]

Marking as 0 was not exactly my idea of a perfect solution but it will at least have no value ...

Thanks for the update that you were able to resolve this issue to your satisfaction ...