I have two databases:
DB1) Database from WooCommerce with orders
DB2) MySQL database with random orders and structure
What is needed:
Create a PHP script that will check each order's email from DB2 with orders from DB1 (WooCommerce).
If this email address exists in DB1 and has a completed order status (only completed, not processing, not cancelled).
If found completed order with this email ---> change this order's status value to 1 in DB2.
Don't touch DB1, only use it to check for completed orders using this email.
Any reply without " I have fully read and understood what needs to be done " will be ignored.
13 фрилансеров(-а) готовы выполнить эту работу в среднем за $48
Hi Ana, are you there ? Please open a private chat so we can start the project and finalize the price and time frame. Lets finish this task ASAP Regards, Rohit
Hello I read your job description and ready to start work now. Send me 2 databse file. I can do task with in day. Let's discuss in chat. Thanks Nitin Mandloi