I have a situation where I need to import and export a lot of information between a "central system" and Magento. Basically Magento would be a "shell" of the central system which pretty much contains all the information and creates products etc. There will be multiple "real" stores talking to the central system, which also talks to Magento.
Some of my questions and concerns. Would appreciate all answers, even those who just points me in the right direction here.
Is it possible to automatically import (and export at certain "hooks") information and match those to for example product creation. For example talking with a standardized API, spitting out XML files of products from the central system.
The extension/way of doing it would have to be able to check for new products or statuses of products (if in stock & how many are available) every 5th minute or so. Many even more.
It would look at the XML and create new products based on that. That would include ALL information needed for the product, with maybe an exception for images. So basically name, descritpion, sku, status, price, special price, special price dates, categories, related products etc.
The other half of the problem would be "exporting" the statuses from Magento back to the other system. For example if someone buys a product in the Webshop It would need to notify it back to the "central" system.
Is it possible to export all orders and all order information to the central system where it would be "taken care" of instead of using Magento for that. This would need to happen as soon as someones buys something.