You’ve got 47 products in your shop. A customer messages you asking about “the blue one with the flowers.” You know exactly which one they mean — it’s the medium-sized ceramic mug with the hand-painted wildflower design. But when you go to check your inventory, you’re scrolling through a spreadsheet full of entries like “Blue Mug,” “Flower Mug,” “Blue Flower Mug (new),” and “Mug - blue floral UPDATED.”
Sound familiar?
If you’ve ever wasted twenty minutes hunting for the right product in your own records, shipped the wrong item because two listings looked identical in your spreadsheet, or realized you oversold something because your inventory count was attached to the wrong row — you don’t have an organization problem. You have a SKU problem.
And the fix is simpler than you think.
What Even Is a SKU?
A SKU (Stock Keeping Unit, pronounced “skew”) is a unique code you assign to each distinct product you sell. It’s not a barcode, it’s not a serial number, and it’s not something your selling platform assigns to you. It’s your internal system for identifying exactly what something is at a glance.
A good SKU tells you something useful just by reading it. Instead of looking up “Product #47” in a spreadsheet, a SKU like CER-MUG-BLU-M immediately tells you:
- CER — Ceramic (material/category)
- MUG — It’s a mug (product type)
- BLU — Blue (color/variant)
- M — Medium (size)
No spreadsheet lookup required. No guessing. No “wait, which blue mug was that?”
Why You Actually Need One
Let’s be honest — when you’re selling five products out of your kitchen or craft room, you can keep everything in your head. But the moment your product line grows past a handful of items, operating without SKUs starts costing you in ways you might not even notice.
You’re making mistakes you don’t catch
Without a standardized system, you’re relying on product names that you made up on the fly. “Lavender Candle” and “Candle - Lavender Scent” might be the same product. Or they might be two different sizes. When you’re filling orders at 10 PM, that ambiguity turns into a wrong shipment — and a refund request.
Your inventory counts are unreliable
If your products don’t have unique identifiers, your inventory tracking is built on vibes. You think you have 12 of the small ones left. But “small” in which color? Which version? The one with the updated label or the old packaging?
Reordering supplies is a guessing game
When you need to restock materials, you should be able to look at your sales data and see exactly which products are moving. But if your records use inconsistent naming, pulling a clean report is nearly impossible.
You can’t scale
This is the big one. Every successful seller eventually hits a point where they need to bring on help — a friend who packs orders, a virtual assistant who manages listings, a partner who handles restocking. None of those people live inside your head. Without a SKU system, you’re the only person who can decode your inventory, which means you’re the bottleneck for everything.
How to Build a SKU System That Actually Works
Here’s the good news: you don’t need software, you don’t need a business degree, and you don’t need to spend a weekend on it. You just need a consistent format.
Step 1: Define Your Categories
Start by listing the broad categories your products fall into. These become the first segment of your SKU.
| Category | Code |
|---|---|
| Candles | CAN |
| Ceramics | CER |
| Stickers | STK |
| Digital Templates | DIG |
| Baked Goods | BAK |
Keep codes to 2-4 characters. Short enough to scan quickly, long enough to be meaningful.
Step 2: Identify Product Types
Within each category, what are the specific product types?
| Product Type | Code |
|---|---|
| Mug | MUG |
| Bowl | BWL |
| Votive | VOT |
| Sheet (sticker) | SHT |
| Planner | PLN |
Step 3: Add Variant Codes
This is where SKUs get powerful. Variants capture the attributes that make one product different from another — color, size, scent, flavor, format.
| Attribute | Code |
|---|---|
| Blue | BLU |
| Small | S |
| Lavender | LAV |
| Chocolate | CHO |
| 8oz | 8OZ |
Step 4: Assemble the Format
Pick a consistent structure and stick with it. A common format is:
[CATEGORY]-[TYPE]-[VARIANT1]-[VARIANT2]Examples:
- CAN-VOT-LAV-S — Candle, Votive, Lavender, Small
- CER-MUG-BLU-M — Ceramic, Mug, Blue, Medium
- BAK-COO-CHO-DZ — Baked Goods, Cookie, Chocolate, Dozen
- DIG-PLN-WKY — Digital, Planner, Weekly
Use hyphens as separators (not spaces, not slashes, not underscores). Hyphens are universally readable across spreadsheets, selling platforms, and shipping labels.
Step 5: Document Everything
This is the step people skip, and it’s the step that makes or breaks the whole system. Create a SKU key — a simple reference document that lists what each code means.
Without the key, your SKU system is just another layer of mystery for anyone who isn’t you. With the key, anyone on your team can decode CAN-VOT-LAV-S in seconds.
A tool like the SKU Generator - Excel handles this entire process for you — it builds SKUs from your categories and variants automatically and keeps your reference key in one place. If you prefer working in the browser, there’s also a Google Sheets version.
Common SKU Mistakes to Avoid
Even with the right format, a few pitfalls can undermine your system.
Starting with numbers. SKUs that begin with numbers (like “12-MUG-BLU”) can cause problems in spreadsheets — Excel loves to “helpfully” reformat them. Start with letters.
Making them too long. If your SKU is 20 characters, you’ve defeated the purpose. Aim for 8-15 characters. The goal is glanceable, not encyclopedic.
Using ambiguous codes. If “BL” could mean “blue” or “black,” you’ll regret it. Be specific: “BLU” and “BLK.”
Not being consistent. If some products use size before color and others use color before size, your system is broken. Pick an order and enforce it everywhere.
Reusing retired SKUs. When you discontinue a product, retire its SKU permanently. Reassigning it to a new product creates a data nightmare in your sales history.
When Your SKU System Connects to Everything Else
A SKU system on its own is useful. A SKU system connected to your inventory tracking is transformative.
Once every product has a unique identifier, you can:
- Track real inventory counts — not “I think we have some” but actual numbers tied to actual products
- Analyze sales by product — see which specific variants are your best sellers, not just which category
- Reorder with confidence — know exactly when you’re running low on a specific item
- Fulfill orders faster — find the right product instantly instead of hunting through bins
This is where a comprehensive tool like the Craft Business Manager really shines. It ties your SKU system directly into inventory tracking, cost calculations, and sales records — so your product codes aren’t just labels, they’re the backbone of your entire business data.
Start Simple, Expand Later
If you’re feeling overwhelmed, here’s your permission to start small. You don’t need to SKU every product today. Start with your top 10 best sellers. Build the system for those. Get comfortable with the format. Then expand to the rest of your catalog.
The worst SKU system is no SKU system. The second worst is one you built to be “perfect” but never actually use because it’s too complicated.
Good enough and consistent beats elaborate and abandoned. Every time.
Here’s a quick-start checklist:
- List your product categories (3-5 to start)
- Define your SKU format:
[CATEGORY]-[TYPE]-[VARIANT] - Assign codes to your top 10 products
- Create a SKU key document
- Update your inventory spreadsheet to use SKUs instead of product names
- Add the SKU to your product labels, packaging, or storage bins
That’s it. A couple of hours now saves you hundreds of hours of confusion later.
The Bottom Line
A SKU system isn’t glamorous. Nobody starts a small business because they’re excited about inventory codes. But the sellers who stick around — the ones who grow from a side hustle into a real business — are the ones who build systems that scale.
You don’t need to be a logistics expert. You just need a consistent way to say “this product is this one, not that one.” That’s all a SKU does. And once you have it, you’ll wonder how you ever operated without it.
And when your business outgrows a spreadsheet and you need real-time inventory tracking, manufacturing workflows, and sales analytics all in one place — Ardent Seller is the next step.