Core formulas
The formulas to keep straight
SKU = brand code + product code + variant code + channel code + season code + sequence numberShort SKU = product code + variant code + sequence numberBatch code = brand code + season code + sequence numberSKU rule = one format, reused across every product familyHow do you create SKU numbers?
Create SKU numbers by choosing a fixed code order and using short codes for brand, product, variant, channel, season, and sequence. Keep the pattern stable so every export and label reads the same way.
For example, FP-CANDLE-LAV-ETSY-26-0012 is easier to scan than Lavender Soy Candle Etsy 2026 Batch 12. The second one is a title. The first one is a working inventory code.
A SKU should be readable by a person and stable enough for a spreadsheet.
Simple handmade SKU format
| Part | Example | Meaning |
|---|---|---|
| Brand | FP | Brand or shop code |
| Product | CANDLE | Product family |
| Variant | LAV | Scent, color, size, or style |
| Channel | ETSY | Sales channel |
| Season | 26 | Year, batch season, or launch code |
| Sequence | 0012 | Unique number |
What makes a good SKU?
A good SKU is short, consistent, unique, and readable. It should not contain every detail. If the SKU gets too long, people stop using it and exports become harder to scan.
Use letters and numbers. Avoid spaces. Pick one separator and keep it. The boring format wins because it reduces mistakes during packing and reconciliation.
A 12 to 24 character SKU is often enough for a small handmade shop.
- Use uppercase letters and numbers.
- Avoid spaces and special symbols.
- Keep the same order in every SKU.
- Make each variant unique.
- Do not reuse old SKUs for new products.
Should Etsy sellers use SKUs?
Etsy sellers should use SKUs when they sell variants, repeat products, bundles, or POD items. SKUs make it easier to match Etsy orders to materials, Printify orders, inventory counts, and profit tracking.
If you sell one-of-a-kind items, a SKU can still help with bookkeeping, but it does not need to be complex. The point is traceability, not decoration.
A SKU helps match Etsy revenue to product cost when titles change.
When a SKU helps
| Shop type | SKU value |
|---|---|
| Candles | Tracks scent, vessel, batch, and size |
| Jewelry | Tracks metal, stone, and style |
| POD | Matches Etsy order to provider order |
| Crochet | Tracks pattern, color, and size |
| Craft fairs | Speeds restock and post-event counts |
What should you avoid in SKU numbers?
Avoid full words, random codes, date-only SKUs, and codes that depend on product titles. A SKU should still make sense when viewed in a CSV six months later.
Do not encode price in a SKU. Prices change. Product identity should not. Use the pricing calculator for price, and use the SKU for tracking the item.
Never reuse a SKU for a different product variant.
- Do not include price.
- Do not include full product titles.
- Do not change the format by product line.
- Do not reuse old SKUs.
- Do not rely on color names alone if sizes also vary.
Decision table
SKU format decisions
| Choice | Best option | Why |
|---|---|---|
| Separator | Dash | Easy to read in exports |
| Length | 12 to 24 characters | Enough detail without clutter |
| Variant code | Short meaning code | Keeps products distinct |
| Sequence | Padded number | Sorts cleanly |
| Price | Leave it out | Prices change |
Worked examples
Examples you can compare against your own numbers
Example: candle SKU
A seller creates a SKU for a lavender candle sold on Etsy in 2026.
| Brand | FP | Shop code |
|---|---|---|
| Product | CANDLE | Product family |
| Variant | LAV | Lavender scent |
| Generated SKU | FP-CANDLE-LAV-ETSY-26-0012 | Readable in exports |
Takeaway: The SKU is long enough to identify the product, but not a sentence.
Open the SKU generatorAction checklist
Before you use this number in the real business
- 1Choose one SKU pattern.
- 2Create short codes for products and variants.
- 3Use a sequence number.
- 4Test the SKU in an order export.
- 5Put the SKU on labels or internal packing notes.
- 6Use the same SKU in profit tracking.
Common mistakes
Mistakes that make the answer look better than reality
FAQs
Questions people ask before making the decision
What is a SKU?
A SKU is an internal stock keeping unit. Sellers use it to identify products and variants inside their own inventory system.
Is a SKU the same as a UPC?
No. A SKU is internal to your business. A UPC or GTIN is a formal barcode identifier used across retailers.
How many characters should a SKU have?
Use the shortest code that still identifies the product and variant. Many small shops can stay between 12 and 24 characters.
Should handmade sellers use SKUs?
Yes if they have repeat products, variants, batches, POD providers, or inventory counts. SKUs reduce manual matching work.
Can I change old SKUs?
Avoid changing old SKUs unless you are cleaning a broken system. Changing SKUs can break order history and profit tracking.
Sources and notes
Where the assumptions come from
Live calculator for generating product, variant, channel, season, and sequence SKUs.
Guide showing why SKUs help reconcile Etsy revenue with Printify fulfillment cost.