function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Allen ZhangAllen Zhang 

How to add product information when uploading opportunity

hi everyone
I am designing excel template to upload opportunity by connector.
Actually we don't have any account in system, but it is easy to insert new account before uploading opportunity and then use vlookup to combine account ID.
However, I can't find product information when i download an opportunity already created in system with product information.
I know opportunity is a complicated object to use with excel connector, but adding product information by ID should not be so difficult.
I appreciate that if any friend can give me some advice.
You are right in thinking that it is not as straight forward as it would at first seem.

To do this you will need to look at a couple tables

Price Book
OpportunityProduct (aka OpportunityLineItem)  -
              this is what links opportunities to the product lines and is what you see on the opportunity

If you pull all these down you should be able to see the corresponding IDs you need to get things done.