Quickbook Sync

[srturner47]

foteek -- It seems that this error is related to a possible bug in Zen Cart. Read through this thread here. The advice may help you:

http://www.zen-cart.com/forum/showthread.php?t=122683


tj1 -- Well, yes, you can do this. But it won't work out too well for you. What if an old customer places a new order? Then, your customer won't be in Quickbooks, so it won't be able to export the order to Quickbooks. Every invoice, sales order, or sales receipt in Quickbooks must be associated with a QB Customer. Plus, your products need to be in Quickbooks in case someone orders them. I really am confused about why you would want to do this....but...

If you still decide to do this, just make sure the value quickbooks is set to 1 for all orders, products, and customers that you already have when running the SQL patch to install the mod. Setting it to 1 will tell the mod to ignore the customers, products, and orders you already have. There are instructions about how to do this in the manual.

[foteek]

Thanks for your help, unfortunately the fix didn't help me.

I'm brand new to quickbooks, in fact I just bought it today. Is there anything I need to do to prepare it before I can connect? All I did was set up a "company" as a retail store, and left it at that. I haven't set up anything else, I was hoping this import would fill in a bunch of things for me...

Thanks again for your help!

[srturner47]

I really hate when people answer by saying read the manual. But honestly, you need to read the manual. It will explain all -- that is simply too broad of a question! :)

[foteek]

Fair enough. But are you talking about the qb sync manual (the pdf in your zip)? Because I've read that multiple times, and frankly I don't understand the first paragraph well.

If I do understand it, I thought I could just leave all the sync match variables blank, and it would pass through the ZC names into QB. If you're talking about a different manual, by all means let me know and I'll start reading!

Thanks!

[srturner47]

Yes. That is correct. If you leave everything blank they should transfer through using the ZC names.

If your QB names are different from your ZC names, you need to match the ZC names to the QB names. Go to Admin->Tools->Quickbooks Sync Match to do so.

[tj1]

tj1 -- Well, yes, you can do this. But it won't work out too well for you. What if an old customer places a new order? Then, your customer won't be in Quickbooks, so it won't be able to export the order to Quickbooks. Every invoice, sales order, or sales receipt in Quickbooks must be associated with a QB Customer. Plus, your products need to be in Quickbooks in case someone orders them. I really am confused about why you would want to do this....but...

If you still decide to do this, just make sure the value quickbooks is set to 1 for all orders, products, and customers that you already have when running the SQL patch to install the mod. Setting it to 1 will tell the mod to ignore the customers, products, and orders you already have. There are instructions about how to do this in the manual.

Sorry, I don't think I explained correctly.

The reason why I don't want to export past customers/orders/products to QB is because I have already imported them before. I currently use the other mod QBI, but it's a bit restricted and lacks some features Quickbooks Sync has.
If I export everything initially with Quickbooks Sync I would most likely create duplicates, correct?

Does this mod have a setting to allow to import orders with certain order status, for example import only orders with 'pending' status?


Thanks.

[srturner47]

If an order, product, or customer already exists, QBsync can do two things:

1. This mod has a matching feature. Just turn on MATCH customers, products, and orders. Its the last three options in Admin->Configuration->QBSync. Then, anytime a customer, order, or product already exists in Quickbooks, it will figure this out and store the match in your database.

2. You don't have to use match, but without it, you can't use some of the more advanced features of QBSync like continuing sync. See the manual for more details. If you don't use match, QBSync will automatically ignore any duplicates.

Either way, just make sure that your naming convention for orders and customers is the same as it was with QBI. If they don't match exactly, it can't determine that it already exists in Quickbooks.

You should also consider very carefully when installing the SQL patch whether or not you want to mark quickbooks as 1 or 0 for products, customers, and orders. Anything marked as 1 will be completely ignored. No matching or exporting will take place.

It sounds to me like your best bet is to turn matching on for products and customers and mark quickbooks as 0 for these in the SQL patch. Then, turn matching off for orders and mark quickbooks as 1 in the SQL patch for all orders. This will ignore orders. Matching them is less important as orders can't really change anyway. However, matching products and customers can be very useful, especially if you choose to use continuing sync. This will only effect old orders, new ones should still export just fine.

[helpme]

I am trying this again, I think I was doing it wrong before...how do I import the QWC file? I tried adding it to Quickbooks but I can't get it o import.
I am not extremely knowledgable with QB.
thanks for any help....I REALLY need this to start working!
Happy New Year!

[pglock]

Sorry to come back yet again. I'm still unable to get any transactions to sync. Just to recap, I'm in the UK, using UK VAT as the tax. The tax codes in QB are 'S' for standard (now 17.5%) and '0' for zero rated. I have set up the Sales Tax QB sync page as shown in the attached screen grab. When I try to sync I get the error message in the notification email:

Errors are Listed Below:
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.

Any idea what I'm doing wrong?

[srturner47]

helpme -- you don't import or export the QWC file, you run it. It doesn't run from Quickbooks, it runs from Quickbooks Web Connector. You need to download and install Quickbooks Web Connector. Get it here: http://marketplace.intuit.com/webconnector/

pglock -- Not sure what a tax code is. You just need to put the name of the tax here. If you can click on Items and Records (top right hand corner in QB Home) in QB and take a screenshot of the page with the sales tax items on it I can tell you what you need change.