=PROPER(raw_title)
Supplier titles in all caps or all lowercase? PROPER fixes the casing and FlexSync sends clean titles to Shopify.
Keep the raw title in its own column or the supplier's sheet. PROPER, TRIM and SUBSTITUTE turn it into a clean title.
Native Google Sheets formulas. Paste one in the yellow column and fill down.
=PROPER(AA2)
Capitalize every word.
=TRIM(PROPER(AA2))
Removes double spaces from supplier data.
=SUBSTITUTE(PROPER(AA2)," With "," with ")
Title Case without the awkward With.
A title can't reference itself. Point PROPER at a raw title column or a supplier sheet.
We tested =PROPER(VLOOKUP(id,IMPORTRANGE(url,range),4,0)) and the title updated in Shopify.
PROPER changes iPhone to Iphone. Use SUBSTITUTE for brand names.
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 →
=VLOOKUP(SKU,Costs,3,0)*1.6
Explore →
=IF(Available<10,"low-stock","")
Explore →
="FB-"&RIGHT(Variant_id,6)
Explore →
Still have questions? Our support team is available 24/7 at support@flexsync.app.
No. Shopify keeps the existing handle when the title changes.
Yes. Join text with &, for example =PROPER(AA2)&" | Brand".
In a column you add to your Sheet, or in your supplier's sheet via IMPORTRANGE.
Free plan includes 500 SKUs and 20 formula cells.