2025-08-14 16:00:02 [INFO]: Execution Started
2025-08-14 16:00:02 [INFO]: old server sucessfully connected
2025-08-14 16:00:02 [INFO]: sqs client sucess created
2025-08-14 16:00:06 [INFO]: Number of messages in the queue: 3
2025-08-14 16:00:07 [INFO]: item found in queue is if condition  14409
2025-08-14 16:00:07 [INFO]: item found in queue is  14409
2025-08-14 16:00:07 [INFO]: Message deleted from the queue for receipt handle: AQEByBpEAzwdFZU5+OblAiscBhRiVmSLssqJ/MJItgDN9JZKwBr4lcMrCP7JcVDSrmib3J7H2qw3tplhZHKSILwqV5G1xaexR4Espb8on13LEbF+tRDPnS0Xxihqxpq91121Sjkba2qzRVM41gjvOQ8i8I/tEYUOzxGMWZdV9MAzbWLHHfgTtz/6inPCWJ3qt4UWunv/jI+siJavm9Ho/hq2jKpRfiRZhmvmcuTx1ewtqyN7RRujr20UgJlTa42pUVCNUs5muHk3eTxOZX7fU7HA0KqX9yI7zYfgnmMgaE6J8InNKl8qfrwSYkjbGduV/eFwdvAFBpK2YFGdzkMOapm9PGonUwNl2mmKJvW+c6QOS5ZwlTfZXZJCMygx81zEpF9ZkDG+B8XkiOzzUI7Hhka1TRiRYMiXZLekN11ODOP8931ypGNkBHmNd1i13eqxWrvx
2025-08-14 16:00:08 [INFO]: item found in queue is if condition  14409
2025-08-14 16:00:08 [INFO]: item found in queue is  14409
2025-08-14 16:00:09 [INFO]: Message deleted from the queue for receipt handle: AQEBIcdkArtT7vcHGbeVOKYYaBnJpdUWx9zj08FJATRtrAprTjNCr7vAm3CxFtd1IuqTJQHHkg7tHiX/Fk1B7E4ufHkRDKKZLc1LH+wiIR6Ajv3qO/RT4ZWdt5Pj6L2GTZ9Ter9D7116qxbKPkZOuiY9H1V0CFeFK7uQVADjazNuq1uT9jXkt51Mx7Et0ZTno7vJIH206QGoqrRqeEX9UvUWxMlQr400sjkTA1+SY+dlgLB4JdoX/bHjyt9Rf2Bx0R+A6H4E7Z3iOOd3v3Lu5xhN4YqB/2PdCZTPD00Mba1qxTKf0G9HgQSTSW83ZXazRZzRbyoHPJ5SiXxrvGawuJJtjQgNkuUUiN+9zxdNobA6PcmLJ0JKh8Sm9m+LvQ/ePs0+bIePlHvvH+Umi8PUXzAYu1QpnMyG3tIMPIlzxAOKNKSw8qhTat6wP5/5WaYTXcxt
2025-08-14 16:00:10 [INFO]: item found in queue is if condition  14409
2025-08-14 16:00:10 [INFO]: item found in queue is  14409
2025-08-14 16:00:11 [INFO]: Message deleted from the queue for receipt handle: AQEB4/oamJdYcHOKunMZFJBZtAb3bRfKk6ehhN0OgRJqb3sRBk+4RtbG3zRBhJ4aV1u6v6HflsCtPWNFCvGmr8/1IX53HIyBCqia/QUqI1xBscr0PiTzIdr+9OoPaMqoGiRLnSQZonk9EpbTA0CtsbioIQKZ+1GMPPICurcGVcczs3D1uPH94ibDeOlciItGGUSd8SHEWW2JPByX7ygePr4a4TuYEuHFBLoQ7N/OwReKACF7gEAv5hLu61x93Wipyx0bDBZwbhjDNCClHjts/fF4epoS32NN3wxUb+MnNvuLwYoZ91GINeMYoNwiHtO7Hx2Y3Rkor+wHSnfsriXvwod4XpL+CP1RnlrjpkuOh2fBQzZb9nt1x9w8yshk0wRS9RxIA4jmPjx3p0e57J4gMRCj5drU6fs+r1brcPentdMoa6nQ44c5JQUqwHPO/nUfN6Hg
2025-08-14 16:00:11 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-14 16:00:11 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-14 16:00:11 [INFO]: inside itemsold and closed 14409
2025-08-14 16:00:13 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 16:00:13 [INFO]: autolink for user_id 14409 is 1
2025-08-14 16:00:13 [INFO]: Ebay item id :: 332430782971 exists in Database
2025-08-14 16:00:13 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 16:00:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-14 16:00:13 [INFO]: inside itemsold and closed 14409
2025-08-14 16:00:15 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 16:00:15 [INFO]: autolink for user_id 14409 is 1
2025-08-14 16:00:15 [INFO]: Ebay item id :: 306407780758 exists in Database
2025-08-14 16:00:15 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 16:00:15 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-14 16:00:15 [INFO]: inside itemsold and closed 14409
2025-08-14 16:00:16 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 16:00:16 [INFO]: autolink for user_id 14409 is 1
2025-08-14 16:00:16 [INFO]: Ebay item id :: 406073526363 exists in Database
2025-08-14 16:00:16 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 16:00:16 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-14 16:00:16 [INFO]: in processold action queue is array    for {"45274696":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45274696","ebayitemid":"306407780758","deleted":1}},"45288044":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45288044","ebayitemid":"406073526363","deleted":1}}}
2025-08-14 16:00:16 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-14 16:00:16 [INFO]: productIds WHich are having null productid -> [45274696,45288044]
2025-08-14 16:00:16 [INFO]: ebayItemIds WHich are not imported-> ["306407780758","406073526363"]
2025-08-14 16:00:16 [INFO]: Entered in bulkUpdateProducts function
2025-08-14 16:00:16 [INFO]: Transaction started for bulkUpdateProducts
2025-08-14 16:00:16 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45274696,45288044)
2025-08-14 16:00:16 [INFO]: Query executed successfully. Affected rows: 0
2025-08-14 16:00:16 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-14 16:00:16 [INFO]: Transaction committed successfully.
2025-08-14 16:00:16 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-14 16:00:16 [INFO]: Successfully processed data for user 14409
2025-08-14 16:00:16 [INFO]: Execution Started
2025-08-14 16:00:16 [INFO]: Execution Finished
2025-08-14 16:10:01 [INFO]: Execution Started
2025-08-14 16:10:01 [INFO]: old server sucessfully connected
2025-08-14 16:10:01 [INFO]: sqs client sucess created
2025-08-14 16:10:04 [INFO]: Number of messages in the queue: 1
2025-08-14 16:10:05 [INFO]: item found in queue is if condition  14409
2025-08-14 16:10:05 [INFO]: item found in queue is  14409
2025-08-14 16:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBo+p/iQi3bAGWMgrEraa67g7qphrtFZeGCwfTBJOdvptQ5QL9uBGc8QDUXXDg0tvu7/2uaEGsEWv4pljcnJem8LFXQxN1IwgSM9HdSgHWUzwsC/K+xl2EI5+JH+RjGxSpbFoONgoZGjRr5fnF5eO04dnfndSE3Xrlyu5j4TPjUztrY4hap6iqs2fIql3jbstagdDfdtPlamCL1UhD9D4OATDRRV2juTAydy7xkl4rrwoaC/reReV6fa+nXzDaUhXtaN2i2rD7LEpGxABIucyQBz3lDHbEkotoBjB5ob2nB0iZF/RyqyAcQF05VnndKojMHtgzGiuGaG36Yg/wbrnLWcGKBLdSBqIZDQDTgyRW0FJ8WFXg7kPM71phitRtNXi8QV8SdjXaxWaE6yCKrijmpmAyYzkTi74Z+3BJ0yBsRtecg6Bf2w0Ys64dkIYPsRM+
2025-08-14 16:10:05 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-14 16:10:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-14 16:10:05 [INFO]: inside itemsold and closed 14409
2025-08-14 16:10:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 16:10:07 [INFO]: autolink for user_id 14409 is 1
2025-08-14 16:10:07 [INFO]: Ebay item id :: 336008209187 exists in Database
2025-08-14 16:10:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 16:10:07 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-14 16:10:07 [INFO]: in processold action queue is array    for {"45113676":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45113676","ebayitemid":"336008209187","deleted":1}}}
2025-08-14 16:10:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-14 16:10:07 [INFO]: productIds WHich are having null productid -> [45113676]
2025-08-14 16:10:07 [INFO]: ebayItemIds WHich are not imported-> ["336008209187"]
2025-08-14 16:10:07 [INFO]: Entered in bulkUpdateProducts function
2025-08-14 16:10:07 [INFO]: Transaction started for bulkUpdateProducts
2025-08-14 16:10:07 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45113676)
2025-08-14 16:10:07 [INFO]: Query executed successfully. Affected rows: 0
2025-08-14 16:10:07 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-14 16:10:07 [INFO]: Transaction committed successfully.
2025-08-14 16:10:07 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-14 16:10:07 [INFO]: Successfully processed data for user 14409
2025-08-14 16:10:07 [INFO]: Execution Started
2025-08-14 16:10:07 [INFO]: Execution Finished
2025-08-14 16:20:01 [INFO]: Execution Started
2025-08-14 16:20:01 [INFO]: old server sucessfully connected
2025-08-14 16:20:01 [INFO]: sqs client sucess created
2025-08-14 16:20:06 [INFO]: Number of messages in the queue: 4
2025-08-14 16:20:06 [INFO]: item found in queue is if condition  14409
2025-08-14 16:20:06 [INFO]: item found in queue is  14409
2025-08-14 16:20:07 [INFO]: Message deleted from the queue for receipt handle: AQEBGWtf2KLrrgucGUVSreQ35WsFhbk3v/dTQNepqD29IpC+yvyC2o5sAEoBOeVYqXcRHkwfEpV5myTt5wzD4I4+FFCIiEox435wVGWDl9BoJVcjkmN8pADQ7gLbJPSH4kgse5XyDohpUDQpBDwR6XnMedUkGJoKhCOvmxs24PFxKRBNEbXU3j30h9vK0BFghy+NR0gohTMcu4xiXjksDAAz7dqnhYkg0g6DfjeJV9rhV4yO2/bwfNkAipqQ0jzlhiTqF7dWHE3l3gV3bpDVNkIYGHEPZzEjAT35SeffnnGMnSxryecbyng/r4HUurFRhuzh6m45EwXwxbDX3vIPquTQWK1jrMqHG2ak/2T1e85Vx5GRLbpiO1v3dJ8x5dvRFzfYlm0GfRW8K6W9pKyAenUgOTEriO5bRoH545vjxcrrLMQ50ACAwbSrtGVJIrWK4jKm
2025-08-14 16:20:08 [INFO]: item found in queue is if condition  14409
2025-08-14 16:20:08 [INFO]: item found in queue is  14409
2025-08-14 16:20:08 [INFO]: Message deleted from the queue for receipt handle: AQEBJrpXqXmSKqFqAlLbHBkCHbV40MEyI51l6SiYbWIIQKOgSnzoJfixsGq25yMbx9hM1EcO0zlOw0vsczEwHF8aX2PJqTZqUJeeKMnNSPQ/Iip0R0L54vhP630G5K/xj+CF10Z23pDUxT0PiDPArAsga0rVY0aMNxpa1pzE5Sgd0Lge4fbNvI1vvO4NINoOxXiszaFnS/hBp7wjKwOod7pbiGg0ox4i+61jiM8Yqz07qr8HHpG5WtlLHqCVvV9RlKo9Av5VAB0eWrxkZ5gTsBZFAIXQQQSs7qat/5XfQDD5j3xTvnWVwKdltJtMzIwoP2eqGCHSN6j6sUl+zxSJ2UB5lZJFJhksHwi6yjJsqey+HiIO1CXQ1xvnTXg+CtN5Lw5ENoCFvPLUqA38H3EWJNKwCPA9eamzpk/GZ+o4icMI4JlJ8Yy3O905BiEYPHZplEuk
2025-08-14 16:20:09 [INFO]: item found in queue is if condition  14409
2025-08-14 16:20:09 [INFO]: item found in queue is  14409
2025-08-14 16:20:09 [INFO]: Message deleted from the queue for receipt handle: AQEBm2vnok/+6IVIX9pR/oZS7S/ysfBK3zP1B9tP25ZbawueiPjkec5INBUwbD+gudO/A9IjHUhKhABzk8pIbwKz1BknGBWqeyXdAbpAjZP4SIr3LNZECIGxBDuS3xa0ExdBPHC1YqF9ZL/fsSvm2fTDwU3B7tmnKiiMAv59wapY42AT0iXUN0lIV3+7uSQrVutaQy4cH2piAQLR0k/sjZGsj85QY1w3boPs6vL43EPzN/DaiBfOE3E++X4PlTx8DUo9oLE8li/37Xr8rDSc+g17TCJLvdgQgo9LYyQC1A2gG8KH3MPTiNb5DS1z3tehaNvPVEyU1xrph7pHZnaVtXZuIZxssekpl+BLmj+AkfQpPrhYsgHB0j+0D+80kJHbi7lED+6aQeSpy7wAKIoKy8XVyEn4voRFec/FD3QntIAcUFyrW3jBqHw1hH1o0zCc3LpB
2025-08-14 16:20:09 [INFO]: item found in queue is if condition  14409
2025-08-14 16:20:09 [INFO]: item found in queue is  14409
2025-08-14 16:20:10 [INFO]: Message deleted from the queue for receipt handle: AQEBhlqvba6pJMXBzdjHK3W3URsuauovUhU6qrLvnrP+xgJnhgWIYr5Ph36YbHrbDrJ2YwHPJyTz9Dzw2YeSLiuowAi81g2kbXmiHfXxIcynM1psxOcxttj2+EYqK8NaVjrJGJfNnz1NRZ4hGzD6L8xZXKsUpYuOWCDjfRWfYrMNMGtnCKppPXrk+4aB9Hh6GoOUjwQNYx2zt8GzsUotqriVXGe5qOqtZoR44+cttyLUIaZOgilYK9CT6xGtfmrD7t0NTl3iJKYYhv323Hum54eoScvYP/tpcvuemfOfCNNgokhv/e9K0QJV0WHDNJZhd8A35waJEXEIXgza8yBUPG9pqg4uPxzOfjMr17sYM0OEPdnP7ljijQJULsZAPBYLX2TdX5vmJS5aA9pnAx155chWVEvWpvbZRYs2+vgDBULJpIIInrqaZJ4KAxL7Oo9C1lwO
2025-08-14 16:20:10 [INFO]: Processed 4 messages, reached the limit of 4.
2025-08-14 16:20:10 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-14 16:20:10 [INFO]: inside itemsold and closed 14409
2025-08-14 16:20:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 16:20:12 [INFO]: autolink for user_id 14409 is 1
2025-08-14 16:20:12 [INFO]: Ebay item id :: 226752088785 exists in Database
2025-08-14 16:20:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 16:20:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-14 16:20:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-14 16:20:12 [INFO]: inside itemsold and closed 14409
2025-08-14 16:20:14 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 16:20:14 [INFO]: autolink for user_id 14409 is 1
2025-08-14 16:20:14 [INFO]: Ebay item id :: 406123397262 exists in Database
2025-08-14 16:20:14 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 16:20:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-14 16:20:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-14 16:20:14 [INFO]: inside itemsold and closed 14409
2025-08-14 16:20:15 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 16:20:15 [INFO]: autolink for user_id 14409 is 1
2025-08-14 16:20:15 [INFO]: Ebay item id :: 335930213600 exists in Database
2025-08-14 16:20:15 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 16:20:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-14 16:20:15 [INFO]: inside itemsold and closed 14409
2025-08-14 16:20:17 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 16:20:17 [INFO]: autolink for user_id 14409 is 1
2025-08-14 16:20:17 [INFO]: Ebay item id :: 286416330529 exists in Database
2025-08-14 16:20:17 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 16:20:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-14 16:20:17 [INFO]: in processold action queue is array    for {"44791154":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44791154","ebayitemid":"226752088785","shopifyproductid":"8918138323166","variants":[{"price":"19.99","quantity":0,"weight":"1","shopifyproductid":"8918138323166","shopifyvariantid":"46733782876382","shopifyinventoryid":"48832270172382","shopifylocationid":"58450641063","product_id":"44791154","variant_id":"77701403","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45313977":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313977","ebayitemid":"406123397262","shopifyproductid":"8984858722526","variants":[{"price":"14.99","quantity":0,"weight":"2","shopifyproductid":"8984858722526","shopifyvariantid":"47438268825822","shopifyinventoryid":"49550134673630","shopifylocationid":"58450641063","product_id":"45313977","variant_id":"78266490","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-14 16:20:17 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-14 16:20:17 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-14 16:20:17 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-14 16:20:17 [INFO]: Shopify Inventory id 48832270172382
2025-08-14 16:20:17 [INFO]: Shopify Location id 58450641063
2025-08-14 16:20:17 [INFO]: QUANTITY FOR UPDATE 0
2025-08-14 16:20:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1978,"restoreRate":100}}}}
2025-08-14 16:20:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-14 16:20:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44791154 and user_id = 14409 
2025-08-14 16:20:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77701403 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-14 16:20:17 [INFO]: Shopify Inventory id 49550134673630
2025-08-14 16:20:17 [INFO]: Shopify Location id 58450641063
2025-08-14 16:20:17 [INFO]: QUANTITY FOR UPDATE 0
2025-08-14 16:20:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T16:20:18Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1978,"restoreRate":100}}}}
2025-08-14 16:20:18 [INFO]: Change: available | Delta: -1
2025-08-14 16:20:18 [INFO]: Change: on_hand | Delta: -1
2025-08-14 16:20:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-14 16:20:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313977 and user_id = 14409 
2025-08-14 16:20:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266490 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-14 16:20:18 [INFO]: updateIdsQuantity -> ["77701403","78266490"]
2025-08-14 16:20:18 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 1
2025-08-14 16:20:18 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77701403 THEN 0 WHEN id = 78266490 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77701403 THEN 0 WHEN id = 78266490 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77701403,78266490)
2025-08-14 16:20:18 [INFO]: QUANTITY Updated IDs: 77701403, 78266490
2025-08-14 16:20:18 [INFO]: Successfully processed data for user 14409
2025-08-14 16:20:18 [INFO]: Execution Started
2025-08-14 16:20:18 [INFO]: Execution Finished
2025-08-14 16:30:01 [INFO]: Execution Started
2025-08-14 16:30:01 [INFO]: old server sucessfully connected
2025-08-14 16:30:01 [INFO]: sqs client sucess created
2025-08-14 16:30:03 [INFO]: Number of messages in the queue: 0
2025-08-14 16:30:23 [INFO]: Execution Started
2025-08-14 16:30:23 [INFO]: Execution Finished
2025-08-14 16:40:01 [INFO]: Execution Started
2025-08-14 16:40:01 [INFO]: old server sucessfully connected
2025-08-14 16:40:01 [INFO]: sqs client sucess created
2025-08-14 16:40:05 [INFO]: Number of messages in the queue: 2
2025-08-14 16:40:06 [INFO]: item found in queue is if condition  14409
2025-08-14 16:40:06 [INFO]: item found in queue is  14409
2025-08-14 16:40:06 [INFO]: Message deleted from the queue for receipt handle: AQEBkd31MMkMqkbV+UMKNcShF2zHPI++A9hwR7UZlozUBrq460Bf/dT6/e+icX5lfynk2f5yRwd/RNVBs/tAdBLOk3wmweDBv6qZyLgy3UVoqkgdUokp388kXW4q/zntyiPPi6g2aAkSIkhSHs/WmBQAJJxORcFBRloVaTV5AbywnJ3J6HUsET25J0fhuqSrHq4ee14n6YM48UaeTVbn8YH4bfz0jpYjVxZFoHBLGJKrE771W1NxiXWZFwxJ46013Av91XEFEnU2ft/PlCos+/CWkMS4HTfzYmXq53BF2ugx/O/OuTsbeH08zyRFfR+PpFgAXCjOX6YIDeL48/KFpBuBhQFilzbznUBV4xpVzeV1sMGz6AwoxgjGkvx/pKQDyyIS0cG/0hpZ0jlaOwTDl8ot84dUX8rSI2f8YjJh1QLqoyzG8WSpy+Gn3Rh0pCb73TsQ
2025-08-14 16:40:07 [INFO]: item found in queue is if condition  14409
2025-08-14 16:40:07 [INFO]: item found in queue is  14409
2025-08-14 16:40:08 [INFO]: Message deleted from the queue for receipt handle: AQEBfULzL7tSlWgHWT5WV7qnrAZM9eQgE89m0TjrN5PaAcVk93GWmCm4DYNWKRMx3/FkJvTyfWd7yDIrJ30JpksVDPgZ9WGyHgvm7ZNoxhPkRitkJ8F6jrY9oClPYrAFRS2gbzJuLK/SS7BD9EKDBij+9j90V3BoqKxlcetubsvP4v91pqU6pPs547EOArv7v7sg701RhTLa1Ic88NfFqX8F7RS4eqrG3z470yLcD1oSgDad+f/F/80xMFSkl4oxC1XSHe8WmUkkIpyW7N7qkX3XHGAlkGRf27ZDmun9huM1elsB93Tgc4dDdpMUtev2TT3JhGvEsWk/6g1Sg2WBKrOzNlbhnFUEtAQzVZJaFtPJUEv2cM/bP53LzwmtdtC1J03pFmDjHYFj7Jzk9We/HlyVcVYx4nyHuRngXDCKSbOOgz1hBGA6oqbbCKXOYO0YxHUC
2025-08-14 16:40:08 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-14 16:40:08 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-14 16:40:08 [INFO]: inside itemsold and closed 14409
2025-08-14 16:40:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 16:40:09 [INFO]: autolink for user_id 14409 is 1
2025-08-14 16:40:09 [INFO]: Ebay item id :: 405929214935 exists in Database
2025-08-14 16:40:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 16:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-14 16:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-14 16:40:09 [INFO]: inside itemsold and closed 14409
2025-08-14 16:40:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 16:40:11 [INFO]: autolink for user_id 14409 is 1
2025-08-14 16:40:11 [INFO]: Ebay item id :: 286350217170 exists in Database
2025-08-14 16:40:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 16:40:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-14 16:40:11 [INFO]: in processold action queue is array    for {"44651112":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44651112","ebayitemid":"405929214935","shopifyproductid":"8156876144862","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8156876144862","shopifyvariantid":"44416357466334","shopifyinventoryid":"46514111807710","shopifylocationid":"","product_id":"44651112","variant_id":"77556301","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-14 16:40:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-14 16:40:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-14 16:40:11 [INFO]: Shopify Inventory id 46514111807710
2025-08-14 16:40:11 [INFO]: Shopify Location id 58450641063
2025-08-14 16:40:11 [INFO]: QUANTITY FOR UPDATE 0
2025-08-14 16:40:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T16:40:11Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1976,"restoreRate":100}}}}
2025-08-14 16:40:11 [INFO]: Change: available | Delta: -1
2025-08-14 16:40:11 [INFO]: Change: on_hand | Delta: -1
2025-08-14 16:40:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-14 16:40:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44651112 and user_id = 14409 
2025-08-14 16:40:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77556301 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-14 16:40:11 [INFO]: updateIdsQuantity -> ["77556301"]
2025-08-14 16:40:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-14 16:40:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77556301 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77556301 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77556301)
2025-08-14 16:40:11 [INFO]: QUANTITY Updated IDs: 77556301
2025-08-14 16:40:11 [INFO]: Successfully processed data for user 14409
2025-08-14 16:40:11 [INFO]: Execution Started
2025-08-14 16:40:11 [INFO]: Execution Finished
2025-08-14 16:50:01 [INFO]: Execution Started
2025-08-14 16:50:01 [INFO]: old server sucessfully connected
2025-08-14 16:50:01 [INFO]: sqs client sucess created
2025-08-14 16:50:05 [INFO]: Number of messages in the queue: 0
2025-08-14 16:50:27 [INFO]: Execution Started
2025-08-14 16:50:27 [INFO]: Execution Finished