Zen Follower
- Join Date:
- Aug 2006
- Posts:
- 233
- Plugin Contributions:
- 0
Need Help - getting customer list for purchase history of a single product
Okay, I need to generate a list of all of the customers who purchased a specific product. I need the list in a format that I can export (even if to just a text file), and I need to have address information in it as well.
In short, I need: order number, customer name, customer email, customer (physical) address
Unfortunately, Zen Cart does not have the capability to do this.
Now, I know that I could run a query on the DB using SQL (as I have access to both php MyAdmin and another DB tool that I can use to connect to the DB (MySQL-Front). However, I do not have the expertise to create such a SQL query.
Can anybody help??
(yes, I know that I could do a "products purchased report" and then manually cut-n-paste the other information, but I am hoping to avoid that if at all possible.
Thanks in advance!!
