Mangeto批量修改价格：把price的值赋值给special price

#把price的值赋值给special price
#产品id为888
#attribute_id=76的时候value字段表示的是special price价格
#attribute_id=75的是value字段表示的是price价格

UPDATE catalog_product_entity_decimal as t1
INNER JOIN (SELECT entity_id,value FROM catalog_product_entity_decimal where attribute_id=75) as t2
SET t1.value=t2.value WHERE t1.entity_id=t2.entity_id and t1.attribute_id=76 and t1.entity_id=888;

#不指定产品id，批量修改
UPDATE catalog_product_entity_decimal as t1
INNER JOIN (SELECT entity_id,value FROM catalog_product_entity_decimal where attribute_id=75) as t2
SET t1.value=t2.value WHERE t1.entity_id=t2.entity_id and t1.attribute_id=76;

#把虚高价格(price价格)上调20%
#attribute_id=75的时候value字段的值表示price价格
update catalog_product_entity_decimal set value=value*1.2 where attribute_id=75;