=IMPORTRANGE(supplier_url,"Sheet1!B2")
Link your supplier's Google Sheet. Their price lands on your Shopify product. No downloads, no CSV imports.
IMPORTRANGE reads a cell from any Google Sheet you can open. Put it in the Price column and FlexSync sends the supplier's price to Shopify.
Native Google Sheets formulas. Paste one in the yellow column and fill down.
=IMPORTRANGE(url,"Sheet1!B2")
Read a single supplier price.
=IMPORTRANGE(url,"Sheet1!B2")*1.4
Add 40% on top of the supplier's price.
=VLOOKUP(B2,IMPORTRANGE(url,"Sheet1!A2:B500"),2,0)
Find each product's row in the supplier sheet.
Run IMPORTRANGE once in a spare tab and click Allow access. Then delete the tab and use the formula in Price.
Fill the Price formula down again. FlexSync sends the new prices to Shopify.
Match on variant ID or SKU, not row position, so new supplier rows don't shift prices.
In FlexSync, open Settings, then Advance Settings, and switch on Allow Sheet Formula.
Add it to the first row of the yellow column you want to change.
Drag it down the column. FlexSync sends each result to Shopify.
=IF(On_hand=0,"DRAFT","ACTIVE")
Explore →
=Compare_at*0.85
Explore →
=VLOOKUP(SKU,Costs,3,0)*1.6
Explore →
=IF(Available<10,"low-stock","")
Explore →
=PROPER(raw_title)
Explore →
="FB-"&RIGHT(Variant_id,6)
Explore →
Still have questions? Our support team is available 24/7 at support@flexsync.app.
No. They only need to share their Google Sheet with you.
Before access is granted, IMPORTRANGE shows an error. FlexSync won't send an error to Shopify, so connect the sheets first.
Yes. Pull the cost and multiply by your markup in the same cell.
Free plan includes 500 SKUs and 20 formula cells.