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 template
From the home page, select the Update Products category in the template filter bar and click Create on the Products 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 template.
2. Update Existing Products
To update an existing product, the row must have an Id (Product) value. eCommix uses the ID to locate the product in Shopify and applies only the columns that are present in the sheet. The following field is required:
- Id (Product) - The Shopify product ID. This is exported automatically when you sync a Products spreadsheet. Do not modify it.
Any other product field included in the sheet can be updated: title, body HTML, vendor, type, tags, collections, status, SEO fields, option names, template suffix, metafields, and more. Columns that are not present in the sheet are left unchanged. Note that Handle (Product) cannot be changed via update.
In this example, Tags (Product) was updated for the first three products; edited cells turn light blue to mark them as changed. Edit any fields you need, then go back to eCommix, click Sync, and hit Import to push the changes to Shopify. If you are not familiar with the Sync flow, the How Two-Way Sync Works tutorial walks you through it step by step.
If you need to update variant-level fields like price, SKU, or weight instead, see the Updating Product Variants from Google Sheets tutorial. To update inventory quantities, prices, metafields, or region catalog prices in bulk, see the Updating Product Inventory Quantities, Updating Product Prices, Updating Product Metafields, and Updating Region Catalog Prices tutorials.
3. Applying Updates to Product-Level Rows Only
If your spreadsheet includes both products and variants, and you want to target only product-level fields - such as vendor, tags, or category - you can isolate those rows by adding the Top Row field to your sheet.
Once the column is in the sheet, use Google Sheets' built-in filter to show only the rows where Top Row is true. That way any edits you make apply exclusively to the product-level row and leave variant rows untouched.
