Product Description
Bi-directional QuickBooks Sync Made Easy
With the OpenSync QuickBooks sync solution, you can avoid the overhead of learning the QuickBooks API and use standard database tools to read and update QuickBooks data. Performance bottlenecks inherent in the QuickBooks QODBC driver and the QuickBooks Web Connector are eliminated since the sync technology enables you to run your application against a true database server. Forget about import and export tools, OpenSync provides near real time database synchronization with QuickBooks.
It also provides the ability to perform a QuickBooks sync with multiple company files with multiple external Access, SQL Server, MySQL, Oracle, and now Microsoft Azure databases. Changes made in QuickBooks are automatically synchronized to the external database and changes marked in the database are automatically synchronized back to QuickBooks.
OpenSync defines three fundamental concepts to support its operation. These are company files, databases, and tasks. Company files are QuickBooks company files and these must be configured within OpenSync. Databases are either Access, SQL Server, MySQL, Oracle, or Microsoft Azure databases loaded with the OpenSync schema. A task is the fundamental unit of work. Each task defines a company file, a database, an operation, and scheduling information. OpenSync’s sync operation is defined by the configured tasks.
QuickBooks sync tasks can be run either interactively through the OpenSync configuration program or in the background by the OpenSync background processing service. The OpenSync service can be configured to run even without having to log on to the machine and can be controlled through the configuration program.
Click here for a brief video demonstration.
If you want to get a feel for the database that OpenSync creates and maintains for you, click here to download a populated sample database (in Microsoft Access .MDB format).
Note: If you’re having issues syncing data back to QuickBooks, make sure the STATUS column of your parent record is set to ADD or UPDATE.
ashok (verified owner) – :
Works very well for my purposes. Been using 2.x for a long time, and needed 3.x to support latest DB version.
Mark (verified owner) – :
The good: It syncs data to mysql
The bad: Lots of bugs, not that much insight into what it’s actually doing in quickbooks.. unable to trace/debug why we cannot delete invoices or other operations.
More bad: We paid for premium support and the support has been very slow. Basic bugs have not been fixed in several years. This is the last month we’ll be using opensync and we’re moving to QODBC.
jk.peralta – :
BTH yes thats the only problem you need to create a button to do that, but this opensync really helps us to make an improvement to quickbooks.
LessPaperCo (verified owner) – :
We have had a lot of problems with OpenSync and, unfortunately, their customer service is some of the worst customer service I have ever experienced in my entire life. We’re paying hundreds of dollars for this software and we were purchasing it at least once a month for our clients and yet they can’t seem to fix “simple” bugs for us. It’s hard to get any kind of response from them. They’re about to lose us clients because we have a few clients who cannot stand these bugs anymore and are threatening to cancel service with us. If/when this happens we’ll be charging back our credit card to get our money back for the purchases since we bought defective software that OpenSync obviously doesn’t care about fixing.
maryellen.currie (verified owner) – :
We purchased OpenSync 3.0 after using the 2.0 version. We upgraded to 3.0 because the software supported the line item sequence number field which is stored in QuickBooks. This feature is also touted on the Synergration company website. It suddenly stopped working. When I posted a question about this on the forum I was told that OpenSync didn’t support this field. I got this answer after purchasing a premium support subscription. Very frustrated.
kevin9 (verified owner) – :
Product works perfectly. Easy to use.
gurtejsingh (verified owner) – :
Great product.. only problem I faced to make filled for sync with qb
jeff.clements (verified owner) – :
Great product. Easy to configure. Exported to a SQL database for reporting. My only complaint is that it can be very difficult determining which fields are used to relate the tables.
lars (verified owner) – :
Does what it needs to. Would be four stars if transactions synced billable status without a repopulation.
K Readle – :
What a great tool. Solved our issues and was easy to setup.
edgar – :
amazing wish i found this earlier
BTH (verified owner) – :
OpenSync works great for us. We tried other ODBC tools and found they were very slow for a large QB data file