SKU Generator
Type a product and its options to get a SKU for every variant. Or drop your Shopify product export and fill in every missing SKU at once. The file stays in your browser.
SKUs for one product
This part works for any store, not only Shopify. One line per option, like color or size, with commas between the values.
Leave empty to build it from the name.
(the first 1,000 combinations)
| Variant | SKU |
|---|---|
SKUs for your whole Shopify catalog
- In the Shopify admin, open Products and click Export.
- Choose All products and CSV for Excel, Numbers or other spreadsheet programs.
- Drop the file below. It is read in this browser tab and never uploaded.
:
Shopify wants a different SKU on every variant. These SKUs are on more than one. Change them by hand in Shopify, or tick the box above to rebuild every SKU.
- :
Every variant already has a SKU. Tick the box above if you want to replace them all with one consistent format.
New SKUs
Import the download under Products, Import, and choose to overwrite existing products. The file has only the columns Shopify needs to find each variant, plus the SKU, so nothing else changes. Shopify's preview may show status Active, your shop name as vendor and a 0.00 price; those are placeholders for the columns the file leaves out and are not applied. Keep your export as a backup and try one product first.
| Product | SKU | Variant |
|---|---|---|
How the SKUs are built
| Part | Rule | Example |
|---|---|---|
| Product code | First letter of each of the first five words, numbers kept whole | Organic Cotton Bath Towel→ OCBT |
| Option value | First three letters of a single word | White → WHIXL → XL |
| Same code twice | The second value uses its consonants, then a number | Grey → GREGreen → GRN |
| Full SKU | Prefix, product code and option codes, joined by the separator | OCBT-GRN-XL |
Two products with the same initials get a number after the code, so every product keeps its own. The rules follow Shopify's advice on SKU formats: short, letters and numbers only, a dash or underscore between the parts. Editing other columns in the same file? Read what the Shopify bulk editor and CSV import can change first. To check page titles and meta descriptions in the same export, use the length checker.
Frequently asked questions
Is my product file uploaded anywhere?
No. The generator reads the CSV in your browser and nothing is sent to a server. Close the tab and the data is gone.
How are the SKUs built?
From a product code and one short code per option value, joined by the separator you pick. The product code is the first letter of each of the first five words in the title, with numbers kept whole, so "Organic Cotton Bath Towel" becomes OCBT. A one-word option value keeps its first three letters, so Blue becomes BLU and Large becomes LAR. When two values would get the same code, like Grey and Green, the second one uses its consonants instead: GRE and GRN.
Does Shopify require SKUs?
No. Shopify treats a SKU as an optional code for tracking inventory and reporting on sales. It asks for a unique SKU on every variant only if you use the Shopify Fulfillment Network. Inventory and shipping apps usually match products by SKU though, so empty SKUs tend to become a problem the day you connect one.
Do SKUs have to be unique?
Shopify says no two variants should share a SKU, and it treats ABC123 and abc123 as different codes. The generator gives every variant its own SKU, checks new ones against the SKUs already in your file, and tells you how many existing variants share a SKU.
How long should a SKU be?
Shopify suggests keeping SKUs as short as possible, 16 characters at most, and using only letters, numbers, dashes and underscores. Spaces and symbols can break search. The generator sticks to those characters and counts the SKUs that come out longer than 16.
Will the import change anything else on my products?
The download has only the columns Shopify needs to find each variant (URL handle, Title, option names and values) and the SKU column. Shopify leaves a column alone when it is missing from the import file, so prices, descriptions and stock stay as they are. The preview Shopify shows before importing fills the missing columns with placeholders (status Active, your shop name as vendor, a 0.00 price); in my test on a real store none of them were applied and the variants kept their IDs. Import it on one product first if you want to be sure, and keep the original export as a backup.
SKUs done. Titles and descriptions next?
Norlif AI Product Description rewrites product titles, descriptions and meta descriptions across a whole catalog in one run. Every change can be reverted, and the first 100 credits are free.