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?



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.