How Bidirectional Sync Works in FlexSync

FlexSync supports bidirectional synchronization, allowing product data to be updated seamlessly between Shopify and Google Sheets. 

How Bidirectional Sync Works #

Bidirectional sync allows product updates to flow in two directions:

1. Google Sheets → Shopify
   When product data is updated in the connected spreadsheet, FlexSync automatically updates the corresponding product data in Shopify.
2. Shopify → Google Sheets
   When product data is updated directly in Shopify, the changes are automatically reflected in the connected Google Sheet.

This ensures that both platforms always contain the most up-to-date product information.

Enabling Bidirectional Sync #

To enable bidirectional synchronization, you must add the FlexSync App Script to your connected Google Spreadsheet.

Steps to Enable #

1. Open the Google Spreadsheet connected to FlexSync.
2. Copy the App Script provided by FlexSync.
3. Open Extensions → Apps Script in your Google Sheet.
4. Paste the provided script into the Apps Script editor.
5. Save and authorize the script.
6. Complete the setup process.

For detailed instructions, refer to the full setup guide.

Once the script is configured, bidirectional sync will begin operating automatically.

Supported Columns for Bidirectional Sync #

Currently, FlexSync supports 11 columns for bidirectional synchronization. Changes made to these columns will sync between Shopify and Google Sheets. The supported columns are,

• Title
• Type
• Status
• Tags
• Price
• Compare at Price
• Barcode
• Taxable
• On Hand
• Available
• SKU

If any of these fields are edited in either platform, the changes will automatically synchronize.

Identifying Supported Columns in the Spreadsheet #

FlexSync visually indicates which columns support bidirectional synchronization.

• Lavender-colored columns → Support bidirectional sync

• Gray-colored columns → Do not currently support bidirectional sync

This visual indicator helps users easily identify which fields can be safely edited for automatic synchronization.

Important Notes #

• Only the 11 supported columns currently allow bidirectional updates.
• Changes made to unsupported columns will not sync back to Shopify.

Ensure the FlexSync App Script is properly installed in your spreadsheet for bidirectional sync to function.