ProductCart Shopping Cart Software Forums : Bulk delete of inactive customers https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 16:37:29 +0000 Wed, 06 Mar 2013 18:40:01 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=5531 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Bulk delete of inactive customers : As a former AS/400 developer,...]]> https://forum.productcart.com/bulk-delete-of-inactive-customers_topic5531_post21075.html#21075 Author: Greg Dinger
Subject: 5531
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.).
    • ]]>     Wed, 06 Mar 2013 18:40:01 +0000 https://forum.productcart.com/bulk-delete-of-inactive-customers_topic5531_post21075.html#21075     <![CDATA[Bulk delete of inactive customers : We use ProductCart 4.0 to...]]> https://forum.productcart.com/bulk-delete-of-inactive-customers_topic5531_post21074.html#21074 Author: BrianRoden
    Subject: 5531
    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?
    ]]>     Wed, 06 Mar 2013 17:57:58 +0000 https://forum.productcart.com/bulk-delete-of-inactive-customers_topic5531_post21074.html#21074