- Posts: 45
- Thank you received: 0
Possible to run mysql query after ordering certain
15 years 7 months ago #6989
by spoOx
Possible to run mysql query after ordering certain was created by spoOx
Hi,
I was wondering whether it is possible to run a MySQL query after a successful order of a certain product. This query will basically insert the user details (name, add, etc) in to another table...
I was wondering whether it is possible to run a MySQL query after a successful order of a certain product. This query will basically insert the user details (name, add, etc) in to another table...
Please Log in or Create an account to join the conversation.
15 years 7 months ago #6997
by nicolas
Replied by nicolas on topic Re: 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.
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.
Please Log in or Create an account to join the conversation.
Time to create page: 0.169 seconds