Today I want to show you how to automatically disable out of stock products in your store. Unfortunately, by default you can't hide products which are out of stock. You can only disallow to order them. So the product will appear on list. In this tutorial you will read how to disable it. 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.