Skip to content

Can I use analytics and ad cookies? Google Analytics and Microsoft Clarity show me how people use this site, and Reddit measures my Reddit ads. You can change this any time under Cookie settings at the bottom of the page. Privacy policy

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.

Option values

(the first 1,000 combinations)

Variant SKU

SKUs for your whole Shopify catalog

  1. In the Shopify admin, open Products and click Export.
  2. Choose All products and CSV for Excel, Numbers or other spreadsheet programs.
  3. Drop the file below. It is read in this browser tab and never uploaded.

:

new SKUs
SKUs kept as they are
variants sharing a SKU

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 codeFirst letter of each of the first five words, numbers kept wholeOrganic Cotton Bath Towel→ OCBT
Option valueFirst three letters of a single wordWhite → WHIXL → XL
Same code twiceThe second value uses its consonants, then a numberGrey → GREGreen → GRN
Full SKUPrefix, product code and option codes, joined by the separatorOCBT-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.