Quickbook Sync

Slow Import:

I'm currently importing live (nervous time I know!) but the connection seems to be pretty slow when importing customers, I have about 6,500 customers and it is probably importing about 12 an hour.

It appears to get the information from the store almost instantly but then shows "Sending request to Quickbooks" for about 5mins per customer.

Is there any reason for this or method of speeding it up at all, it's not so bad at the moment whilst sales are slow but we anticipate about 100 new customers a day for Nov/Dec and this means it'll be almost impossible to keep on top of the accounts!

First, thanks to the original author the_ancient and the 2.0 author srturner47 for all their work bringing this mod to us.

Almost done setting up Sync with Quickbooks Pro 2009 on a Zencart 1.3.9h store .

I can't seem to sort out the fact that tax is applied to all Sales Receipts. On all my out of state purchases there should be no tax applied. I did try several different settings in the admin but never got the proper results.

Anybody have an idea on how to change this?

I have been using Quickbook Sync for few months. It seems to work great.. However, i have not been able to let QB Sync to Auto-Login.. I get an error QBWC1013 when my quickbooks are not open. I have to open my quickbooks and login with admin for my QB Sync to be able to work. Any ideas?

Also can i schedule QB Sync to run everyday at 1pm ? How do i configure that?

Thanks in advance!

I finally figured out how to stop applying tax on shipping on orders that are out of state. :clap:

At the bottom of the invoice screen in QB there is a tax table which will let you select from several options that you may define for different tax options. I added the table Out of State which applied no taxes to the invoice then applied that name in the QB sync setting in the Zencart admin under Quickbooks Sync.

I found the table called:
no tax in Zen Cart tax name for Quickbooks

In this table I put the name of my Quickbooks no tax account
( Out of State ).

Sometimes you just have to walk away and comeback later with a fresh look at things.
Hours worth of aggrevation resolved in minutes. :frusty:

I hope this helps everybody.

Hey,

With a few personal modifications this mod is now working brilliantly...EXCEPT... I have the same problem as quoted here. How do you get the sync to run automatically when quickbooks isn't open? Anyone got any ideas?

vaige:

I have been using Quickbook Sync for few months. It seems to work great.. However, i have not been able to let QB Sync to Auto-Login.. I get an error QBWC1013 when my quickbooks are not open. I have to open my quickbooks and login with admin for my QB Sync to be able to work. Any ideas?

Also can i schedule QB Sync to run everyday at 1pm ? How do i configure that?

Thanks in advance!

Any idea on why new products added to Zencart will not show up in quickbooks? I am getting an error when I try to sycn and it will not sync any of the roders that have the new products i added to zen cart. All was working fine until I added the new products to zen cart. I have my settings to "add new products:, and preferred vendor is 0.

here is the error the "CWR-41509" represents a new product in zen cart that has not yet been added to QB.......

Errors are Listed Below:
Error:Object "1EF04-1299973726" specified in the request cannot be found.
Error:There is an invalid reference to QuickBooks Item "CWR-41509" in the SalesReceipt line. QuickBooks error message: Invalid argument. The specified record does not exist in the list.
Error:There is an invalid reference to QuickBooks Item "CWR-36885" in the SalesReceipt line. QuickBooks error message: Invalid argument. The specified record does not exist in the list.

Any ideas on this error? Thanks for your help...
Errors are Listed Below:
Error:Object "1EF04-1299973726" specified in the request cannot be found.

Detailed Error Log Activity Follows:

LOG
e77ac9f5330b586817a48bf7dae9cf5c
05-01-11 08:35:22 PM

SimpleXMLElement Object
(
[QBXMLMsgsRq] => SimpleXMLElement Object
(
[@attributes] => Array
(
[onError] => continueOnError
)

        [TxnDelRq] => SimpleXMLElement Object
            (
                [TxnDelType] => SalesReceipt
                [TxnID] => 1EF04-1299973726
            )

    )

)

LOG
e77ac9f5330b586817a48bf7dae9cf5c
05-01-11 08:35:22 PM

SimpleXMLElement Object
(
[QBXMLMsgsRs] => SimpleXMLElement Object
(
[TxnDelRs] => SimpleXMLElement Object
(
[@attributes] => Array
(
[statusCode] => 3120
[statusSeverity] => Error
[statusMessage] => Object quot;1EF04-1299973726quot; specified in the request cannot be found.
)

            )

    )

)

ERROR
e77ac9f5330b586817a48bf7dae9cf5c
05-01-11 08:35:22 PM

Error:Object "1EF04-1299973726" specified in the request cannot be found.

How can I unistall the SQL from the Database?

Just finished v2.02.

No need to update to v2.02 from v2.01 unless you have a large store, use continuing sync, and have the Authentication Failed error after a long wait when first running the Web Connector. Essentially, this means that your server isn't fast enough to build the que before the Web Connector times out. You are much more likely to encounter this error if you are in a shared hosting environment where resources are limited. This update works around the problem. See the changelog below for more details.

Changelog for v2.02:

• Optimized code for continuing sync que build to speed this up a bit.
• If you still get the Authentication Failed error, a Quickbooks Prepare option has been added to the tools menu. Run this first, then run Quickbooks Web Connector to solve this problem.

totalsam - Nope. Wish I could figure that out too.

bkeaton - No script available. It won't hurt to leave it in. If you must be rid of it, just use phpmyadmin in cpanel. Delete the 12 tables that begin with quickbooks. Then, remove the field "quickbooks" from the orders, products, and customers tables.

bpsstore - Sure. I can help with that. qbSync stores the unique identifier (no way to view this in QB) that QB uses to identify orders, products and customers. What you are seeing is the unique identifier of something you previously exported. You deleted something from QB that qbSync expected to be there because it previously exported it. Don't do this in the future! If you delete something in Zen Cart, turn continuing sync on and it will automatically delete in QB. Otherwise, don't mess with it in QB! No good way to get you out of this mess, but here is what I'd recommend: Empty tables quickbooks_items_record, quickbooks_customers_record, and quickbooks_orders_record in phpmyadmin via cpanel. This will erase all records of products, customers, and items that were previously exported. Then, go to Admin->Configuration->Quickbooks Sync->QBS-MATCH (There should be three values here.). Turn all three of the match values to 1. Run the web connector. It will find all products, orders, and items that match names in Zen Cart. Their names must match EXACTLY or they won't find them and match them. Go to Admin->Configuration->Quickbooks Sync->Customer Name Format and Order Number Format to format the orders and customer names. Product names use model number, no way to change that, so hopefully they are the same in QB!

As for these errors:
Error:Object "1EF04-1299973726" specified in the request cannot be found.
Error:There is an invalid reference to QuickBooks Item "CWR-41509" in the SalesReceipt line. QuickBooks error message: Invalid argument. The specified record does not exist in the list.
Error:There is an invalid reference to QuickBooks Item "CWR-36885" in the SalesReceipt line. QuickBooks error message: Invalid argument. The specified record does not exist in the list.

They mean that these products don't exist in QB. They can't export an order with those products when they don't exist in QB.

seems there is no answer to it..

is there a way we can auto login to quickbooks?

thanks!

Getting this error, head about to explode :censored:

QBWC1003: The application ZenCart Quickbooks Sync's support URL (http://mysiteishere/test/admin/qbAdmin.php) could not be reached. Do you want to proceed anyway?

Possible problem:
Status Code: InternalServerError
Status Description : Internal Server Error

The file is there, the path to it is right. Any suggestions?

Please please please...

Thanks.

Also, if I choose continue I am getting this error

20110615.21:34:07 UTC : QBWebConnector.WebServiceManager.DoUpdateSelected() : updateWS() for application = 'ZenCart Quickbooks Sync' has STARTED
20110615.21:34:07 UTC : QBWebConnector.RegistryManager.getUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock = FALSE
20110615.21:34:07 UTC : QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock has been set to True
20110615.21:34:07 UTC : QBWebConnector.RegistryManager.setUpdateLock() : ********************* Update session locked *********************
20110615.21:34:07 UTC : QBWebConnector.SOAPWebService.instantiateWebService() : Initiated connection to the following application.
20110615.21:34:07 UTC : QBWebConnector.SOAPWebService.instantiateWebService() : AppName: ZenCart Quickbooks Sync
20110615.21:34:07 UTC : QBWebConnector.SOAPWebService.instantiateWebService() : AppUniqueName (if available): ZenCart Quickbooks Sync
20110615.21:34:07 UTC : QBWebConnector.SOAPWebService.instantiateWebService() : AppURL: https://abruzzos.com/test/qbServer.php/
20110615.21:34:07 UTC : QBWebConnector.SOAPWebService.do_serverVersion() : *** Calling serverVersion().
20110615.21:34:07 UTC : QBWebConnector.SOAPWebService.do_serverVersion() : Actual error received from web service for serverVersion call: <Client found response content type of 'text/html; charset=UTF-8', but expected 'text/xml'.
The request failed with an empty response.>. For backward compatibility of all webservers, QBWC will catch all errors under app-not-supporting-serverVersion.
20110615.21:34:07 UTC : QBWebConnector.SOAPWebService.do_serverVersion() : This application does not contain support for serverVersion. Allowing update operation for backward compatibility.
20110615.21:34:07 UTC : QBWebConnector.SOAPWebService.do_clientVersion() : *** Calling clientVersion() with following parameter:<productVersion="2.0.0.139">
20110615.21:34:08 UTC : QBWebConnector.SOAPWebService.updateWS() : Actual error received from web service for clientVersion call: <Client found response content type of 'text/html; charset=UTF-8', but expected 'text/xml'.
The request failed with an empty response.>. For backward compatibility of all webservers, QBWC will catch all errors under app-not-supporting-clientVersion.
20110615.21:34:08 UTC : QBWebConnector.SOAPWebService.do_clientVersion() : This application does not contain support for clientVersion. Allowing update operation for backward compatibility.
20110615.21:34:08 UTC : QBWebConnector.SOAPWebService.do_authenticate() : Authenticating to application 'ZenCart Quickbooks Sync', username = 'private'
20110615.21:34:08 UTC : QBWebConnector.SOAPWebService.do_authenticate() : *** Calling authenticate() with following parameters:<userName="private"><password=<MaskedForSecurity>
20110615.21:34:08 UTC : QBWebConnector.SOAPWebService.do_authenticate() : QBWC1012: Authentication failed due to following error message.
Client found response content type of 'text/html; charset=UTF-8', but expected 'text/xml'.
The request failed with an empty response.
More info:
StackTrace = at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at QBWebConnector.localhost.WCWebServiceDoc.authenticate(String strUserName, String strPassword)
at QBWebConnector.localhost.WCWebService.authenticate(String strUserName, String strPassword)
at QBWebConnector.SOAPWebService.authenticate(String UserName, String Password)
at QBWebConnector.WebService.do_authenticate(String& ticket, String& companyFileName)
Source = System.Web.Services
20110615.21:34:08 UTC : QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock has been set to False
20110615.21:34:08 UTC : QBWebConnector.RegistryManager.setUpdateLock() : ********************* Update session unlocked *********************
20110615.21:34:08 UTC : QBWebConnector.WebServiceManager.DoUpdateSelected() : Update completed with errors. See log (QWClog.txt) for details.

I installed this mod to evaluate it as an alternative to QBI.

After set-up it connects to the server and brings in new products and new customers into Quickbooks. However, none of my orders are being imported to Quickbooks. I can't see anything obvious in the Quickbooks Sync configuration that might account for this. The Web Connector log does not show any errors that I can tell.

Can anyone suggest where I could go next to troubleshoot this?

please help me out on this. I am able to sync all my customers and all their info from zen-cart into a quickbook's manufacturer sample file, but no any orders or products are synced. please tell me what exactly should i write in "match zen cart value and quickbooks value" areas infront of each others to bring orders into quickbooks, or which line in zen-cart qb config i should change into 0 or to 1 or to what so this orders show up in quickbooks? would appretiate any advice, because i spent hours trying to figure this out.
must be something simple.
thanks.

log errors:
There is an invalid reference to QuickBooks Account "Sales" in the Items. QuickBooks error message: Invalid argument. The specified record does not exist in the list.

and

[statusCode] => 3140
[statusSeverity] => Error
[statusMessage] => There is an invalid reference to QuickBooks Account quot;Salesquot; in the Items. QuickBooks error message: Invalid argument. The specified record does not exist in the list.

I had installed this add-on about a year ago, and ran into some difficulty and removed it. I am now trying again to get it to work. I installed as a new install. I followed all of the directions carefully. When I installed the sql, it told me that the extra fields were already installed in the database, as expected. I uploaded the appropriate files. I now have the quickbooks sync menu items under tools, but there is no quickbooks sync entry under the admin column. Any ideas?

SPembleton:

I had installed this add-on about a year ago, and ran into some difficulty and removed it. I am now trying again to get it to work. I installed as a new install. I followed all of the directions carefully. When I installed the sql, it told me that the extra fields were already installed in the database, as expected. I uploaded the appropriate files. I now have the quickbooks sync menu items under tools, but there is no quickbooks sync entry under the admin column. Any ideas?

Does anyone know if I can try to reinstall either the new installation sql patch or the upgrade patch?

Has anyone tried this mod with Zen v1.50 yet?

Note: This mod isn't compatible for Zen-Cart V1.5 yet. I have installed it and the sql isn't for V1.5 it's for the older version of 1.3.9h I sure hope someone has an update for 1.5

If some has an update that is compatible for v1.5 that would be awesome. Let us know.

bkeaton:

Note: This mod isn't compatible for Zen-Cart V1.5 yet. I have installed it and the sql isn't for V1.5 it's for the older version of 1.3.9h I sure hope someone has an update for 1.5

If some has an update that is compatible for v1.5 that would be awesome. Let us know.

I was able to get it running with 1.5 but haven't tested it thoroughly since my live store is still on 1.3.9 but everything looks fine.

What I did was just install as normal (i had to tweak the sql file a bit but i think that was more because of my MySQL settings). I had to add the column names in the insert statements and remove the first " '', " from them since I was getting an error trying to insert a blank string as a primary key.

After that I added the following language strings to some file i made for just this purpose:

define('BOX_TOOLS_QUICKBOOKS', 'Quickbooks Sync');
define('BOX_TOOLS_QUICKBOOKS_LOG', 'Quickbooks Sync Log');
define('BOX_TOOLS_QUICKBOOKS_MATCH', 'Quickbooks Sync Match');
define('BOX_TOOLS_QUICKBOOKS_PREPARE', 'Quickbooks Prepare');
define('FILENAME_QUICKBOOKS_LOG', 'qbAdmin.php');
define('FILENAME_QUICKBOOKS_MATCH', 'qbMatch.php');
define('FILENAME_QUICKBOOKS_PREPARE', 'qbBuildQue.php');

Then I went into the Admin Page Registration screen and added these (using the param "gID=##" for the 'Quickbooks Sync" configuration menu item) where ## was the id of the configuration_group that was created.

This method works for most non-upgraded plugins so far btw but maybe it's not the best way - i just stumbled on it by trial and error.