Sync
Shopify fulfillments with
Airtable
Every shipment in one Airtable table: status, carrier, tracking numbers, delivery dates, and the order it belongs to. Review and report on fulfillment across all your orders.
5‑day free trial, then from $35 a month. Billed through Shopify.
3.8 billion Shopify records synced since 2019 for brands like these
Fulfillment fields you can track in Airtable
Every field below comes into Airtable for review and reporting. Fulfillment data is read only, so nothing here is written back to Shopify.
| Area | Fields | Into Airtable | Back to Shopify |
|---|---|---|---|
| Fulfillment details | Name, status, display status, shipment status, and created and updated dates | Read only | |
| Tracking | Tracking company, tracking number, and tracking URL, plus every number and URL when a fulfillment has more than one package | Read only | |
| Delivery dates | In transit, estimated delivery, and delivered dates | Read only | |
| Service and location | Fulfillment service name and type, requires shipping, and the location the shipment left from | Read only | |
| Quantities | Total quantity shipped in each fulfillment | Read only | |
| Fulfillment line items | SKU, title, quantity, price, delivery status, shipping company, tracking number, and tracking link, on a linked Fulfillment Line Items table Set up fulfillments | Read only | |
| Order links | Links from each fulfillment to its order, and from each fulfillment line item to its order line item How links work | Read only |
To change order tags or notes from Airtable, see Orders.
From Shopify into Airtable
One Shopify to Airtable Sync does the work. Fulfillment data flows one way, into Airtable.
-
Bring fulfillments in
Add Fulfillments and Fulfillment line items to a Shopify to Airtable Sync and save it. The last six months of fulfillments download into their own tables, and new fulfillments and tracking updates arrive as Shopify sends them.
-
Review shipments
Filter a view by status, carrier, or location to see what shipped, what is in transit, and what was delivered. Each row links back to its order.
-
Build reports
Group and roll up fulfillment rows in Airtable to count shipments per day, per carrier, or per location. Fulfillment line items show shipped quantities for each SKU.
Add orders to the same Sync. Add Orders and Order line items to the same Sync so each fulfillment links to its order and each fulfillment line item links to the item it shipped. How linked tables work
Common fulfillment jobs
Step-by-step guides for tracking shipments and orders in Airtable.
“We manage about 500 SKUs and being able to sync the data to airtable for analysis, automations, and reporting is invaluable.”
Fulfillment questions
More answers in the help center, or email team@airpowersync.com.
Can I edit fulfillments in Airtable and send them to Shopify?
No. Fulfillments and Fulfillment Line Items sync from Shopify to Airtable only. Changes made in Airtable stay in Airtable. Create or update fulfillments in Shopify or your shipping app, and the new data comes into Airtable.
How do new fulfillments reach Airtable?
Shopify notifies the app when a fulfillment is created or updated. The Sync then writes the change to Airtable on its schedule. Set the sync frequency
Can I load fulfillments from before I set up the Sync?
Yes. Saving the Sync loads the last six months of fulfillments. To go further back, in Settings > Download data, set the Since date next to Fulfillments and click Download.
Do fulfillments link to orders?
Yes, when Orders and Order line items are in the same Sync. Each fulfillment links to its order. Each fulfillment line item links to its fulfillment, its order, and the order line item it shipped.
Related features
Try AirPower on your own store
Install it from the Shopify App Store, connect an Airtable base, and run your first Sync today. Free for 5 days.
AirPower



