I've noticed that many of community members want to automatically hide products which are out of stock. This feature unfortunately isn't available in PrestaShop. You can only disallow to order them, but each product (which is out of stock) will still appear on list.
I've got solution for this :-)
Today I want to show you how to automatically disable out of stock products in your store. In this tutorial you will read how to disable them. As you know, PrestaShop is based on MySQL database, which mean that most important informations (products + categories + etc.) are stored in tables. To achieve what we want - we will use MySQL triggers.