Ginno Posted January 14, 2014 Share Posted January 14, 2014 HelloI would like, if possible, to add a new field to the back office client filter, search by phone number. TKS Link to comment Share on other sites More sharing options...
NemoPS Posted January 15, 2014 Share Posted January 15, 2014 You must edit adminCustomersController (controllers/admin) You can then apply this tutorial, but choosing the fields you need http://nemops.com/filter-by-country-prestashop-order-list/ Link to comment Share on other sites More sharing options...
vekia Posted January 15, 2014 Share Posted January 15, 2014 it will not be as easy as it seems. it's because phone numbers are stored in "addresS" object what does it mean? it's necessary to modify the sql query but... what if customer has got several different addresses? different for invoice, different for delivery, several other addresses etc. ? which one phone number to display then? Link to comment Share on other sites More sharing options...
NemoPS Posted January 15, 2014 Share Posted January 15, 2014 Yes, he has to modify the query indeed. In case of multiple addresses he can simply pick the first match. After all, if this is his requirement Link to comment Share on other sites More sharing options...
Ginno Posted January 17, 2014 Author Share Posted January 17, 2014 (edited) I want to use this filter to view customer history.The site will be used only one address and in one country do not think I can handle it following the tutorial. A little help? Edited January 18, 2014 by Ginno (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted January 19, 2014 Share Posted January 19, 2014 your customer has got possibility to use several different addresses. during order they can use different one, and this will causing problem in your filtering method. this is what we are trying to say Link to comment Share on other sites More sharing options...
Ginno Posted January 19, 2014 Author Share Posted January 19, 2014 Phone numbers are stored in the table ps_adress - phone & phone_mobile. Even if you use different addresses. Addresses are not important. I am interested to find quickly the client Link to comment Share on other sites More sharing options...
vekia Posted January 20, 2014 Share Posted January 20, 2014 address in this case means also phone and mobile, they can use different numbers. so which one you want to display? phone from delivery, or phone from invoice? Link to comment Share on other sites More sharing options...
Recommended Posts