You open Seller Hub on a Sunday night. It says you sold 14 items this month for $612. That sounds great until you try to answer three simple questions: What did those 14 items cost you? How many things are still sitting in bins in the garage? And after fees and labels, how much of that $612 did you actually keep?
eBay is very good at showing what sold. It's not built to show what you paid, what's aging on the shelf, or your true profit. That gap is what managing eBay inventory is really about. This guide walks through a simple manual system any seller can run, whether you have 20 listings or 2,000.
What eBay inventory management actually covers
Most people think "inventory" means knowing how many of something you have. For a reseller, it's three records that have to agree with each other:
- What you bought — item, date, where, and what you paid (your cost basis).
- Where it is — unlisted, listed, sold, shipped, returned, or written off.
- What it made — sale price, shipping collected, eBay fees, label cost, and profit.
eBay only holds pieces of #2 and #3, and only after an item is listed. Your cost basis never enters eBay at all. If you don't record it the day you buy, it's gone. A pile of receipts in a shoebox won't tell you which $4 thrift find became which $45 sale six weeks later.
Step 1: Give every item an ID the day you buy it
Before anything gets photographed, give it a short code and write it somewhere you'll see it: a sticky note, a bin label, or the eBay "Custom label (SKU)" field when you list.
A good SKU tells you where to find the item and when you bought it. For example:
B07-0926-03
bin 7 · bought Sept 26 · 3rd item from that haul
You don't need anything fancy. If you'd rather not invent a format, the free 3Dsellers SKU generator builds consistent codes from attributes you choose and exports them to a spreadsheet.
The point is that the same code follows the item from purchase, to listing, to sale. That's what lets you match a completed sale back to what you paid.
Step 2: Record cost basis, including lot splits
Write down what you paid on the day you buy. Include anything you spent to make the item sellable, like cleaning supplies or a replacement part.
Bulk buys need one extra step. If you pay $30 for a box of eight items, don't book $30 against whichever item sells first. Spread it across the box. The simplest way is equal shares ($3.75 each). A better way, if some pieces are clearly worth more, is to split by what you expect each to sell for.
You buy a box for $30. Inside: one jacket you expect to sell for $60, and seven small items you expect to sell for $10 each ($70 total). Total expected value is $130.
- Jacket: $60 ÷ $130 × $30 = $13.85
- Each small item: $10 ÷ $130 × $30 = $2.31
Check: $13.85 + (7 × $2.31) = $30.02. Round one item down a cent so the lot adds to exactly $30.00.
Step 3: Track status, not just quantity
Every item should always be in exactly one status. Keep the list short:
| Status | Meaning |
|---|---|
| Unlisted | Bought, not yet photographed or posted |
| Listed | Live on eBay (note the date listed) |
| Sold | Paid for, not yet shipped |
| Shipped | Label printed and dropped off |
| Returned | Back with you; decide relist or write off |
| Written off | Damaged, donated, or unsellable |
The date you listed an item matters more than most sellers think. It lets you see what has been sitting for 60 or 90 days. That's money tied up in stock that isn't working. Aging items are where price drops, offers, or a bundle make the most sense.
Step 4: Record completed sales with real fees
When an item sells, record the full picture, not just the sale price. For most US categories, eBay's final value fee is 13.6% of the total amount of the sale plus a per-order fee ($0.30 on orders of $10 or less, $0.40 above that). The total amount of the sale includes the item price, shipping you collected, and sales tax. Some categories use different rates. Books, for example, are higher, so check your category.
That tax detail trips people up. You never keep the sales tax, but eBay still charges its percentage on it.
A jacket from Step 2 (cost $13.85) sells for $45.00. The buyer pays $8.00 shipping and 6% sales tax.
- Total amount of the sale: ($45.00 + $8.00) × 1.06 = $56.18
- Final value fee: 13.6% × $56.18 + $0.40 = $7.64 + $0.40 = $8.04
- Shipping label you bought: $7.20
Profit: $45.00 + $8.00 − $8.04 − $7.20 − $13.85 = $23.91
That's about 53% of the $45 item price. Without the cost basis from Step 2, you'd have no way to know the real number.
If you'd like to check the fee side before you list, these free eBay fee calculators do the math for you:
- Poshwatch eBay fee calculator
- eBayFeesCalculator.com US calculator
- FinalFeeCalc
- 3Dsellers US eBay fee calculator, which can also suggest a price from your cost and target margin
- ZIK Analytics eBay fee calculator
- Easync eBay fees calculator
Fee calculators handle one item at a time. Your inventory records are what connect that one sale back to what you paid and forward to your monthly totals.
Step 5: Review your inventory once a month
A 15-minute monthly check keeps small problems from growing. Look at four numbers:
- Items bought vs. items sold. If you're buying faster than you sell, your stock (and the cash tied up in it) keeps growing.
- Sell-through rate. Items sold this month ÷ items that were listed during the month. If 12 of 40 listed items sold, that's 30%. Compare month to month rather than chasing a universal "good" number.
- Aging stock. Count items listed more than 60 days. Decide on each: drop the price, send offers, bundle, or pull it.
- Profit, not revenue. Add up profit from your completed sales, not the gross from Seller Hub.
If you want to see how items like yours sell across eBay before you buy more, research tools like ZIK Analytics show sold-listing data for a category. Treat that as research, and your own records as the truth about your business.
eBay inventory management software vs. a spreadsheet
A spreadsheet works fine at first. It gets harder as you grow, for a few common reasons:
- Lot splits need formulas that break when you add a row.
- Status changes happen on your phone at the post office, not at your desk.
- The fee math has to be rebuilt every time eBay changes its rates.
Listing tools such as 3Dsellers focus on the eBay side: creating, editing, and managing listings in bulk. What they don't hold is your purchase history and cost basis from before an item was ever listed. Whatever you use, make sure it records cost at purchase. That's the one thing eBay can't give you later.
For a broader look at the same system across every marketplace, not just eBay, see our guide on reseller inventory tracking.
FAQ
Does eBay track my cost of goods?
No. eBay records sale prices, fees, and shipping labels bought through eBay. It doesn't know what you paid for an item. You have to track cost basis yourself.
What should I use as a SKU on eBay?
Anything short and unique that tells you where the item is. A bin number plus purchase date plus a sequence number works well. Put it in the Custom label (SKU) field when you list.
How often should I review my eBay inventory?
Monthly is enough for most part-time sellers. Weekly is better if you buy large lots or list more than a few dozen items a week.
Upcyclist records cost basis the day you buy, tracks each item's status, and logs completed sales with fees and shipping so profit is calculated for you. Set a margin target in settings and use the inventory planner to see which items are on track and which are falling short, before they sit on the shelf for 90 days.
Once you're tracking profit per item, the next question is whether that profit is actually good. That's where margin and ROI come in, and they're easy to confuse. Our guide on profit margin vs. ROI breaks down the difference and how to use each one when you're deciding what to buy.
