You can synchronize your Shopify Orders with Airtable thanks to SyncBase. This topic explains how the new Orders structure works and what data is available in your base.

Overview

• Orders data can be found in the Orders table.
• Line items data can be found in the new Line Items table.
• Orders metafields data can be found in the Orders metafields table.

New structure

• Each record in the Orders table represents a single Shopify Order.
• Each record in the Line Items table represents a single product purchased within an order.
• Both tables are connected through a linked record field.

This means you can:

• Open an Order and instantly see all related Line Items.
• Open a Line Item and see which Order it belongs to.
• Build advanced views or rollups (total quantities, revenue per order, etc.).

Data you can find

SyncBase supports syncing key order information across both tables.

In the Orders table

You will find global order information such as:

• Order ID
• Order Number
• Created At
• Order Status (Fulfillment, Payment, etc.)
• Customer data: ID, Email, Phone
• Shipping data: Name & Address
• Tags
• Note
• Sales channel
• Currency
• … and more

In the Line Items table

You will find product-level information such as:

• Line Item ID
• Line Item Name
• Product ID
• Variant ID
• SKU
• Vendor
• Quantity
• Price
• Linked Order (linked record)

👉 See the full list of fields SyncBase can sync

Orders history

During the Base Generation step, SyncBase automatically syncs your orders from the past 3 months.

If you are on a Business, Elite, or Enterprise plan, you can contact us via live chat to request a refresh from a date older than 3 months.

New order placed in Shopify

When a new order is placed in your Shopify store, it will be synced to Airtable within seconds.

• A new record will appear in the Orders table.
• Related records will automatically appear in the Line Items table.
• Both will be linked together instantly.

For existing users: how the migration works

If you were using the previous Orders structure (where Orders and Line Items were combined in a single table), here is what changes:

• A new Line Items table will automatically appear in your base.
• Line item-related fields inside the Orders table will stop being synchronized.
• Line item data will now be synced exclusively inside the Line Items table.

Your historical data remains safe. The new structure simply separates order-level data from product-level data for better clarity and performance.

If you have existing views, formulas, or automations using line item fields in the Orders table, we recommend updating them to use the new Line Items table instead.

Creating a new order from Airtable

Updated on: 08/03/2026