Quickbook Sync

19 Oct 2008, 14:26

#1

Zen Follower

Join Date:: Mar 2007
Posts:: 120
Plugin Contributions:: 1

Quickbook Sync

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

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!
[SIZE=4][COLOR=Black]
Before you start, make sure you back up everything, including your quickbooks company file.

[SIZE=1][SIZE=2]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

[/SIZE][/SIZE][/SIZE][/COLOR]

19 Oct 2008, 14:40

#2

the_ancient

Zen Follower

Join Date:: Mar 2007
Posts:: 120
Plugin Contributions:: 1

Re: Quickbook Sync

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

20 Oct 2008, 13:11

#3

confused_aswell

Zen Follower

Join Date:: Apr 2008
Posts:: 315
Plugin Contributions:: 1

Re: Quickbook Sync

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

20 Oct 2008, 17:39

#4

the_ancient

Zen Follower

Join Date:: Mar 2007
Posts:: 120
Plugin Contributions:: 1

Re: Quickbook Sync

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

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

27 Oct 2008, 19:16

#5

cornhustlah

New Zenner

Join Date:: Oct 2008
Posts:: 2
Plugin Contributions:: 0

Re: Quickbook Sync

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

will report back.

29 Oct 2008, 19:31

#6

the_ancient

Zen Follower

Join Date:: Mar 2007
Posts:: 120
Plugin Contributions:: 1

Re: Quickbook Sync

Added to the Contributions Database

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=1153

03 Nov 2008, 05:30

#7

mustang394

Zen Follower

Join Date:: Jun 2008
Posts:: 146
Plugin Contributions:: 0

Re: Quickbook Sync

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>

03 Nov 2008, 05:42

#8

mustang394

Zen Follower

Join Date:: Jun 2008
Posts:: 146
Plugin Contributions:: 0

Re: Quickbook Sync

Disregard I figured it out

03 Nov 2008, 05:57

#9

mustang394

Zen Follower

Join Date:: Jun 2008
Posts:: 146
Plugin Contributions:: 0

Re: Quickbook Sync

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>

04 Nov 2008, 01:41

#10

the_ancient

Zen Follower

Join Date:: Mar 2007
Posts:: 120
Plugin Contributions:: 1

Re: Quickbook Sync

did you run the SQL file against your database?

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

04 Nov 2008, 05:45

#11

mustang394

Zen Follower

Join Date:: Jun 2008
Posts:: 146
Plugin Contributions:: 0

Re: Quickbook Sync

I did run the sql file

04 Nov 2008, 11:56

#12

the_ancient

Zen Follower

Join Date:: Mar 2007
Posts:: 120
Plugin Contributions:: 1

Re: Quickbook Sync

manually verify that the quickbooks_que, quickbooks_log and quickbooks_sessions tables were created

05 Nov 2008, 17:42

#13

cropinstop

New Zenner

Join Date:: Oct 2006
Posts:: 73
Plugin Contributions:: 0

Re: Quickbook Sync

Is Quickbooks Sync compatible with the QBI Import contribution?

I use QBI Import, and syncing up new products currently requires scrolling through over 100 pages of existing products to find the new records.

05 Nov 2008, 21:56

#14

the_ancient

Zen Follower

Join Date:: Mar 2007
Posts:: 120
Plugin Contributions:: 1

Re: Quickbook Sync

cropinstop:
Is Quickbooks Sync compatible with the QBI Import contribution?

I use QBI Import, and syncing up new products currently requires scrolling through over 100 pages of existing products to find the new records.

I honestly have never used, seen or downloaded the QBI, I saw it used IFF files and instantly new it was not for me.

So I wrote this one.

The ONLY thing my "sync" does with products is bring in new products that have a"0" in the new quickbooks column in the database.

I assume that QB is the master and the Zen is the Slave.

by default new products added are given a 1 value, you can change that default value to 0 which would then force the qbServer to add all new products to your QB Installation.

Currently however no inventory figured are transferred only Model Number, Name and Pice.

07 Nov 2008, 13:29

#15

the_ancient

Zen Follower

Join Date:: Mar 2007
Posts:: 120
Plugin Contributions:: 1

Re: Quickbook Sync

I have Discovered a Bug in the qbClass.

Quickbooks Requires the Name to be added manually to the Address Section for Shipping and Bill to, I had assumed it used the already exsisting Name Fields

I have Modified the Customer Import Method and the Sale Reciept Method to Use the Customer First Name and Last name as Address Line 1

To Upgrade you only need to replace the "quickbooksSync/qbClass.php" File No Other Changes were made. BE SURE TO CHANGE THE SETTINGS IN THAT FILE BEFORE YOU UPLOAD THE NEW FILE.

I have Submited it to the Zen Cart, until then you can download it at
http://theancient.us/downloads/QBSync-v1.1.zip

12 Nov 2008, 02:51

#16

pikodapets

New Zenner

Join Date:: Nov 2008
Posts:: 2
Plugin Contributions:: 0

Re: Quickbook Sync

I installed this mod and it seems like most of it is working. I am getting some errors though.

0x80040400:QuickBooks found an error when parsing the provided XML text stream.

Within the Web Connector Log file I have found:
<div class="systemerror">1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1<br />[UPDATE quickbooks_que SET complete = -1 where id = ]<br /></div>

and:

SimpleXMLElement Object
(
    [QBXMLMsgsRs] => SimpleXMLElement Object
        (
            [ItemInventoryAddRs] => SimpleXMLElement Object
                (
                    [@attributes] => Array
                        (
                            [statusCode] => 3180
                            [statusSeverity] => Error
                            [statusMessage] => There was an error when saving a Items list, element "".  QuickBooks error message: The name of the list element cannot be blank.
                        )

                )

        )

)

12 Nov 2008, 12:11

#17

the_ancient

Zen Follower

Join Date:: Mar 2007
Posts:: 120
Plugin Contributions:: 1

Re: Quickbook Sync

pikodapets:
I installed this mod and it seems like most of it is working. I am getting some errors though.

0x80040400:QuickBooks found an error when parsing the provided XML text stream.

Within the Web Connector Log file I have found:
<div class="systemerror">1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1<br />[UPDATE quickbooks_que SET complete = -1 where id = ]<br /></div>

and:
SimpleXMLElement Object
(
    [QBXMLMsgsRs] => SimpleXMLElement Object
        (
            [ItemInventoryAddRs] => SimpleXMLElement Object
                (
                    [@attributes] => Array
                        (
                            [statusCode] => 3180
                            [statusSeverity] => Error
                            [statusMessage] => There was an error when saving a Items list, element "".  QuickBooks error message: The name of the list element cannot be blank.
                        )

                )

        )

)

Looks like is a Item in your Cart with no "model" the model is the field I used as the "name" in quickbooks.

Check and see if you can if you do have a product with no model

20 Nov 2008, 23:20

#18

webkinetic

New Zenner

Join Date:: Nov 2008
Posts:: 3
Plugin Contributions:: 0

Re: Quickbook Sync

I got everything installed and when I Run the sync in the Web Connector it creates a new order in Quickbooks, but if the order already exists it just makes a new copy with the same Sale No. So every time I run it I keep getting the same orders over and over.

How do I keep it from entering the same order multiple times?

25 Nov 2008, 20:29

#19

romy

New Zenner

Join Date:: May 2007
Posts:: 98
Plugin Contributions:: 0

Re: Quickbook Sync

help on quickbook install
uploaded all files to admin
install SQL file started with qbi_2-10_3-21
updated to qbi_3-20_3-21
then go to customers - qb import QBI
(Install QBI database tables for version 3.21?)
click install QBI database table now
gives me this error: Error: SQL file not found

What Im I doing wrong.

Thanks

26 Nov 2008, 01:55

#20

the_ancient

Zen Follower

Join Date:: Mar 2007
Posts:: 120
Plugin Contributions:: 1

Re: Quickbook Sync

romy:
help on quickbook install
uploaded all files to admin
install SQL file started with qbi_2-10_3-21
updated to qbi_3-20_3-21
then go to customers - qb import QBI
(Install QBI database tables for version 3.21?)
click install QBI database table now
gives me this error: Error: SQL file not found

What Im I doing wrong.

Thanks

This is not for QBI, see the Sticky Thread in this forum for QBI support.