2025-08-14 17:00:01 [INFO]: Execution Started
2025-08-14 17:00:01 [INFO]: old server sucessfully connected
2025-08-14 17:00:01 [INFO]: sqs client sucess created
2025-08-14 17:00:04 [INFO]: Number of messages in the queue: 0
2025-08-14 17:00:24 [INFO]: Execution Started
2025-08-14 17:00:24 [INFO]: Execution Finished
2025-08-14 17:10:01 [INFO]: Execution Started
2025-08-14 17:10:01 [INFO]: old server sucessfully connected
2025-08-14 17:10:01 [INFO]: sqs client sucess created
2025-08-14 17:10:04 [INFO]: Number of messages in the queue: 0
2025-08-14 17:10:25 [INFO]: Execution Started
2025-08-14 17:10:25 [INFO]: Execution Finished
2025-08-14 17:20:01 [INFO]: Execution Started
2025-08-14 17:20:01 [INFO]: old server sucessfully connected
2025-08-14 17:20:01 [INFO]: sqs client sucess created
2025-08-14 17:20:08 [INFO]: Number of messages in the queue: 1
2025-08-14 17:20:10 [INFO]: item found in queue is if condition  14409
2025-08-14 17:20:10 [INFO]: item found in queue is  14409
2025-08-14 17:20:12 [INFO]: Message deleted from the queue for receipt handle: AQEBvPxZNkOjHWY0pBjtL2AKaEyX7MVE9fVExuSf9sZNHGo0/Vj3FFsLHnbuR2ygsW02N7L05cHmGS6mDbFaTaCe0IUEr9wKArN9ym/r0qj/oF0mh31gLfKVzDvOE/Y4L0/sMlUH6MMJrXN5KnPCWiSoAUavH2r3d0d0mpWMvdNX3od+nP+RFzVOLYH52WJQj5Ghh2E0tuLYnu5uGWqAe/vtjHPgdD4/9zbmZyTVbBk+HmcKP+hmFDgX7URXJJm0UA3rlmYIGPR8b482DpyxCciFkcW9EI9mWbhLbe7W0Hc5O08L1f/3c02dbr0VuVmcUzF2EZqoWIUG41Tf+3G83HLm+mjTD8IvrRZlUSbZSf+GOjDqI4U3qko6/Y9n+7AtT5T9iSlDJUuV2Xw2mgX/1PqsMHRq/23pWpwDmlrOlSRbgYGcL/XAAvGfLxyfyxulThXI
2025-08-14 17:20:12 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-14 17:20:12 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-14 17:20:12 [INFO]: inside itemsold and closed 14409
2025-08-14 17:20:13 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 17:20:13 [INFO]: autolink for user_id 14409 is 1
2025-08-14 17:20:13 [INFO]: Ebay item id :: 305842544698 exists in Database
2025-08-14 17:20:13 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 17:20:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-14 17:20:13 [INFO]: in processold action queue is array    for []
2025-08-14 17:20:14 [INFO]: Successfully processed data for user 14409
2025-08-14 17:20:14 [INFO]: Execution Started
2025-08-14 17:20:14 [INFO]: Execution Finished
2025-08-14 17:30:01 [INFO]: Execution Started
2025-08-14 17:30:01 [INFO]: old server sucessfully connected
2025-08-14 17:30:01 [INFO]: sqs client sucess created
2025-08-14 17:30:04 [INFO]: Number of messages in the queue: 0
2025-08-14 17:30:24 [INFO]: Execution Started
2025-08-14 17:30:24 [INFO]: Execution Finished
2025-08-14 17:40:02 [INFO]: Execution Started
2025-08-14 17:40:02 [INFO]: old server sucessfully connected
2025-08-14 17:40:02 [INFO]: sqs client sucess created
2025-08-14 17:40:04 [INFO]: Number of messages in the queue: 1
2025-08-14 17:40:05 [INFO]: item found in queue is if condition  14409
2025-08-14 17:40:05 [INFO]: item found in queue is  14409
2025-08-14 17:40:07 [INFO]: Message deleted from the queue for receipt handle: AQEBO0+6Sctd9m6RLrbLNtuIEwhLJFjkJ+0M+c1arxfs8tauR96e7zEfU95m4mHfL8iEDEyD4GEeNAUXz7JWF2e+NG9djCIqn+77McCinvwJC7EUoX2lx07tG5Ws/WHPkxbzMLfQg9BdF/6eRWCoySM3LaJSMHgkxe9GD18VGVLGzFHa0v5SItK1Vz2+Jat2Gm/9s6lZrRl/kEE5tuapf0XQLIxEhXocf5iDWUOKNJfCwRdV7WW0vnt9tJpPsSp3ac3vTAhjq06IXS495jmYH8cD+L5k0BLEtfYjZo7gTKT73IesQ3id2wUsv7DO7H046Aj0p+25Zxd2NwBti0lYBSBjON9eZL8h1xC61HDy7T0aj277ptd1k0Y+IIlIE9/TeIXjhEcledtJ6fK2G9Tpgwx9XHn576AWUNVW3Kdj4xfF1Ivspg4NlwHrIkSHBUAW+pym
2025-08-14 17:40:07 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-14 17:40:07 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-14 17:40:07 [INFO]: inside itemsold and closed 14409
2025-08-14 17:40:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 17:40:09 [INFO]: autolink for user_id 14409 is 1
2025-08-14 17:40:09 [INFO]: Ebay item id :: 336121361525 exists in Database
2025-08-14 17:40:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 17:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-14 17:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-14 17:40:09 [INFO]: in processold action queue is array    for {"45314151":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45314151","ebayitemid":"336121361525","shopifyproductid":"8985790513374","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8985790513374","shopifyvariantid":"47441106960606","shopifyinventoryid":"49552997744862","shopifylocationid":"58450641063","product_id":"45314151","variant_id":"78266664","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-14 17:40:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-14 17:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-14 17:40:09 [INFO]: Shopify Inventory id 49552997744862
2025-08-14 17:40:09 [INFO]: Shopify Location id 58450641063
2025-08-14 17:40:09 [INFO]: QUANTITY FOR UPDATE 0
2025-08-14 17:40:09 [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 17:40:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-14 17:40:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45314151 and user_id = 14409 
2025-08-14 17:40:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266664 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-14 17:40:09 [INFO]: updateIdsQuantity -> ["78266664"]
2025-08-14 17:40:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 0
2025-08-14 17:40:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 78266664 THEN 0  END, 
					  quantityflag = CASE WHEN id = 78266664 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (78266664)
2025-08-14 17:40:09 [INFO]: QUANTITY Updated IDs: 
2025-08-14 17:40:09 [INFO]: Successfully processed data for user 14409
2025-08-14 17:40:09 [INFO]: Execution Started
2025-08-14 17:40:09 [INFO]: Execution Finished
2025-08-14 17:50:02 [INFO]: Execution Started
2025-08-14 17:50:02 [INFO]: old server sucessfully connected
2025-08-14 17:50:02 [INFO]: sqs client sucess created
2025-08-14 17:50:06 [INFO]: Number of messages in the queue: 1
2025-08-14 17:50:06 [INFO]: item found in queue is if condition  14409
2025-08-14 17:50:06 [INFO]: item found in queue is  14409
2025-08-14 17:50:07 [INFO]: Message deleted from the queue for receipt handle: AQEB+bpLKKZIBbrCKAr+iWMwqia6YXizF8g3OBMQv+QRbCKCCng+1fFtFA/cKJgrvteJLLjJ367kC6ypQpkSrbtNIQ1W0xJSKnY0smH7bkzRAUL/e5kZKi7hIm3sWGEphjOUJhkrv0uKTUhAuFeyEECmDZ4Qx4/aaPYSNeK2uDhBAzrdtqroIh+VMxl2YBr6DUOIyGCH+9QuzTaWfwQudE2hD/Nnm/AxjHbh215Z6Cp1BIR+SDksEvG1eesp+mfqg+HzI2UO5AB4zQGGP7kg67be/V/P8pcG2wxvf1Tb0jvM829Q7YsfpJuxLT7JKJlQieusAGEzJLixXwk6HXYHboBrmGRXXmYAB6jOPIp83jwg2fgNyYEmM23HK+ziwuDcZNdBd3Aw6e8nEYaI5SDMaTPavKqRmB9acwtcKk5DTnx6rZib+3tWdYSXDKT3pUqTuFsI
2025-08-14 17:50:07 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-14 17:50:07 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-14 17:50:07 [INFO]: inside itemsold and closed 14409
2025-08-14 17:50:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 17:50:08 [INFO]: autolink for user_id 14409 is 1
2025-08-14 17:50:08 [INFO]: Ebay item id :: 326535682041 exists in Database
2025-08-14 17:50:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 17:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-14 17:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-14 17:50:08 [INFO]: in processold action queue is array    for {"44651895":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44651895","ebayitemid":"326535682041","shopifyproductid":"8878305804510","variants":[{"price":"34.99","quantity":0,"weight":"0.75","shopifyproductid":"8878305804510","shopifyvariantid":"46620011200734","shopifyinventoryid":"48722905956574","shopifylocationid":"","product_id":"44651895","variant_id":"77557084","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-14 17:50:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-14 17:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-14 17:50:09 [INFO]: Shopify Inventory id 48722905956574
2025-08-14 17:50:09 [INFO]: Shopify Location id 58450641063
2025-08-14 17:50:09 [INFO]: QUANTITY FOR UPDATE 0
2025-08-14 17:50:09 [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-14 17:50:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-14 17:50:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44651895 and user_id = 14409 
2025-08-14 17:50:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77557084 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-14 17:50:09 [INFO]: updateIdsQuantity -> ["77557084"]
2025-08-14 17:50:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-14 17:50:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77557084 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77557084 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77557084)
2025-08-14 17:50:09 [INFO]: QUANTITY Updated IDs: 77557084
2025-08-14 17:50:09 [INFO]: Successfully processed data for user 14409
2025-08-14 17:50:09 [INFO]: Execution Started
2025-08-14 17:50:09 [INFO]: Execution Finished