Customizing ProductCart - Delete Customers

Print Page | Close Window

Delete Customers

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=3291
Printed Date: 21-July-2025 at 9:23am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Delete Customers

Posted By: steverguy
Subject: Delete Customers
Date 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!

Replies:

Posted By: ProductCart
Date 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 http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: steverguy
Date Posted: 15-December-2009 at 5:17pm

Thanks for the heads up, I'll check that out.