Bulk edit the Google Shopping fields for your Shopify products

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.

Google Shopping fields in a spreadsheet

1. After installing the Mixtable Spreadsheet app, create a workbook and set up a worksheet to sync your Shopify products.

2. To load new Shopify data, start by selecting an empty column — any column with a non-green header (green headers mean the column is already linked to Shopify data). Then, click the ⚡️ button in the column header to open the selection window to choose the data you want to pull in.

   

3. In the window that opens, select the Google Shopping Fields radio button option.

4. 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.

5. 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.

Optional: Use the pre-built Google Shopping workbook

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.

Edit Google Shopping fields and sync changes to Shopify

1. 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”.
2. 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.

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.