I made a new template to import Order Status. I set the template to ignore new items, as I didn't want it to create new orders from the XML file I was importing, only update existing ones. However, it added about 400 orders.
2024-03-25 22:35:04 2 [DEBUG] Use field value for field root/OrderStates/OrderNo
2024-03-25 22:35:04 2 [DEBUG] Use field value for field root/OrderStates/State
2024-03-25 22:35:04 2 [DEBUG] Process line 2
2024-03-25 22:35:04 2 [DEBUG] COM_CSVI_DEBUG_LOAD_ORDER_ID
2024-03-25 22:35:04 2 [QUERY] SELECT `virtuemart_order_id` FROM `_virtuemart_orders` WHERE `order_number` = '2038982'
2024-03-25 22:35:04 2 [DEBUG] COM_CSVI_DEBUG_NOT_CREATE_ORDER_NUMBER
2024-03-25 22:35:04 2 [QUERY] INSERT INTO `_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (4328,2,'Item 2038982 not added because ignore non-existing items enabled','Notice','Skipped','Orders')
2024-03-25 22:35:04 2 [DEBUG] COM_CSVI_DEBUG_CREATE_ORDER_PASS
2024-03-25 22:35:04 2 [QUERY] INSERT INTO `_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (4328,2,'Item 2038982 not added because ignore non-existing items enabled','Notice','Skipped','Orders')
2024-03-25 22:35:04 2 [DEBUG] Query for Order
2024-03-25 22:35:04 2 [DEBUG] Executed store
2024-03-25 22:35:04 2 [QUERY] INSERT INTO `_virtuemart_orders` (`virtuemart_user_id`,`virtuemart_vendor_id`,`order_number`,`order_pass`,`invoice_locked`,`order_total`,`order_salesPrice`,`order_billTaxAmount`,`order_billDiscountAmount`,`order_discountAmount`,`order_shipment`,`order_shipment_tax`,`order_payment`,`order_payment_tax`,`coupon_discount`,`coupon_code`,`order_discount`,`user_currency_rate`,`payment_currency_rate`,`virtuemart_paymentmethod_id`,`delivery_date`,`order_language`,`ip_address`,`STsameAsBT`,`paid`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_by`) VALUES ('0','1','2038982','p_9c3fce','0','0.00000','0.00000','0.00000','0.00000','0.00000','0','0','0','0','0.00','','0.00','1','1.000000','0','','de-DE','5.79.78.230','0','0.00000','2024-03-25 22:35:04','42','2024-03-25 22:35:04','42','0')
2024-03-25 22:35:04 2 [DEBUG] Load the order info
2024-03-25 22:35:04 2 [QUERY] SELECT `virtuemart_order_userinfo_id` FROM `_virtuemart_order_userinfos` WHERE `address_type` = 'BT' AND `virtuemart_order_id` = 3
2024-03-25 22:35:04 2 [DEBUG] COM_CSVI_DEBUG_LOAD_USER_ORDER_INFO
2024-03-25 22:35:04 2 [QUERY] SELECT `virtuemart_order_userinfo_id` FROM `_virtuemart_order_userinfos` WHERE `address_type` = 'BT' AND `virtuemart_order_id` = 3
2024-03-25 22:35:04 2 [DEBUG] Query for Orderuserinfo
2024-03-25 22:35:04 2 [DEBUG] Executed store
2024-03-25 22:35:04 2 [QUERY] INSERT INTO `_virtuemart_order_userinfos` (`virtuemart_order_id`,`virtuemart_user_id`,`address_type`,`address_1`,`city`,`virtuemart_state_id`,`virtuemart_country_id`,`zip`,`agreed`,`tos`,`customer_note`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('3','0','BT','','','0','0','','0','0','','2024-03-25 22:35:04','42','2024-03-25 22:35:04','42')
2024-03-25 22:35:04 2 [DEBUG] Query for Orderhistory
2024-03-25 22:35:04 2 [DEBUG] Executed store
2024-03-25 22:35:04 2 [QUERY] INSERT INTO `_virtuemart_order_histories` (`virtuemart_order_id`,`order_status_code`,`customer_notified`,`comments`,`paid`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('3','C','0','','0.00000','2024-03-25 22:35:04','42','2024-03-25 22:35:04','42')
Item 2038982 not added because ignore non-existing items enabled and yet it continues to add the values INSERT INTO `_virtuemart_orders`
Weird?
