Reporting Items Ordered by Customer

[Tig]

I've been forum huting for a while and I'm wondering if there is a mod that will allow a report to be printed that shows items ordered and sorts them by customer.

We (myself and the company that I'm building the store for) want to track what customers are ordering and with what frequency.

Any help or gesture in the right direction will be much appreciated.

Note: I've already tried Super Orders and Sales Report. Both programs are awesome but I can't seem to make either of them work in the way I want.

[wolfsz]

Hi there
Why not write a SQL report to get exactly what you want?
You can do this using phpmyadmin which is most likely available via your control panel

[Tig]

There is that.

Unfortunately I'm not very database savvy (or programming savvy; I just make it look good) so I'm not sure how to go and generate the report.

Do you know of any resources I could take a gander at?

Thank you.

[wolfsz]

Hi there
SQL is a relative straight forward reporting language that is very, very helpful when dealing with databases in any shape or form. If you do a search in the forum you will see that I have made several posts with SQL code.
If you can't find anything that suits outline what you need and I can post some basic code to get you going. However there is a learning curve as with anything new. So you've got two choices:
1. learn SQL - mysql.com or a google search will get you started or better a good book
2. or get someone to write the query for you
You can PM me if you want me to write it for you and I will provide details of what is required and what it will cost you.