Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Customer Listing


Recommended Posts

Hi everyone,


I am here to enquire for support due to having some issues with my Customer Listing on my Administration Panel.


Now: The listing is now in Alphabetical Order from the persons name.


Aim: I would like the listing to be in Alphabetical Order from the business name.


Thanking you,



Link to comment
Share on other sites

Look for the query below in admin/customers.php

$customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by c.customers_lastname, c.customers_firstname";


Change Order By

order by c.customers_lastname, c.customers_firstname"
order by a.entry_company"



NOTE: Take a backup of your file before you make any changes!!!

Best Regards,

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...