How to Create a Reseller SKU System That Scales

Formats, category codes, bin locations, and the edge cases (moves, returns, lots) that trip resellers up.

3 min readUpdated November 22, 2026By the Swifty team

A SKU (stock keeping unit) is a short code that uniquely identifies one item in your inventory. For a reseller, a good SKU does two jobs: it tells you what an item is and where to find it. Get the format right early and it'll still work when you have thousands of items.

Three SKU formats, and when to use each

FormatExampleBest for
Number only0142Very small inventories. Simple, but tells you nothing.
Location + numberB07-0142Most resellers. Instantly tells you where the item is.
Category + location + numberOUT-B07-0142Growing inventories across several categories.

Some sellers add a source or date code, such as OUT-B07-2611-0142 for an item acquired in November 2026. That's useful for spotting stale inventory, but longer SKUs are harder to read and type. Add parts only if you'll actually use them.

Rules for SKUs that don't break

  • Unique forever. Never reuse a SKU, even after the item sells. Your sales history depends on it.
  • Fixed length per part. Always three letters for category, always three characters for bin, always four digits for the number. It keeps everything sortable.
  • Zero-pad numbers. Use 0042, not 42, so 42 sorts before 142.
  • Letters, numbers, and one separator only. Skip spaces, slashes, and special characters, which some systems reject.
  • Avoid look-alikes such as O/0 and I/1 in your category codes.
  • Short enough to fit. Aim for 8–14 characters so it fits on a small label and in listing fields.

Choosing category codes

Use a short list you can remember without looking. Here's a starting point for a clothing-focused reseller:

CodeCategoryCodeCategory
TOPTops & teesSHOShoes
BTMJeans, pants & shortsBAGBags & accessories
OUTJackets & coatsHOMHome & decor
DRSDressesMEDBooks, media & games

Keep the list under about 12 codes. If you need more, you're probably being too specific. Put the detail in the title instead.

Location codes and labels

Number your bins, shelves, and rails, and use those numbers in the SKU:

  • Bins: B01, B02, B03…
  • Shelves: S1A (unit 1, shelf A), S1B…
  • Rails: R01, R02…

Print labels for the outside of each container, and keep a small tag on each item with its full SKU. Hanging tags or removable stickers on the bag work well. Avoid writing on the item itself.

Edge cases that trip people up

When you move an item to a different bin

You have two options. Keep the SKU and update the location field in your sheet. This is simpler, and best if your listings already include the SKU. Or re-SKU the item, which keeps codes accurate but means updating every listing. Most resellers keep the SKU and treat the location column as the source of truth for where an item is now.

Returns

When an item comes back, keep its original SKU, set status to "Returned," inspect it, then relist it. You'll keep the full history of that item in one row.

Lots and bundles you buy

Give each item from a lot its own SKU, and split the lot's cost across the items. Equal shares are fine if you're not sure. You can also note the lot in the Source column (e.g. "Lot 2026-11-03") to see later whether that lot was worth it.

Multiples of the same item

If you have several identical new items, one SKU with a quantity is fine. For used items, give each its own SKU, because condition differs.

Put the SKU in every listing

Many marketplaces offer a private SKU or custom label field. If not, add it discreetly at the end of the description. Then searching any marketplace for the SKU finds the listing instantly. That's a lifesaver when you need to delist fast.

Get started in ten minutes

  1. Write your category code list.
  2. Number and label your storage.
  3. Generate your first batch with the SKU generator.
  4. Download the inventory template and paste the SKUs into the first column.

Swifty is being built around this idea: every item gets one record and one SKU, and all its listings and sales hang off it. It's in development, and you can join early access to follow along.

Swifty is being built for exactly this

We're building an inventory-first workspace for resellers. Join the early-access list for build updates. It's free, and there's no spam.

Join early access