SKU Generator

What is a SKU, exactly?

A Stock Keeping Unit is the smallest unit of a product that your business tracks separately in stock. If you sell a hoodie in three sizes and two colours, that's six SKUs, not one — each combination needs its own code because each is ordered, stocked and sold independently. The SKU is entirely internal: unlike a barcode, no external body issues it or checks it for uniqueness. You're free to build whatever format suits your operation, as long as it stays consistent and unique across your own catalogue.

Most Maltese retailers build a SKU from three to five short segments — category, brand or supplier, a size or variant code, a colour code, and sometimes a sequential number — joined by hyphens. The result usually lands between 6 and 15 characters: long enough to be meaningful, short enough to read on a shelf label or packing slip at a glance.

SKU vs EAN, UPC, GTIN, serial and batch numbers

These terms get mixed up constantly, and the confusion causes real stock-control mistakes, so it's worth being precise. An EAN (part of the wider GTIN family) is a globally unique barcode number issued through GS1 Malta. It identifies a product to any retailer and supplier on the planet. You can't make one up; GS1 licenses company prefixes and you assign numbers within your own block.

A SKU has none of that infrastructure. You invent it, it only has to be unique inside your own systems, and it can (and often should) encode information the EAN never will — which supplier you bought it from, which season it belongs to, or where it sits in your own category tree. Amazon and eBay call your SKU the "seller SKU" or "custom label" precisely because it's yours to define, layered on top of their own listing ID and any EAN the product carries.

Serial numbers are different again: they identify one individual unit (useful for electronics, tools and anything under warranty), while a batch or lot number identifies a production run. A SKU sits above both — one SKU can cover thousands of units across many batches and serial numbers.

Step-by-step: designing your own SKU naming convention

Worked example for a small Maltese retailer: category "Hoodie" → HOO, brand "Nova" → NOV, size "Medium" → M, colour "Charcoal" → CHR, giving HOO-NOV-M-CHR. Add a two-digit batch suffix if you restock the same combination from a different supplier later — HOO-NOV-M-CHR-02.

1. List the attributes that actually help you find stock fast. For most shops that's category, brand or supplier, size, and colour — resist the urge to add more than four or five, or the code becomes unreadable.
2. Decide an abbreviation rule per attribute. "Hoodie" might become "HOO" (first three letters), "Extra Large" might become "XL" (an initials rule), and a colour list might use a fixed custom mapping so "Charcoal" always shortens to "CHR", never "CHA" one week and "CHR" the next.
3. Pick one separator and stick to it. A hyphen is the safest universal choice — it survives copy-paste into Excel and most marketplace bulk-upload templates without being reinterpreted as a formula or a date.
4. Add a sequential number if two products could otherwise collide. Zero-pad it (001, 002…) so the codes sort correctly in a spreadsheet.
5. Decide on a maximum length before you generate anything. Marketplace fields have hard limits, and a 40-character SKU isn't more informative than a 14-character one — it's just harder to read on a shelf.

Best practices — and the mistakes that come back to bite you

• Avoid the letter O and the digit 0 together, and the letter I or lowercase l next to the digit 1 — on a printed label these are genuinely hard to tell apart. This generator flags both automatically.
• Never start a SKU with a zero. Excel and Google Sheets silently strip leading zeros when a cell is treated as a number, turning "007-BLU" into "7-BLU" the moment someone re-opens your export.
• Don't encode information that changes — a supplier's cost price or a shelf location. Both change independently of the product itself.
• Keep the format identical across your whole catalogue. A SKU scheme that's 8 characters for one category and 14 for another looks fine until you try to sort a spreadsheet by SKU and the columns don't line up.
• Stick to A–Z, 0–9, hyphens, underscores and full stops. Spaces and special characters cause silent failures in CSV imports on most marketplace bulk tools.

Marketplace-specific SKU rules for Malta-based sellers

Amazon (typically Amazon.it or Amazon.co.uk for cross-border Maltese sellers) Seller Central: the "Seller SKU" field allows up to 40 characters, and Amazon strongly recommends avoiding characters outside letters, numbers and hyphens — special characters have historically caused listing feed errors.

eBay: the equivalent field is the "Custom Label", limited to 50 characters, used purely for your own inventory management and never shown to buyers — the ideal place to drop your full internal SKU regardless of which regional eBay site you list on.

Maltapark and other local classifieds/marketplace platforms typically have no formal SKU field, but keeping a consistent internal SKU across every channel you sell on — including informal ones — is what actually prevents stock discrepancies.

Because many Maltese sellers list cross-border into both the UK and EU (Amazon.it, Amazon.co.uk, eBay), GS1 Malta remains the authority for the underlying EAN — the SKU and the EAN work as complementary, not competing, identifiers across every marketplace.

Bulk workflow: from spreadsheet chaos to a clean variant matrix

The single biggest time cost in SKU management is entering size/colour combinations one at a time. If you stock 4 sizes and 5 colours across 3 styles, that's 60 SKUs — manageable in this tool in under a minute, because entering "S, M, L, XL" once against Size and all five colour names once against Colour generates every combination automatically as a true cartesian matrix, not a queue of single-item forms.

Once generated, sort the results table by any column to spot-check a size run, copy the whole set to your clipboard, or export to CSV or Excel. The Excel export writes every SKU as text, not a number, so codes with leading digits or hyphens import into your inventory system or a marketplace bulk-upload template exactly as generated.