Almost every reseller hits the same wall. The first 50 items live happily in a closet. Somewhere past 150, you start digging through bags to find a sold item, relisting things you already sold, and losing track of what you paid. The fix isn't a bigger closet. It's a system.
This guide sets up a system with three parts: a SKU on every item, labeled storage, and one spreadsheet that holds the truth. It costs almost nothing and scales to thousands of items.
The goal: answer four questions in seconds
A good inventory system lets you answer these, for any item, almost instantly:
- Do I have it? Is it still in stock, or sold?
- Where is it? Which bin, shelf, or rail?
- Where is it listed? Which marketplaces, and at what price?
- What did it cost me? So you know your real profit when it sells.
If your current setup can't answer all four, the steps below will help.
Part 1: Set up labeled storage
Pick storage you can label and expand:
- Clear plastic bins with numbered labels (B01, B02…), the most popular option for clothing and small goods.
- Shelving units with labeled shelves (S1-A, S1-B…) for shoes, home goods, and boxes.
- Garment rails with numbered sections for items that wrinkle or need hanging.
Label the outside of every container clearly and keep the numbering simple. You'll be reading these labels in a hurry when something sells.
Part 2: Give every item a SKU
A SKU is a short, unique code for one item. The most practical reseller format includes a category, a location, and a number:
OUT-B07-0142 means outerwear, in bin 7, item number 142.
Write the SKU on a tag or sticker attached to the item, and put it in every listing (in a SKU field or at the end of the description). Generate a batch with the free SKU generator, and read the full SKU system guide for rules and edge cases.
Part 3: Keep one master spreadsheet
One row per item. These are the columns that matter most:
| Column | Why it matters |
|---|---|
| SKU | The unique key that ties everything together |
| Title, category, brand, size | So you can search and filter |
| Cost and acquired date | For real profit and spotting stale stock |
| Location | So you can find it fast |
| Listed on and listing URLs | So you know what to end when it sells |
| Status | To list, Listed, Sold, Shipped, Returned, Donated |
| Sale price, fees, shipping, net profit | Your real numbers |
Our free inventory spreadsheet template has all 21 columns ready to go, with three example rows.
Example rows (fictional)
| SKU | Title | Cost | Location | Status |
|---|---|---|---|---|
OUT-B07-0142 | Denim trucker jacket, M | $9.00 | B07 | Sold |
SHO-S02-0031 | Leather ankle boots, 8 | $15.00 | S02 | Listed |
MED-M01-0207 | Hardcover cookbook | $1.00 | M01 | To list |
Part 4: The routines that keep it accurate
A system is only as good as the habits behind it.
When you bring new inventory home
- Clean, check, and sort items.
- Assign SKUs and attach tags.
- Add a row for each item with cost and source.
- Put them in a "to list" bin.
When you list an item
- Move it from "to list" to its permanent bin and record the location.
- Record each marketplace and listing link as you publish.
When an item sells
- End it on every other marketplace.
- Update status, sold date, price, fees, and net profit.
- Pull it from the bin and pack it.
Once a week
- Spot-check a few bins against your sheet.
- Sort by acquired date to find stale items for a refresh or markdown.
- Check that every "Listed" item really is live where you think it is.
Common inventory mistakes
- Reusing SKUs. Once a SKU is used, retire it forever, even after the item sells.
- Moving items without updating the location. If you move an item between bins, update the sheet right away.
- Forgetting the cost. "I'll add it later" usually becomes "never." Record cost when you bring items home.
- Splitting the truth. One master record beats notes spread across apps, receipts, and memory.
When a spreadsheet stops being enough
Spreadsheets work well for a long time. You've outgrown yours when updating it takes longer than listing, when it regularly falls behind your marketplaces, or when you've sold the same item twice. That's the problem Swifty is being built for: an inventory-first workspace where each item's listings and sales live with the item itself. It's in development, and you can 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