Bulk Edit Shopify Order Transactions with Airtable
Every time money moves on a Shopify order, the change is recorded as an order transaction. That includes the original authorization, the capture or sale, any refund payments, and any failed attempts. Each transaction carries the gateway used, the amount, the currency, the status, and timestamps.
The Shopify admin surfaces transactions inside each order under the payment timeline. For finance, reconciliation against a payment processor, or dispute analysis, working through them one order at a time does not scale.
AirPower brings order transactions into Airtable as a separate table linked back to the parent order. Build reconciliation views against your processor statements, audit failed charges, or feed downstream finance reporting without exporting Shopify data each month.
Order Transactions sync from Shopify into Airtable for reporting. Changes you make in Airtable are not sent back to Shopify.
Set up Order Transactions
- Open a Shopify → Airtable sync or create a new one
- In Connections, select your Airtable base
- Go to Data & fields
- Click Order Transactions
- Select the Airtable table to sync to
- Open the Main Fields pane and map the fields you want to sync
- Click Save sync
Default mappable fields include gateway, order ID, kind (authorization, sale, capture, refund, void), status, message, amount, currency, created at, processed at, test flag, authorization, location ID, user ID, device ID, error code, and source name.
When Orders is also configured in the same sync, each order transaction row links back to its parent order row.
Load existing transaction data
To backfill historical order transactions into Airtable:
- Open the Shopify → Airtable sync
- Scroll to Settings
- Click Download Shopify data
- Find Order Transactions and click Download
There is no date picker — the download reloads transaction records for the orders AirPower has indexed.
Ongoing sync
Once the initial backfill is done, Shopify sends new order transaction events to AirPower automatically. They process on the same schedule as your other Shopify → Airtable data.