I would like to check my database triggers related to stock updates in my Magento 2.4.
I need to know what are the triggers to stock updates specifically.
How could I check it?
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.
Sign up to join this communityIt's a native MySQL feature that Magento uses to detect and invalidate the data, so you might be able to check the stock-related ones via this DB query below.
select trigger_name from information_schema.triggers where trigger_name like "%stock%";
+----------------------------------------------+
| trigger_name |
+----------------------------------------------+
| trg_cataloginventory_stock_item_after_insert |
| trg_cataloginventory_stock_item_after_update |
| trg_cataloginventory_stock_item_after_delete |
+----------------------------------------------+