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.

Fulfillments recorded in Shopify arrive in Airtable on their own, with carrier and status.

3.8 billion Shopify records synced since 2019 for brands like these

  • Birdy Grey
  • Radica
  • Known Source
  • Crockd
  • Apolis
  • Go Fast Campers
  • Foundation Goods

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.

  1. 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.

  2. 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.

  3. 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

“We manage about 500 SKUs and being able to sync the data to airtable for analysis, automations, and reporting is invaluable.”

GoGun.co, United States, on the Shopify App Store
4.9 from 68 reviews Read the reviews

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.

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.