QuickBooks Sync Web Service

Description
This Creates a Quickbooks Web Service with the ability to add new customers, orders (as Sales Receipts) and Products to Quickbooks via the Quickbooks Web Connector. + Download Latest

Submit An Updated Version
Zen Cart® Versions v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Original Author the_ancient
Last Updated by swguy - 30 Apr 2018
Downloads 4,591

Version History

QuickBooks Sync Web Service   -   Version: 2.1
Updated for Zen Cart 1.5. Please verify on a test store and make good backups before deploying to your store and modifying your Quickbooks data.   + Download
Zen Cart® Versions v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Date Added 30 Apr 2018
Author swguy
File Size 194.3 KB
PHP 5.3 Safe? No
Downloads 46
 
QuickBooks Sync Web Service   -   Version: 2.02
To update, replace all files and add new files.

No other changes are necessary.

No need to update to v2.02 from v2.01 unless you have a large store, use continuing sync, and have the Authentication Failed error after a long wait when first running the Web Connector.

Changelog for v2.02:

- Optimized code for continuing sync que build to speed this up a bit.
- If you still get the Authentication Failed error, a Quickbooks Prepare option has been added to the tools menu. Run this first, then run Quickbooks Web Connector to solve this problem.
  + Download
Zen Cart® Versions v1.3.9
Date Added 9 May 2011
Author srturner47
File Size 190.1 KB
PHP 5.3 Safe? Unknown
Downloads 1,646
 
QuickBooks Sync Web Service   -   Version: 2.01
To Upgrade from v2.0:
Replace file quickbooksSync/qbClass.php with the new one.
No other changes are necessary.

Changelog for v2.01:
- Fixed issue when no manufacturer is specified for products.
- Fixed issue with colons in customer names.
- Fixed tag error in Quickbooks Web Connector example file.
  + Download
Zen Cart® Versions v1.3.8
Date Added 13 Dec 2009
Author srturner47
File Size 187.0 KB
PHP 5.3 Safe? Unknown
Downloads 1,235
 
QuickBooks Sync Web Service   -   Version: 2.0
Tons of new features and bug fixes. Most notable new feature: Continuing Sync allows updates and deletions in Zen Cart for products, orders, and customers to automatically update in Quickbooks.

Changelog:
-Continuing Sync
-Matching System for Continuing Sync
-option to add customer comments to invoice, sales orders, or sales receipt
-option to add attributes from products to invoice, sales orders, or sales receipt
-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.
-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
-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 use specials price instead of regular price.
-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.
-A second, high priority que. This allows QBSync to do additional queries. This was important as
several functions have two or three queries in a row now.
-Several new tables in the database.
-Adding customers and products to orders using ListID (a unique identifier in Quickbooks that cannot be
changed by the user) instead of by name. Actually, pretty much everything is done by ListID now. For
those that do not use Continuing Sync, this will be optional if you prefer to identify by Name -- but using
ListID has many other benefits, so I would suggest using it.
-Fixed an issue with the state name not always importing correctly for customers.
-Option to view only errors on Log Page.
-I may have missed some enhancements, but these are the major ones
  + Download
Zen Cart® Versions v1.3.8
Date Added 29 Aug 2009
Author srturner47
File Size 186.6 KB
PHP 5.3 Safe? Unknown
Downloads 413
 
QuickBooks Sync Web Service   -   Version: 1.1
BUG FIX: Sales Receipt now shows Customer Name as Address Line 1.   + Download
Zen Cart® Versions v1.3.8
Date Added 7 Nov 2008
Author the_ancient
File Size 132.3 KB
PHP 5.3 Safe? Unknown
Downloads 1,078
 
QuickBooks Sync Web Service   -   Version: 1
  + Download
Zen Cart® Versions v1.3.8
Date Added 20 Oct 2008
Author the_ancient
File Size 132.2 KB
PHP 5.3 Safe? Unknown
Downloads 173
 


disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR