Update Order Tracking Number in Airtable When It Is Added In Shopify

[Laura_Hartle]

Hello,
I’m hoping someone may be able to help because I haven’t found a solution in previous posts.

My team uses Airtable to project manage the creation of jewelry. Make pulls in the order info from Shopify and then it goes through its lifecycle in Airtable.

I would love to find a way to either enter the tracking information in Shopify and have it populate in a corresponding Tracking # field (column in Excel or Google Sheets) in Airtable or update the Tracking # field in Airtable.

I have a Fulfillment Webhook

But when I get to the Airtable module, I would have to choose an individual record ID to update (Row number in Excel, Google Sheets).

Is it possible to create a flow where any time an order in Shopify is fulfilled with a tracking number, that tracking number is added to the corresponding order number record in Airtable?

Thanks for any help and much appreciated!
Laura

[Laura_Hartle]

Hi,
I was able to make this work using the following diagram and outputs. However, it will only grab the first tracking number. If tracking is updated with a new tracking number at any point, it will not update. I posted about it here, in case anyone has any answers.
Unable to Retrieve Last Object In Array (Last Tracking Number Used).

If my scenario of updating new tracking numbers for an order does not apply for you, then this diagram below should work for you:

Create Fulfillment Webhook

Choose your table, view, and then use this formula:

Map the record ID and map the tracking

Cheers!