Results 1 to 9 of 9

Hybrid View

  1. #1

    Default 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

  2. #2
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    9,700
    Plugin Contributions
    11

    Default 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.
    A little help with colors.
    myZenCartHost.com - Zen Cart Certified, PCI Compatible Hosting by JEANDRET
    Free SSL & Domain with semi-annual and longer hosting. Updating 1.5.2 and Up.

  3. #3

    Default 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.

    Thanks,

    Drew

  4. #4
    Join Date
    Jun 2009
    Location
    Brisbane, QLD AUS
    Posts
    210
    Plugin Contributions
    0

    Default 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.

  5. #5

    Default 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

  6. #6
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,267
    Plugin Contributions
    3

    Default Re: Import Customers FROM QuickBooks - Is It Possible?

    You may have some joy with the following:-

    http://www.zen-cart.com/index.php?ma...roducts_id=454
    20 years a Zencart User

 

 

Similar Threads

  1. Quickbooks Import vs. Quickbooks Sync
    By sports guy in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 28 Oct 2011, 02:01 AM
  2. Is it possible to import products from a datafeed?
    By mpsblue in forum General Questions
    Replies: 3
    Last Post: 2 Jun 2011, 11:02 PM
  3. Import customers from .xls file
    By canemasters in forum Managing Customers and Orders
    Replies: 2
    Last Post: 23 Feb 2009, 11:44 PM
  4. Possible to import products from seperate sql database?
    By gat0man in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 15 Oct 2008, 09:46 AM
  5. Import customers from xls file
    By canemasters in forum General Questions
    Replies: 2
    Last Post: 30 Jul 2007, 10:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg