[2026-06-10 20:37:45] --- NEW REQUEST RECEIVED --- [2026-06-10 20:37:45] Product not found in MRA. Creating custom for: CUSTOM [2026-06-10 20:37:45] SUCCESS: Transaction committed. [2026-06-10 20:40:50] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-10 20:40:50] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-10') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-10 20:40:50] Successfully compiled 1 matching stock entries. [2026-06-10 20:40:50] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 1 movement records. [2026-06-10 20:40:50] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-10 20:41:33] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-10 20:41:33] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-10') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-10 20:41:33] Successfully compiled 1 matching stock entries. [2026-06-10 20:41:33] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 1 movement records. [2026-06-10 20:41:33] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-10 20:42:13] ERROR: Branch '27' not found. [2026-06-10 20:44:22] --- NEW REQUEST RECEIVED --- [2026-06-10 20:44:22] Closing Session Raw Stream Capture: org_id=41&warehouse_stock_id=41&branch_name=27&transfer_qty=50&selling_price=1200&min_alert=5 [2026-06-10 20:53:56] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-10 20:54:22] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-10 20:54:27] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-10 21:12:30] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-10 21:13:09] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-10 21:14:30] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-10 21:15:21] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-10 21:16:03] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-10 21:16:18] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-10 21:18:12] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-10 21:19:32] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-10 21:19:32] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-10') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-10 21:19:32] Successfully compiled 1 matching stock entries. [2026-06-10 21:19:32] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-10 21:19:32] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-10 21:26:11] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-10 21:26:11] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-10') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-10 21:26:11] Successfully compiled 1 matching stock entries. [2026-06-10 21:26:11] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-10 21:26:11] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-10 21:36:19] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-10 21:36:19] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-10') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-10 21:36:19] Successfully compiled 1 matching stock entries. [2026-06-10 21:36:19] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-10 21:36:19] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-10 21:42:25] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-10 21:42:25] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-10') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-10 21:42:25] Successfully compiled 1 matching stock entries. [2026-06-10 21:42:25] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-10 21:42:25] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-10 21:42:31] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-10 21:42:31] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-10') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-10 21:42:31] Successfully compiled 1 matching stock entries. [2026-06-10 21:42:31] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-10 21:42:31] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-10 23:02:50] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-10 23:02:50] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-10') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-10 23:02:50] Successfully compiled 1 matching stock entries. [2026-06-10 23:02:50] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-10 23:02:50] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 06:52:19] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 06:52:19] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 06:52:19] Successfully compiled 1 matching stock entries. [2026-06-11 06:52:19] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-11 06:52:19] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 06:54:16] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 06:54:16] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 06:54:16] Successfully compiled 1 matching stock entries. [2026-06-11 06:54:16] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-11 06:54:16] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 06:54:20] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 06:54:20] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 06:54:20] Successfully compiled 1 matching stock entries. [2026-06-11 06:54:20] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-11 06:54:20] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 11:11:05] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 11:11:05] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 11:11:05] Successfully compiled 1 matching stock entries. [2026-06-11 11:11:05] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-11 11:11:05] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 11:11:06] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 11:11:06] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 11:11:06] Successfully compiled 1 matching stock entries. [2026-06-11 11:11:06] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-11 11:11:06] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 11:38:24] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 11:38:24] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 11:38:24] Successfully compiled 1 matching stock entries. [2026-06-11 11:38:24] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-11 11:38:24] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 12:45:21] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 12:45:21] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 12:45:21] Successfully compiled 1 matching stock entries. [2026-06-11 12:45:21] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-11 12:45:21] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 12:48:41] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 12:48:41] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 12:48:41] Successfully compiled 1 matching stock entries. [2026-06-11 12:48:41] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-11 12:48:41] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 18:27:38] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 18:27:38] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 18:27:38] Successfully compiled 0 matching stock entries. [2026-06-11 18:27:38] Final Outbound JSON Payload Success! Total items bundled: 0 [2026-06-11 18:29:10] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 18:29:10] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 18:29:10] Successfully compiled 0 matching stock entries. [2026-06-11 18:29:10] Final Outbound JSON Payload Success! Total items bundled: 0 [2026-06-11 18:30:25] --- NEW REQUEST RECEIVED --- [2026-06-11 18:32:01] --- NEW REQUEST RECEIVED --- [2026-06-11 18:32:01] Product not found in MRA. Creating custom for: CUSTOM [2026-06-11 18:32:01] SUCCESS: Transaction committed. [2026-06-11 18:32:01] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 18:32:01] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 18:32:01] Successfully compiled 1 matching stock entries. [2026-06-11 18:32:01] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 1 movement records. [2026-06-11 18:32:01] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 19:23:36] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 19:23:36] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 19:23:36] Successfully compiled 1 matching stock entries. [2026-06-11 19:23:36] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 1 movement records. [2026-06-11 19:23:36] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 19:28:54] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 19:28:54] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 19:28:54] Successfully compiled 1 matching stock entries. [2026-06-11 19:28:54] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 1 movement records. [2026-06-11 19:28:54] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 19:37:20] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 19:37:20] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 19:37:20] Successfully compiled 1 matching stock entries. [2026-06-11 19:37:20] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 1 movement records. [2026-06-11 19:37:20] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 19:44:05] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 19:44:05] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 19:44:05] Successfully compiled 1 matching stock entries. [2026-06-11 19:44:05] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 1 movement records. [2026-06-11 19:44:05] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 19:45:31] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 19:45:31] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 19:45:31] Successfully compiled 1 matching stock entries. [2026-06-11 19:45:31] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 1 movement records. [2026-06-11 19:45:31] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 19:50:27] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 19:50:27] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 19:50:27] Successfully compiled 1 matching stock entries. [2026-06-11 19:50:27] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 1 movement records. [2026-06-11 19:50:27] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 19:54:07] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 19:54:07] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 19:54:07] Successfully compiled 1 matching stock entries. [2026-06-11 19:54:07] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 1 movement records. [2026-06-11 19:54:07] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 20:00:37] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 20:00:37] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 20:00:37] Successfully compiled 1 matching stock entries. [2026-06-11 20:00:37] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 1 movement records. [2026-06-11 20:00:37] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 20:01:55] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 20:01:55] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 20:01:55] Successfully compiled 1 matching stock entries. [2026-06-11 20:01:55] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 1 movement records. [2026-06-11 20:01:55] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 20:09:29] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 20:09:29] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 20:09:29] Successfully compiled 1 matching stock entries. [2026-06-11 20:09:29] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 1 movement records. [2026-06-11 20:09:29] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 20:10:22] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 20:10:22] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 20:10:22] Successfully compiled 1 matching stock entries. [2026-06-11 20:10:22] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 1 movement records. [2026-06-11 20:10:22] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 20:11:20] --- NEW REQUEST RECEIVED --- [2026-06-11 20:11:20] Closing Session Raw Stream Capture: org_id=42&warehouse_stock_id=42&branch_name=28&transfer_qty=200&selling_price=1200&min_alert=5 [2026-06-11 20:32:45] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 20:32:45] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 20:32:45] Successfully compiled 1 matching stock entries. [2026-06-11 20:32:45] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 2 movement records. [2026-06-11 20:32:45] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 20:32:48] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 20:32:48] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 20:32:48] Successfully compiled 1 matching stock entries. [2026-06-11 20:32:48] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 2 movement records. [2026-06-11 20:32:48] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 20:57:15] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 20:57:15] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 20:57:15] Successfully compiled 1 matching stock entries. [2026-06-11 20:57:15] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 2 movement records. [2026-06-11 20:57:15] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-11 21:47:42] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-11 21:47:42] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-11') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-11 21:47:42] Successfully compiled 1 matching stock entries. [2026-06-11 21:47:42] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 2 movement records. [2026-06-11 21:47:42] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-12 04:15:43] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-12 04:15:43] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-12') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-12 04:15:43] Successfully compiled 1 matching stock entries. [2026-06-12 04:15:43] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 2 movement records. [2026-06-12 04:15:43] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-12 20:05:38] --- NEW REQUEST RECEIVED --- [2026-06-12 20:05:38] Closing Session Raw Stream Capture: [] [2026-06-12 20:05:40] Inbound Request Auth -> Org: 0, User: 0, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-12 20:05:48] --- NEW REQUEST RECEIVED --- [2026-06-12 20:05:48] Closing Session Raw Stream Capture: [] [2026-06-12 20:05:48] ERROR: Warehouse stock record not found. [2026-06-12 20:05:59] --- NEW REQUEST RECEIVED --- [2026-06-12 20:05:59] ERROR: Auth Failed. Cleaned Org: 0, Cleaned User: 0 [2026-06-12 20:05:59] RAW POST DATA: [] [2026-06-12 20:06:14] --- NEW UPDATE REQUEST RECEIVED --- [2026-06-12 20:06:14] ERROR: Validation Failed. Org: 0, User: 0, Stock ID: 0 [2026-06-13 07:56:48] --- NEW UPDATE REQUEST RECEIVED --- [2026-06-13 07:56:48] ERROR: Validation Failed. Org: 0, User: 0, Stock ID: 0 [2026-06-13 07:56:48] Inbound Request Auth -> Org: 0, User: 0, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-13 07:56:48] --- NEW REQUEST RECEIVED --- [2026-06-13 07:56:48] ERROR: Auth Failed. Cleaned Org: 0, Cleaned User: 0 [2026-06-13 07:56:48] RAW POST DATA: [] [2026-06-13 07:56:48] --- NEW REQUEST RECEIVED --- [2026-06-13 07:56:48] Closing Session Raw Stream Capture: [] [2026-06-13 07:56:48] --- NEW REQUEST RECEIVED --- [2026-06-13 07:56:48] Closing Session Raw Stream Capture: [] [2026-06-13 07:56:48] ERROR: Warehouse stock record not found. [2026-06-13 21:52:20] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-13 21:52:20] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-13') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-13 21:52:20] Successfully compiled 1 matching stock entries. [2026-06-13 21:52:20] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 2 movement records. [2026-06-13 21:52:20] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-13 22:27:44] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-13 22:27:44] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-13') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-13 22:27:44] Successfully compiled 1 matching stock entries. [2026-06-13 22:27:44] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 2 movement records. [2026-06-13 22:27:44] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-13 22:30:09] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-13 22:30:09] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-13') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-13 22:30:09] Successfully compiled 1 matching stock entries. [2026-06-13 22:30:09] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 2 movement records. [2026-06-13 22:30:09] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-13 22:30:11] Inbound Request Auth -> Org: 42, User: 51, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-13 22:30:11] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-13') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 42 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-13 22:30:11] Successfully compiled 1 matching stock entries. [2026-06-13 22:30:11] -> Stock ID: 42 (Item ID: 23) | Name: 'Chombe tea' | Found 2 movement records. [2026-06-13 22:30:11] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 06:07:30] Inbound Request Auth -> Org: 43, User: 54, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 06:07:30] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 43 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 06:07:30] Successfully compiled 0 matching stock entries. [2026-06-14 06:07:30] Final Outbound JSON Payload Success! Total items bundled: 0 [2026-06-14 06:09:45] --- NEW REQUEST RECEIVED --- [2026-06-14 06:09:45] Product not found in MRA. Creating custom for: CUSTOM [2026-06-14 06:09:45] SUCCESS: Transaction committed. [2026-06-14 06:09:45] Inbound Request Auth -> Org: 43, User: 54, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 06:09:45] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 43 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 06:09:45] Successfully compiled 1 matching stock entries. [2026-06-14 06:09:45] -> Stock ID: 43 (Item ID: 24) | Name: 'Azam big' | Found 1 movement records. [2026-06-14 06:09:45] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 06:10:29] Inbound Request Auth -> Org: 43, User: 54, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 06:10:29] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 43 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 06:10:29] Successfully compiled 1 matching stock entries. [2026-06-14 06:10:29] -> Stock ID: 43 (Item ID: 24) | Name: 'Azam big' | Found 1 movement records. [2026-06-14 06:10:29] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 06:11:04] --- NEW REQUEST RECEIVED --- [2026-06-14 06:11:04] Closing Session Raw Stream Capture: org_id=43&warehouse_stock_id=43&branch_name=29&transfer_qty=100&selling_price=1200&min_alert=10 [2026-06-14 07:13:24] Inbound Request Auth -> Org: 44, User: 55, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 07:13:24] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 44 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 07:13:24] Successfully compiled 0 matching stock entries. [2026-06-14 07:13:24] Final Outbound JSON Payload Success! Total items bundled: 0 [2026-06-14 07:14:36] --- NEW REQUEST RECEIVED --- [2026-06-14 07:14:36] Product not found in MRA. Creating custom for: CUSTOM [2026-06-14 07:14:36] SUCCESS: Transaction committed. [2026-06-14 07:14:37] Inbound Request Auth -> Org: 44, User: 55, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 07:14:37] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 44 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 07:14:37] Successfully compiled 1 matching stock entries. [2026-06-14 07:14:37] -> Stock ID: 44 (Item ID: 25) | Name: 'Azam big' | Found 1 movement records. [2026-06-14 07:14:37] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 07:15:12] Inbound Request Auth -> Org: 44, User: 55, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 07:15:12] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 44 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 07:15:12] Successfully compiled 1 matching stock entries. [2026-06-14 07:15:12] -> Stock ID: 44 (Item ID: 25) | Name: 'Azam big' | Found 1 movement records. [2026-06-14 07:15:12] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 07:15:37] --- NEW REQUEST RECEIVED --- [2026-06-14 07:15:37] Closing Session Raw Stream Capture: org_id=44&warehouse_stock_id=44&branch_name=30&transfer_qty=100&selling_price=1200&min_alert=10 [2026-06-14 07:55:16] Inbound Request Auth -> Org: 44, User: 55, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 07:55:16] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 44 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 07:55:16] Successfully compiled 1 matching stock entries. [2026-06-14 07:55:16] -> Stock ID: 44 (Item ID: 25) | Name: 'Azam big' | Found 2 movement records. [2026-06-14 07:55:16] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 08:02:44] Inbound Request Auth -> Org: 44, User: 55, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 08:02:44] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 44 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 08:02:44] Successfully compiled 1 matching stock entries. [2026-06-14 08:02:44] -> Stock ID: 44 (Item ID: 25) | Name: 'Azam big' | Found 2 movement records. [2026-06-14 08:02:44] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 08:08:32] Inbound Request Auth -> Org: 44, User: 55, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 08:08:32] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 44 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 08:08:32] Successfully compiled 1 matching stock entries. [2026-06-14 08:08:32] -> Stock ID: 44 (Item ID: 25) | Name: 'Azam big' | Found 2 movement records. [2026-06-14 08:08:32] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 08:46:43] Inbound Request Auth -> Org: 44, User: 55, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 08:46:43] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 44 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 08:46:43] Successfully compiled 1 matching stock entries. [2026-06-14 08:46:43] -> Stock ID: 44 (Item ID: 25) | Name: 'Azam big' | Found 2 movement records. [2026-06-14 08:46:43] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 08:52:21] Inbound Request Auth -> Org: 45, User: 56, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 08:52:21] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 45 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 08:52:21] Successfully compiled 0 matching stock entries. [2026-06-14 08:52:21] Final Outbound JSON Payload Success! Total items bundled: 0 [2026-06-14 08:54:40] --- NEW REQUEST RECEIVED --- [2026-06-14 08:54:40] Product not found in MRA. Creating custom for: CUSTOM [2026-06-14 08:54:40] SUCCESS: Transaction committed. [2026-06-14 08:54:40] Inbound Request Auth -> Org: 45, User: 56, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 08:54:40] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 45 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 08:54:40] Successfully compiled 1 matching stock entries. [2026-06-14 08:54:40] -> Stock ID: 45 (Item ID: 26) | Name: 'Azam soap big' | Found 1 movement records. [2026-06-14 08:54:40] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 08:55:35] --- NEW REQUEST RECEIVED --- [2026-06-14 08:55:35] Closing Session Raw Stream Capture: org_id=45&warehouse_stock_id=45&branch_name=31&transfer_qty=100&selling_price=1200&min_alert=5 [2026-06-14 09:04:32] Inbound Request Auth -> Org: 45, User: 56, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 09:04:32] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 45 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 09:04:32] Successfully compiled 1 matching stock entries. [2026-06-14 09:04:32] -> Stock ID: 45 (Item ID: 26) | Name: 'Azam soap big' | Found 2 movement records. [2026-06-14 09:04:32] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 09:04:38] Inbound Request Auth -> Org: 45, User: 56, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 09:04:38] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 45 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 09:04:38] Successfully compiled 1 matching stock entries. [2026-06-14 09:04:38] -> Stock ID: 45 (Item ID: 26) | Name: 'Azam soap big' | Found 2 movement records. [2026-06-14 09:04:38] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 09:05:02] Inbound Request Auth -> Org: 45, User: 56, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 09:05:02] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 45 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 09:05:02] Successfully compiled 1 matching stock entries. [2026-06-14 09:05:02] -> Stock ID: 45 (Item ID: 26) | Name: 'Azam soap big' | Found 2 movement records. [2026-06-14 09:05:02] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 09:22:58] Inbound Request Auth -> Org: 46, User: 57, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 09:22:58] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 46 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 09:22:58] Successfully compiled 0 matching stock entries. [2026-06-14 09:22:58] Final Outbound JSON Payload Success! Total items bundled: 0 [2026-06-14 09:24:27] --- NEW REQUEST RECEIVED --- [2026-06-14 09:24:27] Product not found in MRA. Creating custom for: CUSTOM [2026-06-14 09:24:27] SUCCESS: Transaction committed. [2026-06-14 09:24:27] Inbound Request Auth -> Org: 46, User: 57, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 09:24:27] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 46 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 09:24:27] Successfully compiled 1 matching stock entries. [2026-06-14 09:24:27] -> Stock ID: 46 (Item ID: 27) | Name: 'Azam soap big' | Found 1 movement records. [2026-06-14 09:24:27] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 09:25:48] --- NEW REQUEST RECEIVED --- [2026-06-14 09:25:48] Closing Session Raw Stream Capture: org_id=46&warehouse_stock_id=46&branch_name=32&transfer_qty=200&selling_price=1200&min_alert=50 [2026-06-14 09:46:29] Inbound Request Auth -> Org: 46, User: 57, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 09:46:29] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 46 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 09:46:29] Successfully compiled 1 matching stock entries. [2026-06-14 09:46:29] -> Stock ID: 46 (Item ID: 27) | Name: 'Azam soap big' | Found 2 movement records. [2026-06-14 09:46:29] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 09:47:27] Inbound Request Auth -> Org: 46, User: 57, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 09:47:27] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 46 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 09:47:27] Successfully compiled 1 matching stock entries. [2026-06-14 09:47:27] -> Stock ID: 46 (Item ID: 27) | Name: 'Azam soap big' | Found 2 movement records. [2026-06-14 09:47:27] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 09:47:28] Inbound Request Auth -> Org: 46, User: 57, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 09:47:28] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 46 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 09:47:28] Successfully compiled 1 matching stock entries. [2026-06-14 09:47:28] -> Stock ID: 46 (Item ID: 27) | Name: 'Azam soap big' | Found 2 movement records. [2026-06-14 09:47:28] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 09:47:31] Inbound Request Auth -> Org: 46, User: 57, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 09:47:31] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 46 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 09:47:31] Successfully compiled 1 matching stock entries. [2026-06-14 09:47:31] -> Stock ID: 46 (Item ID: 27) | Name: 'Azam soap big' | Found 2 movement records. [2026-06-14 09:47:31] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 09:47:35] Inbound Request Auth -> Org: 46, User: 57, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 09:47:35] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 46 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 09:47:35] Successfully compiled 1 matching stock entries. [2026-06-14 09:47:35] -> Stock ID: 46 (Item ID: 27) | Name: 'Azam soap big' | Found 2 movement records. [2026-06-14 09:47:35] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 09:56:53] Inbound Request Auth -> Org: 47, User: 58, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 09:56:53] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 47 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 09:56:53] Successfully compiled 0 matching stock entries. [2026-06-14 09:56:53] Final Outbound JSON Payload Success! Total items bundled: 0 [2026-06-14 09:58:18] --- NEW REQUEST RECEIVED --- [2026-06-14 09:58:18] Product not found in MRA. Creating custom for: CUSTOM [2026-06-14 09:58:18] SUCCESS: Transaction committed. [2026-06-14 09:58:18] Inbound Request Auth -> Org: 47, User: 58, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 09:58:18] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 47 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 09:58:18] Successfully compiled 1 matching stock entries. [2026-06-14 09:58:18] -> Stock ID: 47 (Item ID: 28) | Name: 'Azam soap big' | Found 1 movement records. [2026-06-14 09:58:18] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 09:59:35] --- NEW REQUEST RECEIVED --- [2026-06-14 09:59:35] Closing Session Raw Stream Capture: org_id=47&warehouse_stock_id=47&branch_name=33&transfer_qty=100&selling_price=1200&min_alert=20 [2026-06-14 10:21:30] Inbound Request Auth -> Org: 47, User: 60, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 10:21:30] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 47 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 10:21:30] Successfully compiled 1 matching stock entries. [2026-06-14 10:21:30] -> Stock ID: 47 (Item ID: 28) | Name: 'Azam soap big' | Found 2 movement records. [2026-06-14 10:21:30] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 10:21:40] Inbound Request Auth -> Org: 47, User: 60, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 10:21:40] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 47 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 10:21:40] Successfully compiled 1 matching stock entries. [2026-06-14 10:21:40] -> Stock ID: 47 (Item ID: 28) | Name: 'Azam soap big' | Found 2 movement records. [2026-06-14 10:21:40] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 10:21:51] Inbound Request Auth -> Org: 47, User: 60, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 10:21:51] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 47 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 10:21:51] Successfully compiled 1 matching stock entries. [2026-06-14 10:21:51] -> Stock ID: 47 (Item ID: 28) | Name: 'Azam soap big' | Found 2 movement records. [2026-06-14 10:21:51] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 10:21:53] Inbound Request Auth -> Org: 47, User: 60, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 10:21:53] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 47 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 10:21:53] Successfully compiled 1 matching stock entries. [2026-06-14 10:21:53] -> Stock ID: 47 (Item ID: 28) | Name: 'Azam soap big' | Found 2 movement records. [2026-06-14 10:21:53] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 10:26:56] Inbound Request Auth -> Org: 47, User: 60, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 10:26:56] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 47 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 10:26:56] Successfully compiled 1 matching stock entries. [2026-06-14 10:26:56] -> Stock ID: 47 (Item ID: 28) | Name: 'Azam soap big' | Found 2 movement records. [2026-06-14 10:26:56] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 10:27:25] Inbound Request Auth -> Org: 47, User: 60, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 10:27:25] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 47 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 10:27:25] Successfully compiled 1 matching stock entries. [2026-06-14 10:27:25] -> Stock ID: 47 (Item ID: 28) | Name: 'Azam soap big' | Found 2 movement records. [2026-06-14 10:27:25] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 10:27:36] Inbound Request Auth -> Org: 47, User: 60, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 10:27:36] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 47 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 10:27:36] Successfully compiled 1 matching stock entries. [2026-06-14 10:27:36] -> Stock ID: 47 (Item ID: 28) | Name: 'Azam soap big' | Found 2 movement records. [2026-06-14 10:27:36] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 10:27:39] Inbound Request Auth -> Org: 47, User: 60, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 10:27:39] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 47 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 10:27:39] Successfully compiled 1 matching stock entries. [2026-06-14 10:27:39] -> Stock ID: 47 (Item ID: 28) | Name: 'Azam soap big' | Found 2 movement records. [2026-06-14 10:27:39] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 10:27:42] Inbound Request Auth -> Org: 47, User: 60, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 10:27:42] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 47 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 10:27:42] Successfully compiled 1 matching stock entries. [2026-06-14 10:27:42] -> Stock ID: 47 (Item ID: 28) | Name: 'Azam soap big' | Found 2 movement records. [2026-06-14 10:27:42] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 11:07:46] Inbound Request Auth -> Org: 41, User: 62, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 11:07:46] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 11:07:46] Successfully compiled 1 matching stock entries. [2026-06-14 11:07:46] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-14 11:07:46] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 11:45:34] Inbound Request Auth -> Org: 41, User: 63, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 11:45:34] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 11:45:34] Successfully compiled 1 matching stock entries. [2026-06-14 11:45:34] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-14 11:45:34] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 11:45:37] Inbound Request Auth -> Org: 41, User: 63, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 11:45:37] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 11:45:37] Successfully compiled 1 matching stock entries. [2026-06-14 11:45:37] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-14 11:45:37] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 14:17:45] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 14:17:45] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 14:17:45] Successfully compiled 1 matching stock entries. [2026-06-14 14:17:45] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-14 14:17:45] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 16:30:02] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 16:30:02] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 16:30:02] Successfully compiled 1 matching stock entries. [2026-06-14 16:30:02] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-14 16:30:02] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 16:30:52] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 16:30:52] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 16:30:52] Successfully compiled 1 matching stock entries. [2026-06-14 16:30:52] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-14 16:30:52] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 16:32:34] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 16:32:34] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 16:32:34] Successfully compiled 1 matching stock entries. [2026-06-14 16:32:34] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-14 16:32:34] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 16:36:49] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 16:36:49] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 16:36:49] Successfully compiled 1 matching stock entries. [2026-06-14 16:36:49] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-14 16:36:49] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 17:00:13] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 17:00:13] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 17:00:13] Successfully compiled 1 matching stock entries. [2026-06-14 17:00:13] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-14 17:00:13] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 17:13:38] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 17:13:38] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 17:13:38] Successfully compiled 1 matching stock entries. [2026-06-14 17:13:38] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-14 17:13:38] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-14 17:15:18] --- NEW REQUEST RECEIVED --- [2026-06-14 17:15:18] Product not found in MRA. Creating custom for: CUSTOM [2026-06-14 17:15:18] SUCCESS: Transaction committed. [2026-06-14 17:15:19] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 17:15:19] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 17:15:19] Successfully compiled 2 matching stock entries. [2026-06-14 17:15:19] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-14 17:15:19] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 1 movement records. [2026-06-14 17:15:19] Final Outbound JSON Payload Success! Total items bundled: 2 [2026-06-14 17:21:47] --- NEW REQUEST RECEIVED --- [2026-06-14 17:21:47] Product not found in MRA. Creating custom for: CUSTOM [2026-06-14 17:21:47] SUCCESS: Transaction committed. [2026-06-14 17:21:48] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 17:21:48] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 17:21:48] Successfully compiled 3 matching stock entries. [2026-06-14 17:21:48] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-14 17:21:48] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 1 movement records. [2026-06-14 17:21:48] -> Stock ID: 49 (Item ID: 30) | Name: 'Kazinga 2lite' | Found 1 movement records. [2026-06-14 17:21:48] Final Outbound JSON Payload Success! Total items bundled: 3 [2026-06-14 17:42:14] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 17:42:14] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 17:42:14] Successfully compiled 3 matching stock entries. [2026-06-14 17:42:14] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-14 17:42:14] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 1 movement records. [2026-06-14 17:42:14] -> Stock ID: 49 (Item ID: 30) | Name: 'Kazinga 2lite' | Found 1 movement records. [2026-06-14 17:42:14] Final Outbound JSON Payload Success! Total items bundled: 3 [2026-06-14 17:42:46] --- NEW REQUEST RECEIVED --- [2026-06-14 17:42:46] Closing Session Raw Stream Capture: org_id=41&warehouse_stock_id=49&branch_name=27&transfer_qty=100&selling_price=9200&min_alert=5 [2026-06-14 17:43:22] --- NEW REQUEST RECEIVED --- [2026-06-14 17:43:22] Closing Session Raw Stream Capture: org_id=41&warehouse_stock_id=48&branch_name=27&transfer_qty=150&selling_price=650&min_alert=5 [2026-06-14 17:43:57] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 17:43:57] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 17:43:57] Successfully compiled 3 matching stock entries. [2026-06-14 17:43:57] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-14 17:43:57] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 2 movement records. [2026-06-14 17:43:57] -> Stock ID: 49 (Item ID: 30) | Name: 'Kazinga 2lite' | Found 2 movement records. [2026-06-14 17:43:57] Final Outbound JSON Payload Success! Total items bundled: 3 [2026-06-14 17:44:39] --- NEW REQUEST RECEIVED --- [2026-06-14 17:44:39] Product not found in MRA. Creating custom for: CUSTOM [2026-06-14 17:44:39] SUCCESS: Transaction committed. [2026-06-14 17:44:40] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-14 17:44:40] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-14') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-14 17:44:40] Successfully compiled 4 matching stock entries. [2026-06-14 17:44:40] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-14 17:44:40] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 2 movement records. [2026-06-14 17:44:40] -> Stock ID: 49 (Item ID: 30) | Name: 'Kazinga 2lite' | Found 2 movement records. [2026-06-14 17:44:40] -> Stock ID: 50 (Item ID: 31) | Name: 'Doom' | Found 1 movement records. [2026-06-14 17:44:40] Final Outbound JSON Payload Success! Total items bundled: 4 [2026-06-14 17:46:35] --- NEW REQUEST RECEIVED --- [2026-06-14 17:46:35] Closing Session Raw Stream Capture: org_id=41&warehouse_stock_id=50&branch_name=27&transfer_qty=150&selling_price=2200&min_alert=5 [2026-06-15 04:26:44] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-15 04:26:44] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-15') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-15 04:26:44] Successfully compiled 4 matching stock entries. [2026-06-15 04:26:44] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-15 04:26:44] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 2 movement records. [2026-06-15 04:26:44] -> Stock ID: 49 (Item ID: 30) | Name: 'Kazinga 2lite' | Found 2 movement records. [2026-06-15 04:26:44] -> Stock ID: 50 (Item ID: 31) | Name: 'Doom' | Found 2 movement records. [2026-06-15 04:26:44] Final Outbound JSON Payload Success! Total items bundled: 4 [2026-06-15 04:31:43] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-15 04:31:43] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-15') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-15 04:31:43] Successfully compiled 4 matching stock entries. [2026-06-15 04:31:43] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-15 04:31:43] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 2 movement records. [2026-06-15 04:31:43] -> Stock ID: 49 (Item ID: 30) | Name: 'Kazinga 2lite' | Found 2 movement records. [2026-06-15 04:31:43] -> Stock ID: 50 (Item ID: 31) | Name: 'Doom' | Found 2 movement records. [2026-06-15 04:31:43] Final Outbound JSON Payload Success! Total items bundled: 4 [2026-06-15 04:32:28] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-15 04:32:28] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-15') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-15 04:32:28] Successfully compiled 4 matching stock entries. [2026-06-15 04:32:28] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-15 04:32:28] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 2 movement records. [2026-06-15 04:32:28] -> Stock ID: 49 (Item ID: 30) | Name: 'Kazinga 2lite' | Found 2 movement records. [2026-06-15 04:32:28] -> Stock ID: 50 (Item ID: 31) | Name: 'Doom' | Found 2 movement records. [2026-06-15 04:32:28] Final Outbound JSON Payload Success! Total items bundled: 4 [2026-06-15 04:35:19] --- NEW REQUEST RECEIVED --- [2026-06-15 04:35:19] Product not found in MRA. Creating custom for: CUSTOM [2026-06-15 04:35:19] SUCCESS: Transaction committed. [2026-06-15 04:35:20] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-15 04:35:20] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-15') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-15 04:35:20] Successfully compiled 5 matching stock entries. [2026-06-15 04:35:20] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-15 04:35:20] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 2 movement records. [2026-06-15 04:35:20] -> Stock ID: 49 (Item ID: 30) | Name: 'Kazinga 2lite' | Found 2 movement records. [2026-06-15 04:35:20] -> Stock ID: 50 (Item ID: 31) | Name: 'Doom' | Found 2 movement records. [2026-06-15 04:35:20] -> Stock ID: 51 (Item ID: 32) | Name: 'eggs' | Found 1 movement records. [2026-06-15 04:35:20] Final Outbound JSON Payload Success! Total items bundled: 5 [2026-06-15 04:36:33] --- NEW REQUEST RECEIVED --- [2026-06-15 04:36:33] Closing Session Raw Stream Capture: org_id=41&warehouse_stock_id=51&branch_name=27&transfer_qty=150&selling_price=550&min_alert=5 [2026-06-15 06:35:55] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-15 06:35:55] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-15') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-15 06:35:55] Successfully compiled 5 matching stock entries. [2026-06-15 06:35:55] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-15 06:35:55] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 2 movement records. [2026-06-15 06:35:55] -> Stock ID: 49 (Item ID: 30) | Name: 'Kazinga 2lite' | Found 2 movement records. [2026-06-15 06:35:55] -> Stock ID: 50 (Item ID: 31) | Name: 'Doom' | Found 2 movement records. [2026-06-15 06:35:55] -> Stock ID: 51 (Item ID: 32) | Name: 'eggs' | Found 2 movement records. [2026-06-15 06:35:55] Final Outbound JSON Payload Success! Total items bundled: 5 [2026-06-15 06:36:11] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-15 06:36:11] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-15') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-15 06:36:11] Successfully compiled 5 matching stock entries. [2026-06-15 06:36:11] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-15 06:36:11] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 2 movement records. [2026-06-15 06:36:11] -> Stock ID: 49 (Item ID: 30) | Name: 'Kazinga 2lite' | Found 2 movement records. [2026-06-15 06:36:11] -> Stock ID: 50 (Item ID: 31) | Name: 'Doom' | Found 2 movement records. [2026-06-15 06:36:11] -> Stock ID: 51 (Item ID: 32) | Name: 'eggs' | Found 2 movement records. [2026-06-15 06:36:11] Final Outbound JSON Payload Success! Total items bundled: 5 [2026-06-15 06:55:20] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-15 06:55:20] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-15') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-15 06:55:20] Successfully compiled 5 matching stock entries. [2026-06-15 06:55:20] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-15 06:55:20] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 2 movement records. [2026-06-15 06:55:20] -> Stock ID: 49 (Item ID: 30) | Name: 'Kazinga 2lite' | Found 2 movement records. [2026-06-15 06:55:20] -> Stock ID: 50 (Item ID: 31) | Name: 'Doom' | Found 2 movement records. [2026-06-15 06:55:20] -> Stock ID: 51 (Item ID: 32) | Name: 'eggs' | Found 2 movement records. [2026-06-15 06:55:20] Final Outbound JSON Payload Success! Total items bundled: 5 [2026-06-15 06:57:56] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-15 06:57:56] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-15') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-15 06:57:56] Successfully compiled 5 matching stock entries. [2026-06-15 06:57:56] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-15 06:57:56] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 2 movement records. [2026-06-15 06:57:56] -> Stock ID: 49 (Item ID: 30) | Name: 'Kazinga 2lite' | Found 2 movement records. [2026-06-15 06:57:56] -> Stock ID: 50 (Item ID: 31) | Name: 'Doom' | Found 2 movement records. [2026-06-15 06:57:56] -> Stock ID: 51 (Item ID: 32) | Name: 'eggs' | Found 2 movement records. [2026-06-15 06:57:56] Final Outbound JSON Payload Success! Total items bundled: 5 [2026-06-15 09:58:53] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-15 09:58:53] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-15') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-15 09:58:53] Successfully compiled 5 matching stock entries. [2026-06-15 09:58:53] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-15 09:58:53] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 2 movement records. [2026-06-15 09:58:53] -> Stock ID: 49 (Item ID: 30) | Name: 'Kazinga 2lite' | Found 2 movement records. [2026-06-15 09:58:53] -> Stock ID: 50 (Item ID: 31) | Name: 'Doom' | Found 2 movement records. [2026-06-15 09:58:53] -> Stock ID: 51 (Item ID: 32) | Name: 'eggs' | Found 2 movement records. [2026-06-15 09:58:53] Final Outbound JSON Payload Success! Total items bundled: 5 [2026-06-15 19:10:38] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-15 19:10:38] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-15') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-15 19:10:38] Successfully compiled 5 matching stock entries. [2026-06-15 19:10:38] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-15 19:10:38] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 2 movement records. [2026-06-15 19:10:38] -> Stock ID: 49 (Item ID: 30) | Name: 'Kazinga 2lite' | Found 2 movement records. [2026-06-15 19:10:38] -> Stock ID: 50 (Item ID: 31) | Name: 'Doom' | Found 2 movement records. [2026-06-15 19:10:38] -> Stock ID: 51 (Item ID: 32) | Name: 'eggs' | Found 2 movement records. [2026-06-15 19:10:38] Final Outbound JSON Payload Success! Total items bundled: 5 [2026-06-16 08:17:03] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-16 08:17:03] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-16') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-16 08:17:03] Successfully compiled 5 matching stock entries. [2026-06-16 08:17:03] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-16 08:17:03] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 2 movement records. [2026-06-16 08:17:03] -> Stock ID: 49 (Item ID: 30) | Name: 'Kazinga 2lite' | Found 2 movement records. [2026-06-16 08:17:03] -> Stock ID: 50 (Item ID: 31) | Name: 'Doom' | Found 2 movement records. [2026-06-16 08:17:03] -> Stock ID: 51 (Item ID: 32) | Name: 'eggs' | Found 2 movement records. [2026-06-16 08:17:03] Final Outbound JSON Payload Success! Total items bundled: 5 [2026-06-16 08:19:27] --- NEW REQUEST RECEIVED --- [2026-06-16 08:19:27] Product not found in MRA. Creating custom for: CUSTOM [2026-06-16 08:19:27] SUCCESS: Transaction committed. [2026-06-16 08:19:27] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-16 08:19:27] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-16') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-16 08:19:27] Successfully compiled 6 matching stock entries. [2026-06-16 08:19:27] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-16 08:19:27] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 2 movement records. [2026-06-16 08:19:27] -> Stock ID: 49 (Item ID: 30) | Name: 'Kazinga 2lite' | Found 2 movement records. [2026-06-16 08:19:27] -> Stock ID: 50 (Item ID: 31) | Name: 'Doom' | Found 2 movement records. [2026-06-16 08:19:27] -> Stock ID: 51 (Item ID: 32) | Name: 'eggs' | Found 2 movement records. [2026-06-16 08:19:27] -> Stock ID: 52 (Item ID: 33) | Name: 'Azam smal' | Found 2 movement records. [2026-06-16 08:19:27] Final Outbound JSON Payload Success! Total items bundled: 6 [2026-06-16 08:20:31] --- NEW REQUEST RECEIVED --- [2026-06-16 08:20:31] Closing Session Raw Stream Capture: org_id=41&warehouse_stock_id=52&branch_name=27&transfer_qty=10&selling_price=150&min_alert=5 [2026-06-16 08:53:29] Inbound Request Auth -> Org: 49, User: 65, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-16 08:53:29] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-16') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 49 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-16 08:53:29] Successfully compiled 0 matching stock entries. [2026-06-16 08:53:29] Final Outbound JSON Payload Success! Total items bundled: 0 [2026-06-16 08:56:39] --- NEW REQUEST RECEIVED --- [2026-06-16 08:56:39] Product not found in MRA. Creating custom for: CUSTOM [2026-06-16 08:56:39] SUCCESS: Transaction committed. [2026-06-16 08:56:39] Inbound Request Auth -> Org: 49, User: 65, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-16 08:56:39] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-16') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 49 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-16 08:56:39] Successfully compiled 1 matching stock entries. [2026-06-16 08:56:39] -> Stock ID: 53 (Item ID: 34) | Name: 'l sharp sofa ,3seater and sofa bed' | Found 2 movement records. [2026-06-16 08:56:39] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-16 08:57:29] --- NEW REQUEST RECEIVED --- [2026-06-16 08:57:29] Closing Session Raw Stream Capture: org_id=49&warehouse_stock_id=53&branch_name=34&transfer_qty=1&selling_price=850000&min_alert=5 [2026-06-16 10:44:30] Inbound Request Auth -> Org: 49, User: 65, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-16 10:44:30] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-16') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 49 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-16 10:44:30] Successfully compiled 1 matching stock entries. [2026-06-16 10:44:30] -> Stock ID: 53 (Item ID: 34) | Name: 'l sharp sofa ,3seater and sofa bed' | Found 3 movement records. [2026-06-16 10:44:30] Final Outbound JSON Payload Success! Total items bundled: 1 [2026-06-17 05:13:53] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-17 05:13:53] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-17') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-17 05:13:53] Successfully compiled 6 matching stock entries. [2026-06-17 05:13:53] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-17 05:13:53] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 2 movement records. [2026-06-17 05:13:53] -> Stock ID: 49 (Item ID: 30) | Name: 'Kazinga 2lite' | Found 2 movement records. [2026-06-17 05:13:53] -> Stock ID: 50 (Item ID: 31) | Name: 'Doom' | Found 2 movement records. [2026-06-17 05:13:53] -> Stock ID: 51 (Item ID: 32) | Name: 'eggs' | Found 2 movement records. [2026-06-17 05:13:53] -> Stock ID: 52 (Item ID: 33) | Name: 'Azam smal' | Found 3 movement records. [2026-06-17 05:13:53] Final Outbound JSON Payload Success! Total items bundled: 6 [2026-06-19 06:34:47] Inbound Request Auth -> Org: 50, User: 66, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-19 06:34:47] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-19') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 50 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-19 06:34:47] Successfully compiled 0 matching stock entries. [2026-06-19 06:34:47] Final Outbound JSON Payload Success! Total items bundled: 0 [2026-06-19 07:34:12] Inbound Request Auth -> Org: 41, User: 50, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-19 07:34:12] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-19') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 41 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-19 07:34:12] Successfully compiled 6 matching stock entries. [2026-06-19 07:34:12] -> Stock ID: 41 (Item ID: 22) | Name: 'AZAM BIG' | Found 2 movement records. [2026-06-19 07:34:12] -> Stock ID: 48 (Item ID: 29) | Name: 'Tomato sauce' | Found 2 movement records. [2026-06-19 07:34:12] -> Stock ID: 49 (Item ID: 30) | Name: 'Kazinga 2lite' | Found 2 movement records. [2026-06-19 07:34:12] -> Stock ID: 50 (Item ID: 31) | Name: 'Doom' | Found 2 movement records. [2026-06-19 07:34:12] -> Stock ID: 51 (Item ID: 32) | Name: 'eggs' | Found 2 movement records. [2026-06-19 07:34:12] -> Stock ID: 52 (Item ID: 33) | Name: 'Azam smal' | Found 3 movement records. [2026-06-19 07:34:12] Final Outbound JSON Payload Success! Total items bundled: 6 [2026-06-19 11:19:54] Inbound Request Auth -> Org: 52, User: 68, Branch Context: 0, Last Sync Window: '2000-01-01 00:00:00' [2026-06-19 11:19:54] Executing Query String: SELECT ws.*, mp.description as product_real_name, DATEDIFF(ws.expiry_date, '2026-06-19') as days_to_expire FROM org_warehouse_stock ws LEFT JOIN mra_products mp ON ws.barcode = mp.product_code WHERE ws.org_id = 52 AND ws.last_updated > '2000-01-01 00:00:00' [2026-06-19 11:19:54] Successfully compiled 0 matching stock entries. [2026-06-19 11:19:54] Final Outbound JSON Payload Success! Total items bundled: 0 [2026-06-19 11:26:57] --- NEW REQUEST RECEIVED --- [2026-06-19 11:26:57] Closing Session Raw Stream Capture: [] [2026-06-19 11:26:57] ERROR: Warehouse stock record not found.