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:
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:
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