Manage your Shopify store with Mixtable

This page explains the main steps for working with Shopify data in Mixtable. It assumes that you have already connected your Shopify store.

Creating a Shopify-linked spreadsheet

To get going, click the Create Spreadsheet button on your Mixtable dashboard. In the dialog that opens, you can pick from a variety of pre-built templates organized by category (Products, Inventory & Pricing, Orders & Customers, Organization, Content, Integrations, and Analytics), or start from scratch with a Blank Excel-like Spreadsheet. Each template comes pre-configured with the columns you need, so you can start editing right away.

Adding a Shopify-linked worksheet

You can add a Shopify-linked worksheet to any Mixtable spreadsheet.

In an existing Mixtable spreadsheet, click the (+) button to add a new worksheet.

The Add Worksheet dialog guides you through four choices:

1. Under Choose a worksheet type, select Shopify data worksheet, then click Continue
2. Under What data do you want to work with?, choose the type of Shopify data you want, such as Products (with variants), Orders (no line items), Fulfillments, Discounts, or Markets
3. Under Choose your columns, select the Shopify fields that should appear in the worksheet. You can search for fields, choose the most-used fields, select every field, remove fields, and drag column headers to change their order
4. Under Which rows should we load?, choose Load everything or Only rows that match rules, then click Create Worksheet

Orders and order-line-item worksheets use a date range or a condition instead of loading an unlimited order history. If more than one Shopify store is connected, the first step also asks which store the worksheet should use.

Mixtable creates the worksheet and starts loading the selected Shopify data. The available fields and row options depend on the type of data you chose.

Syncing data from Shopify to Mixtable

For Shopify data that supports automatic updates, changes made in Shopify are sent to Mixtable after Shopify notifies the app. This can take a few seconds. If the spreadsheet is open, the relevant cells update and briefly show a green border.

Some data sources require a manual download or reload instead. These include blogs, blog posts, pages, payouts, balance transactions, media images, translations, Market prices, and B2B prices. Mixtable shows the relevant download or reload control when manual action is required.

Syncing data from Mixtable to Shopify

To update Shopify from Mixtable, edit a Shopify-linked cell. The highlighted cell is saved as a pending change, but it has not yet been sent to Shopify. It stays pending if you reload the spreadsheet, so you can prepare and review a batch before publishing it.

When you are ready, click Sync to Shopify on the right side of the worksheet. Mixtable then sends the supported pending changes to Shopify and shows the sync progress.

If you’d like to double-check what will update before anything reaches Shopify, click Preview changes next to the Sync to Shopify button to review every pending edit. See Preview Shopify changes before syncing for details.

Mapping spreadsheet columns to Shopify data

Not every available Shopify field is displayed by default. To show another field, such as a product description, map an empty column to that Shopify data.

To load new Shopify data, start by selecting an empty column, meaning any column with a non-green header. A green header means the column is already linked to Shopify data. Then click the button in the column header to open the selection window and choose the data you want to pull in.

In the window that opens, choose Shopify data fields, Metafields, Analytics, Related Data Fields, or another available column type. The choices depend on the type of Shopify data in the worksheet.

Select the field you want, click Save Column, and Mixtable loads its existing Shopify values into the column.

Using Excel formulas in your Shopify worksheets

Just like you would in Excel, you can use formulas to set a Shopify value in the spreadsheet. 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 spreadsheet to an Excel XLSX file. Click Import & Export in the top toolbar, then select Export to Excel. The file will be downloaded to your computer right away.

To export the current worksheet as a CSV file instead, select Export to CSV from the same menu.