SkuWorth
Inventory

SKU Generator

Create standardized, human-readable product SKUs and bulk variant matrices for Shopify, Amazon, and WooCommerce. Instant CSV export 100% in your browser.

2–4 letter merchant or brand prefix.

2–4 letter category identifier.

Product silhouette or model code.

Standardized 2–3 letter color code.

Apparel size or physical dimension.

Season, batch, or supplier ID.

Generated Single SKU Output
18 / 40 chars (Amazon Compliant)
SW-TOP-CRW-BLK-L-001
Format: [BRAND]-[CAT]-[STYLE]-[COLOR]-[SIZE]-[SEQ]

How It Works & Exact Technical Standard

An e-commerce Stock Keeping Unit (SKU) is an alphanumeric code designed to systematically identify, categorize, and track physical products across multi-channel retail environments. Unlike machine-only identifiers, an effective SKU is human-interpretable: a warehouse associate, customer support representative, or store manager should be able to deduce the brand, product line, color, and size simply by reading the code.

Standard E-Commerce SKU Architecture

Brand
SW
Category
TOP
Style
CRW
Color
BLK
Size
L
Sequence
001
Result: SW-TOP-CRW-BLK-L-001

Critical Rules for SKU Construction

  • Never Start a SKU with Zero (0): When inventory CSV files are opened in Microsoft Excel or Google Sheets, software interprets numbers starting with zero as numeric integers rather than text strings, instantly stripping the leading zero (e.g., 04981 becomes 4981). This corrupts Shopify imports, Amazon feeds, and WMS inventory sync.
  • Eliminate Ambiguous Alphanumerics: Warehouse pickers and logistics staff frequently confuse the uppercase letter O with the number 0, and the uppercase letter I or lowercase l with the number 1. SkuWorth provides an automated sanitizer toggle to substitute or clarify these characters before printing bin tags.
  • Strictly Avoid Special Characters & Spaces: Characters such as /, ,, ", ', #, @, and whitespace cause severe parsing syntax errors in CSV exports, SQL database tables, and REST API calls on Shopify, Amazon, and WooCommerce. Use hyphens (-) or underscores (_) as universal delimiters.
  • Respect Marketplace Length Constraints: Amazon Seller Central enforces a hard ceiling of 40 characters for merchant SKUs. SkuWorth actively monitors character counts and displays warning indicators if your constructed codes approach or exceed this threshold.

Step-by-Step Instructions

  1. Establish a Fixed Taxonomy: Determine standardized 2-to-4 character abbreviations for your primary business dimensions: Brand/Store (e.g., SW), Product Category (e.g., TOP, BTM, ACC), and Style Name (e.g., CRW for Crewneck, HDY for Hoodie).
  2. Select Your Mode: Use the Single SKU Builder for standalone items or unique product additions. Switch to the Bulk Variant Matrix when launching multi-variant items with color and size combinations.
  3. Input Attributes & Delimiters: Enter your attribute values. For bulk generation, input comma-separated lists for colors (BLK, NVY, SND) and sizes (S, M, L, XL). SkuWorth calculates the full combinatorial matrix instantaneously in your browser.
  4. Inspect Length & Ambiguity: Confirm that each SKU remains under Amazon's 40-character threshold and verify that the "Sanitize Ambiguous Chars" toggle is active if your product codes use O or I.
  5. Export for Catalog Integration: Click Copy All SKUs to paste newline-delimited lists into spreadsheets, or click Download CSV to receive a clean, pre-structured table containing separate columns for SKU, Brand, Category, Style, Color, and Size.

Worked Real-World E-Commerce Example

Worked Example: Apparel Brand Launching Heavyweight Tees12-SKU Variant Matrix

An e-commerce streetwear brand (SkuWorth Apparel, code SW) launches an oversized 280 GSM crewneck t-shirt (category TOP, style CRW) across 3 core colors (Black BLK, Navy NVY, Sand SND) and 4 sizes (S, M, L, XL). Entering these attributes into the Bulk Variant Matrix builder produces 12 production-ready SKUs:

ColorSize SSize MSize LSize XL
Black (BLK)SW-TOP-CRW-BLK-SSW-TOP-CRW-BLK-MSW-TOP-CRW-BLK-LSW-TOP-CRW-BLK-XL
Navy (NVY)SW-TOP-CRW-NVY-SSW-TOP-CRW-NVY-MSW-TOP-CRW-NVY-LSW-TOP-CRW-NVY-XL
Sand (SND)SW-TOP-CRW-SND-SSW-TOP-CRW-SND-MSW-TOP-CRW-SND-LSW-TOP-CRW-SND-XL

Each SKU has a length of 17 characters — well below Amazon's 40-character limit. The brand downloads the CSV file, imports it directly into Shopify to auto-create all 12 product variants, and uses the Barcode Generator to print matching Code 128 warehouse bin labels for each physical location.

Frequently Asked Questions

What is a SKU number and how is it different from a UPC barcode?
A Stock Keeping Unit (SKU) is an internal, alphanumeric identification code created by a merchant to organize, track, and manage product inventory across warehouses, catalog databases, and sales channels. In contrast, a Universal Product Code (UPC) is a globally standardized, 12-digit numeric barcode licensed through GS1 that uniquely identifies a product across all worldwide retail supply chains. While every retailer creates their own proprietary SKUs (e.g., SW-TOP-CRW-BLK-L), all retailers selling that exact packaged product share the exact same GS1 UPC barcode.
What is the best SKU naming convention for Shopify and Amazon sellers?
The industry standard e-commerce SKU convention follows a cascading top-down hierarchy separated by hyphens: [Brand/Supplier]-[Category]-[Style/Model]-[Color/Finish]-[Size/Variation]-[Optional Batch]. For example, SW-APP-CRW-BLK-LRG immediately tells a warehouse picker that the item is a SkuWorth Apparel Crewneck in Black, Size Large. Maintain uniform 2-to-4 character abbreviations for each attribute, always use uppercase letters, and never mix numbering systems between product categories.
Why should I avoid starting a SKU with the number zero (0)?
Never begin a SKU code with the number zero. Spreadsheet software like Microsoft Excel, Google Sheets, and older inventory CSV parsers automatically classify strings starting with numbers as integers rather than text. When opening an inventory export, these programs truncate leading zeros (e.g., 01234 becomes 1234), irreversibly corrupting your SKU inventory records and causing catalog sync mismatches across Shopify, Amazon Seller Central, and warehouse 3PL systems.
Which letters and symbols should never be used in product SKUs?
Avoid visually ambiguous alphanumeric characters — specifically capital letter "O" (frequently misread as number zero "0"), capital letter "I" and lowercase "l" (frequently misread as number one "1"), and the letter "Z" (confused with number two "2"). Furthermore, never use spaces, slashes (/), commas, quotation marks, or special characters like @, #, $, %, &, or * in SKUs. Special characters break database SQL queries, Excel CSV formulas, barcode scanner decoders, and marketplace REST API endpoints.
What is the maximum character limit for Amazon Seller SKUs?
Amazon Seller Central imposes a strict maximum limit of 40 characters for merchant SKUs (MSKUs). However, the recommended best practice is to keep SKUs between 8 and 20 characters. Compact SKUs fit neatly on 2" x 1" thermal barcode labels, remain legible on mobile warehouse picking scanners, and leave ample margin for Amazon FNSKU barcode integration without truncation.
How do I generate bulk SKUs for multiple product sizes and colors at once?
Use the Bulk Variant Matrix tab above. Enter your core Brand and Style prefix, followed by comma-separated lists for your variant attributes (such as Colors: "BLK, NVY, SND" and Sizes: "S, M, L, XL"). SkuWorth instantly calculates the Cartesian mathematical product of all attribute combinations (3 colors × 4 sizes = 12 structured SKUs), verifies the 40-character limit, and provides one-click CSV export ready for bulk upload into Shopify, WooCommerce, or BigCommerce.

Related E-Commerce Tools

Cross-Silo Utilities