How the SKUs are built
Each line you paste becomes one SKU. The product name and every option after it are shortened to a few characters and joined with a separator. The rules are fixed, so the same input always gives the same code:
- One word becomes its first letter followed by consonants: Black gives
BLK, Large givesLRG, Green givesGRN. - Short words are kept whole: Red stays
RED. - Several words become initials: Canvas Tote Bag gives
CTB. - Sizes and numbers are left alone:
S,XL,32and12OZstay readable. - Duplicates get a number on the end, so two rows can never share a SKU.
So "T-Shirt, Black, M" with the prefix ACME becomes ACME-TS-BLK-M. Anyone in the stockroom can read that without a lookup table, which is the whole point.
What makes a good SKU
- Order from general to specific. Product first, then colour, then size. Sorted alphabetically, the list then groups itself by product.
- Keep it short. Eight to twelve characters is ideal. A long SKU makes a wide barcode and gets misread aloud.
- Use capitals, digits and hyphens only. Spaces and slashes break in file names, URLs and marketplace imports.
- Do not start with zero. Spreadsheets strip leading zeros unless the column is formatted as text.
- Avoid look-alikes where you can. The letter O and the digit 0, and the letter I and the digit 1, cause picking mistakes. If a code is ambiguous, change one segment by hand.
- Never reuse a retired SKU. Old orders and reports still point at it.
- Leave the supplier's code out. Suppliers change. Your SKU should describe the product, not where you bought it this year.
SKU, UPC and barcode: how they fit together
| SKU | UPC or EAN | |
|---|---|---|
| Who creates it | You | Licensed from GS1 |
| Who uses it | Your team and systems | Retailers, marketplaces, Google |
| Format | Letters and digits, any length | 12 or 13 digits |
| Cost | Free | Paid |
| Can it change? | Yes, if you reorganise | No |
A product can have both. The longer comparison, including ASIN and MPN, is in the guide to UPC vs EAN vs GTIN vs SKU.
From SKU list to printed labels
Press "Make barcodes for these SKUs" and the list opens in the bulk barcode generator as Code 128, with the product name as the text line on each label. From there you can print on 30-up sheets or download a zip of images. If you only need one, the Code 128 generator has size and height controls.
Loading SKUs into your store
The CSV download has two columns, Product and SKU. Most store platforms let you paste a SKU column in a bulk editor or import it from a product CSV. On Shopify, the column in the product export is Variant SKU. There is more on how SKU and barcode fields differ on the Shopify barcode generator page.