Free SKU generator for WooCommerce
Design one SKU pattern, apply it to your whole catalog, and export a CSV in the exact format the built-in WooCommerce importer expects — SKUs, prices, stock, categories, tags, and attributes included.
Why consistent SKUs matter in WooCommerce
WooCommerce enforces SKU uniqueness: a duplicate produces the dreaded "Invalid or duplicated SKU" error, and imports silently skip rows. Beyond errors, consistent SKUs are what make stock lookups, order picking, and accounting exports usable once your catalog grows past a few dozen products.
The usual workflow — inventing codes one by one in a spreadsheet — is exactly how duplicates and inconsistent codes happen. A generator applies your rules mechanically, so every product gets a unique, readable code like OTR-CTN-M-0031.
How it works
- Define your pattern. Brand code + attribute codes + padded sequence number, with your choice of separator.
- Add attributes and options. Color, size, material — each option gets a short code that appears in the SKU.
- Add products or generate variant sets. Duplicate-detection runs live, so collisions are caught before WooCommerce ever sees them.
- Export the WooCommerce CSV and import it via Products → All Products → Import.
What the export includes
| WooCommerce column | Filled from |
|---|---|
| SKU | Generated from your pattern |
| Name, Description | Product details |
| Regular price / Sale price | Pricing (compare-at maps to Regular + Sale) |
| Stock, In stock?, Backorders | Inventory settings |
| Categories, Tags, Images, Weight | Organization & shipping fields |
| Attribute 1–n name / value(s) | Your attributes |
Migrating or cleaning up? Import your existing product CSV into OtterLabel first — you get an instant audit of duplicate, missing, and risky SKUs before anything touches your store.
Clean SKUs for your WooCommerce store
Free, no account, runs entirely in your browser — your product data never leaves your machine.
Open the free SKU builderAlso exports Shopify and generic spreadsheet formats.