Manage your Shopify store with Mixtable

This page explains the core concepts you need to be aware of when using Mixtable for the purpose of synchronizing data to/from your Shopify store. Please note that the content below assumes that you have already linked your Shopify store with Mixtable.

Creating a Shopify-linked workbook

To get going, click on the Add Workbook button on your Mixtable dashboard. In the dialog that opens you will be presented with two options. You can start with a Blank Workbook, or with a Starter Shopify Workbook.

The Blank Workbook options creates a blank, Excel-like new workbook with a blank worksheet in it. If you go down this route you can then add Shopify data-linked worksheets for the data you need as outlined below.

The Starter Shopify Workbook option creates a workbook pre-populated with worksheet for the data we most commonly find users adding, and a starter set of data within each worksheet mapped to columns.

Adding a Shopify-linked worksheet

At any time, and from any workbook you can add a new worksheet that is linked to Shopify data. Click on the + button in the worksheet ribbon found at the bottom of your screen.

Now you’ll be asked whether you want to create a Basic Worksheet (blank, Excel-like new worksheet), or one that is integrated with Shopify data. The Shopify worksheet options are broken down by the type of data you want to sync (e.g., Products, Orders). Select the Shopify worksheet you’d like to add, and it will be immediately added to your workbook. You’ll also see that it will immediately start populating with any existing data from Shopify.

Syncing data from Shopify to Mixtable

Data is synced from Shopify to Mixtable automatically, whenever something is created/updated in Shopify, although it will take a few seconds for Shopify to notify Mixtable of the change, and Mixtable to process the data. If you don’t have your Shopify workbook open the change will be made in the background and you’ll see the updated data next time you open the workbook. If the workbook is currently open in your browser, then you’ll see the relevant cell(s) change their values, and they will be highlighted for a few seconds with a green border.

Syncing data from Mixtable to Shopify

To sync a piece of data from Mixtable to Shopify first update the relevant cell with the new data. The updated cell will be highlighted, showing that it has been saved in Mixtable’s database, _but has not yet _been sent to Shopify. The cell will stay highlighted even if you reload the workbook, allowing you to make changes over time and sync them to Shopify when you are good and ready.

To actually sync the changes you’ve made click on the Sync sheet to Shopify button in the top right corner of the screen. The highlighted cells will once again get a white background, and you’ll see an indication on the toolbar that the sync is tacking place.

Mapping spreadsheet columns to Shopify data

Not all Shopify data is shown in every worksheet all the time. To make a column show a particular field you need (e.g., the product’s description) you need to map a column to the field. To do so right-click on the column header and select Shopify Sync Settings.

In the window that opens, you have a choice whether to map a Core Field, a Metafield, a Mixtable Analytics field, and other options that will change depending on which Shopify data is stored in the worksheet.

Once you’ve selected the field you want to map to the column click on Save and you’ll see any existing Shopify data start to populate in the column.

Using Excel formulas in your Shopify worksheets

Just like you would in Excel, you can use formulas to set a cell’s value. The cell’s value can then be synced to Shopify as it changes based on the inputs. One thing to keep in mind is that if a cell contains a formula, then its content will only sync from Mixtable to Shopify. The cell’s content will not be affected if the underlying data changes in Shopify.

Exporting Shopify data to Excel xlsx file

At any time you can export your entire workbook into an Excel xlsx file. Simply open the workbook menu via the “three dots” button in the upper right corner of the screen and select the Export to .xlsx option. You’ll be immediately prompted with the location where to save the file.