I am currently in the process of integrating my php website with the desktop version of Quickbooks. The application resides on a remote computer and will need to remain in sync with the mysql db on my server. After a great deal of research it appears my two options are:
- Use the PHP Devkit and the web connector to accomplish this.
- Manually export csv files periodically from quickbooks and parse them and insert the data into my mysql db.
In regards to the first option, I can't seem to find any resources indicating that it's possible to query all items from the quickbooks db. This would be ideal as I could periodically query the remote quickbooks application for all items and insert ones which have been added/updated. It looks like the xml requests for querying require you to specify the item your querying. This will not work for what I have envisioned. As we are not making any orders from the website and only displaying current items/customers maybe the web connector is not what I need.
This brings me to my next option, manually parsing csv files from the application. I don't mind this as its more straight forward than setting up the php dev kit to talk to the web connector but requires manual intervention to export data files from quickbooks.
Does anyone have experience in accomplishing this task/automating the syncing of data between quickbooks desktop and a remote php website?
Any and all comments/suggestions are appreciated, Thanks.