+ Start a Discussion
crmorbitcrmorbit 

excel connector and oppt. line item insert

I am trying to upload oppt. line items via xls connector. I have oppt. ID and product ID. when I try to insert whereby line Item ID is obatined upon insert, I get an error in the LineItemID saying that the Insert Row Failed: Product ID: id value of incorrect type: 01t30000000TfU8AAK (Note the additional three upper case letter in product ID).

Could it be because the API call is against ProductID and not Product2ID? If yes, how can I make the connection?

Udi Merhav

ScotScot
The productId field is left over from an earlier version of salesforce. It's a read-only field and ... as you surmised ... it has the older ProductID values (which start with '00j' rather than '01t').
 
What you need to provide for the opportunity line items is the PricebookEntryId.