Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008
    Posts
    187
    Plugin Contributions
    0

    help question 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

  2. #2
    Join Date
    Oct 2005
    Location
    Chicago, IL USA
    Posts
    1,386
    Plugin Contributions
    27

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

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

  3. #3
    Join Date
    Jun 2008
    Posts
    187
    Plugin Contributions
    0

    Default 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

  4. #4

    Default 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

 

 

Similar Threads

  1. v151 Customer Telephone Number on Orders
    By gold in forum General Questions
    Replies: 6
    Last Post: 4 Jun 2015, 03:39 PM
  2. v151 Adding older orders and customer list to new database
    By In2Deep in forum General Questions
    Replies: 11
    Last Post: 10 Mar 2014, 10:58 PM
  3. Searching number of orders per item
    By beinart in forum General Questions
    Replies: 4
    Last Post: 22 Apr 2010, 01:01 PM
  4. Number of orders made by each customer?
    By misterhh in forum General Questions
    Replies: 1
    Last Post: 2 Sep 2009, 03:14 PM
  5. Replies: 3
    Last Post: 17 Oct 2006, 12:04 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR