This tutorial assumes you already know what Two-Way Sync is and how to configure it. If not, please review the How Two-Way Sync Works tutorial first.
1. Choose the Products - Metafields template
From the home page, select the Update Products category in the template filter bar and click Create on the Products - Metafields template. If you are configuring a spreadsheet from scratch, click New Spreadsheet, select Two-Way Sync as the sync direction, and then choose the Products - Metafields template.
2. Add metafield columns in the Format Data step
Metafield columns are not added automatically — you choose which metafields to include. In the Format Data step, open Manage Columns and scroll to the Metafields - Product and Metafields - Variant sections. These sections list every metafield definition that exists in your Shopify store. Check the ones you want to export and update.
Each selected metafield appears as a column named after the metafield with its type and owner in brackets; for example Product Rating (rating Product Metafield) or Care Instructions (single_line_text_field Variant Metafield). The type in the column name is informational — it tells eCommix how to parse and serialize the value when importing.
3. Edit metafield values in the spreadsheet
After the first export runs, you will see one row per product variant with the current metafield values filled in. Edit the cells for the variants you want to update. The following fields are required and must not be modified:
- Id (Product) — The Shopify product ID. Exported automatically; do not modify it.
- Id (Variant) — The Shopify variant ID. Exported automatically; do not modify it.
How you enter the value depends on the metafield type:
- Text, number, date, URL, color — type the value as plain text; for example
Red,29.99, or2025-12-31. - Boolean — enter
TRUEorFALSE. - List types and JSON — enter a valid JSON array; for example
["tag1", "tag2"]. - Metaobject reference — enter the handle or display name of the metaobject to link to.
To clear a metafield (remove its value from Shopify), leave the cell completely empty. Only rows where you change at least one cell will be processed on import.
4. Validate and import
Once your edits are ready, go back to eCommix and click Sync next to your spreadsheet. In the modal, click Validate first to preview which rows will be updated before anything is sent to Shopify.
After validation, check the STATUS column in the sheet. Rows ready to import show VALIDATED: Variant will be updated. Once satisfied, click Import to push the changes to Shopify.
After the import finishes, the STATUS column updates to UPDATED for each successfully saved row. If you are not familiar with the Sync flow, the How Two-Way Sync Works tutorial walks you through it step by step.
To update other variant-level fields such as price, SKU, or inventory quantities, see the Updating Product Variants from Google Sheets tutorial. To update inventory quantities across locations, see the Updating Product Inventory Quantities from Google Sheets tutorial.
