Импорт:
Экспорт:
Заменить артикул производителя на ID товара:
Вкладка До обновления.
Код: Выделить всё
UPDATE etrade_products SET tov_art=tov_id
Код: Выделить всё
UPDATE etrade_products SET tov_art=tov_id
Код: Выделить всё
UPDATE jos_virtuemart_customs, jos_virtuemart_product_customfields, etrade_products SET jos_virtuemart_product_customfields.custom_value=etrade_products.tov_size WHERE jos_virtuemart_customs.custom_title='Размер' AND jos_virtuemart_product_customfields.virtuemart_custom_id=jos_virtuemart_customs.virtuemart_custom_id AND etrade_products.tov_id=jos_virtuemart_product_customfields.virtuemart_product_id;;;
INSERT INTO jos_virtuemart_product_customfields (virtuemart_product_id, virtuemart_custom_id, custom_value) SELECT etrade_products.tov_id, (SELECT virtuemart_custom_id FROM jos_virtuemart_customs WHERE custom_title='Размер' GROUP BY virtuemart_custom_id) as virtuemart_custom_id, etrade_products.tov_size FROM etrade_products WHERE etrade_products.tov_id NOT IN (SELECT virtuemart_product_id FROM jos_virtuemart_product_customfields WHERE virtuemart_custom_id=(SELECT virtuemart_custom_id FROM jos_virtuemart_customs WHERE custom_title='Размер' GROUP BY virtuemart_custom_id));;;