We are trying to sync a management software with magento database through trigger.
Are there some guide that help us to map database and build a software to magento data correspondance?
We do a search but there are lot of old stuff:
- 2014 http://www.magentocommerce.com/wiki/2_-_magento_concepts_and_architecture/magento_database_diagram
- 2012 http://www.magentocommerce.com/wiki/2_-_magento_concepts_and_architecture/catalog_database_tables
- 2011 http://excellencemagentoblog.com/blog/2011/09/07/magento-eav-database-structure/
Thanks to everyone that comments below.
If you have time and budget, I would suggest you sync through API, as DB structure may change, your script works now may not work later if there's a major magento update, but API will adapt it.