Quickbook Sync

[srturner47]

You need to run QB Web Connector on your computer. Edit QWCExample file to fit your needs and then open it using Quickbooks Web Connector. You should find Quickbooks Web Connector is installed with most Quickbooks installations, but if not, there is a link in the documentation to download it.

[tj1]

I want to try this mod, but first I want to know it does what I want.

I only want to import new orders. I don't want to import existing customers, existing products or past orders.
Can I do this with this mod or does it always import everything?


Thanks.

[foteek]

I'm running into a problem. It looks like I'm not the first one, but the proposed solution doesn't seem to match my root cause.

When I run the web connector, I get the following error:

Version:
Not provided by service

Message:
Authentication failed

Description:
QBWC1012: Authentication failed due to following error message.
Client found response content type of 'text/html; charset=iso-8859-1', but expected 'text/xml'.
The request failed with the error message:
--

<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="http://developer.intuit.com/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><SOAP-ENV:Body><ns1:authenticateResponse><ns1:authenticateResult><ns1:string>38e7d35ce 6a58f545f1f0ef74595ff90</ns1:string><ns1:string xsi:nil="true"/></ns1:authenticateResult></ns1:authenticateResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>
<br />
<b>Notice</b>: Object of class queryFactoryResult could not be converted to int in <b>Unknown</b> on line <b>0</b><br />

--. See QWCLog for more details. Remember to turn logging on

I have verified that I have PHP 5.2.11, and soap is enabled (--enable-soap).

I've checked the logs, there's no error logs in apache and nothing of interest in QWCLog. Thanks for any help!

What else can I try, or provide to you to help me out?

Thanks!
TJ

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

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