^^^^ Yes, this is similar to the type of functionality we are looking for as well. There are other ERP systems that have built in integration with QB; an automatic sync function.
Here are a few examples of those:
https://www.mydbsync.com/product/accounting-quickbooks-and-quickbooks-online-edition
Quickbooks API allows integration.
https://developer.intuit.com/docs/0200_quickbooks_desktop/0100_essentials/0000_overview
Look at Web Connector for the QB Desktop.
Thank you Alexnca. I will take a look!
Hi, I am trying to do the same syn doibarr with quickbooks for our accountant.
Can you please guide us with the setup process.
quickbook webconnector is asking for .qwc file (where to get that)
what kind of setup is required in dolibarr for sync process?
waiting for reply.
Thanks.
nazeer,
A .qwc file is a proprietary extension for Quickbook files. Quickbooks has its own schema as well that is very difficult to map with other databases. I ran some testing with a connector called Consolibyte and i was able to successfully connect QB desktop to an online PHP database, but the database had to also be based on the QB schema (same tables, fields, etc.). Since Dolibarr’s database is not the same schema as Quickbooks, it is more difficult to map. You would need to find a developer to customize this for you.
There seems to be a REST-API:
https://developer.intuit.com/app/developer/qbo/docs/develop/rest-api-features
thanks for reply.
I have checked REST API can’t figure out anything.
I used demo script to create qbc file and got connected using SOAP, but its keep on asking to enter password to complete sync process.
where can I get password ?
the help of quickbooks says the password will be provided by web service server which in this case will be dolibarr.
any insight?
tx.
I didn’t use SOAP before - so I guess it is here:
For the REST API you should login with your user name here, which will be used/addressed later on:
Thanks for quick reply.
Yes I saw that in SOAP and tried to used that as password in Web Connector of Quickbooks but authentication fail error.
You are right I saw REST/API too and found the way for user and password. But the problem is Quickbooks Desktop version only uses web connector to sync and not API.
Hi guys, any update on this issue?
I am new to Dolibarr so I can’t speak to spefics, but it seems the API interface for Dolibarr is based on REST API (I just saw they have the option for a SOAP one). The way QuickBooks desktop SDK works it via a desktop app (Quickbooks Webconnect). This external application implements the QB SDK via a SOAP API (using qbXML format). The external (to the quickbook application), will make very speific SOAP calls to the SOAP webserver listed in the .QWC file.
[QB]<->[QWC]<via SOAP QXML>[webbased sever]
QWC is setup to call out to the web-based server at defined intervals of time, there is no provision for the webserver to reach out an activate QWC. Thus on the webserver a que used to queue up request for QB to handle when QWC eventually ask for them.
There, fortunately, are many tools out there that have been created to implement a SOAP to REST API server, which means there is a possibility with some work to create an interface.
One of the best resources to use is http://consolibyte.com/quickbooks-open-source/ keith gives a good explanation and starting point.
From my perspective there are two ways to accomplish this
It seems #2 could be easier to implement than #1.
https://github.com/jsgoupil/quickbooks-sync (uses SOAP and .net)
https://github.com/GPCsolutions/doliwoo (an example Woocoommerce SOAP interface) Could be repurposed into a QB sync but plug seems outdated.
Thanks for reply.
I am still struggling to understand the best solution.
going through links. thanks…
trying to find where to put username and password that QWC is asking to authenticate?
Hi,
I have gone thru the above suggested consolibyte resources.
My confusion is do I have to user those resource to as middle man between dolibarr soap and quickbook webconnector.
Where do I enter user name and password for authentication?
going nowhere with this problem
Any1 tried this?
You can use Consolibyte, you would just need to map the Dolibarr database to the Quickbooks database, which I have been told by developers is very tricky because QB has a lot of sub-tables that need to be taken into account. Are you a developer? Have you tried mapping the tables?
Thanks for your reply.
Not a developer, but can do some troubleshooting… self learning.
Well then I dont see a way ahead with this sync process…
I guess Dolibarr developer should seriously consider developing report printing in Accounting, so that the output will be in standard format of accounting.
I hope developers are reading us.
Thanks.
[color=#0044ff]You can use the QuickBooks mobile app and use sync with your QuickBooks account. You will sign in using the same login credentials. If you are using an iPad, make sure you download the Mobile app and not the QuickBooks Online for iPad app. You will need an online account for that app. Contact Quickbooks cloud hosting support they will help you.
Regards,
Lewis
[/color]
Thanks for reply, but I am looking for solution for Desktop Quickbook sync and not online.
I’m half-way there. Consolibyte quickbooks-php is no longer maintained, but I’ve made some improvements to get it working for one-way sync from QuickBooks to a MariaDB/MySQL database (GitHub - mc2contributor/quickbooks-php: QuickBooks Integration for PHP).
The next step - mapping QuickBooks to Dolibarr - doesn’t seem to have any precedents I can follow.
Accellier Limited have a Dolibarr to Quickbooks online plugin/integration.
Contact them via https://www.accellier.com
