I run an ecommerce site and would like to be able to write PHP code to export all of our order data into a format that can be imported into QuickBooks 2006. However, I have not been able to find a source to fully explain the QuickBooks file format or any processes surrounding it. Can anyone help me with this and/or point me to a source to read up on this so that I can write our export code?
I would look at the SDK. See
I have downloaded the SDK, however, what I am really looking for is details on a file format that I could export all of our order invoices to so that QuickBooks can import them. We have thousands of orders and I am trying to move us away from an in-house developed software solution to something more standardized such as QuickBooks but to do that I have to get everything into QuickBooks in as streamlined a way as possible.
Actually, I think what I may be looking for is a way to export to the IIF file format for import into QuickBooks, but I don't know if this file format is outdated.
You definitely need the SDK or a program that uses it (either
Mike Block - QuickBooks Tax Cut C.P.A. Intuit paid me to make QuickBooks better!
IIF works okay, but requires manual importing from within the QB user interface. It is also on the chopping block and me be removed from future versions of QB. You'll probably regret it if you spend time developing an IIF solution.
The SDK allows you to push orders into QB from your application using COM and XML. It has robust error handling.
That is easy. Use your Mac or Linux box as a terminal and run QuickBooks under a remote Windows Terminal Server.
Mike Block - QuickBooks Tax Cut C.P.A. Intuit paid me to make QuickBooks better!
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.