Numbering The Backlog: How To Put SKUs On The Items You Already Listed

# Numbering The Backlog: How To Put SKUs On The Items You Already Listed

Most SKU advice starts on day one: number everything as it comes in, and you will never lose an item again. Good advice, and useless to the seller who is reading it with four hundred items already live and none of them numbered. This is for that seller. The backlog is the hard part, and it is more doable than it looks.

Why The Backlog Is Different

A new item gets its number at the same moment it gets its photos, so the habit costs nothing. The backlog has no such moment. Every item is already photographed, already written, already on a shelf somewhere, and numbering it means going back to it on purpose. That is why it never happens: it is a project, and projects wait.

The fix is to stop treating it as one project. Treat it as a series of short passes, each one small enough to finish in a sitting, each one leaving the catalog a little more findable than before.

Decide The Shape Of The Number First

Do not start typing until the shape is settled, because changing it halfway is worse than not starting. Two rules do most of the work.

Keep a letter prefix that says where the item lives. A shelf letter, a tote letter, a room letter, whatever matches how your space is actually laid out. The prefix is the part that tells you which direction to walk.

Keep the number sequential inside that prefix, and never reuse one. V1341 is followed by V1342, and when V1341 sells its number retires with it. Sequential numbers are the whole reason the system works on the sold side: a packing list sorted by SKU walks the shelf in order.

Resist the urge to encode anything else. Category codes, condition codes, purchase dates: every extra field is another thing to look up and another way to make a typo. The number's only job is to find the item.

Work The Backlog By Shelf, Not By Catalog

The mistake is to open the catalog at the top and start numbering down the list. The list is in some arbitrary order, the items are all over the house, and by item forty you are hunting.

Instead, stand at one shelf. Everything on that shelf gets that shelf's prefix, and you number it left to right, top to bottom, the way you would read it. Find each item in the catalog as you touch it, give it the next number, put a sticker or a tag on the physical item, move on. One shelf is one pass. When the shelf is done, the catalog and the shelf agree, and that shelf is finished forever.

Twenty or thirty items a pass is plenty. Four shelves a week and a big backlog is gone in a month without a single long night.

Tag The Physical Item Every Time

The number in the catalog is half the system. The other half is on the item. A small label on the case, a tag on the bag, a marker on the tote lid. If you number the catalog and not the shelf, you have built a lookup that only works in one direction, and the direction you need on shipping day is shelf to catalog.

Cheap address labels and a fine marker are enough. Consistency matters more than the label stock.

Let The Tool Do The Counting

The slowest part of numbering by hand is the counting itself: what was the last number, did I already use this one, did I skip one. Any tool that hands out the next number for you removes that entirely, and it is the difference between a pass that takes an evening and a pass that takes twenty minutes.

In FlipPress, Sequential Mode in Batch Edit does exactly that on the web app: search, tap, and every item gets the next SKU. Set a prefix and a starting number, save a new prefix mid-way when you move to the next shelf, tap Done. The numbers are saved to your FlipPress listings in the order you picked them, so a shelf pass is a search-and-click loop instead of a typing loop. One thing to know so you plan the backlog correctly: that number lives on your FlipPress listing, and any SKU field on the live marketplace listing itself is a separate edit.

What Changes Once The Backlog Is Numbered

Sold items get pulled in shelf order instead of in memory order. A missing item becomes a five-minute search instead of a Saturday. A helper can pack from a list without knowing your inventory. And the next lot you bring home gets its numbers the moment it gets its photos, because the system it slots into already exists.

Start with the shelf nearest the door. Number it tonight. That is the whole first step.