Forums / General Questions / Export Products and Customers

Export Products and Customers

Views: 675

Results 1 to 4 of 4
29 Mar 2013, 2:52 PM
#1
brucelynch avatar

brucelynch

New Zenner

Join Date:
Mar 2012
Posts:
10
Plugin Contributions:
0

Export Products and Customers

I'd like to export products and customers from an install of zencart to migrate to a clean install. What's the best way to accomplish this? (I do not want to import the entire database, only the customers, customer history, and products.)

Also, one of the reasons for the clean install is it appears some where along the way the site was comprimised. It's unclear where, but I'm guessing it was sql injection. Does anyone have any thoughts on how to santized the data before importing into the new install?

Thanks!

29 Mar 2013, 5:39 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Export Products and Customers

like to export products and customers
Not importing the complete db is fraught with pitfalls as there are many interlinked tables especially between products and customers

Zen-Venom Get Bitten

1 Apr 2013, 10:31 PM
#3
brucelynch avatar

brucelynch

New Zenner

Join Date:
Mar 2012
Posts:
10
Plugin Contributions:
0

Re: Export Products and Customers

If I only needed to export / import customers? (So prior customers could login to our new site.) Would that make it easier perhaps?

2 Apr 2013, 2:07 AM
#4
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Export Products and Customers

If I only needed to export / import customers? (So prior customers could login to our new site.) Would that make it easier perhaps?
Customers are interlinked to many tables - address, orders, and the list goes on

Just import a full database

Zen-Venom Get Bitten