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.
