An eBay Inventory System for Resellers: From Sourcing to Shipping
Most eBay inventory problems aren't about software. They come from items without a home and listings without a SKU. This loop fixes both.
The loop
Every item goes through the same seven steps. Skip one and it comes back to bite you, usually as an item you can't find after it sells.
- Intake → 2. SKU → 3. Location → 4. List → 5. Sell → 6. Pick & pack → 7. Record
1. Intake
New finds go to one intake spot, never straight onto a random shelf. Check condition, clean, test, and note the cost (what you paid) right away. Cost is the number you'll need at tax time and the one most resellers lose.
2. Give it a SKU
For one-of-a-kind items, a short SKU is enough: the month you sourced it plus a running number, like 2611-0042. Write it on a small tag or sticker on the item or its bag. The SKU builder can generate a batch at once.
3. Give it a home
Put it in a bin with an address, like RM-8-2, and write that address down with the SKU. If you don't have locations yet, set them up with the bin location guide and print labels with the label maker.
4. List it with the SKU and location
When you create the listing, enter your SKU in eBay's custom label (SKU) field. That field is private to you and you can search your active listings by it. Where you record the location is your choice:
- In the custom label, for example
2611-0042 RM-8-2. Private, and it travels with the listing. - At the end of the title, for example "... LOC RM-8-2". Very visible on order screens, but buyers see it and it costs title characters.
- In a spreadsheet or app keyed by SKU. Cleanest, but one more place to update.
If the item has a UPC, EAN, ISBN or a brand part number, add it as the product identifier. It helps your listing show up in product-based search. Read UPCs and GTINs explained.
5. When it sells
If the item is also listed elsewhere, delist it there first (see preventing overselling). Then print the shipping label. Sorting your awaiting-shipment list by custom label groups orders by location, which turns into a walking route through your stockroom.
6. Pick and pack
- Walk the route with your list, pulling each item and checking its SKU tag against the order.
- Pack at your packing desk, not at the shelf.
- Remove or cover old tags that could confuse the buyer.
7. Record and clean up
Mark the item sold in your records. Once a month:
- Look at your oldest listings and decide: refresh, discount, crosslist or let go. See turnover and slow stock.
- Spot-check a few locations against your records.
- Consolidate half-empty bins so space doesn't creep away.
Returns: inspect, re-tag if needed, put it in a bin, record the location, then relist. In that order.
Common questions
Where should I put my SKU on eBay?
In the custom label (SKU) field when you create or revise a listing. It's visible to you, not to buyers, and you can search your listings by it.
Should I put the bin location in the eBay title?
Some resellers add a short code like 'LOC A-2-3' to the end of the title so it shows on every order screen. It works, but buyers see it and it uses title characters that could hold search keywords. The custom label field is a private alternative.
How often should I check inventory against my eBay listings?
A quick weekly check of a few locations, plus a monthly look at items that have been listed longest, catches most problems.
Sources
Marketplace and GS1 rules change. Check the linked source before relying on a specific requirement or price.