Does the database keep track of the specific coupon code used in a transaction? For example, can I write a script to query the database for all transactions that used coupon code "ERET11"? Or display the particular coupon code used for an individual transaction? I see the coupon count is display, but I want to know which transaction used that coupon in case there is a stolen coupon code or something.
you can do this, coupon_id is written into field "coupon_id" of amember_payments table. Unfortunately, this is not implemented in aMember CP yet.