[2026-04-14 08:17:01] API Triggered
[2026-04-14 08:17:01] Checking Token...
[2026-04-14 08:17:01] Token Valid. Store ID: 1
[2026-04-14 08:17:01] Input Received: {"items":[{"product_id":88,"variant_id":125,"quantity":1,"price":200.0},{"product_id":85,"variant_id":121,"quantity":1,"price":30.0},{"product_id":81,"variant_id":116,"quantity":1,"price":145.0},{"product_id":78,"variant_id":111,"quantity":1,"price":38.0}],"subtotal":413.0,"discount":0.0,"total":413.0,"payment_method":"Cash","customer_name":"kartik1","customer_phone":"+911234567890","coupon_id":null,"coupon_code":null,"coupon_discount":0.0,"manual_discount":0.0,"manual_discount_reason":"","payment_status":"Paid","order_type":"POS","created_at":"2026-04-14T13:47:02.359359"}
[2026-04-14 08:17:01] Transaction Started
[2026-04-14 08:17:01] Calling createOrderService...
[2026-04-14 08:17:01] ERROR: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`sarancmn_velecommerce`.`orders`, CONSTRAINT `fk_orders_ship_addr` FOREIGN KEY (`shipping_address_id`) REFERENCES `customer_addresses` (`id`) ON DELETE SET NULL) in /home/sarancmn/ecom.veltriadiix.in/ecom-api/helpers/order_service.php on line 129
[2026-04-16 08:47:06] --- NEW PAYMENT REQUEST ---
[2026-04-16 08:47:06] Checking dependencies...
[2026-04-16 08:47:06] Dependencies loaded.
[2026-04-16 08:47:06] Token valid. User ID: 1
[2026-04-16 08:47:06] Raw Input: {"order_id":139,"amount":50.0,"payment_method":"cash"}
[2026-04-16 08:47:06] Processing Order ID: 139, Amount: 50, Method: cash
[2026-04-16 08:47:06] DB Connected.
[2026-04-16 08:47:06] Current Collected: 200, New Total Collected: 250 / 300
[2026-04-16 08:47:06] New Payment Status: partial
[2026-04-16 08:47:06] Orders table updated.
[2026-04-16 08:47:06] Transaction rolled back.
[2026-04-16 08:47:06] CRITICAL ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'payment_method' in 'INSERT INTO'
[2026-04-16 08:49:24] --- NEW PAYMENT REQUEST ---
[2026-04-16 08:49:24] Checking dependencies...
[2026-04-16 08:49:24] Dependencies loaded.
[2026-04-16 08:49:24] Token valid. User ID: 1
[2026-04-16 08:49:24] Raw Input: {"order_id":139,"amount":50.0,"payment_method":"cash"}
[2026-04-16 08:49:24] Processing Order ID: 139, Amount: 50, Method: cash
[2026-04-16 08:49:24] DB Connected.
[2026-04-16 08:49:24] Current Collected: 200, New Total Collected: 250 / 300
[2026-04-16 08:49:24] New Payment Status: partial
[2026-04-16 08:49:24] Orders table updated.
[2026-04-16 08:49:24] Transaction rolled back.
[2026-04-16 08:49:24] CRITICAL ERROR: SQLSTATE[42000]: Syntax error or access violation: 1110 Column 'gateway' specified twice
[2026-04-16 09:09:12] --- NEW PAYMENT REQUEST ---
[2026-04-16 09:09:12] Checking dependencies...
[2026-04-16 09:09:12] Dependencies loaded.
[2026-04-16 09:09:12] Token valid. User ID: 1
[2026-04-16 09:09:12] Raw Input: {"order_id":139,"amount":50.0,"payment_method":"cash"}
[2026-04-16 09:09:12] Processing Order ID: 139, Amount: 50, Method: cash
[2026-04-16 09:09:12] DB Connected.
[2026-04-16 09:09:12] Current Collected: 200, New Total Collected: 250 / 300
[2026-04-16 09:09:12] New Payment Status: partial
[2026-04-16 09:09:12] Orders table updated.
[2026-04-16 09:09:12] Payments table record inserted. TXID: POS_COLL_1776330552_139
[2026-04-16 09:09:12] Transaction committed successfully.
[2026-04-16 09:09:51] --- NEW PAYMENT REQUEST ---
[2026-04-16 09:09:51] Checking dependencies...
[2026-04-16 09:09:51] Dependencies loaded.
[2026-04-16 09:09:51] Token valid. User ID: 1
[2026-04-16 09:09:51] Raw Input: {"order_id":139,"amount":50.0,"payment_method":"cash"}
[2026-04-16 09:09:51] Processing Order ID: 139, Amount: 50, Method: cash
[2026-04-16 09:09:51] DB Connected.
[2026-04-16 09:09:51] Current Collected: 250, New Total Collected: 300 / 300
[2026-04-16 09:09:51] New Payment Status: paid
[2026-04-16 09:09:51] Orders table updated.
[2026-04-16 09:09:51] Payments table record inserted. TXID: POS_COLL_1776330591_139
[2026-04-16 09:09:51] Transaction committed successfully.
[2026-04-19 07:17:55] --- NEW PAYMENT REQUEST ---
[2026-04-19 07:17:55] Checking dependencies...
[2026-04-19 07:17:55] Dependencies loaded.
[2026-04-19 07:17:55] Token valid. User ID: 1
[2026-04-19 07:17:55] Raw Input: {"order_id":185,"amount":300.0,"payment_method":"upi"}
[2026-04-19 07:17:55] Processing Order ID: 185, Amount: 300, Method: upi
[2026-04-19 07:17:55] DB Connected.
[2026-04-19 07:17:55] Current Collected: 0, New Total Collected: 300 / 300
[2026-04-19 07:17:55] New Payment Status: paid
[2026-04-19 07:17:55] Orders table updated.
[2026-04-19 07:17:55] Payments table record inserted. TXID: POS_COLL_1776583075_185
[2026-04-19 07:17:55] Transaction committed successfully.
[2026-04-19 07:26:32] --- NEW PAYMENT REQUEST ---
[2026-04-19 07:26:32] Checking dependencies...
[2026-04-19 07:26:32] Dependencies loaded.
[2026-04-19 07:26:32] Token valid. User ID: 1
[2026-04-19 07:26:32] Raw Input: {"order_id":186,"amount":50.0,"payment_method":"cash"}
[2026-04-19 07:26:32] Processing Order ID: 186, Amount: 50, Method: cash
[2026-04-19 07:26:32] DB Connected.
[2026-04-19 07:26:32] Current Collected: 100, New Total Collected: 150 / 200
[2026-04-19 07:26:32] New Payment Status: partial
[2026-04-19 07:26:32] Orders table updated.
[2026-04-19 07:26:32] Payments table record inserted. TXID: POS_COLL_1776583592_186
[2026-04-19 07:26:32] Transaction committed successfully.
[2026-04-19 07:33:45] --- NEW PAYMENT REQUEST ---
[2026-04-19 07:33:45] Checking dependencies...
[2026-04-19 07:33:45] Dependencies loaded.
[2026-04-19 07:33:45] Token valid. User ID: 1
[2026-04-19 07:33:45] Raw Input: {"order_id":186,"amount":50.0,"payment_method":"cash"}
[2026-04-19 07:33:45] Processing Order ID: 186, Amount: 50, Method: cash
[2026-04-19 07:33:45] DB Connected.
[2026-04-19 07:33:45] Current Collected: 150, New Total Collected: 200 / 200
[2026-04-19 07:33:45] New Payment Status: paid
[2026-04-19 07:33:45] Orders table updated with new method: cash
[2026-04-19 07:33:45] Payments table record inserted. TXID: POS_COLL_1776584025_186
[2026-04-19 07:33:45] Transaction committed successfully.
[2026-04-19 07:35:04] --- NEW PAYMENT REQUEST ---
[2026-04-19 07:35:04] Checking dependencies...
[2026-04-19 07:35:04] Dependencies loaded.
[2026-04-19 07:35:04] Token valid. User ID: 1
[2026-04-19 07:35:04] Raw Input: {"order_id":189,"amount":50.0,"payment_method":"cash"}
[2026-04-19 07:35:04] Processing Order ID: 189, Amount: 50, Method: cash
[2026-04-19 07:35:04] DB Connected.
[2026-04-19 07:35:04] Current Collected: 0, New Total Collected: 50 / 100
[2026-04-19 07:35:04] New Payment Status: partial
[2026-04-19 07:35:04] Orders table updated with new method: cash
[2026-04-19 07:35:04] Payments table record inserted. TXID: POS_COLL_1776584104_189
[2026-04-19 07:35:04] Transaction committed successfully.
[2026-04-19 07:35:47] --- NEW PAYMENT REQUEST ---
[2026-04-19 07:35:47] Checking dependencies...
[2026-04-19 07:35:47] Dependencies loaded.
[2026-04-19 07:35:47] Token valid. User ID: 1
[2026-04-19 07:35:47] Raw Input: {"order_id":189,"amount":50.0,"payment_method":"upi"}
[2026-04-19 07:35:47] Processing Order ID: 189, Amount: 50, Method: upi
[2026-04-19 07:35:47] DB Connected.
[2026-04-19 07:35:47] Current Collected: 50, New Total Collected: 100 / 100
[2026-04-19 07:35:47] New Payment Status: paid
[2026-04-19 07:35:47] Orders table updated with new method: upi
[2026-04-19 07:35:47] Payments table record inserted. TXID: POS_COLL_1776584147_189
[2026-04-19 07:35:47] Transaction committed successfully.
[2026-04-19 09:11:01] --- NEW PAYMENT REQUEST ---
[2026-04-19 09:11:01] Checking dependencies...
[2026-04-19 09:11:01] Dependencies loaded.
[2026-04-19 09:11:01] Token valid. User ID: 1
[2026-04-19 09:11:01] Raw Input: {"order_id":190,"amount":200.0,"payment_method":"cash"}
[2026-04-19 09:11:01] Processing Order ID: 190, Amount: 200, Method: cash
[2026-04-19 09:11:01] DB Connected.
[2026-04-19 09:11:01] Current Collected: 0, New Total Collected: 200 / 280
[2026-04-19 09:11:01] New Payment Status: partial
[2026-04-19 09:11:01] Orders table updated with new method: cash
[2026-04-19 09:11:01] Payments table record inserted. TXID: POS_COLL_1776589861_190
[2026-04-19 09:11:01] Transaction committed successfully.
[2026-04-19 09:11:23] --- NEW PAYMENT REQUEST ---
[2026-04-19 09:11:23] Checking dependencies...
[2026-04-19 09:11:23] Dependencies loaded.
[2026-04-19 09:11:23] Token valid. User ID: 1
[2026-04-19 09:11:23] Raw Input: {"order_id":183,"amount":195.0,"payment_method":"cash"}
[2026-04-19 09:11:23] Processing Order ID: 183, Amount: 195, Method: cash
[2026-04-19 09:11:23] DB Connected.
[2026-04-19 09:11:23] Current Collected: 0, New Total Collected: 195 / 195
[2026-04-19 09:11:23] New Payment Status: paid
[2026-04-19 09:11:23] Orders table updated with new method: cash
[2026-04-19 09:11:23] Payments table record inserted. TXID: POS_COLL_1776589883_183
[2026-04-19 09:11:23] Transaction committed successfully.
[2026-04-20 07:22:27] --- NEW PAYMENT REQUEST ---
[2026-04-20 07:22:27] Checking dependencies...
[2026-04-20 07:22:27] Dependencies loaded.
[2026-04-20 07:22:27] Token valid. User ID: 1
[2026-04-20 07:22:27] Raw Input: {"order_id":190,"amount":80.0,"payment_method":"cash"}
[2026-04-20 07:22:27] Processing Order ID: 190, Amount: 80, Method: cash
[2026-04-20 07:22:27] DB Connected.
[2026-04-20 07:22:27] Current Collected: 200, New Total Collected: 280 / 280
[2026-04-20 07:22:27] New Payment Status: paid
[2026-04-20 07:22:27] Orders table updated with new method: cash
[2026-04-20 07:22:27] Payments table record inserted. TXID: POS_COLL_1776669747_190
[2026-04-20 07:22:27] Transaction committed successfully.
[2026-04-20 07:46:44] --- NEW PAYMENT REQUEST ---
[2026-04-20 07:46:44] Checking dependencies...
[2026-04-20 07:46:44] Dependencies loaded.
[2026-04-20 07:46:44] Token valid. User ID: 1
[2026-04-20 07:46:44] Raw Input: {"order_id":193,"amount":70.0,"payment_method":"upi"}
[2026-04-20 07:46:44] Processing Order ID: 193, Amount: 70, Method: upi
[2026-04-20 07:46:44] DB Connected.
[2026-04-20 07:46:44] Current Collected: 0, New Total Collected: 70 / 70
[2026-04-20 07:46:44] New Payment Status: paid
[2026-04-20 07:46:44] Orders table updated with new method: upi
[2026-04-20 07:46:44] Payments table record inserted. TXID: POS_COLL_1776671204_193
[2026-04-20 07:46:44] Transaction committed successfully.
[2026-05-18 17:58:21] --- NEW PAYMENT REQUEST ---
[2026-05-18 17:58:21] Checking dependencies...
[2026-05-18 17:58:21] Dependencies loaded.
[2026-05-18 18:03:33] --- NEW PAYMENT REQUEST ---
[2026-05-18 18:03:33] Checking dependencies...
[2026-05-18 18:03:33] Dependencies loaded.
[2026-05-27 11:36:54] --- NEW PAYMENT REQUEST ---
[2026-05-27 11:36:54] Checking dependencies...
[2026-05-27 11:36:54] Dependencies loaded.
[2026-05-27 12:10:28] --- NEW PAYMENT REQUEST ---
[2026-05-27 12:10:28] Checking dependencies...
[2026-05-27 12:10:28] Dependencies loaded.
[2026-06-11 05:06:11] --- NEW PAYMENT REQUEST ---
[2026-06-11 05:06:11] Checking dependencies...
[2026-06-11 05:06:11] Dependencies loaded.
[2026-06-12 10:45:45] --- NEW PAYMENT REQUEST ---
[2026-06-12 10:45:45] Checking dependencies...
[2026-06-12 10:45:45] Dependencies loaded.
[2026-06-18 08:32:26] --- NEW PAYMENT REQUEST ---
[2026-06-18 08:32:26] Checking dependencies...
[2026-06-18 08:32:26] Dependencies loaded.
[2026-06-22 06:17:38] --- NEW PAYMENT REQUEST ---
[2026-06-22 06:17:38] Checking dependencies...
[2026-06-22 06:17:38] Dependencies loaded.
[2026-06-22 06:27:55] --- NEW PAYMENT REQUEST ---
[2026-06-22 06:27:55] Checking dependencies...
[2026-06-22 06:27:55] Dependencies loaded.
[2026-06-29 03:44:47] --- NEW PAYMENT REQUEST ---
[2026-06-29 03:44:47] Checking dependencies...
[2026-06-29 03:44:47] Dependencies loaded.
[2026-06-29 04:00:48] --- NEW PAYMENT REQUEST ---
[2026-06-29 04:00:48] Checking dependencies...
[2026-06-29 04:00:48] Dependencies loaded.
[2026-06-29 06:37:47] --- NEW PAYMENT REQUEST ---
[2026-06-29 06:37:47] Checking dependencies...
[2026-06-29 06:37:47] Dependencies loaded.
[2026-06-29 06:37:47] Token valid. User ID: 2
[2026-06-29 06:37:47] Raw Input: {"order_id":265,"amount":860.0,"payment_method":"upi"}
[2026-06-29 06:37:47] Processing Order ID: 265, Amount: 860, Method: upi
[2026-06-29 06:37:47] DB Connected.
[2026-06-29 06:37:47] Current Collected: 0, New Total Collected: 860 / 864
[2026-06-29 06:37:47] New Payment Status: partial
[2026-06-29 06:37:47] Orders table updated with new method: upi
[2026-06-29 06:37:47] Payments table record inserted. TXID: POS_COLL_1782715067_265
[2026-06-29 06:37:47] Transaction committed successfully.
[2026-06-29 06:38:07] --- NEW PAYMENT REQUEST ---
[2026-06-29 06:38:07] Checking dependencies...
[2026-06-29 06:38:07] Dependencies loaded.
[2026-06-29 06:38:07] Token valid. User ID: 2
[2026-06-29 06:38:07] Raw Input: {"order_id":265,"amount":4.0,"payment_method":"cash"}
[2026-06-29 06:38:07] Processing Order ID: 265, Amount: 4, Method: cash
[2026-06-29 06:38:07] DB Connected.
[2026-06-29 06:38:07] Current Collected: 860, New Total Collected: 864 / 864
[2026-06-29 06:38:07] New Payment Status: paid
[2026-06-29 06:38:07] Orders table updated with new method: cash
[2026-06-29 06:38:07] Payments table record inserted. TXID: POS_COLL_1782715087_265
[2026-06-29 06:38:07] Transaction committed successfully.
[2026-07-21 09:56:43] --- NEW PAYMENT REQUEST ---
[2026-07-21 09:56:43] Checking dependencies...
[2026-07-21 09:56:43] Dependencies loaded.
[2026-07-21 09:56:43] Token valid. User ID: 2
[2026-07-21 09:56:43] Raw Input: {"order_id":343,"amount":2200.0,"payment_method":"cash"}
[2026-07-21 09:56:43] Processing Order ID: 343, Amount: 2200, Method: cash
[2026-07-21 09:56:43] DB Connected.
[2026-07-21 09:56:43] Current Collected: 0, New Total Collected: 2200 / 2200
[2026-07-21 09:56:43] New Payment Status: paid
[2026-07-21 09:56:43] Orders table updated with new method: cash
[2026-07-21 09:56:43] Payments table record inserted. TXID: POS_COLL_1784627803_343
[2026-07-21 09:56:43] Transaction committed successfully.
[2026-07-21 10:44:35] --- NEW PAYMENT REQUEST ---
[2026-07-21 10:44:35] Checking dependencies...
[2026-07-21 10:44:35] Dependencies loaded.
[2026-07-21 10:44:35] Token valid. User ID: 2
[2026-07-21 10:44:35] Raw Input: {"order_id":342,"amount":2000.0,"payment_method":"upi"}
[2026-07-21 10:44:35] Processing Order ID: 342, Amount: 2000, Method: upi
[2026-07-21 10:44:35] DB Connected.
[2026-07-21 10:44:35] Current Collected: 0, New Total Collected: 2000 / 2352
[2026-07-21 10:44:35] New Payment Status: partial
[2026-07-21 10:44:35] Orders table updated with new method: upi
[2026-07-21 10:44:35] Payments table record inserted. TXID: POS_COLL_1784630675_342
[2026-07-21 10:44:35] Transaction committed successfully.
[2026-07-21 11:20:35] --- NEW PAYMENT REQUEST ---
[2026-07-21 11:20:35] Checking dependencies...
[2026-07-21 11:20:35] Dependencies loaded.
[2026-07-21 14:20:32] --- NEW PAYMENT REQUEST ---
[2026-07-21 14:20:32] Checking dependencies...
[2026-07-21 14:20:32] Dependencies loaded.
[2026-07-30 07:56:12] --- NEW PAYMENT REQUEST ---
[2026-07-30 07:56:12] Checking dependencies...
[2026-07-30 07:56:12] Dependencies loaded.
[2026-08-08 03:42:31] --- NEW PAYMENT REQUEST ---
[2026-08-08 03:42:31] Checking dependencies...
[2026-08-08 03:42:31] Dependencies loaded.
[2026-08-08 03:42:31] Token valid. User ID: 2
[2026-08-08 03:42:31] Raw Input: {"order_id":411,"amount":60.0,"payment_method":"cash"}
[2026-08-08 03:42:31] Processing Order ID: 411, Amount: 60, Method: cash
[2026-08-08 03:42:31] DB Connected.
[2026-08-08 03:42:31] Current Collected: 0, New Total Collected: 60 / 460
[2026-08-08 03:42:31] New Payment Status: partial
[2026-08-08 03:42:31] Orders table updated with new method: cash
[2026-08-08 03:42:31] Payments table record inserted. TXID: POS_COLL_1786160551_411
[2026-08-08 03:42:31] Transaction committed successfully.
[2026-08-16 15:13:35] --- NEW PAYMENT REQUEST ---
[2026-08-16 15:13:35] Checking dependencies...
[2026-08-16 15:13:35] Dependencies loaded.
[2026-08-30 11:55:55] --- NEW PAYMENT REQUEST ---
[2026-08-30 11:55:55] Checking dependencies...
[2026-08-30 11:55:55] Dependencies loaded.
[2026-09-02 11:30:30] --- NEW PAYMENT REQUEST ---
[2026-09-02 11:30:30] Checking dependencies...
[2026-09-02 11:30:30] Dependencies loaded.
[2026-09-11 04:32:46] --- NEW PAYMENT REQUEST ---
[2026-09-11 04:32:46] Checking dependencies...
[2026-09-11 04:32:46] Dependencies loaded.