eBay Inventory Management for Resellers: SKUs, Bins, and Stock Counts

When you have 30 items, you can remember where everything is. At 300, you can't. At 3,000, a missing item means a cancelled order, a defect on your seller record, and an unhappy buyer. A simple inventory system prevents all of that — and it also makes accurate profit tracking possible.

How should you format SKUs?

A SKU should tell you something useful at a glance. A common format combines a location and an item number:

• B12-0457 → bin 12, item 457
• S3-A-0102 → shelf 3, row A, item 102

Some sellers add source or date codes (EST-2610-B12-0457). Keep it short enough to write on a label and type quickly. Put it in eBay's Custom label (SKU) field so it appears on orders and packing slips.

How should you organize physical storage?

• Numbered bins or shelves — the number is part of the SKU.
• Similar sizes together to use space efficiently.
• Clear bags or labeled bags for small items, with SKU and cost written on them.
• Separate areas for unlisted, listed, sold-awaiting-shipping, and returns.
• Separate stock per store or client if you run multiple accounts — see managing multiple accounts.

What is a good intake workflow?

1. Receive: unpack, inspect, and set aside anything unsellable.
2. Record cost: enter item cost — or allocated lot cost — against the SKU. See tracking COGS.
3. Photograph using a standard shot list.
4. List with the SKU in the custom label field.
5. Shelve in the bin shown in the SKU.

Batching each step (photograph 30 items, then list 30) is much faster than doing one item at a time.

How often should you count inventory?

Do a full count at least once a year (often at year-end for tax purposes — see year-end checklist) and spot-check a few bins every month. Counts find:

• items listed but missing from shelves (fix before they sell),
• items on shelves that were never listed,
• items in the wrong bin.

How do you handle aged inventory?

Each month, pull a list of listings older than 90 days and decide for each one:

• Reprice using current sold comps.
• Improve the listing — title, specifics, photos.
• Promote with a low ad rate or a markdown — see promotions.
• Bundle into a lot.
• Clear out by donating or selling locally, and write off the cost.

Aged inventory ties up cash and space, which hurts your cash flow.

When do you need inventory software?

A spreadsheet plus SKUs works for most solo resellers. Once you hold multi-quantity stock, sell on several channels, or run a warehouse for clients, you'll want a system that updates stock automatically when orders come in. MyOrderProfit's warehouse module (Enterprise and Unlimited plans) adds SKU-based inventory tracking, barcode scanning, purchase orders, fulfillment workflow, and returns restocking, with inventory updating as orders are fulfilled. For 3PL operations, see 3PL fulfillment.