Customer Search in Admin?

[PudzPud]

Using the search button under Customers in admin is it possible to search by full name or even better customer id number?

We have a lot of customer names in this section and if you need to find someone with a common surname e.g. Brown the search may give out 100+ matching entries and then you manually need to check through them all to find the right one, whereas if you could search by full name e.g. Mary Brown it would bring up far fewer results, or by the database unique customer ID number then it would bring up only the one matching record.

Thought I would check in case there is a way to do this that I just don't know about as it seems strange to only search for part of a name.

Any ideas or tips on how to do this?

[gigi3]

*bump*
I need to be able to search customers by ID. Anyone?

TIA.

[swguy]

What about search by phone number, which is already available.

[gigi3]

Thanks, swguy, but for me it must be by ID....

[swguy]

OK. What version of Zen Cart do you have?

[gigi3]

1.5.1
Thanks!

[swguy]

Change line admin/customers.php line 1045-1049 from:

    if (isset($_GET['search']) && zen_not_null($_GET['search'])) {
      $keywords = zen_db_input(zen_db_prepare_input($_GET['search']));
      $search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%' or c.customers_telephone rlike ':keywords:' or a.entry_company rlike ':keywords:' or a.entry_street_address rlike ':keywords:' or a.entry_city rlike ':keywords:' or a.entry_postcode rlike ':keywords:'";
      $search = $db->bindVars($search, ':keywords:', $keywords, 'regexp');
    }

to

    if (isset($_GET['search']) && zen_not_null($_GET['search'])) {
      $keywords = zen_db_input(zen_db_prepare_input($_GET['search']));
      // CID search
      if ((strlen($keywords) < 6) && is_numeric($keywords)) {
         $cid = (int)$keywords;
         $search = "where c.customers_id = " . $cid;
      } else {
         // end CID search
         $search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%' or c.customers_telephone rlike ':keywords:' or a.entry_company rlike ':keywords:' or a.entry_street_address rlike ':keywords:' or a.entry_city rlike ':keywords:' or a.entry_postcode rlike ':keywords:'";
         $search = $db->bindVars($search, ':keywords:', $keywords, 'regexp');
      }
    }

[gigi3]

It worked! Thank you SO MUCH! Do you have a donate link I can use? Would love to support your work. :)

[swguy]

LOL that's very kind of you. Please make a contribution to the Zen Cart project.

https://www.zen-cart.com/content.php?6-donate