Обсуждение и советы: создание интернет-магазинов - решения, процессы, прайсинг

Код: Выделить всё

UPDATE product_special, etrade_products SET product_special.price=etrade_products.recom_price WHERE product_special.product_id=etrade_products.tov_id;;;
INSERT INTO product_special (product_special_id, product_id, customer_group_id, priority, price, date_start, date_end) SELECT tov_id, tov_id, '1' as customer_group_id,'1' as priority, recom_price, now() as date_start, '2013-02-28' as date_end FROM etrade_products WHERE recom_price>0 AND tov_id NOT IN (SELECT product_id FROM product_special GROUP BY product_id);;;

Код: Выделить всё

UPDATE product, etrade_products SET product.price = SUBSTRING_INDEX(etrade_products.addon_prices_list,';',1) WHERE etrade_products.tov_id = product.product_id;;;

Код: Выделить всё

UPDATE product, etrade_products SET product.price = SUBSTRING_INDEX( SUBSTRING_INDEX(etrade_products.addon_prices_list, ';', -2 ) , ';', -1) WHERE etrade_products.tov_id = product.product_id;;;

Код: Выделить всё

UPDATE oc_product_description, etrade_products SET oc_product_description.seo_h1=etrade_products.tov_name WHERE oc_product_description.product_id=etrade_products.tov_id;;;