Quickbook Sync

[the_ancient]

I have finally Finished my Quickbooks Sync Project enough to release the 1st version.

This will use the Quickbooks Web Connector to Sync

• Customers
• Orders
• Products

It will NOT sync Inventory levels at this time, but it will, I am still working out the best way to do it, i.e use a report to pull all of the inventory at once or query individual items


PLEASE READ THE DOCS FULLY, YOU MUST CONFIGURE THE SCRIPT PROPERLY OR IT WILL FAIL,

Since this project is still in its inital development, there is no "install" script to walk you through it so you will have to modify the actual php files. Also there are some things inside quickbooks that has to be done and standardized in order for the sync to work

BACKUP ALL DATA!

Before you start, make sure you back up everything, including your quickbooks company file.

Feed back Welcome, This was Tested on a Quickbooks 2006 Installation, If reporting Bugs Please Report the Following

The Version of Quickbooks your Using
Any Log messages Reported (found in "qbAdmin.php")
PM me the "qwcLog" File (found in the WebConnector Software)

To Download
Click here

[the_ancient]

Couple of things I Forgot

• No Changes at all to any Zen Core Files, these
• Short of a Massive Database Restructuring it should be upgrade proof.
• adds 3 New Tables to the Database, and adds 1 Column to the Orders, Products and Customers Tables (this is how I track what is and what is not in Quickbooks)

All feedback welcome

[confused_aswell]

HI

I have had a quick look at it and it seems there is a lot to do before installing, so will wait and see how other people get on before I install. It looks very comprehensive though.

Good luck,

Phil

[the_ancient]

HI

I have had a quick look at it and it seems there is a lot to do before installing, so will wait and see how other people get on before I install. It looks very comprehensive though.

Good luck,

Phil

That is true depending on how your Quickbooks is Set up,

As far as Zen Cart goes there is not much to the install.


I am open to suggestions on how to ease the Configuration of the top of my head I cant think if anything to change or remove

[cornhustlah]

sounds cool.
dl'd and hoping to install/play with in the next couple days.

will report back.

[the_ancient]

Added to the Contributions Database

http://www.zen-cart.com/index.php?ma...oducts_id=1153

[Mustang394]

Getting this error from web connector

The "AppURL' start tag on line '5' doesn't match the end tag of '\QBWCXML' in file ......

The new application not added.

Any idea what causing this?

Copy of file (edited out sensitive info)

<?xml version="1.0"?>
<QBWCXML>
<AppName>ZenCart Quickbooks Sync</AppName>
<AppID></AppID>
<AppURL>https://afishybusiness.com/qbServer.phpAppURL>
<AppDescription>Zen Cart Sync</AppDescription>
<AppSupport>http://afishybusiness.com/***********/qbAdmin.php </AppSupport>
<UserName>*******</UserName>
<OwnerID>{******}</OwnerID>
<FileID>{********}</FileID>
<QBType>QBFS</QBType>
<Scheduler>
<RunEveryNMinutes>1440</RunEveryNMinutes>
</Scheduler>
</QBWCXML>

[Mustang394]

Disregard I figured it out

[Mustang394]

now I get this.

Message:
Authentication failed

Description:
QBWC1012: Authentication failed due to error: Client found response content type of 'text/html; charset=iso-8859-1', but expected 'text/xml'.
The request failed with the error message:

<div class="systemError">1146 Table 'afi0811808332160.quickbooks_que' doesn't exist<br />in:<br />[TRUNCATE TABLE quickbooks_que]<br /></div>

[the_ancient]

did you run the SQL file against your database?

it does not appear the quickbooks tables were added to your database