SKU generator: how to create SKUs for your products (free method)
How to generate SKUs for your products: a simple naming system, a free spreadsheet formula to create SKUs in bulk, examples by product type, and mistakes to avoid.
By the SellSail team · Updated · 6 min read
Key takeaways
- Decide a pattern first, such as CATEGORY-ITEM-VARIANT, then generate SKUs from it.
- A spreadsheet formula can build hundreds of SKUs from columns in seconds.
- Keep SKUs short, unique and limited to letters, numbers and hyphens.
- Dropshippers should build the supplier's product ID, such as the ASIN, into each SKU.
A SKU generator turns a few facts about each product into a consistent, unique code. You don't need special software: decide a naming pattern, put the parts in a spreadsheet and join them with a formula. Here's how to build SKUs for hundreds of products in a few minutes.
Step 1: choose your SKU pattern
Pick the parts that identify a product in your business, most general first:
| Business type | Pattern | Example |
|---|---|---|
| Clothing | TYPE-COLOUR-SIZE | TEE-BLK-M |
| Homeware | CAT-ITEM-VARIANT | KIT-KETTLE-17L |
| Electronics | BRAND-MODEL-COLOUR | ACME-X200-WHT |
| Dropshipping from Amazon | PREFIX-ASIN | AMZ-B0EXAMPLE1 |
| Several suppliers | SUPPLIER-CODE | ACME-10432 |
If you're new to SKUs, read SKU meaning first.
Step 2: abbreviate consistently
Use short codes and write them down so everyone uses the same ones:
- Colours: BLK, WHT, RED, NVY
- Sizes: XS, S, M, L, XL
- Categories: KIT (kitchen), GAR (garden), TOY
Step 3: generate SKUs in a spreadsheet
Put each part in its own column (A = type, B = colour, C = size), then in column D:
=UPPER(A2&"-"&B2&"-"&C2)
Fill the formula down and every row gets a SKU. For dropshipping from Amazon, with the ASIN in column A:
="AMZ-"&UPPER(TRIM(A2))
Step 4: check for duplicates
Every SKU must be unique. In a spreadsheet, use conditional formatting to highlight duplicates, or count each SKU with a COUNTIF formula and filter for any count above 1.
SKU rules to follow
- Letters, numbers and hyphens only. No spaces, slashes or symbols.
- Don't start with zero: spreadsheets may drop it.
- Avoid letters that look like numbers (O and 0, I and 1) where you can.
- Never reuse a SKU for a different product, even after you stop selling the first.
- Don't change SKUs once listings and tools depend on them.
Why put the supplier ID in the SKU?
Because tools can then link a listing to its source with no extra setup. SellSail, for example, reads the ASIN from each OnBuy SKU (stripping prefixes you set, such as "AMZ-"), looks up the live Amazon UK price and sets your OnBuy price and stock.
Summary
Choose a pattern, abbreviate consistently, build SKUs with a formula, and check for duplicates. Ten minutes now saves hours of confusion as your catalogue grows.