Deleting products crashes WordPress

  • Resolved teuptworkshop

    (@teuptworkshop)


    5 years, 11 months ago

    I have a store with 10K+ products, and a few times a year I will want to wipe the entire database and reupload my products, so as to repair potential errors. I’m using Store Toolkit’s Nuke option for this, but it keeps crashing WordPress after some 2000 products. Not a huge problem, I can sit and wait and keep retrying until it is finally empty.. takes time but it works.
    But is there a better way that I should be aware of? Or any way I can optimise something so that I can delete my products without crashing WordPress several times?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Kel C. a11n

    (@kellymetal)

    5 years, 11 months ago

    Hi there,

    There are a variety of options for this. Our Product CSV Import Suite extension includes a tool for deleting all products and all variations:

    delete products
    Link to image: https://d.pr/i/nrMCuX

    Alternatively, I see this free plugin in the .org repository, though it doesn’t appear to have been tested recently:
    https://ww.wp.xz.cn/plugins/woocommerce-remove-all-products/

    Finally, doing a Google search for “WooCommerce delete all products” provides many different discussions / guides for doing this.

    Whichever method you choose, I would definitely recommend taking a complete backup first (just in case there are some random side effects, aside from “deleting all your products”).

    One last thing to mention — if possible, just increasing your WP Memory limit and PHP Execution time limit on the server might resolve the issue with your current solution crashing.

    I hope that helps!

    Thread Starter teuptworkshop

    (@teuptworkshop)

    5 years, 11 months ago

    Thanks for your reply. The way I do it now works quite comfortably apart from the crashing, so I will first try to look into that memory and timeout thing.. feels like there might be something to gain there!

    Plugin Support Kel C. a11n

    (@kellymetal)

    5 years, 11 months ago

    Hi there,

    The way I do it now works quite comfortably apart from the crashing, so I will first try to look into that memory and timeout thing.. feels like there might be something to gain there!

    Yeah, hopefully just increasing those memory/time limits fixes the issue with the import crashing! Let us know how it goes!

    AJ a11n

    (@amandasjackson)

    5 years, 11 months ago

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Deleting products crashes WordPress’ is closed to new replies.