Onlinelastmodified not being triggered by specific status change

[shipworks_support]

Hello,
We've got a customer using Zencart with third party software ShipWorks to download orders by onlinelastmodified. They've encountered an issue where an order that is changed from Pending to Processing by Paypal eCheck, but doesn't seem to be triggering the onlinelastmodified. So ShipWorks is not getting the status change just for these orders in this specific status.
I'd like to see if this is a known issue or if it can be investigated.

Thanks in advance!
Tammy
ShipWorks Support

[DrByte]

I'm not aware of any database field named "onlinelastmodified".
But if you're referring to the "last_modified" field in the "orders" table, you might be able to fix that issue by adding this change:

/includes/modules/payment/paypal/paypal_functions.php
around line 640:

  function ipn_update_orders_status_and_history($ordersID, $new_status = 1, $txn_type) {
    global $db;
    ipn_debug_email('IPN NOTICE :: Updating order #' . (int)$ordersID . ' to status: ' . (int)$new_status . ' (txn_type: ' . $txn_type . ')');
    $db->Execute("update " . TABLE_ORDERS  . "
                  set orders_status = '" . (int)$new_status . "', last_modified = now()
                  where orders_id = '" . (int)$ordersID . "'");