magento批量改价命令
UPDATE catalog_product_entity_decimal set value=value-0.3 where attribute_id=68
update catalog_product_index_price set price=price , final_price=final_price-0.3 , min_price=min_price-0.3 , max_price=max_price-0.3
UPDATE catalog_product_index_price_idx SET price=price , final_price=final_price-0.3 , min_price=min_price-0.3 , max_price=max_price-0.3
全站减0.3元
UPDATE catalog_product_entity_decimal set value=value-20 where attribute_id=68 and value between 100 and 200
update catalog_product_index_price set price=price , final_price=final_price-20 , min_price=min_price-20 , max_price=max_price-20 where final_price between 100 and 200
UPDATE catalog_product_index_price_idx SET price=price , final_price=final_price-20 , min_price=min_price-20 , max_price=max_price-20 where final_price between 100 and 200
现价是100-200 的减20 |
(责任编辑:最模板) |