Bulk delete of inactive customers

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

We use ProductCart 4.0 to run our B2B wholesale site. I need to do a mass database update to deactivate/delete any customers in ProductCart that are no longer active customers in our internal AS/400-based billing system. 
I have imported a CSV file with the e-mails of the inactive accounts into a table in our SQL DB for the store. Which table/field would I update in the PC tables to make it where these customers can no longer log into the PC site?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
BrianRoden Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 07-September-2007 Status: Offline Points: 0	Post Options Post Reply Quote BrianRoden Report Post Thanks(0) Quote Reply Topic: Bulk delete of inactive customers Posted: 06-March-2013 at 5:57pm
	We use ProductCart 4.0 to run our B2B wholesale site. I need to do a mass database update to deactivate/delete any customers in ProductCart that are no longer active customers in our internal AS/400-based billing system. I have imported a CSV file with the e-mails of the inactive accounts into a table in our SQL DB for the store. Which table/field would I update in the PC tables to make it where these customers can no longer log into the PC site?

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: 06-March-2013 at 6:40pm
	As a former AS/400 developer, I'm happy to give ya a hand. table = customers fields: - suspend = 1 - pcCust_Locked = 1 From the WIKI: http://wiki.earlyimpact.com/productcart/customer-view Lock the customer account The customer will remain in the database, but he/she will no longer be able to log in and/or place orders. Suspend the account The customer can log into the account and browse the catalog, but not place an order. The difference between locking and suspending an account is that in the first scenario the customer can no longer log in (e.g. to view previous orders, etc.).