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 *

Need More Help?

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


In This Article
Scroll to Top