[Skip to main content](#vessel-content)

#   Possible to run mysql query after ordering certain

##

- **[spoOx](/forum/user/964-spoox "View spoOx's Profile")**
- [![spoOx's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/964-spoox "View spoOx's Profile") Topic Author
- [ Offline](/forum/user/964-spoox)

Less More

- Posts: 45
- Thank you received: 0
-
-

15 years 8 months ago [\#6989](#6989) by [spoOx](/forum/user/964-spoox "View spoOx's Profile")  *[Possible to run mysql query after ordering certain](/forum/2-general-talk-about-hikashop/6989-possible-to-run-mysql-query-after-ordering-certain#6989 "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...")* was created by *[spoOx](/forum/user/964-spoox "View spoOx's Profile")*

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...

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY5ODktcG9zc2libGUtdG8tcnVuLW15c3FsLXF1ZXJ5LWFmdGVyLW9yZGVyaW5nLWNlcnRhaW4/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86322
- Thank you received: 14281
-
-

15 years 8 months ago [\#6997](#6997) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Possible to run mysql query after ordering certain](/forum/2-general-talk-about-hikashop/6989-possible-to-run-mysql-query-after-ordering-certain#6997 "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...")*

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](http://www.hikashop.com/en/support/documentation/62-hikashop-developer-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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY5ODktcG9zc2libGUtdG8tcnVuLW15c3FsLXF1ZXJ5LWFmdGVyLW9yZGVyaW5nLWNlcnRhaW4/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation.

Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.040 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)