Mixtable’s spreadsheet interface makes it very easy to edit your Shopify products’ Google Shopping fields individually or in bulk. This page will walk you through mapping the Google Shopping fields to columns in your workbook so that the Google Shopping fields’ data shows up and then making changes and syncing these changes back to Shopify.
- After installing the Mixtable Spreadsheet app, create a workbook and set up a worksheet to sync your Shopify products.
- Right-click on the column header of a column that is not yet mapped to sync to a field. Such columns have a grey background, whereas columns that are set up for data syncing have a light green background. When you right-click, a context menu will appear. Select the Shopify Sync Settings option.
- In the window that opens, select the Google Shopping Fields radio button option.
- You’ll now be prompted to select which Google Shopping field you’d like to display and edit from the column. Open the dropdown and select your chosen field. Here, we are going to select the Condition field.
- You’ll now see Mixtable set up this new column with a heading (which you are free to change), and populate all the cells with any pre-existing data for the Google Shopping field in question. If the Google Shopping field requires that its value is from a list of pre-determined options, such as the Condition field in our example, which can be New, Used, or Refurbished, then Mixtable will automatically add a drop-down to each cell to make changing the value easier. You can also always change the field’s value by manually editing the cell, like you would do in Excel.
If you start a brand-new worksheet, you can simply load the pre-built Google Shopping template. Here’s how to do it:
- After installing the Mixtable Spreadsheet Editor app, click the Create a Workbook button.
- Select the Google Shopping pre-built template from the list that appears in the dialog.
- Now that we have one or more Google Fields mapped to columns, modify any cells with the values you want. In the example above, we are changing the Condition of our product to “used”.
- When you are done, click the Sync worksheet changes to Shopify button at the bottom right corner of the worksheet. Mixtable will update the Google Shopping fields data that changed to Shopify. It may take a few seconds to see your store’s new information.
Operating in the Mixtable Spreadsheet Editor app allows you to use any spreadsheet function to analyze and manage your data, such as:
Find out more about the Mixtable suite of products here.
