Fórum OpenCart Brasil

update pro
set pro.quantity = est.quantity
from ga_product pro
join (select product_id
   ,sum (quantity) as estoquet 
from ga_product_option_value
group by product_id) est
on est.product_id = pro.product_id

UPDATE ga_product p 
SET p.quantity = ( SELECT SUM( quantity ) AS estoque
                  FROM ga_product_option_value o
                  WHERE o.product_id = p.product_id
                  GROUP BY product_id ),
p.price = o.price
WHERE p.product_id = product_id