SyncBase was designed for continuous, reliable sync. On top of that, many users also rely on it for bulk operations — like imports, catalog migrations, or mass edits. This guide walks you through how to do it efficiently and safely, without running into API rate limits.

How Bulk Operations work

You will learn how to update and create in bulk from Airtable -> Shopify and from Shopify -> Airtable. Read the guideline first, then jump to the specific section.

SyncBase uses both Shopify and Airtable APIs, and each has rate limits depending on your plan.

During a bulk operation, you can easily hit these limits if you are not using the Bulk update feature or workflow. And while SyncBase has a built-in queuing system to manage traffic, too many requests too fast can lead to:

• Slower syncing.
• Delayed operations.
• Or even lost updates if limits are breached for too long.

Bulk Operations guide :

The correct workflow is your key to smooth bulk syncs. Follow these tips:

Before you start: Check your Queue status

Wait until the task queue is down to 0. Check here: SyncBase > Status > Tasks section. SyncBase processes changes one by one, and new updates land at the end of the queue — starting a refresh and bulk operations with a non-empty queue causes conflicts. Wait until it drains to zero. 👉 How the queue system works

Testing a single operation before bulking it

That's probably our best advice: before launching a bulk operations just try the operation once on a single data object. For example: creating a new product. You'll then see if everything goes as expected. If not, that will help you improve it before launching a massive operations potentially full with many errors.

Adding delays

Let's get straight to the point: Shopify API is the most restrictive.
And as it's running in credit/seconds, the main goal is to slow down a bit your bulk operations.

The Shopify API is usually the tightest bottleneck. The solution? Slow things down — just enough to stay within limits.

Here are a few tips:

• Add delays in your script. Even 2 seconds between each operation can make a big difference.
• Use automation delays. In Zapier, Make, or Airtable automations, insert a “Wait” step between tasks.

Monitoring your queue & Sync Errors tab

Monitor your SyncBase queue. SyncBase > Synchronization > Tasks section.
If you see a backlog growing too fast, slow down your inputs temporarily.

Keep an eye on the Sync Errors tab in your Airtable-synced base.
If errors start appearing, you can pause the operation and adjust your workflow according to the information in the error messages.

Use timestamp fields

Every table includes fields showing the last time a successful update was triggered (from Shopify or Airtable). If this stays empty, your update was not processed - adjust your workflow and try again.

Sizing your batches

Avoid all-at-once actions. Instead of pasting 500 records into Airtable, add them in smaller batches.
When running batch updates, use the column Airtable → Shopify last successful update as a checkpoint. Once the last record of your batch shows as updated, you can safely start the next batch.

Timing large runs at night

Schedule the heavy runs (bulk updates and mass variant creation) overnight. The queue is less contested and long-running operations finish cleanly.

Bulk Update from Airtable -> Shopify (special feature)

Need to update your Shopify data in bulk from your Airtable-synced base? SyncBase includes a Bulk update from Airtable feature available on Elite and Enterprise plans. It is the recommended option when you want to make mass edits from Airtable and push them to Shopify more safely, without dealing directly with Shopify API limitations. Check out how to do it here:

👉 How to bulk update your Shopify data from Airtable

Classic Bulk Update from Airtable -> Shopify:

This is the classic workflow for batch updates if you're not using the Bulk update from Airtable feature.

1. Wait until the task queue is down to 0. Check in the App: SyncBase > Status > Tasks section. SyncBase processes changes one by one, and new updates land at the end of the queue — starting a refresh and bulk operations with a non-empty queue causes conflicts.
2. Run your updates in smaller batches in Airtable, following the batching and timestamp-checkpoint tips above.
3. Wait for the queue to drain back to 0 before starting your next batch.
4. Check the "last successful update" columns in Airtable to see if the changes populated (or directly in Shopify).

Bulk create new products and variants in Airtable

The Bulk update feature does not create new products or variants — it only updates existing records. To create at scale, follow this pattern.

Products:

1. Wait until the task queue is down to 0. Check here: SyncBase > Status > Tasks section. SyncBase processes changes one by one, and new updates land at the end of the queue — starting a refresh and bulk operations with a non-empty queue causes conflicts.
2. In your Airtable Products table, add a new row
3. Wait for the Product ID and Handle to populate in the new row before setting any other fields. Shopify assigns the ID; if you fill fields before it's back, SyncBase can't route them correctly.
4. Once the Product ID is in, fill the remaining fields
5. Run your updates in smaller batches in Airtable, following the batching and timestamp-checkpoint tips above.
6. Wait for the queue to drain back to 0 before starting your next batch.
7. Check the "last successful update" columns in Airtable to see if the changes populated (or directly in Shopify).

If Product creation is new to you, check the entire flow here:
👉 How to create a new product from Airtable with SyncBase?

Variants:

For very large variant counts, script this against the Variants table:

1. Wait until the task queue is down to 0.
2. In your Airtable Variants table, add a new row filling the minimum required fields. Each row must include the parent Product ID and all minimum required fields of your custom setup (at least one Option value) — Shopify rejects variant creates without these.
3. Put delays to wait for the Variant IDs to populate on each new row before adding additional information or starting the next creation.
4. Wait for the queue to drain back to 0 before starting your next batch.
5. Check the "last successful update" columns in Airtable to see if the changes populated (or directly in Shopify).

If Variant creation is new to you, check the entire flow here:
👉 How to create a new variant from Airtable with SyncBase

Bulk updates from Shopify -> Airtable

To run mass operations safely in the Shopify to Airtable direction, follow these steps:

1. Wait until the task queue is down to 0.
2. Apply your bulk changes on the Shopify side.
3. In the SyncBase app, go to Operations > Refresh your base and run a base refresh to push all the updates over to Airtable in one go without hitting API limits
4. You'll receive an email once the operation has completed.
5. Normal sync resumes automatically

Need help with a large migration?

Very large catalogs (tens of thousands of variants), reference-GID/metaobject setups, and dev → live rebuilds are advanced setups. If you'd like our team to guide the workflow or run it for you, reach out via the live chat — we can advise or scope a Studio mission.

Chat with us

Updated on: 31/07/2026