The Formula Feature allows you to use Google Sheets formulas to dynamically update product data (such as SKU, price, or stock) inside the Flexsync sheet. Any formula-based changes are automatically reflected in the Google Sheet and synced to your store.

This feature is ideal for users who want to manage product data from multiple sheets or external vendor sources without manual updates.

How to Navigate This Feature:  #

Go toFlexSync: Stock Sync for Sheet→ Check the box Allow SheetFormula.

Enable this to sync formula-based changes to Shopify every 5 minutes. After updating any formula data, wait up to 5 minutes for it to sync. 

How the Formula Feature Works #

You can use any kind of valid Google Sheets formula, based on your need, simple, complex, or advanced. The Formula Feature does not limit you to specific formulas. If the formula works in Google Sheets, it will work with this feature.

When the Formula Feature is enabled:

• You can add formulas to your Google Sheet
• Formulas can pull or calculate data from other tabs or external sheets
• The connected Google Sheet tab updates automatically based on the formula results
• Flexsync syncs the updated data to your store accordingly.

No manual copy-paste is required.

Example 1: Update Sale Price Using Another Sheet Tab (Same Google Sheet) #

Scenario:
You want to update the Compare at Price in the Products tab using data from another tab within the same Google Sheet. This allows you to bulk update prices easily without directly syncing to your store instantly.

• Plugin connected tab: Products
• Source tab: offer_time_price
• Column to update: Compare at price

How It Works (Simple):

1. Update or manage offer prices inside the offer_time_price tab
2. Use a simple formula to pull the value into the Products tab
3. Drag or scroll to apply the formula to multiple rows (bulk update)
4. Prices update to your store

Simple Formula Example:

=offer_time_price!C2

👉 Just drag down or scroll with your mouse to apply this formula to multiple rows.

Example 2: Vendor Price & Stock Update (External Sheet)

Scenario:
Your vendor maintains price and stock data in a separate Google Sheet. You want those updates to automatically reflect in your store while still keeping control before syncing to your Shopify store.

Sheet Structure:

• Vendor Sheet tab: VendorPrice+Stock
• Local intermediate tab: Price+stock_update_from_vendor
• Flexsync connected tab: Products

Step 1: Connect Vendor Sheet to Local Tab. Use the following formula inside the Price+stock_update_from_vendor tab:

=IMPORTRANGE(“Google Sheet URL”, “VendorPrice+Stock!A:B”)

 On first use, Google Sheets will ask for permission. Click Allow access.

Step 2: Connect Vendor Data to Flexsync. Inside the Products tab, pull the required value using:

=’Price+stock_update_from_vendor’!A2

How This Works

Vendor sheet → intermediate tab → Flexsync flow

• Flexsync plugin syncs the updated data to your Shopify store.
• Vendors update the price or stock in their sheet.
• Price or stock update from the vendor updates automatically via a formula.
• Flexsync updates using the linked formula.

Important Notes #

• Formula updates appear instantly in Google Sheets.
• Shopify updates every 5 minutes, sync schedule.
• Complex and advanced formulas are fully supported.
• All formulas shown in this documentation were possible use cases. FlexSync is not limited to specific formulas. It supports all native Google Sheets formulas.

Common Issues & Tips #

• Data not updating? Ensure the Formula Feature is enabled.
• IMPORTRANGE not working? Check access permissions.
• The Shopify store has not been updated yet. Wait for the next scheduled sync.