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

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

UPDATE etrade_products SET tov_art=tov_id

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

UPDATE cscart_products, etrade_products SET cscart_products.company_id=etrade_products.supply_id WHERE etrade_products.tov_id=cscart_products.product_id;;;

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

SET SESSION sql_mode='';;;
SET SQL_BIG_SELECTS=1;;;
TRUNCATE TABLE cscart_products_categories;;;
UPDATE etrade_cats SET row_exist=1 WHERE cat_id IN (SELECT category_id FROM cscart_categories);;;
INSERT INTO cscart_categories (product_details_layout, status, category_id, parent_id, position) SELECT 'default' as product_details_layout, IF(cat_active=1,'A','N'), cat_id, parent_id, sort_order FROM etrade_cats WHERE etrade_cats.row_exist=0;;;
INSERT INTO cscart_category_descriptions (category_id, lang_code, category, description) SELECT cat_id, 'RU' as lang_code, cat_name, cat_desc FROM etrade_cats WHERE etrade_cats.row_exist=0;;;
UPDATE cscart_categories, etrade_cats SET cscart_categories.status = IF(cat_active=1,'A','N'), cscart_categories.parent_id = etrade_cats.parent_id, cscart_categories.position = etrade_cats.sort_order WHERE etrade_cats.row_exist=1 AND etrade_cats.cat_id=cscart_categories.category_id;;;
UPDATE cscart_category_descriptions, etrade_cats SET cscart_category_descriptions.category = etrade_cats.cat_name WHERE etrade_cats.row_exist=1 AND etrade_cats.cat_id=cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code='RU';;;
UPDATE cscart_products, etrade_products SET cscart_products.status = IF(tov_active=1,'A','N'), cscart_products.amount = etrade_products.tov_quantity, cscart_products.list_price = etrade_products.tov_price WHERE etrade_products.tov_art2=cscart_products.product_id;;;
UPDATE cscart_product_descriptions, etrade_products SET cscart_product_descriptions.product = etrade_products.tov_name WHERE etrade_products.tov_art2=cscart_product_descriptions.product_id AND cscart_product_descriptions.lang_code='RU';;;
DELETE FROM cscart_product_prices WHERE cscart_product_prices.product_id IN (SELECT tov_art2 FROM etrade_products GROUP BY etrade_products.tov_art2);;;
INSERT INTO cscart_product_prices (lower_limit, product_id, price) SELECT '1' as lower_limit, tov_art2, MIN(tov_price) as min_price FROM etrade_products WHERE etrade_products.tov_art2 NOT IN (SELECT product_id FROM cscart_product_prices) GROUP BY etrade_products.tov_art2 ORDER BY min_price;;;
INSERT INTO cscart_product_descriptions (product_id, lang_code, product) SELECT tov_art2, 'RU' as lang_code, tov_name FROM etrade_products WHERE etrade_products.tov_art2 NOT IN (SELECT product_id FROM cscart_products) GROUP BY etrade_products.tov_art2;;;
INSERT INTO cscart_products (details_layout, feature_comparison, tracking, status, product_code, product_id, amount, list_price) SELECT 'default' as details_layout, 'Y' as feature_comparison, 'D' as tracking, IF(tov_active=1,'A','N'), tov_id, tov_art2, tov_quantity, tov_price FROM etrade_products WHERE etrade_products.tov_art2 NOT IN (SELECT product_id FROM cscart_products) GROUP BY etrade_products.tov_art2;;;
DELETE FROM cscart_products_categories WHERE product_id IN (SELECT tov_art2 FROM etrade_products GROUP BY etrade_products.tov_art2);;;
INSERT INTO cscart_products_categories (product_id, category_id) SELECT etrade_products.tov_art2, etrade_products_cats.tov_cat_id FROM etrade_products_cats LEFT JOIN etrade_products ON etrade_products_cats.tov_id=etrade_products.tov_id GROUP BY etrade_products_cats.tov_cat_id, etrade_products.tov_art2;;;
UPDATE etrade_cats SET punkt=REPLACE(punkt, '/0/', '');;;
UPDATE cscart_categories, etrade_cats SET id_path=etrade_cats.punkt WHERE etrade_cats.cat_id=category_id;;;
TRUNCATE cscart_product_options;;;
TRUNCATE cscart_product_options_descriptions;;;
TRUNCATE cscart_product_option_variants;;;
TRUNCATE cscart_product_option_variants_descriptions;;;
INSERT INTO cscart_product_options (option_id, product_id) SELECT tov_id, tov_art2 FROM etrade_products WHERE tov_size<>'' AND nalich_c='Есть' GROUP BY tov_art2;;;
INSERT INTO cscart_product_options_descriptions (option_id, lang_code, option_name) SELECT option_id, 'RU' as lang_code, 'Размер' as option_name FROM cscart_product_options;;;
INSERT INTO cscart_product_option_variants (variant_id, option_id, modifier) SELECT etrade_products.tov_id, cscart_product_options.option_id, etrade_products.tov_price FROM etrade_products LEFT JOIN cscart_product_options ON cscart_product_options.product_id=etrade_products.tov_art2 WHERE tov_size<>'' AND nalich_c='Есть';;;
INSERT INTO cscart_product_option_variants_descriptions (variant_id, lang_code, variant_name) SELECT tov_id, 'RU' as lang_code, tov_size FROM etrade_products WHERE tov_size<>'' AND nalich_c='Есть' ORDER BY tov_id, tov_size;;;
UPDATE cscart_product_option_variants, cscart_product_options, cscart_product_prices SET cscart_product_option_variants.modifier=cscart_product_option_variants.modifier-cscart_product_prices.price WHERE cscart_product_option_variants.option_id=cscart_product_options.option_id AND cscart_product_options.product_id=cscart_product_prices.product_id AND cscart_product_option_variants.modifier<>cscart_product_prices.price;;;
UPDATE cscart_product_option_variants, cscart_product_options, cscart_product_prices SET cscart_product_option_variants.modifier=0 WHERE cscart_product_option_variants.option_id=cscart_product_options.option_id AND cscart_product_options.product_id=cscart_product_prices.product_id AND cscart_product_option_variants.modifier=cscart_product_prices.price;;;
INSERT INTO cscart_seo_names (name, object_id, type, lang_code) SELECT tov_seo_url, tov_art2, 'p' as type, 'RU' as lang_code FROM etrade_products WHERE tov_art2 NOT IN (SELECT object_id FROM cscart_seo_names WHERE type='p' AND lang_code='RU') GROUP BY etrade_products.tov_art2;;;
INSERT INTO cscart_seo_names (name, object_id, type, lang_code) SELECT cat_seo_url, cat_id, 'c' as type, 'RU' as lang_code FROM etrade_cats WHERE cat_id NOT IN (SELECT object_id FROM cscart_seo_names WHERE type='c' AND lang_code='RU');;;
DROP TABLE IF EXISTS etrade_cats;;;
DROP TABLE IF EXISTS etrade_products;;;
DROP TABLE IF EXISTS etrade_products_cats;;;
DROP TABLE IF EXISTS etrade_mans;;;

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

UPDATE cscart_products_categories, etrade_products SET link_type='A' WHERE etrade_products.tov_id=cscart_products_categories.product_id AND etrade_products.tov_cat_id<>cscart_products_categories.category_id;;;