Our website has recently been upgraded to Magento 2.2.2 and since then we have had daily occurrences of products disappearing from the catalogue. The product is still live and can be found/purchased etc. via the URL, but is no longer visible on the front end in any of its categories or via the search bar.
When this has happened there has been no changes in the back end, and the product looks normal in admin.
Has anyone else experienced this, and if so knows how to resolve it?
Seems like you have issue of indexing database.
Do reindexing by running this command : php bin/magento indexer:reindex
Then after run php bin/magento cache:clean and php bin/magento cache:flush command
It will works , and display products at frontend
As @ManthanDave suggested, the problem could be because of re-indexing. Run the reindex commands and clear cache.
Additionally, check the stock availability of the products and see if they are not allowed to show in catalog and search.