SKUs, locations and status: a lightweight way to keep track of what you have, where it is and what sold.
Somewhere around the twentieth item, every reseller has the same moment: a buyer asks about the blue lamp, and you have no idea which bin it is in, whether it is still listed on Mercari, or what you said the price was. That is when you need an inventory system. It does not have to be complicated.
Give every item a short ID
A simple code like YSD-0001, YSD-0002 is enough. Write it on a piece of painter’s tape on the item and in your notes. It connects the physical item to its listing, its photos and its price.
Track a handful of fields
A spreadsheet with these columns covers most needs:
- ID
- Item name
- Where it is stored (bin, shelf, corner of the garage)
- Cost, if you paid anything
- Asking price
- Where it is listed, with links
- Status: not listed, listed, pending, sold
- Date listed and date sold
- Final sale price and fees
Keep private details like what you paid or who consigned an item in your own sheet, not in public listings.
Name your storage spots
Label shelves and bins with letters or numbers. “Shelf B, bin 3” beats “somewhere in the back.” Five minutes with a marker saves hours of digging.
Update status the moment it changes
The biggest inventory mistake is selling something in one place and forgetting to remove it from another. When something sells or goes pending, update the sheet and every listing right then.
Review once a week
Sort by date listed. Anything sitting a long time gets a decision: new photos, lower price, bundle it, or donate it. Weekly reviews keep dead stock from quietly eating your space.
Photos in folders by ID
Name your photo folders with the item ID. When you relist on another platform, everything is in one place.
Why most resellers avoid inventory tracking
Inventory systems sound boring, and for small sellers they can feel unnecessary. You can remember ten items. But somewhere around twenty-five, memory starts to fail. You forget what you listed where, what you agreed to with a buyer, or whether that lamp is in the garage or the hall closet. By the time you realize you need a system, you are already behind.
The good news is that starting a system takes less than an hour, and maintaining it takes a few minutes per item. The time it saves pays for itself quickly.
Paper, spreadsheet or app?
There is no single right tool. The best system is the one you will actually use.
- Paper notebook: simple and always available, but hard to search and easy to lose. Works for very small sellers.
- Spreadsheet: flexible, searchable, sortable and free. Google Sheets works on your phone and computer. This is the best choice for most small resellers.
- Dedicated reselling apps: some offer cross-listing, inventory tracking and sales reports. They can save time at higher volumes, but they often have monthly fees.
Start with a spreadsheet. If you outgrow it, you will know exactly which features you need, and you can choose an app with confidence.
Setting up the physical space
An inventory system is only as good as your storage. A few simple steps make a big difference:
- Use uniform bins. Matching clear bins stack neatly and let you see contents.
- Label everything. Each shelf and bin gets a simple code, such as A1, A2, B1.
- Separate by status. Keep areas for “to process,” “listed” and “sold, awaiting pickup.”
- Keep a processing station. A table with cleaning supplies, tape, markers and your photo setup.
- Leave a clear path. If you have to move three boxes to reach one item, you will avoid doing it.
Tracking items through their life cycle
Every item moves through the same stages: acquired, processed, listed, sold, picked up or shipped. Your spreadsheet’s status column should reflect these stages. Updating the status as each item moves forward lets you see at a glance:
- How many items are waiting to be processed
- How many are listed and for how long
- Which sales still need pickups or shipping
- What sold this week and this month
Filtering by status turns a long list into a simple to-do list.
Handling consignment items
If you sell items for other people, your inventory system becomes even more important. For each consigned item, track the owner, the agreed price range, the commission or split, the date received and the agreed timeline. Keep this information private, separate from public listings. When an item sells, record the sale price and the payout owed, and keep a record of payments. Clear records protect both you and the people who trust you with their belongings.
Monthly reports that actually help
Once a month, take fifteen minutes to look at your numbers:
- Total sales and total profit
- Number of items sold
- Average days to sell
- Best-selling categories
- Items listed longer than 30 or 60 days
These numbers tell you what to source more of, what to stop buying, and what needs a price drop or a new listing. Over time, they show whether your side business is growing and whether it is worth the time you are putting in.
Keep it simple and keep it going
The most common reason inventory systems fail is that they get too complicated. If updating your spreadsheet feels like a chore, simplify it. Remove columns you never look at. Use dropdown menus for status and category. Update it at the same time each day, such as when you check messages. A simple system you maintain is far better than a perfect system you abandon after a month.
A sample row
YSD-0042 · Lasko 20" box fan · Shelf B, bin 3 · Cost $0 (own) · Ask $25 · Marketplace, group · Listed 10/02 · Sold 10/05 · $22 · Fees $0
One line tells you everything: where it was, what it sold for, how long it took. Multiply that by a hundred items and you can see exactly which categories are worth your time.
What to do with the data
After a month or two, sort sold items by days to sell and by profit. Patterns appear quickly. Maybe small electronics sell in days and furniture takes weeks. Maybe one platform consistently brings better prices for tools. Use those patterns to decide what to source, where to list, and what to stop bothering with.
Questions we hear about inventory
How many items before I need a system?
Many sellers say they wish they had started at around fifteen to twenty items. Starting early is easier, because you build the habit before the backlog grows.
What is the most important column to track?
Location. Knowing exactly where an item is stored saves more time than almost anything else. Status is a close second.
Should I track items I donate?
Yes, briefly. Marking them as donated keeps your records complete, shows how much inventory you are giving away, and can help with tax records if you itemize charitable donations. Ask a tax professional about what documentation you need.
How do I handle items with multiple pieces?
Give the set one ID and list the pieces in a notes column. If pieces are stored in different places, note each location. When selling, check the list so nothing gets left behind.
What if I fall behind on updating it?
Do a quick catch-up session: walk through your storage, update locations and statuses, and remove sold items. Then make updating part of a daily routine, such as when you check messages in the evening.
Can I share my inventory sheet with a partner or helper?
Yes, and shared spreadsheets make teamwork much easier. Decide who updates what, and keep private details like costs and consignor information in a separate tab that only the people who need it can see.
Key takeaways
- Give every item a short ID and label it physically.
- Start with a simple spreadsheet; upgrade only when you know what you need.
- Track location and status above everything else.
- Label shelves and bins, and separate items by stage.
- Update status the moment something sells or goes pending, everywhere it is listed.
- Keep private details like cost and consignor information out of public listings.
- Review stale items weekly and your numbers monthly.
An inventory system is less about software and more about habits. A few minutes a day keeps your space organized, your buyers happy and your business decisions grounded in real numbers.
Letting AI handle the setup
If spreadsheets are not your thing, an AI assistant can help you design one: the columns, formulas for profit and days listed, even simple conditional formatting so stale items turn red. Describe how you sell and what you want to track, and ask for step-by-step instructions for Google Sheets or Excel. It can also help you write a quick weekly review checklist. The more specific your request, the less cleanup you will do afterward.
Got a storage find you want to sell, or something specific you are hunting for? Tell us what you have or join the local Facebook group.