473,387 Members | 1,863 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 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 2785
<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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: behindspace | last post by:
is this possible, or does my client need to enter information in the DB manually (which I will end up doing for them) any ideas or links would be great, thanks in advance!
2
by: Benny | last post by:
Does anyone know if you have to have a specific version of QuickBooks and Peachtree to integrate a website's "shopping cart" feature? Some of my clients have QuickBooks and some use Peachtree, I am...
3
by: Aliza Klein | last post by:
I have a client who wants to export his Access purchase order data (from the system I am designing) directly into Quickbooks. I know I can create a CSV or similar that Quickbooks can then import -...
2
by: Raghu Gupta | last post by:
Hi, Actually i am facing some problem using quickbooks and presently i am not so expert in using it. I am using c# code to retrive the data from quickbooks. it doesn't matter which language we...
14
by: Kevin G. Anderson | last post by:
What: CAUG Meeting - QuickBooks IIF Files; Total Access Analyzer; CAUG Social When: Thursday, May 25, 2006, 6PM Who: Chris Monaghan and Kevin Anderson Where: The Information Management Group...
6
by: Jimmy | last post by:
I am developing a project management database for my company and would like to somehow integrate or share data from my quickbooks file. I am currently using Access 2003 and Quickbooks 2003 Pro. ...
1
by: Student1000 | last post by:
Ok, i have an access database which is connected to quickbooks in order to make invoices. One of the variables sent to quickbooks is job number. Recently, we 've been having very long(more digits)...
10
by: ARC | last post by:
Hello all, Does anyone have any access functions for quickbooks integration, or have a link with access examples for some basic importing / exporting? Many Thanks,
6
by: Kevin | last post by:
In my business, I use Quickbooks extensively for billing and accounting and a custom built Access DB for project management. I recently began using MS Outlooks contacts quite extensively as well...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.