zen cart – clear all customer data from zen cart website database
 

if you copy a new site from another zen cart website,you may need to clear all the customer data,include customer info,customer basket,customer order,and product review

Below is a sql script to do that clear job.Be careful when you test it against your zen cart database.

TRUNCATE `customers`;
TRUNCATE `customers_basket`;
TRUNCATE `customers_basket_attributes`;
TRUNCATE `customers_info`;
TRUNCATE `customers_wishlist`;
TRUNCATE `customers_info`;
TRUNCATE `customers_basket`;
TRUNCATE `orders`;
TRUNCATE `orders_products`;
TRUNCATE `orders_status_history`;
TRUNCATE `orders_total`;
TRUNCATE `reviews`;
TRUNCATE `reviews_description`;