Cannot permanently delete/remove product

  • Resolved chinners

    (@chinners)


    10 years, 1 month ago

    I have a problem actually permanently deleting a Woocommerce product (i.e. removing from the bin). I’m wondering if anyone would know how I could find, and manually eradicate, all traces of this product, using phpMyAdmin.

    A step by step guide to manually remove via phpMyAdmin would be appreciated – I’ve been unable to find any solution via Google searches, other than problems related to removing variants of products.

    The problem seems to be caused by some corrupt entry (I’m guessing) – this is what happens and what I’ve tried.

    1. If trying to remove from bin, the system seems to go in a loop. Eventually, it times out – I’m running on a cloud VPS with Plesk and have set all limits for memory, timeouts etc to max. Once it goes into this loop, the site breaks and the server needs to be restarted.

    2. I’ve tried using the Nuke plugin. I thought I’d try moving the product to an empty category, then running the Nuke option to permanently remove all products from that category. No luck, it timeouts and the only thing that seems to be removed is the SKU number and price and category.

    3. I’ve tried running repair and optimize via plugins and also via phpMyAdmin – no luck, although I’m not seeing any overhead via phpMyAdmin.

    4. I’ve tried bashing the computer with a big stick – still no luck.

    5. I’ve tried making changes to the product, changing from simple to variable, changing SKU, price, removing image and so on. No luck.

    I could just leave it permanently in the bin I suppose – but I don’t like the idea of having such a potentially damaging (presumably corrupt) entry anywhere in the system.

    So, as far as I can tell, the only way is to go into the database manually via phpMyAdmin and track down every single entry related to this product – but I really don’t know where the entries are and how to find them or where to start. WordPress (and Woocommerce) seems to have a completely different structure to previous CMS I have worked with, like Joomla, where the table entries were a bit easier to identify and understand.

    If anyone has any suggestions on how to deal with this, I’d appreciate it, thanks, Mark

    https://wordpress.org/plugins/woocommerce/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Mike Jolley

    (@mikejolley)

    10 years, 1 month ago

    Look at the ID of the product in the bin (it should be visible in the URL on hover), then find it in the wp_posts table. You can delete from there.

    Thread Starter chinners

    (@chinners)

    10 years, 1 month ago

    Thanks, understood – I thought it might be more complicated than that – confirm all product data is just held in this one row? I’ve deleted from PHPMyAdmin and all seems OK!

    Thanks again – perhaps I was anticipating it being more spread out over various entries for some reason.

    Still love to know what happened to cause this issue but it’s certainly seemed to solve the problem and I owe you a beer.

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

The topic ‘Cannot permanently delete/remove product’ is closed to new replies.