How to set an alert price ceiling from eBay sold listings

The prices you see in a normal eBay search are what sellers hope to get. Some are realistic, many are optimistic, and a few are for listings that have sat unsold for months precisely because the price is wrong. Using them to set a ceiling means anchoring on the top of the market, and a monitor set that way alerts you to ordinary listings at ordinary prices, which is not what an alert is for.

Sold listings are what buyers actually paid. They include the bidding wars and the bargains, the sealed units and the ones that turned out to be missing a part, and taken together they describe the range within which the item really changes hands. A ceiling set a little under the middle of that range produces a feed of fair-to-good deals; a ceiling set well under it produces a feed of mispricings, which is what most people want when they set up an alert in the first place.

The other reason is trust. You will only act on alerts if experience has taught you they are worth acting on, and a ceiling derived from sold prices is one you tap on in the thirty seconds before someone else does.

Search for the item on eBay as precisely as you can: the model, the reference or the part number, and a disambiguator if the name is shared. On the results page, open the filters and tick Sold Items, which on most versions of the site also ticks Completed Items. Sold shows listings that ended in a sale; Completed shows everything that ended, including listings that did not sell, which is useful for a different question (what price the market rejected) but not for setting a ceiling. Use Sold.

Then narrow the set to match what you will be alerting on. Set the condition filter to the condition your monitor will use, because a sealed item and a used one have different ranges and mixing them produces a meaningless middle. Set the buying format to Buy It Now if your monitor is Buy It Now only, since auction results include the low-start bargains and the last-second wars that fixed-price listings do not. Sort by most recent, so you are looking at this month's market rather than last year's.

Note that sold prices show what the buyer paid for the item and, in a separate line, the shipping charged, and that Best Offer sales show the listed price with the accepted price struck through or hidden depending on the site version. Look at each result briefly rather than just the number: a sold price for a lot of three, a bundle with extras, or a misdescribed unit is not a comparable for a single item.

With ten to twenty recent sold results in front of you, write down the prices in order. The middle value of that ordered list is the median, and it is the number to use. An average is pulled up by a single bidding war and down by a single broken unit; a median ignores both and tells you what a typical sale looks like. If your list has an even number of entries, take the midpoint of the two central values.

Before taking the median, drop the results that are not comparable. At the top, remove bundles, sealed units in a used search, and auctions that ended in an obvious two-bidder war. At the bottom, remove for-parts units, listings that turned out to be an accessory, and anything with a title that suggests damage. What remains is the set of sales for the item you actually want, and its median is your reference price.

Then look at the spread. If the remaining prices sit within a narrow band, the market is stable and your ceiling can be set with confidence. If they are scattered across a wide range, the item's price depends on something you have not controlled for, such as storage tier, generation, or included accessories, and you should split the search until each subset is tight. A ceiling set on a wide, uncontrolled range alerts you to the cheap variant's ordinary prices alongside the expensive variant's bargains.

A sold price of a hundred plus fifteen shipping and a sold price of a hundred and fifteen with free shipping are the same sale, and comparing item prices alone across listings with different shipping produces a false range. Work in landed cost: item price plus shipping to you. For the sold listings, add the shipping shown to each price before ordering them and taking the median, so that the reference price is what a buyer actually paid to have the item arrive.

The monitor's Max price, however, applies to the listing's item price, because that is what eBay search exposes. So once you have a landed-cost ceiling, subtract typical shipping for the category to get the item-price ceiling you type in. For small, light items the difference is a few dollars and it is reasonable to ignore it; for heavy items, or categories where sellers routinely charge high shipping to offset a low item price, it is the difference between a bargain and an ordinary price dressed up as one.

If your feed includes overseas sellers, add import duty and any handling fee to the landed cost as well, and read the location in each alert. A listing fifteen percent under market from a seller abroad is often at market once it arrives.

The numbers below are made up to show the method; they are not a claim about any item's actual price. Suppose you are hunting a particular used camera lens and eBay's sold filter, set to Used and Buy It Now and sorted by most recent, gives you twelve sales. Adding shipping to each, the landed prices in order are: 180, 210, 265, 270, 280, 285, 290, 295, 300, 310, 330, and 420. Reading the titles, the 180 was listed as “fungus, for parts” and the 420 came with a second lens in a bundle, so both are removed.

That leaves ten comparable sales from 210 to 330. The median is the midpoint of the fifth and sixth values, 285 and 290, which is 287.50; call the reference price 285. For a personal purchase you would be pleased with, set the landed ceiling about twenty percent under that, which is 228. Typical shipping for a lens of this size in the sold results was about 12, so the Max price you type into the monitor is 216, which you might round to 220 to avoid missing the listing that was three dollars over.

If instead you were buying to resell, you would start from the 285 you expect to sell at, subtract eBay's final value fee, shipping both ways, packaging and the profit you need, and work down to whatever number that produces; for a lens at this price, that is likely to land somewhere between 150 and 190 landed, or a Max price of 140 to 180 in the monitor. Either way, the ceiling now has a reason behind it, and when an alert arrives under it, you already know why it is worth opening.

When you create a monitor, the Filters section has a Min price and a Max price field, both in dollars and both optional. Max price is the ceiling from the sum above. A listing whose item price is above it is never sent, so the field is where the maths becomes a filter. Type the rounded item-price ceiling, not the landed one, and keep the rounding on the generous side; a ceiling that is five dollars too tight misses the listing that was five dollars over, which was still a good deal.

Min price is the floor, and it does a different job. It is not there to catch deals; it is there to remove the accessories, parts and scams that share the item's name at prices no real unit sells for. If a real used lens never sells for under a hundred, a Min price of a hundred removes every lens cap, hood and empty box from the feed in one move, and it removes the too-good-to-be-true listing from a new account that is more likely a scam than a bargain. Set it a little below the lowest genuine sale you saw.

Set the rest of the monitor to match the sold search you ran: the same keywords, the same condition (Any, New or Pre-owned) and the same listing type (All, Buy It Now or Auction), so that the alerts are drawn from the same population as the reference price. Choose every minute as the check frequency if you intend to act quickly, and route the monitor to phone push, a Discord webhook, or both. eSnipe does all of this for free with no eBay login; it sends the notification and leaves the buying to you.

Markets move. A new generation of a product pushes the old one down; a supply problem pushes a current one up; seasonal demand lifts some categories in the run-up to December and drops them in January. A ceiling set six months ago is set against a market that no longer exists, and the symptom is a feed that either floods or falls silent. Put a monthly reminder in your calendar to rerun the sold search for each monitor and adjust.

The feed itself is the best signal. If nothing has arrived in two weeks for an item that sells every day, the ceiling is under the new floor; rerun the sold search and you will usually find the median has risen. If every listing is arriving and most are ordinary, the median has fallen and your ceiling is now above it. If the feed contains alerts you would happily have bought but did not act on in time, the ceiling is fine and the problem is delivery; move that monitor to phone push and every minute.

Finally, keep a note of the median and the date each time you set a ceiling. Over a year that note is a price history for the things you care about: you will know when a category is rising before asking prices catch up, and when it has fallen far enough that the ordinary listing is the deal.