> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.syncbase.app/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# 🛒 Orders (and Line Items) synchronization : how does it work?

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.

|| With our latest update, Orders and Line Items are now separated into two linked tables. This gives you a clearer structure, better performance, and more flexibility when building views, automations, or reports.


# 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](https://help.syncbase.app/en/article/data-synced-with-syncbase-1cecyb3/)


# 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 change the historical sync date for orders and line items by updating it with a base refresh from your operations panel. 

👉 See how it works here :[ "Update the order history sync date"](https://help.syncbase.app/en/article/refresh-your-data-on-demand-t0v5yg/#:~:text=Refresh%20Orders%2C%20Line%20Items%20or%20Customers%20from%20a%20specific%20date)

# 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

|| **This feature is on our roadmap — feel free to let us know you're interested by emailing** **theau@syncbase.app****.**