Reselling Guides
How to Organize Reselling Inventory So You Can Find Any Sold Item Fast
How to organize reselling inventory with a SKU and bin system, so every item you sell has one numbered home you can walk to in under a minute.
Something sells at eleven at night. It is a polo you bought at an estate sale five weeks ago, and you have a handling clock running on it now. You know it is in the house. You have no idea which tub.
Everybody hits this wall at the same place. Around thirty or forty active listings, memory stops working. You start opening bins at random, you find the item eventually, and you tell yourself you will get organized later. Later never has a spare Saturday in it.
The fix is not a bigger shelf or a better app. It is a code on the listing that points at a number on the shelf.
The system is two halves that have to match
Half one is physical. Every place an item can sit gets a permanent number.
Half two is digital. Every listing carries that number in a field only you can read.
When those two halves agree, finding a sold item stops being a search. You open the order, read the code, and walk to the spot. That is the whole idea, and it works the same whether you have forty items or four hundred.
Number the shelf first, not the item
This is the step people get backwards. They start labeling items, run out of steam, and end up with half a system that nobody trusts.
Number the locations instead. There are far fewer of them, you do it once, and the numbers never change again.
Pick a scheme and be boring about it. Letters for the shelf or rack, numbers for the position on it. Bin A1 is the top left bin on rack A. Bin C4 is the fourth bin on rack C. Write the number on the front of the bin big enough to read from across the room, and write it somewhere it will not peel off the first time you slide the bin back in.
One rule holds the whole thing together: the number belongs to the spot, not to what is in it. Bin A1 is bin A1 forever. Today it holds a windbreaker. Next month it holds a pair of cleats. The label never gets rewritten, which means it never gets out of date.
Write a SKU that tells you three things
A SKU is just a short code you make up. Make it earn its space. The version that pays for itself carries the location, the month you bought it, and what you paid.
| SKU | Reads as |
|---|---|
| A1-0704-05 | Bin A1, sourced July 4, cost five dollars |
| C4-0621-12 | Bin C4, sourced June 21, cost twelve dollars |
| R2-0715-03 | Hanging rack R2, sourced July 15, cost three dollars |
The location gets the item in your hands. The date tells you how long your money has been sitting in it, which is the number that should drive your markdowns. The cost tells you your floor the moment a lowball offer comes in, without opening a spreadsheet or guessing.
Keep it short and keep the format identical every time. A code you have to think about is a code you will stop writing.
Where the code goes on the listing
On eBay the field is called Custom Label, and it sits with the title. In the listing form, open the title options and switch on Custom Label (SKU), and it appears in a box just under the title. eBay covers the listing form itself on its creating and managing listings help page. The important part for this system is that Custom Label does not show on your live listing page, so a cost code inside it is yours alone. It does surface on your own sold and awaiting-shipment screens, which is exactly where you need it at eleven at night.
Other apps vary. Some give you an internal SKU field, some give you nothing. Where there is no field, the last line of the description works fine. A short code at the bottom of a description reads as inventory shorthand to anybody who notices it, and it costs you nothing.
One spreadsheet, five columns, no more
You do not need software for this. You need a sheet you will actually update.
| Column | What goes in it |
|---|---|
| SKU | The code, exactly as it appears on the listing |
| Item | Brand and item in four words, enough to recognize it |
| Location | The bin or rack number |
| Cost | What you paid, before anything else |
| Status | Listed, sold, shipped, or returned |
Five columns is the ceiling on purpose. Every column you add is another thing to fall behind on, and a sheet that is two weeks stale is worse than no sheet at all because you will trust it and be wrong.
Handle the things that do not fit a bin
Some of it will never go in a tub. Jerseys and jackets creased in a bin come out looking like they were stored in a bin. Tap handles, framed pieces, and anything rigid take up a bin they do not need.
Give those a numbered home too. Hang the clothes on a rack and number the rack sections the same way you numbered the shelves. Put the awkward items on an open shelf with its own letter. The scheme does not care what shape the storage is, only that every spot has one name.
Label at intake, not at listing time
The habit that keeps this alive is small. Nothing goes onto a shelf without a number on it.
You get home from sourcing, you clean and check the item, you assign it a bin and write the code on a piece of masking tape stuck to the tag. That happens before it is photographed and before it is listed. By the time you write the listing, the SKU already exists and you are just copying it into a field.
Do it in the other order and it never happens. The listing goes live, the item goes on a pile, and you are back to opening tubs.
What this actually buys you
Two things, and neither of them is tidiness.
The first is shipping speed. Late shipments are one of the few own goals in this business that show up in your seller metrics, and most of them are not laziness. They are somebody who could not find the item.
The second is honest markdown decisions. When the date is right there in the SKU, you can see that a jacket has been sitting since June without running a report. Cash stuck in a bin is not inventory, it is just cash you cannot spend.
Set up the shelf numbers this weekend. Write a SKU on the next thing you list. The system only has to be built once, and it never needs to get more complicated than this.
Hero photo by seanmfreese, used under CC BY 2.0.
