Originally Posted by
ShopVille
... i copied the complete data from the main site database to the new database i created for the test site, so now all customers, orders etc. are showing in the test site admin, i do not need this information how can i delete all orders/customer details?
Additional Considerations
Just to be on the safe side, you may wish to disable the email subsystem prior to manipulating anything with customer data (just to be on the safe side if you have existing orders / customer data)...
If you plan to test sending email, I'd recommend changing the store name (and / or the email address they are sent to). This makes identifying emails easier.
Safe Way
This method is tried, true, and safe. Use the Zen Cart admin folder to remove all unnecessary data. This includes orders, customers, admin users, etc.
Fast Way
While this method is fast, any mistakes made when directly modifying the database can break things.
Use phpMyAdmin to TRUNCATE (will empty the table) the following database tables: address_book, customers, customers_basket, customers_basket_attributes, customers_info, orders, orders_products, orders_products_attributes, orders_products_download, orders_status, orders_status_history, and orders_total.
Code:
TRUNCATE `address_book`;
Afterwards use something similiar to the following to remove all administrative users except admin.
Code:
DELETE FROM `admin` WHERE NOT `admin_name` = 'admin';
Bookmarks