Zen Cart Logo
Forums / General Questions / Import Customers FROM QuickBooks - Is It Possible?

Import Customers FROM QuickBooks - Is It Possible?

Locked

Views: 1,253

Results 1 to 9 of 9
This thread is locked. New replies are disabled.
25 Nov 2009, 9:50 PM
#1
imacamper avatar

imacamper

New Zenner

Join Date:
Nov 2009
Posts:
50
Plugin Contributions:
0

Import Customers FROM QuickBooks - Is It Possible?

I have Zen Cart 1.38 installed. I'd like to import customer names, addresses, email, & phone numbers FROM QuickBooks 2006 Pro. I've Googled and come across the QBI module but it doesn't appear to allow me to import customer data from QuickBooks. Just product, shipping, etc.

Is is possible to use QBI to import customer data? Or if not, something else? I guess at a minimum, I should be able to export a CSV from QB and insert it into the MySQL but I'm not much or a SQL expert. Is there some guide that might help?

Thanks,

Drew

25 Nov 2009, 10:06 PM
#2
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,792
Plugin Contributions:
14

Re: Import Customers FROM QuickBooks - Is It Possible?

click on Free Software Add Ons above and search for Quickbooks. See if any of those can help.

25 Nov 2009, 11:42 PM
#3
imacamper avatar

imacamper

New Zenner

Join Date:
Nov 2009
Posts:
50
Plugin Contributions:
0

Re: Import Customers FROM QuickBooks - Is It Possible?

Thanks for your reply. I did as you suggested. However none of the 5 results appear to do what I need. The first looked promising but again, it was a way to go FROM Zen Cart TO QuickBooks. I need the other direction.

The second I already tried.

And the rest do not appear to have anything to do with what I need.

Am I missing something? If so, please shove me in the right direction. :smile:

Thanks,

Drew

26 Nov 2009, 10:40 AM
#4
aliepinieks avatar

aliepinieks

Zen Follower

Join Date:
Jun 2009
Location:
Brisbane, QLD AUS
Posts:
209
Plugin Contributions:
0

Re: Import Customers FROM QuickBooks - Is It Possible?

is this a one-time deal? if so, you'll be better off getting some SQL help than you will be installing a mod. trouble here is SQL help isn't that easy if you're data is sensitive, and you don't know anyone with the time to assist.

26 Nov 2009, 3:44 PM
#5
imacamper avatar

imacamper

New Zenner

Join Date:
Nov 2009
Posts:
50
Plugin Contributions:
0

Re: Import Customers FROM QuickBooks - Is It Possible?

Thanks for your reply. Yes, just a one time deal. All I really want to import is name, address, phone, and email.

I guess with good backups, I could try figuring out the right SQLfu.

Cheers,

Drew

30 Nov 2009, 12:24 AM
#9
imacamper avatar

imacamper

New Zenner

Join Date:
Nov 2009
Posts:
50
Plugin Contributions:
0

Re: Import Customers FROM QuickBooks - Is It Possible?

Yes, the add customers mod was exactly what I needed. Thanks!

However now I'm having a small issue with it which I posted about in the issues thread you mentioned.