Sync Products from Airtable to Shopify with Inventory Management

This n8n workflow synchronizes products from an Airtable base to a Shopify store, focusing on one-way creation and updates. It fetches records from Airtable where the 'sync' boolean is true, matches them to existing Shopify products using the 'slug' field (Shopify's handle), and creates new products or updates existing ones with details like title, description, price, SKU, and status. Inventory management is handled by setting the stock quantity at the store's default location via Shopify's GraphQL Admin API (2025-04 version).

Key benefits include keeping Shopify in sync with Airtable as the primary data source, reducing manual data entry, and ensuring accurate inventory levels to prevent overselling. It's ideal for e-commerce teams using Airtable for product catalogs, enabling quick updates via Airtable automations that toggle the 'sync' flag on record changes.

Use cases: Small to medium online stores managing products in Airtable (e.g., digital goods, print-on-demand), inventory tracking for physical items, or migrating product data without custom coding. Setup requires configuring Airtable columns (title, description, slug, price, SKU, stock_on_hand, sync) and updating GraphQL node URLs with your Shopify store endpoint. Trigger via schedule or Airtable webhook for real-time sync.