How do I write tracking numbers from Google Sheets back to Shopify?
On this page
With Pro, tracking numbers that you or your suppliers type into your synced spreadsheet fulfill the orders in Shopify. When a number changes in the sheet, the app updates the tracking in Shopify.
Before you start
- A Google Sheets sync is set up and saved (see “How do I sync new orders to Google Sheets?”).
- Tracking write-back is part of the Pro plan (see “What does the Pro plan add?”).
- The sync’s template has one row per order or one row per line item. Report templates that sum orders into one row cannot carry tracking.
- The orders ship from your own locations. Orders that another app or a fulfillment service ships are left to that app.
Turn it on
- In the app, open Settings and pick Google Sheets sync (for another sync, open it from More syncs).
- In Tracking write-back, tick Write tracking back to Shopify. Without Pro you see “Write tracking back to Shopify” with the button to start Pro instead.
- If you see “Allow the app to fulfill orders”, click Allow fulfillment access and approve the request in Shopify. The app asks for this access only now, not when you install it.
- Tick Email customers when an order ships if Shopify should send its shipping confirmation, and its shipping update when a tracking number changes. Leave it off to fulfill orders without an email.
- Click Save in the bar at the top of the page.
On the next sync the app adds these columns after Order ID (sync key): Line item ID (sync key), Tracking number, Tracking company, Tracking URL and Tracking result. Click Sync now to add them right away.
Add tracking in the sheet
- In the row of the order, type the number into Tracking number.
- Optionally type the carrier into Tracking company (for example “UPS” or “DHL Express”) and a link into Tracking URL. The link must start with https:// or http://.
- Do not change the two sync key columns. The app uses them to find the order and its items.
The app reads the sheet on every sync, at least once an hour. Click Sync now in the app to read it right away.
- In a sheet with one row per order, the number fulfills every item of the order that is still open.
- In a sheet with one row per line item, each row fulfills only its own item. Rows of the same order with the same number become one shipment; rows with different numbers become separate shipments.
- A sync filtered to one supplier’s items fulfills only those items, so each supplier can fill in their own rows.
- To fix a typo, change the number in the same row. The app updates the shipment it created. Clearing a number does nothing in Shopify.
Verify it worked
- Tracking result in the row says “Fulfilled in Shopify”, “Tracking updated in Shopify” or “Already in Shopify”.
- In Shopify admin, the order shows as fulfilled with the tracking number.
- In the app, the sync’s status shows Tracking write-back with the time the sheet was last read and how many shipments were written to Shopify.
Turn it off
Untick Write tracking back to Shopify and click Save. The tracking columns and everything typed in them stay in the sheet. You can turn it off on any plan.
If Pro ends
The app stops reading tracking from the sheet, and the sync’s status says “Tracking write-back needs the Pro plan. Upgrade in the app to start it again.” New orders keep syncing to your first sheet.
Troubleshooting
The status shows “Needs attention”. Some rows need you. Read their Tracking result:
- “Order not found: do not edit the Order ID (sync key) column” or “Line item not found: do not edit the Line item ID (sync key) column”: the key was changed. Undo the change in that cell.
- “Line item ID (sync key) is empty: fulfill this order in Shopify”: the row was added before tracking write-back was on, and the order has more than one row. Fulfill it in Shopify admin.
- “Items shipped together have different tracking numbers: make them match”: one item is listed twice with different numbers. Use one number per item.
- “Items ship from more than one location: fulfill this order in Shopify”, “Order has several shipments: update the tracking in Shopify” or “Order is too large to match: fulfill it in Shopify”: the app does not guess which shipment is which. Use Shopify admin for this order.
- “Nothing left to fulfill here (or another app fulfills it)”: the items are already fulfilled, or another app or fulfillment service ships them.
- “Tracking URL must start with https:// or http://” or “Tracking number is longer than 255 characters”: fix the cell.
- “Shopify: …”: Shopify refused the change and gives the reason after the colon.
The status shows “Columna may not fulfill orders yet. Open the sync settings and allow fulfillment access.” Open the sync and click Allow fulfillment access.
A row says “Shopify denied Columna access needed to write tracking: contact support”. Fulfillment access is allowed, but Shopify refused another part of the change. Contact support from the app; the rows wait for the next sync.
The status shows “The sheet has no tracking columns yet.” The tab has your own columns after Order ID (sync key), or the template is a report. Move your columns before Order ID (sync key), or pick a template with one row per order or line item.
A row says “Shopify is busy: tried again on the next sync” or “Shopify could not be reached: tried again on the next sync”. Nothing to do; the next sync tries again.