Q: How to delete items that are no longer on eBay but still in sku grid?


A: Unless you have a list of item numbers that have been ended on eBay (file exchange only goes back 90 days so you may not get them all), then you'd need to follow this process in order to reconcile sku grid with your active item list.


You'd have to cross-reference with Active Listings not Unsold. You can use eBay's File exchange to download a CSV of your Active Listings and cross-reference with the CSV from Sku Grid...(save a copy of the CSV from sku grid in case you need to restore the data) Please be sure you're not using Excel as it will mess up your eBay item ids -- use Google Sheets or Libre Office for free. Excel is known to mess up your eBay item numbers by converting them to scientific notation and sku grid cannot read that.

  1. Export your Active Listings CSV from eBay's File Exchange (More info on File Exchange can be found here - https://bulksell.ebay.com/ws/ebayISAPI.dll?FileExchangeSubscribe) & Export your CSV from Sku Grid (Import/Export --> Export CSV)
  2. Just take the item ids from the eBay Active Listings CSV and paste under the reprice_sku column in the Sku Grid CSV which are your eBay item ids.
  3. Then sort the Sku Grid CSV by the reprice_sku Column (basically to line up identical eBay item ids one on top of the other).  
  4. Anything appearing twice (a full entry with all info and one blank entry with just an eBay id entered) would mean that the item exists both on your eBay account as an active listing and in Sku Grid as being monitored). These are okay.
  5. Anything appearing only once as just a full sku grid entry with all info filled in would mean that it's in Sku Grid and not on eBay anymore.  Delete those rows.
  6. Any items that are appearing only once with no additional info other than the reprice sku (eBay item id) would mean that the item is active in eBay but you don't have it being monitored in Sku Grid.  You would need to add those items to Sku Grid for tracking.
  7. Once you're done removing unnecessary rows from the CSV.  Save it.  
  8. Then go to Sku Grid and Delete All Items (that's under Advanced).
  9. Then go to Import/Export --> Import CSV and upload the newly saved CSV.  Your entries that went to old listings would have been removed at that point.