SKU Generator

How This Tool Works

Define your SKU structure by entering a category prefix (like APP for Apparel or ELC for Electronics), a product code (like TSH for T-Shirt), and lists of colors and sizes. The generator creates a unique SKU for every combination. For example, with category APP, code TSH, colors Black and Blue, and sizes S, M, L, you get six SKUs: APP-TSH-BLK-S, APP-TSH-BLU-S, APP-TSH-BLK-M, and so on.

The auto-abbreviation feature shortens color and size names to three characters (Black becomes BLK, Medium becomes MED). You can also enter your own abbreviations directly. The separator between segments can be a dash, dot, or nothing, depending on your preference.

Add multiple products to generate SKUs for your entire product line at once. Each product can have its own code override while sharing the same category prefix, colors, and sizes. The preview table shows every generated SKU alongside the product name, color, and size for easy verification.

Step-by-Step Guide to Building Your SKU System

1. Define your category prefixes. List every product category in your store and assign a 2-3 character prefix. Common examples: APP (Apparel), ACC (Accessories), ELC (Electronics), HOM (Home & Living), BEA (Beauty), FD (Food), PET (Pet Supplies). Keep a master reference document.
2. Create product codes. For each product within a category, assign a unique 2-4 character code. T-Shirts could be TSH, Hoodies could be HOD, Mugs could be MUG. These should be intuitive enough that a warehouse worker can recognize the product type at a glance.
3. Standardize color abbreviations. Create a universal color abbreviation chart: BLK (Black), WHT (White), NVY (Navy), RED (Red), GRN (Green), BLU (Blue), GRY (Grey), PNK (Pink), etc. Apply these consistently across all products. This tool’s auto-abbreviation feature helps, but having a master list prevents inconsistencies.
4. Define size codes. For apparel: XS, S, M, L, XL, 2XL, 3XL. For shoes: use the numeric size (8, 9, 10, 11). For one-size products: use OS or STD. For volume: use the measurement (8OZ, 16OZ, 1L).
5. Choose your separator. Dashes are the most common and readable. Dots work well for systems that already use dashes in product codes. No separator creates the shortest SKUs but reduces readability.
6. Generate SKUs for your first product line. Enter the category, product code, colors, and sizes in the tool above. Review the generated SKUs to make sure they look right and follow your conventions.
7. Apply to your Shopify products. Download the SKU CSV and use it as a reference when setting up products, or incorporate the SKUs into your product import CSV. You can also copy individual SKUs and paste them into the Shopify admin.
8. Document your system. Create a reference guide listing all category prefixes, product codes, color abbreviations, and size codes. Share this with your warehouse team, customer service team, and anyone who handles inventory.

Why This Matters for Your Shopify Store

Consistent SKUs enable faster warehouse operations, accurate inventory tracking, and reliable analytics. When your SKU encodes the category, product, color, and size, any team member can identify a product at a glance without looking it up in the system. This speeds up picking, packing, and returns processing, especially during high-volume periods like Black Friday.

Structured SKUs also make data analysis more powerful. You can filter sales reports by SKU prefix to see how an entire category is performing, or extract the color segment to identify your best-selling colorways across all products. Without this structure, generating these insights requires manual product-by-product analysis that does not scale.

For multi-channel sellers, consistent SKUs are essential. If you sell on Shopify, Amazon, Etsy, and wholesale, the same SKU should identify the same product everywhere. This enables unified inventory management across channels and prevents overselling when stock levels change. Stores selling on 3 or more channels without consistent SKUs report inventory discrepancy rates of 15-25%, compared to 2-5% for stores with structured SKU systems.

Real-World SKU Examples

Example 1: Apparel Brand (T-Shirts, Hoodies, Pants)

A clothing brand with three product categories needs a scalable SKU system:

With this system, a warehouse worker seeing “APP-HOD-NVY-XL” on a packing slip instantly knows: Apparel category, Hoodie product, Navy color, Extra Large size. No need to look up the product in the system.

Example 2: Home Goods Store (Candles, Mugs, Decor)

A home goods store with products that vary by scent, material, or size rather than traditional clothing options:

Example 3: Electronics Accessories (Cases, Cables, Chargers)

SKU Generator vs. Other Methods

Common Mistakes to Avoid

1. Using product names as SKUs. “Blue-Medium-T-Shirt” is a description, not a coded SKU. SKUs should use abbreviated codes (APP-TSH-BLU-M) that are short, systematic, and scannable. Long descriptive SKUs are hard to type, scan with barcode readers, and display on labels.
2. Reusing retired SKUs. When you discontinue a product, retire its SKU permanently. Assigning an old SKU to a new product corrupts your historical sales data, confuses returns processing, and makes inventory audits unreliable. Keep a record of retired SKUs.
3. Inconsistent abbreviations. If “Black” is “BLK” for t-shirts, it must be “BLK” for hoodies, pants, and every other product. Mixing “BLK”, “BK”, “BLACK”, and “Blk” creates confusion and breaks filtering. Maintain a master abbreviation reference.
4. Starting SKUs with zeros. Some spreadsheet applications and barcode systems strip leading zeros. A SKU like “007-TSH-BLK” might become “7-TSH-BLK” when processed. Start SKUs with letters to avoid this issue entirely.
5. Making SKUs too long. SKUs over 15-20 characters become impractical for manual entry, barcode label printing, and visual scanning. If your SKU exceeds 15 characters, you are probably encoding too much information. Keep segments to 2-4 characters each.
6. Not planning for growth. A category prefix system that works for 3 categories might not work for 30. Reserve common prefixes and build a numbering system that accommodates new categories, products, and option values without redesigning the entire scheme.

When to Use This Tool

Tips and Best Practices

• Keep category prefixes to 2-3 characters. Short prefixes keep SKUs scannable and easy to type. Common examples: APP (Apparel), ACC (Accessories), ELC (Electronics), HOM (Home), BEA (Beauty).
• Use consistent abbreviations across your catalog. If Black is BLK for one product, it should be BLK everywhere. Create a reference sheet for your team listing every abbreviation used in your SKU system.
• Avoid ambiguous characters. Letters like O and I can be confused with numbers 0 and 1. Use abbreviations that avoid this confusion, or stick with all-letters codes and separate them with dashes for readability.
• Plan for future products. Choose a pattern that accommodates new categories, products, and options without needing to redesign your entire SKU system. Leave room in your product code scheme for additions.
• Never reuse SKUs. When you discontinue a product, retire its SKU permanently. Reusing SKUs causes confusion in historical sales data, returns tracking, and inventory audits.
• Include season or year codes when needed. For seasonal businesses, append a season code like -SS25 (Spring/Summer 2025) or -FW25 (Fall/Winter 2025). This helps with inventory aging analysis and seasonal planning.
• Test your SKU system with warehouse staff. Before finalizing, show sample SKUs to the people who will use them daily. If they cannot decode the product from the SKU within a few seconds, simplify the format or improve your abbreviations.

Related Tools

• Product CSV Generator – Generate Shopify product CSVs with your newly created SKUs built in.
• Barcode Validator – Validate UPC and EAN barcodes that complement your internal SKU system.
• CSV Validator – Validate your product CSV after adding generated SKUs to catch any formatting issues.