Customer List - Admin

[dannylee]

Hi Guys,

 

As standard the customers are displayed in alphabetical order in the admin site.

 

Is there a way to change this so it sorts them by date "account created" from showing the newest first to the latest.

 

I.e. the first page will display the new accounts then the further through the pages you go the older they get.

 

Thanks for any help...am sure its an easy one I just can't work it out

 

Thanks

[cliq]

Hi Guys,

 

As standard the customers are displayed in alphabetical order in the admin site.

 

Is there a way to change this so it sorts them by date "account created" from showing the newest first to the latest.

 

I.e. the first page will display the new accounts then the further through the pages you go the older they get.

 

Thanks for any help...am sure its an easy one I just can't work it out

 

Thanks

 

 

Hello Danny.

You tried modify admin/customers.php ?

[dannylee]

Hello Danny.

You tried modify admin/customers.php ?

 

Hi Diego,

 

Yeh have had a look at customers.php but not sure which section to change and how to change it.....am assuming its some "sort" function within but not got a clue.

 

Any ideas?

[nst888]

Hi Diego,

 

Yeh have had a look at customers.php but not sure which section to change and how to change it.....am assuming its some "sort" function within but not got a clue.

 

Any ideas?

 

Hi I did this quite recently. Unfortuantely I'm at work at the moment and don't have access to my code. I believe I amended the select criteria for the list by joining on the customer table which held the created date, then did a sort on that. If you wish to email me the customers.php file to 'nicki' at my domain in my signature then I will tell you exactly the line number you have to change.

[dannylee]

Hi I did this quite recently. Unfortuantely I'm at work at the moment and don't have access to my code. I believe I amended the select criteria for the list by joining on the customer table which held the created date, then did a sort on that. If you wish to email me the customers.php file to 'nicki' at my domain in my signature then I will tell you exactly the line number you have to change.

 

Hi Nicki,

 

Have just emailed you the customers.php file.

 

Thanks for your help

 

Danny

[nst888]

Hi Nicki,

 

Have just emailed you the customers.php file.

 

Thanks for your help

 

Danny

 

Just replace line 820:

 

$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";

 

with:

 

$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 left join " . TABLE_CUSTOMERS_INFO . " ci on ci.customers_info_id = c.customers_id " . $search . " order by ci.customers_info_date_account_created desc";

 

Hope this is correct, as I said I'm at work at the mo so can't be doubly sure. Let me know if you have any problems

[dannylee]

Absolute start! Exactly the solution I needed.

 

Thankyou very much for that

 

Danny :thumbsup:

[nst888]

No probs glad I could help.