One naming rule, every variant, no typos
SKUs break when two people invent them. Define the pattern once, generate the full variant grid, and paste the result into your product import — no spaces, no duplicates.
Result
Every calculation runs locally. Nothing you type is sent anywhere — check the network tab.
Most SKU chaos starts with good intentions: someone names the first product by hand, then a second person names the next one slightly differently. Six months later nobody can find anything.
A SKU is not a product name. It is a machine key: stable, boring and predictable. The colour code should never change because marketing renamed 'Sand' to 'Desert Beige'.
Generate the grid below, export it, and keep the naming rule in a document that new hires actually read.
How it is calculated
SKU = prefix + "-" + style + "-" + colour code + "-" + size colour code = first three letters of the colour, uppercase example = ACME-TEE-BLA-S
Reading the result
- Keep the pattern short — Eight to fourteen characters is the sweet spot. Long enough to stay unique as you add categories, short enough that warehouse staff and support agents can read it back over the phone.
- Never use spaces — Shopify, Amazon and most ERP imports treat spaces as delimiters. Hyphens are safe across every marketplace feed and survive CSV round-trips.
- Lock the rule before launch — Changing a SKU after launch breaks order history, ad catalogues and 3PL mappings. Decide the pattern while the catalogue is still small, then keep it.
2026 benchmarks
| Metric | Typical range | Why it matters |
|---|---|---|
| SKU length | 8–14 characters | Unique without becoming unreadable. |
| Variant grid | 12–60 SKUs | Beyond that, manage by table, not by pattern. |
| Separator | hyphen | Safe in CSV, Shopify and Amazon feeds. |
| Reserved characters | no spaces, no commas | Both break common importers. |
| Case | uppercase | Prevents duplicate keys on case-sensitive systems. |
Conventions that survive contact with marketplaces, 3PLs and ERPs.
Questions
Can I export this as CSV?
What if two colours start with the same three letters?
Should the size be at the end?
Field limits differ between Shopify (255 characters), Amazon (40) and most ERPs. Keep SKUs well under the smallest limit you use.
Next calculator
Break-even ROAS & profit
One number that tells you the lowest return on ad spend you can survive — carrying product cost, freight, payment fees and returns.
Volumetric & chargeable weight
Convert box dimensions into billable weight across DHL, FedEx and UPS divisors — and see how much air you are shipping.