Shopify-Airtable Sync Errors
A sync touches two systems with their own rules. Shopify rejects updates that miss a required field or reference a record that no longer exists. Airtable rejects writes when a column type does not match the value being saved or when the token does not have the right scope.
When AirPower hits one of these problems, it records a sync error on the affected sync card and, for issues that need your attention, pauses the sync automatically. This page covers how to find those errors, what causes them, and how to resolve and resume.
Viewing errors
When a sync has recorded errors, an alert appears in the dashboard sync card body with a View Errors button.
- Go to the dashboard
- Find the affected sync card
- Click View Errors
The error list expands below the card. Each error entry shows:
- Error message: a description of what went wrong
- Airtable Record ID: the ID of the Airtable row involved, when available
- Shopify ID: the Shopify object ID involved, when available
- Data causing error: the source data that triggered the error, when available. Shown as an expandable JSON block.
If there are more than five errors, the list paginates. Use the page controls to navigate between pages.
Auto-pause after a sync error
When AirPower hits an error that needs your attention, the sync is paused automatically. The dashboard sync card switches to a paused state and stays there until you fix the underlying issue and resume the sync manually.
Common error causes
Field type mismatch (Shopify → Airtable): an Airtable column expects a different data type than what AirPower is trying to write. For example, writing text to a number column.
Missing required Shopify field (Airtable → Shopify): a required field in Shopify (such as a product title or variant price) is blank in the Airtable row.
Invalid Shopify ID (Airtable → Shopify): the Shopify ID column in Airtable contains a value that does not match any existing Shopify record.
Airtable permission error (either direction): AirPower does not have write access to the table or column. Check that the Airtable Personal Access Token has the correct scopes.
Shopify API error (Airtable → Shopify): Shopify rejected the update. The error message usually includes the Shopify error detail.
Resolving errors
- Review the error message and the affected record ID
- Open the Airtable row identified by the Airtable Record ID
- Fix the data that caused the error: correct the field value, fill in missing fields, or update the Shopify ID column
- Run the affected Sync again after fixing the source data
Run the Sync again after fixing errors
To push corrected Airtable data to Shopify:
- Open the Airtable → Shopify Sync
- Click Sync now on the dashboard sync card
To download corrected Shopify data into Airtable:
- Open the Shopify → Airtable Sync
- Scroll to Settings
- Click Download Shopify data
- Find the relevant data type and click Download
Clearing errors
Most errors clear themselves. Once the underlying issue is fixed and the failing sync runs successfully, AirPower removes the error from the card automatically.
In rare cases an error entry can linger after the data has already been corrected. Clear it manually with the Clear errors button in Advanced settings. Clearing only dismisses the entry; it does not change any data in Shopify or Airtable.
Deleting queued tasks
If a sync has accumulated queued tasks you no longer want to run, cancel them with Delete queued tasks in Advanced settings. Tasks already in progress are not affected.
Resuming a paused sync
You can resume an auto-paused sync from either place:
From the dashboard: Click Resume in the dashboard sync card header.
From the sync editor: Open the sync and click Unpause sync in the top bar.
The sync resumes and runs according to its configured schedule.