interfacing QuickBooks and ZenCart

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search

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.

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