Set up a Conditional Worksheet for Shopify data

There are times when you don’t want all your Shopify data to be loaded in a worksheet. For example, you might want to load only products with specific names, or products from a specific vendor, or products that have a specific tag, or orders after a specific date. Mixtable allows you to do this by adding a Conditional Worksheet with your Shopify data. If you set up a Conditional Worksheet then Mixtable will only load data that matches the criteria you’ve set out. If a new object is added in Shopify (e.g., a new product), then that object will only load in the worksheet if it matches the Conditional Worksheet criteria.

To create a Conditional Worksheet follow these steps:

1. Click the + button in the workbook tab strip to add a new worksheet
2. Select the data you’d like to load in your worksheet. E.g., Products
3. You’ll now be prompted to choose whether you want all data to be loaded in the worksheet, or to Set Conditional Worksheet criteria. Select the second option.
4. You’ll now see an interface that allows you to Add Condition. You’ll be able to pick from the fields your data has and to set up the conditional criteria for each such field. For example, to load only products that have “aliexpress” as the vendor and whose tags include “best-seller”. You can set up more than one condition, and to select whether data is loaded when all conditions are met (an AND condition), or whether only one of the conditions is met (an OR condition). You can set up a condition for all the “core” fields your object has, along for any metafields that you’ve defined for the object.

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.