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
Re: Reporting Number of orders per customer in a list?
Bump. I'm looking for the exact same report.
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 :(
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 ...