Goal: Import and export Google Shopping metafields (custom labels, brand, condition, and more) so you can manage your Google Merchant Center product data in bulk through spreadsheets.
Prerequisites:
You have Altera installed on your Shopify store
Understanding Google Shopping Metafields
The Google & YouTube channel app stores product data in the mm-google-shopping metafield namespace. These metafields map directly to Google Merchant Center feed attributes like custom labels, brand, condition, and product category.
In Altera, you work with these metafields using the standard metafield column format:
Metafield: mm-google-shopping.{key} [single_line_text_field]
Here are the most commonly used Google Shopping metafields:
Column Header | Google Shopping Attribute |
| Custom Label 0 |
| Custom Label 1 |
| Custom Label 2 |
| Custom Label 3 |
| Custom Label 4 |
| Google Product Category |
| Brand |
| Condition |
| Gender |
| Age Group |
| Color |
| Size |
| Material |
Exporting Google Shopping Metafields
Follow these steps to export your existing Google Shopping metafield data.
Step 1 - Create a new export
In your Shopify admin, go to Apps and open Altera. Click New export.
Step 2 - Select products and fields
Select Products as the data type. Then select the General and Metafields field groups.
Step 3 - Filter to Google Shopping metafields only
Click the filter icon next to the Metafields field group. Add a filter condition with the following settings:
Column: Namespace
Relation: Equals
Value:
mm-google-shopping
This ensures your export only includes Google Shopping metafields rather than every metafield on your products.
Step 4 - Start the export
Click Start export. Your exported file will contain the product ID, handle, and all Google Shopping metafields that have values on your products.
Importing Google Shopping Metafields
Follow these steps to bulk-update Google Shopping metafields from a spreadsheet.
Step 1 - Prepare your spreadsheet
Create a CSV or Excel file with at least one identifier column (ID or Handle) and the Google Shopping metafield columns you want to update. Use the exact column headers from the table above.
Step 2 - Upload and import
In Altera, click Upload file on the home page and select your spreadsheet. Review the import preview and click Run import.
Example Spreadsheet
Handle | Command | Metafield: mm-google-shopping.custom_label_0 [single_line_text_field] | Metafield: mm-google-shopping.brand [single_line_text_field] | Metafield: mm-google-shopping.condition [single_line_text_field] |
| MERGE | Summer Sale | Acme Clothing | new |
| MERGE | Clearance | Acme Footwear | new |
Outcome
After exporting, you have a spreadsheet with your current Google Shopping metafield values filtered to just the mm-google-shopping namespace. After importing, your product metafields are updated in Shopify and will sync to Google Merchant Center through the Google & YouTube channel.
Next Steps
How to export a Google Shopping feed for generating a Merchant Center feed file
How to convert Google Shopping categories to Shopify taxonomy categories for migrating category data
Metafields guide for more details on working with metafields
