Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2008
    Posts
    10
    Plugin Contributions
    0

    Default importing customers from an external sql database

    Hello everyone

    i have been looking at ways of importing the companys current customer database data into a zen cart database the current database table headers are layed out as follows:

    customerId | name | address | postcode | country | telephone | email | username | password | isWebMaster | isSalesAdmin | lastAccess | isAffiliate

    Edit* the old database was created about 5 years ago without upgrading in mind and its HUGE

    now i know most of this data is useless but the important information is there

    unfortunatly not all the data is simply copy/paste

    email (ok)
    name (first and last names in one field, sometimes only a company name)
    address (all in one line not always correct)
    postcode (ok)
    country (ok)
    email (ok)
    password (ok)

    is there a way to have this data inserted into my current zen cart in any way? even if some fields are left with "PLEASE UPDATE THIS DATA" or words to that effect.

    the goal here is to migrate the customers to the new database and cart software without them having to sign up again.

    Many Thanks

    Rich

  2. #2
    Join Date
    Mar 2008
    Posts
    2
    Plugin Contributions
    0

    Default Re: importing customers from an external sql database

    I am interested in doing this too....anyone done this type of thing before???
    2hounds Productions

  3. #3
    Join Date
    Mar 2007
    Location
    Chandler, Az
    Posts
    54
    Plugin Contributions
    0

    Default Re: importing customers from an external sql database

    this is also something i'm trying to do as well...

  4. #4
    Join Date
    Mar 2008
    Location
    Cape Town & London (depends on the season)
    Posts
    2,975
    Plugin Contributions
    0

    Default Re: importing customers from an external sql database

    Briefly... this is not as easy at it may seem... There's a LOT of cross-referencing in the database, and customer info is no exception to this. If you tamper with the d-base, you should at least have a "superior" understanding of the tables, and how they all interact...

  5. #5
    Join Date
    Mar 2007
    Location
    Chandler, Az
    Posts
    54
    Plugin Contributions
    0

    Default Re: importing customers from an external sql database

    is there by chance a way to load in email address manually? i collect emails from show my band plays and instead of having to deal with 2 mailing list i would like to be able to take the address i have a load them into my zencart mailing list some how... make sense?
    my other thing is that i have a collection of addresses in a csv file. is there a way to upload the address in that file, into the zencart database?

 

 

Similar Threads

  1. v139h Problem Importing SQL database to new database ready for testing Zencart 1.5
    By gillpotsoffun in forum Upgrading to 1.5.x
    Replies: 8
    Last Post: 24 Aug 2015, 11:24 PM
  2. Importing Customers into ZC from Another Database
    By clausont in forum Managing Customers and Orders
    Replies: 2
    Last Post: 22 Dec 2012, 10:21 PM
  3. Importing from an external dropship site
    By Tiigaan in forum Setting Up Categories, Products, Attributes
    Replies: 25
    Last Post: 11 Feb 2011, 04:55 PM
  4. Replies: 4
    Last Post: 15 Oct 2010, 07:18 AM
  5. Need help importing customers database from csv file into mySQL
    By jeffmic in forum Managing Customers and Orders
    Replies: 18
    Last Post: 20 Jan 2008, 04:54 PM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR