Connecting Shopify

Sync your Shopify products, orders, and customers to Airtable. This guide walks you through the complete OAuth setup for your Shopify store.

Before You Begin

• You need a Shopify store (any plan, including Shopify Lite)
• You must be the store owner or a staff member with app installation permissions
• Have your Shopify store URL ready (e.g., mystore.myshopify.com)
• Make sure you've already connected Airtable to TableSync

[Screenshot: Shopify store admin dashboard]

Step-by-Step Connection Guide

Step 1: Find Shopify in Sources

1. Log in to your TableSync Dashboard
2. Scroll down to the Sources section
3. Find the Shopify card (green icon)

[Screenshot: Dashboard Sources section with Shopify card highlighted]

Step 2: Enter Your Store URL

Unlike other integrations, Shopify requires your store URL first:

1. Click the Connect button on the Shopify card
2. A popup will ask for your Shopify store URL
3. Enter just the store name (e.g., "mystore" not the full URL)
4. Or enter the full URL: mystore.myshopify.com
5. Click Continue

[Screenshot: Store URL input popup]

Tip: Your store URL is the one ending in .myshopify.com, even if you use a custom domain for your public store.

Step 3: Log In to Shopify

1. You'll be redirected to Shopify's login page
2. Enter your Shopify email and password
3. Complete any two-factor authentication if enabled
4. If already logged in, you'll skip this step

[Screenshot: Shopify login page]

Step 4: Install the TableSync App

Shopify treats TableSync as an app that needs to be installed:

1. Review the app information page
2. See what data TableSync will access
3. Click Install app or Install unlisted app

[Screenshot: Shopify app installation confirmation screen]

Note: TableSync may show as "unlisted" because it's a private integration, not listed in the public Shopify App Store.

Step 5: Approve Permissions

Review what TableSync needs access to:

1. Read products - To sync product information
2. Read orders - To sync order data
3. Read customers - To sync customer information
4. Click Install to confirm

[Screenshot: Shopify permissions approval screen]

Important: TableSync only requests read access. We cannot modify products, process orders, or change customer data.

Step 6: Confirm Connection

1. You'll be redirected back to TableSync
2. The Shopify card will show Connected with a green indicator
3. Your store name will appear below the status

[Screenshot: Connected Shopify card showing store name]

Available Data Types

Once connected, you can sync these Shopify objects to Airtable:

Products

Note: Product variants (sizes, colors) are synced as part of the product data.

Orders

Customers

Shopify Plan Compatibility

Staff Permissions Requirements

If you're not the store owner:

Ask your store owner to grant these permissions if you need them.

Troubleshooting

"Store not found"

Possible causes:

• Typo in the store URL
• Store doesn't exist or was deleted
• Store is on a development/partner account

Solutions:

1. Double-check your store URL (use .myshopify.com domain)
2. Make sure the store is active (not frozen or paused)
3. Try accessing your Shopify admin directly to verify the URL

"You don't have permission to install apps"

Cause: Your staff account lacks app installation permissions.

Solutions:

1. Ask the store owner to install TableSync
2. Request "Apps" permissions from the store owner
3. Use the store owner's account to connect

"Connection failed after entering store URL"

Possible causes:

• Pop-up was blocked
• Browser cookies issue
• Shopify session expired

Solutions:

1. Allow pop-ups from tablesync.io
2. Try in an incognito/private browser window
3. Log out of Shopify, then try connecting again

"I can't see my orders or customers"

Possible causes:

• Your Shopify plan doesn't include those features
• You don't have staff permissions for that data
• The store is new with no orders yet

Solutions:

1. Check your Shopify plan features
2. Verify your staff permissions include order/customer access
3. Create a test order to verify data appears

"Products show as variants instead of main products"

Explanation: Shopify treats products and variants differently. TableSync syncs at the product level, with variant information included.

Solution: When mapping fields, use the parent product fields, not variant-specific ones.

Managing Your Shopify Connection

Viewing Connection Details

Your Dashboard shows:

• Connection status
• Store name
• Connection date

Disconnecting Shopify

To remove the connection:

1. Click the three-dot menu on the Shopify card
2. Select Disconnect
3. Confirm the disconnection

Note: This pauses all syncs using this store connection.

Removing from Shopify Admin

You can also uninstall from Shopify:

1. Log in to your Shopify admin
2. Go to Settings > Apps and sales channels
3. Find TableSync in the list
4. Click Uninstall

Frequently Asked Questions

Can I sync from multiple Shopify stores?

Currently, each TableSync account connects to one Shopify store. For multiple stores, use separate TableSync accounts or contact support for enterprise options.

Will syncing affect my Shopify API limits?

TableSync uses Shopify's REST API efficiently. For most stores, you won't approach API limits. High-frequency syncs on very large stores may use significant API quota.

How are refunds and order changes handled?

When an order is updated in Shopify (refund, fulfillment change), the next sync will update that record in Airtable to reflect the current state.

Can I sync order line items (individual products in an order)?

Order line items are included in the order data. During field mapping, you can choose to sync the line items as a formatted text field.

Does TableSync work with Shopify POS orders?

Yes! POS orders appear in Shopify's order system and are included in syncs.

What about draft orders?

Draft orders are separate from regular orders in Shopify. Currently, TableSync syncs completed orders. Contact support if you need draft order syncing.

Can I filter which products/orders sync?

TableSync syncs all data of the selected type. You can use Airtable views and filters to organize the synced data afterward.

Why can't I see some product fields?

Shopify has many product fields. TableSync supports the most commonly used ones. If you need a specific field, contact support to request it.