Hey, I was looking for some time on how to delete all the orders and customers from my installation of zencart, after no luck in finding it online, I just created an sql script to do this.
This is pretty much it here, it's helped me. Hopefully it will help you.
NOTE: this won't touch any of the products or artists, or admin accounts, etc...
Just the Orders and Customers. And any session entries related to them.
Use at your own risk, of course:
Code:
DELETE FROM zc_address_book;
DELETE FROM zc_coupon_email_track;
DELETE FROM zc_coupon_gv_customer;
DELETE FROM zc_coupon_gv_queue;
DELETE FROM zc_coupon_redeem_track;
DELETE FROM zc_customers;
DELETE FROM zc_customers_basket;
DELETE FROM zc_customers_basket_attributes;
DELETE FROM zc_customers_info;
DELETE FROM zc_customers_wishlist;
DELETE FROM zc_email_archive;
DELETE FROM zc_files_uploaded;
DELETE FROM zc_orders;
DELETE FROM zc_orders_products;
DELETE FROM zc_orders_products_attributes;
DELETE FROM zc_orders_products_download;
DELETE FROM zc_orders_status_history;
DELETE FROM zc_orders_total;
DELETE FROM zc_paypal;
DELETE FROM zc_paypal_session;
DELETE FROM zc_paypal_testing;
DELETE FROM zc_reviews;
DELETE FROM zc_reviews_description;
DELETE FROM zc_sessions;
DELETE FROM zc_whos_online;
Bookmarks