Manually Download Shopify Data to Airtable
Shopify → Airtable Syncs stay in step with Shopify by listening for live changes. New events update Airtable as they happen, but older records that existed before the Sync was set up, or before you mapped a new field, do not flow in on their own.
The Download Shopify data section in the sync editor triggers a full, on-demand download of existing Shopify data into Airtable. Run it after first setup to backfill history, after changing field mappings to repopulate columns, to fix data errors, or to recover after a Sync was paused.
Navigate to Download Shopify data
- Open a Shopify → Airtable sync
- Scroll to Settings
- Click Download Shopify data
The section shows every supported Shopify download AirPower can run, regardless of which data types you have configured in Data & fields. A download only populates Airtable for data types that have an Airtable table and field mappings, so set those up first if you want the records to land.
If the sync has not been saved yet, the rows are visible but the Download buttons are disabled. The section shows the message “Save this sync first, then you can queue Shopify downloads.” Save the sync, then return to queue downloads.
This section appears only on Shopify → Airtable Syncs. Use Sync now or a schedule to run an Airtable → Shopify Sync.
Available Shopify downloads
Each row queues a one-time download from Shopify for that data type.
Products Downloads product data. Variants, images, and locations are refreshed as part of product processing.
Collections Downloads both custom (manual) and smart collections.
Orders Includes an Orders since date picker. Set the date to control how far back to load order history. The default is six months.
Companies Downloads Shopify B2B company records.
Company Locations Downloads Shopify B2B company location records.
Refunds Downloads refund records. Includes a Refunds since date picker to limit how far back to load.
Order Transactions Downloads payment and refund transaction records.
Draft Orders Downloads draft order records.
Metaobjects Downloads metaobject records.
Customers Downloads customer profile records.
Blog posts Downloads blog channels and individual blog posts.
Pages Downloads static Shopify page records.
Translations Downloads translation data for configured objects.
Payouts Downloads Shopify Payments payout records. Balance transactions are loaded as part of payout processing.
Market and B2B prices Downloads international market prices and B2B catalog prices.
Data types loaded alongside another download
Some data types do not have a Download row of their own because they load as part of another data type’s download:
- Variants load with Products
- Images load with Products
- Locations load with Products
- Order Line Items load with Orders
- Refund Line Items load with Refunds
- Balance Transactions load with Payouts
Data types pushed by Shopify automatically
A few data types do not need a manual download at all because Shopify pushes them to AirPower as events happen:
- Inventory updates flow in whenever stock changes in Shopify. Configured within the Variants data type.
- Fulfillments and Fulfillment Line Items flow in whenever Shopify sends a fulfillment event.