Advanced Product Filter

The Advanced Filter allows you to create complex, multi-condition filters to find exactly the products you need. Save frequently-used filters for quick access.

Opening the Filter

  1. Click the Filter button in the toolbar (funnel icon)
  2. Or use keyboard shortcut

Filter Interface

Saved Filters

At the top, select from previously saved filters:

  • Choose a saved filter from the dropdown
  • Click Delete to remove a saved filter
  • Loading a saved filter populates all conditions

Filter Conditions

Each condition consists of:

  1. Field - Which product attribute to filter
  2. Value/Operator - The filter criteria

Add multiple conditions to narrow results.

Available Fields

Text Fields

Field Description Example Values
Title Product name "Blue Widget", "Summer Dress"
Vendor Brand/manufacturer "Nike", "Apple"
Product Type Category "Shirts", "Electronics"
Handle URL slug "blue-widget-large"
SKU Stock keeping unit "SKU-001", "PROD-ABC"
Barcode UPC/EAN "123456789012"

Numeric Fields

Field Description Example Values
Price Variant price "29.99", ">50", "10-100"
Compare At Price Original price ">0" (has compare price)
Inventory Stock quantity "<10", "0", ">=100"
Variant Count Number of variants ">1", "=1"

Status Fields

Field Description Options
Status Publication status Active, Draft, Archived

Date Fields

Field Description
Created At When product was created
Updated At Last modification date
Published At When product went live

Special Fields

Field Description
Tags Product tags (multi-select)
Collections Collection membership (multi-select)
Sales Quantity Units sold (requires sales sync)
Sales Revenue Revenue generated (requires sales sync)

Filter Syntax

Text Field Operators

Syntax Meaning Example
value Contains blue matches "Blue Widget"
=value Exact match =Blue matches only "Blue"
!=value Does not contain !=draft excludes drafts
^value Starts with ^Summer matches "Summer Dress"
$value Ends with $XL matches "Shirt XL"

Numeric Field Operators

Syntax Meaning Example
number Equals 100 matches price of 100
>number Greater than >50 matches 51+
>=number Greater or equal >=50 matches 50+
<number Less than <10 matches 0-9
<=number Less or equal <=10 matches 0-10
min-max Range 10-50 matches 10 to 50

Date Field Selection

For date fields, use the date picker:

  • From date - Start of range
  • To date - End of range
  • Leave either blank for open-ended range

Sales Field Syntax

Sales fields support threshold with optional date range:

Component Purpose
Value Threshold (e.g., >10, >=100)
From Date Start of sales period
To Date End of sales period

Example: Find products with >100 sales in Q4 2024

Using Multiple Conditions

Adding Conditions

  1. Click + Add Condition
  2. Select field from dropdown
  3. Enter value/criteria
  4. Repeat for additional conditions

Condition Logic

All conditions use AND logic:

  • Product must match ALL conditions to appear
  • More conditions = narrower results

Removing Conditions

Click the X button on any condition to remove it.

Saving Filters

Save Current Filter

  1. Configure your conditions
  2. Enter a name in "Save as" field
  3. Click Save Filter

Using Saved Filters

  1. Select from "Saved Filters" dropdown
  2. Conditions auto-populate
  3. Modify if needed
  4. Apply or save as new name

Deleting Saved Filters

  1. Select the filter to delete
  2. Click Delete button
  3. Filter is removed from list

Common Filter Examples

Low Stock Items

Field: Inventory
Value: <10

High-Value Products

Field: Price
Value: >100

Products Without Images

Field: Image Count
Value: =0

Recent Products

Field: Created At
From: [30 days ago]
To: [today]

Inactive Products

Field: Status
Value: Draft

Products by Tag

Field: Tags
Value: [Select "Sale", "Featured"]

Uncategorized Products

Field: Collections
Value: [Not in any collection]

Best Sellers (requires sales sync)

Field: Sales Quantity
Value: >50
From: [start of quarter]
To: [today]

Field-Specific Help

When you select a field, the help panel shows:

  • Field type (Text, Numeric, Date)
  • Available operators for that type
  • Examples of valid input

The help panel updates dynamically as you work.

Validation

Invalid Input

Invalid filter values show:

  • Red border on input field
  • Warning icon
  • Tooltip with error message

Common Validation Errors

Error Cause Fix
"Invalid number" Text in numeric field Enter numbers only
"Invalid date range" From after To Swap dates
"Empty value" No criteria entered Enter a value

Best Practices

Building Effective Filters

  1. Start broad - Begin with one condition
  2. Add gradually - Add conditions one at a time
  3. Check results - Apply and verify after each addition
  4. Save useful filters - Don't recreate complex filters

Filter Performance

  • Simple filters are fastest
  • Text "contains" is slower than "equals"
  • Large result sets may be slower to display

Organizing Saved Filters

  • Use descriptive names
  • Include criteria in name (e.g., "Low Stock < 10")
  • Delete unused filters

Keyboard Shortcuts

Shortcut Action
Enter Apply filters
Escape Cancel / Close

See Also