Using ProductCart - How can I delete multiple customers?

Print Page | Close Window

How can I delete multiple customers?

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=2478
Printed Date: 27-February-2025 at 2:22am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: How can I delete multiple customers?

Posted By: postitworld
Subject: How can I delete multiple customers?
Date 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

Replies:

Posted By: Greg Dinger
Date 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

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: postitworld
Date 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!!

Posted By: Greg Dinger
Date 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

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |