...
In this example, our fist item has a sell price of $10.2 which is 50% markup. To update it to 60% markup, we can calculate by $10.00 X 60% + Cost Ex tax = $16.00. If you're using formulas to calcuate the new markup, make sure to paste the data as values prior to importing.
Prior to the change
After updating column J Sell Price based on 60% markup
6. Save the updated file and go back to Inventory → Supplies → but this time, select Import and markup for the selected supply category should update accordingly.
...