Customer Listing

[Jamiie7]

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,

 

Jamie

[Jamiie7]

If someone does know how to solve this issue.

 

Could you please post here A.S.A.P.

 

Thank you!

[Gauravs]

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

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

 

 

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

[Jamiie7]

Thank you very much!

 

I will give it a go shortly.