GALAXY OF TOOLS

SHIP SECTOR

SKU Generator – Build Consistent SKUs for Every Variant

Turn products, categories, sizes and colours into consistent SKU codes — bulk CSV, Excel formula, barcodes.

Tokens in braces; anything else (dashes, letters) is copied as typed.
Add =CODE to fix a code (Bags=BAG); otherwise one is made from the name.
Every product gets every combination. Leave empty for products without variants.
Options

36 SKUs from 3 products × 3 colour × 4 size · longest 14 characters · no problems found

#SKUProductCategoryColourSizeBarcode
1APP-TEE-BLK-SClassic Crew T-ShirtApparelBlackS
2APP-TEE-BLK-MClassic Crew T-ShirtApparelBlackM
3APP-TEE-BLK-LClassic Crew T-ShirtApparelBlackL
4APP-TEE-BLK-XLClassic Crew T-ShirtApparelBlackXL
5APP-TEE-WHT-SClassic Crew T-ShirtApparelWhiteS
6APP-TEE-WHT-MClassic Crew T-ShirtApparelWhiteM
7APP-TEE-WHT-LClassic Crew T-ShirtApparelWhiteL
8APP-TEE-WHT-XLClassic Crew T-ShirtApparelWhiteXL
9APP-TEE-NVY-SClassic Crew T-ShirtApparelNavyS
10APP-TEE-NVY-MClassic Crew T-ShirtApparelNavyM
11APP-TEE-NVY-LClassic Crew T-ShirtApparelNavyL
12APP-TEE-NVY-XLClassic Crew T-ShirtApparelNavyXL
13APP-SFJ-BLK-SSlim Fit JeansApparelBlackS
14APP-SFJ-BLK-MSlim Fit JeansApparelBlackM
15APP-SFJ-BLK-LSlim Fit JeansApparelBlackL
16APP-SFJ-BLK-XLSlim Fit JeansApparelBlackXL
17APP-SFJ-WHT-SSlim Fit JeansApparelWhiteS
18APP-SFJ-WHT-MSlim Fit JeansApparelWhiteM
19APP-SFJ-WHT-LSlim Fit JeansApparelWhiteL
20APP-SFJ-WHT-XLSlim Fit JeansApparelWhiteXL
21APP-SFJ-NVY-SSlim Fit JeansApparelNavyS
22APP-SFJ-NVY-MSlim Fit JeansApparelNavyM
23APP-SFJ-NVY-LSlim Fit JeansApparelNavyL
24APP-SFJ-NVY-XLSlim Fit JeansApparelNavyXL
25BAG-CTB-BLK-SCanvas Tote BagBagsBlackS
26BAG-CTB-BLK-MCanvas Tote BagBagsBlackM
27BAG-CTB-BLK-LCanvas Tote BagBagsBlackL
28BAG-CTB-BLK-XLCanvas Tote BagBagsBlackXL
29BAG-CTB-WHT-SCanvas Tote BagBagsWhiteS
30BAG-CTB-WHT-MCanvas Tote BagBagsWhiteM
31BAG-CTB-WHT-LCanvas Tote BagBagsWhiteL
32BAG-CTB-WHT-XLCanvas Tote BagBagsWhiteXL
33BAG-CTB-NVY-SCanvas Tote BagBagsNavyS
34BAG-CTB-NVY-MCanvas Tote BagBagsNavyM
35BAG-CTB-NVY-LCanvas Tote BagBagsNavyL
36BAG-CTB-NVY-XLCanvas Tote BagBagsNavyXL
Spreadsheet formula (Excel / Google Sheets)

Put product names in column A, categories in B and attribute values in C, D…, then paste into row 2 and fill down. It uses plain first letters, so it is simpler than the codes above.

=UPPER(LEFT(SUBSTITUTE(B2," ",""),3)&"-"&LEFT(SUBSTITUTE(A2," ",""),3)&"-"&LEFT(SUBSTITUTE(C2," ",""),3)&"-"&LEFT(SUBSTITUTE(D2," ",""),3))

SKUs are your own internal codes. To sell in shops or on marketplaces that require GTIN, UPC or EAN barcodes, license numbers from GS1 — a SKU is not one.

Runs entirely in your browser. Nothing you enter or upload is sent to a server.

A free SKU generator for products and variants

A good SKU (stock keeping unit) tells you what an item is at a glance — APP-TEE-BLK-M is the black, medium T-shirt in apparel — and stays unique across every variant. This SKU generator builds those codes for you from a pattern you control: list your products and categories, add attributes such as colour and size, choose the order of the parts, and it creates every combination, flags duplicates and problem characters, and exports a bulk CSV.

It suits new shops setting up a catalogue, sellers moving to a new platform and anyone cleaning up inconsistent codes. Codes can be fixed by hand (Bags=BAG) or made automatically from the names. A matching spreadsheet formula and a Code 128 barcode for any SKU are one click away.

How to use the SKU Generator

  1. Edit the SKU pattern. Tap tokens such as {CAT}, {NAME}, {COLOUR}, {SIZE}, {BRAND} or {SEQ} to insert them; type dashes or fixed letters between them.
  2. List products one per line as “product name, category”. Add =CODE after a name to fix its code.
  3. List attributes one per line as “Size: S, M, L”. Every product gets every combination of values.
  4. Set the options: automatic code length, sequence start and digits, upper case and the length warning.
  5. Check the table for flagged rows, then download the CSV, copy the SKUs, or show a barcode for any row.

SKU Generator features

Pattern builder

Any order of brand, category, product, attribute and sequence parts, with your own separators.

Automatic or fixed codes

Codes from initials and consonants (Navy → NVY, Slim Fit Jeans → SFJ) or plain first letters, or your own codes.

Bulk variants

Products × colours × sizes (and any other attribute) in one go, up to 5,000 SKUs.

Built-in checks

Flags duplicates, codes over your length limit, spaces or symbols and leading zeros.

CSV, Excel formula and barcodes

A spreadsheet-ready CSV with variant titles, an equivalent Excel / Google Sheets formula, and Code 128 barcodes as SVG or PNG.

SKU naming rules that save trouble later

  • Start with the broadest attribute (category or brand) and end with the most specific (size), so codes sort in a useful order.
  • Use only letters, numbers and dashes. Spaces, slashes and symbols break some barcode fonts, URLs and import tools.
  • Do not start a SKU with 0: spreadsheets often drop leading zeros and turn 0012 into 12.
  • Avoid letters that look like digits (O and 0, I and 1) in parts people read aloud or type by hand.
  • Keep codes short — 8 to 16 characters is common — and never reuse a retired SKU for a different product.
  • Do not put price, supplier or other changing facts in a SKU; keep those in your catalogue.

SKU, UPC, EAN and GTIN

The barcode button draws a Code 128 barcode, which encodes letters and digits and suits shelf labels and bin tags inside your business. For retail barcodes you need GS1 numbers; you can draw those with the barcode generator. Plan reorders with the reorder point calculator and edit the exported list in the CSV editor.

CodeWho sets itUsed for
SKUYouYour own stock, warehouse and listings; any format
GTIN (UPC-A, EAN-13)Licensed from GS1Retail scanning and marketplaces that require a global product ID
ASIN, FSN and similarThe marketplaceEach marketplace’s own catalogue

How automatic codes are made

Values that are already short (S, XL, 32) are kept. A single word becomes its first letter plus the following consonants (Navy → NVY, Apparel → APP). Several words become their initials, topped up from the last word if needed (Slim Fit Jeans → SFJ). Fix any code you do not like with Name=CODE. Barcodes are drawn with JsBarcode 3.11.6 (MIT licence), loaded only when you press a barcode button.

SKU Generator FAQ

How do I create SKU numbers?

Decide which facts identify a variant — usually category, product, colour and size — give each value a short code, and join them in a fixed order with dashes. This SKU generator does that for every combination and checks the result for duplicates.

Is this SKU generator free?

Yes. It runs in your browser with no sign-up and no limit beyond 5,000 SKUs per run, and your product list is not uploaded anywhere.

Can I make SKUs in Excel?

Yes. Open “Spreadsheet formula” for a formula matching your pattern that you can fill down in Excel or Google Sheets, or download the CSV from this tool and open it in Excel.

Can I generate a barcode for a SKU?

Press Barcode on any row to draw a Code 128 barcode and download it as SVG or PNG. It is fine for internal labels; retail barcodes need a GS1 GTIN.

Should SKUs contain numbers only?

No. Readable letter codes are easier for people to pick and check. Add {SEQ} if you also want a running number.

What if two products get the same SKU?

The row is flagged as a duplicate. Add a fixed code (Name=CODE), raise the automatic code length, or add {SEQ} to the pattern.

You might also need