Update Table If Checkout is Successful

Good Day,

There is a table which I would like update when a user checks out.

Currently, the checkout page where a user enters their credit card information is MYSITE/index.php/component/hikashop/checkout.

There is a 'Next' button at the bottom right hand of the page.

When the user clicks this 'Next' button, I would like to update a separate table which I have created using php and mySQL. I only want to update this table if the checkout validation is successful.

Which file or files will I need to modify to accomplish this?
Which block of code will I need to place my statement in so my table will be updated if the checkout is successful?

Thank You in advance

Hi,

I think that you'll have to add your code in the "end" file of the "Checkout" view of your front-end template that you are currently using through "Hikashop->Display->Views".

Hope this will help you.