How to query some data out of a QuickBook(.qbw) file?

Question

Situation

• I am new to the QuickBooks world.
• I have a .qbw file -> CompanyName.qbw
• It's a huge file that contain almost everything about my company.
• I want to query some data out of that file - NOT all , but some.:)

Let's say, I want to query only the inventory report.

• Within that inventory report, I only want 3 fields.

  1. product_id
  2. name
  3. availability

I've been looking for a tool out there everywhere, I could not find anything that will does exactly what I want.

Can someone get me start on this ? Can anybody at least point me to the right direction ?

I am not exactly sure, if what I am trying to do is possible.

Answer 1

Not a direct answer, but some direction as you requested:

The QOBDC driver available here (http://qodbc.com) should allow you to access your qbw file like a SQL database and perform queries against it. There is a free trial, but it looks like you'll need to pay $150-$500 to buy this driver if you find that it works and you want to use it long term.

As for querying a specific report like inventory, I don't know, but there are plenty of tutorials around in the form of blog posts and YouTube videos that should help you figure out how to use QODBC for your purpose.

Answer 2

Intuit (the people that make QuickBooks) offers something called the QuickBooks SDK specifically for situations like yours.

• https://developer.intuit.com/docs/0250_qb

It's free to download. Download, install, and you can connect to QuickBooks and extract any data you want or run any reports you want.

There's about 600 pages of documentation available in PDF format:

• https://developer-static.intuit.com/qbSDK-current/doc/PDF/QBSDK_ProGuide.pdf

And you'll probably also want to look at the QuickBooks OSR, which shows all of the XML messages you can send QuickBooks, along with the XML responses you get back and even some auto-generated sample code:

• https://developer-static.intuit.com/qbSDK-current/Common/newOSR/index.html

If you post more details (e.g. what language are you developing in?) we could post sample code for you too.