How it works Features Help center Sign In Sign up

Getting started

Mixtable basics
Connect your store to Mixtable
Using Mixtable to manage your store

Shopify user guide

Edit metafields
Manage and track inventory
Adjust inventory quantity
Bulk edit store data
Bulk edit Google Shopping fields
Add variants to your products in bulk
Bulk import or add products
Add products to collections
Bulk change product prices
Bulk edit product descriptions
Bulk add, update, and delete tags
Bulk edit customers
Bulk update product status
Change variant display order
Using the Shopify sidebar
Bulk actions
Increase prices in bulk
Set product cost per item
Bulk find and replace
Bulk import or add customers
Delete a product
Edit Shopify product descriptions with rich text editor
Export store data to Excel
Export orders with metafields
Export orders data
Export products with metafields
Export products data
Manage product images
Manage variant images
Bulk delete customers
Bulk delete orders
Bulk delete products
Bulk delete product variants
Export products with collections
View product data history
View product price history
Analyze store sales
Configure worksheet sync filter
Building a Shopify store CRM
Update SEO Title and SEO Description
Load the products of a single vendor into a worksheet
Set image ALT tag

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.

Syncing a Google Shopping field to a column

  1. Create workbook and set up a worksheet to sync your Shopify products.
  2. 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 purple background. When you right click you’ll see a context menu show up. Select the Shopify Sync Settings option.
  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 dropdown 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.

Editing and syncing Google Shopping fields to Shopify

  1. Now that we have one or more Google Fields mapped to columns, modify any of the cells with the values you want. In this case we are changing the Condition of our product to “used”.
  2. When you are done, click on the Done Editing button, and Mixtable will update the Google Shopping fields data that changed to Shopify. It may take a few seconds before you see the new information in your store.