cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Query To Pull Customer Emails, Coupon Code, & Products Ordered?

SQL Query To Pull Customer Emails, Coupon Code, & Products Ordered?

I was able to find a query which is supposed to pull the email, name, rule #, coupon #, and coupon code. 

However, I noticed that, based on the coupon usage report, this query is missing 90% of the orders attributed to the code from the last two week period.

 

Is there a code for Magento 1.9 which can pull email, customer name, coupon code, and what they ordered in the same report? Or at least everything besides the product?

 

Thanks in advance!