Useful MySQL To Help You Manage Your Prestashop Project Like a Boss

During the years I have been working on Prestashop professionally I gathered many useful SQL queries which help you to overcome some unusual tasks.

Here is a collection of useful SQL queries for Prestashop project ready to be fired. This is my personal collection from years spent on developing Prestashop projects. I will do my best to update this list periodically so please do re-check this post from time to time.

If you have any suggestions please write it in a comment of this post below and I will be more than happy to find the answer and then extend this list. I have been working with Prestashop for many years on really complex project with thousands of products and I have to do many unusual tasks for my clients


All SQL query have been tested under Prestashop in version 1.6.1

SQL Query For Exporting Data

export categories and products:

export just categories:

export just products:


Reset your Prestashop password

you can find your cookie key in the /config/ file