Quickbook Sync

[wolfderby]

I started a new quickbooks company to start off with and things weren't syncing correctly. I then tried to start a new company to get a fresh start but realized that the quickbooks number was 1 instead of 0 in the tables, so it wasn't syncing them. My Customer name's and product names go in, as well as the price but the product quantity does not. So "On Hand" in quickbooks is always zero. Also none of my transactions are going in as sales receipts, or as anything else for that matter.

I'm also receiving about 100 of these:

3240

Time creation mismatch

Object “fieldValue” specified in the request cannot be found.

I keep receiving the following error message in my log:

SimpleXMLElement Object
(
    [QBXMLMsgsRs] => SimpleXMLElement Object
        (
            [ItemInventoryModRs] => SimpleXMLElement Object
                (
                    [@attributes] => Array
                        (
                            [statusCode] => 3240
                            [statusSeverity] => Error
                            [statusMessage] => Object quot;800000C7-1271112511quot; specified in the request cannot be found. 
                        )

                )

        )

)

[srturner47]

That is correct. QBSync does not export or sync the quantity on hand.

As for your error, it means that there was a product in your QB file that ZC had previously identified and matched to a product in ZC -- OR -- that ZC had exported a product to your QB file. Either way, QBSync is now looking for a product that no longer exists.

You'll need to drop the three QBSync record tables and start over for it to work properly if you've modified the QB file or started a new QB file and change the "quickbooks" value to "0" for all products, customers, and orders. This will start everything over from scratch with QBSync.

[lifecoachvaness]

Ok, I have a question. This issue has been giving me a hard time. I am seeing the transactions in my zen cart admin once someone makes a payment but no payment is taken from the client's card and no payment is deposited into my account. I don't even see the transactions posted in my merchant services center.

I installed the qbms module to receive payments through Intuit Merchant Services. I setup my application and received my connection ticket. I am using the Desktop model.

I checked with Intuit and they see the connection between my application and their system. The person who makes the purchase also gets a confirmation that their transaction was successful.

Any ideas on what I should do to resolve this issue?

I really need to get this working right away.

Thanks.

[srturner47]

This mod is for exporting and syncing data between from ZC -> QB. It has nothing to do with merchant services or charging credit cards. I think there is another forum for payment modules, I'd check there. :)

[bizcatalyst]

Hello again,
I've resolved the multiple COGS account issue by adding a new COGS account in QB that is used just for new products added in zen cart. But now when I try the initial sync I get an error saying the following for each product:
There is an invalid reference to QuickBooks Vendor "" in the Items.

An example entry in the log has this:
[PrefVendorRef] => SimpleXMLElement Object
(
[FullName] => SimpleXMLElement Object

I also noticed that in the configuration, the following setting is 1, which means "Use Zen Carts Manufacturer":
QBS - Preferred Vendor of Products Added

Does this error mean that the products which do not have manufacturers specified will not be added to QB? This part of the latest release notes seems to support to my theory but I thought I would ask to be sure:
"- Created ability to ignore Preferred Vendor which allows products to be added without setting up
manufacturers as Vendors."
Thanks,
Robert

[bizcatalyst]

Hello again,
So I changed the config setting to 0 (the one I mentioned on May 4th) and I was happy to see the products imported without errors. :)

However, I did get an error when importing an order which required shipping. I had setup shipping to use a table for calculating the amount, and in the xml passed to QB the shipping charge looks like a separate item. The error I received is this -

Error:There is an invalid reference to QuickBooks Item "Table Rate (Best Way):" in the SalesReceipt line. QuickBooks error message: Invalid argument. The specified record does not exist in the list.

Does this mean I need to create a new product in quickbooks called "Table Rate (Best Way)" ? That doesn't sound right to me but I'm not sure how else to interpret that error.
Thank you,
Robert

[srturner47]

Yes, if you set that setting to 1, you need to add all the manufacturers to QB, or the import won't work right. Set it to 0 and manufacturers will be ignored. Seems like you already did that though! :)

You need to match the shipping. Go to the match page, make the first value *. This will catch all shipping types that don't have a match yet. Then create an item for shipping in QB. Then, the second value should be the name of this item.

[bizcatalyst]

Hello again,
Before I ask about my latest error I just wanted to mention how pleased I am to have received answers to all my questions in this forum. I appreciate that.

Currently I have setup the QBSync and successfully transferred products and orders (with and without shipping) from zencart to QB.

Today I received errors after products were deleted in zencart and the auto sync occurred. The message in the QBSync log for each deleted item is this:
"Error:There was an error adding, modifying or deleting the ItemInventory
specified by the id = 800005F1-1231034479 because it is already in use."

What does it mean that the ItemInventory is in use? I assume that's referring to the item being "in use" in quickbooks, but what does that mean?

Thanks,
Robert

[srturner47]

I think it means that it is already in an order in QB. Hence, you can't delete it in QB.

Now here's the strange part -- I setup the delete functionality such that if an order can't be deleted, it can still handle the situation. Hence, even though QB sends an error, it shouldn't pass that error onto you.

See the setting:

QBS - CS-Change Products Allow Product Deletion
Continuing Sync - Delete Products in Quickbooks When Deleted in Zen Cart (0 - never delete, 1 - make product inactive in quickbooks, 2 - delete, 3 - try to delete, but if that doesnt work make the product inactive in quickbooks)

This will tell you how you are currently setup to handle this situation.

Now........its been quite awhile since I coded this. But, I know I use selection 3. And in this case, the product becomes inactive in QB when it can't be deleted.

I just don't remember exactly how I coded it for selection 2. If you selected this, maybe I set it up to throw out the error if it can't delete it because there are no other alternatives. Check your settings, if it is set to 2, then I bet this is the issue. Change it to 3 -- works much better!

If not....I'm not really sure why you are receiving an error.

[bizcatalyst]

Thank you for your prompt reply, unfortunately my setting for that value is already 3 (that must be the default). I'll ignore it for now, the worst that can happen is that products don't get deleted from quickbooks when they're deleted from zen cart, right? So it is the same as if I choose a value of 0 for that setting in the worst case scenario?