Connect 2 MySQL databases in PHP and exchange data using cronjobs
Budget: €250 – €750 EUR
Hi,
I’m looking for a PHP:MySQL Developer who has decent knowledge concerning data transmission between 2 servers using corncobs.
There are 2 days of work: Friday April 8th and Saturday April 9th Western European time (eventually start earlier if we make a deal). The work will be done with my collaboration.
The job consists of creating PHP scripts to communicate wth a distant server (dropshipper) and a local server (Prestashop 1.7).
My intention is to bypass Prestashop totally and update the servers through PHP and corncobs.
Here is the non extensive list of scripts to be made.
- MAP all the necessary tables/fields on each server (JOINs). I believe the liaison between the servers will be ready before starting.
- SELECT local order list from the last hour (H-1) land INSERT the orders into the distant database table
- SELECT local order products from the last hour (H-1) land INSERT the order products into the distant database table
- VERIFY that there are no duplicate entries and delete if necessary
- VERIFY errors and alert admin (statut_recup column)
- VERIFY order state on the distant server and UPDATE local order info (pending, OK, error, delivering, delivered…)
- UPDATE daily stock on distant server (full stock minus our orders)
- SELECT daily stock and UPDATE local stock quantities on all products
- UPDATE certain fields on local products with info from distant server (daily probably)
We can only write to certain tables on the distant server: orders, order products, daily stock, and one field in all pertinent tables (statut_recup) product/order/delivery state.
We have the list of all the tables on the two servers. Access to PHPmyAdmin on local server. All the necessary tables have a horodated column.
The distant server documentation is in French but most of it is self evident (table descriptions)
I’m looking for someone free to work all day Friday and Saturday of this week and who is good at PHP/MySQL, corncobs and transmission protocols.
Please give me references of similar work.
Thanks in advance.
Richy Roberts
I’m looking for a PHP:MySQL Developer who has decent knowledge concerning data transmission between 2 servers using corncobs.
There are 2 days of work: Friday April 8th and Saturday April 9th Western European time (eventually start earlier if we make a deal). The work will be done with my collaboration.
The job consists of creating PHP scripts to communicate wth a distant server (dropshipper) and a local server (Prestashop 1.7).
My intention is to bypass Prestashop totally and update the servers through PHP and corncobs.
Here is the non extensive list of scripts to be made.
- MAP all the necessary tables/fields on each server (JOINs). I believe the liaison between the servers will be ready before starting.
- SELECT local order list from the last hour (H-1) land INSERT the orders into the distant database table
- SELECT local order products from the last hour (H-1) land INSERT the order products into the distant database table
- VERIFY that there are no duplicate entries and delete if necessary
- VERIFY errors and alert admin (statut_recup column)
- VERIFY order state on the distant server and UPDATE local order info (pending, OK, error, delivering, delivered…)
- UPDATE daily stock on distant server (full stock minus our orders)
- SELECT daily stock and UPDATE local stock quantities on all products
- UPDATE certain fields on local products with info from distant server (daily probably)
We can only write to certain tables on the distant server: orders, order products, daily stock, and one field in all pertinent tables (statut_recup) product/order/delivery state.
We have the list of all the tables on the two servers. Access to PHPmyAdmin on local server. All the necessary tables have a horodated column.
The distant server documentation is in French but most of it is self evident (table descriptions)
I’m looking for someone free to work all day Friday and Saturday of this week and who is good at PHP/MySQL, corncobs and transmission protocols.
Please give me references of similar work.
Thanks in advance.
Richy Roberts