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.