Shopware Airtable Automation for UK Merchants

Airtable is a cross between a spreadsheet and a database that lets teams structure data without programming. Connected to Shopware 6, it becomes a shared workspace for product data, campaigns and operational processes that are maintained outside the shop.

Airtable organises data in bases made up of tables, fields of different types (text, single select, attachment, linked record) and several views: grid, Kanban, calendar and form. Links between tables turn a spreadsheet into a relational database, while automations and scripts react to changes. For teams without developers, it is a quick way to map processes that would otherwise be scattered across Excel files and emails.

Shopware is the leading system for catalogue, orders and customers. A lot of what surrounds it, however, lives in other tools: content planning, supplier lists, campaign calendars, return reasons, quality checks. Airtable brings this data together where marketing, purchasing and customer service already work, and the connection to Shopware keeps both sides in sync: orders appear as rows in Airtable, and decisions made in Airtable flow back into the shop as changes.

• Preparing product data: create new products with copy, images and attributes in Airtable, approve them, then create them in Shopware via an automation.
• Planning campaigns: plan promotions, discount codes and Shopping Experiences in a calendar; start and end dates are passed to Shopware.
• Analysing orders: import orders with status, revenue and shipping method as rows, analyse them by channel or region and derive tasks from them.
• Returns and complaints: record return reasons, assign team members and write the status back to the order in Shopware.
• Suppliers and purchasing: generate purchase suggestions based on Shopware stock levels and track orders with suppliers.
• Content workflow: collect and review copy and images in Airtable, and only publish them in Shopware once approved.

Shopware has no native Airtable integration; the connection runs via the Admin API and the Airtable API. Three approaches have proven themselves:

• Integration platform: n8n, Make or Zapier offer ready-made modules for Airtable and Shopware. A workflow fetches new orders via search, writes them to Airtable as records and vice versa. Quick to set up and ideal for manageable data volumes.
• Airtable automations and scripts: Airtable can send webhooks itself when something changes, or call the Shopware API via a script, for example to set an order status.
• Custom integration: a Shopware plugin or a small service synchronises data selectively and in large volumes, with error handling and logging. This makes sense for large numbers of records or when Airtable is the leading system for product data. Find out more on our page on Shopware plugin development.

On the Shopware side, the triggers are webhooks or the Flow Builder, so that transfers are event-driven instead of polling every minute.

• Data volumes: depending on the plan, bases are limited to a few tens of thousands of records; a complete catalogue with many variants will not fit.
• API limits: the Airtable API only allows a few requests per second, so bulk syncs have to be batched.
• No transactional integrity: Airtable is not an ERP. Stock levels, prices and invoices belong in Shopware or an ERP; Airtable is the planning and working space.
• Data protection: Airtable stores customer data in the US. For UK merchants, that is an international transfer under UK GDPR, so only transfer what is necessary and put a data processing agreement in place.

• Define the leading system for each data type: Shopware for orders and stock, Airtable for planning and approvals. Use two-way sync only where it is genuinely needed.
• Unique keys: keep Shopware IDs or product numbers as a field in Airtable so that records are matched cleanly.
• Event-driven rather than scheduled: use webhooks and the Flow Builder instead of polling every minute; this protects your API limits.
• Make errors visible: log failed transfers in a separate table and send notifications.
• Keep permissions minimal: a dedicated Shopware integration with its own ACL role for Airtable, and a separate Airtable token that only covers the base concerned.

See also: automation platform, no-code automation, API automation tools and data pipeline tools. You will find all terms in the Shopware dictionary. If you would like help connecting Airtable to your Shopware shop, solution25 works with merchants across the UK.