If you don't specify any filters, you get back everything. If you specify a name to filter by, it filters items by that. or if you don't want to specify any criteria at all, that's fine too. If you look up ItemQuery, you can specify an item name if you want.

No, they do not require that you specify an item. It looks like the xml requests for querying require you to specify the item your querying. but you could slim it down if you wanted to just do items) (that example can also import all invoices, all customers, etc. 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. 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.ĭoes anyone have experience in accomplishing this task/automating the syncing of data between quickbooks desktop and a remote php website?Īny and all comments/suggestions are appreciated, Thanks. This brings me to my next option, manually parsing csv files from the application. 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 will not work for what I have envisioned. This would be ideal as I could periodically query the remote quickbooks application for all items and insert ones which have been added/updated.

Manually export csv files periodically from quickbooks and parse them and insert the data into my mysql db.Use the PHP Devkit and the web connector to accomplish this.After a great deal of research it appears my two options are: The application resides on a remote computer and will need to remain in sync with the mysql db on my server. I am currently in the process of integrating my php website with the desktop version of Quickbooks.

Quickbooks sdk 13 technical overview