2025-08-03 17:00:01 [INFO]: Execution Started
2025-08-03 17:00:01 [INFO]: old server sucessfully connected
2025-08-03 17:00:01 [INFO]: sqs client sucess created
2025-08-03 17:00:02 [INFO]: Number of messages in the queue: 0
2025-08-03 17:00:22 [INFO]: Execution Started
2025-08-03 17:00:22 [INFO]: Execution Finished
2025-08-03 17:10:02 [INFO]: Execution Started
2025-08-03 17:10:02 [INFO]: old server sucessfully connected
2025-08-03 17:10:02 [INFO]: sqs client sucess created
2025-08-03 17:10:03 [INFO]: Number of messages in the queue: 1
2025-08-03 17:10:03 [INFO]: item found in queue is if condition  14409
2025-08-03 17:10:03 [INFO]: item found in queue is  14409
2025-08-03 17:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEB15+VqNlDILzeC/9hNlb2Cy0lLpJOzfZPvn3gheuc8EwqHQLxQpBR9QS5uGlG89+wVcBxNpNX5NOAfwsV2HyGeyn93z7v7O4AviwHzM+hmX+NA73oFDiN/0B8h3aDAmIjpDBJCRMU8+v9xUZcTZZfQNf9Q/8lrYAwaxPH7K8R6xLktPm+62+XelWN6L6bk1zJtat8DbBeLjuBGyZqLb4gCMCc5kYm9P6nMc5cr7vexWs+/vU56hkb0EJ1lxrOewfZxun03xp/dES6bpXjdZGBJw2l2gry5QZNTJ6h1aSkLZxSte81I33fjwaVnFWSNSEBEmBqcJ5Bp1Ef1RfoR62laHExiYjnwvoLmPFBVDW1tWJ/YvL4lH1c1BukYsiUgh3nd09PfoTmtnTwlaI8vZNBNmNq2MsQu1Va5wFIwVJzXUfEdw/FohKLjm6WlEm1pH0Z
2025-08-03 17:10:04 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-03 17:10:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-03 17:10:04 [INFO]: inside itemsold and closed 14409
2025-08-03 17:10:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-03 17:10:05 [INFO]: autolink for user_id 14409 is 1
2025-08-03 17:10:05 [INFO]: not in db for user_id 14409 and the ebayitemid286738951654
2025-08-03 17:10:05 [INFO]: in processold action queue is array    for []
2025-08-03 17:10:05 [INFO]: Successfully processed data for user 14409
2025-08-03 17:10:05 [INFO]: Execution Started
2025-08-03 17:10:05 [INFO]: Execution Finished
2025-08-03 17:20:01 [INFO]: Execution Started
2025-08-03 17:20:01 [INFO]: old server sucessfully connected
2025-08-03 17:20:01 [INFO]: sqs client sucess created
2025-08-03 17:20:02 [INFO]: Number of messages in the queue: 1
2025-08-03 17:20:02 [INFO]: item found in queue is if condition  14409
2025-08-03 17:20:02 [INFO]: item found in queue is  14409
2025-08-03 17:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBmcFbIbm/Brg0sMZSqxId3sjiH2MTi627aS2EX8lVUoXZvGblg8JVopwQJqiniDGqnS00bEdbLDDqLq33Ur/CnMe7UiUVbEhNBgsXDPEjqNzfMDdORmX6+ZeV4CzhfvhqLxB62En/bR3QBWtii5FPq+dtMcqhcj3G/kxQ4GbrrmOhJsHYDgjQnLjdMNzmzXLYDXp9+okrKTtojVSg4OOKdcxyhRAKnCJImjIyMkfHStZJNR08E0AHtCmAW2YIUmKA9QdjT58n7EglpHLVmn/sF7xAEadKXSTHUB87aC/Jp8v6mDLeg+hxWN7i+10FXt46I7e3CbUbgJkA9+6UTNFuv6Y0hpLd4bYzaH0cfDHXdowijn4BI8FG+WI0NyO0PITVh4C0IXteHB5+ZaeHjb8ZCWziKY+1WPqr4ZX117Fd3ASto59H7FKfUoMUmYkdNsU0
2025-08-03 17:20:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-03 17:20:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-03 17:20:03 [INFO]: inside itemsold and closed 14409
2025-08-03 17:20:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-03 17:20:05 [INFO]: autolink for user_id 14409 is 1
2025-08-03 17:20:05 [INFO]: Ebay item id :: 304819944797 exists in Database
2025-08-03 17:20:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-03 17:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-03 17:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-03 17:20:05 [INFO]: in processold action queue is array    for {"44593017":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44593017","ebayitemid":"304819944797","shopifyproductid":"7964046491870","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"7964046491870","shopifyvariantid":"44022682648798","shopifyinventoryid":"46119283884254","shopifylocationid":"","product_id":"44593017","variant_id":"77485726","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-03 17:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-03 17:20:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-03 17:20:05 [INFO]: Shopify Inventory id 46119283884254
2025-08-03 17:20:05 [INFO]: Shopify Location id 58450641063
2025-08-03 17:20:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-03 17:20:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}}
2025-08-03 17:20:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-03 17:20:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44593017 and user_id = 14409 
2025-08-03 17:20:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77485726 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-03 17:20:05 [INFO]: updateIdsQuantity -> ["77485726"]
2025-08-03 17:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-03 17:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77485726 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77485726 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77485726)
2025-08-03 17:20:05 [INFO]: QUANTITY Updated IDs: 77485726
2025-08-03 17:20:05 [INFO]: Successfully processed data for user 14409
2025-08-03 17:20:05 [INFO]: Execution Started
2025-08-03 17:20:05 [INFO]: Execution Finished
2025-08-03 17:27:21 [INFO]: Execution Started
2025-08-03 17:27:21 [INFO]: old server sucessfully connected
2025-08-03 17:27:21 [INFO]: sqs client sucess created
2025-08-03 17:27:22 [INFO]: Number of messages in the queue: 0
2025-08-03 17:27:42 [INFO]: Execution Started
2025-08-03 17:27:42 [INFO]: Execution Finished
2025-08-03 17:30:02 [INFO]: Execution Started
2025-08-03 17:30:02 [INFO]: old server sucessfully connected
2025-08-03 17:30:02 [INFO]: sqs client sucess created
2025-08-03 17:30:03 [INFO]: Number of messages in the queue: 0
2025-08-03 17:30:23 [INFO]: Execution Started
2025-08-03 17:30:23 [INFO]: Execution Finished
2025-08-03 17:32:24 [INFO]: Execution Started
2025-08-03 17:32:24 [INFO]: old server sucessfully connected
2025-08-03 17:32:24 [INFO]: sqs client sucess created
2025-08-03 17:32:25 [INFO]: Number of messages in the queue: 0
2025-08-03 17:32:45 [INFO]: Execution Started
2025-08-03 17:32:45 [INFO]: Execution Finished
2025-08-03 17:40:01 [INFO]: Execution Started
2025-08-03 17:40:01 [INFO]: old server sucessfully connected
2025-08-03 17:40:02 [INFO]: sqs client sucess created
2025-08-03 17:40:03 [INFO]: Number of messages in the queue: 0
2025-08-03 17:40:23 [INFO]: Execution Started
2025-08-03 17:40:23 [INFO]: Execution Finished
2025-08-03 17:50:01 [INFO]: Execution Started
2025-08-03 17:50:01 [INFO]: old server sucessfully connected
2025-08-03 17:50:01 [INFO]: sqs client sucess created
2025-08-03 17:50:02 [INFO]: Number of messages in the queue: 0
2025-08-03 17:50:23 [INFO]: Execution Started
2025-08-03 17:50:23 [INFO]: Execution Finished