Hi everyone, I have a trigger that should fire but it doesn't seem to work. Basically, if the Opportunity Product being added is an inverter, the trigger should check to see if there is a panel in the Opportunity Products and then set the quanitity of the inverter being added to a number based on the quantity of the panel.

The trigger worked for me when I hardcoded the Product2Id's but I want to avoid doing that. When I changed the Product2Id to Product2.Name the trigger stopped working.

Here is my code, any help is greatly appreciated!

trigger setInverterQuantity on OpportunityLineItem (before insert) {
    for (OpportunityLineItem oli : Trigger.new) {
        if (oli.Product2.Name == 'APSystems QS1' || oli.Product2.Name == 'Y6COO') { // inverter 1 or inverter 2
            // get quantity of panels
            List<OpportunityLineItem> panels = [
                SELECT Id, Quantity, Product2.Name
                  FROM OpportunityLineItem
                 WHERE OpportunityId = :oli.OpportunityId
                   AND (Product2.Name = 'Heliene 60M-BLK 310W'
                    OR Product2.Name = 'Heliene 60M-HBLK 300W') // panel 1 or panel 2
                 LIMIT 1
            ];

            if (!panels.isEmpty()) {
                // set inverter quantity formulas
                Decimal inverterQuantityOne = (panels.get(0).Quantity / 4);
                Decimal inverterQuantityTwo = (panels.get(0).Quantity / 2);
                inverterQuantityOne = inverterQuantityOne.round(System.RoundingMode.CEILING);
                inverterQuantityTwo = inverterQuantityTwo.round(System.RoundingMode.CEILING);

                // set quantity of inverter
                if (oli.Product2.Name == 'APSystems QS1') { // inverter 1
                    oli.Quantity = inverterQuantityOne;
                } else if (oli.Product2.Name == 'Y6COO') { // inverter 2
                    oli.Quantity = inverterQuantityTwo;
                }
            }
        }
    }
}