Well I've just had to cull nearly all my listings (24,000) because I realised I have been uploading some bad ones (description not fully there, or pic url) after editing the csv in excel.
But I left all the ones up which sold 1 or more.
It's really easy guys, use your brain.
1. Go to the eBay File Exchange and request Active listings (under Download Files). This may take a couple of hours or is really quick, just depends.
2. Once you download that file. Go into excel and use the filter on the purchases column. I selected only 0 purchases, deselecting all the others.
3. Then copy all the item numbers into a file exchange csv file to end those listings, and upload it to file exchange.
Tip: Create a folder on your computer with file exchange templates you have successfully figured out, so you can quicky edit them.
I'll give you the exact answer for ending listing via file exchange.
You need 3 columns and the headers in order should be.
[TABLE="width: 64"]
[TR]
[TD="width: 64"]Action(SiteID=UK|Country=GB|Currency=GBP|Version=745)[/TD]
[/TR]
[/TABLE]
[TABLE="width: 64"]
[TR]
[TD="width: 64"]ItemID[/TD]
[/TR]
[/TABLE]
[TABLE="width: 64"]
[TR]
[TD="width: 64"]EndCode[/TD]
[/TR]
[/TABLE]
Note the first column header is for the UK site. You'll have to figure out the US site yourself, which is easier I think, because it took me ages to find the UK version of that header, but from what I remember there were a lot of examples of the US site on the eBay forums.
Now under the first column, put End in every single cell below it.
The second column is obvious, put your item numbers in there (the ones you got from the active listings spreadsheet that you want to end).
For the third column, put NotAvailable in every cell.
Simple. Just remember when working with eBay item numbers, that excel will open them funny. So highlight the column and format it as a number format with 0 decimal places.
If it's not working, google ebay forums and read the ebay documentation.
Also the best way to figure if something goes wrong, is go to the file exchange (after it's uploaded and failed to work), go to View Upload Results, and download the Results Report. It will tell you Success or Failure in the report, and give you an error code and message if it's a failure. Once again use Excel filter to easier see where there are any failures or successes.