=VLOOKUP(SKU,Costs,3,0)*1.6
Keep costs in one sheet. VLOOKUP finds each product's cost, your markup sets the price, and Shopify follows.
Your cost list can live in another tab or another file. VLOOKUP pulls the right cost for each row and your markup does the rest.
Native Google Sheets formulas. Paste one in the yellow column and fill down.
=VLOOKUP(X2,Costs!A:C,3,0)*1.6
Cost times 1.6.
=ROUND(VLOOKUP(X2,Costs!A:C,3,0)/(1-0.35),0)
Price for a 35% margin, rounded.
=VLOOKUP(B2,IMPORTRANGE(url,"Sheet1!A2:D500"),3,0)*1.6
Tested: cost 7,000 became 11,200.
Keep the last argument at 0 so VLOOKUP only returns an exact SKU match.
If a SKU isn't in the cost list, VLOOKUP returns an error and FlexSync resets that cell. Wrap it in IFERROR to fall back to the current price.
Fill the Price formula down again after updating costs.
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 →
=IMPORTRANGE(supplier_url,"Sheet1!B2")
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.
Yes. Look up by Variant ID instead. It's already in the Sheet.
Yes. Add a markup column to your cost sheet and multiply by it.
No. This formula sets the Price only.
Free plan includes 500 SKUs and 20 formula cells.