Quickbook Sync

[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

[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

[fusionsp]

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.

ok im newer to all of this. How do i change the default value to 0 so all new products will sync with QB? Is that in a table somewhere?

[Zeroca]

I did run the sql file

I am having the same issue. Ran the SQL, can see the new tables in the database, but the script still fails.

Does the script know to look for the "zen_" prefix?

[lifecoachvaness]

Ok, I have a question. This issue has been giving me a hard time. I am seeing the transactions in my zen cart admin once someone makes a payment but no payment is taken from the client's card and no payment is deposited into my account. I don't even see the transactions posted in my merchant services center.

I installed the qbms module to receive payments through Intuit Merchant Services. I setup my application and received my connection ticket. I am using the Desktop model.

I checked with Intuit and they see the connection between my application and their system. The person who makes the purchase also gets a confirmation that their transaction was successful.

Any ideas on what I should do to resolve this issue?

I really need to get this working right away.

Thanks.