Organisation

The SKU: the unique reference that finds any item in 10 seconds

15 October 2026 · 6 min read

At 30 live items, you remember everything. At 150, you search. At 400, you spend evenings digging through bins wondering whether "the grey jumper" sold yesterday is the one in box A or box C. Retail solved this long ago: the SKU — one unique reference per item. Here's how to set it up in an afternoon, and why it pays back far more than time.

The principle: one number, three places

A SKU is a simple sequential number — #1287 — assigned to each item the moment it enters stock, present in three places:

  • In the listing title, at the end ("Lacoste wool jumper grey M #1287"): discreet for the buyer, instant for you.
  • On the physical item: a label or card slipped in with the garment in its bin.
  • In your tracking (tool or register): purchase price, source, entry date.

A sale lands? The title gives the number, the number gives the bin, the bin gives the item. Ten seconds, even at 500 references — and zero shipping mix-ups, the number-one cause of "item not as described" disputes.

The three rules that make it hold

1. Sequential, never meaningful. Resist the clever code ("JUM-GRY-M-24"): it needs decoding, it changes when the item changes, and no two people build it the same way. An incrementing counter never lies. 2. Never reused. An assigned number is burned, even once the item is sold or withdrawn — a recycled SKU sooner or later ends up on two different garments, and your history becomes unreadable. 3. Assigned at intake, not at listing. Stock entry creates the reference: items not yet photographed already have one, and nothing gets lost between purchase and going live.

The hidden bonus: bookkeeping follows for free

The SKU isn't just about bins. It's the key linking a sale to its purchase price: when sale #1287 lands, you know exactly which cost to attach — so your margin is right, item by item. And in consignment, a suffix with the consignor's initials ("#1287sev") tells you at a glance whose piece it is and who gets a share.

Starting with existing stock? Don't label 300 items in one go: apply the system to new intakes from today, and catch up old stock as it sells. Within three months, most of your live stock is covered, without sacrificing a weekend.

Where Fripilot builds on it

Fripilot reads the SKU in your listing titles and uses it as a backbone: finding an item, matching a sale to its purchase price, tracking a consignor's stock — everything runs through that reference. If you adopt one organisational habit this year, make it this one. Free 30-day trial, no card required.

Fripilot does it for you

Sales sync, margins, accounting, invoices — automatically. Start with a 30-day free trial.

Start for free →
← All articles
With your consent, we use Microsoft Clarity and Metricool to measure how the site is used. The app's session cookie is strictly necessary. Cookie and privacy details
Fripilot — Any questions?