Formula recipe

Generate SKUs for every variant

="FB-"&RIGHT(Variant_id,6)

Missing SKUs? Build them from the product, color, size or variant ID. FlexSync writes them to Shopify.

FormulaText join
Shopify fieldSKU
Tested resultSKU FB-716807 created
4.9/5 on Shopify App Store
Built for Shopify
20 formula cells free
How it works

A clean SKU on every variant

SKUs make stock counts, supplier orders and lookups easier. Build them from data already in your Sheet.

  • Prefix plus variant ID
  • Product, color and size codes
  • Fill down for the whole catalog
Copy and paste

Ready-to-use variations

Native Google Sheets formulas. Paste one in the yellow column and fill down.

="FB-"&RIGHT(B2,6)

Prefix plus ID

Tested: created FB-716807.

=UPPER(LEFT(L2,3))&"-"&UPPER(LEFT(K2,3))&"-"&I2

Product, color, size

Readable SKUs like DAW-BLA-2XS.

=UPPER(LEFT(L2,3))&"-"&TEXT(ROW()-1,"0000")

Numbered SKUs

Sequential codes like DAW-0005.

Good to know

Tips before you start

Keep SKUs unique

Include size or variant ID so no two variants share a SKU.

Set once, then paste values

Once SKUs look right, paste them as values so they never change by accident.

Use SKUs everywhere

Once set, use SKUs as the key for VLOOKUP cost and supplier formulas.

Setup

Up and running in three steps

1

Turn on formulas

In FlexSync, open Settings, then Advance Settings, and switch on Allow Sheet Formula.

2

Paste the formula

Add it to the first row of the yellow column you want to change.

3

Fill down

Drag it down the column. FlexSync sends each result to Shopify.

Questions

Frequently asked questions

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.

Let your formulas run your store

Free plan includes 500 SKUs and 20 formula cells.