Skip to content
Free tool - no sign-up

SKU generator: turn item names into SKUs.

Type or paste your items, one per line, with sizes or colors after a comma. The generator makes a short SKU from each name and its details, ends it with a running number or a random code, and keeps every SKU in the list different. Copy the list or download it as a CSV. It runs in your browser: nothing is uploaded.

1. Your items
Order: Name, then any details such as a size or a color, each after a comma. Paste straight from a spreadsheet or type with commas. Up to 500 lines.
6 SKUs, the longest 16 characters
2. How the SKUs are made
Optional. A code for the kind of item, such as CAB or HW. Up to 8 letters and digits.
Small words such as the, of and for are left out.
3. Your SKUs

Nothing is uploaded. The SKUs are made in this browser tab, and it keeps nothing when you close it. The CSV has a Name and a SKU column and opens in Excel, Google Sheets and Numbers.

#ItemSKU
1Birch plywood, 3/4 inBIR-PLY-34IN-001
2Birch plywood, 1/2 inBIR-PLY-12IN-002
3Edge banding, WhiteEDG-BAN-WHI-003
4Euro hinge, Soft closeEUR-HIN-SC-004
5Drawer slide, 18 inDRA-SLI-18IN-005
6Drawer slide, 22 inDRA-SLI-22IN-006

How the SKUs are made

Each line is read as a name, then any details after a comma. Birch plywood, 3/4 in becomes BIR-PLY-34IN-001:

  • Prefix (if you set one): a code for the kind of item, such as CAB for cabinet parts or HW for hardware, up to 8 letters and digits. It goes first.
  • From the name: the first 3 letters of each of the first 2 words, with small words such as the, of and for left out. A word with a digit in it, such as M8 or 2x4, is kept whole. You can change both numbers.
  • From the details: a short detail is kept whole, without its spaces and marks (XL stays XL, and 3/4 in becomes 34IN); a detail of more than one word becomes its first letters (Soft close becomes SC); one longer word is cut to its first letters (White becomes WHI). Up to 4 details are used.
  • The ending: a running number (001, 002 and so on, from the number you start at), a random code of 4 to 6 characters, or nothing.
  • Always different: if two items would get the same SKU, the second one gets 2 added on the end, the next 3, and so on.
  • Capitals only: accents are dropped and everything is put in capitals, so a SKU holds only letters, digits and the separator you pick.

What makes a good SKU

  • One for each item. No two items share a SKU. When you add an item, InventoryQuick refuses a SKU another item already has, even one in the trash.
  • Capitals count. SKUs are matched exactly, so PLY-B34 and ply-b34 are two different SKUs. Putting every SKU in capitals means the question never comes up.
  • Letters, digits and one separator. Leave out spaces, slashes and symbols. A code that starts with = or - can be taken for a formula by a spreadsheet.
  • No look-alike characters. 0 and O, or 1, I and L, are easy to misread on a label. The random codes here never use them, and InventoryQuick leaves the same ones out of the SKUs it makes.
  • Start with what the item is. SKUs that begin with the kind of item, such as BIR-PLY or EUR-HIN, sit together when a list is sorted.
  • Short enough to read. A SKU someone can read off a label and type without a mistake is worth more than one that holds every detail. The generator shows the length of the longest one.
  • Nothing that changes. Leave the price, the supplier and the shelf out of a SKU: when one of those changes, the SKU would be wrong.
  • Format the column as Text in Excel before you paste, so a SKU such as 0012 keeps its zeros.
  • Not SAMPLE-. In InventoryQuick, SKUs that start with SAMPLE- are kept for demo data, and an item with one is refused. The generator tells you if your prefix makes one.

SKU or barcode number?

A SKU is your own code, made up by you for the items you stock. A UPC or EAN is the number under a retail barcode, and those numbers are issued by GS1. This tool does not make UPC or EAN numbers.

You can still print your SKUs as labels. Copy the list here and paste it into the item label maker, which prints each SKU as a QR code or a Code 128 barcode with the item name, on Avery 5160 or 5167 sheets. To save each SKU as a barcode image instead, paste the list into the Code 128 barcode generator, which downloads an SVG or a PNG for each one.

SKUs in InventoryQuick

  • Made for you: leave the SKU blank on the web item form and one is made when you save, or type the name and press Generate next to the SKU field to see it first. It is made from the start of the name and six random characters, such as BIRCHP-7KQ2MX for Birch plywood.
  • Bring a list in: download the CSV here and open Import Items on the web. Name and SKU are names the import reads, so each column is matched to its field, and you can change a match before the import runs. CSV import is on every plan. To add quantities, locations and costs too, use the inventory spreadsheet template.
  • Scanning: scan the barcode on an item with the iPhone or Android app to open it. Scanning is on every plan.

Flat monthly plans from $19/mo, with no per-user fees. Every plan starts with a 7-day free trial, and you won't be charged for 7 days. On the web you pick a plan and enter a card.

Frequently asked questions

Is the SKU generator free?

Yes. There is no sign-up and no email is asked for. The SKUs are made in your browser, and the items you type are not sent to InventoryQuick or stored.

What is a SKU?

A SKU (stock keeping unit) is a short code you give each item you stock, so every item has one name that does not change. It is your own code: you make up your SKUs yourself, unlike the UPC or EAN number under a retail barcode, which is issued by GS1.

How do I make a SKU for an item?

Start with a few letters for what the item is, add a short code for each detail that sets it apart, such as its size or color, and end with a number. Birch plywood, 3/4 in becomes BIR-PLY-34IN-001. Use only letters, digits and one separator, and give each item a SKU no other item has.

Can two items have the same SKU?

No. Each item needs its own SKU, or you cannot tell them apart on a count or an order. When you add an item, InventoryQuick refuses a SKU another item already has, even one in the trash, and names that item. The generator makes every SKU in its list different.

Are SKUs case sensitive?

In InventoryQuick, yes. SKUs are matched exactly, so capital letters count: PLY-B34 and ply-b34 are two different SKUs. The generator puts every SKU in capitals, so a list made here never mixes the two.

Can I import the SKUs into InventoryQuick?

Yes. The CSV has a Name and a SKU column, and those are names the import reads, so when you open Import Items on the web and choose the file, each column is matched to its field. To add quantities, locations and costs as well, copy the SKUs into the free inventory spreadsheet template first. CSV import is on every plan.

More free tools: item label maker, Code 128 barcode generator, inventory spreadsheet template, inventory count sheet.