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

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

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

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

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.

Updated on: 29/06/2026