VirtueMart Forum

VirtueMart 2 + 3 => Administration & Configuration => Topic started by: thefbi on March 18, 2021, 09:02:31 am

Title: Search product in order list
Post by: thefbi on March 18, 2021, 09:02:31 am
Hello,

is there a way to search products directly in the order list. Actually, if i will search with product name in the search field in the order list, it dos not work.

Regards.

VM 3.8.8 10472
Joomla 3.9.25
Title: Re: Search product in order list
Post by: Jörgen on March 18, 2021, 10:16:07 am
There is a thread with a user that searchs on SKU in order list. Try to search for SKU in recent posts, the last few days.

You can see all the orders that are connected to a product under product details in backend, if that maybe would help.

Jörgen @ Kreativ Fotografi
Title: Re: Search product in order list
Post by: thefbi on March 18, 2021, 10:50:49 am
Hello,

thank you, but all my product have not sku. I know i can search in the product, but this is not that i will.

Will be great if we can just search any word in the order list to quick find order.

Regards.
Title: Re: Search product in order list
Post by: AH on March 18, 2021, 11:06:21 am
Quote
Actually, if i will search with product name in the search field in the order list, it does not work.

If every item does not have an SKU - you should consider adding one

I have posted an option in this thread to allow for search by SKU

http://forum.virtuemart.net/index.php?topic=146492.msg521418#msg521418 (http://forum.virtuemart.net/index.php?topic=146492.msg521418#msg521418)

Reply #13

You can add "order_item_name" if you really want to
$searchFields[] = 'oi.order_item_name';