> ## 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).

# 🔗 How to pull data from a separate Airtable base into your synced base

When the data you want on Shopify lives in a **different Airtable base** than the one SyncBase synced, you can still bring it across — by matching both bases on a **unique identifier** (like a `SKU` or `HIN`) and copying the value into your synced base.

# Why a lookup field isn't enough

Airtable **Lookup** and **Linked Record** fields only work **within a single base**. If your extra data sits in a *separate* base, a lookup can't reach it.

👉 If your data is in another **table of the same base**, you don't need this — just use a lookup: [How to link tables and display data from a tab to another one](https://help.syncbase.app/en/article/how-to-link-tables-and-display-data-from-a-tab-to-another-one-ylzh7l/)

To move data **across two bases**, you need an **automation, a script, or an AI assistant** that matches records on a shared unique identifier and writes the value into your synced base.

# Before you start

__Make sure__:

* The value you want exists in **both bases** behind a **unique identifier** — the same `SKU`, `HIN`, or other ID in each. This is what links a record in one base to the right record in the other.
* You add the result to a **new column** in your synced base (to the left or right of the existing ones).

||| ⚠️ Never rename or change the type of the columns SyncBase created — the sync relies on their exact name and type. Always add your own columns alongside them. 👉 [Do's and Don'ts](https://help.syncbase.app/en/article/dos-and-donts-1tifwu4/)

# How to bring the data across

Both approaches happen **in Airtable**, not in the SyncBase app.

### Option 1 — Airtable automation or script

Build an Airtable **Automation** (or a **Script**) that, for each record, finds the matching record in the other base by the unique identifier and writes its value into your synced base.

* Trigger: a record is created or updated, or run on a schedule.
* Action: match the `SKU` / `HIN` in the source base, then update the target field in your synced base.

### Option 2 — Connect Airtable to an AI assistant

Airtable has official integrations with AI assistants like **ChatGPT** and **Claude**. Once connected, they can read your bases and set up the mapping for you — just describe it in plain language, for example: copy the `City`/`State` from the source base into the synced base, matching on the unique identifier.

👉 You can manage your Shopify data this way too: [Manage your Shopify store data directly from Claude](https://help.syncbase.app/en/article/manage-your-shopify-store-data-directly-from-claude-1kx807l/)

Once the value lands in your synced base, SyncBase pushes it to Shopify like any other synced field (for example into a **product metafield**).

# This is an advanced, custom setup

Mapping data across two separate bases is **custom Airtable work**, not a built-in SyncBase feature. If you'd rather have it done for you, our in-house Airtable experts can set it up in a **paid expert call or a custom Studio mission**.

👉 [Book a 30-minute expert call](https://help.syncbase.app/en/article/30-minute-expert-call-meedwh/)

# Need help?

Reach out via the in-app live chat and explain your use case — we'll guide you or prepare a custom setup proposal.