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 - Tracking Numbers template
From the home page, select the Orders category in the template filter bar and click Create on the Orders - Tracking Numbers 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 - Tracking Numbers template.
2. Update Tracking Codes
To update tracking information for an order, the row must include both the order ID and fulfillment ID. eCommix uses those IDs to find the fulfillment in Shopify and updates the tracking fields included in the sheet. The following fields are required:
- Id (Order) — The Shopify order ID. This is exported automatically when you sync an Orders spreadsheet. Do not modify it.
- Id (Fulfillment) — The Shopify fulfillment ID. This is exported automatically for fulfilled orders. Do not modify it.
Edit the tracking columns you need: Tracking Info 1: Company (Fulfillment), Tracking Info 1: Number (Fulfillment), and Tracking Info 1: URL (Fulfillment). Columns that are not present in the sheet are left unchanged.
Once your tracking codes 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 order tags, see the Updating Order Tags from Google Sheets tutorial.
