moNTeZIon Posted June 12, 2015 Share Posted June 12, 2015 (edited) Hi everyone, I need to delete all the products related to one suplier. When I access to CATALOG > SUPPLIERS I see my suppliers. The supplier i need to empty the products has 6500 products. When I click on the suplier to see the products, Prestashop never show the products, just a white screen. Other suppliers with less products don't have this problem. What can I do? I would like to detele all the products related to this suipplier, but don't know how... Thanks a lot. Edited July 17, 2015 by moNTeZIon (see edit history) Link to comment Share on other sites More sharing options...
NemoPS Posted June 13, 2015 Share Posted June 13, 2015 Turn on dev mode as described in my signature, and see what the error is Link to comment Share on other sites More sharing options...
moNTeZIon Posted June 19, 2015 Author Share Posted June 19, 2015 (edited) Thaks Nemo1 for you reply. Turning on DEV MODE now i can see the error: Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 30720 bytes) in .../httpdocs/tools/smarty/sysplugins/smarty_internal_templatebase.php(157) : eval()'d code on line 48 What can be the solution? Thanks Edited June 19, 2015 by moNTeZIon (see edit history) Link to comment Share on other sites More sharing options...
NemoPS Posted June 20, 2015 Share Posted June 20, 2015 You don't have enough resources, try setting the memory limit to 256mb 1 Link to comment Share on other sites More sharing options...
moNTeZIon Posted June 20, 2015 Author Share Posted June 20, 2015 (edited) Thanks Nemo1! Setting the memory limit to 256 solved my problem. Now I can get the insane product list (7500) of the selected supplier. But viewing the list, I can not see the option to delete all this products. Is there an option to delete the products related to one supplier? Thanks! Edited July 2, 2015 by moNTeZIon (see edit history) Link to comment Share on other sites More sharing options...
fpopiku Posted September 25, 2015 Share Posted September 25, 2015 Hello, Have you find a solution for this, I am also looking for a script / module that can do this. Thank you. Link to comment Share on other sites More sharing options...
fpopiku Posted September 25, 2015 Share Posted September 25, 2015 (edited) Turn on dev mode as described in my signature, and see what the error is Do you have one on hand ? I did found one on the forum for PS 1.4.9, but I do think that the structure of the db has changed. Edited September 25, 2015 by fpopiku (see edit history) Link to comment Share on other sites More sharing options...
NemoPS Posted September 25, 2015 Share Posted September 25, 2015 I'd use a custom sql query, like delete everything from all product-related tables, joining on id_product, where id_supplier is the one you want to erase Link to comment Share on other sites More sharing options...
Recommended Posts