Master the search operators to filter thousands of products with precision.
Basic Search
Simply type in the search bar to filter products. Search matches across all searchable columns.
Example:
honda → Shows all products containing “honda”
Search Operators
AND Operator (Space)
All terms must match (across any columns).
honda civic → Products containing BOTH “honda” AND “civic”
OR Operator (Comma)
Any term can match.
honda,toyota → Products containing “honda” OR “toyota”
SEP Operator (Colon) — Exact Match
Match exact values, starts with, or ends with.
:honda → Values starting with “honda”civic: → Values ending with “civic”:2024: → Values exactly equal to “2024”
ESC Operator (Backslash) — Escape Characters
Use special characters literally in search.
\: → Searches for literal colon character
Search operators filtering product results
Combining Operators
You can combine operators for complex searches:
honda civic,accord 2024Means: (honda AND civic) OR (accord AND 2024)
Using the List Panel
The list panel below the search table shows unique values per column. Click values to filter:
- Click a value → Adds to filter (blue background)
- Click again → Removes from filter
- Multiple values in same column = OR
- Values across different columns = AND
Next: Learn how to build invoices with one click.