I uploaded a csv in which there were some products having no name ,so it comes out blank in frontend.
I tried getting these products in
catalog_product_entity_varchar but there were no NULL values in this table corresponding to
attribute_id of Product Name attribute.
Is there any way to delete these products using admin/sql query.