Show Only Matching Products with a Metafield-Based Conditional Worksheet

You can filter your Shopify products and variants in Mixtable by metafield values. This lets you work with just the products that match specific criteria—like showing only summer products, or variants assigned to a particular warehouse.

Common use cases:

• Show only products where a “Season” metafield equals “Summer”
• Show only variants where a “Warehouse” metafield equals “LA”
• Show only variants whose parent product has a specific metafield value

Before you start

Make sure:

1. The metafield you want to filter by is defined in Shopify (go to Settings → Custom data)
2. You know which worksheet type you need:

• Products (no variants) – for filtering products
• Products (with variants) – for filtering variants

Filter products by metafield

Use this to create a worksheet that only shows Shopify products matching a metafield value.

1. Click the + button to add a new worksheet
2. Select Products (no variants)
3. When prompted, choose Set Conditional Worksheet criteria
4. Click Add Condition
5. Select the metafield you want to filter by (shown by name)
6. Choose an operator (like Equals)
7. Enter the value you want to match
8. Click Save filter conditions

Mixtable will load only the products that match your metafield criteria.

Filter variants by metafield

Use this to create a worksheet with Shopify variants, filtered by either:

• A variant metafield value
• A parent product metafield value

1. Click the + button to add a new worksheet
2. Select Products (with variants)
3. When prompted, choose Set Conditional Worksheet criteria
4. Click Add Condition
5. Select the metafield you want to filter by
6. Choose an operator and enter the value
7. Click Save filter conditions

Note: In a variants worksheet, you can filter by both variant metafields and product metafields. If you have the same metafield name on both, you’ll see multiple options in the list—choose the one that matches what you want to filter.

Edit and sync your changes

Once your Conditional Worksheet finishes loading:

1. Make your edits in the spreadsheet
2. Click Sync worksheet changes to Shopify when you’re ready

Change your filter criteria

To adjust your Conditional Worksheet criteria later:

1. Open the worksheet
2. Click Change Conditional Worksheet criteria
3. Update your conditions
4. Click Save Conditional Worksheet criteria

Mixtable will refresh the worksheet to show rows matching your new filter.

Troubleshooting

My metafield isn’t showing as a filter option

Make sure the metafield definition exists in Shopify (check Settings → Custom data), then try again.

Not all metafield types appear

Conditional Worksheets support common single-value metafield types like text, number, date, and boolean. Other types may not be available for filtering.

You're ready!

Mixtable is an online spreadsheet designed to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. With Mixtable you can:

• Bulk add products to collections, edit metafields, add or remove tags;
• Change product prices, including international prices, and review price history;
• Manage customers with a spreadsheet CRM for Shopify;
• Use Excel features like sort ascending or descending, find-replace, filter, and more.

Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.