I require a program/script to syncronise my magento site with my accounting system.
I would prefer a java program but a php script would do. (i understand java better)
My understanding is that the best way to achieve this would be through the api, and possibly soap.
The program should lookup our alphamicro server where all stock information resides.
The alphamicro system has a webservice that you can connect to with a socket connection and lookup category and product information as follows-
to get all categories - \service=productcategory
to get all products - \service=productinfo
The category structure is on 2 levels with master categories such as wines and subcategories such as Portugal rose.
Depending on the design of the program it may require a separate program to add the categories in the correct structure. If speed is an issue it may be necessary to run a cut down version every couple mins and a full update every hour.
This program will then be run in regular intervals to update the site ( including stock levels)
I will provide connection information to the winning bidder to try the webservice.
IN SUMMMARY - i want to update the magento site as often as practical using the information in the core systems webservice.