{"id":26833,"date":"2024-01-27T14:05:06","date_gmt":"2024-01-27T14:05:06","guid":{"rendered":"https:\/\/ithemelandco.com\/?p=26833"},"modified":"2025-10-16T11:26:35","modified_gmt":"2025-10-16T11:26:35","slug":"bulk-edit-woocommerce-product-status","status":"publish","type":"post","link":"https:\/\/ithemelandco.com\/blog\/bulk-edit-woocommerce-product-status\/","title":{"rendered":"3 easy ways to bulk edit WooCommerce product status"},"content":{"rendered":"\n<p>Bulk edit the WooCommerce product status is necessary for online stores that usually need to add new products or remove some of them from the shop page. The most important use of bulk edit WooCommerce product status is when you have added several new products to your store and WooCommerce saves them as a draft by default.&nbsp;<\/p>\n\n\n\n<p>Without a bulk editing tool, you need to open the page of each product individually to publish it which takes you a lot of time. But with bulk edit product status methods, you can make these changes with one click.<\/p>\n\n\n\n<p>As a WooCommerce store owner, you may have wondered how to bulk change product status. In this post, we have a look at how you can bulk edit WooCommerce product status in three methods:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"#mothod-1\"><span style=\"text-decoration: underline\">Bulk edit product status without a plugin<\/span><\/a>.<\/li>\n\n\n\n<li><span style=\"text-decoration: underline\"><a href=\"#mothod-2\">Bulk change product status with WooCommerce products bulk edit plugin<\/a><\/span>.<\/li>\n\n\n\n<li><span style=\"text-decoration: underline\"><a href=\"#mothod-3\">WooCommerce bulk edit product status by import\/export<\/a><\/span>.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">What is WooCommerce product status?<\/h2>\n\n\n\n<p>WooCommerce product status allows store managers to display the product on the shop page for purchase or save it to be released later. In WooCommerce, four product statuses can be set, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Published:<\/strong> The published products are displayed on the shop page and available for purchase.<\/li>\n\n\n\n<li><strong>Draft<\/strong>: The draft products are not available for purchase, but they are saved in WooCommerce and store managers usually need to edit then publish them later.&nbsp;<\/li>\n\n\n\n<li><strong>Pending<\/strong>: The pending products are not available for purchase however they are waiting to be approved and then published.&nbsp;<\/li>\n\n\n\n<li><strong>Private<\/strong>: The private products are only available for special users to be purchased.<\/li>\n<\/ul>\n\n\n\n<p>Continue reading to learn how to bulk edit WooCommerce product statuses.<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" id=\"mothod-1\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Method 1: Bulk edit WooCommerce product status without plugin<\/h2>\n\n\n\n<p>You can follow the below steps to use the default editor of WooCommerce for bulk edit product status:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to <strong>All products<\/strong> in the <strong>WordPress Dashboard.<\/strong>&nbsp;<\/li>\n\n\n\n<li>Filter desired products.<\/li>\n<\/ol>\n\n\n\n<p>There are three options available for filtering products:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Select category:<\/strong> Let you filter WooCommerce products by category.&nbsp;<\/li>\n\n\n\n<li><strong>Filter by product type:<\/strong> To filter WooCommerce products by their types.<\/li>\n\n\n\n<li><strong>Filter by stock status:<\/strong> To filter products by their stock status.<\/li>\n<\/ul>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>When you filter your desired products, Open the <strong>Bulk Action<\/strong> field and choose <strong>Edit<\/strong> from the list.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/filtering-products-1.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1270\" height=\"587\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/filtering-products-1.png\" alt=\"filtering products in table products\" class=\"wp-image-26837\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/filtering-products-1.png 1270w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/filtering-products-1-500x231.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/filtering-products-1-1000x462.png 1000w\" sizes=\"(max-width: 1270px) 100vw, 1270px\" \/><\/a><\/figure>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>Then select some products in the table and press <strong>Apply<\/strong> to see the bulk edit form of WooCommerce.&nbsp;<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-edit-form.png\"><img decoding=\"async\" width=\"854\" height=\"381\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-edit-form.png\" alt=\"select edit form in products table\" class=\"wp-image-26838\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-edit-form.png 854w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-edit-form-500x223.png 500w\" sizes=\"(max-width: 854px) 100vw, 854px\" \/><\/a><\/figure>\n\n\n\n<ol start=\"5\" class=\"wp-block-list\">\n<li>In this form, open the combo box of <strong>Status<\/strong> and choose one of the product statuses.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-published-categories.png\"><img decoding=\"async\" width=\"1152\" height=\"264\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-published-categories.png\" alt=\"select published categories in bulk edit form\" class=\"wp-image-26839\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-published-categories.png 1152w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-published-categories-500x115.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-published-categories-1000x229.png 1000w\" sizes=\"(max-width: 1152px) 100vw, 1152px\" \/><\/a><\/figure>\n\n\n\n<ol start=\"6\" class=\"wp-block-list\">\n<li>Press the <strong>Update<\/strong> button to bulk edit product status WooCommerce.&nbsp;<\/li>\n<\/ol>\n\n\n\n<p>Bulk changing the status of multiple products by default editor of WooCommerce is really fast and easy. The only problem is the filtering options which are not very flexible and comprehensive.<\/p>\n\n\n\n<p>If you are looking for an ultimate solution to bulk edit product status, we recommend you use the WooCommerce product bulk editing plugin.&nbsp;<\/p>\n\n\n\n<p>Let\u2019s see how.<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" id=\"mothod-2\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Method 2: Bulk change product status with WooCommerce products bulk edit plugin<\/h2>\n\n\n\n<p><span style=\"text-decoration: underline\"><a href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-bulk-product-editing\/?utm_source=blog&amp;utm_content=bulk-edit-product-status\" target=\"_blank\" rel=\"noreferrer noopener\">WooCommerce products bulk edit plugin<\/a><\/span> will save a lot of your time and increase the speed of making changes in products of the online store.<\/p>\n\n\n\n<p>This plugin is one of the most popular plugins for editing multiple products at once, and with the help of this plugin, you can easily bulk change any product feature, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Product stock quantity.<\/li>\n\n\n\n<li>Regular or sale price.&nbsp;<\/li>\n\n\n\n<li>Product status.<\/li>\n\n\n\n<li>Product category\/ tags\/ taxonomies.<\/li>\n\n\n\n<li>And\u2026<\/li>\n<\/ul>\n\n\n\n<p>To bulk edit product status WooCommerce with this plugin, follow the below steps:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Install WooCommerce product bulk editing Plugin&nbsp;<\/h3>\n\n\n\n<p>At first, you must<a href=\"https:\/\/ithemelandco.com\/blog\/docs\/woocommerce-bulk-product-editing\/how-to-install-the-woocommerce-bulk-product-editing-plugin\/\"> <\/a><span style=\"text-decoration: underline\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/how-to-install-the-woocommerce-bulk-product-editing-plugin\/\" target=\"_blank\" rel=\"noreferrer noopener\">download and install the WooCommerce product bulk editing plugin<\/a><\/span>. After installation, you should see the <strong>IT bulk editing <\/strong>menu in your WordPress dashboard.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-woo-products-section-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"148\" height=\"149\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-woo-products-section-1.png\" alt=\"select Woo Products section in iT Bulk Editing\" class=\"wp-image-26840\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-woo-products-section-1.png 148w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-woo-products-section-1-100x100.png 100w\" sizes=\"(max-width: 148px) 100vw, 148px\" \/><\/a><\/figure>\n\n\n\n<p>In this menu, click on the <strong>Woo Products<\/strong> submenu to open the main plugin page. On this page, a complete list of the WooCommerce products will be displayed with all tools available in this plugin in a toolbar on top.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-products-bulk-edit-plugin-tools.png\"><img loading=\"lazy\" decoding=\"async\" width=\"936\" height=\"505\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-products-bulk-edit-plugin-tools.png\" alt=\"select products bulk edit plugin tools in WooCommerce toolbar\" class=\"wp-image-26841\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-products-bulk-edit-plugin-tools.png 936w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-products-bulk-edit-plugin-tools-500x270.png 500w\" sizes=\"(max-width: 936px) 100vw, 936px\" \/><\/a><\/figure>\n\n\n\n<p>To bulk edit product status in this plugin, you need to use the three below tools:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Filter<\/strong><\/li>\n\n\n\n<li><strong>Bulk Edit<\/strong><\/li>\n\n\n\n<li><strong>Bind Edit<\/strong><\/li>\n<\/ol>\n\n\n\n<p>In the next steps, we will describe how to use these tools, briefly.<\/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-4a33225c 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-4f39da6d 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\" style=\"font-size:26px;font-style:normal;font-weight:800\">PBULKiT &#8211; Bulk Edit WooCommerce Products<\/p>\n\n\n\n<p class=\"single-cta-desc has-white-color has-text-color has-link-color wp-elements-11005baf602e93620b344ff309fb0e9f\" style=\"font-size:16px\">The easy way to bulk edit WooCommerce product status<\/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=bulk-edit-product-status\" 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<h3 class=\"wp-block-heading\">Step 2: Filter desired products&nbsp;<\/h3>\n\n\n\n<p>The first useful tool in this plugin is <strong>Filter<\/strong> which is a great way to find and limit products displayed in the table.&nbsp;<\/p>\n\n\n\n<p>All WooCommerce fields and meta fields are supported in this form and you can filter products based on any features like <strong>Title<\/strong>, <strong>Price<\/strong>, <strong>Date<\/strong>, <strong>Stock qty<\/strong>, <strong>Type<\/strong>, etc.<\/p>\n\n\n\n<p>To make the filtering process easier for you, the related fields are divided into eight tabs including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>General<\/li>\n\n\n\n<li>Categories&nbsp;<\/li>\n\n\n\n<li>Pricing&nbsp;<\/li>\n\n\n\n<li>Shipping<\/li>\n\n\n\n<li>Stock<\/li>\n\n\n\n<li>Type<\/li>\n\n\n\n<li>Compatibles<\/li>\n\n\n\n<li>Custom fields<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-general-tab.png\"><img loading=\"lazy\" decoding=\"async\" width=\"755\" height=\"475\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-general-tab.png\" alt=\"select general tab in filter form\" class=\"wp-image-26842\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-general-tab.png 755w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-general-tab-500x315.png 500w\" sizes=\"(max-width: 755px) 100vw, 755px\" \/><\/a><\/figure>\n\n\n\n<p>You can set one or more filters on different fields to instruct the plugin to show the products you need in the table.<\/p>\n\n\n\n<p>After filtering, you can proceed to the next step to change the status of multiple products.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Bulk change WooCommerce product status<\/h3>\n\n\n\n<p>In the WooCommerce product bulk editing plugin, you can use one of the below methods to bulk change product status:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Bulk edit form.<\/li>\n\n\n\n<li>Bind edit tool.<\/li>\n<\/ul>\n\n\n\n<p>Let\u2019s review each method, briefly.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Method 1: WooCommerce bulk edit product status<\/h4>\n\n\n\n<p>To use the bulk edit form for WooCommerce bulk edit product status, select some products in the table (1) then press the <strong>Bulk Edit<\/strong> icon (2).<\/p>\n\n\n\n<p>In the <strong>General<\/strong> tab of <strong>Bulk Edit<\/strong> form, open the combo box of <strong>Product status<\/strong> and choose one of the statuses from the list (3), including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Draft<\/li>\n\n\n\n<li>Pending Review<\/li>\n\n\n\n<li>Private<\/li>\n\n\n\n<li>Published<\/li>\n\n\n\n<li>Trash<\/li>\n<\/ul>\n\n\n\n<p>Finally, press on the <strong>Do bulk edit <\/strong>button.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-product-status-field.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1064\" height=\"896\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-product-status-field.png\" alt=\"select product status field in Bulk Edit Form\" class=\"wp-image-26843\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-product-status-field.png 1064w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-product-status-field-500x421.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-product-status-field-1000x842.png 1000w\" sizes=\"(max-width: 1064px) 100vw, 1064px\" \/><\/a><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Method 2: Bind edit product status WooCommerce<\/h4>\n\n\n\n<p><strong>Bind Edit<\/strong> is the quickest way allowing you to change multiple product statuses directly on the table.<\/p>\n\n\n\n<p>To use the <strong>Bind Edit<\/strong> tool, try to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Mark some products on the table.<\/li>\n\n\n\n<li>Press the <strong>Bind Edit<\/strong> tool in the toolbar.<\/li>\n\n\n\n<li>Open the status field dropdown list related to one of the selected products.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-draft-status.png\"><img loading=\"lazy\" decoding=\"async\" width=\"937\" height=\"276\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-draft-status.png\" alt=\"select draft status in WooCommerce products table\" class=\"wp-image-26844\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-draft-status.png 937w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-draft-status-500x147.png 500w\" sizes=\"(max-width: 937px) 100vw, 937px\" \/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Choose the status you want for example <strong>Draft.<\/strong><\/li>\n\n\n\n<li>Wait a few seconds and let the plugin change the status of other selected products.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/result-draft-status.png\"><img loading=\"lazy\" decoding=\"async\" width=\"929\" height=\"277\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/result-draft-status.png\" alt=\"result draft status for WooCommerce products table\" class=\"wp-image-26845\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/result-draft-status.png 929w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/result-draft-status-500x149.png 500w\" sizes=\"(max-width: 929px) 100vw, 929px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Note:<\/strong> If the status column is not visible in the product table, you need to use the <strong>Column Profile<\/strong> form and add the <strong>Status<\/strong> column to the table.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-status-field.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1407\" height=\"412\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-status-field.png\" alt=\"select status field in column profiles\" class=\"wp-image-26846\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-status-field.png 1407w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-status-field-500x146.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-status-field-1000x293.png 1000w\" sizes=\"(max-width: 1407px) 100vw, 1407px\" \/><\/a><\/figure>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" id=\"mothod-3\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Method 3: Bulk edit product status WooCommerce by import\/export<\/h2>\n\n\n\n<p>You can also use the <strong>import\/export<\/strong> tool to bulk edit product status with or without a plugin.&nbsp;<\/p>\n\n\n\n<p>Let\u2019s review both methods:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Use import\/export tools in WooCommerce&nbsp;<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to the <strong>All Products<\/strong> page in the <strong>WordPress Dashboard.<\/strong>&nbsp;<\/li>\n\n\n\n<li>Press the <strong>Export<\/strong> button.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-export-button.png\"><img loading=\"lazy\" decoding=\"async\" width=\"820\" height=\"439\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-export-button.png\" alt=\"select export button in table products list\" class=\"wp-image-26847\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-export-button.png 820w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-export-button-500x268.png 500w\" sizes=\"(max-width: 820px) 100vw, 820px\" \/><\/a><\/figure>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>In the appeared form, you can choose which columns to be exported. As you want to bulk edit product status, it is necessary to choose the <strong>Published<\/strong> column with <strong>ID<\/strong> and <strong>Name<\/strong> of products.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-columns-for-export-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"649\" height=\"498\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-columns-for-export-1.png\" alt=\"select columns for export in export products form\" class=\"wp-image-26849\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-columns-for-export-1.png 649w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-columns-for-export-1-500x384.png 500w\" sizes=\"(max-width: 649px) 100vw, 649px\" \/><\/a><\/figure>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>Press <strong>Generate CSV<\/strong> to download and save the <strong>CSV<\/strong> file.<\/li>\n\n\n\n<li>Open the file in <strong>Excel<\/strong>.<\/li>\n\n\n\n<li>You can bulk edit product status in the Excel file as <strong>Published<\/strong> or <strong>Draft<\/strong> by inserting 1 or -1 in the related cells, respectively. It is not possible to set other statuses for products in this method.<\/li>\n<\/ol>\n\n\n\n<p>For example, the product statuses we have exported were not published as illustrated below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/result-exported-product-status-.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1357\" height=\"195\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/result-exported-product-status-.png\" alt=\"result exported product status in Excel file\" class=\"wp-image-26851\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/result-exported-product-status-.png 1357w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/result-exported-product-status--500x72.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/result-exported-product-status--1000x144.png 1000w\" sizes=\"(max-width: 1357px) 100vw, 1357px\" \/><\/a><\/figure>\n\n\n\n<p>So, we bulk changed the status cells and inserted <strong>1<\/strong> in all cells which means the products will be published when we import this CSV file to WooCommerce.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/result-products-changed-status-cells.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1355\" height=\"185\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/result-products-changed-status-cells.png\" alt=\"result products changed status cells in Excel file\" class=\"wp-image-26852\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/result-products-changed-status-cells.png 1355w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/result-products-changed-status-cells-500x68.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/result-products-changed-status-cells-1000x137.png 1000w\" sizes=\"(max-width: 1355px) 100vw, 1355px\" \/><\/a><\/figure>\n\n\n\n<ol start=\"7\" class=\"wp-block-list\">\n<li>Finally, you need to return to the WooCommerce <strong>All Products<\/strong> page and choose <strong>Import<\/strong>.<\/li>\n\n\n\n<li>Then, choose the edited file and mark the <strong>Updated existing products.<\/strong>&nbsp;<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-updated-existing-products-field.png\"><img loading=\"lazy\" decoding=\"async\" width=\"730\" height=\"478\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-updated-existing-products-field.png\" alt=\"select updated existing products field in import products form\" class=\"wp-image-26854\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-updated-existing-products-field.png 730w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-updated-existing-products-field-500x327.png 500w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><\/a><\/figure>\n\n\n\n<ol start=\"9\" class=\"wp-block-list\">\n<li>Press <strong>Continue<\/strong> to import the data and bulk edit the product statuses.&nbsp;<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Use the Import\/Export tool in WooCommerce products bulk edit plugin<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Add the <strong>Status<\/strong> column to the product table by using the <strong>Column Profile <\/strong>form.<\/li>\n\n\n\n<li>Select the products you want to bulk edit their product statuses.<\/li>\n\n\n\n<li>Open the <strong>Import\/Export<\/strong> form in our plugin by pressing the icon.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-import-and-export-icon-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"630\" height=\"52\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-import-and-export-icon-1.png\" alt=\"select import and export icon in plugin toolbar\" class=\"wp-image-26855\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-import-and-export-icon-1.png 630w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-import-and-export-icon-1-500x41.png 500w\" sizes=\"(max-width: 630px) 100vw, 630px\" \/><\/a><\/figure>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>Choose <strong>Only Selected Products\/Only visible Fields<\/strong> and press <strong>Export Now.<\/strong><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-products-and-fields-options.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1133\" height=\"555\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-products-and-fields-options.png\" alt=\"select products and fields options for export\" class=\"wp-image-26856\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-products-and-fields-options.png 1133w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-products-and-fields-options-500x245.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/01\/select-products-and-fields-options-1000x490.png 1000w\" sizes=\"(max-width: 1133px) 100vw, 1133px\" \/><\/a><\/figure>\n\n\n\n<p>Follow the steps 5 to 9 of the first method.<\/p>\n\n\n\n<p>In the <strong>Import\/Export<\/strong> form of our plugin, you have more flexible options to export products exactly as you need. We described all of these options, <span style=\"text-decoration: underline\"><a href=\"https:\/\/ithemelandco.com\/blog\/woocommerce-export-products-with-images\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a><\/span>.<\/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-4a33225c 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-4f39da6d 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\" style=\"font-size:26px;font-style:normal;font-weight:800\">PBULKiT &#8211; Bulk Edit WooCommerce Products<\/p>\n\n\n\n<p class=\"single-cta-desc has-white-color has-text-color has-link-color wp-elements-11005baf602e93620b344ff309fb0e9f\" style=\"font-size:16px\">The easy way to bulk edit WooCommerce product status<\/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=bulk-edit-product-status\" 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>In this post, we will introduce you to 3 practical methods for bulk edit WooCommerce product status. But if you have a large number of products in your store and you need to change their various features constantly, we suggest using the WooCommerce products bulk editing plugin. It provides all the necessary tools and options you need to filter and bulk edit WooCommerce products very fast and easily.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bulk edit the WooCommerce product status is necessary for online stores that usually need to add new products or remove some of them from the shop page. The most important use of bulk edit WooCommerce product status is when you have added several new products to your store and WooCommerce saves them as a draft [&hellip;]<\/p>\n","protected":false},"author":1990,"featured_media":26858,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[50,73],"tags":[],"class_list":["post-26833","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\/2024\/01\/bulk-edit-product-status-500x335.jpg","excerpt_plain":"Bulk edit the WooCommerce product status is necessary for online stores that usually need to add new products or remove some of them from the shop page. The most important use of bulk edit WooCommerce product status is when you have added several new products to your store and WooCommerce saves them as a draft [&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\/26833","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\/1990"}],"replies":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/comments?post=26833"}],"version-history":[{"count":2,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/posts\/26833\/revisions"}],"predecessor-version":[{"id":48942,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/posts\/26833\/revisions\/48942"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/media\/26858"}],"wp:attachment":[{"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/media?parent=26833"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/categories?post=26833"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/tags?post=26833"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}