471,616 Members | 1,780 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,616 software developers and data experts.

Integrating Quickbooks Enterprise with unique PHP store?

We're being asked to get Quickbooks Enterprise edition for our
business.
We use a completely hand-made online store (PHP and mySQL) and used to
simply create CSV sheets that were imported as invoices into regular
Quickbooks.
But I guess that's neither 100% accurate and may not even be doable in
newer Quickbooks.

We want to be able to integrate Quickbooks into the system without
replacing our system. Has anyone done this?
Anyone have any experience with Quickbooks Enterprise and unique
in-house online stores?

Thanks for any feedback!!
Liam

Jul 17 '05 #1
2 2599
<ne**@celticbear.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
We're being asked to get Quickbooks Enterprise edition for our
business.
We use a completely hand-made online store (PHP and mySQL) and used to
simply create CSV sheets that were imported as invoices into regular
Quickbooks.
But I guess that's neither 100% accurate and may not even be doable in
newer Quickbooks.

We want to be able to integrate Quickbooks into the system without
replacing our system. Has anyone done this?
Anyone have any experience with Quickbooks Enterprise and unique
in-house online stores?


I've never done exactly this, but I've had to deal with similar issues
(integrating two dissimilar data sources like that) -

Best thing I could suggest is that you back up your Quickbooks data and
examine the data structure in the file - Unless Quickbooks supports SQL
queries (I'm pretty sure it doesn't), you'll need to use file commands & a
lot of file data parsing.

I suppose another possibility is to see if Quickbooks does import/export to
a SQL-supporting format, but that would be a lot of extra steps in using
Quickbooks.

Jul 17 '05 #2
NC
ne**@celticbear.com wrote:

We use a completely hand-made online store (PHP and mySQL)
and used to simply create CSV sheets that were imported as
invoices into regular Quickbooks.
But I guess that's neither 100% accurate and may not even
be doable in newer Quickbooks.

We want to be able to integrate Quickbooks into the system
without replacing our system. Has anyone done this?


Yes. Since QuickBooks has a proprietary data architecture,
you can't make another program write into its database
directly. So the solution would involve some kind of file
interchange.

I would suggest that you write a command-line PHP script
that would pull your sales data from the database and write
it into an IIF file (this is QuickBooks' standard export-
import format; essentially, this is tab-delimited text with
some domain-specific twists; for example, data pertaining
to a single transaction can span over multiple lines of
text). The IIF file can then be imported into QuickBooks.

Last time I dealt with IIF was a few years ago, so I don't
remember all the details, but I do remember that somewhere
between QuickBooks help files and QuickBooks Web site I
found a pretty intelligible description of the IIF format...
These links should get you started:

http://www.quickbooks.com/support/ar...00/117503.html
http://www.quickbooks.com/support/ar...00/121756.html

Cheers,
NC

Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by behindspace | last post: by
6 posts views Thread by Jimmy | last post: by
10 posts views Thread by ARC | last post: by
6 posts views Thread by Kevin | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.