I'm looking for a utility that allows me to use an Excel spreadsheet to search for items by part number currently listed on eBay. Results will be in a .csv/spreadsheet that would show what part number/keyword was found and other auction detail It would need to search both auctions and store inventory.
.csv or Excel spreadsheet with part numbers (potentially thousands)
Takes this file and searches BOTH title AND description on eBay in BOTH stores AND auctions for every part number in the given part number file and reports on items it has found.
The output will be an Excel or .csv file with the following information for EACH item found on eBay:
1. Part Number (from the list)
2. Auction title
4. Sale type (auction or store)
5. Item Price
6. Shipping Cost
7. Qty available (for stores)
8. Item Location
If there are no results for a search, all fields (except part number) should be populated with “No Results”
Every part number should have at least one line of results, some will have multiple. (FYI - Based on my current research, each part number should only have a handful at most). All data should be in one file (.csv or Excel)