- Go into the Publication module and Mailer Grid Manager
- Select the Mailer Name from the drop-down box
- Click Search
- In the Results tab, remove any lines you don't wish to update by highlighting them and click Remove Selected Records button.
- In the Change tab, tick Update Selling Price to, select criteria from the drop down and enter amount. The choices for updating the selling price are:
Increase by THIS Set Amount =>
Increase by THIS Set % =>
Decrease by THIS Set Amount =>
Decrease by THIS Set % =>
- Click the ‘Apply’ button to confirm these changes
Option 2
- Go into the Publication module and Mailers
- Double click into the mailer
- Click on the Pink Bar above the mailer to use the extended search function
- Click the Export Mailer button, which will bring up a pop-up box.
- An excel file will be created listing all the items in the mailer.
- To import back, the spreadsheet should contain ONLY the first 3 columns, MAINID, SUBID and NEW-MAILERPRICE. Delete all other columns.
- Once all the changes have been made, the spreadsheet needs to be saved as a CSVfile. DO NOT change the heading names.
- On the EDC machine, drop the file into the PrimaV6 > Imports folder
- The mailer prices will now be updated from the CSV file.
Note- The mailer prices will only be updated from the CSV file if the EDC is running