Search for customer number / phone number from admin?

[dubz99]

Hello all!

 

I was hoping I could search more options in admin, at the minimum I'd like to be able to search by customer number.

 

But it would also be great to search by phone number!

 

Thanks

dubz

[andes1]

Hello

 

sorry for a late reply but until no0w i read this post.

 

the solution is easy:

in admin/customers.php

find

	$search = '';
if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) {
  $keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search']));
  $search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%'";
}

 

and replace for

$search = '';
if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) {
  $keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search']));
  $search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_telephone like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%'";
}

 

that's it

 

remember backup first.