{"id":662,"date":"2021-06-07T14:30:04","date_gmt":"2021-06-07T14:30:04","guid":{"rendered":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/?p=662"},"modified":"2025-10-22T08:29:21","modified_gmt":"2025-10-22T08:29:21","slug":"bulk-edit-product-sku","status":"publish","type":"post","link":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/bulk-edit-product-sku\/","title":{"rendered":"How to bulk edit product SKU in VBULKiT &#8211; Bulk Edit WooCommerce Variations &#8211; plugin?"},"content":{"rendered":"\n<p>In the <a href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-variations-bulk-edit\/?utm_source=kb&amp;utm_content=bulk-edit-sku\" target=\"_blank\" rel=\"noreferrer noopener\">VBULKiT &#8211; Bulk Edit WooCommerce Variations &#8211; plugin<\/a>, you can change multi WooCommerce product SKU at the same time. This helps to manage products faster and easier.<\/p>\n\n\n\n<p>In VBULKiT &#8211; Bulk Edit WooCommerce Variations &#8211; plugin,  the store manager is able to filter the products regarding their priorities then bulk edit their values such as SKU value.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>Read More:<\/strong> <a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/filter-products\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to filter products in VBULKiT &#8211; Bulk Edit WooCommerce Variations &#8211; plugin?<\/a><\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Displaying SKU column in the product table<\/strong><\/h2>\n\n\n\n<p>To display SKU column in the product table and better obverse how this field is going to be changed in the next step, we add SKU column to our preset:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized is-style-default\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-SKU-column.jpg\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1200\" height=\"468\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-SKU-column.jpg\" alt=\"Displaying SKU Column in the product table  in Woocommerce product bulk editing plugin\" class=\"wp-image-666\" style=\"width:900px\"\/><\/a><figcaption class=\"wp-element-caption\">Show SKU column in bulk edit table<\/figcaption><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>Read More:<\/strong> <a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/manage-product-columns\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to manage product table columns in VBULKiT &#8211; Bulk Edit WooCommerce Variations &#8211; plugin?<\/a><\/p>\n<\/blockquote>\n\n\n\n<p>As you can see the SKU of our products includes the word \u201cWoo\u201d and we are doing to replace it with product \u201cID\u201d.<\/p>\n\n\n\n<p>Let\u2019s show how to change SKU in WooCommerce.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Bulk edit product SKU<\/strong><\/h2>\n\n\n\n<p>Before bulk edit the multi SKU label in WooCommerce, you should select your products in question. otherwise all of the products will be changed and then click on \u201c<strong>Bulk Edit<\/strong>\u201d button from the toolbar.<\/p>\n\n\n\n<p>Bulk editing of product SKU is available in the \u201c<strong>General<\/strong>\u201d Tab of this plugin.<\/p>\n\n\n\n<p>As you can see in the below picture, there are 3 different boxes in front of product SKU:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-bulk-edit-form.jpg\"><img decoding=\"async\" width=\"1200\" height=\"633\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-bulk-edit-form.jpg\" alt=\"Change multi-product SKU in Woocommerce product bulk editing plugin\" class=\"wp-image-668\" style=\"width:900px\"\/><\/a><\/figure>\n\n\n\n<p>In the first box you can set below conditions:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Append:<\/strong> Your value will be added at the end of SKU.<\/li>\n\n\n\n<li><strong>Prepend: <\/strong>Your value will be added at the beginning of SKU.<\/li>\n\n\n\n<li><strong>New:<\/strong> A new value will be set for all SKU of the filtered product.<\/li>\n\n\n\n<li><strong>Delete:<\/strong> SKU of all filtered products will be deleted.<\/li>\n\n\n\n<li><strong>Replace:<\/strong> Your selected value will be replaced by a new value you entered.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-product-sku.jpg\"><img decoding=\"async\" width=\"1200\" height=\"580\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-product-sku.jpg\" alt=\"append product SKU operator in woocommerce bulk product editing\" class=\"wp-image-669\" style=\"width:900px\"\/><\/a><\/figure>\n\n\n\n<p>At the second box, you have to type the new value for changing SKU of filtered products. You can either select a variable from the opposite dropdown list(including the WooCommerce fields) or enter a new value.<\/p>\n\n\n\n<p>The Dropdown list includes below Items to make it easier for you to bulk edit multi-product SKU:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Title<\/li>\n\n\n\n<li>ID<\/li>\n\n\n\n<li>SKU<\/li>\n\n\n\n<li>Menu Order<\/li>\n\n\n\n<li>Parent ID<\/li>\n\n\n\n<li>The Parent Title<\/li>\n\n\n\n<li>Parent SKU<\/li>\n\n\n\n<li>Regular Price<\/li>\n\n\n\n<li>Sale Price<\/li>\n<\/ul>\n\n\n\n<p>It is possible to add one or more items from the list to the box.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-product-sku-variable.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"668\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-product-sku-variable.jpg\" alt=\"product sku variable option in woocommerce bulk product editing\" class=\"wp-image-671\" style=\"width:1200px\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Append value to product SKU<\/strong><\/h3>\n\n\n\n<p>In this example, we want to <strong>Append <\/strong>\u201cID\u201d and \u201cTitle\u201d to the SKU of selected products. To make our changes more readable, we also add some space between those values and separate them by \u201c,\u201d as below. So, you can see that the SKU of our products has been changed accordingly:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-content\/uploads\/sites\/15\/2021\/06\/append-id-title-to-SKU.png\"><img loading=\"lazy\" decoding=\"async\" width=\"979\" height=\"591\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-content\/uploads\/sites\/15\/2021\/06\/append-id-title-to-SKU.png\" alt=\"Append id title to SKU\" class=\"wp-image-2953\"\/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-final-result.jpg\"><img decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-final-result-e1688880077583.jpg\" alt=\"select products to change multi-product editing\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Prepend value to product SKU<\/strong><\/h3>\n\n\n\n<p>Now, let\u2019s repeat the previous changes by prepending theme to the SKU:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-append-id-and-title-2.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"538\" height=\"44\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-append-id-and-title-2.jpg\" alt=\"append id and title 2\" class=\"wp-image-677\" style=\"width:538px\"\/><\/a><\/figure>\n\n\n\n<p>We expect to see the \u201cID\u201d and \u201cTitle\u201d are added to the beginning of SKU:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-final-result-2-e1688880134695.jpg\" alt=\"change multi-product SKU in woocommerce bulk product editing\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Set a new value for product SKU<\/strong><\/h3>\n\n\n\n<p>If we select \u201c<strong>New<\/strong>\u201d from the condition box, all of the current values will be replaced by the value added to the text box. So, if we apply \u201cNew\u201d for the same values selected in the previous step:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-new-from-the-condition-box.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"535\" height=\"41\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-new-from-the-condition-box.jpg\" alt=\"new from the condition box\" class=\"wp-image-680\" style=\"width:535px;height:41px\"\/><\/a><\/figure>\n\n\n\n<p>The SKU of selected products will be replaced by \u201cID\u201d , \u201cTitle\u201d:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-final-result-3.jpg\"><img decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-final-result-3-e1688880196786.jpg\" alt=\"new value for product SKU in woocommerce bulk product editing\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Delete or remove <strong>product SKU<\/strong><\/strong><\/h3>\n\n\n\n<p>You can choose which part of SKU you prefer to be removed from this field. For example, we want to remove \u201cID\u201d, so, the conditions set as below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-product-sku-id.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"531\" height=\"164\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-product-sku-id.jpg\" alt=\"Select ID\" class=\"wp-image-683\" style=\"width:531px\"\/><\/a><\/figure>\n\n\n\n<p>By clicking on <strong>Do Bulk Edit<\/strong>, the changes are made as we expected:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-final-result-4.jpg\"><img decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-final-result-4-e1688880257889.jpg\" alt=\"Delete value from SKU in woocommerce bulk product editor\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Replace product SKU<\/strong><\/h3>\n\n\n\n<p>In this part of the tutorial, we are going to bulk edit the SKU of products and replace \u201cWoo\u201d in their SKU with \u201cID\u201d.<\/p>\n\n\n\n<p>So, at first we choose the \u201c<strong>Replace<\/strong>\u201d condition from the first box. As you can see below a new line will be shown to help you exactly specify what you want to be replaced.<\/p>\n\n\n\n<p>In the below Line, you can see another box to set conditions including:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-replace-condition.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"550\" height=\"131\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-replace-condition.jpg\" alt=\"select same case\" class=\"wp-image-685\" style=\"width:550px\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Same Case: <\/strong>The value you entered in the Product SKU box matter if is in lower or upper case.<\/li>\n\n\n\n<li><strong>Ignore Case:<\/strong> The value you entered in the Product SKU box no matter if is in lower or upper case.<\/li>\n<\/ul>\n\n\n\n<p>As it is obvious in the below picture, in the opposite dropdown list, some values have been set as default to help you select them to be replaced by.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-same-case.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"586\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-same-case.jpg\" alt=\"replace product SKU and change multi-product SKU\" class=\"wp-image-687\" style=\"width:900px\"\/><\/a><\/figure>\n\n\n\n<p>As we mentioned above, we want to replace \u201cWoo\u201d in the SKU of Products with \u201cID\u201d.<\/p>\n\n\n\n<p>To change multi-product SKU in this tutotrail and reach our goal, we follow below steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Enter \u201cWoo\u201d in the Product SKU Box.<\/li>\n\n\n\n<li>Set the first condition of the line below to \u201cSame Case\u201d.<\/li>\n\n\n\n<li>Choose \u201cID\u201d from the opposite dropdown list.<\/li>\n<\/ul>\n\n\n\n<p>By clicking on \u201c<strong>Do Bulk Edit<\/strong>\u201d, our preferred changes are conducted and we can see the final result in our product table:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-final-result-5.jpg\"><img decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/04-final-result-5-e1688880332730.jpg\" alt=\"change multi-product SKU via bulk edit\"\/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>In the VBULKiT &#8211; Bulk Edit WooCommerce Variations &#8211; plugin, you can change multi WooCommerce product SKU at the same time. This helps to manage products faster and easier. In VBULKiT &#8211; Bulk Edit WooCommerce Variations &#8211; plugin, the store manager is able to filter the products regarding their priorities then bulk edit their values [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-662","post","type-post","status-publish","format-standard","hentry","category-plugin-usage"],"_links":{"self":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/posts\/662","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/comments?post=662"}],"version-history":[{"count":4,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/posts\/662\/revisions"}],"predecessor-version":[{"id":3910,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/posts\/662\/revisions\/3910"}],"wp:attachment":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/media?parent=662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/categories?post=662"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/tags?post=662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}