The columns: Purchase price + cost = Cost of goods. The Cost of goods value is the key for any calculation in Calculate your price. If you only have Cost of goods the plugin will try to calculate backwards then you see that cost = cost of goods and purchase price is empty. If you know purchase price and then add this the cost field will automatically adjust its value. But you can use Calculate your price without setting purchase price and cost if you like.
So with this in mind, let us play with some examples.
I want to bulk update my products with 50% profit
I have values in Cost of goods so then we enter 150 in the bulk input field for Markup (100 + your profit i.e 50). Select the Set fixed and now you will see the New price (suggested price) has a 50% profit. So compare it with the current price and if OK click the “Save all” button. This changes your current price to equal the New price.
I want to increase each price by 18.5% for freight then double the resulting price to give me a new sell price.
To do this we need to figure out the Markup (for bulk set Markup on every product). So we start by adding 118.5 in Markup (then the suggested new price has added 18.5%). So we want to double (add 100%), then in New price we add 100 (increase by %). Now we see that Markup is 237 so this Markup is the number we now can add (set fixed) as Markup for the rest of our products – then all our prices will have this calculation.
I want to add Freight or Shipping cost to my calculations
To add Shipping cost (or Freight) go to: WooCommerce > Settings > Calculate your price. Find Shipping cost: name. We want to call it Freight so we enter Freight then we check the checkbox: Show shipping cost + Save
Then go back to Calculate your price. Now you have a new column labeled Freight and you can add values that will be included in Cost of goods. ( Purchase price + Cost + Freight/Shipping cost = Cost of goods)