A SKU is the short code that identifies one exact variant: this tee, in this size, in this color. Shopify does not force you to fill it in, and plenty of stores run for months without SKUs. Then they connect an accounting tool, a warehouse or a barcode scanner and have to backfill hundreds of codes. Picking a format on day one takes ten minutes and saves that cleanup.
Why SKUs matter
Variant titles like "M / Navy" are only readable inside the product they belong to. A SKU like TEE-M-NVY means the same thing in an order export, a packing slip, a stock count or a supplier email. Inventory, accounting and fulfillment tools all match items on it.
If you sync orders to QuickBooks or a similar tool, the SKU is often the field that links a Shopify sale to the right item. Our guide to syncing options to QuickBooks shows where that matters.
3 naming patterns
- Descriptive: SHIRT-SMALL-RED-COTTON. Easy to read, but long and awkward on labels.
- Abbreviated: SH-S-RED-CTN. A good balance of short and readable.
- Sequential: SH001, SH002, SH003. Compact, but you need a lookup sheet to know what anything is.
Pick one pattern and use it on every product. Mixing styles is worse than any single choice.
Recommended format
[Product code]-[Option1]-[Option2]-[Option3]
Example: TSHIRT-S-RED-CTN, TSHIRT-M-RED-CTN, TSHIRT-S-BLUE-CTN. A person can read it, and a spreadsheet can split it on the dashes.
Put the options in the same order as they appear on the product (Size, then Color, then Material) so the codes sort sensibly in reports.
Abbreviation table
Write your abbreviations down once and share them with anyone who adds products:
| Option | Value | Code |
|---|---|---|
| Size | Small / Medium / Large / X-Large | S / M / L / XL |
| Color | Black / White / Navy / Forest Green | BLK / WHT / NVY / FGRN |
| Material | Cotton / Polyester / Blend | CTN / PLY / BLD |
| Mug size | 11 oz / 15 oz | 11 / 15 |
Use fixed-length codes where you can. Three letters for colors keeps every SKU the same shape, which makes typos easy to spot.
Bulk generation
For more than a few products, build SKUs in a spreadsheet. Export your products to CSV, add a formula that joins the product code and option codes, for example =A2&"-"&B2&"-"&C2&"-"&D2, fill it down the SKU column, then import the file back.
For smaller changes, Shopify's bulk editor is quicker than a CSV round trip. Our guide to bulk editing variants shows how to paste a column of SKUs in one go.
POS + POD compatibility
- POS and barcode scanners read SKUs or barcodes at the till. Keeping SKUs under about 20 characters makes them fit on labels and screens.
- POD partners such as Printful usually link your Shopify variants to their catalog items when you sync products, so the SKU is mostly for your own records. Check your partner's documentation for how they match items.
- Stick to letters, numbers and dashes. Spaces and symbols cause trouble in spreadsheets and some scanners.
If you sell in person, pair each SKU with a barcode. Our guide to variant barcode setup covers the label side.
SKUs for personalized products
Keep personalization out of the SKU. A mug with "Grandma Rose" printed on it is still the 15 oz white mug, so its SKU stays MUG-15-WHT. The name is saved on the order line as a line-item property, which is how PIMW Product Personalizer stores customer text and photos, and your print partner reads it from there.
Creating a SKU per name or per font would give you thousands of codes with no stock behind them. Our explainer on variants vs line-item properties covers where the line falls.
Common mistakes
- Reusing a SKU across two variants. Shopify will let you save it, but stock counts and reports will mix the two up.
- Changing SKUs often. Old orders keep the old code, so your sales history splits in two.
- Encoding the price in the SKU. Prices change; SKUs should not.
- Leading zeros in spreadsheets. Excel turns 0012 into 12. Format the SKU column as text before you paste.
Frequently asked questions
What's a good Shopify SKU format?
A product code followed by short option codes, separated by dashes, for example TSHIRT-S-RED-CTN. It is easy for people to read and easy for spreadsheets to split.
How long can Shopify SKUs be?
Shopify allows long SKUs, but 20 to 30 characters is a practical maximum. Shorter codes fit on labels, POS screens and reports.
Should SKU include the option values?
Yes. Then anyone can tell the exact variant from the SKU alone, which speeds up reports, POS scanning and order lookups.
How do I bulk-generate SKUs?
Export your products to CSV, use a spreadsheet formula to join the product code and option codes, then import the file back. For small edits, the bulk editor is quicker.
Can SKUs have spaces?
They can, but avoid them. Spaces cause problems with barcode scanners and spreadsheets, so use dashes or underscores instead.
Do SKUs affect my POD partner, such as Printful?
Usually not directly, since POD apps link variants when you sync products. Consistent SKUs still make it much easier to match your reports with theirs.
Can two variants share a SKU?
Shopify does not stop you, but you should avoid it. Duplicate SKUs confuse inventory counts, accounting syncs and warehouse picking.
How do I change existing SKUs?
Use the bulk editor or re-import a CSV with the new codes. Past orders keep the old SKU on the order record, so keep a note of what changed.
Related reading
Sources & further reading
Primary sources referenced in this article. We link to official platform documentation and standards bodies rather than secondary summaries so you can verify claims directly.
- Shopify Help Center: Product variants
- Shopify.dev: Product variant limits
- Shopify Help Center: Line item properties (customization)
Try it free on Shopify
PIMW Product Personalizer's permanent Free plan includes live preview, custom options, and Cart Transform pricing.
Install PIMW Product Personalizer