Etsy SKU Generator

Free tool

Build your SKU from short codes.

Product
e.g. CNDL for candles
Attributes
Format

Preview

TS-NAV-S

8 characters · Navy Blue, S

9 SKUs

Unique and within Etsy's tips.

ColorSizeSKUCheck
Navy BlueSTS-NAV-SFits Etsy's tips
Navy BlueMTS-NAV-MFits Etsy's tips
Navy BlueLTS-NAV-LFits Etsy's tips
SageSTS-SAG-SFits Etsy's tips
SageMTS-SAG-MFits Etsy's tips
SageLTS-SAG-LFits Etsy's tips
SandSTS-SAN-SFits Etsy's tips
SandMTS-SAN-MFits Etsy's tips
SandLTS-SAN-LFits Etsy's tips

SKUs are made on this page and never leave your browser. Checks follow Etsy's SKU tips. Etsy's help page doesn't state a maximum length. Etsy's guide to SKUs

What is a SKU on Etsy?

A SKU, short for stock keeping unit, is a code you give each item you sell so you can track your inventory. On Etsy it's an optional field on every listing, and on every variation if you turn it on. Etsy lets you use numbers, letters or both, in whatever system helps you organize.

A SKU is your own code, not Etsy's. Etsy gives each listing its own listing ID. The SKU is the name you choose for the product, so the same item can carry the same SKU on Etsy, your own website and your stock shelf.

Once you add SKUs, Etsy uses them in several places:

  • Listings. Search by SKU in the Listings section of Shop Manager, and view or edit SKUs with Quick edit.
  • Orders. Search your orders by SKU, and find SKUs in the sold orders spreadsheet you can download.
  • Listing download. The CSV of your listings includes each SKU.
  • EU shipping labels. For labels bought on Etsy for orders to the EU, Etsy submits your listing SKU as a required product identifier. Without a SKU, it uses your listing ID.

Do you need SKUs on Etsy?

Etsy doesn't require them. A shop with a handful of one-of-a-kind pieces can do fine without. SKUs start to pay off when:

  • Your listings have variations. A mug in 4 colors and 3 sizes is 12 different things to stock. A SKU per version tells you exactly which one sold.
  • You sell in more than one place. Etsy suggests SKUs for tracking inventory across channels, like Etsy and your own website.
  • Someone else packs orders. A code on the shelf that matches the order is faster than reading a listing title.
  • You ship to the EU. Your SKU becomes the product identifier on Etsy shipping labels, so it should name the exact item or variation.

How to create a SKU system

  1. Start with a product code. Two to four letters for the product type: CNDL for candles, MUG for mugs.
  2. Add one code per attribute, always in the same order. Color then size, for example. A fixed order lets you read any SKU at a glance.
  3. Keep each code short and fixed. Navy Blue is always NAV, in every product.
  4. Add a running number if you need one. It keeps SKUs unique when two products would otherwise share a code.
  5. Never reuse a SKU. A retired product keeps its code, so old orders still make sense.
  6. Keep the list in a spreadsheet. Download the CSV from the generator and add to it as you launch products.

The generator above follows this system. With 3 colors and 3 sizes, it makes 9 SKUs, one per combination:

ColorSizeSKU
Navy BlueSTS-NAV-S
Navy BlueMTS-NAV-M
Navy BlueLTS-NAV-L
SageSTS-SAG-S
SageMTS-SAG-M

With a SKU for each version, you can price each one properly. The craft pricing calculator turns its costs into an Etsy price, and the Etsy fee calculator shows the profit on a price you already have.

Etsy SKU rules

Etsy's help pages give tips more than hard rules. Here is what Etsy says and how the generator checks it.

RuleWhat Etsy saysWhat the generator does
CharactersNumbers, letters or both, whatever helps you organizeAllows letters and numbers, with a hyphen or underscore between parts
Length4 to 8 characters for most inventoryFlags SKUs outside 4 to 8. Etsy's help page states no maximum
O and IAvoid them. They're easy to mistake for 0 and 1Flags SKUs with an O or I
SymbolsAvoid symbols like commas or slashes. They may confuse programs like ExcelFlags any symbol other than a hyphen or underscore
UniqueLetters help you avoid using the same SKU twiceFlags every duplicate, ignoring case
VariationsUnique SKUs for up to 400 option combinations per listingStops at 400 combinations

Tips are not errors. Etsy recommends 4 to 8 characters for most inventory, and some sellers choose a longer code they can read at a glance. Duplicates are the one thing to fix, because two items with one SKU defeat the point of having SKUs.

Etsy SKU examples for common shops

Put the attribute that matters most for stock right after the product code. These are starting points to adapt.

ShopPartsExample SKU
CandlesProduct, scent, jar sizeCN-LAV-8
RingsProduct, metal, ring sizeRG-SLV-7
Art printsProduct, design, paper sizePR-FN-A4
T-shirtsProduct, color, sizeTS-BLK-M
StickersProduct, design, pack sizeST-CAT-3
YarnProduct, fiber, colorwayYN-MR-TL

Digital products have no stock to count, but a SKU still helps you match orders and files. A product code plus a version number, like PLNR-2027, is enough.

SKUs for variations on Etsy

When a listing has variations, you can give each combination its own SKU. When you add a variation, turn on the option to vary the SKU, and a SKU field appears next to each option. Etsy allows unique SKUs for up to 400 option combinations in one listing.

This is where a SKU generator saves the most time. Enter every value once, and the generator writes the SKU for every combination. The CSV has a column per attribute and a SKU column, so you can match each row to the right variation as you fill in the listing.

A free SKU generator built for Etsy

  • Free, with no email. No account, no sign-up form. The SKUs are made on this page.
  • Checks Etsy's tips. Every SKU is checked for duplicates, length, symbols and the letters O and I.
  • Exports a spreadsheet. Download every SKU with its values as a CSV for Excel, Numbers or Google Sheets.

Alura brings in your Etsy orders and fees automatically, so you can see what each listing earns. Start for free or see pricing.

Share tool

FAQ

Frequently asked questions

Can't find the answer? Contact us.

Helping 1,274,000+ sellersgrow their Etsy shops.