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:

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.

Google Shopping metafields are typically stored at the product level, which is the default for the Google & YouTube channel. Some third-party feed apps also read or write variant-level metafields in the same namespace, using the Variant Metafield: column prefix. Use whichever level your feed app actually reads from - your export will populate the columns that have values on your store.

In Altera, you work with these metafields using the standard metafield column format:

For variant-level data, use the Variant Metafield: prefix instead:

Here are the most commonly used Google Shopping metafields:

Follow these steps to export your existing Google Shopping metafield data.

In your Shopify admin, go to Apps and open Altera. Click New export.

Select Products as the data type. Then select the General and Metafields field groups.

Click the filter icon next to the Metafields field group. Add a filter condition with the following settings:

This ensures your export only includes Google Shopping metafields rather than every metafield on your products.

Click Start export. Your exported file will contain the product ID, handle, and all Google Shopping metafields that have values on your products.

Follow these steps to bulk-update Google Shopping metafields from a 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.

In Altera, click Upload file on the home page and select your spreadsheet. Review the import preview and click Run import.

Note: If your store only has variant-level metafield definitions for the mm-google-shopping namespace (or vice versa), you may see a PRD033 warning telling you the metafield is defined at the other level. If the data on your store is already stored at the level you're importing into, the warning is safe to ignore - the round trip from export to import is reliable. To silence the warning, create metafield definitions at the matching level in your Shopify admin.

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.