-UPDATE QUANTITY:

DELIMITER //

CREATE TRIGGER sync_product_quantity
AFTER UPDATE ON ProductSAP
FOR EACH ROW
BEGIN
    IF NEW.OnHand != OLD.OnHand THEN
        UPDATE Product
        SET quantity = NEW.OnHand
        WHERE itemCode = NEW.ItemCode;
    END IF;
END;
//

DELIMITER ;


________________________________________




-INSERT ITEM:

CREATE TRIGGER insert_items_trigger
AFTER INSERT ON itemsap 
FOR EACH ROW
BEGIN 
    INSERT INTO items (name, itemCode, codeBars, price, quantity)
    SELECT NEW.ItemName, NEW.ItemCode, NEW.CodeBars, NEW.Price, NEW.OnHand
    WHERE NOT EXISTS (
        SELECT 1 FROM items WHERE itemCode = NEW.ItemCode
    );
END;