Reset coupon use count for a specific coupon for a specific customer

[FASA_Andrew]

I'm running ZC 1.5.5b, kindly do not tell me to upgrade, I know we need to but there are barriers.

I've read through the first five pages of this section of the forum, and performed searches on the FAQs.

How do you reset the coupon use count for a specific coupon for a specific customer? There obviously is a value in the DB somewhere that tracks how many times a customer has used a specific coupon. I need to reset that to zero for a customer, so that they can get a group discount they are entitled to.

[balihr]

First, know your coupon ID. You can navigate to your Coupon Admin, click the coupon and then look at the URL - it will have a cid parameter, something like cid=16. In this example, your coupon ID would be 16.
Next, know your customer ID. It's the first column in your customers listing. Let's say for our example customer ID would be 3568.

Go to Tools->Install SQL Patches and run the following query (BACKUP your database before running any SQL queries):

DELETE FROM coupon_redeem_track WHERE coupon_id = '16' AND customer_id = '3568';

This should allow that single customer to use that coupon again.

[mc12345678]

First, know your coupon ID. You can navigate to your Coupon Admin, click the coupon and then look at the URL - it will have a cid parameter, something like cid=16. In this example, your coupon ID would be 16.
Next, know your customer ID. It's the first column in your customers listing. Let's say for our example customer ID would be 3568.

Go to Tools->Install SQL Patches and run the following query (BACKUP your database before running any SQL queries):

DELETE FROM coupon_redeem_track WHERE coupon_id = '16' AND customer_id = '3568';

This should allow that single customer to use that coupon again.

Note that this is as if the customer had never used that coupon in the past. If the coupon had say a use count per user of 5, then it will be as if they have used it 0 times and can then use it 5 times.

It does appear that if you wish to reduce the number of uses say by one, that will want to modify the above to account for a "date" or other field in the associated table and limit to 1 or whatever number of permissions back you wish to offer (e.g. Limit 2, limit 3, etc)