DESKTOP EDITION CLOUD EDITION SERVER EDITION GUIDES FORUM

Searching inventory items using multiple words


#1

Hi,

Is there a way to search inventory items using multiple words without them being an exact phrase?

Thanks
Greg


#2

Or even better, is there a way to apply filters to the results?


#3

Currently not. However you can use the Export button


and copy the data to a spreadsheet program like Excel, which can do both the things you ask for.


#4

Yes, I often export to excel and use filters etc.
It would just be good to maybe have a dropdown option box when searching so you could choose something like

  • any word
  • all words
  • phrase

In your screenshot if you just typed large apple, it would be good if it only listed the items with both those words.

My inventory currently has 2100 items and is growing daily, searching starts to get hard sometimes :frowning:


#5

I like that idea, let’s see if a mod will move it to the ideas category, @Tut?
If the developer does decide to implement it, don’t expect to see it immediately.


#6

I concur. I very often might need to filter by say @laptops category and then filter by core i5 and then filter by manufacturer. So filter within filter would be really good


#7

Added to the latest version (18.5.71). Works on every screen where Search function is available.


#8

It does not seem to function for me :frowning:


#9

Are you sure you updated?


#10

See below

The inventory

image

and the result of the search


#11

You missed the point of the change. The multiple words must all be present within the same record. In effect, the search is an AND, not OR.


#12

ok, now is clear, although an .or. would be also useful
Thanks


#13

Thank you, thank you, thank you…
I absolutely LOVE it !!!

This now makes my life so much easier :slight_smile:


#14

Hello!

  1. Can we make this search bar more responsive, like we type a few letters and the list starts getting sorted with the letters in the search rather than typing the whole thing and then hit the search. This is because this system becomes difficult in a few sections like customers, inventory and many other.

  2. Can we add a button “Create Customer” & “Create Buyer” in “Sales Quotes and Sales Invoice” and “Purchase Invoice” respectively. I think that will save a lot of time.

Thanks!


#15

The search function will work on partial words. What you describe isn’t a search, but auto fill.