How can I delete multiple customers?

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

   Hi, can anyone tell me how I can delete over 900 customers at once? I imported them by accident now I am trying to get rid of them. I was testing the import function and didn't realize the list would import in without a warning. Thank you

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
postitworld Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 11-February-2009 Status: Offline Points: 0	Post Options Post Reply Quote postitworld Report Post Thanks(0) Quote Reply Topic: How can I delete multiple customers? Posted: 12-February-2009 at 1:11am
	Hi, can anyone tell me how I can delete over 900 customers at once? I imported them by accident now I am trying to get rid of them. I was testing the import function and didn't realize the list would import in without a warning. Thank you

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 12-February-2009 at 11:59am
	Have you tried this? http://wiki.earlyimpact.com/productcart/customer-import ProductCart allows you to easily “undo” an import/update by reverting back to the data that was stored in the customer table before new data was imported or updated

postitworld Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 11-February-2009 Status: Offline Points: 0	Post Options Post Reply Quote postitworld Report Post Thanks(0) Quote Reply Posted: 12-February-2009 at 1:13pm
	Hi, Thank you for the response to my question but I already tried to back out of the import, I was not able. Some where some how I need to delete the customers. Thanks again!!

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 12-February-2009 at 3:11pm
	If your host allows you access to the database via some browser-based tool, or via SQL Studio Express, it would be possible to use the following query to wipe out all of the customer records. TRUNCATE TABLE customers