[SalesForce] Set Product for new opportunity lineitem

in a trigger i'am going to create a new opportunitylineitem for an opportunity:

                 OpportunityLineItem newOpptLineItem = new OpportunityLineItem();
                 newOpptLineItem.OpportunityId = opptInserted.Id;
                 newOpptLineItem.=cs.OppProductCpvId__c; // FOR GIGABYTE
                 newOpptLineItem.Quantity = 1;                   
                 newOpptLineItem.PricebookEntryId = peWEBinteractive.Id;
                 opptLineItemsToInsert.add(newOpptLineItem);

I want to set up a product for this new opportunitylineitem.

newOpptLineItem.ProductId isn't available.

Thanks in advantage for any advice.

Best Answer

OpportunityLineItems lookup to a PriceBookEntry rather than a Product.

PriceBookEntry is a junction object between PriceBook and Product. This is so that you can list the same Product in multiple PriceBooks to cater for various currencies / commercial offering.

I've explained this in a past answer with a diagram.

You will therefore need to set the PriceBookEntryId rather than the ProductId, which I see you are already doing. You therefore should just get rid of this line, and the association to the Product happens via the PriceBookEntry relationship.

Related Solutions

[SalesForce] Exeception on After Insert, Record is read only

The record is locked because you are catching the record after the insert DML statement has happened. So if you'd like to modify this record (or records), you will need to query anew, modify, then execute another DML statement.

Here is an example of how you could modify your trigger to work:

trigger SetProductCategory on OpportunityLineItem (after insert) {

    List<OpportunityLineItem> olis = [SELECT Id, PricebookEntry.Product2.Product_Category_new__c FROM OpportunityLineItem WHERE Id IN: Trigger.newMap.keySet()];

    for (OpportunityLineItem opplineitem: olis){
        opplineitem.Product_Category__c= opplineitem.PricebookEntry.Product2.Product_Category_new__c;
    }

    update olis;

}

And of course, since it's a trigger, we want to be sure to work in batches -- that's why I'm updating a list of olis rather than an individual opp line item.

[SalesForce] Querying Quote and Product Information in Opportunity Trigger

To state the obvious, you'll want to make sure that there is a quote for the opportunity involved. I don't see any reason why your code shouldn't get you a quote, provided your trigger is acting on an opportunity with a quote attached to it.

But really you should be querying for the Quote before you iterate over Trigger.new and collecting quotes into a map. Something like this:

Map<Id,List<Quote>> oppQuoteMap = new Map<Id,List<Quote>>();
for (List<quote> daQuote : [select id, opportunityid, name from quote where opportunityid in Trigger.new){
  if (!oppQuoteMap.keyset().contains(daQuote.opportunityid){
    oppQuoteMap.put(daQuote.id, new List<Quote>());
  }
    oppQuoteMap.get(daQuote.opportunityid).add(daQuote);
}

You can then use oppQuoteMap inside of your for loop to get any quotes related to your opportunity.

Just rememberif you query or call DML inside of a loop in Apex, you are risking governor limit exceptions. Hope you find your problem.

Best Answer

Related Solutions

[SalesForce] Exeception on After Insert, Record is read only

[SalesForce] Querying Quote and Product Information in Opportunity Trigger

Related Topic