This page provides information on the syntax for searching text fields.
The same search query syntax is used across Shopify as an interface to search functionality. This includes the storefront, admin, mobile apps, customer group queries, Admin API, and Storefront API. For the APIs, the specific resources that can be queried are defined in the reference documentation.
Search query grammar overview
A string query is a text search made up of terms, connectives, modifiers, and comparators. The search grammar rules defined here can be built into larger structures as defined by the search query syntax.
The search grammar is expressed similarly to EBNF and uses some baseline terminal symbols as follows:
||Any sequence of space, tab, or newline characters.|
||Any sequence of non-whitespace, non-special characters. See Special characters for more information.|
||Any name, or any quoted string (single or double quotes are both permitted).|
The root of the grammar is a Query.
A Query is one or more Terms separated by whitespace and optionally by single Connectives. A Query may have optional leading and trailing whitespace.
When a Connective is not specified between two Terms,
AND is implied.
query=state:enabled OR state:disabled
A term consists of an optional modifier, followed either by a sub-Query (enclosed in parentheses) or a value with an optional name-and-Comparator.
query=-first_name:Bob AND orders_count:>3 orders_count:<=4
A modifier can be "-" (in which case it must not be followed by whitespace) or it may be "NOT" (in which case it must be followed by whitespace). Both mean the same thing.
The current list of comparators is:
* equality depends on how a field is indexed. For numeric fields
: represents equality. For tokenized fields, equality exists if the term is found anywhere in the field. For non-tokenized fields, the search query string must match the searched field exactly.
Search query syntax
Shopify search query syntax is based on the defined grammar and enables the following search behavior.
Term searches will make a case-insensitive search appearing in any field in a document.
This will make a case insensitive search for both "bob" AND "norman".
Field searches apply to terms in specific fields.
This will search for the "Bob" in the "first_name" field AND "27" in the "age" field.
The value must immediately follow the field with no whitespace:
first_name: Bob will actually search for the terms "first_name" and "Bob".
A range search specifies a range of values to search against.
This will match documents where the
orders_count field is greater than 16 and less than or equal to 30. The supported operators are
Equality is done as
orders_count:=16; the latter will actually search for the term "
=16" in the
This query excludes documents that include the NOT operator.
Both of these queries will not return documents including the term "bob".
The "NOT" operator must be capitalized to execute a Not Query, and only applies to the following space separated term or query. The minus sign must precede the field, value, or subquery e.g.
-field:value -value -(subquery).
Boolean operators allow terms to be combined through logic operators.
query=bob OR norman AND Shopify
This will search for documents that MUST have the term "Shopify" and SHOULD have at least one of the terms "bob" or "norman".
query=bob OR norman Shopify
This query is equivalent to the query above, since OR has a higher operator precedence than AND. Furthermore, the default boolean operator between terms or queries is AND, so no explicit AND operator is needed.
Shopify supports using parentheses to group clauses to form sub queries.
query=state:disabled AND ("sale shopper" OR VIP)
This searches for disabled customers with tags
sale shopper or
A Phrase is a group of words surrounded by double quotes
This will search for the term "bob" followed immediately by the term "norman" in the "name" field. Phrase queries can be used outside of a field query, e.g. "Bob Norman".
A prefix query will match documents containing terms that begin with a specified set of characters.
This will search for all terms that begin with the prefix "norm". For example, "norman".
Shopify supports the ability to escape special characters using backslash escaping. The current list of special characters is:
Names can include the characters
" but cannot start with them. Names can include escaped characters using backslash escaping.
The exists query will match documents with a non-NULL value in the specified field.
This query can be combined with a Not Query to find fields missing a value, e.g.