istox Posted March 14, 2012 Share Posted March 14, 2012 Hello! I have upgraded my store to 1.4.7 version. And now I have the error on 60% of products. I can't delete them. The prestashop gives error. 1. Unable to delete product. error 1. Before 1.4.7 I was using 1.4.3, and everything worked well. I have 1200 products and 1100 orders. What to do now if I really need to delete old products? Turn off the product working but it is not good for me. Link to comment Share on other sites More sharing options...
Mike Kranzler Posted March 14, 2012 Share Posted March 14, 2012 Hi istox, I'm guessing the products you cannot delete are the headphones and the iPod Touch, correct ? This is due to the sample order by John Doe in your Orders tab. Open that order and cancel those products, and you will be able to delete them. I hope this helps. -Mike Link to comment Share on other sites More sharing options...
istox Posted March 14, 2012 Author Share Posted March 14, 2012 Nope, I have upgraded store from 1.4.3 to 1.4.7 and I have 1100 orders. I need to search and filter all orders for 100 products that I need to delete? What a miracle in 1.4.7.... Link to comment Share on other sites More sharing options...
Mike Kranzler Posted March 14, 2012 Share Posted March 14, 2012 Hi istox, This should only be the case for orders that have yet to be completed. For example, if someone placed an order for one of those products you're looking to delete and it is still awaiting check payment, then you would be unable to delete it until the order is complete. -Mike Link to comment Share on other sites More sharing options...
istox Posted March 14, 2012 Author Share Posted March 14, 2012 Nope. All orders marked as Delivered, Shipped (the last) and Canceled. Link to comment Share on other sites More sharing options...
istox Posted March 14, 2012 Author Share Posted March 14, 2012 Why there is no opportunity - JUST DELETE the product, like in previous versions I see that who wants to upgrade working one shops it will be quiet difficult to use if you need to delete permanently your products. Link to comment Share on other sites More sharing options...
Mike Kranzler Posted March 14, 2012 Share Posted March 14, 2012 Hi istox, This is not an error I've seen before. Could you by chance post a screencast illustrating this issue so that I can look into this further for you? -Mike Link to comment Share on other sites More sharing options...
istox Posted March 14, 2012 Author Share Posted March 14, 2012 Here you are the screenshot. I put config.php Display error to ON. Nothing new appears now. Link to comment Share on other sites More sharing options...
istox Posted March 15, 2012 Author Share Posted March 15, 2012 I can delete some products. But some products (about 50%) I can't delete. There is still an error. And I found in statistic of each product that this product was never sold! And even of that I can't delete it Link to comment Share on other sites More sharing options...
istox Posted March 15, 2012 Author Share Posted March 15, 2012 I duplicated the products which I can't delete. The duplicated products deleted very well. Original still can't be deleted. Please advise how I can delete products from DB MyPHPadmin by products ID Or may be I need to set permissions for folders or files on server? Link to comment Share on other sites More sharing options...
Mike Kranzler Posted March 15, 2012 Share Posted March 15, 2012 Hi istox, If you're looking to delete products from your database, they will be in the various ps_product tables, depending on what values you have populated for each one. -Mike Link to comment Share on other sites More sharing options...
istox Posted March 15, 2012 Author Share Posted March 15, 2012 this means that my error is not resolvable. and i need to wait new update of presta to see how it will be. Link to comment Share on other sites More sharing options...
istox Posted March 16, 2012 Author Share Posted March 16, 2012 Just deleted products from DB phpmyadmin. Really strange that only I have such problem... There fore I have 2 shops on presta and these 2 shops has this problem. Thank any way for your help Link to comment Share on other sites More sharing options...
TWDesign Posted March 29, 2012 Share Posted March 29, 2012 I had a similar error in 1.4.7 I think the error message was a little different though. Just a vague "an error occured" in red (note to PS core developers - please add more descriptive error messaging!) I was able to resolve it by going to the Orders tab and "cancelling" the products for John Doe as described above. Link to comment Share on other sites More sharing options...
Frenk Posted March 30, 2012 Share Posted March 30, 2012 I had a similar error in 1.4.7 I think the error message was a little different though. Just a vague "an error occured" in red (note to PS core developers - please add more descriptive error messaging!) I was able to resolve it by going to the Orders tab and "cancelling" the products for John Doe as described above. Hello, I have this problem also, I cannot delete the ordered products, however. It might be the cause of first deleting john doe as a client and deleting the products, before deleting the orders........does anybody know the solution? Link to comment Share on other sites More sharing options...
Mike Kranzler Posted March 30, 2012 Share Posted March 30, 2012 Hello, I have this problem also, I cannot delete the ordered products, however. It might be the cause of first deleting john doe as a client and deleting the products, before deleting the orders........does anybody know the solution? Hi Frenk, Which specific orders are you unable to delete? And what is the message you are getting? -Mike Link to comment Share on other sites More sharing options...
agilewebsolutions Posted June 18, 2012 Share Posted June 18, 2012 (edited) I have the same problem, and i really dont like when systems try to choose the best solution for me. And if the system does a check on why I cant delete it, then write why in the error message. I have not even published my site and i cant delete the default items, not good. ON DELETE CASCADE. Edited June 18, 2012 by agilewebsolutions (see edit history) 1 Link to comment Share on other sites More sharing options...
Mike Kranzler Posted June 18, 2012 Share Posted June 18, 2012 Hi agilewebsolutions, Can you please let me know what products you're unable to delete? -Mike Link to comment Share on other sites More sharing options...
istox Posted June 18, 2012 Author Share Posted June 18, 2012 The default items can be deleted in the beginning. Go to Orders tab, find the order with these products and then you can remove products from the order. After that you can simply delete products from catalog. In the matter of fact this situation really annoying. And for me (I've done upgrade from 1.4.3 to 1.4.7 with 1500 products and 1500 orders) and now I can't delete the products from the Back office. I need to go to PHP My Admin all time. Very fat minus to Presta! Link to comment Share on other sites More sharing options...
Mike Kranzler Posted June 18, 2012 Share Posted June 18, 2012 The default items can be deleted in the beginning. Go to Orders tab, find the order with these products and then you can remove products from the order. After that you can simply delete products from catalog. In the matter of fact this situation really annoying. And for me (I've done upgrade from 1.4.3 to 1.4.7 with 1500 products and 1500 orders) and now I can't delete the products from the Back office. I need to go to PHP My Admin all time. Very fat minus to Presta! Don't worry, we're aware of the concerns here. I'm personally pushing for us to remove those default orders from new installations for that very reason. -Mike Link to comment Share on other sites More sharing options...
istox Posted June 18, 2012 Author Share Posted June 18, 2012 Don't worry, we're aware of the concerns here. I'm personally pushing for us to remove those default orders from new installations for that very reason. -Mike Dear Mike, I really will be happy if you will remove this feature from prestashop. Because Old products and Old Orders after upgrade from older versions can't be deleted. Link to comment Share on other sites More sharing options...
Mike Kranzler Posted June 18, 2012 Share Posted June 18, 2012 Dear Mike, I really will be happy if you will remove this feature from prestashop. Because Old products and Old Orders after upgrade from older versions can't be deleted. Go ahead and post your request here as an Improvement so that our development team can look into it for you! -Mike Link to comment Share on other sites More sharing options...
agilewebsolutions Posted June 18, 2012 Share Posted June 18, 2012 Hi agilewebsolutions, Can you please let me know what products you're unable to delete? -Mike the ipod touch, all 2 orders are cancelled and John doe is deleted,,,,,, thanx for the quick reply. Link to comment Share on other sites More sharing options...
Mike Kranzler Posted June 18, 2012 Share Posted June 18, 2012 the ipod touch, all 2 orders are cancelled and John doe is deleted,,,,,, thanx for the quick reply. And did you cancel the individual items within those orders? -Mike Link to comment Share on other sites More sharing options...
agilewebsolutions Posted June 18, 2012 Share Posted June 18, 2012 And did you cancel the individual items within those orders? -Mike No, but i did now and now it worked, Thank u Link to comment Share on other sites More sharing options...
Mike Kranzler Posted June 18, 2012 Share Posted June 18, 2012 Great, I'm glad I could help! Happy selling! -Mike Link to comment Share on other sites More sharing options...
istox Posted August 9, 2012 Author Share Posted August 9, 2012 Hello! No solution for today about problem of Unable to delete products in 1.4.7? I just delete the products from DB PS_Products table and it is not so fast... Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now