Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In this example, our fist item has a sell price of $10.2 which is 40% 50% markup. To update it to 50% 60% markup, we can calculate by $10.00 X 60% + Cost Ex tax = $16.3200. If you're using formulas to calcuate the new markup, make sure to paste the data as values prior to importing.
Image Removed


Prior to the change

Image Added

After updating column J Sell Price based on 60% markup

Image Added


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.

...