ProductCart Shopping Cart Software Forums : Delete Customers https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 00:57:42 +0000 Tue, 15 Dec 2009 17:17:41 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=3291 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Delete Customers : Thanks for the heads up, I&#039;ll...]]> https://forum.productcart.com/delete-customers_topic3291_post12370.html#12370 Author: steverguy
Subject: 3291
Posted: 15-December-2009 at 5:17pm

Thanks for the heads up, I'll check that out.]]> Tue, 15 Dec 2009 17:17:41 +0000 https://forum.productcart.com/delete-customers_topic3291_post12370.html#12370 <![CDATA[Delete Customers : There are indeed many tables that...]]> https://forum.productcart.com/delete-customers_topic3291_post12369.html#12369 Author: ProductCart
Subject: 3291
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.]]> Tue, 15 Dec 2009 17:05:28 +0000 https://forum.productcart.com/delete-customers_topic3291_post12369.html#12369 <![CDATA[Delete Customers : I need to delete about 8000 retail...]]> https://forum.productcart.com/delete-customers_topic3291_post12366.html#12366 Author: steverguy
Subject: 3291
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!
]]> Tue, 15 Dec 2009 11:25:43 +0000 https://forum.productcart.com/delete-customers_topic3291_post12366.html#12366