DataSynclySuite
← Back to All Integrations

How to Connect Shopify to Airtable

Learn how to import and sync data from Shopify into Airtable without writing code. Supports automated pagination, field auto-type inference, deduplicated upserts, and scheduled syncs.

Prerequisites

  • An active Shopify account.
  • Credentials / API Key: Admin API Access Token.
  • DataSyncly installed in your Airtable Base.

Step-by-Step Setup Guide

1. Connect & Authenticate

  1. Open the DataSyncly extension in your Airtable Base.
  2. Search for Shopify and select your preset.
  3. Provide your Admin API Access Token and click Test Connection.

2. Field Auto-Type Inference

  • DataSyncly inspects incoming sample records and automatically detects Airtable field types (Dates, Numbers, URLs, Attachments, Checkboxes).
  • Adjust or confirm mapped columns.

3. Pagination & Upsert Configuration

  • Pagination: Handled automatically via cursor.
  • Write Mode: Choose Upsert (Update & Insert).
  • Unique Key: Set to id to prevent duplicate entries and keep records updated.

4. Run & Schedule

  • Click Run Sync to import records.
  • Optionally toggle Automated Background Sync (e.g. Every 15 mins) or copy the unique Webhook URL.