="FB-"&RIGHT(Variant_id,6)
Missing SKUs? Build them from the product, color, size or variant ID. FlexSync writes them to Shopify.
SKUs make stock counts, supplier orders and lookups easier. Build them from data already in your Sheet.
Native Google Sheets formulas. Paste one in the yellow column and fill down.
="FB-"&RIGHT(B2,6)
Tested: created FB-716807.
=UPPER(LEFT(L2,3))&"-"&UPPER(LEFT(K2,3))&"-"&I2
Readable SKUs like DAW-BLA-2XS.
=UPPER(LEFT(L2,3))&"-"&TEXT(ROW()-1,"0000")
Sequential codes like DAW-0005.
Include size or variant ID so no two variants share a SKU.
Once SKUs look right, paste them as values so they never change by accident.
Once set, use SKUs as the key for VLOOKUP cost and supplier formulas.
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 →
=PROPER(raw_title)
Explore →
Still have questions? Our support team is available 24/7 at support@flexsync.app.
Yes, for the rows you fill. Filter to rows with an empty SKU first.
Yes. LEFT, MID and UPPER pull and format any part of the title.
Only if your theme displays them. They always show in Shopify Admin.
Free plan includes 500 SKUs and 20 formula cells.