Quickbook Sync

[Koi Supplies UK]

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

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

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

[srturner47]

Found one more issue:

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

[Koi Supplies UK]

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

[the_ancient]

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

[srturner47]

Thanks for the prompt response the_ancient. Don't know why I had authentication issues before, but my changes seem to work now.

I've been working a little on this mod. I fixed the problem with international orders: It seems that QBXML doesn't work so well with anything but simple ASCII characters. Hence, letters with accents and other characters from different languages were causing problems. Took several hours finding and fixing the problem, but I found a decent fix for it. In addition, I've added the payment method to sales receipts.

Part of the learning curve was figuring out how QBXML works, as I've never used it before. For those who are new to QBXML, check out this link: http://developer.intuit.com/qbsdk-cu...OSR/index.html -- it's a lifesaver.

Next, I'm going to implement multiple tax rates and automatic inventory updates (instead of just one time when you first run it). I'd be happy to upload my changes to zen-cart.com's free software once I finish, but I don't want to step on any toes. Let me know if that is OK, the_ancient.

BTW - kudos to you the_ancient! This mod makes handling Quickbooks so much easier. You just set it and forget it...Ron Popeil would be proud!

[the_ancient]

Next, I'm going to implement multiple tax rates and automatic inventory updates (instead of just one time when you first run it). I'd be happy to upload my changes to zen-cart.com's free software once I finish, but I don't want to step on any toes. Let me know if that is OK, the_ancient.

BTW - kudos to you the_ancient! This mod makes handling Quickbooks so much easier. You just set it and forget it...Ron Popeil would be proud!

The only thing I ask is that I get credit for the code I wrote,

Having someone build on our Code is the main purpose IMO of OpenSource development, I want to add all of the items you plan to, unfortunately they are not needed for my Employer and I have zero time during my off hours (when I get off Hours) to advance this so it get no feature additions.

If you want to improve it

[Koi Supplies UK]

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