Skip to main content

Setting Up Filters

Filters are how you pick which products or variants a bulk edit (or export) will act on. Bulk Product Editor uses a structured condition builder — you pick a field, an operator, and a value, and stack as many conditions as you need.

Filter Builder with three conditions and AND/OR toggle

A filter is a list of conditions joined by ALL (AND) or ANY (OR).

How filters work​

Three concepts to know:

  • Conditions — Each condition targets one field with one operator and (usually) one value. Example: Status equals Active, or Price is greater than 50.
  • Join logic — At the bottom of the panel, pick Match ALL (every condition must be true — AND) or Match ANY (at least one condition must be true — OR).
  • Quick search — A separate text box that searches across title, vendor, product type, SKU, and barcode with OR logic. Combine it with explicit conditions when you want a fast text-based narrow-down.

Once you have your conditions, click Search. The results table updates with matching rows. From there you can refine, save a preset, or move on to defining modifications.

Supported conditions​

The fields and operators below come straight from the app's filter builder. You won't need to remember any syntax — the UI gives you dropdowns for everything.

Text fields​

Applies to: Title, Vendor, Product type, Handle, Description, SEO title, SEO description (product); SKU, Barcode, Variant title, Option values (variant).

Operators:

  • Contains / Doesn't contain
  • Equals / Doesn't equal
  • Starts with / Ends with
  • Is blank / Is not blank
  • Is defined / Is not defined (useful for metafields)
  • Has duplicates (find rows where the value is shared with another row)

Number fields​

Applies to: Price, Compare-at price, Cost, Inventory, Weight.

Operators:

  • Equals
  • Greater than / Greater than or equal
  • Less than / Less than or equal
  • Between (min and max)
  • Is defined / Is not defined

For Weight, you also pick the unit you're entering values in (g, kg, oz, lb); the app converts internally.

Cross-field comparisons​

For Price, you can compare against other numeric variant fields without typing numbers:

  • Price vs Compare-at price: less than / equal to / greater than (and % variants like "Price is less than X% of Compare-at price").
  • Price vs Cost: same set.

Use these for things like "find every variant where Price is less than 110% of Cost" without exporting a spreadsheet.

Boolean (yes/no) fields​

  • Has images — true / false
  • Published — true / false (i.e. published to the Online Store sales channel)
  • Inventory tracked — true / false
  • Taxable — true / false
  • Requires shipping — true / false

Status​

A dropdown of the Shopify product status: Active, Draft, Archived.

Inventory policy​

A variant-level field controlling overselling behavior:

  • Deny — Stop selling when out of stock (Shopify's default).
  • Continue — Allow overselling when out of stock.

Tags​

Match against product tags:

  • Has any of these tags
  • Has all of these tags
  • Has none of these tags ("Not any")
  • Doesn't have all of these tags ("Not all")
  • Has none of these tags from manual matches ("Not any manual")

Collections​

Match against collection membership:

  • In any of the selected collections
  • In all of the selected collections
  • Not in any of the selected collections
  • Not in any collection at all
  • Not in any manual collection

Inventory at a specific location​

Variant-only. Pick a location from your shop, then use the standard numeric operators (greater than, between, etc.). Use this when stock at one warehouse drives the change, not total stock.

Metafield​

Match against any metafield by namespace and key. Pick the value type — string, number, or boolean — and the operators match that type (text operators for strings, numeric operators for numbers, true/false for booleans).

Specific products​

Manually pick a list of products to include — or, with the Exclude toggle on, a list to exclude. Useful for one-off edits or for carving exceptions out of a broader filter.

Filter presets​

Once you've built a filter you like, click Save preset in the Filter Builder. Give it a name, and it'll appear in the Load preset menu the next time you open the bulk edit or export workspace.

Save filter preset dialog

Saved presets show up under Load preset next time you build a filter.

Plan limits apply — Free plans can save up to 5 presets across filter, modification, and export presets; paid plans are unlimited. See Filter presets for the full guide.

Worked examples​

Find draft products with no images​

  • Match ALL
  • Status equals Draft
  • Has images equals false

Use this to clean up unfinished listings before publishing.

Increase price on a specific vendor's active products​

  • Match ALL
  • Vendor equals "Acme Co"
  • Status equals Active

Run, then add a Price modification with the Increase by % operation.

Find variants priced too close to cost​

  • Match ALL
  • Price is less than 110% of Cost (cross-field comparison)
  • Status equals Active

Catch low-margin variants before a sale.

Bulk-clear discounts that didn't get cleaned up​

  • Match ALL
  • Compare-at price is defined
  • Tags has any "summer-sale"

Then add a Compare-at price modification with Clear, and a Tags modification to Remove summer-sale.

Restock alert candidates at a specific warehouse​

  • Match ALL
  • Inventory at location "Brooklyn DC" is less than 10
  • Inventory tracked equals true

Pair with an export to send the list to your replenishment team.

Tips​

  • Pick the right scope. The results table can show one row per product or one per variant, depending on the kind of modifications you plan to make. Variant-level conditions (SKU, barcode, variant inventory) work best with variant-scoped results.
  • Use Quick search first to narrow down. A fast title/SKU search before adding structured conditions saves clicks.
  • Always preview before running. No matter how confident the filter looks, the Preview step shows the exact before/after for every row — use it.
  • Save a preset for anything you'll repeat. Quarterly cleanups, vendor updates, and seasonal pushes all benefit from one-click reload.

What's next?​