If you have a lot of opportunities that you want to transfer to different account managers, but you don't want to change the account manager on the relationship, then you may benefit from using the Dataloader functionality to upload a file of the transfers you wish to perform and allowing the Dataloader to do this for you.
We recommend that the first time you use this functionality, you use a small file with a couple of opportunities so you can test out the functionality and make sure you are happy with it. Once you are happy, then you can upload a larger file containing all the opportunities you wish to transfer.
You will need to make sure your user has permission to use the "Opportunity Set Account Mgr" Dataloader type by checking Settings > Edit User.
You will need to prepare a CSV file containing the opportunity ID's that you wish to merge. The email address of the account manager, as used in Accelerate, should be in the first column, followed by a list of opportunity ids that should be transferred to that user (opportunity id's can be found in the Opportunity report by going to Reports > Opportunities) e.g.
[email protected],123456,124567,982304
[email protected],34562
[email protected],112233,334455
This CSV file would transfer opportunity ids 123456, 124567 and 982304 to the account manager with the email address [email protected], opportunity 34562 to the account manager with the email address [email protected], and opportunities 112233 and 334455 to the account manager with the email address [email protected]. It would perform each of these transfers in turn, so 123456 would be transferred first and then 124567.
The file should only contain this information, it should not contain headers and the email address should be exactly as used within the Accelerate application. The file can either contain one opportunity per line or multiple opportunities on the same line, as in the example above. So in the example above, we could have produced a file with one opportunity per line which would do the exact same thing e.g
[email protected],123456
[email protected],124567
[email protected],982304
[email protected],34562
[email protected],112233
[email protected],334455
Once you have prepared your CSV file, go to https://dataloader.quotevineapp.com and login with your Accelerate credentials.
Select 'OpportunitySet Account Mgr' as the Data Type and click 'Next'.
Choose who to notify after the upload.
Select the file you wish to upload and click 'Upload'.
A preview of the data uploaded from the file will be presented.
Clicking Confirm will perform all the transfers and if you click "Transfer tasks" then it will also transfer any open tasks associated with the opportunity that are assigned to the current account manager to the new account manager.
Click below for detailed instructions.
Once an opportunity transfer file has been processed, it is very difficult to undo. Therefore, please double check that your file is correct. There is validation in place to check that the opportunity and account manager exist and that the opportunity is not closed, however if you mistype then it might still find an opportunity or account manager and the results will be different to expected.
We recommend using the opportunity report to generate the list of opportunities with their associated ID.