On our testing environment we are constantly creating new customers and also (mass) removing them again, currently only having 12 customers. Now after a while our sales_flat_order (5038 rows) and sales_flat_quote (5279 rows) tables are really filling up. I want to clean them up with a simple script or SQL query (maybe going to put this in a cron too). Does anyone know how to do this and not miss anything in the clean up?
-
You might be interested in these SQL statements: magento.stackexchange.com/a/3703/231. That truncates of course all of the orders and does not take care of existing customers.– Anna VölklMar 2, 2015 at 11:17
Add a comment
|