DROP TRIGGER IF EXISTS `ps_product_after_update`//
CREATE TRIGGER `ps_product_after_update` AFTER UPDATE ON `ps_product`
 FOR EACH ROW BEGIN
     IF EXISTS (SELECT * FROM phreebooks.lock_table WHERE lock_trigger1=0)
     THEN
         UPDATE phreebooks.lock_table SET lock_trigger1=1;
         IF ((new.`wholesale_price`<>old.`wholesale_price`) OR
             (new.`price`<>old.`price`))
         THEN
             IF EXISTS(SELECT * FROM `print`.`ps_product_attribute` `ppa` WHERE `ppa`.`id_product`=new.`id_product`)
             THEN
                 UPDATE `print`.`ps_product_attribute` `ppa`
                  SET `ppa`.`wholesale_price`=new.`wholesale_price`
                  WHERE (`ppa`.`id_product`=new.`id_product`) AND
                        (`ppa`.`default_on`=1);

                 SELECT `ppa`.`reference`
                  FROM `print`.`ps_product_attribute` `ppa`
                  WHERE (`ppa`.`id_product`=new.`id_product`) AND
                        (`ppa`.`default_on`=1)
                  INTO @Sel_SKU;

                 UPDATE `phreebooks`.`f_inventory` `fi`
                  SET `fi`.full_price=new.price, `fi`.`item_cost`=new.wholesale_price
                  WHERE `fi`.`sku`=@Sel_SKU;
                 #
                 UPDATE `print`.`ps_product_attribute` `ppa`
                  SET `ppa`.`price`=`ppa`.`price`+old.`price`-new.`price`
                  WHERE (`ppa`.`id_product`=new.`id_product`) AND
                        (`ppa`.`default_on`<>1);
              ELSE
                  UPDATE `phreebooks`.`f_inventory` `fi`
                  SET `fi`.`full_price` = new.`price`, `fi`.`item_cost` = new.`wholesale_price`
                  WHERE (`fi`.`sku` = new.`reference`) AND
                        ((`fi`.`full_price` <> new.`price`) OR
                         (`fi`.`item_cost` <> new.`wholesale_price`));
              END IF;
         END IF;
         UPDATE phreebooks.lock_table SET lock_trigger1=0;
     END IF;
END
//