Zen Cart Logo
Forums / Managing Customers and Orders / Reporting Items Ordered by Customer

Reporting Items Ordered by Customer

Locked

Views: 1,405

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
25 Jun 2008, 4:41 PM
#1
tig avatar

tig

Zen Follower

Join Date:
Apr 2006
Location:
Lansing, MI
Posts:
123
Plugin Contributions:
0

Reporting Items Ordered by Customer

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.

26 Jun 2008, 4:30 AM
#2
wolfsz avatar

wolfsz

Zen Follower

Join Date:
Mar 2006
Location:
Australia
Posts:
286
Plugin Contributions:
3

Re: Reporting Items Ordered by Customer

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

26 Jun 2008, 11:00 AM
#3
tig avatar

tig

Zen Follower

Join Date:
Apr 2006
Location:
Lansing, MI
Posts:
123
Plugin Contributions:
0

Re: Reporting Items Ordered by Customer

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.

27 Jun 2008, 12:11 AM
#4
wolfsz avatar

wolfsz

Zen Follower

Join Date:
Mar 2006
Location:
Australia
Posts:
286
Plugin Contributions:
3

Re: Reporting Items Ordered by Customer

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.