I have a few coupon codes in my store, and I’d like to be able to track what code a user may have utilised. Inversely, is there a way to see how many times a particular code was used?
Magento – How to find out what user used what coupon code
couponmagento-1promotions
Best Answer
Which customers used which coupons:
I usually shy away from raw db queries, but in this case I will make an exception:
You could do the same with the Magento ORM -
will formulate a writeup on how to do that and edit afterwardand here's how:How many times a coupon was used:
As already pointed out in another answer this is in a report. At the most basic level the query for that would be:
The ORM-centric way of handling this is also fairly straightforward:
Note that this does not take into account order status or invoiced payment.