Items In Db, Not Appearing On Site?

I have discovered a handful of items in the product DB that do not appear on the site. Some look like complete entries with stuff in the product_descriptions table as well, but a few seem so only exist in the main products table. Any ideas on why they don't show on the site?

If there are no records in the cscart_product_descriptions and cscart_product_prices tables, the product can be hidden. This is default CS-Cart behaviour