Search Active eBay Listings

Home > eBay Tools > DONATE? Problems with this version?

Please let us know.

Search Active eBay Listings by Keyword •

...item list will display here...

Report Listing X

Search for Items on eBay.

Search for eBay items by one or more seller names or by keywords. Up to 10,000 items can be returned, but results should be constrained by selecting appropriately limiting keywords and categories to reduce unnecessary results.

Overview

Selections - A search must include either a seller name, a category number, or a keyword.

SellerName - Multiple seller names may be added and must be separated by commas.
Keyword search - Various keyword formats are supported. The checkbox will search descriptions.
Site Category - Searches may be limited to include only specified categories, or may exclude specified categories, or may specify some categories and exclude others. Category numbers are site-specific.
Sort Order, Listing Type - Sort order and listing types may be specified. Sort by "Oldest" is not a true eBay option, it simply reverses the "Newest" option and will not find older listings beyond 10,000. Those that return Price+Shipping rely on the postal code field.
Postal Code - The buyer postal/zip code option is specific to the site selected and will provide more accurate shipping costs. Without the postal/zip code, the shipping column may not populate with valid data, but this won't prevent other data from accurately displaying.
Location - Add Country names to limit search. Countries may be included or excluded from the search results (eg: USA, China, United Kingdom, Germany, Hong Kong). Location refers to the location where the item is warehoused for shipping, not the location of the seller. Because sellers do not always correctly state the item location, results may vary. However, location misrepresentation is an eBay violation.

Grid Display - Items matching the search parameters will display in a grid of up to 100 pages (up to 10,000 items max), which will include a thumbnail image, item number, title, start/end dates, price, shipping, total cost, category, condition, eBay site, item location, and sellername. When a listing contains variations, only the lowest, highest, or most popular variation price will appear, based on search order. When all of the items have loaded, the first page will appear and each subsequent page may be loaded and viewed manually.

You may add your own notes to items that appear in the grid. Items may be selectively chosen for the report by clicking to select or deselect the item in the ✓ column, or by tapping rows to toggle up to 3 row colors. When moving from one page to the next, the selected items will remain selected.

Report - The report option will produce spreadsheet reports that can be pasted into an open spreadsheet or into a text file. Select the tab format if pasting directly into an open spreadsheet, or use the comma format if saving directly to a text file that will be given a .csv suffix so that it can be opened later in a spreadsheet tool.

If some items are not wanted in the report, individual rows can be selected/deselected in the grid by clicking the row (changing its color) or by setting checkmarks; or the whole page can be selected/deselected by clicking the "#" header or the ✓ header. You may then choose to include all rows, only the selected rows, or only the deselected rows in your report. Reports can be concatenated, and new scans can be appended to the existing report, by deselecting the option to automatically clear the report at each new scan or build.

IMPORTANT - Before saving data in your spreadsheet tool, or after making any changes and resaving, be sure that the number columns display as numbers and not as exponential notation. [Screenshot] If you see something like 1.63E+11 in a column, right-click the column header, choose "Format cells", and change the format to "Number" with zero decimal places. Pay particular attention to columns that contain the Item ID and long numbers like UPC/EAN. You will have to make these changes every time you open the CSV. To preserve your number changes instead of fixing every time, save the file as XLS. You can export a CSV from that file later.

If you don't convert the exponential numbers to whole numbers prior to saving, your long numbers will be converted to useless numbers with a lot if trailing zeros, like this: 162260000000.

Find API calls:

Keyword Search Tips:

Overview

Will you donate?

Will you donate?
Do you rely on our ad-free tools? Our server happily accepts PayPal donations to help defray the cost of scanning millions of listings daily.		Donation USD