Search in orders by product name

[dellos]

I'm using the PS 1.4.017 and looking for some coding add on / solution in admin pannel. When I'm going to sold product I see the newest orders for my shop I can add to filter ID, Klient name, etc. But I need to add search orders by product name.

 

Is there a way to add it to admin panel ?? and how ??

Edited October 12, 2012 by dellos (see edit history)

[math_php]

Hi Dellos,

 

This will need modification of prestashop admin files that would not be easy and lost for new version.

 

Perhaps a display of alphabetically sorted products for all new orders would help you in managing your orders ?

This would be an easier solution if your request is for managing order to your suppliers.

 

You have got all datas, tell why and how you need them, solutions will be found.

 

Regards

[dellos]

That what I thought that this will be very hard to obtain. As my boss see he want to write in box a name of product and the orders selection will only show orders with the product wrote in. The order can have other products also but must have the product search for... As I see it also would be quite workhors for searching this data.

 

We have lot of orders right now (over 9000 made) and the searching would be time taking... ok I hoped there is some addon plugin made allready for it.

[musicmaster]

In principle this is very simple. You would get a MySQL query like:

 

SELECT UNIQUE id_order FROM ps_order_detail WHERE product_name LIKE '%mygadget%'

 

The rest is dressing up.

[math_php]

In principle this is very simple. You would get a MySQL query like:

 

SELECT UNIQUE id_order FROM ps_order_detail WHERE product_name LIKE '%mygadget%'

 

The rest is dressing up.

Yes in principle it is very simple, in application it is somewhat different.

 

Even with the query (in wich table are prefixed by ps_, which may not be the case) you would get senseless id_order integer. And "SELECT UNIQUE" is not Mysql syntax (use distinct)

 

(The rest is dressing up) : this would need some effort from me to make it running, but I am not a master