Creating a new Price level to Price Shift
01. If you open up Total Control Premier
02. From the General Database submenu, If you select 'Products'
03. Within the Products screen, if you select 'Prices' and click on the drop-down followed by selecting 'New Price List'.
04. Within the Description field if you give the Price list a name followed by clicking 'Click Accept'
05. Where you see 'Default Prices' if you click on the drop-down arrow and from the drop-down if you select your new Price List which you have just created as follows;
06. This will open as follows;
07. If you now select 'Copy Prices In' found under the Products screen
08. Within 'Copy Prices In' - you can select the Product Range Selection or tick the Group selection (Optional)
09. If you make sure 'Copy Current Prices' is ticked followed by clicking 'Copy'
10. You will now see the 'Green Loading' Bar move along as the example below,
11. Once completed you will see a message to confirm 'Prices have been copied' if you now click 'OK'.
12. This will now show as follows as you can see your original prices have copied into the 'Price Level 1' column.
13. If you are adding in a new price level - you would select 'Copy Price to Price'
14. If you now select your destination as in my example, I am selecting rice Level 2 which is currently blank.
15. If you now make sure 'Use All Products' is ticked followed by clicking 'COPY'.
16. You will now be prompted with the 'Copy Price' message if you want to go ahead.
17. If you now click 'YES' which you will see the 'Green Status' Bar move along.
18. When completed you will be prompted with 'Copied' message and now if you click on 'OK'.
19. You will now have noticed your prices have copied into the 'Price Level 2' or the Price level you have chosen.
20. If you now select 'Batch change' from the toolbar menu.
21. You will now see the 'Batch Change Prices' box appear on your screen.
22. From the Update Method, you can select the following;
- Add a Set Value to the Price
- Subtract a Set Value from the Price
- Replace the Price with a set Price
- Add a Percentage to the Price
- Subtract a Percentage from the Price
- Subtract a Percentage from the Price Using Divide
- Use a Custom Formula to Calculate the New Price
Under the Round Method you can select from the following;
- No Rounding
- Round up to 0p
- Round up to 5p
- Round up to 9p
- Round Down to 0p
- Round Down to 5p
- Round Down to 9p
In my example, I have selected 'Use a Custom Formula to Calculate the New Price'
Select the new price staff costing and change the update method to 'Use a custom formula to calculate the new price' followed by entering the custom formula number 3 (cost price SKU) and below tick - Use all products instead of the selected products.
23. If you click 'GO' you will be prompted with a 'Batch Change Prices' message
24. If you click on 'YES' you will see the 'Green Status' Bar move along.
25. When completed you will see the 'Copied' message and now if you click on 'OK'
26. in my example, you will now notice your prices under Price Level 2 have changed.
27. Now you need to click on 'Copy Prices out'
28. which is set to default.
29. Now if you click 'COPY' you will be prompted with the 'Copy Prices' message followed by 'Yes'.
30. You will now see the 'Green status' bar move along within the 'Copy Price List to....' box.
31. When completed you will see the 'Copied' message.