Easy Way To Find out how much a customer has spent?

[brokenjago]

I was just wondering if there's a place that keeps money totals for each customer as to what they've spent so far on the site.

 

I was about to go all out and create a new table and add all the info with some fancy PHP so it can be displayed to me, but I figured osCommerce might actually have this info stored somewhere...

 

does it?

 

For clarification, I want To see how much a customer has spent in Dollars (or whatever currency) from the time they've joined to the time I query the DB

[brokenjago]

PS: This forum's search function sucks the big one.

[Guest]

In admin side of store

 

admin->reports->customers order_total

 

Pierre

[brokenjago]

Wow, thanks for the speedy reply!

 

I noticed it was called "Best Customer Orders-Total." Does that mean it lists customers only to a certain point? I want ALL customers listed.

 

Also, are they sorted in any particular order? I must admit that I don't have any customers yet :o

 

Also, in what status to orders have to be to be counted towards this total? "Delivered"? Placed?

[crash3903]

PS: This forum's search function sucks the big one.

 

 

your right!

 

see my sig for a better search function

[brokenjago]

Anyone?