zklid Posted August 7, 2014 Share Posted August 7, 2014 I have in my prestashop 1.6 about 50000 products. I realized I have a problem with the deletion of the products. The elimination of a single product takes more than a minute. And the massive elimination is thus impossible. How can I fix? Thank you Link to comment Share on other sites More sharing options...
zklid Posted August 7, 2014 Author Share Posted August 7, 2014 Yes, I have access to phpmyadmin, but I need to delete only the products of the category "home", not all the other...There is a command line that does this? Link to comment Share on other sites More sharing options...
zklid Posted August 7, 2014 Author Share Posted August 7, 2014 Ok, but this query delete also the pictures of the products? Link to comment Share on other sites More sharing options...
zklid Posted August 7, 2014 Author Share Posted August 7, 2014 Hi,I have found that presatashop is slow to erase the products in the "home" category while I have no problems if I delete products in other categories. Then I thought, I can with a query to change the category of all products under "home" category and then delete them? Link to comment Share on other sites More sharing options...
drasl Posted August 7, 2014 Share Posted August 7, 2014 if you the id_category of " Home" you can use this query : DELETE FROM ps_category_product WHERE id_category = x ; Where x=id_category for "Home" Is not dangerous delete product like that??? I have in my prestashop 1.6 about 50000 products. I realized I have a problem with the deletion of the products. The elimination of a single product takes more than a minute. And the massive elimination is thus impossible. How can I fix? Thank you Are you using your web site under CGI, FCGI or MOD APACHE? Link to comment Share on other sites More sharing options...
zklid Posted August 7, 2014 Author Share Posted August 7, 2014 Is not dangerous delete product like that??? Are you using your web site under CGI, FCGI or MOD APACHE? MOD APACHE Link to comment Share on other sites More sharing options...
El Patron Posted August 8, 2014 Share Posted August 8, 2014 tip: before manually changing files or db a back up should always be done. Link to comment Share on other sites More sharing options...
Writer Posted September 22, 2014 Share Posted September 22, 2014 if you the id_category of " Home" you can use this query : DELETE FROM ps_category_product WHERE id_category = x ; Where x=id_category for "Home" Suggested query is only deleting association with category, not products as whole. Link to comment Share on other sites More sharing options...
tuk66 Posted September 23, 2014 Share Posted September 23, 2014 Yes, it is dangerous!!! Because this way you only delete records from one table and need delete from more tables at once. Link to comment Share on other sites More sharing options...
drasl Posted October 26, 2014 Share Posted October 26, 2014 If you want to delete products by code I pref use prestashop webservices so you won't do nothing dangeurous. Use fast cgi instead mod apache, is faster. More info: http://blog.layershift.com/which-php-mode-apache-vs-cgi-vs-fastcgi/ Link to comment Share on other sites More sharing options...
Recommended Posts