I did run the sql file
I did run the sql file
manually verify that the quickbooks_que, quickbooks_log and quickbooks_sessions tables were created
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.
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
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:
Code: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. ) ) ) )
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?
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
Bookmarks