Need to keep things clean in Airtable? You might want to sync only recent Orders—like the last 6 or 12 months—for performance, clarity, or Airtable record limits.

SyncBase continuously syncs new and updated orders. That means it's up to you to remove older ones you no longer need in Airtable.

Here’s how you can do that safely.

How to remove older orders from Airtable

You can delete past orders directly in Airtable—this won’t break synchronization. SyncBase won’t try to sync them again unless they’re updated on Shopify.

Option 1: Delete manually

You can go to the Orders tab and delete records one by one or in bulk.

To make things easier:

• Sort by Created at
• Select orders older than X months
• Delete

Then, go to Orders Metafields tab and delete matching records if needed.

Option 2: Use an Airtable automation

For a hands-free solution, set up an Airtable automation to regularly delete old records.

Here’s a basic example:

• Trigger: At scheduled intervals (e.g. every week)
• Action: Find records where Created at is older than your cutoff date
• Then: Delete the matching records

Repeat the same for the Orders Metafields tab if needed.

Good to know

• If an Order is updated on Shopify after it was deleted from Airtable, SyncBase will re-create it automatically. So this method only filters out stale orders, not prevents fresh Shopify updates from syncing back into Airtable.
• During onboarding, at the base generation step, you can choose how much order history you want to sync initially (e.g. all orders since 01/01/2025). After that, SyncBase will automatically sync all new orders as they come in.

Updated on: 31/07/2025