Quickbook Sync

[pglock]

The import of items has completed, customers bombed out with an error of

2008 MySQL client ran out of memory
in:
[SELECT * FROM zen_quickbooks_log WHERE ticket = '0e77c6150b99cf0a5534c88343b4acc2' ORDER BY id DESC]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Since then each time I kick off a qwc session I get an authentication error of

the operation has timed out

The other thing I got was a message from Quickbooks that I was approaching the list limit of 14,500. Not sure if this could be a problem given that in the tables I have 11,649 customers, 11,625 orders and 1,776 products

[srturner47]

pglock:

The quickbooks value will not change to 1 unless a successful export has occurred, so don't worry about it. When you restart QBSync, it will pick up where it left off.
--------------
Yes, timeouts do happen sometimes -- I've noticed the same thing. We can't do much about this, as our servers control this. But, its only a minor annoyance and won't occur very often with small exports if you continue to use QBSync regularly.
--------------
Yes, you are correct. The way it was written it should have problems if the manufacturer is set to NULL. To fix it find this line:

$manuf = $this->db->Execute('SELECT * FROM '.TABLE_MANUFACTURERS.' WHERE manufacturers_id = '.$products->fields['manufacturers_id']);

and add this line just before it:

if (QBS_PREFERRED_VENDOR == 1 && $products->fields['manufacturers_id'] != NULL)

Then find this line twice:

if (QBS_PREFERRED_VENDOR == 1)

and change it both times to this line:

if (QBS_PREFERRED_VENDOR == 1 && $products->fields['manufacturers_id'] != NULL)

I'll change this code the next time I work on this, but if anyone else if having this problem in the meantime, that is the fix.
--------------
Another bug you found was with the : in the customer name. To fix that, find this line:

$listName = strtoupper(str_replace(array('{lastname}','{firstname}','{zc_customerid}'),array($customer->fields['customers_lastname'],$customer->fields['customers_firstname'], $zenCustID),QBS_CUSTOMER_NAME_FORMAT));

and change it to this

$listName = strtoupper(str_replace(array('{lastname}','{firstname}','{zc_customerid}',':'),array($customer->fields['customers_lastname'],$customer->fields['customers_firstname'], $zenCustID,''),QBS_CUSTOMER_NAME_FORMAT));

Then you need to go through the whole code and search for this:

strtoupper(str_replace(array('{lastname}','{firstname}','{zc_customerid}')

Everytime you find an instance of this, you need to do the same thing you did for the last change -> add ,':' to the end of the first array, and add ,'' to the end of the second array. This should fix this issue. Again, I'll make these changes the next time i get a chance to work on this, but in the meantime, that is how to fix this problem.
--------------
Lastly, the error you are describing is caused when the email error log is sent. It looks like too much memory is being used when this email is being sent. Try turning off email error reporting. However, this won't fix your problem -- it will just alleviate the symptom. Something else is causing a problem, otherwise it wouldn't be sending the error log in the first place. However, if I were a betting man, I would guess that your problem is that your server isn't allowing you to access enough memory for all the SQL communication required for QBSync to work considering how many customers, orders, and items you have. Try turning off Continuing Sync, as this should significantly reduce the number of SQL queries required for QBSync to work.

[pglock]

Thanks for the comprehensive reply. I'll work through the changes and turn CS off for now. A more fundamental issue is that QB Pro 2008 only supports a total of 14,500 items so I'll have to cut down the number of items to be imported before trying again.

[pglock]

A quick update. I've worked out how to solve the 14,500 problem by merging the older customer records together and only importing the last year and this years sales [our year end is August] by applying the following SQL to the database:

UPDATE `zen_orders` SET `quickbooks` = 0 WHERE `date_purchased` > 2008-09-01

Now for the code changes you suggested...

[pglock]

I think it's time to look for some more help. I've managed to import customers from the last two years and a full item list. It also appears that the transactions from the last two years have imported as the `quickbooks` entry for all records in `zen_orders` is now set to '1'.

However, no transactions show up in QB.

There are multiple errors in the logs, mostly to do with missing payment methods and tax codes. I've updated Quickbooks where necessary and made the linkages in qbMatch.

I'm still seeing errors (log attached). Any ideas? Or is it time to start paying for some consulting?

[srturner47]

It looks like your problem lies in matching. There is no sales tax called "Sales Tax:" in your QB file. Check your sales tax name in QB and change it on the matching page. It must match exactly.

[pglock]

I'm still at it, trying to get the matching to work. The current problem is that I get this error:

Error:There is an invalid reference to QuickBooks SalesReceiptLine
SalesTaxCode "TAX" in the SalesReceipt line.  QuickBooks error message:
Invalid argument.  The specified record does not exist in the list.

But I have added a line in QBsync match for TAX => Standard Sales.

Our store is based in the UK so our tax rates are either 15% VAT or Zero-Rated. In QB, I have set 'Standard Sales' to be VAT at 15% and 'Zero-Rated Sales' to be exempt from tax. My match table looks like:

Pass Through = Name

Zen Cart	Quickbooks
TAX           Standard Sales
NON 	         Zero-Rated Sales
Sates Tax: Zero-Rated Sales
UK VAT      Standard Sales
*               Standard Sales

To me, this looks like the only entires for 'SalesTaxCode' that should be passed to QB are 'Standard Sales' or 'Zero-Rated Sales'. Any idea why is 'TAX' being passed through?

[bpryor]

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

I've been able to get it working and it now imports customers and products correctly, but it has an error I can not work out with bringing the invoices into QB.

When the XML is constructed for the invoice you do the following:

<CustomerRef>
                        ');
                if ($Cust_List_ID == '')
                        $xml .= ('							<FullName>'.removeaccents($fullName,209).'</FullName>
                                 ');
                else
                        $xml .= ('							<ListID>'.$Cust_List_ID.'</ListID>
                                 ');
                $xml .= ('			
</CustomerRef>

The customer list ID is correctly filled in(80000005-1259481024), but when it tries to sync with QB it gives the following error:

SimpleXMLElement Object
(
    [QBXMLMsgsRs] => SimpleXMLElement Object
        (
            [CustomerModRs] => SimpleXMLElement Object
                (
                    [@attributes] => Array
                        (
                            [statusCode] => 3120
                            [statusSeverity] => Error
                            [statusMessage] => Object quot;80000005-1259481024quot; specified in the request cannot be found.  QuickBooks error message: Invalid argument.  The specified record does not exist in the list.

I can provide more details if you need them.

Thanks.

Bill

[pglock]

sorry, typo in post #117 'Sates Tax' should be 'Sales Tax'/

[bpryor]

I've been able to get it working and it now imports customers and products correctly, but it has an error I can not work out with bringing the invoices into QB.

Forget that post. What I think I've figured out is that when that order was first sent it had an error, so the ListID was put in the Zencart DB, but it actually didn't succeed so when it tried to update it the ListID had not been added to QB.

I am still having problems but I think until I get the other errors figured out, mostly to do with matching, I can't trust the other errors.

BTW, I still cannot figure out how to determine exactly what a shipping method's name is in QB, so it's turning out to be almost impossible to get Zencart and QB to match.