Using ProductCart - Bulk delete of inactive customers

Print Page | Close Window

Bulk delete of inactive 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=5531
Printed Date: 10-March-2025 at 10:16am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Bulk delete of inactive customers

Posted By: BrianRoden
Subject: Bulk delete of inactive customers
Date 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?

Replies:

Posted By: Greg Dinger
Date 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" rel="nofollow - 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.).

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

Certified ProductCart Developer

Web Design/Development/Hosting

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