Magento 2 Database Bloat: Quote Table

Magento stores old sales quotes dating back to the first day you launched your site. Sooner than you know it, you can be up to a couple million quotes that have never been processed but which can take up significant space, and slow your database.

This SQL query will clean out quotes (and their related content in other tables) that are older than 60 days.

DELETE FROM quote WHERE updated_at < DATE_SUB(Now(),INTERVAL 60 DAY)

Make sure to get this task setup on a cron job so that you don’t have to think about it again and your Magento store can keep running fast!

Leave a Reply

Will not be published

Satisfaction Guaranteed

We stand by our work

We know that our work produces real results. Whether it be increased visits, leads, conversions, or sales... Saderra has the track record of success with some of the world's largest and most notable brands. At the start of each project we will work with you to create a thorough checklist of achievable goals and realistic expectations, including a full list of deliverables. Your project isn't complete and our final invoice for the work isn't due until those goals and deliverables are met and provided. Saderra believes you should get what you pay for, and we won't stop working until you do.