Difference between revisions of "interfacing QuickBooks and ZenCart"
(→QBI QuickBooks Import: custom code option) |
|||
| Line 11: | Line 11: | ||
** [http://www.zen-cart.com/forum/showthread.php?t=6152 archived QuickBooks QBI forum]: original statement of the problem | ** [http://www.zen-cart.com/forum/showthread.php?t=6152 archived QuickBooks QBI forum]: original statement of the problem | ||
** [http://www.zen-cart.com/forum/showthread.php?t=35755 QuickBooks Endicia Zencart]: discussion of ZenCart, QuickBooks, Endicia, and other shipping methods | ** [http://www.zen-cart.com/forum/showthread.php?t=35755 QuickBooks Endicia Zencart]: discussion of ZenCart, QuickBooks, Endicia, and other shipping methods | ||
| + | ===Custom code=== | ||
| + | [[QuickBooks]] data can be exported in spreadsheet format, and the resulting text can be [[importing data into ZenCart|imported into ZenCart]] with a little custom coding. | ||
| + | |||
==Notes== | ==Notes== | ||
[http://www.techsol-host.com/ Tech Solutions] states on their [http://www.techsol-host.com/ecommerce.php e-commerce hosting page] that they use [[osCommerce]] and that they can interface with [[QuickBooks]]. I emailed to ask them more about this, and received some useful information (though unfortunately not a solution): [[2006-08-10 Woozle-Techsol emails]] | [http://www.techsol-host.com/ Tech Solutions] states on their [http://www.techsol-host.com/ecommerce.php e-commerce hosting page] that they use [[osCommerce]] and that they can interface with [[QuickBooks]]. I emailed to ask them more about this, and received some useful information (though unfortunately not a solution): [[2006-08-10 Woozle-Techsol emails]] | ||
Revision as of 18:14, 12 October 2006
Overview
ZenCart's target audience includes small businesses, many of whom also use QuickBooks and would like a way to exchange data between the two systems. Some considerable work has been done on this.
QODBC
Data in QuickBooks can be accessed via ODBC if you have the QODBC module (which is proprietary and not, unfortunately, available free of charge).
QBI QuickBooks Import
The other major avenue appears to be a ZenCart module for Quickbooks, called QBI QuickBooks Import. The module costs $50. It apparently generates .iif files, which QuickBooks knows how to import.
- QBI Quickbooks Import official page
- QBI support forums at ZenCart:
- main support thread
- archived QuickBooks QBI forum: original statement of the problem
- QuickBooks Endicia Zencart: discussion of ZenCart, QuickBooks, Endicia, and other shipping methods
Custom code
QuickBooks data can be exported in spreadsheet format, and the resulting text can be imported into ZenCart with a little custom coding.
Notes
Tech Solutions states on their e-commerce hosting page that they use osCommerce and that they can interface with QuickBooks. I emailed to ask them more about this, and received some useful information (though unfortunately not a solution): 2006-08-10 Woozle-Techsol emails