Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
Magento Sales Flat Quote clean-up Query
#Fit the Number of interval days to your customer requirements.
#for Magento 1.X CE
DELETE FROM sales_flat_quote WHERE updated_at < DATE_SUB(Now(),INTERVAL 60 DAY);
#for Magento 1.X EE
DELETE FROM sales_flat_quote WHERE updated_at < DATE_SUB(Now(),INTERVAL 60 DAY);
DELETE FROM enterprise_customer_sales_flat_quote WHERE updated_at < DATE_SUB(Now(),INTERVAL 60 DAY);
#alternative use https://github.com/fbrnc/Aoe_QuoteCleaner
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment