Link to home
Start Free TrialLog in
Avatar of ITsolutionWizard
ITsolutionWizardFlag for United States of America

asked on

QuickBook to MS SQL

I have a quickbook that using hosting account (not cloud).

and I want to export it to MS SQL Server like daily. 


1/ Do you know any plug in I can purchase to sync the data back and forth?


Once it is completed, I want to connect with shopping cart website. 

2/ if you know any good ones, please let me know as well.


Thanks,

Avatar of Bill Bach
Bill Bach
Flag of United States of America image

QODBC Read/Write Edition may be what you are seeking.  It allows you to read and write the QB data directly from an ODBC application.  I use this to get data out of QB and into a Pervasive PSQL databases (to facilitate web searching of QB data).  This script runs nightly, and the target database is accessed through a simple HTML-based front-end that queries the PSQL database -- FAR faster than querying QB directly.  


I also have VBScript tools that read data from our SQLServer-based web storefront application and create Invoices pre-populated with the customer's name and address data, so that, too, should be possible.  Odds are good that you could also create scripts in PowerShell, Python, or any ODBC-compatible language to do exactly what you need.

Avatar of ITsolutionWizard

ASKER

bill thank you for sharing
I have a question
assume I have front end html shopping cart feature that allow anyone to purchase products and of course update the database

will those data sync back to QuickBook? eg update the inventory count

With QODBC, you have access to the entire QB data set.  What *I* do is actually fairly simple: I have one VBScript that extracts order data from my SQL Server-based web storefront and creates an invoice based on the details of the order.  This works because the SKUs are the same.  Once the invoice is saved into QB, the inventory numbers (in QB) automatically get adjusted.

can you share with me which QODBC you use? thanks

There is only one that I am aware of:  www.qodbc.com

Again, if you intend to write to the QB database, you need the read/write license, currently $199.

sound good. very helpful.
one more question for developing shopping cart with QuickBook data schema. where we can find some helps to learn more its database design? like which tables should be updated when the products are purchased. thanks
ASKER CERTIFIED SOLUTION
Avatar of Bill Bach
Bill Bach
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial

in general, i got it. but in c# code in shopping cart. I use sql statement or SP to call and response data? do you have some examples how sql or SP is exe. using c#?

Sorry, I code in C and C++, not C#.  I expect there is some sort of ODBC library available in your compiler?