Search orders by invoice, shipment, zip code or phone number

[EdEichman]

We've moved from a highly customized ecommerce platform to PrestaShop. One of the features that greatly helped our support was the ability to search for orders by a number of different criteria... orderID, shipmentID, tracking number, invoice number, email, phone number, etc. When someone called about an order, you could go to the order area, and search on any combination of the above listed parts.

 

This was needed since users were frequently totally unprepared before calling. They might not have their invoice, or they may have it but can only find e.g. the invoice number, etc.  Those of you who have done customer support know the types of problems I'm talking about ;->

 

Is there any simple way to do this in PresaShop without overriding?

 

Thanks,

Ed

Edited November 13, 2015 by EdEichman (see edit history)

[kNife77]

Hi,

 

Had the same problem, didn't found an answer on the net and I modified the core.

 

So go to the controllers/admin/AdminOrdersController.php and around line 109 you should find 

 

 

and just add this line (note, replace 'phone_mobile' with 'phone' if needed)

 

 

And here is the result 

 

 

Now the Orders are searchable by phone number.

 

Hope it helps

[b.tsvetkov]

I tryed this but it doesn't work. Error - Your website is currently unable to process this query. I am using PrestaShop 1.6.1.5

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

[EdEichman]

 

Hi,

 

Had the same problem, didn't found an answer on the net and I modified the core.

 

So go to the controllers/admin/AdminOrdersController.php and around line 109 you should find 

 

 

Thanks kNife77, that did work, but it changed the core code, which I hate to do (it makes upgrading to new versions a pain in the butt). However, it can be easily done doing an override... just calling the base class constructor, and adding your own fields afterwards. Works great, and is outline in detail in an article I wrote on the subject.

 

Thanks!

Ed

Edited October 5, 2016 by EdEichman (see edit history)