{"id":26833,"date":"2024-01-27T14:05:06","date_gmt":"2024-01-27T14:05:06","guid":{"rendered":"https:\/\/ithemelandco.com\/?p=26833"},"modified":"2026-05-12T20:11:38","modified_gmt":"2026-05-12T20:11:38","slug":"bulk-edit-woocommerce-product-status","status":"publish","type":"post","link":"https:\/\/ithemelandco.com\/blog\/bulk-edit-woocommerce-product-status\/","title":{"rendered":"How to Bulk Edit WooCommerce Product Status (3 Easy Methods)"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Managing product visibility is an important part of running an online store. In WooCommerce, each product has a status that determines whether it appears on the shop page, stays hidden as a draft, or is only accessible to specific users. When store owners add or update many products at once, changing the status of each item individually can become time-consuming.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is where bulk editing becomes extremely useful. Instead of opening every product page one by one, you can update the status of multiple products in just a few clicks. For example, when importing new items into your store, WooCommerce often saves them as drafts, which means they will not appear on the shop page until they are published.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this guide, we will explain how to bulk edit WooCommerce product status using three practical methods. You will learn how to update product status using WooCommerce\u2019s default bulk editor, PBULKiT plugin as a dedicated WooCommerce bulk editing plugin, and the import\/export feature for large product catalogs.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What is WooCommerce product status?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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><figcaption class=\"wp-element-caption\">WooCommerce default tools for filtering products<\/figcaption><\/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><figcaption class=\"wp-element-caption\">Select some products and apply edits<\/figcaption><\/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><figcaption class=\"wp-element-caption\">Change product status field<\/figcaption><\/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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\"><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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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>download and install the WooCommerce product bulk editing plugin. 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-pullquote\"><blockquote><p><strong>Read more:<\/strong> <a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/how-to-install-the-woocommerce-bulk-product-editing-plugin\/\" data-type=\"link\" data-id=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-product-editing\/how-to-install-the-woocommerce-bulk-product-editing-plugin\/\">How to install the PBULKiT \u2013 Bulk Edit WooCommerce Products plugin?<\/a><\/p><\/blockquote><\/figure>\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><figcaption class=\"wp-element-caption\">Open PBULKiT plugin<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">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><figcaption class=\"wp-element-caption\">PBULKiT toolbar<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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-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<p class=\"single-cta-desc has-white-color has-text-color has-link-color wp-elements-11005baf602e93620b344ff309fb0e9f wp-block-paragraph\" 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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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><figcaption class=\"wp-element-caption\">Filter form in PBULKiT plugin<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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><figcaption class=\"wp-element-caption\">Bulk edit product status<\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Method 2: Bind edit product status WooCommerce<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><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 class=\"wp-block-paragraph\">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><figcaption class=\"wp-element-caption\">Select some products and run Bind Edit<\/figcaption><\/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><figcaption class=\"wp-element-caption\">Result of bind edit<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><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><figcaption class=\"wp-element-caption\">Select status column to display in table<\/figcaption><\/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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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><figcaption class=\"wp-element-caption\">Click on the export button in Woo<\/figcaption><\/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><figcaption class=\"wp-element-caption\">Select columns to be exported<\/figcaption><\/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 class=\"wp-block-paragraph\">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><figcaption class=\"wp-element-caption\">Result of product status as draft<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">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><figcaption class=\"wp-element-caption\">Update the publish status to 1<\/figcaption><\/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><figcaption class=\"wp-element-caption\">Import updated file<\/figcaption><\/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><figcaption class=\"wp-element-caption\">Click on the import\/export icon<\/figcaption><\/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><figcaption class=\"wp-element-caption\">Export products using the PBULKiT plugin by iThemeland<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Follow the steps 5 to 9 of the first method.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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, below:<\/p>\n\n\n\n<figure class=\"wp-block-pullquote\"><blockquote><p><strong>Read more:<\/strong> <a href=\"https:\/\/ithemelandco.com\/blog\/woocommerce-export-products-with-images\/?utm_source=blog&amp;utm_content=bulk-edit-product-status\" target=\"_blank\" data-type=\"link\" data-id=\"https:\/\/ithemelandco.com\/blog\/woocommerce-export-products-with-images\/\" rel=\"noreferrer noopener\">How to Export WooCommerce Products with Images (3 Easy Methods \u2013 CSV\/XML)<\/a><\/p><\/blockquote><\/figure>\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<p class=\"single-cta-desc has-white-color has-text-color has-link-color wp-elements-11005baf602e93620b344ff309fb0e9f wp-block-paragraph\" 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 class=\"wp-block-paragraph\">WooCommerce product status plays a key role in controlling which products appear in your store and which remain hidden for editing or review. While WooCommerce provides a basic bulk editing feature, it has limited filtering capabilities when managing a large product catalog.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For small stores, the default WooCommerce bulk editor can be enough to quickly publish or draft multiple products. However, if you regularly manage hundreds or thousands of products, using a WooCommerce bulk editing plugin like PBULKiT or an import\/export workflow can significantly speed up your store management.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">By using the right bulk editing method, store managers can update product statuses quickly, reduce manual work, and keep their WooCommerce catalog organized and ready for customers.<\/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\">What is WooCommerce product status?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">WooCommerce product status determines whether a product is visible and available for purchase in the store. Products can be set as Published, Draft, Pending Review, or Private depending on whether the store owner wants the item to appear on the shop page.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">How can I bulk edit WooCommerce product status?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">You can bulk edit WooCommerce product status using the built-in bulk edit tool in the Products page. Alternatively, you can use a WooCommerce bulk editing plugin like PBULKiT or export products to a CSV file, edit the status in Excel, and import the updated file back into WooCommerce.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Can I change product status for multiple WooCommerce products at once?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Yes, WooCommerce allows store managers to select multiple products and change their status in bulk. This makes it easier to publish newly added products, move items to draft, or manage product visibility without editing each product individually.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Why do store managers need to bulk edit WooCommerce product status?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Bulk editing product status helps store managers save time when managing large product catalogs. It is especially useful when publishing newly imported products, hiding outdated items, or updating product availability across multiple items at once.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Is it better to use a plugin for WooCommerce bulk editing?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">For stores with many products, using a WooCommerce bulk editing plugin like PBULKiT, provides more advanced filtering and editing tools. These plugins allow store managers to quickly find specific products and update their status or other fields much faster than the default WooCommerce editor.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Managing product visibility is an important part of running an online store. In WooCommerce, each product has a status that determines whether it appears on the shop page, stays hidden as a draft, or is only accessible to specific users. When store owners add or update many products at once, changing the status of each [&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":"Managing product visibility is an important part of running an online store. In WooCommerce, each product has a status that determines whether it appears on the shop page, stays hidden as a draft, or is only accessible to specific users. When store owners add or update many products at once, changing the status of each [&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":5,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/posts\/26833\/revisions"}],"predecessor-version":[{"id":51021,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/posts\/26833\/revisions\/51021"}],"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}]}}