Fermé

Script to synchronise Magento order data with MySQL table

We need a script that we can run around twice-daily via cron. It will do the following:

a) Fetch all orders placed via our Magento store since the last check and save the order data to an external MySQL table.

The data that needs to be recorded is: order ID, date of purchase, date that order status last changed, payment method, order status, shipping service, buyer name/address/phone, ship-to name/address/phone, order currency, total tax, order total, number of items shipped from this order, number of items unshipped, IDs of items shipped (in form XXXX;XXXX;XXXX), IDs of items unshipped.

b) Update the new order status of any orders that have been changed via the Magento web interface (eg, changed from 'processing' to 'complete', or 'complete' to 'closed') since the last check

Essentially it gives us our own record of order data that should been in sync with the Magento data. We can then use for analysis purposes. All changes to order data will be made via Magento - there is no need to synchronise changes from our database to the Magneto system.

We are running Magento ver. 1.3.2.3 and cannot upgrade at the present time.

Compétences : Magento, MySQL, PHP, Architecture Logicielle

Voir plus : order placed magento table save data, magento mysql sync, magento currency mysql table, magento unshipped order, magento order table, web analysis service, synchronise it, payment method check, magento script update order status, magento order data, order processing service, magento service, ver , service tax, purchase order, order processing, no address to, name to be changed, magento upgrade, magento shipping, magento database, fetch data, cron script, magento payment processing, update status script php

Concernant l'employeur :
( 10 commentaires ) London, United Kingdom

N° du projet : #1021349

2 freelancers are bidding on average $200 for this job

hamotig87

Please see PM.

250 $ USD en 2 jours
(52 Commentaires)
7.0
softwarevamp

Hello, glad to help you!

150 $ USD en 1 jour
(25 Commentaires)
4.8