๐๏ธ Products and Variants synchronization : how does it work?
You can synchronize your Products and Variants with Airtable thanks to SyncBase. This topic explains how it works.
Overview
- Products data can be found in the
Products
tab. - Products metafields data can be found in the
Products Metafields
tab. - Variant data can be found in the
Variant
tab. - Variant metafields data can be found in the
Variant Metafields
tab.
How Shopify structures Products and Variants
Each product always has at least one variant in Shopify โ even if itโs not visible in the admin. When thereโs only one variant, Shopify creates a Default variant behind the scenes. Youโll see it in your synced Airtable base.
Products and Variants data you can sync
SyncBase supports syncing key product and variant information, including:
Product
- Product ID
- Handle
- Title
- Description
- Vendor
- Status
- Tags
- Images
- SEO meta-title and meta-description
- ... and more!
Variant
- Variant ID
- Product ID
- Item ID
- Price
- SKU
- Barcode
- Country of Origin
- Weight
- Featured image
- Inventory
- ... and more!
๐ See the full list of fields SyncBase can sync
Creating a new product from Airtable
Yes, you can create a new product directly from Airtable โ in just one click!
๐ Follow this step-by-step guide to create a product from Airtable
Creating a new variant from Airtable
Creating a new product or a new variant from Shopify
Any new Product or Variant created from Shopify will appear in your Airtable base within seconds โ no action needed.
Deleting Products and/or Variants from Airtable
By default, SyncBase does not allow deletions from Airtable. This is to protect your product catalog from accidental bulk deletion in Shopify.
๐ Learn how to safely delete products with this tutorial
Good to know
- Handles must be unique. If there are duplicates, Shopify will reject the update. See how to find and fix duplicate handles.
- Country of Origin code values can be misleading. Check Shopifyโs country code list
- Descriptions must be in HTML. Want to write in rich text? [Follow this guide
](https://help.syncbase.app/en/article/how-to-convert-rich-text-into-html-in-airtable-for-products-descriptions-toag18/)
Updated on: 24/06/2025
Thank you!