Coupon Code Usage Report?

[kb reuben]

I am currently using ZC1.3.8a. Would like to run a report showing all the one-time coupon codes that have been redeemed. I currently have over 5,000 codes in my system and would like to purge the codes that have been used. Is there a way to run a report showing the used codes? Thanks!

[jackie.taferner]

I'm not sure of a "report" per se, but this might help you out...

WARNING: DON'T CHANGE anything in your database, it CAN break your site. This is only for reviewing purposes.

1. Go to your phpmyadmin
2. open the 'orders' table
3. click Export, select XLS, then GO
4. That'll give you an Excel spreadsheet with all your orders... in particular you'll want to look at the 'coupon_code' column

Once you've got your list, go to admin and click Gift Certificates/Coupons > Coupon Admin, and delete whatever coupons you wish.

If you find yourself needing to do this often, you might find an Orders Exporter useful: http://www.zen-cart.com/index.php?ma...roducts_id=797