Quickbook Sync

[Danielle]

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.

I'm a little unclear on how to get this to work, just wondering if you could provide a bit more detail? I created a file in admin/includes/languages/english/extra_definitions/quickbooks.php and added the content that you listed. But I'm not clear on what to enter in the admin. Can you list the exact values you entered in the fields on the Admin Page Registration page? I've tried a few things, but nothing works.

Thank you!

[Danielle]

I'm a little unclear on how to get this to work, just wondering if you could provide a bit more detail? I created a file in admin/includes/languages/english/extra_definitions/quickbooks.php and added the content that you listed. But I'm not clear on what to enter in the admin. Can you list the exact values you entered in the fields on the Admin Page Registration page? I've tried a few things, but nothing works.

Thank you!

I got it to work but I had to put those language defines right in admin/includes/languages/english.php. I tried putting them in admin/includes/languages/english/quickbooks.php and admin/includes/languages/english/extra_definitions/quickbooks.php, but neither way worked.

[wmorris]

Will this work with the online version of Quickbooks?

[HamLund]

I really hate ask question with my first post but I really need help with this and was hoping someone here has ran into this. I have installed QBsync and now I'm trying to run web connecter for the first time to sync. i am getting the following error.

20120208.04:39:12 UTC	: QBWebConnector.WebServiceManager.DoUpdateSelected() : updateWS() for application = 'ZenCart Quickbooks Sync' has STARTED
20120208.04:39:12 UTC	: QBWebConnector.RegistryManager.getUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock = FALSE
20120208.04:39:12 UTC	: QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock has been set to True
20120208.04:39:12 UTC	: QBWebConnector.RegistryManager.setUpdateLock() : ********************* Update session locked *********************
20120208.04:39:12 UTC	: QBWebConnector.SOAPWebService.instantiateWebService() : Initiated connection to the following application.
20120208.04:39:12 UTC	: QBWebConnector.SOAPWebService.instantiateWebService() : AppName: ZenCart Quickbooks Sync
20120208.04:39:12 UTC	: QBWebConnector.SOAPWebService.instantiateWebService() : AppUniqueName (if available): ZenCart Quickbooks Sync
20120208.04:39:12 UTC	: QBWebConnector.SOAPWebService.instantiateWebService() : AppURL: https://hamlundtactical.com/catalog/qbServer.php
20120208.04:39:12 UTC	: QBWebConnector.SOAPWebService.do_serverVersion() : *** Calling serverVersion().
20120208.04:39:13 UTC	: QBWebConnector.SOAPWebService.do_serverVersion() : Actual error received from web service for serverVersion call: <Function 'serverVersion' doesn't exist>. For backward compatibility of all webservers, QBWC will catch all errors under app-not-supporting-serverVersion.
20120208.04:39:13 UTC	: QBWebConnector.SOAPWebService.do_serverVersion() : This application does not contain support for serverVersion. Allowing update operation for backward compatibility.
20120208.04:39:13 UTC	: QBWebConnector.SOAPWebService.do_clientVersion() : *** Calling clientVersion() with following parameter:<productVersion="2.0.0.139">
20120208.04:39:13 UTC	: QBWebConnector.SOAPWebService.updateWS() : Actual error received from web service for clientVersion call: <Function 'clientVersion' doesn't exist>. For backward compatibility of all webservers, QBWC will catch all errors under app-not-supporting-clientVersion.
20120208.04:39:13 UTC	: QBWebConnector.SOAPWebService.do_clientVersion() : This application does not contain support for clientVersion. Allowing update operation for backward compatibility.
20120208.04:39:13 UTC	: QBWebConnector.SOAPWebService.do_authenticate() : Authenticating to application 'ZenCart Quickbooks Sync', username = 'epicdopecom'
20120208.04:39:13 UTC	: QBWebConnector.SOAPWebService.do_authenticate() : *** Calling authenticate() with following parameters:<userName="epicdopecom"><password=<MaskedForSecurity>
20120208.04:39:17 UTC	: QBWebConnector.SOAPWebService.updateWS() : Received from authenticate() following parameters:<authRet[0]="0ced1cdf13dd7933763dbb6b8ce725bd"><authRet[1]="null"><authRet[2]=""><authRet[3]="">
20120208.04:39:17 UTC	: QBWebConnector.RegistryManager.setCurrentWebServiceName() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\CurrentWebServiceName has been set to ZenCart Quickbooks Sync
20120208.04:39:17 UTC	: QBWebConnector.RegistryManager.setCurrentWebServiceSessionTicket() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\CurrentWebServiceSessionTicket has been set to 0ced1cdf13dd7933763dbb6b8ce725bd
20120208.04:39:17 UTC	: QBWebConnector.SOAPWebService.CheckCFNResponse() : User authenticated.
20120208.04:39:17 UTC	: QBWebConnector.SOAPWebService.do_authenticate() : Done.
20120208.04:39:17 UTC	: QBWebConnector.SOAPWebService.OpenConnection() : Connecting to QuickBooks...
20120208.04:39:17 UTC	: QBWebConnector.SOAPWebService.OpenConnection() : Connected., Session started
20120208.04:39:17 UTC	: QBWebConnector.CompanyFileLock.Send_CompanyQueryRqXML() : XML dump follows: -

<?xml version="1.0"?><?qbxml version="10.0"?><QBXML><QBXMLMsgsRq onError="s......

20120208.04:39:17 UTC	: QBWebConnector.CompanyFileLock.Send_CompanyQueryRqXML() : XML dump follows: -

<?xml version="1.0" ?>
<QBXML>
<QBXMLMsgsRs>
<CompanyQueryRs requestID="1" ......

20120208.04:39:17 UTC	: QBWebConnector.CompanyFileLock.getLock() : Got Lock = UNLOCKED:SERVER
20120208.04:39:17 UTC	: QBWebConnector.CompanyFileLock.IsLocked() : Lock = UNLOCKED. Returning false.
20120208.04:39:17 UTC	: QBWebConnector.CompanyFileLock.Send_DataExtModRqXML() : XML dump follows: -

<?xml version="1.0"?><?qbxml version="10.0"?><QBXML><QBXMLMsgsRq onError="s......

20120208.04:39:17 UTC	: QBWebConnector.CompanyFileLock.Send_DataExtModRqXML() : XML dump follows: -

<?xml version="1.0" ?>
<QBXML>
<QBXMLMsgsRs>
<DataExtModRs requestID="1" st......

20120208.04:39:17 UTC	: QBWebConnector.CompanyFileLock.setLock() : Lock has been set to value = <LOCKED:SERVER:634642727577528745> in QuickBooks for ownerID = <{CD8D6B56-9AF2-11DD-ACC9-5D4756D89593}>
20120208.04:39:18 UTC	: QBWebConnector.CompanyFileLock.Send_CompanyQueryRqXML() : XML dump follows: -

<?xml version="1.0"?><?qbxml version="10.0"?><QBXML><QBXMLMsgsRq onError="s......

20120208.04:39:19 UTC	: QBWebConnector.CompanyFileLock.Send_CompanyQueryRqXML() : XML dump follows: -

<?xml version="1.0" ?>
<QBXML>
<QBXMLMsgsRs>
<CompanyQueryRs requestID="1" ......

20120208.04:39:19 UTC	: QBWebConnector.CompanyFileLock.getLock() : Got Lock = LOCKED:SERVER:634642727577528745
20120208.04:39:19 UTC	: QBWebConnector.SOAPWebService.update() : Company file has been locked for update.
20120208.04:39:19 UTC	: QBWebConnector.SOAPWebService.update() : Synchronizing with QuickBooks Company Name = HamLund Tactical
20120208.04:39:19 UTC	: QBWebConnector.SOAPWebService.do_sendRequestXML() : Asking application to send request no. 1
20120208.04:39:19 UTC	: QBWebConnector.SOAPWebService.do_sendRequestXML() : *** Calling sendRequestXML() with following parameters:
20120208.04:39:19 UTC	: QBWebConnector.SOAPWebService.do_sendRequestXML() : wcTicket="0ced1cdf13dd7933763dbb6b8ce725bd"
20120208.04:39:19 UTC	: QBWebConnector.SOAPWebService.do_sendRequestXML() : HCPResponseXML=
20120208.04:39:19 UTC	: QBWebConnector.SOAPWebService.do_sendRequestXML() : XML dump follows: -

<?xml version="1.0" ?>
<QBXML>
<QBXMLMsgsRs>
<HostQueryRs requestID="0" sta......

20120208.04:39:19 UTC	: QBWebConnector.SOAPWebService.do_sendRequestXML() : cfn="C:\Users\Public\Documents\Intuit\QuickBooks\Company Files\HamLund Tactical.QBW"
20120208.04:39:19 UTC	: QBWebConnector.SOAPWebService.do_sendRequestXML() : qbNationality="US"
20120208.04:39:19 UTC	: QBWebConnector.SOAPWebService.do_sendRequestXML() : qbXMLMajorVers="10"
20120208.04:39:19 UTC	: QBWebConnector.SOAPWebService.do_sendRequestXML() : qbXMLMinorVers="0"
20120208.04:39:19 UTC	: QBWebConnector.SOAPWebService.do_sendRequestXML() : QBWC1041: SendRequestXML failed.
Error message: Call to undefined function mb_convert_encoding()
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.sendRequestXML(String ticket, String strHCPResponse, String strCompanyFileName, String qbXMLCountry, Int32 qbXMLMajorVers, Int32 qbXMLMinorVers)
   at QBWebConnector.localhost.WCWebService.sendRequestXML(String ticket, String strHCPResponse, String strCompanyFileName, String qbXMLCountry, Int32 qbXMLMajorVers, Int32 qbXMLMinorVers)
   at QBWebConnector.SOAPWebService.sendRequestXML(String wcTicket, String HCPResponseXML, String cfn, String qbNationality, Int32 qbXMLMajorVers, Int32 qbXMLMinorVers)
   at QBWebConnector.WebService.do_sendRequestXML(Int32 x, String wcTicket, String HCPResponseXML, String cfn, String qbNationality, Int32 qbXMLMajorVers, Int32 qbXMLMinorVers, Boolean& timeout)
Source = System.Web.Services
20120208.04:39:19 UTC	: QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock has been set to False
20120208.04:39:19 UTC	: QBWebConnector.RegistryManager.setUpdateLock() : ********************* Update session unlocked *********************
20120208.04:39:19 UTC	: QBWebConnector.SOAPWebService.do_getLastError() : *** Calling getLastError() with following parameter:
20120208.04:39:19 UTC	: QBWebConnector.SOAPWebService.do_getLastError() : wcTicket="0ced1cdf13dd7933763dbb6b8ce725bd"
20120208.04:39:20 UTC	: QBWebConnector.SOAPWebService.do_getLastError() : Received from getLastError() following parameter:
20120208.04:39:20 UTC	: QBWebConnector.SOAPWebService.do_getLastError() : errorMsg="LOG: User Started Session 
"
20120208.04:39:20 UTC	: QBWebConnector.SOAPWebService.do_getLastError() : Received error from application: LOG: User Started Session 

20120208.04:39:20 UTC	: QBWebConnector.CompanyFileLock.Send_CompanyQueryRqXML() : XML dump follows: -

<?xml version="1.0"?><?qbxml version="10.0"?><QBXML><QBXMLMsgsRq onError="s......

20120208.04:39:20 UTC	: QBWebConnector.CompanyFileLock.Send_CompanyQueryRqXML() : XML dump follows: -

<?xml version="1.0" ?>
<QBXML>
<QBXMLMsgsRs>
<CompanyQueryRs requestID="1" ......

20120208.04:39:20 UTC	: QBWebConnector.CompanyFileLock.getLock() : Got Lock = LOCKED:SERVER:634642727577528745
20120208.04:39:20 UTC	: QBWebConnector.CompanyFileLock.Send_DataExtModRqXML() : XML dump follows: -

<?xml version="1.0"?><?qbxml version="10.0"?><QBXML><QBXMLMsgsRq onError="s......

20120208.04:39:20 UTC	: QBWebConnector.CompanyFileLock.Send_DataExtModRqXML() : XML dump follows: -

<?xml version="1.0" ?>
<QBXML>
<QBXMLMsgsRs>
<DataExtModRs requestID="1" st......

20120208.04:39:20 UTC	: QBWebConnector.CompanyFileLock.unsetLock() : Company file has been unlocked for ownerID = <{CD8D6B56-9AF2-11DD-ACC9-5D4756D89593}>
20120208.04:39:20 UTC	: QBWebConnector.SOAPWebService.update() : Company file has been unlocked.
20120208.04:39:20 UTC	: QBWebConnector.SOAPWebService.update() : Ending session to QuickBooks.
20120208.04:39:20 UTC	: QBWebConnector.SOAPWebService.DisconnectFromQB() : Session ended and connection closed
20120208.04:39:20 UTC	: QBWebConnector.SOAPWebService.do_closeConnection() : *** Calling closeConnection() with following parameter:<wcTicket="0ced1cdf13dd7933763dbb6b8ce725bd">
20120208.04:39:20 UTC	: QBWebConnector.SOAPWebService.do_closeConnection() : Received from closeConnection() following parameter:<ccResponse="Thank your for Using the Zen Cart QuickBooks Connector">
20120208.04:39:20 UTC	: QBWebConnector.SOAPWebService.do_closeConnection() : CloseConnection called to application.
20120208.04:39:20 UTC	: QBWebConnector.SOAPWebService.do_closeConnection() : Response received from application = Thank your for Using the Zen Cart QuickBooks Connector
20120208.04:39:21 UTC	: QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock has been set to False
20120208.04:39:21 UTC	: QBWebConnector.RegistryManager.setUpdateLock() : ********************* Update session unlocked *********************
20120208.04:39:21 UTC	: QBWebConnector.SOAPWebService.update() : update completed.
20120208.04:39:21 UTC	: QBWebConnector.WebServiceManager.DoUpdateSelected() : Update for application = 'ZenCart Quickbooks Sync' has COMPLETED
20120208.04:39:21 UTC	: QBWebConnector.WebServiceManager.DoUpdateSelected() : Update session has ended.

When I go to quickbooks there is no information.

I am running Zen Cart 1.3.9h and using QuickBooks Premier 2011. Any help is appreciated.

[whiskeylover]

I've started running into what looks like the same issue that bpryor was having in post #212 with the authentication errors. I'm still running ZC 1.3.9h and version 2.02 of the QB Sync.

Message:
Authentication failed

Description:
QBWC1012: Authentication failed due to following error message.
Maximum execution time of 30 seconds exceeded

It was working fine for a few months, then stopped working three days ago. Even odder, on March 6th, I was looking at the errors to see why it wasn't importing a few orders. I clicked the Update Selected button. Did a little more troubleshooting, then clicked Update Selected again and it started timing out. It's been doing it ever since. I'm my own host, so I can't blame that guy.

20120308.15:18:17 UTC	: QBWebConnector.WebServiceManager.DoUpdateSelected() : updateWS() for application = 'ZenCart Quickbooks Sync' has STARTED
20120308.15:18:17 UTC	: QBWebConnector.RegistryManager.getUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock = FALSE
20120308.15:18:17 UTC	: QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock has been set to True
20120308.15:18:17 UTC	: QBWebConnector.RegistryManager.setUpdateLock() : ********************* Update session locked *********************
20120308.15:18:17 UTC	: QBWebConnector.SOAPWebService.instantiateWebService() : Initiated connection to the following application.
20120308.15:18:17 UTC	: QBWebConnector.SOAPWebService.instantiateWebService() : AppName: ZenCart Quickbooks Sync
20120308.15:18:17 UTC	: QBWebConnector.SOAPWebService.instantiateWebService() : AppUniqueName (if available): ZenCart Quickbooks Sync
20120308.15:18:17 UTC	: QBWebConnector.SOAPWebService.instantiateWebService() : AppURL: https://domain.com/catalog/qbServer.php
20120308.15:18:17 UTC	: QBWebConnector.SOAPWebService.do_serverVersion() : *** Calling serverVersion().
20120308.15:18:19 UTC	: QBWebConnector.SOAPWebService.do_serverVersion() : Actual error received from web service for serverVersion call: <Function 'serverVersion' doesn't exist>. For backward compatibility of all webservers, QBWC will catch all errors under app-not-supporting-serverVersion.
20120308.15:18:19 UTC	: QBWebConnector.SOAPWebService.do_serverVersion() : This application does not contain support for serverVersion. Allowing update operation for backward compatibility.
20120308.15:18:19 UTC	: QBWebConnector.SOAPWebService.do_clientVersion() : *** Calling clientVersion() with following parameter:<productVersion="2.0.0.139">
20120308.15:18:20 UTC	: QBWebConnector.SOAPWebService.updateWS() : Actual error received from web service for clientVersion call: <Function 'clientVersion' doesn't exist>. For backward compatibility of all webservers, QBWC will catch all errors under app-not-supporting-clientVersion.
20120308.15:18:20 UTC	: QBWebConnector.SOAPWebService.do_clientVersion() : This application does not contain support for clientVersion. Allowing update operation for backward compatibility.
20120308.15:18:20 UTC	: QBWebConnector.SOAPWebService.do_authenticate() : Authenticating to application 'ZenCart Quickbooks Sync', username = 'adminname'
20120308.15:18:20 UTC	: QBWebConnector.SOAPWebService.do_authenticate() : *** Calling authenticate() with following parameters:<userName="adminname"><password=<MaskedForSecurity>
20120308.15:18:50 UTC	: QBWebConnector.SOAPWebService.do_authenticate() : QBWC1012: Authentication failed due to following error message.
Maximum execution time of 30 seconds exceeded
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
20120308.15:18:50 UTC	: QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock has been set to False
20120308.15:18:50 UTC	: QBWebConnector.RegistryManager.setUpdateLock() : ********************* Update session unlocked *********************
20120308.15:18:50 UTC	: QBWebConnector.WebServiceManager.DoUpdateSelected() : Update completed with errors. See log (QWClog.txt) for details.

Is something staring at me that I'm just missing? I just can't seem to brute force my way through this.

[whiskeylover]

I forgot to add that the test QWC from the Intuit site works just fine.

[creinold]

Increase your php execution time out and maybe allow more memory to help.

[totalsam]

Hello,

Having problems now we are registered for VAT. For various reasons we don't currently use the built in ZC taxing system. So as far as ZC is concerned we don't have tax.

When importing into Quickbooks (which does recognise our tax needs) we import using standard codes for quickbooks but this always produces and extra VAT charge on each order.

ie
We charge the customer £10

Quickbooks then creates the sale as £10.00 sales £2 VAT
when really the sale is £10.00 and VAT is £1.67 included in the price.

Can the order not be imported with the amounts include VAT box prechecked so the figures all add up correctly?

(Importing as a sales order with QBS - Items in Order Added as Taxable or Non-Taxable setting as 3)

Any help would be much appreciated as this is going to get very frustrating editing every order manually if I can't find a fix fast!!

[newbey]

I am running Zen Cart 1.3.8a and QB Enterprise 12. The Quickbooks Synch process runs fine on my old computer. In trying to get it installed on a new desktop, the error below occurs every time I try to "Add an application" in the QuickBooks Web Connector.

QBWC1039: There was a problem adding the application. Check QWCLog.txt for details.
Unique OwnerID/FileID pair value required

[charmlt]

What is the bSync.php file?
I did a search for it and I could not find any reference to it in this forum.
It is one of the download files listed, acording to Zen Cart Quick Book Sync Web Service 2.php instructions.