How can I view orders by product name?

[Walrus]

Does anyone know of a query I can add to the address bar and have Prestashop show all orders containing a word in the product name?

 

For example, login (essential), open the Orders page in back office and enter something like following in the address bar:

 

https //www.myDomain.com/admin/index.php?controller=AdminOrders=QUERY&productName

 

 

TIA,

 

Shangara.

Edited October 28, 2015 by Walrus (see edit history)

[tuk66]

What about to create the query in Advanced Parameters > SQL Manager?

[Walrus]

How would that work, and what query? I'm not versed in SQL, or PHP.

 

In Orders, you can search by ID but ID is assigned to order number while in Products it's assigned to products. All very confusing.

 

Searching by product ID in Orders would work just as well as searching by product name but no such option is available that I can see.

[tuk66]

That's because products are stored in order details, not orders. You need a complex SQL query or a module.

[Walrus]

That may make sense to coders but to a user like me, who is fairly computer literate, it makes no sense whatsoever.

 

So is there a query containing a product name, because I know product names are stored in orders, that can used to find orders?

[tuk66]

You are almost right, but if you use two or more languages, that approach have to be slightly different. You need to search in products, not order details.

[Walrus]

Maybe I didn't explain well what I'm after. I want to find all orders for 'product foo.' In Products, I can only find, erm, products (unless I am missing the very obvious).

 

I know this can be done because our old shopping cart let me login as Admin, then paste query in the address bar and show me all orders that contained the word in the query and matched it with the orders.

 

For example, enter http: //www.mySite/Query=Photoshop in the address bar, and press Return. I could then see all orders that had the word Photoshop in the product title in the Orders page.