Ok just a tip for anyone, if you duplicate a product in zencart it doesnt duplicate the stock by attributes settings so thats a way to delete them all. I cloned the product and then deleted the original product.