Народ привет, подскажите почему заказы не выгружаются в 1С?
была ошибка middlename, добавил в бд и файл order это поле, но не летят туда заказы все равно..
2021-06-30 7:49:13 - 4889M SELECT * FROM `oc_setting` WHERE `code` = 'exchange1c-stat' AND `key` = 'stat_offers0_1.xml'
2021-06-30 7:49:13 - 4892M UPDATE `oc_setting` SET `value` = '{"exchange":0.08494806289672852,"xml_load":0.00115203857421875,"date":"2021-06-30T10:49:46","classifier_parse":3.0994415283203125e-5,"offers":0.08216309547424316,"offers_num":78,"parse_price":0.0002639293670654297}' WHERE `setting_id` = 2525
2021-06-30 7:49:13 - 2506C Удалн файл: /home/interstroyka.ru/public_html/system/storage/cache/exchange1c/offers0_1.xml
2021-06-30 7:49:13 - 0042C success
2021-06-30 7:49:13 - 0045C Successfully processed file: /home/interstroyka.ru/public_html/system/storage/cache/exchange1c/offers0_1.xml
2021-06-30 7:49:13 - ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2021-06-30 7:49:13 - 6411M ЭКСПОРТ ЗАКАЗОВ В УЧЕТНУЮ СИТЕМУ
2021-06-30 7:49:13 - 6382M SELECT `order_id`,`order_status_id` FROM `oc_order` WHERE `order_status_id` = 1
2021-06-30 7:49:13 - 6398M queryOrdersExport():
2021-06-30 7:49:13 - 6430M Заказ #1
2021-06-30 7:49:13 - 6431M:
2021-06-30 7:49:13 - Array
(
[order_id] => 1
[track_no] =>
[invoice_no] => 0
[invoice_prefix] => INV-2013-00
[store_id] => 0
[store_name] => Мой Магаин
[store_url] => https://interstroyka.ru/
[customer_id] => 1
[customer] => Дмтрий Сериков
[customer_group_id] => 1
[firstname] => Дмитрий
[lastname] => Сериков
[middlename] => 0
[email] =>
[email protected]
[telephone] => 89381245949
[fax] =>
[custom_field] => Array
(
)
[payment_firstname] => Дмитрий
[payment_lastname] => Сериков
[payment_company] =>
[payment_address_1] => Ворошилова 18
[payment_address_2] =>
[payment_postcode] => 347630
[payment_city] => Сальск
[payment_zone_id] => 2778
[payment_zone] => Ростовская облсть
[payment_zone_code] => ROS
[payment_country_id] => 176
[payment_country] => Российская Федерция
[payment_iso_code_2] => RU
[payment_iso_code_3] => RUS
[payment_address_format] =>
[payment_custom_field] => Array
(
)
[payment_method] => Оплта при получении
[payment_code] => cod
[shipping_firstname] => Дмитрий
[shipping_lastname] => Сериков
[shipping_company] =>
[shipping_address_1] => Ворошилова 18
[shipping_address_2] =>
[shipping_postcode] => 347630
[shipping_city] => Сальск
[shipping_zone_id] => 2778
[shipping_zone] => Роствская область
[shipping_zone_code] => ROS
[shipping_country_id] => 176
[shipping_country] => Российская Федерация
[shipping_iso_code_2] => RU
[shipping_iso_code_3] => RUS
[shipping_address_format] =>
[shipping_custom_field] => Array
(
)
[shipping_method] => Фиксированная стоимост доставки
[shipping_code] => flat.flat
[comment] =>
[total] => 9.0000
[reward] => 0
[order_status_id] => 1
[order_status] => жидание
[affiliate_id] => 0
[affiliate_firstname] =>
[affiliate_lastname] =>
[commission] => 0.0000
[language_id] => 1
[language_code] => ru-ru
[currency_id] => 1
[currency_code] => RUB
[currency_value] => 1.00000000
[ip] => 31.23.30.32
[forwarded_ip] =>
[user_agent] => Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36
[accept_language] => ru-RU,ru;q=0.9,en-US;q=0.8,en;q=0.7
[date_added] => 2021-06-29 12:49:27
[date_modified] => 2021-06-30 08:14:01
)
2021-06-30 7:49:13 - 6208M SELECT `firstname`,`lastname`,`middlename`,`company`,`company_inn`,`company_kpp` FROM `oc_customer` WHERE `customer_id` = '1'
в 1С в журнале пишет
Интерактивный обмен
30.06.2021 10:49:50 Запуск загрузки заказов
Обработано: 0
Загружено: 0
Пропущено: 0
Обновлено: 0
Создано: 0
30.06.2021 10:49:51 Завершена загрузка заказов
Дополнительная информация:
Получение данных с сервера: ответ сервера = 500
Получение данных с сервера: Получен пустой ответ сервера.
Загрузка заказов не выполнена.
error.log
2021-06-30 7:46:30 - 8193M Обовление до верси 1.6.4.2...'
2021-06-30 7:46:30 - 8202M Обновление до версии 1.6.4.3...'
2021-06-30 7:46:30 - 8211M Обноление до версии 1.6.4.4...'
2021-06-30 7:46:30 - 8220M Обновление до ерсии 1.6.4.5...'
2021-06-30 7:46:30 - 8229M Обновлние до версии 1.6.4.6...'
2021-06-30 7:46:30 - 8238M Обновление до весии 1.6.4.7...'
2021-06-30 7:46:30 - 0672M SHOW TABLES FROM `inte_opencart`
2021-06-30 7:46:30 - 0539C 2021-06-30T07:44
2021-06-30 7:46:30 - 8114M SELECT `key`, `value` FROM `oc_setting` WHERE `code` = 'exchange1c-stat'
2021-06-30 7:46:30 - 0317M SELECT count(*) as num FROM `oc_product_to_1c`
2021-06-30 7:46:30 - 0319M SELECT count(*) as num FROM `oc_category_to_1c`
2021-06-30 7:46:30 - 0321M SELECT count(*) as num FROM `oc_manufacturer_to_1c`
2021-06-30 7:46:30 - 0323M SELECT count(*) as num FROM `oc_attribute_to_1c`
2021-06-30 7:46:54 - 8135M Поиск в баз данных дополнитльных полей
2021-06-30 7:46:54 - 8156M SHOW TABLES LIKE 'oc_manufacturer'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_manufacturer` WHERE `field` = 'noindex'
2021-06-30 7:46:54 - 8156M SHOW TABLES LIKE 'oc_product_to_category'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_product_to_category` WHERE `field` = 'main_category'
2021-06-30 7:46:54 - 8156M SHOW TABLES LIKE 'oc_product_description'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_product_description` WHERE `field` = 'meta_h1'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_product_description` WHERE `field` = 'meta_title'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_product_description` WHERE `field` = 'meta_description'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_product_description` WHERE `field` = 'meta_keyword'
2021-06-30 7:46:54 - 8156M SHOW TABLES LIKE 'oc_category_description'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_category_description` WHERE `field` = 'meta_h1'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_category_description` WHERE `field` = 'meta_title'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_category_description` WHERE `field` = 'meta_description'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_category_description` WHERE `field` = 'meta_keyword'
2021-06-30 7:46:54 - 8156M SHOW TABLES LIKE 'oc_manufacturer_description'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_manufacturer_description` WHERE `field` = 'name'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_manufacturer_description` WHERE `field` = 'meta_h1'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_manufacturer_description` WHERE `field` = 'meta_title'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_manufacturer_description` WHERE `field` = 'meta_description'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_manufacturer_description` WHERE `field` = 'meta_keyword'
2021-06-30 7:46:54 - 8156M SHOW TABLES LIKE 'oc_manufacturer_to_layout'
2021-06-30 7:46:54 - 8156M SHOW TABLES LIKE 'oc_product'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_product` WHERE `field` = 'noindex'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_product` WHERE `field` = 'unit_id'
2021-06-30 7:46:54 - 8156M SHOW TABLES LIKE 'oc_order'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_order` WHERE `field` = 'middlename'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_order` WHERE `field` = 'shipping_middlename'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_order` WHERE `field` = 'payment_middlename'
2021-06-30 7:46:54 - 8156M SHOW TABLES LIKE 'oc_order_product'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_order_product` WHERE `field` = 'product_feature_id'
2021-06-30 7:46:54 - 8156M SHOW TABLES LIKE 'oc_customer'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_customer` WHERE `field` = 'middlename'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_customer` WHERE `field` = 'company_inn'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_customer` WHERE `field` = 'company_kpp'
2021-06-30 7:46:54 - 8156M SHOW TABLES LIKE 'oc_cart'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_cart` WHERE `field` = 'product_feature_id'
2021-06-30 7:46:54 - 8156M SHOW TABLES LIKE 'oc_attributes_value'
2021-06-30 7:46:54 - 8156M SHOW TABLES LIKE 'oc_attributes_value_to_1c'
2021-06-30 7:46:54 - 8156M SHOW TABLES LIKE 'oc_url_alias'
2021-06-30 7:46:54 - 8163M SHOW COLUMNS FROM `oc_url_alias` WHERE `field` = 'seomanager'
2021-06-30 7:46:54 - 0356C Настройки сохранн
2021-06-30 7:46:54 - 0672M SHOW TABLES FROM `inte_opencart`
2021-06-30 7:46:54 - 0535C 2021-06-30T07:44
2021-06-30 7:46:54 - 8114M SELECT `key`, `value` FROM `oc_setting` WHERE `code` = 'exchange1c-stat'
2021-06-30 7:46:54 - 0317M SELECT count(*) as num FROM `oc_product_to_1c`
2021-06-30 7:46:54 - 0319M SELECT count(*) as num FROM `oc_category_to_1c`
2021-06-30 7:46:54 - 0321M SELECT count(*) as num FROM `oc_manufacturer_to_1c`
2021-06-30 7:46:54 - 0323M SELECT count(*) as num FROM `oc_attribute_to_1c`
2021-06-30 7:47:56 - 8135M Поик в базе данных дполнительных полей
2021-06-30 7:47:56 - 8156M SHOW TABLES LIKE 'oc_manufacturer'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_manufacturer` WHERE `field` = 'noindex'
2021-06-30 7:47:56 - 8156M SHOW TABLES LIKE 'oc_product_to_category'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_product_to_category` WHERE `field` = 'main_category'
2021-06-30 7:47:56 - 8156M SHOW TABLES LIKE 'oc_product_description'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_product_description` WHERE `field` = 'meta_h1'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_product_description` WHERE `field` = 'meta_title'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_product_description` WHERE `field` = 'meta_description'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_product_description` WHERE `field` = 'meta_keyword'
2021-06-30 7:47:56 - 8156M SHOW TABLES LIKE 'oc_category_description'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_category_description` WHERE `field` = 'meta_h1'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_category_description` WHERE `field` = 'meta_title'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_category_description` WHERE `field` = 'meta_description'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_category_description` WHERE `field` = 'meta_keyword'
2021-06-30 7:47:56 - 8156M SHOW TABLES LIKE 'oc_manufacturer_description'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_manufacturer_description` WHERE `field` = 'name'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_manufacturer_description` WHERE `field` = 'meta_h1'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_manufacturer_description` WHERE `field` = 'meta_title'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_manufacturer_description` WHERE `field` = 'meta_description'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_manufacturer_description` WHERE `field` = 'meta_keyword'
2021-06-30 7:47:56 - 8156M SHOW TABLES LIKE 'oc_manufacturer_to_layout'
2021-06-30 7:47:56 - 8156M SHOW TABLES LIKE 'oc_product'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_product` WHERE `field` = 'noindex'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_product` WHERE `field` = 'unit_id'
2021-06-30 7:47:56 - 8156M SHOW TABLES LIKE 'oc_order'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_order` WHERE `field` = 'middlename'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_order` WHERE `field` = 'shipping_middlename'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_order` WHERE `field` = 'payment_middlename'
2021-06-30 7:47:56 - 8156M SHOW TABLES LIKE 'oc_order_product'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_order_product` WHERE `field` = 'product_feature_id'
2021-06-30 7:47:56 - 8156M SHOW TABLES LIKE 'oc_customer'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_customer` WHERE `field` = 'middlename'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_customer` WHERE `field` = 'company_inn'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_customer` WHERE `field` = 'company_kpp'
2021-06-30 7:47:56 - 8156M SHOW TABLES LIKE 'oc_cart'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_cart` WHERE `field` = 'product_feature_id'
2021-06-30 7:47:56 - 8156M SHOW TABLES LIKE 'oc_attributes_value'
2021-06-30 7:47:56 - 8156M SHOW TABLES LIKE 'oc_attributes_value_to_1c'
2021-06-30 7:47:56 - 8156M SHOW TABLES LIKE 'oc_url_alias'
2021-06-30 7:47:56 - 8163M SHOW COLUMNS FROM `oc_url_alias` WHERE `field` = 'seomanager'
2021-06-30 7:47:56 - 0356C Настройки охранны
2021-06-30 7:47:56 - 0672M SHOW TABLES FROM `inte_opencart`
2021-06-30 7:47:56 - 0535C 2021-06-30T07:44
2021-06-30 7:47:56 - 8114M SELECT `key`, `value` FROM `oc_setting` WHERE `code` = 'exchange1c-stat'
2021-06-30 7:47:56 - 0317M SELECT count(*) as num FROM `oc_product_to_1c`
2021-06-30 7:47:56 - 0319M SELECT count(*) as num FROM `oc_category_to_1c`
2021-06-30 7:47:56 - 0321M SELECT count(*) as num FROM `oc_manufacturer_to_1c`
2021-06-30 7:47:56 - 0323M SELECT count(*) as num FROM `oc_attribute_to_1c`