I need to update a line on numerous Opportunity Products across multiple opportunities (too many to do manually) and want to use the data loader to achieve this. However I can't seem to find a reporting option that would output the Opporunity -> Product ID field. I can get the field I need to update, the Opportunity ID and Product ID's, but not the specific Salesforcfe internal ID needed to update the Opportunity -> Product field.
Does anyone know a way to output the Opportunity -> Product records with their ID's from a Salesforce report? Can I output that data using the data loader?
Thanks much!
Cheers,
James
3 个回答
Hi James,
showing it in the report, you have to create a new field on Opportunity Product (Formula, Output Text, Formula: Casesafeid() ), which you can reference to update the Opportunity Products.
Else, you can also query Opportunity Products with the data loader and leverage the id from there.
Cheers,
Till
