|OSCommerce / Gold Mine / Accounting Software integration|
possible to pass customer data easily between CMS, accounting, cart?
I'm about to upgrade to OSCommerce, Goldmine, and one of the following accounting packages (Quickbooks, PeachTree, MYOB). We run credit card transactions on Authorize.net.
We're currently using Mals-e for <1 order per day.
Does OSCommerce have any known hooks into Goldmine or the accounting packages? I'd prefer not to have to retype name, address, phone #, etc. over and over in different programs.
What would you recommend?
Thanks a lot,
I am tackling a similar project with ACCPAC (actually sbt which is the older version of accpac), as follows, largely unimplemented but maybe will give you some ideas on how to go about it:
SBT can import and export csv files.
The froogle feed contribution is a good implementation on creation and uploading of csv files, and is commented well enough that it is not difficult to modify. Basically I have an (exported) csv with appropriate headers and am tweaking the froogle feed to look up customers and orders instead of products, and upload these to my networks ftp instead of googles. The database lookups are similar to prexisting code (in catalog/includes/classes/shopping_cart.php I think), and the ftp mods should be trivial.
This one is kinda on the back burner at the moment due to executive prioritizing - but other then customer ids (in particular ensuring repeat customers are given the prexisting id), its not a particularly difficult project, I wasnt planning on making a contribution of it (our sbt has some propritary add in that allows the csv's and this is not too run of the mill), but would be more then happy to if some of the database lookups would be of use to you.
Not sure of some of the other software but I do know that there is a contribution available to export osCommerce data to Quickbooks. Do a search on the site and I'm sure you'll find it.
I haven't implemented it myself yet but am in the process of doing so so I can't tell you any particulars.