Start Free Trial
Start Free Trial

How to bulk export and update Google Shopping fields in Shopify

Google Shopping export from Shopify with all the detailed data

You can bulk update Google Shopping fields in Shopify by using the Matrixify app import and export functionality.
As you might have noticed – native import in Shopify Admin does have Google Shopping fields in it but does not actually update or export your Google Shopping sales channel data. Shopify Admin exports and imports only the legacy Google Shopping fields which are updating the Metafields in “google” namespace, however the new Google Shopping sales channel stores their values in Metafields “mm-google-shopping” namespace.
Here we can follow a few simple steps on how to update the correct Google Shopping data.

Steps in short to update Google Shopping fields in Shopify

  1. Make sure that at least one product has values in all Google Shopping fields.
  2. Create export in Matrixify app and select to export Products with Basic Columns and Metafields.
  3. Customize Columns for Metafield column to export only Metafields with mm-google-shopping namespace.
  4. In the exported file, update Metafield columns for your products.
  5. Save and import the file back to bulk update Google Shopping fields in your Shopify Admin.

1. Set Google Shopping values for one product in Admin

Google Shopping sales channel stores their data in Shopify Metafields. For Matrixify to be able to export this data, the Metafields need to be set for at least one of the Products that will be exported.
Open any product in your Shopify admin and at the top-right corner press “More Actions” -> “Google fields”.

If you do not see the “Google fields” under More actions, then you need to add the “Google” sales channel in your Shopify Admin.

1 - set values in Google Shopping fields for one product in Shopify

In Shopify, Metafield exists for a product if it has a value so to ensure that all Google Shopping Metafield columns are exported, set values in all Google Shopping fields for this one product.

2 - set values in Google Shopping fields for one product in Shopify with values

2. Create new export for Products with Metafields

Go into the Matrixify app in your store and create a new export.

3 - create new export in Matrixify app Shopify Excel CSV

In the new export page you need to select the export format.
As the goal is to update data in Shopify select to export to “Matrixify: Excel” format.

In the Sheets section select to export Products.

4 - create new export in Matrixify app Shopify Excel CSV

Now let’s move into the Products sheet!
As you do not need to update other Basic Product details select to export only the fields you need to identify the product – Basic Columns group – ID and Handle columns.
Select to export also the Metafields group to include Product level Metafields.

You can also add other columns to the export data if you need them – to reference the Product fields for your Google Shopping metafield columns.

5 - create new export with specific columns in Matrixify app Shopify Excel CSV

3. Export only Google Shopping Metafields

Once you have selected fields you wish to export you can tell the app to only export Google Shopping Metafields, if you have also other Metafields in your store.
Open the “Customize Columns” section and click on the pencil button next to the Metafields column. This section will allow to include only specific Metafield columns that you need.

6 - create new export in Matrixify app Shopify Excel CSV

Select the criteria “Namespace” with “equals to any of” condition. Fill the value mm-google-shopping and press the “Add” button to add the Metafield column selector. This will export only the Metafield columns for your Google Shopping sales channel.

These are the minimal columns that you need exported to bulk update Google Shopping fields in Shopify. But of course, you can add additional columns in that same export if you need them for reference.

7 - create new export in Matrixify app, export Google Shopping Metafields Shopify Excel CSV

Press the “Export” button to start the export and download the file when finished.

8 - download export Shopify Products with Metafields in Matrixify app Excel CSV

4. Update Metafield columns in the exported file

Once you have the exported file, open it and find Metafield columns for Google Shopping.
Each Google Shopping Metafield is also explained in our Products export sheet documentation in a case you need to identify what a specific column means and what values can be entered in what columns.

9 - exported Google Shopping fields Metafields Shopify bulk export import update Excel CSV Matrixify

Now you can bulk set values in these fields for other Products.
Make sure that capitalization for values is also set correctly – to match the Google Shopping requirements for allowed values in each field.
App will save in these Metafields with whatever values you enter but Google Shopping might not accept them if capitalization is not correct.

10 - edit Google Shopping fields Metafields Shopify bulk export import update Excel CSV Matrixify

5. Import to bulk update Google Shopping fields in Shopify

When you have finished editing the file save and head back into the Matrixify app.
Upload your file in the Import section, wait for the app to analyze it, and press the “Import” button to start the import.

11 - import Shopify Metafields with Excel CSV Matrixify app

You can read our “How it works” page for more details about how the import process works.

Once the import is finished, the data is updated in Shopify. Enjoy your bulk updated Google Shopping fields!

12 - bulk edit Google Shopping fields Metafields Shopify bulk export import update Excel CSV Matrixify

Good to know!