AirPower
Bulk edit 
Shopify orders with 
Airtable
Every order and line item in Airtable for reports, queues, and dashboards. Tag or annotate hundreds of existing orders at once, then send the note and tag changes back to Shopify.
5‑day free trial, then from $35 a month. Billed through Shopify.
Built for Shopify
Shopify admin 3.8 billion Shopify records synced since 2019 for brands like these
Order fields in Airtable
Orders bring a lot of data into Airtable. The order note and tags can be changed there and sent back to Shopify. Everything else is for reporting.
| Area | Fields | Into Airtable | Back to Shopify |
|---|---|---|---|
| Note and tags | The order note and tags | ||
| Order name | The order name, such as #1001 | Read only | |
| Customer | Customer email, name, phone, tags, and note, as they appear on the order Customer records | Read only | |
| Totals and payment | Subtotal, total, tax, discounts, shipping, currency, financial status, and payment gateway | Read only | |
| Status and dates | Fulfillment status, processed, created, closed, and cancelled dates, and cancel reason | Read only | |
| Shipping | Shipping and billing addresses, shipping lines, and tracking company and number Fulfillments | Read only | |
| Payment terms | Terms such as Net 30, amount due, and issue, due, and paid dates Track payment terms | Read only | |
| Channel and marketing attribution | Sales channel, source name, landing page, referring site, and days to purchase, plus each order's first and last visit with its source, source type, referrer, referral code, and all five UTM tags Sync marketing attribution | Read only | |
| Line items | SKU, quantity, price, vendor, discounts, and custom properties such as engraving text, on a linked Order Line Items table Custom order options | Read only | |
| Note attributes | Checkout and app fields such as gift messages or delivery dates, each in its own column Sync note attributes | Read only |
Refunds, transactions, and draft orders have their own guides: Refunds, Order transactions, and Draft orders.
From Shopify to Airtable and back
Two Syncs do the work. One brings orders in and keeps them current. The other sends note and tag edits to Shopify.
-
Bring your orders in
Add Orders and Order line items to a Shopify to Airtable Sync and save it. The last six months of orders download into linked tables, and new orders and order changes keep arriving on their own.
-
Tag and annotate
Filter a view, for example unfulfilled orders or orders from one channel, then add tags or notes across hundreds of rows with paste or fill down.
-
Click Sync now
Rows with a Shopify ID update that order's note and tags. Rows without a Shopify ID are skipped, because AirPower does not create orders.
Need to create orders? AirPower does not create Shopify orders from Airtable. To build an order in Airtable, create a draft order instead. Draft orders can be created and updated from Airtable, with linked customers and line items. Draft orders
Shopify admin or Airtable for orders
Shopify's bulk editor and CSV files already handle some orders edits. Here is what changes when you work in Airtable.
| Task | In the Shopify admin | In Airtable with AirPower |
|---|---|---|
| Get orders into a spreadsheet | Orders can be exported to CSV but not imported. Large exports are emailed to you. | Orders arrive in Airtable as they happen, ready for grouped views, interfaces, and automations. |
| Product details on past orders | The order export shows data from when each order was created, not current product information. | Orders keep updating in Airtable as they change in Shopify, such as when they are paid, fulfilled, or refunded. |
| Tags and notes | Bulk actions add or remove tags on selected orders. | Tags and notes are columns, so you can filter, find and replace, and fill down before sending them back. |
Shopify details from the Shopify Help Center: CSV files, exporting orders, bulk actions.
Common order jobs
Step-by-step guides for the order work merchants do most often.
“We manage about 500 SKUs and being able to sync the data to airtable for analysis, automations, and reporting is invaluable.”
Order questions
More answers in the help center, or email team@airpowersync.com.
Can I create orders from Airtable?
No. AirPower only updates existing orders. To build an order in Airtable, create a draft order instead.
Which order fields can I change?
The order note and tags. Each row needs a Shopify ID so AirPower knows which order to update. The order name, totals, statuses, customer details, and line items come into Airtable for reporting, and edits to them are not sent back.
How far back can I load orders?
You choose. In Settings > Download data, set the Since date next to Orders and click Download. The default is six months back. After that, new orders and order changes arrive from Shopify on the Sync's schedule. Download past data
Can I report on UTM campaigns in Airtable?
Yes. Each order can bring in the source, referrer, and UTM source, medium, campaign, content, and term of the first and last visit that led to it. Group orders by campaign or source and add up their totals. Marketing attribution
Can I sync only some orders?
Yes, on the Plus plan. Filters decide which Shopify orders come into Airtable, for example by tag or date. For Airtable to Shopify, choose an Airtable view and only its rows are sent. Filter records
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.