QuickBooks Sync Web Service
| 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. |
 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,787 |
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. | |||||||||||
|
|||||||||||
| 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. |
|||||||||||
|
|||||||||||
| 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. |
|||||||||||
|
|||||||||||
| 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 |
|||||||||||
|
|||||||||||
| QuickBooks Sync Web Service - Version: 1.1 | |||||||||||
| BUG FIX: Sales Receipt now shows Customer Name as Address Line 1. | |||||||||||
|
|||||||||||
| QuickBooks Sync Web Service - Version: 1 | |||||||||||
|
|||||||||||
Date Added
File Size
PHP 5.3 Safe?
