Set up a Conditional Worksheet for Shopify data

Use a Conditional Worksheet when you want to load only the Shopify records that match rules you choose. For example, you can load products from one vendor, products with a particular tag, or B2B orders from a specific company.

Create a Conditional Worksheet

1. Click the + button in the spreadsheet tab strip to add a new worksheet
2. Select Shopify data worksheet, then click Continue
3. Select the type of Shopify data you want to load, then continue to Choose your columns
4. Select and arrange the columns you want, then click Continue
5. Under Which rows should we load?, select Only rows that match rules
6. Build your rules by choosing a field, an operator, and a value for each condition
7. Choose whether records must match all rules or any rule
8. Click Create Worksheet

Available rules depend on the Shopify data you selected and can include standard Shopify fields and defined metafields. Mixtable loads existing records that match and can add new records when they begin matching the rules.

What happens when data no longer matches

Mixtable keeps Conditional Worksheets aligned with your Shopify store. If a Shopify object starts matching your conditions, Mixtable can add it to the worksheet. If an object used to match but no longer does, its row may become empty.

The same thing can happen after you change the conditions for a Conditional Worksheet. Rows for Shopify objects that matched the old conditions, but do not match the new ones, may become empty.

When Mixtable detects empty rows the first time you open a worksheet during a browser session, it shows an Empty rows detected notice. Click Clear Empty Rows in that notice to remove them.

You can also clean up manually:

1. Leave them in place
2. Select the empty row headers and delete the rows manually
3. Click the Worksheet menu and select Remove Empty Rows to clean up rows that no longer contain worksheet data

Removing empty worksheet rows does not delete records from Shopify. See find and remove empty worksheet rows for complete instructions.

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.