{"id":1394,"date":"2021-05-12T11:35:00","date_gmt":"2021-05-12T11:35:00","guid":{"rendered":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/?p=1394"},"modified":"2025-10-22T09:38:12","modified_gmt":"2025-10-22T09:38:12","slug":"inline-edit-product-price","status":"publish","type":"post","link":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/inline-edit-product-price\/","title":{"rendered":"How to inline edit product prices with price calculator in VBULKiT &#8211; Bulk Edit WooCommerce Variations &#8211; plugin?"},"content":{"rendered":"\n<p>Inline edit of product prices with product price calculator is one of the main tasks of store managers, as they have to keep the prices of products up to date according to the different situation.<\/p>\n\n\n\n<p>To help store owners to manage and control the product prices, we have designed a price calculator in the plugin which is available in the price columns in the product table.<\/p>\n\n\n\n<p>If you know how to use our calculator to change the price of your products, inline editing of product price would be an easy and quick task for you.<\/p>\n\n\n\n<p>To make sure that you can use <a href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-variations-bulk-edit\/?utm_source=kb&amp;utm_content=inline-edit-price\" target=\"_blank\" rel=\"noreferrer noopener\">VBULKiT &#8211; Bulk Edit WooCommerce Variations &#8211; plugin<\/a> price calculator, we are going to make it clear by some examples in the following steps.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 1: Filter desired products<\/strong><\/h2>\n\n\n\n<p>There are two ways for filtering products in our plugin:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Using filter form.<\/li>\n\n\n\n<li>Using search box.<\/li>\n<\/ol>\n\n\n\n<p>As we completely described these features of our plugin in other tutorials, we skip explaining this part in detail and abstract it by making the below example.<\/p>\n\n\n\n<p>In this tutorial we need to change the price of downloadable products. So, as you can see in the below picture, we select \u201c<strong>Yes<\/strong>\u201d from the combo box of \u201c<strong>Downloadable<\/strong>\u201d in the \u201c<strong>Type<\/strong>\u201d tab of filter form.<\/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\/32-Downloadable.jpg\"><img decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/32-Downloadable-e1688885796988.jpg\" alt=\"Filter the products in Woocommerce bulk edit plugin\"\/><\/a><\/figure>\n\n\n\n<p>Then to better track the changed we are going to made by inline editing of product prices, it sounds great to load price columns from &#8220;<strong>Columns Profiles<\/strong>&#8220;.<\/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\/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>By clicking on \u201c<strong>Apply to Table<\/strong>\u201d, you can see our product table including \u201c<strong>Downloadable<\/strong>\u201d products with prices column in the product table.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 2: Inline edit filtered product prices<\/strong><\/h2>\n\n\n\n<p>Inline edit of product prices is easily possible in three ways:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Clicking on each column displaying the prices and typing any number you need.<\/li>\n\n\n\n<li>Using Up\/Down button in each cell to Increase\/Decrease the price.<\/li>\n\n\n\n<li>Using the WooCommerce product price calculator.<\/li>\n<\/ul>\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\/32-product-price.jpg\"><img decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/32-product-price-e1688888645670.jpg\" alt=\"Inline edit of product price in woocommerce bulk product editing\"\/><\/a><\/figure>\n\n\n\n<p>We are going to describe how to inline edit product prices using price calculator.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Using the product price calculator for inline edit<\/strong><\/h2>\n\n\n\n<p>Inline edit of product price by using the calculator of our plugin is really amazing. Stay with us to help you using this option effectively in our plugin.<\/p>\n\n\n\n<p>After clicking on the calculator icon, a pop-up page will appear and you can use the designed calculator to inline edit product price.<\/p>\n\n\n\n<p>As you can see, this calculator has 4 fields including:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Operator Box:<\/strong> You can select +, -, RP- (based on regular price displayed only for editing sale price), SP+ (based on sale price displayed only for editing regular price).<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td>Editing Regular Price<\/td><td>Editing Sale Price<\/td><\/tr><tr><td><img fetchpriority=\"high\" decoding=\"async\" width=\"680\" height=\"219\" class=\"wp-image-1410\" style=\"width: 680px;\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/32-Editing-Regular-Price.jpg\" alt=\"\"><\/td><td><img decoding=\"async\" width=\"680\" height=\"218\" class=\"wp-image-1411\" style=\"width: 680px;\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/32-Editing-Sale-Price.jpg\" alt=\"\"><\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n<\/div>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>Textbox:<\/strong> You can type a number or using Up\/Down button to increase or decrease the number.<\/li>\n\n\n\n<li><strong>Type of number:<\/strong> You can select n (Number) or % (Number%) from the dropdown list.<\/li>\n<\/ol>\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\/32-Type-of-number.jpg\"><img decoding=\"async\" width=\"623\" height=\"203\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/32-Type-of-number.jpg\" alt=\"set round value for price\" class=\"wp-image-1413\" style=\"width:623px\"\/><\/a><\/figure>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li><strong>Round box:<\/strong> You can select the round number from the dropdown list.<\/li>\n<\/ol>\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\/32-Round-box.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"623\" height=\"383\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/32-Round-box.jpg\" alt=\"rounded price in woocommerce bulk product editing\" class=\"wp-image-1415\" style=\"width:623px\"\/><\/a><\/figure>\n\n\n\n<p>Now let\u2019s see how we can inline edit the prices of our filtered product by using this calculator.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Increasing the sale price using price calculator<\/strong><\/h3>\n\n\n\n<p>We want to increase the sale price of \u201cWoocommerce Plugin\u201d by 7.<\/p>\n\n\n\n<p>As you can see in the below picture, the existing sale price of this product is 7.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/32-Sale-Price.jpg\"><img decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/32-Sale-Price-e1688888717807.jpg\" alt=\"Increasing the Sale Price Inline edit product image\"\/><\/a><\/figure>\n\n\n\n<p>To increase this price by 7, we selected + from the operator box, then typed \u201c7\u201d in the textbox and chose \u201cn\u201d from the type of the number and finally we set the calculator to round our calculated number by .99.<\/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\/32-calculated-number.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"622\" height=\"200\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/32-calculated-number.jpg\" alt=\"\" class=\"wp-image-1419\" style=\"width:622px\"\/><\/a><\/figure>\n\n\n\n<p>So we expect that the final price displayed as 0.99 according to the below calculation:<\/p>\n\n\n\n<p>Current Sale Price (7) + the entered number (7) = 14 rounded by 0.99=0.99<\/p>\n\n\n\n<p>By clicking on <strong>Applying Changes<\/strong>, you can see the result:<\/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\/32-result.jpg\"><img decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/32-result-e1688888776901.jpg\" alt=\"display products in woocommerce bulk product editing\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Decreasing the sale price based on regular price<\/strong><\/h3>\n\n\n\n<p>To decrease the sale price of \u201cWoocommerce\u201d product by 2 based on product price, we selected \u201crp-\u201c from the calculator operator box and typed \u201c2\u201d in the text box. Then we chose \u201cn\u201d as the \u201cNumber\u201d without any rounding:<\/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\/32-rounding.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"625\" height=\"201\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/32-rounding.jpg\" alt=\"\" class=\"wp-image-1423\" style=\"width:625px;height:201px\"\/><\/a><\/figure>\n\n\n\n<p>We expect to see the below result:<\/p>\n\n\n\n<p>Current Regular Price of WooCommerce (15) \u2013 Our entered number (2) = 13 (Without rounding)<\/p>\n\n\n\n<p>As shown below, our calculator have done this calculation less than a second successfully:<\/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\/32-Current-Regular-Price.jpg\"><img decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/32-Current-Regular-Price-e1688888839384.jpg\" alt=\"Inline edit product image in woocommerce bulk edit product\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Decreasing sale price<\/strong><\/h3>\n\n\n\n<p>Now, let\u2019s look at another example of decreasing the sale price of \u201cWoocommerce\u201d product by 3.<\/p>\n\n\n\n<p>Again, we clicked on \u201c<strong>Calculator<\/strong>\u201d Icon on the sale price cell of \u201cWoocommerce\u201d in the product table and set the conditions as below:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Operator Box: &#8211;<\/li>\n\n\n\n<li>Textbox: 3<\/li>\n\n\n\n<li>Type: n<\/li>\n\n\n\n<li>Round:5<\/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\/32-Calculator.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"625\" height=\"201\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/32-Calculator.jpg\" alt=\"\" class=\"wp-image-1426\" style=\"width:625px\"\/><\/a><\/figure>\n\n\n\n<p>We expect to see the sale price as:<\/p>\n\n\n\n<p>Current sale Price (13) \u2013 our entered number (3)= 10 (Round by 0.05)=10.05<\/p>\n\n\n\n<p>By clicking on \u201c<strong>Apply Changes<\/strong>\u201d, The magic has happened and you can see the correct result 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\/32-result-1.jpg\"><img decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/32-result-1-e1688888901885.jpg\" alt=\"managing product price in woocommerce bulk product editing\"\/><\/a><\/figure>\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\/32-Calculator-1.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"625\" height=\"203\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/32-Calculator-1.jpg\" alt=\"\" class=\"wp-image-1430\" style=\"width:625px\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Increasing regular price based on sale price<\/strong><\/h3>\n\n\n\n<p>Now, consider that the regular price of \u201cWoocommerce\u201d product must be 20% more than sale price which means at the end the regular price must be:<\/p>\n\n\n\n<p>Current Sale Price (10.05) + (Current Sale Price (10.5)*20%) = 10.05 + 10.05*20\/100 = 12.10 (Rounded by 0.10)&nbsp;<\/p>\n\n\n\n<p>To make our plugin calculate this price for you, you can easily follow below steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on the \u201cCalculator\u201d icon in the regular price column of \u201cWooCommerce\u201d.<\/li>\n\n\n\n<li>Choose \u201cSP+\u201d from operator box.<\/li>\n\n\n\n<li>Enter \u201c20\u201d in the text box.<\/li>\n\n\n\n<li>Select \u201c%\u201d from value type box.<\/li>\n\n\n\n<li>Choose \u201c10\u201d as rounding condition.<\/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\/32-rounding-condition.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"625\" height=\"203\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/32-rounding-condition.jpg\" alt=\"\" class=\"wp-image-1432\" style=\"width:625px\"\/><\/a><\/figure>\n\n\n\n<p>The result displayed as we expected in the Regular Price cell of \u201cWoocommerce\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\/32-Regular-Price.jpg\"><img decoding=\"async\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation\/wp-content\/uploads\/sites\/15\/2021\/03\/32-Regular-Price-e1688888955425.jpg\" alt=\"Increasing Regular Price based on Sale Price in woocommerce bulk product editing\"\/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Inline edit of product prices with product price calculator is one of the main tasks of store managers, as they have to keep the prices of products up to date according to the different situation. To help store owners to manage and control the product prices, we have designed a price calculator in the plugin [&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-1394","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\/1394","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=1394"}],"version-history":[{"count":3,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/posts\/1394\/revisions"}],"predecessor-version":[{"id":3952,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/posts\/1394\/revisions\/3952"}],"wp:attachment":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/media?parent=1394"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/categories?post=1394"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-variation-editing\/wp-json\/wp\/v2\/tags?post=1394"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}