{"id":16508,"date":"2022-07-17T13:29:51","date_gmt":"2022-07-17T13:29:51","guid":{"rendered":"https:\/\/ithemelandco.com\/?p=16508"},"modified":"2026-05-24T08:58:44","modified_gmt":"2026-05-24T08:58:44","slug":"delete-all-products-in-woocommerce-stores","status":"publish","type":"post","link":"https:\/\/ithemelandco.com\/blog\/delete-all-products-in-woocommerce-stores\/","title":{"rendered":"How to Delete All Products From WooCommerce in 3 Safe Ways"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Deleting all products from a WooCommerce store is sometimes necessary when you want to clean a test store, remove outdated inventory, rebuild your product catalog, or import a fresh product list. But this task should be done carefully because WooCommerce products can be connected to orders, variations, categories, images, reviews, and other store data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">There are several ways to delete all WooCommerce products. You can use the default WooCommerce bulk actions, run SQL queries from the database, or use<a href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-bulk-product-editing\/?utm_source=blog&amp;utm_content=delete-all-products\" target=\"_blank\" rel=\"noreferrer noopener\"> PBULKiT &#8211; Bulk Edit WooCommerce Products<\/a> to select, filter, move to trash, or permanently delete products in bulk.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this tutorial, we\u2019ll walk through 3 safe methods to remove all products from WooCommerce. You\u2019ll also learn what to check before deleting products, when to use each method, and how to avoid common mistakes that can affect your store data.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"How to delete all products from WooCommerce stores? (with SQL and plugin)\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/1NO5pc56uNg?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to prepare your website to delete all WooCommerce products?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Before you delete all products from WooCommerce stores, it is important to consider the possible consequences. First of all, note that removing all products will also target orders related to them. Another concern is the removal of product dependencies, which may not be your main goal of removing WooCommerce products.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To avoid these possible consequences, consider the following two points before removing all WooCommerce products:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Back up the site information before deleting all products<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">It is better to back up essential information such as WooCommerce orders, customer reviews, product images, and product dependencies.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Collect important information before removing all products<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If your products are linked to other data such as customers, orders, or reviews, it is important to check for possible dependencies. For example, if you remove products that have already been purchased by customers. You may lose your loyal customers who used to visit your site to buy that product.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">WooCommerce delete all products manually<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The easiest way to bulk delete WooCommerce products is to remove them manually through the WooCommerce product bulk edit page. This is an efficient method for online stores with a relatively small volume of products.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">First, go to the <strong>&#8220;Products \u00bb All Products&#8221;<\/strong> section in the WordPress dashboard.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">By default, WooCommerce displays 20 products per page. If the number of products available on your site is more, find the <strong>screen <\/strong><strong>options<\/strong> tab in the upper right corner and click on it.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/all-products-list.webp\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1234\" height=\"618\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/all-products-list.webp\" alt=\"click screen options to change number of items per page\" class=\"wp-image-16510\" style=\"object-fit:cover\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/all-products-list.webp 1234w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/all-products-list-500x250.webp 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/all-products-list-1000x501.webp 1000w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/all-products-list-150x75.webp 150w\" sizes=\"(max-width: 1234px) 100vw, 1234px\" \/><\/a><figcaption class=\"wp-element-caption\">For delete all WooCommerce products you must change default product per page value to a large number<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Now, in the pagination section, set the \u201c<strong>Number of items per page<\/strong>\u201d option so that all the products you have are displayed on one page. Finally, click on &#8220;<strong>Apply&#8221;<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/change-number-of-items.webp\"><img decoding=\"async\" width=\"454\" height=\"266\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/change-number-of-items.webp\" alt=\"Set products per page value\" class=\"wp-image-16513\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/change-number-of-items.webp 454w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/change-number-of-items-150x88.webp 150w\" sizes=\"(max-width: 454px) 100vw, 454px\" \/><\/a><figcaption class=\"wp-element-caption\">change number of items per page<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Now, all products can be viewed on one page and you can select them all by checking the checkbox under the bulk actions window. If you want to select only certain products, you have to check them one by one. Keep in mind that you can apply different filters to target specific products or product groups.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/woocommerce-bulk-action-select.webp\"><img decoding=\"async\" width=\"1163\" height=\"570\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/woocommerce-bulk-action-select.webp\" alt=\"select bulk action in woocommerce product list\" class=\"wp-image-16512\" style=\"object-fit:cover\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/woocommerce-bulk-action-select.webp 1163w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/woocommerce-bulk-action-select-500x245.webp 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/woocommerce-bulk-action-select-1000x490.webp 1000w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/woocommerce-bulk-action-select-150x74.webp 150w\" sizes=\"(max-width: 1163px) 100vw, 1163px\" \/><\/a><figcaption class=\"wp-element-caption\">Select move to trash to delete all selected products in the list<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">After selecting the products to be deleted, return to the <strong>&#8220;Bulk Actions&#8221;<\/strong> box and select the \u201c<strong>Move to Trash<\/strong>\u201d option. Then click on the <strong>Apply<\/strong> button.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It&#8217;s important to note that even though we&#8217;ve moved the products to the trash, they haven&#8217;t been completely removed yet. To complete the bulk delete process, go to <strong>&#8220;Trash&#8221;<\/strong> and again select all products through the checkbox and delete them.<\/p>\n\n\n\n<h2 id=\"h-delete-woocommerce-products-from-database-via-sql\" class=\"wp-block-heading\">Delete WooCommerce products from database via SQL<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">As you may notice, bulk remove products via WooCommerce product bulk edit manually, is very inefficient in online stores with a large number of products. Time is of the essence in web development, and wasting precious time ticking thousands of checkboxes is a tedious way to do it. Fortunately, this problem can be solved using code.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For delete all WooCommerce product via SQL, you must first enter your host <strong>Cpanel<\/strong> and go to &#8220;<strong>phpMyAdmin&#8221;<\/strong> as shown in the image below.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-phpmyadmin-cpanel.webp\"><img loading=\"lazy\" decoding=\"async\" width=\"1405\" height=\"622\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-phpmyadmin-cpanel.webp\" alt=\"Select phpmyadmin in cpanel\" class=\"wp-image-16518\" style=\"object-fit:cover\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-phpmyadmin-cpanel.webp 1405w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-phpmyadmin-cpanel-500x221.webp 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-phpmyadmin-cpanel-1000x443.webp 1000w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-phpmyadmin-cpanel-150x66.webp 150w\" sizes=\"(max-width: 1405px) 100vw, 1405px\" \/><\/a><figcaption class=\"wp-element-caption\">Select phpMyAdmin in cPanel home page<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">After entering &#8220;<strong>phpMyAdmin<\/strong>&#8220;, you will see the image below, where you can enter the name of your database from the left and then click on &#8220;<strong>wp-post<\/strong>&#8221; from the window that opens.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-database-in-phpmyadmin.webp\"><img loading=\"lazy\" decoding=\"async\" width=\"1192\" height=\"600\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-database-in-phpmyadmin.webp\" alt=\"Select WordPress database in phpmyadmin\" class=\"wp-image-16517\" style=\"object-fit:cover\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-database-in-phpmyadmin.webp 1192w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-database-in-phpmyadmin-500x252.webp 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-database-in-phpmyadmin-1000x503.webp 1000w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-database-in-phpmyadmin-150x76.webp 150w\" sizes=\"(max-width: 1192px) 100vw, 1192px\" \/><\/a><figcaption class=\"wp-element-caption\">Select WordPress database in phpMyAdmin<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-wp-post-table.webp\"><img loading=\"lazy\" decoding=\"async\" width=\"243\" height=\"224\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-wp-post-table.webp\" alt=\"select wp_posts database in phpmyadmin\" class=\"wp-image-16511\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-wp-post-table.webp 243w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-wp-post-table-150x138.webp 150w\" sizes=\"(max-width: 243px) 100vw, 243px\" \/><\/a><figcaption class=\"wp-element-caption\">Select wp_posts table to access all WordPress posts and products<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">After entering this section, you will see the image below on the left side. Please note that in some Cpanels, there is a \u201c<strong>Go\u201d<\/strong> button on the right side of the image, and you can apply it by entering the desired code.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Otherwise, you have to click on \u201cConsole\u201d and apply the code there and then press <strong>&#8220;Ctrl+Enter&#8221;<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-console-in-sql.webp\"><img loading=\"lazy\" decoding=\"async\" width=\"1540\" height=\"800\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-console-in-sql.webp\" alt=\"Select console in SQL tab of phpmyadmin\" class=\"wp-image-16516\" style=\"object-fit:cover\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-console-in-sql.webp 1540w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-console-in-sql-500x260.webp 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-console-in-sql-1536x798.webp 1536w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-console-in-sql-1000x519.webp 1000w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/select-console-in-sql-150x78.webp 150w\" sizes=\"(max-width: 1540px) 100vw, 1540px\" \/><\/a><figcaption class=\"wp-element-caption\">Click on &#8220;<strong>Console<\/strong>&#8221; to write SQL code for deleting all products in WooCommerce<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">To execute WooCommerce delete all products, you can enter one of the following codes according to your needs in this section:<\/p>\n\n\n\n<h3 id=\"h-bulk-delete-all-woocommerce-simple-products\" class=\"wp-block-heading\">Bulk delete all WooCommerce simple products<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The following code is for deleting all WooCommerce simple products!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Copy and paste the following code in the indicated section and then press &#8220;<strong>Ctrl+Enter<\/strong>&#8221; and wait for the code to be applied.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE relations.*, taxes.*, terms.*\nFROM wp_term_relationships AS relations\nINNER JOIN wp_term_taxonomy AS taxes\nON relations.term_taxonomy_id=taxes.term_taxonomy_id\nINNER JOIN wp_terms AS terms\nON taxes.term_id=terms.term_id\nWHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type='product');\n\nDELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type = 'product');\nDELETE FROM wp_posts WHERE post_type = 'product';\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Bulk remove all WooCommerce products and categories<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The following code is for deleting all related products and categories in WooCommerce.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Copy and paste the following code in the indicated section and then press &#8220;<strong>Ctrl+Enter&#8221;<\/strong> and wait for the code to be applied.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE relations.*, taxes.*, terms.*\nFROM wp_term_relationships AS relations\nINNER JOIN wp_term_taxonomy AS taxes\nON relations.term_taxonomy_id=taxes.term_taxonomy_id\nINNER JOIN wp_terms AS terms\nON taxes.term_id=terms.term_id\nWHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type='product');\nDELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type = 'product');\nDELETE FROM wp_posts WHERE post_type = 'product';\nDELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;\ndelete from `wp_termmeta`\nwhere\n\t`term_id` in (\n\t\tSELECT `term_id`\n\t\tFROM `wp_term_taxonomy`\n\t\tWHERE `taxonomy` in ('product_cat', 'product_type', 'product_visibility')\n\t);\ndelete from `wp_terms`\nwhere\n\t`term_id` in (\n\t\tSELECT `term_id`\n\t\tFROM `wp_term_taxonomy`\n\t\tWHERE `taxonomy` in ('product_cat', 'product_type', 'product_visibility')\n\t);\nDELETE FROM `wp_term_taxonomy` WHERE `taxonomy` in ('product_cat', 'product_type', 'product_visibility');\nDELETE meta FROM wp_termmeta meta LEFT JOIN wp_terms terms ON terms.term_id = meta.term_id WHERE terms.term_id IS NULL;\nDELETE FROM wp_woocommerce_attribute_taxonomies;\nDELETE FROM wp_woocommerce_sessions;\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">WooCommerce delete all products with variations and taxonomies<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The following code is for deleting all products with variations and taxonomies in WooCommerce.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE relations.*, taxes.*, terms.*\nFROM wp_term_relationships AS relations\nINNER JOIN wp_term_taxonomy AS taxes\nON relations.term_taxonomy_id=taxes.term_taxonomy_id\nINNER JOIN wp_terms AS terms\nON taxes.term_id=terms.term_id\nWHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'));\nDELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'));\nDELETE FROM wp_posts WHERE post_type IN ('product','product_variation');\n\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Bulk remove all WooCommerce product taxonomies<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If you want to remove only the attributes, you can run the following code.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%');\nDELETE FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%';\nDELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy);\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">After running each of these codes, go back to your WordPress dashboard and check if your products have been removed. If you get an error after running the SQL statement, make sure you&#8217;ve replaced all prefixes correctly with <strong>wp<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Note that the above code deletes all WooCommerce products. If you are not familiar with coding, be sure to back up your data or use the next method we are introducing which is using one of the best &nbsp;WooCommerce product bulk edit plugins.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How to use the WooCommerce product bulk edit plugin to bulk remove all products in your online store?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To bulk remove all WooCommerce products using the WooCommerce product bulk edit plugin, first download, install and launch the plugin, after activation, the plugin will be automatically added to the WordPress dashboard.<\/p>\n\n\n\n<div class=\"wp-block-columns alignwide are-vertically-aligned-center main-cta-cnt has-background is-layout-flex wp-container-core-columns-is-layout-8a83d729 wp-block-columns-is-layout-flex\" style=\"background-color:#3d67ff;padding-top:30px;padding-right:30px;padding-bottom:30px;padding-left:30px\">\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-group is-layout-constrained wp-container-core-group-is-layout-5980c20d wp-block-group-is-layout-constrained\" style=\"padding-top:15px\">\n<p class=\"single-cta-heading has-white-color has-text-color has-link-color wp-elements-3eb088219dcb11e14a6e3b37121408c5 wp-block-paragraph\" style=\"font-size:26px;font-style:normal;font-weight:800\">PBULKiT &#8211; Bulk Edit WooCommerce Products<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button main-cta-button\"><a class=\"wp-block-button__link has-text-color has-background wp-element-button\" href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-bulk-product-editing\/?utm_source=blog&amp;utm_content=delete-all-products\" style=\"border-style:none;border-width:0px;border-radius:40px;color:#ffffff;background-color:#0fba5e;padding-top:10px;padding-right:30px;padding-bottom:10px;padding-left:30px;font-style:normal;font-weight:500\" target=\"_blank\" rel=\"noreferrer noopener\">Buy Plugin<\/a><\/div>\n\n\n\n<div class=\"wp-block-button is-style-outline is-style-outline--1\"><a class=\"wp-block-button__link has-white-background-color has-text-color has-background wp-element-button\" href=\"https:\/\/wordpress.org\/plugins\/ithemeland-woo-bulk-product-editor-lite\/\" style=\"border-style:none;border-width:0px;border-radius:40px;color:#3d67ff;padding-top:10px;padding-right:30px;padding-bottom:10px;padding-left:30px;font-style:normal;font-weight:500\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Free Version<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"532\" height=\"355\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/pbulkit-banner.png\" alt=\"PBULKiT - Bulk Edit WooCommerce Products plugin by ithemeland\" class=\"wp-image-48724\" style=\"width:440px;height:auto\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/pbulkit-banner.png 532w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/pbulkit-banner-500x335.png 500w\" sizes=\"(max-width: 532px) 100vw, 532px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Then you can run this plugin to see the list of products displayed as a table. To bulk delete all products, you must first display all of them in the product table of this plugin. For this, just set the pagination box to 100.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Then mark the checkbox next to the <strong>ID<\/strong> option so that all products are selected.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/change-number-of-items-in-woo-bulk-edit-plugin.webp\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"601\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/change-number-of-items-in-woo-bulk-edit-plugin.webp\" alt=\"Change number of items in woocommerce bulk product editing plugin\" class=\"wp-image-16514\" style=\"object-fit:cover\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/change-number-of-items-in-woo-bulk-edit-plugin.webp 1200w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/change-number-of-items-in-woo-bulk-edit-plugin-500x250.webp 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/change-number-of-items-in-woo-bulk-edit-plugin-1000x501.webp 1000w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/change-number-of-items-in-woo-bulk-edit-plugin-150x75.webp 150w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/a><figcaption class=\"wp-element-caption\">Change number of items in WooCommerce bulk product editing plugin<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">After selecting the products, the &#8220;<strong>Delete<\/strong>&#8221; button will be displayed to you, if you click on it, you will see the following two options:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Move to trash.<\/li>\n\n\n\n<li>Delete products permanently.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/delete-selected-product-in-woo-bulk-ediy.webp\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"664\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/delete-selected-product-in-woo-bulk-ediy.webp\" alt=\"delete selected products in woocommerce bulk product editing plugin\" class=\"wp-image-16515\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/delete-selected-product-in-woo-bulk-ediy.webp 1200w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/delete-selected-product-in-woo-bulk-ediy-500x277.webp 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/delete-selected-product-in-woo-bulk-ediy-1000x553.webp 1000w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/delete-selected-product-in-woo-bulk-ediy-150x83.webp 150w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/a><figcaption class=\"wp-element-caption\">Delete all selected products in WooCommerce bulk product editing plugin<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">If you don&#8217;t want to delete all the products, click on the &#8220;<strong>Permanently&#8221;<\/strong> option. In this way, all the products are completely deleted and there is no possibility of restoring them.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">But if you think that in the future you may need the products to be added to your store again, click on the &#8220;<strong>Move to Trash&#8221;<\/strong> option. In this way, the trash option is displayed on the top of the table, if you click on it, you will see the deleted products and you can restore them to your store whenever you want.<\/p>\n\n\n\n<div class=\"wp-block-columns alignwide are-vertically-aligned-center main-cta-cnt has-background is-layout-flex wp-container-core-columns-is-layout-8a83d729 wp-block-columns-is-layout-flex\" style=\"background-color:#3d67ff;padding-top:30px;padding-right:30px;padding-bottom:30px;padding-left:30px\">\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-group is-layout-constrained wp-container-core-group-is-layout-5980c20d wp-block-group-is-layout-constrained\" style=\"padding-top:15px\">\n<p class=\"single-cta-heading has-white-color has-text-color has-link-color wp-elements-3eb088219dcb11e14a6e3b37121408c5 wp-block-paragraph\" style=\"font-size:26px;font-style:normal;font-weight:800\">PBULKiT &#8211; Bulk Edit WooCommerce Products<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button main-cta-button\"><a class=\"wp-block-button__link has-text-color has-background wp-element-button\" href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-bulk-product-editing\/?utm_source=blog&amp;utm_content=delete-all-products\" style=\"border-style:none;border-width:0px;border-radius:40px;color:#ffffff;background-color:#0fba5e;padding-top:10px;padding-right:30px;padding-bottom:10px;padding-left:30px;font-style:normal;font-weight:500\" target=\"_blank\" rel=\"noreferrer noopener\">Buy Plugin<\/a><\/div>\n\n\n\n<div class=\"wp-block-button is-style-outline is-style-outline--2\"><a class=\"wp-block-button__link has-white-background-color has-text-color has-background wp-element-button\" href=\"https:\/\/wordpress.org\/plugins\/ithemeland-woo-bulk-product-editor-lite\/\" style=\"border-style:none;border-width:0px;border-radius:40px;color:#3d67ff;padding-top:10px;padding-right:30px;padding-bottom:10px;padding-left:30px;font-style:normal;font-weight:500\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Free Version<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"532\" height=\"355\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/pbulkit-banner.png\" alt=\"PBULKiT - Bulk Edit WooCommerce Products plugin by ithemeland\" class=\"wp-image-48724\" style=\"width:440px;height:auto\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/pbulkit-banner.png 532w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/pbulkit-banner-500x335.png 500w\" sizes=\"(max-width: 532px) 100vw, 532px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Deleting all WooCommerce products can save a lot of time when you need to reset a store, remove old products, or prepare your catalog for a new import. The default WooCommerce bulk action is useful for smaller stores, while SQL can be faster for technical users who are comfortable working with the database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">However, deleting products directly from the database is risky if you are not sure what the query will remove. It can affect variations, product meta, taxonomies, and other connected data. That is why it is always better to create a full backup before using any bulk delete method.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For most store owners, <a href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-bulk-product-editing\/?utm_source=blog&amp;utm_content=delete-all-products\">PBULKiT &#8211; Bulk Edit WooCommerce Products<\/a> provides a more practical way to bulk delete WooCommerce products. You can review products in a table, select the items you want to remove, choose between moving them to trash or deleting them permanently, and manage product cleanup without editing each product manually.<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-7387b849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column blog-faq-section is-layout-flow wp-block-column-is-layout-flow\">\n<h2 class=\"wp-block-heading\">FAQ<\/h2>\n\n\n\n<h4 class=\"wp-block-heading\">1. How do I delete all products from WooCommerce?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">You can delete all WooCommerce products from <strong>Products &gt; All Products<\/strong> by selecting products, choosing <strong>Move to Trash<\/strong> from the Bulk Actions dropdown, and applying the action. For larger stores, PBULKiT &#8211; Bulk Edit WooCommerce Products can make the process faster and easier to control.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">2. Can I bulk delete WooCommerce products without using SQL?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Yes. You can use WooCommerce\u2019s default bulk action to move products to trash, or use PBULKiT to delete products in bulk from a product table. SQL is not required unless you want to remove products directly from the database.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">3. Is it safe to delete all WooCommerce products?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">It can be safe if you create a backup first and understand what data will be removed. Products may be connected to orders, variations, images, categories, reviews, and metadata, so you should not delete them without checking the impact.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">4. What is the difference between moving products to trash and deleting them permanently?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Moving products to trash keeps them recoverable, so you can restore them later if needed. Permanent deletion removes products completely and cannot be easily reversed unless you have a backup.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">5. Can I delete only selected WooCommerce products instead of all products?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Yes. You can filter or manually select specific products before deleting them. This is useful when you only want to remove products from a category, outdated items, test products, or imported products with incorrect data.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">6. Can I remove all WooCommerce products with variations?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Yes, but you need to be careful. Variable products include parent products and product variations. If you use SQL or bulk delete tools, make sure the method also handles variations correctly, otherwise some product data may remain in the database.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">7. Should I use SQL to delete all WooCommerce products?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">SQL can be fast, but it is risky for non-technical users. A wrong query can delete more data than expected or leave broken records behind. If you are not comfortable with database operations, using PBULKiT is usually a safer option.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">8. What should I do before deleting all WooCommerce products?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Before deleting products, back up your website and database, check if products are connected to orders or reviews, decide whether you want to move products to trash or delete them permanently, and test the process on a small number of products first.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Deleting all products from a WooCommerce store is sometimes necessary when you want to clean a test store, remove outdated inventory, rebuild your product catalog, or import a fresh product list. But this task should be done carefully because WooCommerce products can be connected to orders, variations, categories, images, reviews, and other store data. There [&hellip;]<\/p>\n","protected":false},"author":1458,"featured_media":16522,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[50,73],"tags":[],"class_list":["post-16508","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","category-woocommerce"],"featured_image_url":"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2022\/07\/bulk-delete-all-woo-procuts-500x335.webp","excerpt_plain":"Deleting all products from a WooCommerce store is sometimes necessary when you want to clean a test store, remove outdated inventory, rebuild your product catalog, or import a fresh product list. But this task should be done carefully because WooCommerce products can be connected to orders, variations, categories, images, reviews, and other store data. There [&hellip;]","_embedded":{"wp:term":[[{"term_id":50,"name":"Tutorials","slug":"tutorials","term_group":0,"term_taxonomy_id":50,"taxonomy":"category","description":"Follow and learn the latest educational articles about WordPress plugins and WooCommerce here","parent":0,"count":256,"filter":"raw"},{"term_id":73,"name":"WooCommerce","slug":"woocommerce","term_group":0,"term_taxonomy_id":73,"taxonomy":"category","description":"Do you use WooCommerce to manage your online store? We suggest you read this category of WooCommerce articles.","parent":50,"count":205,"filter":"raw"}]]},"_links":{"self":[{"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/posts\/16508","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/users\/1458"}],"replies":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/comments?post=16508"}],"version-history":[{"count":3,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/posts\/16508\/revisions"}],"predecessor-version":[{"id":51183,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/posts\/16508\/revisions\/51183"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/media\/16522"}],"wp:attachment":[{"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/media?parent=16508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/categories?post=16508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/tags?post=16508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}