Changing prices on a price change run
After extracting products to a price change run, you must make changes to the prices before you finalise it.
For each product, you can edit any of the following fields:
- New Price Ex Tax
- New Price Inc Tax
- Change
- Change Percent
- Gross Profit Percent
- Margin Percent
As you change any one of these fields in a line, all of the other fields will change to reflect the new data you entered.
For example:
- To increase a price by 10%, set the Change Percent field to 10%.
- To increase a price by $5, set the Change field to 5.
- To make 50% gross profit on a line, set the Gross Profit Percent field to 50%.
The Change Percent, Gross Profit Percent and Margin Percent fields are colour-coded to give a quick visual representation of the percentages in them: red fields indicate unexpected values or those that need attention (such as a gross profit of 0.0%) while yellow to green fields indicate expected values.
Setting prices for multiple lines
You can use the buttons in the Lines menu bar to set prices for more than one line at a time. Select each line that you want to change, then click the relevant button:
- Adjust From Current Price lets you adjust the price for each line by a given percentage. (This sets the Change Percent field.)
- Set GP% sets the gross profit for each line to a given percentage.
- Set Margin sets the margin for each line to a given percentage.
- Set Price Category lets you specify the price category for each selected line.
- Round To Nearest 5c rounds the New Price Inc Tax field to the nearest 5 cents.
- Apply Category Price applies pricing based on each line's price category.
Uncheck the Update Was Price under Additional Fields if you not want to update the product Was Price