Author Topic: Search product in order list  (Read 1534 times)

thefbi

  • Jr. Member
  • **
  • Posts: 255
Search product in order list
« 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

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3945
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Search product in order list
« Reply #1 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
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

thefbi

  • Jr. Member
  • **
  • Posts: 255
Re: Search product in order list
« Reply #2 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.

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3517
  • VirtueMart Version: 4.0.12.10777
Re: Search product in order list
« Reply #3 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

Reply #13

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

Joomla 3.10.11
php 8.0