Thread: Quickbook Sync

Page 7 of 29 FirstFirst ... 5678917 ... LastLast
Results 61 to 70 of 283
  1. #61

    Default Re: Quickbook Sync

    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!

  2. #62

    Default Re: Quickbook Sync

    Quote Originally Posted by srturner47 View Post

    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

  3. #63

    Default Re: Quickbook Sync

    Of course I'll be giving you full credit the ancient. This is exactly why I prefer to work with open source software. :)

    My little changes turned into some big changes. I'll list what I've done, and what I need to do next before releasing this, but I had one question first -- hopefully someone (including the_ancient) can help me understand this. As it stands, check/money orders are sent to QB as a sales order while other payments are sent as sales receipts. I'd never heard of a sales order before, so I had to look it up. Apparently they are a way to store purchases from a customer that can later be combined into an invoice. This makes sense if you have customers who make tons of purchases regularly, as you don't have to bill them individually all the time.

    Here's my issue: for the average Zen Cart store, wouldn't it make more sense to import Check/Money Orders into QB as an invoice? Two reasons: 1) Quickbooks Pro, the most popular version of QB, does not support Sales Orders. You need the more expensive Premier version for this. Hence, this isn't going to work for many people. 2) Most Zen Cart stores (although obviously not all) are not going to have customers visiting frequently that need to be invoiced together for multiple orders.

    I suppose the best solution would be to have invoices, sales receipts, and sales orders available as an option that you can choose. However, its going to take a lot of work, as invoices are currently not coded and sales orders are no longer functioning properly as I have significantly changed the way Sales Receipts work. Is it worth the effort? Updating the sales orders code would be easier than adding invoices, but it seems to me that invoices would be more useful for the average user. All in all, sales receipts are obviously the most important. What do people think? My inclination is to just comment out the sales order code and send all orders as sales receipts. I hate to reduce the functionality as I update this mod, but I question whether its worth the effort to implement these features. Any input would be appreciated.

    OK, so here's the changes I've made so far:

    -Updated tables definitions with DB_PREFIX so that you don't have to anymore.
    -Fixed issues that could cause errors including: truncating all QBXML fields to maximum values, replacing all characters with accents, ^, ~, etc... above them with their standard ASCII character without the accent, ^, ~, etc..., automatically removing all other characters above and beyond the 128 standard ASCII characters and replacing them with a ? (QB Web Connector doesn't like these characters!)
    -Implemented Payment Methods
    -Created a matching system that allows multiple shipping types, sales taxes, payment methods, and discounts/fees. These are now stored in the database, and I've created an Admin page that allows you to do your matching. Default is to pass through the Zen Cart values to Quickbooks. All other values need to be matched.
    -Implemented 2 advanced matching features: 1) * in Zen Cart value will indicated that all values NOT yet matched should follow this rule. 2) * in Quickbooks value will indicate that this should be passed through from Zen Cart.
    -Setup matching such that values need only CONTAIN the Zen Cart value to match. They do not need to match exactly. This will make it easier to match things, as many values are not static. For example, if your shipping is "UPS Ground (xxx pounds)", the xxx will change everytime. But, using "UPS Ground" in your Zen Cart matching value will always work for this because it contains "UPS Ground". This also will fix many problems with html codes appearing in matching values.
    -Changed so that products will be taxable or nontaxable on sales receipt based on whether or not they were taxed on this particular order. Previously, they just took the defaults in Quickbooks, which caused problems in some cases.

    The major work is done. Here are a couple things I'd still like to implement:
    -sales orders and invoices...is it worth it? see above
    -ability to add products as non-inventory part
    -move configuration values other than matching to zen cart table so you can configure from admin
    -ability to choose whether or not to add products from zen cart after the first time you run QB Web Connector.
    -create an option for QB Sync to use a standard tax name for items that weren't taxed in Zen Cart
    -add option to override whether or not products were taxed or not and simply tax or not tax all items
    (the reason I want to add the last two is that this will help people that have assigned a 0% tax so that they can track their taxable vs. non-taxable orders -- very helpful when sales tax is due -- I highly recommend it!)
    -create files that will make links to qbAdmin.php and the new qbMatch.php accessible from the admin menu -- no more typing the url!
    -Create ability to limit log entries to a certain number. Oldest get deleted first.

    Here are a few things that would be great additions to this, but I don't plan to do:
    -inventory tracking sync
    -handle products with attributes more accurately

  4. #64

    Default Re: Quickbook Sync

    Nevermind with my question. I just went ahead and fixed Sales Orders to work right. I can't test it though, as I don't have the premiere edition of Quickbooks, so when I release it, users will have to let me know if there are problems. Still haven't decided whether on not it is worth the effort to add invoices.

    Hard at work finishing this. A few more things to do, but it should be done soon. This is an enjoyable project -- I'm having a good time coding this! :) Although I must admit it is distracting me from my other work.... Oh well.

  5. #65

    Default Re: Quickbook Sync

    Quote Originally Posted by srturner47 View Post
    Of course I'll be giving you full credit the ancient. This is exactly why I prefer to work with open source software. :)

    My little changes turned into some big changes. I'll list what I've done, and what I need to do next before releasing this, but I had one question first -- hopefully someone (including the_ancient) can help me understand this. As it stands, check/money orders are sent to QB as a sales order while other payments are sent as sales receipts. I'd never heard of a sales order before, so I had to look it up. Apparently they are a way to store purchases from a customer that can later be combined into an invoice. This makes sense if you have customers who make tons of purchases regularly, as you don't have to bill them individually all the time.

    Here's my issue: for the average Zen Cart store, wouldn't it make more sense to import Check/Money Orders into QB as an invoice? Two reasons: 1) Quickbooks Pro, the most popular version of QB, does not support Sales Orders. You need the more expensive Premier version for this. Hence, this isn't going to work for many people. 2) Most Zen Cart stores (although obviously not all) are not going to have customers visiting frequently that need to be invoiced together for multiple orders.
    I was not aware QB Pro did not have Sales Orders, We only use Premier and infact we may be switching to Enterprise...

    So invoices would be the only logical option, However the way our accounting wants to work it they wanted the sales order not the invoice, why I dont know they are the accountants, Infact they originally wanted me to Create a Sales Order, Invoice and Payment Record for all orders, but I convinced them to let me do a sales receipt for CC Orders




    I suppose the best solution would be to have invoices, sales receipts, and sales orders available as an option that you can choose. However, its going to take a lot of work, as invoices are currently not coded and sales orders are no longer functioning properly as I have significantly changed the way Sales Receipts work. Is it worth the effort? Updating the sales orders code would be easier than adding invoices, but it seems to me that invoices would be more useful for the average user. All in all, sales receipts are obviously the most important. What do people think? My inclination is to just comment out the sales order code and send all orders as sales receipts. I hate to reduce the functionality as I update this mod, but I question whether its worth the effort to implement these features. Any input would be appreciated.
    I am willing to bet 90+% of all orders are CC so I doubt that would be a major Issues,


    OK, so here's the changes I've made so far:

    -Updated tables definitions with DB_PREFIX so that you don't have to anymore.
    -Fixed issues that could cause errors including: truncating all QBXML fields to maximum values, replacing all characters with accents, ^, ~, etc... above them with their standard ASCII character without the accent, ^, ~, etc..., automatically removing all other characters above and beyond the 128 standard ASCII characters and replacing them with a ? (QB Web Connector doesn't like these characters!)
    -Implemented Payment Methods
    -Created a matching system that allows multiple shipping types, sales taxes, payment methods, and discounts/fees. These are now stored in the database, and I've created an Admin page that allows you to do your matching. Default is to pass through the Zen Cart values to Quickbooks. All other values need to be matched.
    -Implemented 2 advanced matching features: 1) * in Zen Cart value will indicated that all values NOT yet matched should follow this rule. 2) * in Quickbooks value will indicate that this should be passed through from Zen Cart.
    -Setup matching such that values need only CONTAIN the Zen Cart value to match. They do not need to match exactly. This will make it easier to match things, as many values are not static. For example, if your shipping is "UPS Ground (xxx pounds)", the xxx will change everytime. But, using "UPS Ground" in your Zen Cart matching value will always work for this because it contains "UPS Ground". This also will fix many problems with html codes appearing in matching values.
    -Changed so that products will be taxable or nontaxable on sales receipt based on whether or not they were taxed on this particular order. Previously, they just took the defaults in Quickbooks, which caused problems in some cases.

    The major work is done. Here are a couple things I'd still like to implement:
    -sales orders and invoices...is it worth it? see above
    -ability to add products as non-inventory part
    -move configuration values other than matching to zen cart table so you can configure from admin
    -ability to choose whether or not to add products from zen cart after the first time you run QB Web Connector.
    -create an option for QB Sync to use a standard tax name for items that weren't taxed in Zen Cart
    -add option to override whether or not products were taxed or not and simply tax or not tax all items
    (the reason I want to add the last two is that this will help people that have assigned a 0% tax so that they can track their taxable vs. non-taxable orders -- very helpful when sales tax is due -- I highly recommend it!)
    -create files that will make links to qbAdmin.php and the new qbMatch.php accessible from the admin menu -- no more typing the url!
    -Create ability to limit log entries to a certain number. Oldest get deleted first.

    Here are a few things that would be great additions to this, but I don't plan to do:
    -inventory tracking sync
    -handle products with attributes more accurately
    Looks like a great list and I look forward to seeing them

  6. #66

    Default Re: Quickbook Sync

    Finally done -- this ended up being a bigger project than I expected! Here is the final changelog:

    V2.0 CHANGELOG

    -Updated tables definitions with DB_PREFIX so that you don't have to anymore.
    -Fixed issues that could cause errors including: truncating all QBXML fields to maximum values, replacing all characters with accents, ^, ~, etc... above them with their standard ASCII character without the accent, ^, ~, etc..., automatically removing all other characters above and beyond the 128 standard ASCII characters and replacing them with a ? (QB Web Connector doesn't like these characters!)
    -Implemented Payment Methods
    -Created a matching system that allows multiple shipping types, sales taxes, payment methods, and discounts/fees. These are now stored in the database, and I've created an Admin page that allows you to do your matching. Default is to pass through the Zen Cart values to Quickbooks. All other values need to be matched.
    -Implemented 2 advanced matching features: 1) * in Zen Cart value will indicated that all values NOT yet matched should follow this rule. 2) * in Quickbooks value will indicate that this should be passed through from Zen Cart.
    -Setup matching such that values need only CONTAIN the Zen Cart value to match. They do not need to match exactly. This will make it easier to match things, as many values are not static. For example, if your shipping is "UPS Ground (xxx pounds)", the xxx will change everytime. But, using "UPS Ground" in your Zen Cart matching value will always work for this because it contains "UPS Ground". This also will fix many problems with html codes appearing in matching values.
    -Changed so that products will be taxable or nontaxable on sales receipt based on whether or not they were taxed on this particular order. Previously, they just took the defaults in Quickbooks, which caused problems in some cases. Also added ability to force tax or non-tax.
    -Added ability to add products as tax or non-tax.
    -invoices added
    -Choose whether or not invoices, sales receipts, or sales orders are used based on payment name.
    -ability to add products as non-inventory part
    -move configuration values other than matching to zen cart table so you can configure from admin
    -ability to choose whether or not to add products from zen cart after the first time you run QB Web Connector.
    -create an option for QB Sync to use a standard tax name for items that weren't taxed in Zen Cart
    -add option to override whether or not products were taxed or not and simply tax or not tax all items
    (the reason I added the last two is that this will help people that have assigned a 0% tax so that they can track their taxable vs. non-taxable orders -- very helpful when sales tax is due -- I highly recommend it!)
    -create files that will make links to qbAdmin.php and the new qbMatch.php accessible from the admin menu -- no more typing the url!
    -Create ability to limit log entries to a certain number. Oldest get deleted first.
    -Send error emails to you when there is a problem.
    -Added customizable order number format.
    - Created ability to ignore Preferred Vendor which allows products to be added without setting up manufacturers as Vendors.
    -Added ability to set orders up as “to be emailed” in addition to “to be printed”.
    -Added ability to set terms for Sales Orders/Invoices as an alternative to payment methods for Sales Receipts.

    Documentation has been updated. I'll be doing some final testing over the next couple of days and then I'll release this. Now, off to bed!

  7. #67

    Default Re: Quickbook Sync

    For final testing, I decided to create a new Quickbooks file and see if I could import my entire store (a huge store -- 1000s of products, customers, and orders). Well, when I installed the exampleQWC file I got the following error, as discussed briefly earlier in this post:
    ---------------------------
    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
    ---------------------------
    After a ton of testing, I found that this error happened sometimes when installing exampleQWC, but not all the time. Hence, if you were persistent, it would work. I reverted to the_ancients version and had similar results, but I found that this error happened less frequently. This NEVER causes a problem when updating, it only happens when installing exampleQWC.

    Strange--I could only think of one possibility--my changes should make the script a little slower as I added a lot of SQL requests and a ton of code. Hence, it would make sense if this happened when the script doesn't return a response fast enough to the Web Connector when installing a new QWC app. Does this sound like a possibility the_ancient? Any other ideas about what might be causing this?

    I'm stumped on this issue.

  8. #68

    Default Re: Quickbook Sync

    UPDATE: Hmmm.. Well I found this thread:

    https://idnforums.intuit.com/message...&enterthread=y

    Looks like if your script sends an error, you might have an issue. I tried running qbServer.php in a browser, and sure enough I got a 503 error. Tried original and with my changes, same 503 error.

    OK--but I'm still not sure how to get rid of the 503 error.

  9. #69
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: Quickbook Sync

    The 503 error suggests that the server is overloaded but still available (at least available enough to respond with a 503).

    This could be because of maintenance work on the server and it might therefore clear itself, or could it be that you are doing the overloading? Is your revised version sending lots of messages to the server for processing in quick succession, intentionally or otherwise?
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  10. #70

    Default Re: Quickbook Sync

    Yep, that's why I investigated with my server first. After submitting a support ticket, they tested the script and found that there was an error in the script causing PHP to crash. Perhaps its because I was running the script in a browser as opposed to using QWC, I really don't know. Either way, the issue with install the QWC file remains. It can be worked around by being persistent, and it only happens when installing the mod, but it is still a problem.

 

 
Page 7 of 29 FirstFirst ... 5678917 ... LastLast

Similar Threads

  1. v154 2015 - Quickbook Integration Options?
    By townsend2009 in forum All Other Contributions/Addons
    Replies: 16
    Last Post: 4 Jan 2016, 11:38 PM
  2. sync quickbook mod
    By lions1855 in forum General Questions
    Replies: 1
    Last Post: 2 Mar 2010, 06:38 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR