Change woocommerce order status by database change
I have a dropshipping client who uses Delphi in his company. He connected his system to my wordpress database and can read and write it.
The WordPress site runs on a windows server.
How can I make sure that when he makes specific changes in the database the order will be changed by script? (processing -> completed)
The best solution would be if the database change alone triggers the order status change with all its functions, like customer email etc.
My ideas would be:
- Scheduler on windows server who notices changes and runs something
- Zapier.com mysql/WooCommerce connection
- Provide the scripts to let him run the scripts on his system by himself
What are your ideas for a stable and reliable solution?
No hate please im a beginner. I appreciate any ideas and solutions.