Possible to run mysql query after ordering certain

Hi,

Yes, you can create plugin for HikaShop for that.
We have some documentation on that: www.hikashop.com/en/support/documentatio...r-documentation.html

you can implement the functions :
onAfterOrderCreate(&$order,&$send_email)
onAfterOrderUpdate(&$order,&$send_email)

You will have to load the products of the order from the table hikashop_order_products in order to check if your product is in the order and you will have to check the status of the order so that you know it's confirmed and skip otherwise.