$display_output .= sprintf(EASYPOPULATE_4_DISPLAY_RESULT_UPDATE_PRODUCT, $items[(int) $filelayout['v_products_model']]) . $items[(int) $filelayout['v_products_quantity']]; } else { // error Attribute entry not found - needs work! $display_output .= sprintf('<br /><font color="red"><b>SKIPPED! - Product Quantity on Model: </b>%s - Not Found!</font>', $items[(int) $filelayout['v_products_model']]); $ep_error_count++; } // if } } elseif ($items[(int) $filelayout['v_SBA_tracked']] == "X") { $sql = "UPDATE " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " SET \n\t\t\t\t\tquantity\t\t\t\t\t = " . $items[(int) $filelayout['v_products_quantity']] . ($ep_4_SBAEnabled == '2' ? ", customid = '" . $items[(string) $filelayout['v_customid']] . "' " : "") . "\n\t\t\t\t\tWHERE (\n\t\t\t\t\tstock_id = " . $items[$filelayout['v_table_tracker']] . " )"; if ($result = ep_4_query($sql)) { zen_record_admin_activity('Updated products with attributes stock ' . (int) $items[$filelayout['v_table_tracker']] . ' via EP4.', 'info'); $display_output .= sprintf(EASYPOPULATE_4_DISPLAY_RESULT_UPDATE_PRODUCT, $items[(int) $filelayout['v_products_model']]) . $items[(int) $filelayout['v_products_quantity']] . ($ep_4_SBAEnabled == '2' ? " " . $items[(string) $filelayout['v_customid']] : ""); $ep_update_count++; if ($sync) { $stock->update_parent_products_stock((int) $query[$items[(int) $filelayout['v_products_model']]][(int) $filelayout['v_table_tracker']]); // $messageStack->add_session('Parent Product Quantity Updated', 'success'); unset($query[$items[(int) $filelayout['v_products_model']]]); } } else { // error Attribute entry not found - needs work! $display_output .= sprintf('<br /><font color="red"><b>SKIPPED! - SBA Tracked Quantity ' . ($ep_4_SBAEnabled == '2' ? 'and CustomID ' : '') . 'on Model: </b>%s - Not Found!</font>', $items[(int) $filelayout['v_products_model']]); $ep_error_count++; } // if } //end if Standard / SBA stock } // end while if ($sync) { foreach ($query as $items) {