Skip to content
SellSail
Guides

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

Working on a laptop

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 typePatternExample
ClothingTYPE-COLOUR-SIZETEE-BLK-M
HomewareCAT-ITEM-VARIANTKIT-KETTLE-17L
ElectronicsBRAND-MODEL-COLOURACME-X200-WHT
Dropshipping from AmazonPREFIX-ASINAMZ-B0EXAMPLE1
Several suppliersSUPPLIER-CODEACME-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.

Frequently asked questions

Is there a free SKU generator?
A spreadsheet is the simplest free SKU generator: put each part of the code in its own column and join them with a formula. This guide shows the formula.
How long should a SKU be?
Usually 8 to 20 characters. Long enough to be unique and readable, short enough to type and to fit marketplace limits.
Should SKUs be random?
No. A meaningful SKU tells you what a product is at a glance, which helps with picking, reporting and spotting mistakes.
All articles

Keep reading

Set sail with SellSail

Start your 14-day free trial. No card needed, cancel any time.