---
title: "Generate SKUs"
id: "1118"
type: "page"
slug: "shopify-auto-generate-skus"
published_at: "2026-11-15T03:05:31+00:00"
modified_at: "2026-11-15T03:05:31+00:00"
url: "https://flexsync.app/formulas/shopify-auto-generate-skus/"
markdown_url: "https://flexsync.app/formulas/shopify-auto-generate-skus.md"
---

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.

[Start for Free](https://apps.shopify.com/flex-stock-sync/install?utm_source=flexsync.app&utm_medium=formula-page&utm_campaign=shopify-auto-generate-skus)
[See how it works](#how)

[#](#)

Formula**Text join**

Shopify field**SKU**

Tested result**SKU 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

SKUs · FlexSync**Synced**

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

| 1 | Product | Color | Size | SKU |
| --- | --- | --- | --- | --- |
| 2 | Dawn Patrol Fullsuit | Black | 2XS | DAW-BLA-2XS |
| 3 | Dawn Patrol Fullsuit | Black | XS | DAW-BLA-XS |
| 4 | Dawn Patrol Fullsuit | Black | 3XS | DAW-BLA-3XS |

Shopify admin

### Hooded Wetsuit

SKU**FB-716807 *Created***

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.

[Read the formula guide](/docs/how-to-enable-and-use-flexsync-shopify-formula-feature/)

More recipes## More formulas that change your store

[Auto-draft sold-out products =IF(On_hand=0,"DRAFT","ACTIVE") Explore →](/formulas/shopify-auto-draft-out-of-stock/)
[Sitewide sale pricing =Compare_at*0.85 Explore →](/formulas/shopify-sale-pricing-formula/)
[Supplier price sync =IMPORTRANGE(supplier_url,"Sheet1!B2") Explore →](/formulas/shopify-supplier-price-sync/)
[Cost-plus pricing =VLOOKUP(SKU,Costs,3,0)*1.6 Explore →](/formulas/shopify-cost-plus-pricing/)
[Auto-tag low stock =IF(Available<10,"low-stock","") Explore →](/formulas/shopify-low-stock-tags/)
[Clean up product titles =PROPER(raw_title) Explore →](/formulas/shopify-clean-product-titles/)

Questions## Frequently asked questions

Still have questions? Our support team is available 24/7 at [support@flexsync.app](mailto:support@flexsync.app)
.

### Will this overwrite existing SKUs?

    Yes, for the rows you fill. Filter to rows with an empty SKU first.

### Can I use letters from the title?

    Yes. LEFT, MID and UPPER pull and format any part of the title.

### Do SKUs show on my storefront?

    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.

[Install FlexSync Free](https://apps.shopify.com/flex-stock-sync/install?utm_source=flexsync.app&utm_medium=formula-page&utm_campaign=shopify-auto-generate-skus)
[See pricing](/pricing)

×
