Assign new products to all the available pricebook using trigger

Question

i have a requirement that, if i insert new product then the newly created product must associate to all the pricebooks(including std and custom) but i get and error as illegal assignment from list to string i have tried the below code.

String pricebkId= [SELECT id,isStandard from Pricebook2];
List<PricebookEntry> pbeList = new List<PricebookEntry>();
for(Product2 p:  Trigger.New){
    pbeList.add(new PricebookEntry(
                    UnitPrice = 10, 
                    Pricebook2Id = pricebkId, 
                    product2Id = p.Id,
                    isActive = true));
}

insert pbeList;

Thanks

Answer 1

Your query is returning a list of Price Books, not just a single one. So that's why you're getting that error. You'll also need to compensate for that by adding another loop below, so you'll need something like the below:

// Standard Price book must be first
List<PriceBook2> priceBooks = [SELECT Id FROM Pricebook2 ORDER BY IsStandard DESC]; 
List<PricebookEntry> pbeList = new List<PricebookEntry>();
for(Product2 p:  Trigger.New){
    for (PriceBook2 priceBook : priceBooks) {
        pbeList.add(new PricebookEntry(
                        UnitPrice = 10, 
                        Pricebook2Id = priceBook.Id, 
                        product2Id = p.Id,
                        isActive = true));
    }
}

insert pbeList;