Выгрузка производителей в opencart/ocstore
Добавлено: 03 дек 2016 13:15
Подскажите, как правильно настроить PLI для выгрузки производителей в opencart/ocstore.
Код: Выделить всё
INSERT INTO oc_manufacturer_description (manufacturer_id, language_id, name)
SELECT manufacturer_id, 1 as language_id, name
FROM oc_manufacturer
WHERE manufacturer_id NOT IN (SELECT manufacturer_id FROM oc_manufacturer_description WHERE language_id=1);;;
TechAdmin писал(а):Возможно этот SQL запрос поможетКод: Выделить всё
INSERT INTO oc_manufacturer_description (manufacturer_id, language_id, name)
SELECT manufacturer_id, 1 as language_id, name
FROM oc_manufacturer
WHERE manufacturer_id NOT IN (SELECT manufacturer_id FROM oc_manufacturer_description WHERE language_id=1);;;
Вставить его в вкладку - После осн. обновления.
Код: Выделить всё
INSERT INTO oc_manufacturer_to_layout (manufacturer_id, store_id, layout_id)
SELECT manufacturer_id, 0 as store_id, 0 as layout_id FROM oc_manufacturer
WHERE manufacturer_id NOT IN (SELECT manufacturer_id FROM oc_manufacturer_to_layout);;;
Код: Выделить всё
INSERT INTO oc_manufacturer_description (manufacturer_id, language_id, meta_title)
SELECT manufacturer_id, 1 as language_id, name FROM oc_manufacturer
WHERE manufacturer_id NOT IN (SELECT manufacturer_id FROM oc_manufacturer_description WHERE language_id=1);;;