chelbeh
9/23/2016 - 11:02 AM

change price for Montale 20мл

change price for Montale 20мл

UPDATE `shop_product_skus` SET `price` = '2800', `primary_price` = '2800' WHERE name LIKE '%20%мл%' AND product_id IN (SELECT id FROM shop_product WHERE category_id IN (295, 299))



//UPDATE `shop_product_skus` SET `primary_price` = '200' WHERE name LIKE '%2 мл%' AND product_id IN (SELECT id FROM shop_product WHERE category_id IN (295, 299))