How can I import multiple products when importing opportunities

To import multiple products you’ll need to combine all of the products for each opportunity into a single cell and then use the [][] delimiter.  You’ll also need an equal number of values for the price and quantity.

If the product doesn’t have a quantity then use 0 and delimiters.

For example:

Product1[][]Product2[][]Product3 – Notice that the Product comes first, then the delimiter.

The corresponding Amount/Price cell would look like this – Price1[][]Price2[][]Price3

If there is no price then you’d use Zeros and the cell would look like this – 0[][]0[][]0

If the import file contains Opportunities with multiple and only one product you’ll need to use the [][] delimiter on the end of the single product’s name, price and quantity.

For Example:

Product Cell – ProductName[][]

Price: ProductPrice[]

Quantity Cell: ProductPrice[][]

Was this article helpful?
How can we improve this article?

Leave a Reply

Your email address will not be published. Required fields are marked *

Share This

Share on facebook
Share on twitter
Share on linkedin
Share on skype
Share on email
Share on print

Need More Help?

Can't find what you're looking for?
Email Us


In This Article
Scroll to Top