Tutorial

Updating Order Tags from Google Sheets

Learn how to update Shopify order tags in bulk using Google Sheets and eCommix.

Hernán Demczuk
Hernán Demczuk
Author
2 min read

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 Orders - Tags template

From the home page, select the Orders category in the template filter bar and click Create on the Orders - Tags template. If you are configuring a spreadsheet from scratch, click New Spreadsheet, select Two-Way Sync as the sync direction, and then choose the Orders - Tags template.

Template selection screen showing Orders - Tags template with Update Orders category selected
Select the Update Orders category to find the Orders - Tags template quickly

2. Update Order Tags

To update tags for an order, the row must include the order ID. eCommix uses that ID to find the order in Shopify and replaces its tags with whatever you have in the Tags (Order) column. The following field is required:

Edit the Tags (Order) column for the orders you want to update. Tags are comma-separated; for example VIP, wholesale, priority. To remove all tags from an order, clear the cell completely.

Google Sheet showing Orders - Tags spreadsheet with tags edited for two order rows
Edit the Tags (Order) column for each order; comma-separate multiple tags

Once your tags are ready, 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.

You can also update other order fields from Google Sheets. To update fulfillment tracking numbers, see the Updating Order Tracking Codes from Google Sheets tutorial.

Related articles

More guides in this category if you want to keep going deeper on the same workflow.

Ready to manage your Shopify store with Google Sheets?

Install eCommix free and start syncing your products, orders, and inventory in minutes.

Install Free on Shopify →