Woocommerce delete all products

New Page

¿How to restore WooCommerce? (Process step by step)

Posted on October 21, 2020 by Alice Pham

Published in

tutorial 1 comment

restart-woocommerce

WooCommerce is one of the best e-commerce platforms in the world. Aunque WooCommerce is extremely powerful and easy to use, the addon does not run automatically without checks. For this, you must have all the basic knowledge on programming and WooCommerce, for this and for later, including the process of reinitiating WooCommerce, which is a common problem that many usuarios may encounter.

Dans cet article, present the reasons why we decided to reinstall et how to restore WooCommerce from your WordPress site.

Table of contents

[Show] [Hide]

  1. Why did you restore the WooCommerce addon?
    1. Error installing a WooCommerce add-on
    2. WordPress crashes after installing WooCommerce addon
    3. You want to have a fresh start with WooCommerce
  2. How to restore WooCommerce?
    1. Method 1: Quick Uninstall WooCommerce
      1. Step 1: Eliminate the WooCommerce add-on
      2. Step 2: Uninstall WooCommerce
    2. Method 2: Manually delete Woocommerce data to complete it
      1. Step 1: Borrar WooCommerce data
      2. Step 2. Eliminate customer details
      3. Step 3. Eliminate WooCommerce Add-on from Control Panel
      4. Step 4. Get rid of custom fields with cPanel
      5. Step 5. Drop the database tables into phpMyAdmin
      6. Step 6. Delete residual files from FTP server
    3. Reinstall WooCommerce
  3. Conclusion

Why did you restore the WooCommerce addon?

It is important to understand why you need to reset WooCommerce before moving on to the detailed process.

Error installing a WooCommerce plugin

There are times when new WordPress users encounter fatal errors when something seems to be wrong with their WooCommerce plugin settings. After installing WooCommerce, you need to install the WooCommerce Product Plugins. However, when you try to activate the plugin, it gives the following error:

The plugin could not be activated because it caused a fatal error

This error occurs because WooCommerce was not installed correctly. In this case, simply disable and remove WooCommerce from your Plugins menu. Finally, reinstall WooCommerce like you did before.

WordPress se bloquea después de instalar el complemento WooCommerce

No importa cuán confiado esté en su plataforma WooCommerce, ningún complemento es inmune a cometer errores. WooCommerce incluso puede funcionar a veces de manera que cause bloqueos de WordPress.

To solve this, consider an updated version or a previous version. Make sure you choose the plugin version carefully and install the one you’ve found.

If the updated version still causes problems, you’d have to reset the WooCommerce plugin as there will be something inside the plugin causing a conflict with WordPress. Literally, it is the incompatibility error causing website problems.

Want to have a fresh start with WooCommerce

The good news is that you have uninstalled your previous platform and you want to switch to WooCommerce again, it’s okay. The great number of choices on the market means you try until you’ll be able to find the one that really works for you.

This time, you want to replace your old eCommerce platform with WooCommerce and use it now as that’s better suited to your region.

If such a course of reason occurs, you’re advised to reset your WooCommerce plugins.

How to reset the WooCommerce?

Method 1: Quick Way To Uninstall WooCommerce

Step 1: Removing the WooCommerce Plugin

If you want to understand how to reinstall WooCommerce, the prerequisite is to delete the WooCommerce plugin completely.

The first step of the uninstallation process is to get rid of the WooCommerce plugin. Here are the common suggestions:

  1. First, hover WordPress Dashboard.
  2. Press the “Plugins” button.
  3. Type “WooCommerce” within the search field.
  4. Click “Deactivate” the plugin.

However, as earlier said, WooCommerce requires more when it comes to deleting it permanently.

In fact, by simply navigating to the plugin page and deactivate and delete the plugin from WordPress, you simply temporarily disable it. Unnecessary files including orders, customer details products, pages, etc… will still exist in the store database.

As your site and skills grow, you realize that WooCommerce contains hundreds of backend stuff to your WordPress installation. In other words, you have to keep your database clean from all those associated files if you wish to uninstall the plugin completely.

Step 2: Uninstall WooCommerce

Before we explain the detailed way, there is a quick solution to get rid of WooCommerce data completely.

  1. Open your site’s wp-config.php file through FTP or File Manager.
  2. Scroll towards the bottom, add this line:
define(‘WC_REMOVE_ALL_DATA’, true);

Make sure to use straight quotation marks and add the code on its own line above the / That’s all, stop editing! Happy blogging. / line in the file, around line 76 of the file.

  1. Save the file to the server.
  2. Press “Deactivate” > “Delete” to remove the plugin from your admin panel.
  3. You can again go back and remove the above code from the wp-config file. Then when you deactivate and delete WooCommerce it will remove all of its data from your WordPress database.

Method 2: Manually Delete Woocommerce Data Completely

If you wish to remove a WooCommerce plugin permanently, it’s a good idea to spend time manually deleting it. Below are steps you have to go through:

Step 1: Clear WooCommerce data

When you decide to delete the plugin, the first thing you should do is to clear all relevant data from the admin panel.

  • Delete all WooCommerce product pages and categories by navigating to the “Products → All Products / Categories” sections.

restart-woocommerce-1

Here’s the result:

restart-woocommerce-2

Press “Screen Options” on the top right corner of the page to configure a particular number of items to display per page, for example, 20 to more than 100, so that you can easily and quickly find and delete them.

restart-woocommerce-3

restart-woocommerce-4

  • Remove all coupons and orders under the “WooCommerce → Coupons / Orders” sections.

restart-woocommerce-5

restart-woocommerce-7

  • Delete log data from “WooCommerce → Status → Logs”.

restart-woocommerce-8

  • Cleanup transient data under the “WooCommerce → Status → Tools” section.

restart-woocommerce-9

Step 2. Delete customer details

Your WooCommerce store can have tons of customers who bought specific products on your shop site. Once you navigate to the WordPress section, you will see a complete list of accounts’ role named “Customer”. You have to delete all customer accounts on the site after deleting the plugin.

  • For this, you need to open “Users → All Users” in the admin panel.
  • Once you’ve filtered all customer users, you need to select “Delete” in the “Bulk Actions” dropdown.
  • Click on the “Apply” button.

restart-woocommerce-10

The customer data can spread across multiple pages, making it a long time to manually remove them but nobody wants to do it that often.

Step 3. Delete WooCommerce plugin from Dashboard

This is a pretty simple step to uninstall plugins from the dashboard.

  • Once you login to your WordPress admin panel and navigate to the “Plugins → Installed Plugins” section in your dashboard.
  • Find and click on “Deactivate” under the WooCommerce plugin.
  • The last step after deactivation is just press “Delete” to eliminate the plugin from your site.

restart-woocommerce-11

The typical way of deleting the plugin will only remove the plugin files from your site without removing data. Well, in most cases, there are many integrations created by the plugin that users need to utilize manual effort.

Step 4. Get rid of Custom Fields with cPanel

WooCommerce uses hundreds of custom fields stored in WordPress as meta keys in the wp_postmeta table. You need to delete custom fields manually, otherwise, WooCommerce leaves behind tables and rows in your WordPress database.

Only to delete the custom fields list for WooCommerce to avoid affecting other functions and account termination. Follow the instructions below to drop them from your database.

  • Log in to your web hosting cPanel.
  • Access the phpMyAdmin app from cPanel to manage the database of your site with all table details.
  • Hover “xx_postmeta” table where xx is the prefix you named the table when you set up WordPress.
  • To manage database content securely, it’s recommended you do a backup of your site and then continue to browse the custom fields.
  • Best way to remove these keys quite quickly using MySQL query a select first to see then do a delete

For example, use the query under the “SQL” tab to first see the meta keys that contain “ship”.

SELECT * FROM wp_postmeta WHERE `meta_key` LIKE ‘%ship%’

Once you know the key format, edit the query to delete dead data.

DELETE FROM wp_postmeta WHERE `meta_key` LIKE ‘%ship%’

It’s easy to directly use the delete query if you know how the meta keys are named.

Step 5. Drop Database tables in phpMyAdmin

The database tables storing the content in the backend isn’t deleted even when you delete the plugin from the dashboard. In such a scenario, you need to remove the WooCommerce table with the phpMyAdmin section of cPanel.

  • Head to the phpMyAdmin section, click on the required table you want to delete.
  • Under the “Operations” tab, press the “Delete the table (DROP)” option.

restart-woocommerce-12

  • Press “OK” in the confirmation prompt for table and content deletion.

restart-woocommerce-13

Step 6. Delete residual files from FTP server

Deleting residual files created by the WooCommerce plugin is one such last necessary activity to carry out to finish WooCommerce uninstallation.

  • Login to the server using an FTP account.
  • Click through to the “Uploads” folder where you find the “/wp-content/” directory.
  • Usually, WooCommerce contains all media like images, “woocommerce_uploads” folder placeholder downloadable files, logs, and database of Geolocation information.
  • Mark every WooCommerce file and then delete all directories from your server to clean up.

Reinstall WooCommerce

After you’ve done deleting the plugin (with the first quick method or the second manual way), you can easily reinstall it to your WordPress site. Resetting WooComerce is similar to the plugin setup, you just install WooCommerce as normal:

  1. In the WordPress dashboard, go to Plugins > Add New.
  2. Type “WooCommerce” in the search box > Install Now.
  3. Once installed, click Activate Now and starting with the WooCommerce Wizard, and building your eCommerce site.

restart-woocommerce-14

After enabling WooCommerce, you can build your WooCommerce store and may need to get a WooCommerce theme to empower your online store.

Conclusion

As mentioned, many users have the habit of deleting and resetting WooCommerce from the admin panel, assuming that is enough. Whatever the reinstallation reason, it requires more to remove all the traces completely. In the general case, be aware of this fact before trying to reset WooCommerce on your site.

La réinitialisation n’est pas aussi simple que la simple désactivation. Apprenez à réinitialiser WooCommerce grâce à cet article chaque fois qu’il existe des possibilités de réinstallation de WooCommerce. L’élimination de la base de données résiduelle et du contenu des fichiers augmentera sensiblement la vitesse de chargement de votre site.

Si vous avez des questions ou des recommandations, veuillez nous en informer en laissant un commentaire ci-dessous.

Partagez ceci :

gif;base64,R0lGODdhAQABAPAAAMPDwwAAACwAAAAAAQABAAACkQBADs= 655f5bbac82019ab448d9106d56d2b38

A propos de l’auteur

Alice Pham

Écrivain et blogueur sur la technologie et le marketing. Je partage également mes connaissances sur WordPress et WooCommerce sur Woostify.com. Contactez-moi sur Twitter @thuyphuong082/ Linkedin Alice Pham

Navigation des articles

Article précédent : WooCommerce Security : comment sécuriser votre site WooCommerce contre les pirates

Next post: Check out the top 11 ways to speed up your WooCommerce store

Subscribe

Warn of

new follow-up comments new replies to my comments

guest guest

Label

{} [+]

Name* Email* Website

D

guest guest

Label

{} [+]

Name* Email* Website

D

1 comment

The oldest

Most recent Most voted

Online reviews

See all comments

Regina Regina

Regina

1 year ago

Hi guys, thanks for the manual to remove/reset Woocommerce. The first method does not work for me.

I did exactly what was explained, and when I reinstall Woocommerce all data is back…. So I will continue with the second method 😉

The site is not yet online, so I can’t give the url

1

Answer

Posted on August 4, 2020 August 25, 2022

How to delete all products in WooCommerce?

Apprenez à supprimer tous les produits WooCommerce rapidement, en toute sécurité et sans codage. Découvrez également comment appliquer des filtres avancés pour supprimer des produits en fonction d’attributs, de catégories, etc.

WooCommerce Delete All Products WooCommerce Delete All Products

Dernière mise à jour le 25 août 2022

Comment supprimer tous les produits dans WooCommerce

Mise à jour : 01 septembre 2022

Partager:

When running an online business, you must not only be aware of what items to offer but also of what products not to sell. For example, if you add seasonal items or those that are no longer in stock, they must be deleted.

This is where you need to use the feature of deleting all WooCommerce products.

This article will give you comprehensive instructions on how to delete all products in WooCommerce.

Let’s get started!

Why Do You Need to Delete Products From Your WooCommerce Store?

There are several scenarios in which you might need to delete all WooCommerce products. Here are the top five causes:

  • Seasonal items

Products that were only appropriate for a limited time. Products will go out of favor beyond that point, and you will need to delete them in bulk.

  • Products with a cyclical nature

Inventory is refreshed with new items at regular periods, such as new clothing for each major season. You must delete the old stock so that it is no longer available.

  • Products that are currently out of stock

Products that are out of stock and have no chance of being restocked should be removed from the store.

  • Non-selling items

Products that aren’t selling, therefore you’d better get rid of them than gathering dust and incurring expenditures for unsold inventory.

  • Products for testing

You develop various test products before launching the main product to ensure everything is in order. When the final product is released, you must also delete the test products.

How to Delete All Products in WooCommerce?

In this part, we will show you how to delete all products from your WooCommerce store in two different ways: using the default WooCommerce setting and running an SQL command.

Method 1: Using the default WooCommerce setting

This method is suitable for deleting less than a few hundred. You can just delete all products from the product page itself.

Using WooCommerce Preset Configuration

Step 1: Go to WooCommerce > Products

From your WordPress admin dashboard, go to WooCommerce > Products.

Step 2: Choose Screen Options

Then you need to select the option Screen Options, which is on the top right of the Products page. Here, you could reduce the number of items per page to 100-200 products per page to speed up the deletion process since more products mean slower loading.

This allows you to increase the number of products that are being displayed.

Step 3: Select products to delete

You must now choose the products that you wish to remove from your WooCommerce store. You can do this one by one or by using filters based on category, stock status, and product type.

Step 4: Select Move to Trash

Now that you have chosen products, navigate to the dropdown list Bulk Actions, click on that, and then choose the option Move to Trash.

This is an extremely slow and laborious procedure. If you don’t cap the number of products on each page to 100 or fewer, it will take quite a long time.

If you want to delete these items for good, you must then go to the Trash and delete them one more time.

Method 2: Running an SQL Command

Step 1: Log in to the phpMyAdmin

Step 2: Select database

Now that you’re on the phpMyAdmin screen, choose the database containing all of the products that you want to delete.

It’s important to keep in mind that you need to make sure you have a backup of your database before running the SQL statement.

You can always search for the table wp options and ensure it has the proper URL for your website to verify you have the correct database loaded.

Step 3: Run the SQL statement

Now click on the SQL tab and you should see a page like this:

Eject SQL statement

After that, simply paste the following code into the MySQL query to start deleting all products in your WooCommerce store.

DELETE relations.*, taxes.*, terms.* FROM wp_term_relationships AS relations INNER JOIN wp_term_taxonomy AS taxes ON relations.term_taxonomy_id=taxes.term_taxonomy_id INNER JOIN wp_terms AS terms ON taxes.term_id=terms.term_id WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type IN (‘product’,’product_variation’)); DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN (‘product’,’product_variation’)); DELETE FROM wp_posts WHERE post_type IN (‘product’,’product_variation’);

Then, to officially run the SQL statement above, hit the Go button.

Lastly, you should check whether your products have been deleted or not after running this SQL statement.

It’s worth mentioning that if your database prefix isn’t the default wp_, you’ll need to change it with your actual database prefix.

Also, because the total number of goods to be deleted might often be in the thousands, utilizing the aforementioned methods would take a long time. Furthermore, performing SQL queries for complex instances isn’t for everyone because you risk losing a lot of data if something goes wrong.

Therefore, in the next section, we’ll show you two robust plugins that can help you delete all goods for any number of products quickly, easily, and without coding.

Recommended Plugins to Delete All Products in WooCommerce

1. Smart Manager

smart administrator

Smart Manager is a sophisticated plugin that enables you to use an Excel-like spreadsheet to take your WooCommerce business to the next level.

Smart Manager plugin can be used for multiple purposes, from managing products to mass modifying them – adding, deleting, and updating them. Not only can you bulk edit products, but you can also bulk edit orders, coupons, blog articles, pages, and users.

Although the Lite version of the plugin supports the feature of deleting all WooCommerce products, you can only move them to the trash and delete up to 50 entries at a time.

Therefore, purchasing the Pro version is the ideal method if you want to delete products permanently.

Features

Features

  • Spreadsheet / Table Editor
  • Price, Product & Stock Management
  • Quick Inline & Bulk Edit
  • Order Management, Discount Coupons…
  • Admin Columns Freely

Pricing

The basic version is available for free. The Pro version costs $149 per year, while the lifetime subscription is $479.

2. Product Import and Export Addon for WooCommerce

Product Import and Export Add-on for WooCommerce

With the Product Import and Export add-on for WooCommerce , you can eliminate the main products from your WooCommerce site using a CSV file which also imports new products.

This add-in also allows importing product data in XML and CSV format. Works with the majority of WooCommerce product types, as well as more complicated ones, as well as product bundles.

Features

  • Export or import products in CSV/XML format.
  • Import or export program using multiple FTP/URLs.
  • Compatible with the main complementos of terceros.
  • Simple Ajax interface and flexible API.
  • Various filter options for custom import/export.
  • Provision for mass editing.

Prix

Single site, 5 site, 25 site licenses cost $69, $99, $199 per year respectively.

last words

Removing all products that can no longer be sold in your store is of great importance, especially when you are looking to keep your WooCommerce store up to date and well organized for customers.

We hope that our guide on how to remove all products in WooCommerce has provided you with a lot of information.

Aucun mec en communiquant avec us in the comments section below if you have any questions. We are happy to help you.

Thanks for reading and see you in the next article.

Automatization du marketing avada

Google Google translator

Google Google Translate


Video Woocommerce delete all products

Related Posts

Free chat room code for my website

Contents1 How to set up a free chat room on the website.2 3 comentarios2.1 Trackbacks/Pingbacks2.2 Submit a Comment Cancel reply3 How to Create a Chat Room Website…

Background image full screen css

Contents1 Cómo – Full Page Image1.1 Example1.2 Example2 CSS background image tamaño tutorial: how to codify a complete page background image3 Perfect Full Page Background Image3.1 Méthode CSS géniale,…

WordPress leverage browser caching

Contents1 Aproveche el almacenamiento in hidden del navegador1.1 Will it works for my website?1.2 Where are plugin options1.3 Some JavaScript files still display under Leverage Browser Caching1.4…

WordPress post to facebook page

Contents1 How to Automatically Post to Facebook from WordPress1.1 Download Now: How to Launch a WordPress Website [Free Guide + Checklist]1.2 1. Create an IFTTT account.1.3 2….

Download images from wordpress media library

Contents1 How to export your WordPress media library1.1 Download maintenant : How to launch a WordPress website [Free Guide + Checklist]1.2 How to export your WordPress media…

WordPress single post template

Contents1 How to Create Custom Unique Post Templates in WordPress2 Post Template Files2.1 author.php2.2 Fecha.php3 Handbook navigation4 How to Create Custom Single Post Templates in WordPress5 Video…