Delete Customers

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I need to delete about 8000 retail customers from my store.  I can do this using SQL, but I wanted to know if this can be done through product cart, or if I do it through SQL, are there other tables I should be concerned about when deleting all these customers?

There are no curent orders, we've moved the database to a new server and i didn't transfer the data in the orders table over, so that shouldn't be an issue...  I did however, bring most of the other data from the othter tables over.

Thanks for your help!

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
steverguy Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 05-April-2006 Location: United States Status: Offline Points: 44	Post Options Post Reply Quote steverguy Report Post Thanks(0) Quote Reply Topic: Delete Customers Posted: 15-December-2009 at 11:25am
	I need to delete about 8000 retail customers from my store. I can do this using SQL, but I wanted to know if this can be done through product cart, or if I do it through SQL, are there other tables I should be concerned about when deleting all these customers? There are no curent orders, we've moved the database to a new server and i didn't transfer the data in the orders table over, so that shouldn't be an issue... I did however, bring most of the other data from the othter tables over. Thanks for your help!

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply Posted: 15-December-2009 at 5:05pm
	There are indeed many tables that reference the customer ID, so you should not run a SQL query that only targets the "customers" table. If you open the file "pcadmin/delCustomer.asp", you will see the various steps that the script runs through. As you will see, the script executes different tasks depending on whether or not the customer has placed any orders.
	The ProductCart Team Home of ProductCart shopping cart software

steverguy Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 05-April-2006 Location: United States Status: Offline Points: 44	Post Options Post Reply Quote steverguy Report Post Thanks(0) Quote Reply Posted: 15-December-2009 at 5:17pm
	Thanks for the heads up, I'll check that out.