Automate the standard operational procedure “complete pending order”, on my wordpress / woocommerce site.

I need a script to automate the standard operational procedure “complete pending order”, on my wordpress / woocommerce site.

The script needs to be executed periodically, every 15 minutes, and I need to be able to initiate it manually as well, when necessary. I also need to be able to schedule it. My hosting provider supports cron jobs.

A third party application will insert records in a database table with order ids that needs to be marked as completed. The table will have four columns:

ID: the order id

Status: the status of the record (initially, set to pending)

Datetime: the date/time of creation/modification

Error: if script fails, here is the description of the problem

The script shall check this table for entries with status pending or error, and try to change the corresponding orders’ status to complete, using woo commerce API. Upon success, the scrips shall mark the related record as completed and update the datetime. Upon failure, the script shall mark the related record as failed, update the daytime and store the reason in error field (for example, order id not found)

The deliverables of this project are:

- The script to create the database table

- The script authoring

- The script deployment on the server

- The script scheduling

- Source code

- Brief guidelines on how to run the script manually and how to change schedule

- Testing for the above

Skills: MySQL, PHP, Software Architecture, WooCommerce, WordPress

See more: standard operational procedure, wordpress woocommerce site development document, i need urgent help to complete a one-page website (pretty simple) it has a prototype currently 20% completed, online php work from home, php freelance work from home, freelance jobs php developer, how to get freelance php projects, online php projects to earn money, online php jobs from home, php work from home projects, freelance php developer hourly rate, php, wordpress, i need someone to make me a fake shoutcast listener script i have tried different ways but cannot get it if anyone can make a sc, i need someone to install paidtoclick script in my website, i need someone to install paid-to-click script in my website, i need a script writer, i need a screenplay writer to help me with writing a script, i need a sash designer script like pride pageant, i need a phphtml script mp3

About the Employer:
( 1 review ) Athens, Greece

Project ID: #15506887

Awarded to:


We can easily handle this as we have team of experts who make sure that API is integrated perfectly. SO that the order status will update accordingly.

€100 EUR in 7 days
(435 Reviews)

10 freelancers are bidding on average €176 for this job

€155 EUR in 3 days
(68 Reviews)

I can develop a Chrome extension that automates the procedure but in that case you have to manually Trigger it Quick Chat??

€165 EUR in 6 days
(33 Reviews)

Dear Client ✦Can we do quick chat right now so that we can discuss the project briefly? I am full time freelancer.I have strong communication skills and have flexible working hours. I assure you quality work comp More

€155 EUR in 3 days
(27 Reviews)

We are a team of highly skilled and experienced website designers and developers with 5+ years experience. I assure you that we can give you a quality and timely delivery of your project.

€155 EUR in 3 days
(37 Reviews)

Hello There , Greetings of the day..!! I hope You doing well. My name is Aditya , Having 5+ years experience in this Domain personally to manage and execute The project as per client vision and my company is provid More

€155 EUR in 3 days
(18 Reviews)
€155 EUR in 3 days
(20 Reviews)

Hello I have more than 6 years experience in web development with WordPress and PHP (HTML,CSS,Javascript,Jquery) I do it with cron job as you want I can do it before award me if you like my job award me after Job c More

€140 EUR in 1 day
(9 Reviews)

This job need r&d first what before you have done to do the same things so send me first the complete details or discuss on chat then only it can be done. At least tell the url.

€333 EUR in 5 days
(4 Reviews)

A proposal has not yet been provided

€250 EUR in 5 days
(0 Reviews)