Quickbook Sync

[pglock]

Here's a screenshot. Note: This is from QuickBooks Pro 2008 UK. Let me know what to do next.

[helpme]

I finally have it working. I am having problems with importing my customers....it seems that some are importing but others are just going in as an error. I can't find anything in common with them, apostrophes or anything like that.

Here is what is emailed to me:
Error:The query request has not been fully completed. There was a required
element ("Doe,John") that could not be found in QuickBooks.

there is one error for each customer....I have ran it several times and the last 2 times it has come up with the same errors exactly.

[helpme]

I finally have it working. I am having problems with importing my customers....it seems that some are importing but others are just going in as an error. I can't find anything in common with them, apostrophes or anything like that.

Here is what is emailed to me:
Error:The query request has not been fully completed. There was a required
element ("Doe,John") that could not be found in QuickBooks.

there is one error for each customer....I have ran it several times and the last 2 times it has come up with the same errors exactly.

Ok, I got it to go through without any errors after I changed it to customers not match. However, my products imported but my sales didn't seem to...at least I can't find them any where. I also see that my inventory did not import.
Any suggestions?

[srturner47]

pglock -- See the things under Name in Quickbooks. Those are what you have to enter for matching. I see no S or Z there. That's your problem. So for example, TAX you might want to match it with Standard Purchases instead of S.

helpme -- What do you mean by inventory? This mod will not sync inventory levels. It will export the products themselves, but not how many are in stock. As for why they aren't importing, you'll have to check the error log for more details.

[helpme]

pglock -- See the things under Name in Quickbooks. Those are what you have to enter for matching. I see no S or Z there. That's your problem. So for example, TAX you might want to match it with Standard Purchases instead of S.

helpme -- What do you mean by inventory? This mod will not sync inventory levels. It will export the products themselves, but not how many are in stock. As for why they aren't importing, you'll have to check the error log for more details.

Ok, good to know on the inventory. I actually am not getting any errors, but the sales or transactions are not showing up in QB. I did get all of the customers to import and the products, but no sales. Unless I am looking in the wrong area....I am looking at the customer then going to their transaction page, but I click through all of the options and there is nothing there.

[helpme]

Tried to add this but it won't let me:
I also am still having problems when a new customer signs up, if I have matching set to 1 my new customers give an error when I sync.
Thanks a ton for all the help...if I need to sign up for help somewhere (& pay) someone direct me to the right place.

Again, there are no errors now (as long as I have match set to 0) I am at a loss as to what to even do next.

[cowspot]

So I setup everything as per the manual, without a hitch. Go into Admin->Tools->Quickbooks Sync Match and I get the error:
Parse error: parse error, unexpected '{' in /home/content/x/x/x/xxxx/html/catalog/quickbooksSync/qbClass.php on line 64

I checked and the line code is:
try{

Am I missing something? I can not seem to find anyone on here that has had this issue.

Using v2.01

[bpryor]

cowspot,

When you get an error like that it almost certainly occured sometime earlier in the file, not the line the error is reported on. I would either suspect a corrupted file or if a constant that's being pulled in had an error in it, it could cause that error, but the only constant I see above there is QUICKBOOKS_TABLE_LOG, which I doubt you edited, but I'd check the file that constant is in too and make sure the file is ok.

[pglock]

I've tried two things:

1. Adding a new Tax called "TAX' to QuickBooks
2. Updating the Matching to Standard Purchases

Both give the same 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

Looking at the XML it shows [excerpt]:

  [ItemSalesTaxRef] => SimpleXMLElement Object
                               (
                                   [FullName] => Zero-Rated Sales
                               )

                           [IsToBePrinted] => 0
                           [IsToBeEmailed] => 0
                           [SalesReceiptLineAdd] => Array
                               (
                                   [0] => SimpleXMLElement Object
                                       (
                                           [ItemRef] => SimpleXMLElement
Object
                                               (
                                                   [FullName] => anchorcut
                                               )

                                           [Desc] => Anchor Cookie Cutter
                                           [Quantity] => 1
                                           [Rate] => 1.6957
                                           [SalesTaxCodeRef] =>
SimpleXMLElement Object
                                               (
                                                   [FullName] => TAX

It looks to me like I need to match both "ItemSalesTaxRef" and "SalesTaxCodeRef" for the transaction to be recorded. Any idea how to do this?

P.S. I'm working with a copy of our 'live' QuickBooks file and the production Zen Cart instance so it's taking a while to run each test, sorry it's taking a while to get back to you on this.

[cowspot]

cowspot,

When you get an error like that it almost certainly occured sometime earlier in the file, not the line the error is reported on. I would either suspect a corrupted file or if a constant that's being pulled in had an error in it, it could cause that error, but the only constant I see above there is QUICKBOOKS_TABLE_LOG, which I doubt you edited, but I'd check the file that constant is in too and make sure the file is ok.

bpryor,

That is an excellent tip. I checked my db and there is no table called quickbooks_table_log , there is only a quickbooks_log table.

Do you think that could be it? I checked older versions of this add on and the file always references that table name but the sql creation file does not have reference to a table creation of that name.

Do you think I should edit the file or will it mess everything up?