homepage Welcome to WebmasterWorld Guest from 54.227.215.140
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / WebmasterWorld / Ecommerce
Forum Library, Charter, Moderators: buckworks

Ecommerce Forum

    
OSCommerce / Gold Mine / Accounting Software integration
possible to pass customer data easily between CMS, accounting, cart?
fossilfool

10+ Year Member



 
Msg#: 2262 posted 4:39 am on Jun 2, 2004 (gmt 0)

hi there,

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,
Paul

 

nalin

10+ Year Member



 
Msg#: 2262 posted 5:24 am on Jun 2, 2004 (gmt 0)

Hi Paul,
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.

Big_Balou

10+ Year Member



 
Msg#: 2262 posted 11:49 pm on Jun 5, 2004 (gmt 0)

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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / Ecommerce
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved