I would like to find out how to (and if possible) do the following:
On our ecommerce site when we are on the 'checkout' page a customer can select a payment method and then click on 'place order' for the purchase to go through and all the details are written to the database.
We have a payment method called 'Account Funds'. These funds are inserted manually on a customers account by the site admin. We have created a custom database table cs_account_funds that we are busy developing a front-end user form for to write the values to those specific db_metas.
My question: If the Account Funds payment method is used and a customer clicks on Place Order, how then can we write that specific order total as a negative to the cs_account_funds table as well as to wherever the values are captured on the DB?