Zen Cart Logo
Forums / Managing Customers and Orders / Removing all customers and orders inf from DB

Removing all customers and orders inf from DB

Views: 1,594

Results 1 to 6 of 6
7 Sep 2011, 11:18 AM
#1
tonyb6 avatar

tonyb6

New Zenner

Join Date:
Mar 2010
Posts:
77
Plugin Contributions:
0

Removing all customers and orders inf from DB

Hi, I've just recently set up a new website. To avoid work I imported the database from one of my other websites as the new one is selling many of the same products. However in doing so I also brought across all the customer and order information. My question is whats the best way of deleting these customers and their associated orders from the database?

So far as I can see their is no facility in admin to remove multiple customers or orders so I'm presuming I'll have to do it directly from the DB however I'm not entirely sure what the table structure is to ensure I remove ALL the relevant data from ALL the relevant tables.

Thanks
Tony

7 Sep 2011, 7:34 PM
#2
hamid84 avatar

hamid84

Zen Follower

Join Date:
Feb 2007
Location:
Walsall
Posts:
223
Plugin Contributions:
0

Re: Removing all customers and orders inf from DB

Log on Cpanel ( if you have it ), go to phpmyadmin, select your database and remove from there.

7 Sep 2011, 8:50 PM
#3
kobra avatar

kobra

Black Belt

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

Re: Removing all customers and orders inf from DB

I'm not entirely sure what the table structure is to ensure I remove ALL the relevant data from ALL the relevant tables.
I then suggest that you do not mess with it

8 Sep 2011, 9:31 AM
#4
tonyb6 avatar

tonyb6

New Zenner

Join Date:
Mar 2010
Posts:
77
Plugin Contributions:
0

Re: Removing all customers and orders inf from DB

Thanks for the above. But in the meantime if somebody more capable could maybe offer some advice on the structure of the DB or even let me know where the relevant documentation is kept which details the relationships i.e. primary keys then I'll see if I can manage to remove the data without messing it up.

thanks

8 Sep 2011, 11:07 AM
#5
tonyb6 avatar

tonyb6

New Zenner

Join Date:
Mar 2010
Posts:
77
Plugin Contributions:
0

Re: Removing all customers and orders inf from DB

Done, db cleaned down

30 Oct 2011, 11:34 PM
#6
jetx avatar

jetx

Zen Follower

Join Date:
Apr 2006
Posts:
425
Plugin Contributions:
0

Re: Removing all customers and orders inf from DB

Anyone else wanting to do this for the above reasons can follow this thread (do a db backup first): http://www.zen-cart.com/forum/showthread.php?t=140440 or do it in phpmyadmin.