Ошибка импорта

[krasenkov]

Здравствуйте, подскажите не получается проимпортировать дату обновления из магазина в PLI
вылазит ошибка, см. скриншот.

Подскажите как бороться?

[support]

Каким образом Вы пытаетесь это сделать?

[krasenkov]

Немного подправил код, ошибка ушла, но дата обновления упорно передается не правильно, она равна дате импорта в PLI. Таким образом не получится фильтровать старые товары для удаления.

SELECT 'g' as op_type, categories.categories_id, categories.parent_id, categories_description.categories_name,
categories_description.categories_description, categories.sort_order,
categories_description.categories_meta_title, categories_description.categories_meta_description, categories_description.categories_meta_keywords,
categories.categories_image
FROM categories INNER JOIN categories_description ON categories.categories_id=categories_description.categories_id
WHERE categories_description.language_id=1 order by categories.categories_id;;;

SELECT 'p' as op_type, products.products_id, products_to_categories.categories_id, products.products_model, products_description.title_products_name3,
products.products_price, 0 as supply_id, products.manufacturers_id,
products_description.products_head_title_tag, products_description.products_head_desc_tag, products_description.products_head_keywords_tag,
'0' as product_flag, products_description.products_description, products.products_quantity,
0 as cc_link,
'' as manufacturers_name,
'' as model,
products_description.products_name,
products.products_image,
'' as pic2,
'1' as order_set,
products.products_newstatus,
'' as addon_price,
'1' as products_to_xml,
products_description.products_url,
products.products_status,
'' as uid,
'' as masa,
'' as garant,
'' as vn_art,
'' as kibk,
'' as cuid,
'' as flag1,
'' as flag2,
'' as flag3,
'' as flag4,
'' as artpost,
'' as gabrozm,
products_description.title_products_name2,
'',
'',
'',
'',
''
FROM products_description
INNER JOIN products_to_categories on products_description.products_id=products_to_categories.products_id
INNER JOIN products on products_description.products_id=products.products_id WHERE products_description.language_id=1 order by products.products_id;;;

SELECT 'm' as op_type, a.manufacturers_id, a.manufacturers_name, a.manufacturers_image, b.title, b.description, b.keywords, c.manufacturers_url FROM manufacturers as a,
meta_tags as b, manufacturers_info as c WHERE a.manufacturers_id=b.manufacturers_id and c.languages_id=1 order by a.manufacturers_id;;;