SQL query to delete all abandoned carts in Prestashop

by matt | Feb 10, 2017 | Prestashop, SQL, Uncategorized

Database of your Prestashop project could be really huge after some time because of all the junk stats related data. The most of such data is not needed at all and it is only takes space on your server and slows the whole project down significantly. The best example...

SQL query to export all WooCommerce products

by matt | May 31, 2016 | SQL, Uncategorized, WordPress

If you want to get all the WooCommerce products ready to be saved into a CSV / Excel file run the following query:   SELECT ID, post_status, post_title, post_content, post_excerpt, guid FROM `wp_posts` WHERE (`post_status` = ‘publish’ OR `post_status`...

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

by matt | May 5, 2016 | Prestashop, SQL, Uncategorized

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...

XAMPP – Script timeout when importing large databse file

by matt | Sep 28, 2014 | SQL, Uncategorized

Find the file config.inc.php and add this line: $cfg[‘ExecTimeLimit’] = 0; then php/php.ini In the php/php.ini find the following commands post_max_size = 8M upload_max_filesize = 2M max_execution_time = 30 max_input_time = 60 memory_limit = 8M and change...

Find and replace text – SQL

by matt | Aug 22, 2014 | SQL, Uncategorized

UPDATE tablename SET tablefield = replace(tablefield,”findstring”,”replacestring”);    

Deleting all comments mark as spam in bulk

by matt | Aug 22, 2014 | SQL, Uncategorized, WordPress

  DELETE FROM wp_comments WHERE comment_approved = ‘spam’;