Magento's database structure is rather arcane, but the API provides a clean way of retrieving order data. So, I made this little tool to pull Magento's orders from the API and then populate these orders in a second MySQL database. The orders are exported to two tables : mage (the order data, including customer shipping and billing information), and mage_items (which includes info on the items purchased). The tables are linked by the increment_id (which is also the order #), so it makes for a very readable database. This tool was designed for reporting, but could likely be useful for other applications... If anyone has any suggestions or improvements definitely send 'em my way!

Installation

1. Create a Magento API username and key (done within the Magento back-end)
2. Untar to a protected directory on your webserver ("tar -xvf magesync_v1.00a.tar")
3. Edit /etc/cfg.php and define your absolute path, database host, database name, database username, database password, Magento API URL, Magento API username, and Magento API key
4. Setup a CRON job and set to run as desired (ex, "cd /path/to/magesync; php -q cron.php")
5. Watch and be amazed as Magento's database is demystified!

Download MageSYNC v1.01

Update Log

01/06/2010 - Removed removeMagicQuotes and unregisterGlobals functions since they appeared to be causing problems on some systems (and were also superfluous)

Tags: hack, linux, Magento, php

Warning: THIS POST IS DEPRECATED! I gave up trying to hack OrderShip and wrote my own extension (http://www.illapps.com/shipsync.html)..    I'm leaving the post here for reference, but I strongly suggest going with a commercial solution.

Read the rest of this entry »

Tags: hack, linux, Magento, php