Quickbook Sync

[srturner47]

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

[goagal]

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.

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

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

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

[treasure4less]

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.

[srturner47]

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.

[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?

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

[robinsonjas]

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

[srturner47]

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.