Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Is Blank and Is Not Blank

How the Is Blank and Is Not Blank Filters Work

The Is blank filter shows only the rows where a column is empty. The Is not blank filter does the opposite: it shows only the rows where that column has a value. Use these filters to find missing information or to hide rows with no data.

Example: Find products with no Variant Title

Say you want to see which products in your store do not have a Variant Title. Here is a small sample of products:

Product
Variant Title

Classic T-Shirt

Small

Classic T-Shirt

Large

Canvas Tote Bag

(empty)

Coffee Mug

Blue

Gift Card

(empty)

Here is what each filter shows when you add it to the Variant Title column:

Filter
What it shows
Rows in the report

Is blank

Only rows with an empty Variant Title

Canvas Tote Bag, Gift Card

Is not blank

Only rows that have a Variant Title

Classic T-Shirt (Small), Classic T-Shirt (Large), Coffee Mug (Blue)

When to use each filter

Use Is blank to find missing data that you may need to fix, such as products with no SKU or orders with no customer email. Use Is not blank to clean up a report so it only shows rows that have data in that column.

How Is Blank differs from other filters

You do not need to type a value when you use these filters. The filter only checks whether the column is empty or has something in it. Filters like Is, Contains, and Include need you to enter a value to match. To learn more, see How the Contains and Not Contains Filters Work.

Last updated