How to delete All products in woocommerce

  • Resolved Windavid

    (@windavid)


    9 years, 10 months ago

    I needed to delete 21,000 products on my travel store, store.adv-hub.com, but when I selected Delete Posts from WPallimport’s Manage import page, it would just freeze.

    Well, I figured it out and wanted to share with others because I haven’t found a good solution until today. This will delete the product posts, categories, affiliate links and other pieces of data imported with your products.

    Go to your site host’s control panel > access your MyphpAdmin > select the database for your store > (Export your entire database to your desktop for safe keeping)

    Now you will need to delete the data in each table. Don’t delete the table, just the data. This is called Truncate. Selecting Truncate will delete all the data in the table.

    You need to delete the data in these tables:

    _pmlca_links
    _pmxi_posts
    _postmeta
    _posts
    _terms
    _term_relationships
    _term_taxonomy
    _woocommerce_termmeta

    How to Truncate the tables:

    Select one table at a time > click Operations (or something similar) > Click Truncate > click ok.

    Do this for each table. I just did this on Bluehost and it worked perfectly!

    This will delete ALL the data in these tables and give you a clean slate to work from. It will also leave your woocommerce site design untouched.

    https://wordpress.org/plugins/wp-all-import/

  • The topic ‘How to delete All products in woocommerce’ is closed to new replies.