Activating an Inactive Coupon in Zen Cart
Recently a client needed to re-activate a coupon in Zen Cart. She wanted to re-use the exact same coupon but had inactivated the original.
After exploring the Zen admin, I could find no way to re-activate a inactive coupon so used the SQL query below.
Copy and the code below and paste it in Tools -> Install SQL Patches. Make sure you change the coupon_id to the number that you would like to re-activate. To get the id number, click on the name in Gift Certificate/Coupons -> Coupon Admin, the id is in the right column, in square brackets before the coupon name. And, as always, BACK UP YOUR DATABASE before making any changes to your Zen Cart installation.
UPDATE `coupons` SET `coupon_active` = 'Y' WHERE `coupons`.`coupon_id` =22 LIMIT 1 ;