Quickbook Sync

binstar:

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.

Will this work with the online version of Quickbooks?

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.

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. :smile:

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.

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

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

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!!

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

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.

Sorry, I mean the admin/includes/boxes/extra_boxes/qbSync.php file?

Will this work on the online web version?

i am in australia and i was looking to purchase quick books, but i am wondering what version should i purchase, i use bank deposit / poli / paypal as payment options.
all products have gst tax, so any help would be appreciated to which version i should purchase and to intergrate it with zen cart, by the addon section, to keep a track of my books easily, as i really dont like paper work

Danielle:

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.

Since I just went through this myself-- I've been using qbSync and 1.3.9h and upgraded to 1.5 earlier this year and continued to use for awhile without upgrading the admin configuration. Then I added new products and really needed the admin portion. So by following some of what was here, I was able to do it. Just thought I would add a couple of points that might make it easier on the next folks.

1. I put the define statements in a file named qbSync_filenames.php and placed it in the <admin area>/includes/extra_datafiles directory.
2. 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');
3. I made sure the php files referenced were in place already
4. I registered the pages using the GUI Admin Page Registration
5. These are the values I used for my page registration. As noted earlier, you need to match your gID for your quickbooks group id in the zen configuration table (sorry, couldn't figure out how to format very well in here) Also note that for most entries, the page_params is blank

• page_key language_key main_page page_params menu_key display_on_menu sort_order
• qbSync BOX_TOOLS_QUICKBOOKS FILENAME_CONFIGURATION gID=888005 configuration Y 100
• qbSyncLog BOX_TOOLS_QUICKBOOKS_LOG FILENAME_QUICKBOOKS_LOG extras Y 100
• qbSyncMatch BOX_TOOLS_QUICKBOOKS_MATCH FILENAME_QUICKBOOKS_MATCH extras Y 101
• qbSyncPrepare BOX_TOOLS_QUICKBOOKS_PREPARE FILENAME_QUICKBOOKS_PREPARE extras Y 102

I installed this in my "not live" 1.3.9e store in an effort to download all my old orders to Quickbooks. I think that I have followed the instructions but I have no Admin>Configuration>Quickbooks Sync link showing up. I do have the Admin>Tools>Quickbooks Sync Log, Quickbooks Sync Match and Quickbooks Prepare links. Web connect is running on my local machine but Authentication Fails when I try and update. I searched this thread and found one other person that had this problem and resolved it but did not mention exactly how he did it. Can anyone help me with this?

Thanks,
Marc

FiberDawn Thanks for the information, I am having some success with it however I am finding that when I go in to "Match Values" the links on this page log me out. It seems that something needs to be done to have these links pass session ID. I thought I would ask if this was something I missed before I jump in and start changing things.

Thanks!

Hi There,

Im running Zen 1.38 with Quickbooks 2012 Enterprise edition, just installed Quickbooks sync,
It connects fine, imports the customers and completes when i look at the logs i see these errors and i see that the inventory and sales have not be imported this is the errors in the log files :

SimpleXMLElement Object
(
    [QBXMLMsgsRs] => SimpleXMLElement Object
        (
            [ItemInventoryAddRs] => SimpleXMLElement Object
                (
                    [@attributes] => Array
                        (
                            [statusCode] => 3040
                            [statusSeverity] => Error
                            [statusMessage] => There was an error when converting the amount quot;104.9940quot; in the field quot;item sales pricequot;.  QuickBooks error message: This field contains an invalid character.
                        )

                )

        )

)
 6ab5781fe2d08d61802932083c663fc6
08-05-12 01:03:53 AM 
ERROR There was an error when converting the amount "104.9940" in the field "item sales price".  QuickBooks error message: This field contains an invalid character. 

any help will be appreciated

Here is my problem/situation: I need the QBS - Customer Name ID Format to be the customers' email address.

Does the program export orders as "sales orders" to Quickbooks ES V13.0 with the advanced inventory option?

Ugh!

I am about at wits end with this. Great plugin first of all. I have managed to manipulate it to work with v1.5.1. I am using QB Pro 2013 and after much effort (which I will post once it works!) I am able to get customers and products into QB but am jammed with a tax error trying to get Sales Receipts.

Here's the error:

Error:There is an invalid reference to QuickBooks ItemSalesTax "TAX" in the SalesReceipt.

I have ensured that Sales Tax is enabled. I have both TAX and NON tax code items in QB. It seems to be that this error gets thrown regardless of what is used for the tax code 'title' in ZC (orders_total, 'title').

At times I can also get the error to display this:

QuickBooks error message: Invalid argument. The specified record does not exist in the list.

What exactly is the 'list'? If its the QB Item List then something is up because the TAX item is definately there. I suspect this is an issue with matching between ZC/QB but I am running out of possible theories.

Anyone?

Thanks.

Hi Gkeaney,

Did you ever got it to work with 1.5.1?

If you did could you post it here so I can follow your leads?

Thanks.