I am new to Magento and I accidentally deleted a product prior to disabling the product on a store. While you are not able to purchase the product as when you select the product from the products listings it says product is unavailable. But the product is showing on the product listings page and I need to remove that but am uncertain how as I cannot find the product and then disable it for that page.
You need to re-index the catalog.
Or in command line
php shell/indexer.php --reindexall