Versions Compared

Key

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

You can update mark up markup for a certain supply category let's say from 40% mark up markup you need to change it to 50% mark upmarkup.


1. Go to Inventory → Supplies → Import/Export then select Export Supplies.

...

3. With the Excel file opened, click on Data → Filter → and select the category of supplies with mark up markup you need to update.

In this example, we are selecting the category "backflow."

...

For example, if you want to change the mark up markup from 40% to 50% then you need to calculate and input the new price in column J.

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

...