Forums / Managing Customers and Orders / Reporting Number of orders per customer in a list?

Reporting Number of orders per customer in a list?

Locked

Views: 1,643

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
9 Jul 2008, 12:43 PM
#1
andy_gs avatar

andy_gs

Zen Follower

Join Date:
Jun 2008
Posts:
187
Plugin Contributions:
0

Reporting Number of orders per customer in a list?

Hey all,

i want to display a list of all my customers with the number of orders they have purchased. the reports only gives me whos spent the most money.

i tried installing Super orders and this also didnt help me with my problem.

i've even tried to look for the field within the database but i can't even find that.

its definatly there a value because it displays when you click on every individual customer.

so any ideas people?

thanks

oh dear gurrrddddd.

15 Jul 2008, 2:32 AM
#2
jeking avatar

jeking

Totally Zenned

Join Date:
Oct 2005
Location:
Chicago, IL USA
Posts:
1,592
Plugin Contributions:
0

Re: Reporting Number of orders per customer in a list?

Bump. I'm looking for the exact same report.

Jim
Wheaton Website Services

15 Jul 2008, 8:18 AM
#3
andy_gs avatar

andy_gs

Zen Follower

Join Date:
Jun 2008
Posts:
187
Plugin Contributions:
0

Re: Reporting Number of orders per customer in a list?

hopefully somone will get back to us eventually but we have to wait and see :(

oh dear gurrrddddd.

18 Jan 2009, 2:49 AM
#4
gharls avatar

gharls

New Zenner

Join Date:
Dec 2008
Posts:
25
Plugin Contributions:
0

Re: Reporting Number of orders per customer in a list?

Andy_GS:

The number of customer orders that you see on your panel probably results from a SQL COUNT on the orders_id column in your ZC database during panel processing. I'm not sure if there is a de-normalized (static) table column that holds the number of orders for a given customer.

I know, my blather gets you no closer to your spec, but ...

GHarls@}-',--
**DataGrange Design Studio**
Web Design and Consulting