Quickbook Sync

fusionsp:

ok im newer to all of this. How do i change the default value to 0 so all new products will sync with QB? Is that in a table somewhere?

The Flag is added to the main Zen products Table

nikki72:

I am getting this error
20090303.18:14:07 UTC : QBWebConnector.WebServiceManager.ReadQWC(QWCReader QWC) : QBWC1048: QuickBooks Web Connector could not verify the web application server certificate.

QBWC1051: The new application was not added

any help with this?

thanks

Are you connecting via a SSL Conntect, meaning your URL has http**s **in it, AND is your certficate signed by a Inuit recognized signing authority. **SELF SIGNED CERT. will not work. **Quickbooks will reject it.

nikki72:

Yes I would love an answer to this so I could use this wonderful app! My ssl cert. is a godaddy cert if that help anyone trouble shoot my issue.

Southport_Red:

Mine is a GoDaddy Certificate as well, not sure if/why that would be significant but it is a common factor

From the QB Developers

Here is a message I received from GoDaddy. It may be helpful in your decision. Their root certificate is from Valicert, which is a certificate authority we support. Some of the troubles people have had was due to not installing the certificate correctly:

When installing a GoDaddy.com secure certificate, it is also necessary to correctly install intermediate certificate(s) which chain the GoDaddy-issued certificate down to the Valicert root certificate contained by default in most browsers and other devices. You are welcome to refer to the following links for more information on how to correctly do this:

You can view the installation instructions based on server software below.

https://certificates.godaddy.c...ionInstructions_alt.go

You can obtain a copy of the intermediate certificate for your server software at the following link:

https://certificates.godaddy.com/Repository.go

Let us know if we can be of further service.

To Contact Us:
Email: [email protected]
Phone: 480-505-8852
FAX: 480-624-2548

Several Other People have reported problems using either QBMS or QBWC services with GoDaddy Certs.

Sorry I cant be of more help

the_ancient:

Are you connecting via a SSL Conntect, meaning your URL has http**s **in it, AND is your certficate signed by a Inuit recognized signing authority. **SELF SIGNED CERT. will not work. **Quickbooks will reject it.

Hi you can add this xml line to the QWC file
<CertURL>https://yoururl.com/</CertURL>

the_ancient:

Everyone, Sorry I have been Absent.... My Full time job is really killing me.

Why, the qbServer makes use of PHP5 internal SOAP Functions
http://www.php.net/manual/en/soap.installation.php

if it is not enabled or you have php4 it will not work

I get this same error, but my CPanel shows I have PHP 5. So, I have to check if it is enabled? Can I enable it myself?

KT Naturals:

I get this same error, but my CPanel shows I have PHP 5. So, I have to check if it is enabled? Can I enable it myself?

create a file with

<?php  
phpinfo();
?>
```Upload this to your webserver and run it from the browser

then look at the "Configure Command" section for  "--enable-soap"



You should be able to enable it yourself depending on your Servers Setup..

is PHP run as a apache module or CGI,  this can be found in the "Server AP" of the above script

Alright, I have that working... now an error:
Message:
ERROR: There is an invalid reference to a parent "ambsconservation.com" in the Customers list. QuickBooks error message: Invalid argument. The specified record does not exist in the list.

Description:
Error message received from application via getLastError(): ERROR: There is an invalid reference to a parent "ambsconservation.com" in the Customers list. QuickBooks error message: Invalid argument. The specified record does not exist in the list.

I didn't see this in my customers list?

the_ancient:

create a file with

> 
> then look at the "Configure Command" section for  "--enable-soap"
> 
> 
> 
> You should be able to enable it yourself depending on your Servers Setup..
> 
> is PHP run as a apache module or CGI,  this can be found in the "Server AP" of the above script

Hi you need to edit your qbclass.php file and remove the refrence to ambsconversation.com, if you are using parent items to your customers in qb you then set that there, if not just remove the text

KT Naturals:

Alright, I have that working... now an error:
Message:
ERROR: There is an invalid reference to a parent "ambsconservation.com" in the Customers list. QuickBooks error message: Invalid argument. The specified record does not exist in the list.

Description:
Error message received from application via getLastError(): ERROR: There is an invalid reference to a parent "ambsconservation.com" in the Customers list. QuickBooks error message: Invalid argument. The specified record does not exist in the list.

I didn't see this in my customers list?

Thank you kindly! :)

mate2009:

Hi you need to edit your qbclass.php file and remove the refrence to ambsconversation.com, if you are using parent items to your customers in qb you then set that there, if not just remove the text

Seemed like everything was loading fine, and then got this:

Version:
Not provided by service

Message:
LOG: User Started Session

Description:
Error message received from application via getLastError(): LOG: User Started Session

Hi the first fault is normal, if you have a look in the log file from within zen cart, you will see what errors are there and beable to work them back, I the mod works and works really well once you have the errors ironed out!! you can copy and paste the erors into word and send it me if you like.

Regards
Mate

KT Naturals:

Seemed like everything was loading fine, and then got this:

Version:
Not provided by service

Message:
LOG: User Started Session

Description:
Error message received from application via getLastError(): LOG: User Started Session

The Why the errors work is when QWC calls "getLastError" the Mod returns the last log entry for that session.

if you got the "user session started" i would assume that meant nothing was qued for sync...

the_ancient:

The simple answer NO...

I do have a update that has not be release yet that will create a sales order for Check Payments.

You would have a instantaneously create

Sales order -> Invoice -> Payment Record

or

Sale Receipt

Which is a Invoice, and Payment Record rolled in to one.

Why create the additional overhead?

Does that mean you can import invoices? Or no not at all? I would rather just have everything invoiced automagically. (and yes I would like that super sized) :smartalec:

Just wondering if anybody can help with this one, QBSync has been working fine, no problems and no changes, bu tyesterday its stopped bringing orders from zencart db in to QB, Ive checked in the database and all orders still say that there not in QB but when i sync it dosent bring them in, neither does it show anything in the error log, although i can see it did make a connection

Cheers
JAs:blink:

I've been adding my customers, and at first any time I had a customer with an apostrophe in their name, address, etc... the sync failed. I figured this was probably an issue with an SQL update so I edited the php script to try and fix it. Well, it wouldn't authenticate, so I removed my edits. Then, everything seemed to work. It seems to have removed all apostrophes.

Any idea why this might have happened? By the way, is there a way to make it authenticate correctly if I change the code? I'd like to make a few custom changes, but obviously this won't work. Does this have something to do with <OwnerID> and <FileID> in the QWC file?

Thanks in advance!

Nevermind! I compared the two files and found a small difference:

return mb_convert_encoding(str_replace(array("\n","\t","'"),' ',$xml), "UTF-8");

Looks like I did leave a very important change (notice the apostrophe!).

Anyway, this fixes the bug, but it's not ideal because it removes all the apostrophes instead of dealing with them appropriately.

I'd still love to be able to edit this thing if I can figure out why it won't authenticate when I make changes.

Found one more issue:

My international customers don't seem to be importing correctly.

srturner47:

I've been adding my customers, and at first any time I had a customer with an apostrophe in their name, address, etc... the sync failed. I figured this was probably an issue with an SQL update so I edited the php script to try and fix it. Well, it wouldn't authenticate, so I removed my edits. Then, everything seemed to work. It seems to have removed all apostrophes.

Any idea why this might have happened? By the way, is there a way to make it authenticate correctly if I change the code? I'd like to make a few custom changes, but obviously this won't work. Does this have something to do with <OwnerID> and <FileID> in the QWC file?

Thanks in advance!

Cheers for this info, this is what was happening with mine, if you manage to fix it please let me know

Cheers
Jay

srturner47:

Nevermind! I compared the two files and found a small difference:

return mb_convert_encoding(str_replace(array("\n","\t","'"),' ',$xml), "UTF-8");

Looks like I did leave a very important change (notice the apostrophe!).

Anyway, this fixes the bug, but it's not ideal because it removes all the apostrophes instead of dealing with them appropriately.

I'd still love to be able to edit this thing if I can figure out why it won't authenticate when I make changes.

I sorry which file did you do this edit in :)

Cheers
JAy

Having apostrophe's in the XML String causes Quickbooks to Error out.

You can remove just the "'" part of that and see if it works, but I doubt it will.

The OwnerID and FileID has nothing to do with your ability to customize the script,

You should be able to make any changes you want as long as your changes adhere to Quickbooks SDK Rules, if you removed the mb_convert or the Sub string replacement, chances are the outputed XML was no longer compatible with Quickbooks thus you errored

@Koi Supplies UK

Did you make any changes? Turn Debug on, and that will log every action the script takes