Craftybase Stocksmith

Why?

Free Resources

Free SKU Generator

Generate unique Stock Keeping Unit codes for your products and variants — then export as CSV for bulk upload to Shopify, Etsy, or your inventory system.

How Do You Generate a SKU Number?

A SKU number is a unique alphanumeric code assigned to each product in your inventory. To generate one, combine a product category prefix + variant code + size code (e.g., SOAP-LAV-001).

A SKU (Stock Keeping Unit) is your own internal shorthand for every product and variant you sell. It's typically 8–12 alphanumeric characters that encode details like product type, size, colour, or scent. Unlike UPC barcodes, SKUs are created by you and unique to your business. Consistent SKUs unlock accurate inventory counts, faster picking, and better sales reporting.

Track these SKUs in real time. Stocksmith syncs your SKUs across Shopify, Etsy and more — so stock levels update automatically as you sell.

Try free for 14 days
Product Attribute 1 Attribute 2 Attribute 3 Generated SKU

Assign and track SKUs across your entire product catalogue automatically

Stocksmith syncs your SKUs across Shopify, Etsy, and more — so stock levels update automatically as you sell and manufacture.

Start your free 14-day trial →

How to Use the Free SKU Generator

Enter your product name and up to three variant attributes, choose a character length and separator, then click Generate SKU to produce a unique, export-ready code in seconds.

  1. Choose your pattern. Decide which elements you want in every SKU — product code, colour or size, and a running attribute.
  2. Set character length and separator. Hyphens (-) keep SKUs readable and are e-commerce-safe, but underscores, pipes, slashes or colons all work too. Choose a character length that's short enough to scan fast and fit on small tags but long enough to be unique.
  3. Enter product details. Type the main product name (e.g. HANDCREAM), then add up to three variant attributes such as LAVENDER, 100ML, TWIN-PACK. Use abbreviations you'll recognise at a glance.
  4. Hit Generate SKU. Each click produces a unique SKU string in the results table. Modify any field and re-generate until the format feels right; duplicates are automatically skipped.
  5. Export as CSV. Click Export as CSV to download the whole list for bulk uploads to Shopify, Etsy or your inventory system.
  6. Put them to work. Paste the codes into Stocksmith (or your platform of choice) and assign them to products. Consistent SKUs unlock accurate reporting, faster picking, and zero mix-ups at shipping time.

Why Unique SKUs Matter

Unique SKUs give every product variant its own identifier, preventing mix-ups at shipping, enabling accurate stock counts, and unlocking variant-level sales reporting.

A Stock-Keeping Unit (SKU) is your own shorthand for every product and variant you sell. Because no two SKUs are alike, they act as the single source of truth across purchasing, production, sales channels and accounting. With a clean SKU system you can:

  • Spot stock at a glance. Search or scan a code and know exactly which colour, size or production batch you're holding.
  • Prevent fulfilment errors. Unique SKUs remove guesswork at picking and packing, cutting refunds and bad reviews.
  • Automate re-ordering. Inventory tools like Stocksmith pair each SKU with real-time counts, so low-stock alerts and purchase orders fire off automatically.
  • Unlock granular reporting. When every sale is tagged to a distinct code, profit and velocity reports drill right down to the variant level — which is how you decide what to scale.
  • Stay platform-agnostic. Whether you're on Shopify, Faire or a wholesale spreadsheet, consistent SKUs keep data in sync when you expand channels.

SKU Format Examples by Product Category

There's no single "right" SKU format, but the best ones follow a predictable pattern: Category – Product – Variant – Size. Here are examples across common small-batch categories to get you started:

Candles & Home Fragrance

Encode the wax type, scent, and container size so you can tell variants apart at a glance.

ProductSKUBreakdown
Soy candle, Lavender, 8 ozCND-SOY-LAV-8OZCategory-Wax-Scent-Size
Beeswax taper, UnscentedCND-BEE-UNS-TAPCategory-Wax-Scent-Style
Wax melt, Cinnamon, 6-packMLT-SOY-CIN-6PKCategory-Wax-Scent-Pack

Soap & Bath Products

Include the soap base, scent, and weight. If you produce both bars and liquid soap, lead with the form.

ProductSKUBreakdown
Cold-process bar, Oatmeal, 4 ozBAR-CP-OAT-4OZForm-Process-Scent-Weight
Liquid soap, Tea Tree, 250 mLLIQ-HM-TEA-250Form-Process-Scent-Volume
Shampoo bar, RosemaryBAR-SH-ROSForm-Type-Scent

Jewellery & Accessories

Encode the material, style, and finish so variants like "gold vs silver" are instantly distinguishable.

ProductSKUBreakdown
Sterling silver hoop earrings, SmallEAR-SS-HOP-SMType-Material-Style-Size
Gold-fill pendant, LeafPEN-GF-LEAType-Material-Design
Polymer clay stud, Floral, BlueSTD-PC-FLO-BLUType-Material-Design-Colour

Food & Beverage

Lead with the product category, then flavour and size. Keep SKUs short enough to fit on small labels.

ProductSKUBreakdown
Sourdough loaf, Plain, LargeBRD-SD-PLN-LGCategory-Style-Flavour-Size
Chocolate cupcake, DozenCUP-CHO-12Category-Flavour-Qty
Granola, Honey Almond, 12 ozGRA-HON-ALM-12Category-Flavour-Variant-Size

Cosmetics & Skincare

Encode the product type, key ingredient, and size. This helps distinguish products that look similar on the shelf.

ProductSKUBreakdown
Lip balm, Vanilla, 0.15 ozLIP-VAN-015Type-Scent-Size
Face serum, Vitamin C, 1 ozSER-VITC-1OZType-Ingredient-Size
Body butter, Lavender, 8 ozBUT-LAV-8OZType-Scent-Size

Managing dozens of SKUs across multiple sales channels? Stocksmith keeps every SKU, stock count, and cost synced across your channels and your own records — so you never oversell or lose track of inventory.

Try free for 14 days →

SKU Best Practices

Use 8–12 alphanumeric characters, start with a letter, avoid O and I, use hyphens as separators, and apply the same format consistently across every sales channel.

Keep It Short but Meaningful

Aim for 8–12 characters. Shorter SKUs print clearly on small tags and are faster to type. But don't go so short that you can't tell products apart. A good test: can you identify the product from the SKU alone, without looking it up?

Avoid Confusing Characters

Skip the letters O and I — they look too much like 0 and 1 on labels and in spreadsheets. Avoid spaces and special characters like #, &, or accented letters, which can cause import errors on marketplaces.

Never Start with Zero

Excel and Google Sheets strip leading zeros unless cells are formatted as text. Start SKUs with a letter to avoid this common headache.

Use the Same Format Everywhere

Pick one SKU format and use it across every sales channel — Shopify, Etsy, markets, wholesale orders. Mismatched SKUs across channels are the fastest way to end up with wrong stock counts and overselling.

Never Reuse a Retired SKU

When you discontinue a product, retire the SKU — don't recycle it. Reusing a code corrupts your historical sales data and can trigger duplicate-SKU errors on marketplaces.

SKU vs UPC vs Barcode: What's the Difference?

It's easy to confuse SKUs with other identifiers. Here's how they compare:

Identifier Designed for Key traits
SKU Internal operations — inventory, manufacturing, analytics Alphanumeric, any length/structure you choose; unique within your business; may be encoded into a barcode or left as text
UPC / EAN External retail & supply chain — point-of-sale, distributors 12- (UPC) or 13-digit (EAN) numeric codes issued by GS1; globally unique; must be printed as a barcode
Barcode
(e.g., Code-128, QR)
Machine reading of any underlying code (SKU, UPC, lot number) Visual pattern (lines or squares) scannable by devices; carries data but is not the data itself

Pro tip: Pair your SKUs with lot numbers to create full traceability from raw materials through to sale — essential for quality control and regulatory compliance.

Who Should Use This SKU Generator?

Any product business selling across online stores, marketplaces, markets, or wholesale channels that needs a consistent, error-free way to identify every product variant.

This tool is built for anyone who sells physical products and needs a consistent way to identify them. Specifically:

  • Candle and home fragrance producers managing dozens of scent-and-size combinations across multiple channels — who need a quick way to assign unique codes before their next production run.
  • Soap and bath product businesses tracking cold-process bars, liquid soap, and bath bombs where small variations (scent, weight, batch) each need their own identifier.
  • Jewellery makers with large catalogues of earrings, necklaces, and bracelets in different materials and finishes that look similar in photos but need distinct codes for fulfilment.
  • Food and beverage producers listing products on multiple platforms and needing SKUs that match across every sales channel and inventory spreadsheet.
  • Cosmetics and skincare formulators producing serums, balms, and lip products in multiple sizes — especially those preparing for wholesale, where SKU consistency is non-negotiable.
  • Any business growing beyond a handful of products that's tired of manually typing codes into spreadsheets and wants a faster starting point.

If you want to go beyond generating codes and actually track stock levels, costs, and sales against each SKU, Stocksmith handles it automatically across your entire product line.

SKU Generator FAQs

What is a SKU?

A SKU (Stock Keeping Unit) is a unique alphanumeric code that a business creates to track individual products and variants in its inventory. A typical SKU is 8–12 characters and encodes details such as product type, size, colour, or scent. Unlike universal barcodes, SKUs are internal identifiers you control — the format and naming convention belong entirely to your business.

Why do I need a SKU for my products?

SKUs let you identify any specific product variant instantly, making it easier to manage stock levels, track sales performance, and prevent fulfilment errors. They're especially valuable when you sell variations of the same product — different sizes, scents, or colours — across multiple sales channels. Stocksmith tracks your SKUs across all connected sales channels so inventory counts update automatically with every sale.

How many characters should a SKU have?

There's no strict rule, but 8–12 characters is the sweet spot for readability and consistency. Longer SKUs capture more product detail but get harder to scan visually and type. Shorter ones usually mean you've dropped a variant dimension you'll wish you had later. The generator above lets you set the character length per segment so you can find the right balance.

Can I change my SKUs after I generate them?

Yes. You're free to edit your SKUs at any time, although it's best to settle on a consistent format early to avoid confusion. If you sell on multiple platforms, remember to update the SKUs everywhere — a code that's changed in one place and not another is worse than the original.

Are SKUs the same as barcodes or UPCs?

No — SKUs, barcodes, and UPCs are three distinct identifiers. A SKU is an internal code you create for your own inventory management, in any format you choose. A UPC or EAN is a globally standardised 12- or 13-digit code issued by GS1 for external retail and supply chains — you can check one with our UPC check digit calculator. A barcode is the visual, machine-readable representation of any underlying code; your SKU can be printed as a barcode once the codes are set.

What characters can I use (and avoid) in a SKU?

Use letters A–Z and numbers 0–9. Dashes (-) or underscores (_) are safe separators. Avoid spaces and special characters such as #, &, /, or accented letters, and consider skipping easily confused letters like O and I.

Is there a maximum SKU length for Shopify, Etsy or Amazon?

Each marketplace sets its own field limit, and they change — check the current documentation for the platforms you sell on before committing to a long format. In practice the limits rarely bite: staying in the 8–12 character range keeps you comfortably inside every major platform's cap while remaining readable on a label. If you're planning a format longer than about 20 characters, verify it against each channel first.

Do my SKUs have to be unique across all sales channels?

Yes — each product variant should carry the same unique SKU on every marketplace you sell on. Duplicate or mismatched SKUs across channels cause wrong inventory counts, analytics errors, and duplicate-listing conflicts. Unique, consistent SKUs are the single source of truth that keeps stock levels accurate when you sell in multiple places.

Can I convert these SKUs into barcodes later?

Yes. Any alphanumeric SKU can be encoded into a barcode format such as Code-128 or a QR code using standard label-printing software — the underlying SKU text stays unchanged. That means you can print shelf labels, product tags, or shipping stickers that scan directly into your inventory system.

Should I reuse a SKU when a product is discontinued?

No. Retire the code instead. Reusing a SKU corrupts historical sales data and can trigger duplicate-SKU conflicts on marketplaces.

What's the best separator — dash or underscore?

Both are technically safe, but dashes tend to print and scan more clearly on labels. Avoid other separators like spaces, slashes, or periods, which can cause import or URL-encoding issues.

Can leading zeros cause problems in spreadsheets?

Yes. Excel and Google Sheets strip leading zeros unless the cells are formatted as text or with a custom number format. Format columns before import, or start the code with a non-zero character to keep the zeros intact.

What is the best SKU format for products with many variants?

For products with multiple variants — scent, size, and colour, say — the most reliable format uses fixed segments: Category–Product–Variant1–Variant2. A lavender soy candle in a 12 oz jar becomes CND-SOY-LAV-12OZ. This pattern keeps every SKU consistent and human-readable while making sure each combination gets a unique code with no overlap.

How does Stocksmith use SKUs to manage inventory automatically?

Stocksmith assigns your SKUs to products and materials, then adjusts inventory counts as you sell, manufacture, or restock. When you connect a sales channel such as Shopify, incoming orders reduce the correct SKU's stock level automatically. That removes the manual reconciliation between spreadsheets and channels, which is where overselling usually starts.

Can I export the generated SKUs?

Yes. Generate as many SKUs as you need, then click Export as CSV to download the whole list. The file includes the product name, all three attributes, and the generated SKU as separate columns, so you can map them straight into a bulk-upload template for Shopify, Etsy, or your inventory system. Nothing is stored on our end — the list lives in your browser until you export it.

Is this SKU generator free?

Yes — completely free, with no sign-up, no email required, and no limit on how many SKUs you generate. Everything runs in your browser. We build it because the businesses we work with need it; if you later want to track stock, costs, and sales against those SKUs automatically, that's what Stocksmith does.

Now track every SKU in real time

Stocksmith syncs your SKUs across Shopify, Etsy and more — so inventory levels update automatically as you sell. No more spreadsheets, no more overselling, no more guesswork.

Start your free 14-day trial

Stop guessing your cost per unit

We've run product businesses too — spreadsheet explosions and all. Two to four emails a month on batch costing, keeping stock honest across channels, and running the numbers instead of guessing them.

    We take care of your data. Read our Privacy Policy.

    Small-batch operations

    Know what a batch actually costs

    Most product businesses work out their real cost per unit long after they've set the price. It doesn't have to go that way.

    Two to four emails a month on batch costing, reorder points, and keeping multi-channel stock honest — written for people who make things in batches.

    No spam, and one-click unsubscribe on every email. Read our Privacy Policy.