SKU generator
SKU generator
Paste your products, or build the variants from a list of options. Pick the attributes, the separator and how many letters each gets, and every row gets a short, readable SKU that no other row shares. Copy them or download a CSV. It all runs in your browser, with no sign-up.
Your products
Paste straight from a spreadsheet or a product export, or type commas. Columns you leave out of the SKU, like price, come along to the download.
No list yet? Build the variants here
Every combination becomes a row. That is 3 × 4 = 12 here.
Your pattern
Segments, in order
Your own abbreviations
SKUs you already use
Pattern
Result
How to generate SKUs for a product list
- Paste your products. One row per product or variant, with a header row. From Shopify, go to Products, then Export, and paste the CSV. Every variant row there has a Handle, so the generator builds the product part from Handle and the rest from the option values. No list yet? Open "Build the variants here", type the product and its options, and it writes every combination for you.
- Set the pattern. Tick the columns that belong in the SKU and put them in order with the arrows. Choose the separator, the letters per segment, and whether you want a fixed prefix or a running number such as 001.
- Fix what it flags. The notes above the table name any code that stands for two different words, any repeated row, any code over Amazon's 40-character limit, and any column with gaps. Add your own abbreviation under "Your own abbreviations" to settle a clash.
- Copy or download. "Copy the SKUs" puts one code per line on your clipboard. The CSV keeps every column you pasted, with the SKU first, so you can import it back.
A worked example
The sample is eleven rows of made-up apparel and drinkware, with columns Product, Color, Size
and Price. The generator picks Product, Color and Size, in that order, and leaves Price out of
the code. With a dash and three letters per segment, the black small crew tee becomes
CTE-BLK-S. Crew Tee has two words, so it takes the first letter of Crew and fills
the rest from Tee. Black is a standard color code, BLK, and Small is a standard size code, S.
The navy blue tee comes out as CTE-NBL-M, and the 20 oz tumbler as
TTM-SST-20OZ, because a measure is kept whole. The coffee mug is in the list
twice with the same color and size, so the second one gets CMG-WHT-12OZ-02 and
a note that it repeats the row above. Every code is unique, and the longest is 15 characters.
If you would rather navy read as NVY, add Navy Blue = NVY to your own
abbreviations and the code becomes CTE-NVY-M.
How each segment is built
Each ticked column gives one segment, in the order you set. A value goes through these rules in turn, and the first one that applies wins:
- Your own abbreviation, if you wrote one for that exact value.
- A standard size code (Small → S, Extra Large → XL, One Size → OS) or a common color code (Black → BLK, White → WHT, Grey → GRY), if that option is on.
- A number with a unit stays whole: 12 oz → 12OZ, 1.5L → 1P5L.
- A short word that fits the segment stays whole: Mat → MAT.
- A longer word keeps its first letter, then its consonants, then other letters until the segment is full: Tumbler → TMB, Hoodie → HOD.
- Several words give the first letter of each but the last, and the last word fills the rest: Coffee Mug → CMG.
Accents and symbols are dropped, and words like "the" and "and" are skipped. When two rows end up with the same code, the later one gets a numeric suffix, -02, then -03. The same happens when a code is already in the list of SKUs you use.
SKU naming rules worth keeping
A SKU is read by people far more often than by machines: on a pick list, on a shelf label, over the phone with a 3PL. That is why a short code with a fixed shape beats a long one.
- General to specific. Product first, then the attributes that split it. Sorted SKUs then group each product's variants together.
- Same shape every time. The same segments in the same order, each the same length. Anyone can then read a code they have never seen.
- Letters, numbers and one separator. No spaces, slashes or symbols. Some channels and barcode fonts reject them.
- No leading zero. A spreadsheet that reads 0123 as a number saves it as 123.
- Nothing that changes. Price, supplier, warehouse and bin change. A SKU should not have to.
- Never reuse one. Sales history, returns and old listings still point at a retired SKU. Give a new product a new code.
The hard part is not the first list. It is keeping one SKU per product when the same item is listed on several channels, sometimes under someone else's code. There is more on that in SKU rationalization starts with the duplicates, and on how sku.io keeps one product record behind every listing on the product information management page.
What it leaves out
It builds codes; it does not create products or change anything in your store. It does not make barcodes or UPCs, which come from GS1. Any number of columns can go into a SKU, but past four or five the codes get long. A lone product name column is split into up to four words. The table shows the first 1,000 rows, and the CSV has them all.
Questions people ask
What is a SKU code?
A SKU (stock keeping unit) is the code a business gives each product it sells, down to the variant. A black medium tee and a black large tee are two SKUs. You make SKUs up yourself, so they can be read by people: CTE-BLK-M says crew tee, black, medium.
How do I create SKU numbers for my products?
Pick the attributes that tell your products apart, usually the product, then color, then size. Give each one a short code and join them with a dash. Then check that no two products got the same code. This generator does all three steps for a whole list at once.
What is a good SKU naming convention?
Go from general to specific, keep every segment the same length, use only letters, numbers and one separator, and never start with a zero. Leave out anything that changes, such as price, supplier or bin location, and never give a retired SKU to a new product.
Is a SKU the same as a UPC or a serial number?
No. A UPC is a barcode number issued through GS1, and every seller of that product uses the same one. A SKU is your own code, and two stores can give the same product different SKUs. A serial number identifies a single unit, while a SKU covers every unit of that variant.
Can I use these SKUs in Shopify, Amazon or a spreadsheet?
Yes. Shopify reads them from the Variant SKU column of its product import. Amazon caps a seller SKU at 40 characters, and the generator warns you when a code goes past that. In Excel or Google Sheets, avoid codes that start with 0, because a sheet that reads them as numbers drops the zero.
Is my product list uploaded anywhere?
No. The codes are built in your browser and the CSV download is made there too. The tool is excluded from the site's session recording, so what you paste is not in it.
Cleaning up SKUs across several channels?
Bring a product export to a call. I'll show you how sku.io keeps one SKU per product across every channel you sell on, and maps the listings that use a different one.
Book a DemoFounder-led demo · 2-day onboarding · no onboarding fees