Quickbook Sync

[Mustang394]

I did run the sql file

[the_ancient]

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

[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.

[the_ancient]

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.

[the_ancient]

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

[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.
                        )

                )

        )

)

[the_ancient]

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

[WebKinetic]

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?

[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

[the_ancient]

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.