Thread: Customer Orders

Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2005
    Location
    England
    Posts
    90
    Plugin Contributions
    0

    Default Customer Orders

    Hi

    If a registered customer logs into our site, they can only see that last 3 orders they have made in their account settings.

    I can't find the setting to change this.

    Can you help?

  2. #2
    Join Date
    Mar 2010
    Location
    Nottingham UK
    Posts
    87
    Plugin Contributions
    1

    Default Re: Customer Orders

    I think if I remember correctly, the option to do this is under:

    Admin > Configuration > Maximum Values > Customer Order History List Per Page

  3. #3
    Join Date
    Mar 2005
    Location
    England
    Posts
    90
    Plugin Contributions
    0

    Default Re: Customer Orders

    hmmm, mine is set to 20 yet only 3 show even though there are 7 orders...

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Customer Orders

    That setting is for the Show All Orders ...

    If you look in the file:
    /includes/modules/pages/account/header_php.php

    you will see the limit in the SELECT statement is set to 3:
    Code:
    $orders_query = "SELECT o.orders_id, o.date_purchased, o.delivery_name,
                            o.delivery_country, o.billing_name, o.billing_country,
                            ot.text as order_total, s.orders_status_name
                     FROM   " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . "  ot, " . TABLE_ORDERS_STATUS . " s
                     WHERE  o.customers_id = :customersID
                     AND    o.orders_id = ot.orders_id
                     AND    ot.class = 'ot_total'
                     AND    o.orders_status = s.orders_status_id
                     AND   s.language_id = :languagesID
                     ORDER BY orders_id DESC LIMIT 3";
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

 

 

Similar Threads

  1. v151 Free orders not showing up in the admin/customer/orders
    By jodean in forum Managing Customers and Orders
    Replies: 10
    Last Post: 12 Jan 2016, 05:23 PM
  2. v151 Customer orders in admin area: Why do orders reformat? Text is small, Margins are off
    By gachogavacho in forum Managing Customers and Orders
    Replies: 4
    Last Post: 22 Aug 2014, 07:08 AM
  3. v139h change Customer Orders Total in Database without deleting orders?
    By AvaAdorn in forum Managing Customers and Orders
    Replies: 6
    Last Post: 30 Jun 2012, 05:00 AM
  4. Edit Orders + Super Orders + Create Customer +Create Orders
    By laurenjj in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 27 May 2011, 07:10 PM
  5. Customer getting orders from another customer
    By Diego Vieira in forum General Questions
    Replies: 0
    Last Post: 24 Jun 2009, 11:44 PM

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