{"id":767,"date":"2021-05-11T13:02:00","date_gmt":"2021-05-11T13:02:00","guid":{"rendered":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/?p=767"},"modified":"2023-07-10T15:15:30","modified_gmt":"2023-07-10T15:15:30","slug":"bulk-edit-product-price","status":"publish","type":"post","link":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/bulk-edit-product-price\/","title":{"rendered":"How to bulk edit product prices in WooCommerce variations bulk edit plugin?"},"content":{"rendered":"\n<p>Bulk edit product prices is one of the most useful features of <a href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-variations-bulk-edit\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">WooCommerce variations bulk edit plugin<\/span><\/a> which enables store managers to bulk edit regular price, sale price, tax status, sale date and etc.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 1: Filter products<\/strong><\/h2>\n\n\n\n<p>Before starting to bulk edit product prices you have to filter your desire products.<\/p>\n\n\n\n<p>For example, in this tutorial, we want to bulk edit the prices of downloadable and featured products. So, as we mentioned in \u201c<a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/filter-products\/\" target=\"_blank\" rel=\"noreferrer noopener\"><\/a><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/filter-products\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">How to filter products in WooCommerce variations bulk edit plugin?<\/span><\/a>\u201d, we filtered those products by going to \u201c<strong>Filter Form<\/strong>\u201d and select them in the<strong> <\/strong>\u201c<strong>Type<\/strong>\u201d tab as below:<\/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\/07-filter-form.jpg\"><img decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/07-filter-form-e1688897704642.jpg\" alt=\"filter products in Woocommerce Bulk Product Editing\"\/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 2: Customize the columns of product table<\/strong><\/h2>\n\n\n\n<p>Customizing columns of the product table is not a necessary task for bulk editing product price, however, we recommend you to choose \u201c<strong>Regular Price<\/strong>\u201d and \u201c<strong>Sale Price<\/strong>\u201d columns in the column profile to better follow your changes.<\/p>\n\n\n\n<p>If you are not familiar with choosing the columns please refer to another tutorial \u201c<a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/save-and-load-column-profiles\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">How to save and load column profiles in WooCommerce variations bulk edit plugin?<\/span><\/a>\u201d<\/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\/07-customize-product-table-columns.jpg\"><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/07-customize-product-table-columns.jpg\" alt=\"Customize the columns of product table in Woocommerce Bulk Product Editing\" class=\"wp-image-772\" width=\"1200\" height=\"421\"\/><\/a><\/figure>\n\n\n\n<p>As we filtered \u201c<strong>Downloadable<\/strong>\u201d and \u201c<strong>Featured<\/strong>\u201d products, our product table with these columns displayed as below:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 3: bulk edit product prices<\/strong><\/h2>\n\n\n\n<p>It is really easy to Bulk edit product price in our plugin as we described below just by one click:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on bulk edit in the main page to open \u201c<strong>Bulk Edit<\/strong>\u201d form.<\/li>\n\n\n\n<li>Go to \u201c<strong>Pricing<\/strong>\u201d tab to see the below form:<\/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\/07-pricing-tab.jpg\"><img decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/07-pricing-tab.jpg\" alt=\"change multi product price with only one click\" class=\"wp-image-775\" width=\"1024\" height=\"643\"\/><\/a><\/figure>\n\n\n\n<p>There is no difference if you have chosen ten, one hundred or even one thousand products for editing.<\/p>\n\n\n\n<p>You can change values in the options below according to the conditions you prefer, and change their prices at the same time. It is like magic, isn\u2019t it?<\/p>\n\n\n\n<p>Now let\u2019s take a look at what is waiting for you in the \u201c<strong>Pricing<\/strong>\u201d tab of \u201c<strong>Bulk Edit<\/strong>\u201d Form.<\/p>\n\n\n\n<p>As you may notice to the above picture, you can change:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Regular price<\/li>\n\n\n\n<li>Sale Price<\/li>\n\n\n\n<li>the Sale Date From&nbsp;<\/li>\n\n\n\n<li>Sale Date To<\/li>\n\n\n\n<li>Tax Status<\/li>\n\n\n\n<li>Tax Class<\/li>\n<\/ul>\n\n\n\n<p>There are a lot more options related to each field. Therefore, follow this tutorial to see how to bulk edit product prices in the WooCommerce variations bulk edit plugin.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Regular price<\/strong><\/h3>\n\n\n\n<p>As you can see in the below picture, there are three boxes next to the regular price field.<\/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\/07-regular-prices.jpg\"><img decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/07-regular-prices.jpg\" alt=\"change regular price in woocommerce bulk product editing\" class=\"wp-image-777\" width=\"1200\" height=\"643\"\/><\/a><\/figure>\n\n\n\n<p>We designed some default conditions in the first box and you can choose one of them from the dropdown list to bulk edit regular prices of your filtered products according to them, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Set New: <\/strong>A new value will be replaced by the current value.<\/li>\n\n\n\n<li><strong>Clear Value:<\/strong> The current value will be totally cleared.<\/li>\n\n\n\n<li><strong>Formula:<\/strong> you can use (+)plus, (-)minus, (*)times or (\/)division sign to make a formula for editing the current value.<\/li>\n\n\n\n<li><strong>Increased by value:<\/strong> Increase the current value by the value you entered.<\/li>\n\n\n\n<li><strong>Decreased by value:<\/strong> Decrease the current value by the value you entered.<\/li>\n\n\n\n<li><strong>Increased by %:<\/strong> Increase the current value by the percent you have entered.<\/li>\n\n\n\n<li><strong>Decreased by %:<\/strong> The current value will be decreased by the percent you have entered.<\/li>\n\n\n\n<li><strong>Increase by value (From Sale):<\/strong> The value will be sale price added up entered value.<\/li>\n\n\n\n<li><strong>Increase by value % (From Sale): <\/strong>The value will be sale price added up the percent of sale price, for example if you set 10 for value, the result will be (sale price + (sale price*10%)).<\/li>\n<\/ul>\n\n\n\n<p><strong>Note:<\/strong> In the formula type, (the current value = X). For example <em>(X+10)*10%<\/em>&nbsp; mean <em>(The current value+10) * 10%<\/em>. if X=20: (20+10)*10% = 3<\/p>\n\n\n\n<p>At the second box, you can type the value which must be a number without any special limit.<\/p>\n\n\n\n<p>In the third box, you can set how the calculated prices according to our specified conditions and value for rounding and displaying in the product table.<\/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\/07-round-item.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/07-round-item.jpg\" alt=\"round up the calculated price\" class=\"wp-image-779\" width=\"1200\" height=\"641\"\/><\/a><\/figure>\n\n\n\n<p>The options available for the \u201c<strong>Sale Price<\/strong>\u201d are mostly the same as \u201c<strong>Regular Price<\/strong>\u201d. The difference is for the last two items of conditions which we will explain in the following.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Sale price<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Decrease by value (From regular): <\/strong>The value will be regular price minus entered value<\/li>\n\n\n\n<li><strong>Decrease by value % (From regular):<\/strong> The value will be regular price minus the percent of regular price, for Example if you set 10 for value, the result will be (Regular Price &#8211; (Regular Price*10%))<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Sale date from and sale date to<\/strong><\/h3>\n\n\n\n<p>The next two fields named \u201c<strong>Sale Date From<\/strong>\u201d and \u201c<strong>Sale Date To<\/strong>\u201d, can help you to set a schedule for starting and ending the sale date for selling your products on sale.<\/p>\n\n\n\n<p>By choosing this date from the calendar, the sale price will automatically displayed in your online store from the start date to the end date.<\/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\/07-sale-date.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/07-sale-date.jpg\" alt=\"Sale date from and Sale date to for sale price for products\" class=\"wp-image-781\" width=\"1200\" height=\"640\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Tax status and tax class<\/strong><\/h3>\n\n\n\n<p>All the tax status you have already assigned to your product in WooCommerce is available here to make controlling and managing selling the product easier for you.<\/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\/07-tax-status.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/07-tax-status.jpg\" alt=\"tax status through the bulk product editing\" class=\"wp-image-783\" width=\"1024\" height=\"643\"\/><\/a><\/figure>\n\n\n\n<p>You can also choose the <strong>Tax Class<\/strong> to be assigned to the filtered product by choosing one of the items in the dropdown list next to this field.<\/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\/07-tax-status.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/07-tax-status.jpg\" alt=\"all of tax classes are available in bulk edit form\" class=\"wp-image-783\" width=\"1200\" height=\"643\"\/><\/a><\/figure>\n\n\n\n<p><strong>Note: <\/strong>Please refer to \u201c<a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/bulk-edit-product-tax-settings\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">How to bulk edit product tax settings in WooCommerce variations bulk edit plugin?<\/span><\/a>\u201d, if you need more information.<\/p>\n\n\n\n<p>For example, we want to increase sale prices of our filtered product by 0.5 unit.<\/p>\n\n\n\n<p>To bulk edit product sale prices we followed below steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select <strong>Increase by value<\/strong> from the condition box of <strong>Sale Price<\/strong> field.&nbsp;<\/li>\n\n\n\n<li>Type 0.5 as the value in the text box.<\/li>\n\n\n\n<li>Click on \u201c<strong>Do Bulk Edit<\/strong>\u201d.<\/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\/07-sale-prices.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/07-sale-prices.jpg\" alt=\"increase sale prices of our filtered product in woocommerce bulk edit form\" class=\"wp-image-788\" width=\"1024\" height=\"644\"\/><\/a><\/figure>\n\n\n\n<p>Now, you can see that the sale price of our filtered products has been changes as below:<\/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\/07-final-result.jpg\"><img decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/07-final-result-e1688897800257.jpg\" alt=\"bulk edit product price in woocommerce bulk product editor\"\/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Bulk edit product prices is one of the most useful features of WooCommerce variations bulk edit plugin which enables store managers to bulk edit regular price, sale price, tax status, sale date and etc. Step 1: Filter products Before starting to bulk edit product prices you have to filter your desire products. For example, in [&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-767","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\/767","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=767"}],"version-history":[{"count":0,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/posts\/767\/revisions"}],"wp:attachment":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/media?parent=767"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/categories?post=767"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/tags?post=767"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}