Thanks for replying, I used Easy Populate and uploaded all my sku's with v_status (value 9) to delete and it cleared all but 1 product.

Good ideal if anyone has this problem and is using Easy Populate