Quickbook Sync

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. 
                        )

                )

        )

)

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.

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.

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

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

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

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.

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

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.

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?

Yes, it shouldn't be much of a problem. But, to be on the safe side, change it to 0, then you won't have the problem at all.

Still don't quite understand why you are having this issue, as it doesn't do this for me. Maybe it has to do with it being an inventory item, as I only use non-inventory items for my store. Strange...

could someone help me with the order sync...
Now I could sync the customers and products, it perfect.
And thanks for your great contributions, srturner47.

But now, I don't know how to sync the order.
At the match page, just for the testing, I have set all zen-cart term to *, and fill a name in the quickbooks tab which I have already add in the quickbooks account base.

When I try to sync the orders, there are no order import in, and at the log, there are not error.

Could you please just give me a simple setting example, so that I could know the procedure.

Just like:
Discounts and Fees
zen cart(ot_coupon) |Quickbooks(coupon)
Sales Receipt Payment Methods / Invoice-Sales Order Terms
zen cart() | Quickbooks(ZC_sales)
Shipping Methods
Zen Cart() | Quickbooks(shipping fee)

I use quickbooks 2010 pro, and all is new install, zen cart is 1.3.8a, and I know how to add account in quickbooks.

Thanks in advance.:cry:

I think I have solved this problem, hope this would help others.

Beacause of the order user name is not the same with the account user name, so system could not export the orders.

I don't know why the deafult set is {lastname},{firstname}at the setting page, but when I fix it by {firstname} {lastname}this problem solved.
:clap::clap::clap::clap:

goagal:

I think I have solved this problem, hope this would help others.

Beacause of the order user name is not the same with the account user name, so system could not export the orders.

I don't know why the deafult set is {lastname},{firstname}at the setting page, but when I fix it by {firstname} {lastname}this problem solved.
:clap::clap::clap::clap:

Sorry, everyone, I should say, I make a big mistake.
After I changed the naming, the web sync just rechanged the downloaded customers, and also without the orders..:cry:

I am getting the following error and my orders are not uploading, can someone look at this and possible advise what may be wrong?

SimpleXMLElement Object
(
[QBXMLMsgsRq] => SimpleXMLElement Object
(
[@attributes] => Array
(
[onError] => continueOnError
)

        [ItemNonInventoryAddRq] => SimpleXMLElement Object
            (
                [ItemNonInventoryAdd] => SimpleXMLElement Object
                    (
                        [Name] => SimpleXMLElement Object
                            (
                            )

                        [IsActive] => 1
                        [SalesTaxCodeRef] => SimpleXMLElement Object
                            (
                                [FullName] => NON
                            )

                        [SalesAndPurchase] => SimpleXMLElement Object
                            (
                                [SalesDesc] => SimpleXMLElement Object
                                    (
                                    )

                                [SalesPrice] => 0.0000
                                [IncomeAccountRef] => SimpleXMLElement Object
                                    (
                                        [FullName] => Sales
                                    )

                                [PurchaseDesc] => SimpleXMLElement Object
                                    (
                                    )

                                [PurchaseCost] => 0
                                [ExpenseAccountRef] => SimpleXMLElement Object
                                    (
                                        [FullName] => Cost of Goods Sold
                                    )

                            )

                    )

            )

    )

)

SimpleXMLElement Object
(
[QBXMLMsgsRs] => SimpleXMLElement Object
(
[ItemNonInventoryAddRs] => SimpleXMLElement Object
(
[@attributes] => Array
(
[statusCode] => 3180
[statusSeverity] => Error
[statusMessage] => There was an error when saving a Items list, element quot;quot;. QuickBooks error message: The name of the list element cannot be blank.
)

            )

    )

)

There was an error when saving a Items list, element "". QuickBooks error message: The name of the list element cannot be blank.

You have a product without a model number. It is trying to add it and failing because there is no model number... actually, it looks like you have no description either.

When purchasing a taxable product (purchased in-state) from my website and applying a coupon the COUPON doesn't come into QB as 'Tax'...so the item is Taxed at the full price.

Example:
Item 1 .......................... $43.95
Discount ....................... $-43.73

Tax (5.4%).................... $2.37
Total ............................ $2.59

Item should be 0.01 Tax after discount...any ideas?

robinsonjas:

When purchasing a taxable product (purchased in-state) from my website and applying a coupon the COUPON doesn't come into QB as 'Tax'...so the item is Taxed at the full price.

Example:
Item 1 .......................... $43.95
Discount ....................... $-43.73

Tax (5.4%).................... $2.37
Total ............................ $2.59

Item should be 0.01 Tax after discount...any ideas?

A bit more info:

Here is a cut from the log:
[Desc] => Discount Coupon JASON
[Rate] => -43.73
[Amount] => -43.73
[SalesTaxCodeRef] => SimpleXMLElement Object
(
[ListID] => 80000002-1169492761
[FullName] => Non
)

The 'Non' is causing my issue; it should be 'Tax'
If I change manually in Quickbooks it fixes my problem.

Not to keep updating my own post but I think I got it fixed.
I noticed the [ItemRef] for the Discount wasn't assigning a [SalesTaxRef], so when imported into QB its was coming in as 'Non'

I updated the block of code for [SalesReceiptAdd] in qbClass.php with an 'if' statement in the discountsfees section.
-> If item is taxed, then we need to add 'TAX' class to COUPON

This is my result...I think it fixes my problem. Anyone see any issues with this?

                                        [Desc] => Discount Coupon JASON 
                                        [Rate] => -39.7500
                                        [SalesTaxCodeRef] => SimpleXMLElement Object
                                            (
                                                [FullName] => TAX

I don't think that this is necessary. They way it is coded is so that if you match ot_coupon to something in QB, whatever the default tax status for whatever you matched to in QB is what will be used. So just go to your item list in QB and change the default tax status of that item.