[SOLVED] How to search customers by phone mobile

[b.tsvetkov]

Hallo

I'am using PrestaShop 1.6.

Is it possible to search customers in customers page by their phone numbers. I tryed this way https://www.prestashop.com/forums/topic/325175-how-do-i-search-customer-by-their-phone-number-in-the-back-office/ , but it doesn't work.

Please, help!

Thank you!

Edited June 12, 2016 by b.tsvetkov (see edit history)

[rocky]

Here's a simple override that adds "Phone" and "Mobile" columns to the Customers > Addresses tab in the Back Office so you can filter by phone or mobile. Create override/controllers/admin/AdminAddressesController.php with the following:

<?phpclass AdminAddressesController extends AdminAddressesControllerCore{    public function __construct()    {        parent::__construct();                $this->fields_list['phone'] = array('title' => $this->l('Phone'), 'filter_key' => 'a!phone');           $this->fields_list['phone_mobile'] = array('title' => $this->l('Mobile'), 'filter_key' => 'a!phone_mobile');       [spam-filter]

Remember to go to the Advanced Parameters > Performance tab and click the "Clear cache" button after creating the file.

[b.tsvetkov]

Here's a simple override that adds "Phone" and "Mobile" columns to the Customers > Addresses tab in the Back Office so you can filter by phone or mobile. Create override/controllers/admin/AdminAddressesController.php with the following:

<?phpclass AdminAddressesController extends AdminAddressesControllerCore{    public function __construct()    {        parent::__construct();                $this->fields_list['phone'] = array('title' => $this->l('Phone'), 'filter_key' => 'a!phone');           $this->fields_list['phone_mobile'] = array('title' => $this->l('Mobile'), 'filter_key' => 'a!phone_mobile');       [spam-filter]

Remember to go to the Advanced Parameters > Performance tab and click the "Clear cache" button after creating the file.

Great, it's working!

Thank you so much!

[rocky]

Glad to help. Please edit your first post and add [sOLVED] to the title.

[b.tsvetkov]

It doesn't work on PrestaShop 1.6.1.7. After update the fields with phone number disappeared. Any solution for this problem?

Thank You!

[b.tsvetkov]

It doesn't work on PrestaShop 1.6.1.7. After update the fields with phone number disappeared. Any solution for this problem?

Thank You!

[rocky]

It's working fine on my PrestaShop v1.6.1.7 test site:

 

[MaakMijnWitgoed]

I'm new with using this override but I can't get it working in PrestaShop 1.6.1.12. Is there something changed in the past few versions?

[George Bazz]

Delete the /cache/class_index.php file.

 

As it is stated in /override/readme_override.txt:

 

Hello,

 

Please read the documentation before trying to override something here.

http://doc.prestashop.com/display/PS16/Overriding+default+behaviors

 

Frequently Asked Questions

 

Q: I added an override file but it seems to be ignored by PrestaShop

A: You need to trigger the regeneration of the /cache/class_index.php file. This is done simply by deleting the file. It is the same when manually removing an override: in order to reinstate the default behavior, you must delete the /cache/class_index.php file.

 

 

Worked, fine for me in 1.6.1.12

[MaakMijnWitgoed]

Followed all steps mentioned in this thread but unfortunately no luck 

[stweet]

any one know how to do this on 1.7 ?

[hakeryk2]

Does anyone has this code? Original one from post is with [spam filter] because it was too long probably.

[dandumit]

I guess that same trick can be added to search by tracking number...

 

Daniel

[istox]

On 6/11/2016 at 2:53 PM, rocky said:

Here's a simple override that adds "Phone" and "Mobile" columns to the Customers > Addresses tab in the Back Office so you can filter by phone or mobile. Create override/controllers/admin/AdminAddressesController.php with the following:

<?phpclass AdminAddressesController extends AdminAddressesControllerCore{    public function __construct()    {        parent::__construct();                $this->fields_list['phone'] = array('title' => $this->l('Phone'), 'filter_key' => 'a!phone');           $this->fields_list['phone_mobile'] = array('title' => $this->l('Mobile'), 'filter_key' => 'a!phone_mobile');       [spam-filter]

Remember to go to the Advanced Parameters > Performance tab and click the "Clear cache" button after creating the file.

Not working. [spam filter] locked the code

[zod]

The code missed just 2 curly brackets, the correct code is:

<?php
class AdminAddressesController extends AdminAddressesControllerCore{
  public function __construct() {
    parent::__construct();
    $this->fields_list['phone'] = array('title' => $this->l('Phone'), 'filter_key' => 'a!phone');
    $this->fields_list['phone_mobile'] = array('title' => $this->l('Mobile'), 'filter_key' => 'a!phone_mobile');
  }
}

 

[Coloranti]

On 3/31/2018 at 12:13 PM, zod said:

The code missed just 2 curly brackets, the correct code is:

<?php
class AdminAddressesController extends AdminAddressesControllerCore{
  public function __construct() {
    parent::__construct();
    $this->fields_list['phone'] = array('title' => $this->l('Phone'), 'filter_key' => 'a!phone');
    $this->fields_list['phone_mobile'] = array('title' => $this->l('Mobile'), 'filter_key' => 'a!phone_mobile');
  }
}

 

This code works in PS 1.6.16!

 

Thanks a lot @zod

Edited June 27, 2018 by Coloranti (see edit history)

[MathiasReker]

you can search customers by phone from this module: https://addons.prestashop.com/en/order-management/39583-search-by-tracking-number-phone-etc.html

[Evi]

On 3/31/2018 at 12:13 PM, zod said:

The code missed just 2 curly brackets, the correct code is:

<?php
class AdminAddressesController extends AdminAddressesControllerCore{
  public function __construct() {
    parent::__construct();
    $this->fields_list['phone'] = array('title' => $this->l('Phone'), 'filter_key' => 'a!phone');
    $this->fields_list['phone_mobile'] = array('title' => $this->l('Mobile'), 'filter_key' => 'a!phone_mobile');
  }
}

 

It works for 1.7.2.2 as well. Thank you!

 

[siomosp]

Works fine at 1.7.5.2

Added search for VAT and customer comments

<?php

class AdminAddressesController extends AdminAddressesControllerCore
{
    public function __construct()
    {
        parent::__construct();
        
        $this->fields_list['phone'] = array('title' => $this->l('phonr'), 'filter_key' => 'a!phone');   
        $this->fields_list['phone_mobile'] = array('title' => $this->l('mobile'), 'filter_key' => 'a!phone_mobile'); 
        $this->fields_list['other'] = array('title' => $this->l('comments'), 'filter_key' => 'a!other');
      $this->fields_list['vat_number'] = array('title' => $this->l('VAT'), 'filter_key' => 'a!vat_number');    
    }
}

[depurweb]

can i add this fuction on AdminCustomers?

[MANB Design]

in AdminOrdersController????? THX

[Prestag0od]

On 11/26/2019 at 1:33 PM, MANB Design said:

in AdminOrdersController????? THX

 

On 10/31/2019 at 6:48 PM, depurweb said:

can i add this fuction on AdminCustomers?

I also searching for solution about orders and customers pages... Did you find anything?

[DoGGoD]

On 6/11/2016 at 2:53 PM, rocky said:

Here's a simple override that adds "Phone" and "Mobile" columns to the Customers > Addresses tab in the Back Office so you can filter by phone or mobile. Create override/controllers/admin/AdminAddressesController.php with the following:

<?phpclass AdminAddressesController extends AdminAddressesControllerCore{    public function __construct()    {        parent::__construct();                $this->fields_list['phone'] = array('title' => $this->l('Phone'), 'filter_key' => 'a!phone');           $this->fields_list['phone_mobile'] = array('title' => $this->l('Mobile'), 'filter_key' => 'a!phone_mobile');       [spam-filter]

Remember to go to the Advanced Parameters > Performance tab and click the "Clear cache" button after creating the file.

This works with Prestashop 1.7.6.7 as well. Awsome job!

[thehurricane]

is it possible to show phone number on customer list not on addresses list?