2025-08-08 13:00:01 [INFO]: Execution Started
2025-08-08 13:00:01 [INFO]: old server sucessfully connected
2025-08-08 13:00:01 [INFO]: sqs client sucess created
2025-08-08 13:00:03 [INFO]: Number of messages in the queue: 1
2025-08-08 13:00:04 [INFO]: item found in queue is if condition  14409
2025-08-08 13:00:04 [INFO]: item found in queue is  14409
2025-08-08 13:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBaU1oKypp/xzMrw2KB1bXmAh6LcT7XoRVRTJvfx00026nADorMNeSYwwEOK2z+M1niAW11Y0WOLK1+XFf1MyaQfxI4gTpj+/k1V9R92QYQySSxT4NBKXAx9p5CgS63vCuDFfrxSwwv7HicjAqc/N0bl8op1iZU5IdhyXsFsRYTBg40sCALeLmsoOvUPJBExCVl79J1nzbibU6w5l8zjkLfPm5uSCV2Zt0KQPiZSwsX2d7e0GVhc0AWoGN/W+r5R0hpLO7L/e2/7aYYABHBo0tAFUYAt4FO0z5EUXddqQdsg1bNaSEmLqOVuNftoaLY7F3B5f9+dw93kydz9OaNuCuG029izfEZhJF0wcj/1DXXYZM/qlRuAJBv766ZxIuJr2z0bNvZTcx5W8K8JfOtYvYb3nECprKdWbjGUkMLt2cm7igHvcaYf3N+2vNVohVHh+j
2025-08-08 13:00:05 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-08 13:00:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-08 13:00:05 [INFO]: inside itemsold and closed 14409
2025-08-08 13:00:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 13:00:07 [INFO]: autolink for user_id 14409 is 1
2025-08-08 13:00:07 [INFO]: Ebay item id :: 405409478543 exists in Database
2025-08-08 13:00:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 13:00:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 13:00:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 13:00:07 [INFO]: in processold action queue is array    for {"44777264":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44777264","ebayitemid":"405409478543","shopifyproductid":"8758744482014","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8758744482014","shopifyvariantid":"46136323997918","shopifyinventoryid":"48235536122078","shopifylocationid":"","product_id":"44777264","variant_id":"77685806","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-08 13:00:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-08 13:00:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 13:00:07 [INFO]: Shopify Inventory id 48235536122078
2025-08-08 13:00:07 [INFO]: Shopify Location id 58450641063
2025-08-08 13:00:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 13:00:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T13:00:07Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-08 13:00:07 [INFO]: Change: available | Delta: -1
2025-08-08 13:00:07 [INFO]: Change: on_hand | Delta: -1
2025-08-08 13:00:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 13:00:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44777264 and user_id = 14409 
2025-08-08 13:00:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685806 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 13:00:07 [INFO]: updateIdsQuantity -> ["77685806"]
2025-08-08 13:00:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-08 13:00:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77685806 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77685806 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77685806)
2025-08-08 13:00:07 [INFO]: QUANTITY Updated IDs: 77685806
2025-08-08 13:00:07 [INFO]: Successfully processed data for user 14409
2025-08-08 13:00:07 [INFO]: Execution Started
2025-08-08 13:00:07 [INFO]: Execution Finished
2025-08-08 13:10:01 [INFO]: Execution Started
2025-08-08 13:10:01 [INFO]: old server sucessfully connected
2025-08-08 13:10:01 [INFO]: sqs client sucess created
2025-08-08 13:10:03 [INFO]: Number of messages in the queue: 0
2025-08-08 13:10:24 [INFO]: Execution Started
2025-08-08 13:10:24 [INFO]: Execution Finished
2025-08-08 13:20:01 [INFO]: Execution Started
2025-08-08 13:20:01 [INFO]: old server sucessfully connected
2025-08-08 13:20:01 [INFO]: sqs client sucess created
2025-08-08 13:20:07 [INFO]: Number of messages in the queue: 1
2025-08-08 13:20:09 [INFO]: item found in queue is if condition  14409
2025-08-08 13:20:09 [INFO]: item found in queue is  14409
2025-08-08 13:20:16 [INFO]: Message deleted from the queue for receipt handle: AQEBu9Ncp5pTEvt/+zHDuZcTBs3/GSOhxFG/xFe2k3VX/bFlOPqhPTXpGwVL/ijNXfk06IRF4sxbI93Bj6ZbUxp+fnss7ltnoDSycFNlpKQbNdnMeoezJw8JRZ26keUUR1J5GoO+HMwZkpthjhG1Q2fMT/A2J1weTo2gyRbslcP/OVz+om7ALGgsTALWADNwFEQt7ZMtgDZSZGQLU5yZT4fQKNBXpo3pncmqBrZ0+17dWMgpCLeHxAGQF5oUXZCOKtTOqmBxqHtqQAmRWJDlOSjxJ7UMvzeVa2Be2ZVXShaPcIvA4QhX4Iz8Qg6Zuh8JTxQU58m8QIa+Pe9YLVWSb+3JCmMtjItg2ooaEpRdCWCPEIOfNDVF8ub1aJk25maAQFsB+d3TlZlVHT/hJV5/AAiDRwT54xvoOpdsdiMZFw+hVO+/+eycIvIzZHnC4gAWhxcQ
2025-08-08 13:20:16 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-08 13:20:16 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-08 13:20:16 [INFO]: inside itemsold and closed 14409
2025-08-08 13:20:18 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 13:20:18 [INFO]: autolink for user_id 14409 is 1
2025-08-08 13:20:18 [INFO]: Ebay item id :: 404751444301 exists in Database
2025-08-08 13:20:18 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 13:20:18 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 13:20:18 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 13:20:18 [INFO]: in processold action queue is array    for {"44657953":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44657953","ebayitemid":"404751444301","shopifyproductid":"8257140457694","variants":[{"price":"49.99","quantity":0,"weight":"3","shopifyproductid":"8257140457694","shopifyvariantid":"44684504432862","shopifyinventoryid":"46782465409246","shopifylocationid":"","product_id":"44657953","variant_id":"77563173","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-08 13:20:18 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-08 13:20:18 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 13:20:18 [INFO]: Shopify Inventory id 46782465409246
2025-08-08 13:20:18 [INFO]: Shopify Location id 58450641063
2025-08-08 13:20:18 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 13:20:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T13: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":1989,"restoreRate":100}}}}
2025-08-08 13:20:18 [INFO]: Change: available | Delta: -1
2025-08-08 13:20:18 [INFO]: Change: on_hand | Delta: -1
2025-08-08 13:20:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 13:20:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44657953 and user_id = 14409 
2025-08-08 13:20:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77563173 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 13:20:18 [INFO]: updateIdsQuantity -> ["77563173"]
2025-08-08 13:20:18 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-08 13:20:18 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77563173 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77563173 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77563173)
2025-08-08 13:20:18 [INFO]: QUANTITY Updated IDs: 77563173
2025-08-08 13:20:18 [INFO]: Successfully processed data for user 14409
2025-08-08 13:20:18 [INFO]: Execution Started
2025-08-08 13:20:18 [INFO]: Execution Finished
2025-08-08 13:30:01 [INFO]: Execution Started
2025-08-08 13:30:01 [INFO]: old server sucessfully connected
2025-08-08 13:30:01 [INFO]: sqs client sucess created
2025-08-08 13:30:03 [INFO]: Number of messages in the queue: 5
2025-08-08 13:30:04 [INFO]: item found in queue is if condition  14409
2025-08-08 13:30:04 [INFO]: item found in queue is  14409
2025-08-08 13:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBaK0uMfbW9Cab733MnUmQ1zdFsTTIjFxjw/cWL4+ordmjqkbsq9/USFWwPbRzgK/YsC90PCN1Ps4IAL3nJbUyLItGAjziLpvrYcCSMhFDuwgkwoiCa8WY6x8FkZTSKDAVWJ98VKtdj3uDsFCcioqBWaFfIKddVXfNkSIAHS2Bkn+iEP2lXWqVGi6ilATBkyJLQg9PQ79wvBHvvWh14c3c9vNtuiWsxDan4QUEaZ4bZsuZgXYqcrXdpyEsvx8K3GIavRhGKcxdfZUS13hnF/WR9TSwCLuLdeZ0J8fPuvObnoEzD2Wofh3HwXLeu8pWjEuOy0R4rtyMJAAZfZu1noRlDUMvZBhWzCogA699RH8Hn/OM9OYo0aS0nzIt1BklDNc43dRW/fXSkTis/NeE0AAs8i0WRlc6UMHumVgHNiFK07FDEV11pdZXBbLukqdZmVWM
2025-08-08 13:30:05 [INFO]: item found in queue is if condition  14409
2025-08-08 13:30:05 [INFO]: item found in queue is  14409
2025-08-08 13:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBvEOfA9Uqsk0463l5yBDgZ/6K7MGa1eNB5h0Dvn7EIMUnk2UxNjzwhobNA/mswNO7L9Ny0hmoHP+RfjtWh4ThULz2j17NqC9lYZd+u1ABOtq5LfdsE4r9O+WJUANgByUY69J0iCd7uo/Nq0yeRFKoDnM8XN0bO51gtr+xMnbwXAz+q7iRb3P45+Bvduju5BVJ6fV7tvNvRBFmOqoIyhgpwHzW67+T8102UUi4h1GhI4YCyA90dsIBNyU4pl1I6Bblk/dTtwow3I/3icx9VtRZ3f3BPHRY3FrSJHkm2yJImPXMgBCCGtJuGJVfVL9u9MiycEc1aJJ+fp63zIBGLwQXXS1rfY9DvZ2NAgxARdOfPOp7a0ny2Ag2c1WkBoPmjXXh/ZJc4tHKtJjNPuH1CBV3D5CJKrJkX8IO7CmIZfKcWKgngEb43OtWnsGA0qKXaOwv
2025-08-08 13:30:06 [INFO]: item found in queue is if condition  14409
2025-08-08 13:30:06 [INFO]: item found in queue is  14409
2025-08-08 13:30:06 [INFO]: Message deleted from the queue for receipt handle: AQEBxewSS6+L4/R0TNybZIh/1d47ypMi6aQ4L5AW8r/a5Pc7cOG5lasPn4Mevuj5t3d1M9zHq+Kjo9TmFsyeLKqDlNvqHQlvb6iMSO8adssjEYfqAUrgSwKLSiDtS2CiFeNgUP+iCggdT/2DsJg9Gx7RsN+GJSo6VBVWs9kZXi+H7mYZ5mqOkhM7P/VYTxNZBwaMOCx5UVEeEqC2KJqewvg5oDBllEXNATuM1Wp6yPzMk2w/Y0rXKKPwp/7LMNGhVMvVrAEtHwNAz2WCDMXBebBTC6yVGzSC04OPdICfI1p9izPsgUtzeoAefC5IOfEVCq9HSk3fvbtgJknCOvpGeCsppsurA8PYAR7ycc6dtm0Qa5HC9JFo9moXY618e2HlCzLgxS2mNqnvTLnl+7Azt6a1GuIgl1LHAVgj94UXA3akMzO5eRYK7fOUFzzqPQ3+1wWL
2025-08-08 13:30:07 [INFO]: item found in queue is if condition  14409
2025-08-08 13:30:07 [INFO]: item found in queue is  14409
2025-08-08 13:30:07 [INFO]: Message deleted from the queue for receipt handle: AQEBUwM6AdxtAkji6jU90Y/4EYTMApZPq//TM0QtLf42jwCi1FSsCgplw8dZD4IswrQxmxqf7HhHSVjoEMe14N0dByGqXiRYmumvLhJHa5bic71rxsidgtM0JmXERTeY3emd2O74q1RGvZgpr3YSXj6KVJLPkzd8UCM4qFgWV6gHSSHbURJpcbR3byOTi16BWWYViiYKQfonlsK0ganJoLnE+H3YuZKeJfpv0OtDKBRSlpb7LhOUCU0/cRgwOtiHlS7RQHkiRo2LcbobJ2KYpS0HYAgZqI9O+KnPRZTUnde/NIbS34609afhFWPyri9nxOtUnt/XNg12rIEjjY8xxwfzufDuhFRDbDP/OM2QHn0U7m4P3eHgWrKWHxoTwlyjFGV/Pl4WXUbEqsguW0I7uVpZK0cGzl8oZRiH5AfB+9G0YlEejYiXP/xpc9loih2eh6F0
2025-08-08 13:30:09 [INFO]: item found in queue is if condition  14409
2025-08-08 13:30:09 [INFO]: item found in queue is  14409
2025-08-08 13:30:09 [INFO]: Message deleted from the queue for receipt handle: AQEBNVHFm7YiahWhrDXtTWxN1xD7TzDo0ft5EQgSK5SJQ0pw8tvBfBkPYy1MfINHVvDL+KJG2XkpjJNToH96VHounv9DdBukVyjvD8k4X7lJxv1wiRLWXo8xqKWJZJsrNZ037VEYiK5s/8ONuKsLaiczgF2dYUCOBMwfo0cG9Rlgm/WbD1dTpN0/ok/lBXemqpSn9AuJwnoNWNEi5hIqEXBN2qPjGmiIMPwuKkbkRcZdrKWCVySYBLoK4lRpwgtFqUf2kb56m8xj5DAF65EXvRPPcFutSrVZ+jpKYaBl7bpXtM5wk3H1VIQSVAZ5v1ofwVab2EE9di8c7xAitQClVuChbohkW++Pqu3QgNS4gl3lH1q2ZmY6X4i1zdv3UcXj1EMxS8ESwOPbziGyRnExL6Vi3cOUuC51jcMkJ+asrswvdLotQlz4Z+k1AzfD95TFHy+H
2025-08-08 13:30:09 [INFO]: Processed 5 messages, reached the limit of 5.
2025-08-08 13:30:09 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-08 13:30:09 [INFO]: inside itemsold and closed 14409
2025-08-08 13:30:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 13:30:11 [INFO]: autolink for user_id 14409 is 1
2025-08-08 13:30:11 [INFO]: Ebay item id :: 285687942611 exists in Database
2025-08-08 13:30:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 13:30:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 13:30:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 13:30:11 [INFO]: inside itemsold and closed 14409
2025-08-08 13:30:13 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 13:30:13 [INFO]: autolink for user_id 14409 is 1
2025-08-08 13:30:13 [INFO]: Ebay item id :: 335277814219 exists in Database
2025-08-08 13:30:13 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 13:30:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 13:30:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 13:30:13 [INFO]: inside itemsold and closed 14409
2025-08-08 13:30:15 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 13:30:15 [INFO]: autolink for user_id 14409 is 1
2025-08-08 13:30:15 [INFO]: Ebay item id :: 404770648706 exists in Database
2025-08-08 13:30:15 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 13:30:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 13:30:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 13:30:15 [INFO]: inside itemsold and closed 14409
2025-08-08 13:30:16 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 13:30:16 [INFO]: autolink for user_id 14409 is 1
2025-08-08 13:30:16 [INFO]: Ebay item id :: 285774805421 exists in Database
2025-08-08 13:30:16 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 13:30:16 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 13:30:16 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 13:30:16 [INFO]: inside itemsold and closed 14409
2025-08-08 13:30:18 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 13:30:18 [INFO]: autolink for user_id 14409 is 1
2025-08-08 13:30:18 [INFO]: Ebay item id :: 256394635665 exists in Database
2025-08-08 13:30:18 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 13:30:18 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 13:30:18 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 13:30:18 [INFO]: in processold action queue is array    for {"44771419":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44771419","ebayitemid":"285687942611","shopifyproductid":"8274254692574","variants":[{"price":"34.99","quantity":0,"weight":"3","shopifyproductid":"8274254692574","shopifyvariantid":"44762753073374","shopifyinventoryid":"46860764053726","shopifylocationid":"","product_id":"44771419","variant_id":"77679961","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44593861":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44593861","ebayitemid":"335277814219","shopifyproductid":"7701526479070","variants":[{"price":"16.99","quantity":0,"weight":"0.75","shopifyproductid":"7701526479070","shopifyvariantid":"43002106609886","shopifyinventoryid":"45097311043806","shopifylocationid":"","product_id":"44593861","variant_id":"77486570","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44771120":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44771120","ebayitemid":"404770648706","shopifyproductid":"8270112784606","variants":[{"price":"79.99","quantity":0,"weight":"3","shopifyproductid":"8270112784606","shopifyvariantid":"44744640069854","shopifyinventoryid":"46842647642334","shopifylocationid":"","product_id":"44771120","variant_id":"77679662","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44662224":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44662224","ebayitemid":"285774805421","shopifyproductid":"8333335429342","variants":[{"price":"71.99","quantity":0,"weight":"2","shopifyproductid":"8333335429342","shopifyvariantid":"44952331485406","shopifyinventoryid":"47050113089758","shopifylocationid":"","product_id":"44662224","variant_id":"77567444","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44771110":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44771110","ebayitemid":"256394635665","shopifyproductid":"8269916799198","variants":[{"price":"79.99","quantity":0,"weight":"3","shopifyproductid":"8269916799198","shopifyvariantid":"44744375566558","shopifyinventoryid":"46842383139038","shopifylocationid":"","product_id":"44771110","variant_id":"77679652","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-08 13:30:18 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-08 13:30:18 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 13:30:18 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 13:30:18 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 13:30:18 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 13:30:18 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 13:30:18 [INFO]: Shopify Inventory id 46860764053726
2025-08-08 13:30:18 [INFO]: Shopify Location id 58450641063
2025-08-08 13:30:18 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 13:30:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T13:30:18Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-08 13:30:19 [INFO]: Change: available | Delta: -1
2025-08-08 13:30:19 [INFO]: Change: on_hand | Delta: -1
2025-08-08 13:30:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 13:30:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44771419 and user_id = 14409 
2025-08-08 13:30:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77679961 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 13:30:19 [INFO]: Shopify Inventory id 45097311043806
2025-08-08 13:30:19 [INFO]: Shopify Location id 58450641063
2025-08-08 13:30:19 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 13:30:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T13:30:19Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-08 13:30:19 [INFO]: Change: available | Delta: -1
2025-08-08 13:30:19 [INFO]: Change: on_hand | Delta: -1
2025-08-08 13:30:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 13:30:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44593861 and user_id = 14409 
2025-08-08 13:30:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77486570 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 13:30:19 [INFO]: Shopify Inventory id 46842647642334
2025-08-08 13:30:19 [INFO]: Shopify Location id 58450641063
2025-08-08 13:30:19 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 13:30:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T13:30:19Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-08 13:30:19 [INFO]: Change: available | Delta: -1
2025-08-08 13:30:19 [INFO]: Change: on_hand | Delta: -1
2025-08-08 13:30:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 13:30:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44771120 and user_id = 14409 
2025-08-08 13:30:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77679662 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 13:30:19 [INFO]: Shopify Inventory id 47050113089758
2025-08-08 13:30:19 [INFO]: Shopify Location id 58450641063
2025-08-08 13:30:19 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 13:30:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T13:30:19Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-08 13:30:20 [INFO]: Change: available | Delta: -1
2025-08-08 13:30:20 [INFO]: Change: on_hand | Delta: -1
2025-08-08 13:30:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 13:30:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44662224 and user_id = 14409 
2025-08-08 13:30:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77567444 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 13:30:20 [INFO]: Shopify Inventory id 46842383139038
2025-08-08 13:30:20 [INFO]: Shopify Location id 58450641063
2025-08-08 13:30:20 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 13:30:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T13:30:20Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-08 13:30:20 [INFO]: Change: available | Delta: -1
2025-08-08 13:30:20 [INFO]: Change: on_hand | Delta: -1
2025-08-08 13:30:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 13:30:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44771110 and user_id = 14409 
2025-08-08 13:30:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77679652 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 13:30:20 [INFO]: updateIdsQuantity -> ["77679961","77486570","77679662","77567444","77679652"]
2025-08-08 13:30:20 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 5. Affected rows: 5
2025-08-08 13:30:20 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77679961 THEN 0 WHEN id = 77486570 THEN 0 WHEN id = 77679662 THEN 0 WHEN id = 77567444 THEN 0 WHEN id = 77679652 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77679961 THEN 0 WHEN id = 77486570 THEN 0 WHEN id = 77679662 THEN 0 WHEN id = 77567444 THEN 0 WHEN id = 77679652 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77679961,77486570,77679662,77567444,77679652)
2025-08-08 13:30:20 [INFO]: QUANTITY Updated IDs: 77679961, 77486570, 77679662, 77567444, 77679652
2025-08-08 13:30:20 [INFO]: Successfully processed data for user 14409
2025-08-08 13:30:20 [INFO]: Execution Started
2025-08-08 13:30:20 [INFO]: Execution Finished
2025-08-08 13:40:01 [INFO]: Execution Started
2025-08-08 13:40:01 [INFO]: old server sucessfully connected
2025-08-08 13:40:01 [INFO]: sqs client sucess created
2025-08-08 13:40:02 [INFO]: Number of messages in the queue: 3
2025-08-08 13:40:03 [INFO]: item found in queue is if condition  14409
2025-08-08 13:40:03 [INFO]: item found in queue is  14409
2025-08-08 13:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEB/RMzkdUCflchghj3mMjqj9FjPBkjExotwQu3WtFe/N3zRmjfO3T0g4+sAhO3hs+7cPZnYYbCp9LVrdnepEz+h1MqfKDR0SWWx1aXW1+rND0PDepuGreIl4mWz/pTFr6tJjXFN9Rwblt1i397J1z4wCyyqB5wklKzQfKESFd1Zw9hwWMRnhbL+nvBYSkGuGs0NKhRmZcoc1KD6aQRGjyhLa8Deign4On1eECqB9bwNOSSJ3dnrq5OZXlisQXmiGpzj1+us5yvVWEGsYW7wJfFwDXQmOL7HmX6Fid9d8EYmQ61OPWMzapjo58LfH5ca+VB/gvyLtZwDPDWmmlRXIr9y29+f/OaxB41siT3soXety+8mWAQviBJ1daZHc5/PfiaPgB6kWYc6rt9t96/u5bBzzwsN5AwDBtpelodOLRxUG1HPJS8R7QmYmC7xtl5ujMl
2025-08-08 13:40:03 [INFO]: item found in queue is if condition  14409
2025-08-08 13:40:03 [INFO]: item found in queue is  14409
2025-08-08 13:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEB6ZBwrcbnovNkwQOe68tnaaJXqcT6bQOvCksoYt/aPEPdswE7gL/OfRCXHOeQpIqThhGHmpY0pMh9dj/bD9QZrrwTd9KZIZUu7KY9YSQY3Lhcm0mDwq7FdblguGMbly5uU458ljJuj3qTAhJRjizIU7E8K9EcYWIpIZgzjFPrinvquZsdB0KDh2yrRzuWbCUEp0rgpm0ZBpMaTJguemYLmhSN61vKRwOemfP76j7yhkeWiaXmtRbRNsajAPZ5TBIgT2LwphqtVGn/l3znNHYQWyshYA/Foq26/8eUwC/jVfAe8YzPEc4PmhhWvV552K1Ha9qyYGPEPcEA7XD7JAt0t97cvj0vevKelQ5Mn1dkxQjRAJ2elusER5UaC21WURNeFh2kb4TKJobSb2no66GNBRPTX9EWIsaLhaNpm/Qa6c9NqjCSxX5gLhqDXNhnQ7uj
2025-08-08 13:40:04 [INFO]: item found in queue is if condition  14409
2025-08-08 13:40:04 [INFO]: item found in queue is  14409
2025-08-08 13:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBfM8Pb2yAz17U+XK/V6Z0ZkCUgBX2rpLnVXwHLYojE9GxODMlChBmBi64AYfoAaHiFxqwRyrggGkF8261g5k2A1al2wu39zXTlGOjhx2TCW2hmKDk8pBAQfXZstbIxemrSMGKFNnNiQ57MWQyghnRttruGhygIAu9RDMa6RemZBzcVm/rDnZIrpBIrB9ok9xpVlW0y/eOafHXLKUGZQq54yIWcygIL89hK/wu0300drpPTzmrRyhHEH5voA6M1atqWD0pjY3GI8fDvSW9w0BmD18ZkU2cWmXfapQNJMo5duyz9oHolad/YknAJ9d90h/I5DIvEdH385f9hJY2dYyx2Jpf0JpeVr1+yWwgIpYoKUoSxpJDNkxD5oTQmUR8RGlZGv3qQFM61Hihwu+rJNhNSv9CxL0Rn4Ug0TnNM5v0LP30N3sWAWt9gyCt0VJtH4E6
2025-08-08 13:40:04 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-08 13:40:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-08 13:40:04 [INFO]: inside itemsold and closed 14409
2025-08-08 13:40:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 13:40:06 [INFO]: autolink for user_id 14409 is 1
2025-08-08 13:40:06 [INFO]: Ebay item id :: 256766826424 exists in Database
2025-08-08 13:40:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 13:40:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 13:40:06 [INFO]: inside itemsold and closed 14409
2025-08-08 13:40:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 13:40:09 [INFO]: autolink for user_id 14409 is 1
2025-08-08 13:40:09 [INFO]: Ebay item id :: 335951578272 exists in Database
2025-08-08 13:40:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 13:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 13:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 13:40:09 [INFO]: inside itemsold and closed 14409
2025-08-08 13:40:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 13:40:10 [INFO]: autolink for user_id 14409 is 1
2025-08-08 13:40:10 [INFO]: Ebay item id :: 285775385649 exists in Database
2025-08-08 13:40:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 13:40:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 13:40:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 13:40:10 [INFO]: in processold action queue is array    for {"44624376":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44624376","ebayitemid":"335951578272","shopifyproductid":"8920701075678","variants":[{"price":"54.99","quantity":0,"weight":"2","shopifyproductid":"8920701075678","shopifyvariantid":"46784791609566","shopifyinventoryid":"48883305349342","shopifylocationid":"58450641063","product_id":"44624376","variant_id":"77528823","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44663778":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44663778","ebayitemid":"285775385649","shopifyproductid":"8086499426526","variants":[{"price":"222.99","quantity":0,"weight":"3","shopifyproductid":"8086499426526","shopifyvariantid":"44268507726046","shopifyinventoryid":"46365638394078","shopifylocationid":"","product_id":"44663778","variant_id":"77568998","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-08 13:40:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-08 13:40:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 13:40:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 13:40:10 [INFO]: Shopify Inventory id 48883305349342
2025-08-08 13:40:10 [INFO]: Shopify Location id 58450641063
2025-08-08 13:40:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 13:40:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T13: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":1989,"restoreRate":100}}}}
2025-08-08 13:40:11 [INFO]: Change: available | Delta: -1
2025-08-08 13:40:11 [INFO]: Change: on_hand | Delta: -1
2025-08-08 13:40:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 13:40:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44624376 and user_id = 14409 
2025-08-08 13:40:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77528823 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 13:40:11 [INFO]: Shopify Inventory id 46365638394078
2025-08-08 13:40:11 [INFO]: Shopify Location id 58450641063
2025-08-08 13:40:11 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 13:40:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T13: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":1989,"restoreRate":100}}}}
2025-08-08 13:40:11 [INFO]: Change: available | Delta: -1
2025-08-08 13:40:11 [INFO]: Change: on_hand | Delta: -1
2025-08-08 13:40:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 13:40:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44663778 and user_id = 14409 
2025-08-08 13:40:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77568998 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 13:40:11 [INFO]: updateIdsQuantity -> ["77528823","77568998"]
2025-08-08 13:40:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-08 13:40:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77528823 THEN 0 WHEN id = 77568998 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77528823 THEN 0 WHEN id = 77568998 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77528823,77568998)
2025-08-08 13:40:11 [INFO]: QUANTITY Updated IDs: 77528823, 77568998
2025-08-08 13:40:11 [INFO]: Successfully processed data for user 14409
2025-08-08 13:40:11 [INFO]: Execution Started
2025-08-08 13:40:11 [INFO]: Execution Finished
2025-08-08 13:50:01 [INFO]: Execution Started
2025-08-08 13:50:01 [INFO]: old server sucessfully connected
2025-08-08 13:50:01 [INFO]: sqs client sucess created
2025-08-08 13:50:03 [INFO]: Number of messages in the queue: 2
2025-08-08 13:50:04 [INFO]: item found in queue is if condition  14409
2025-08-08 13:50:04 [INFO]: item found in queue is  14409
2025-08-08 13:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBk9mpG2wqpsQT+/7/vAsajLhbWh3oNednRPVtw1Sj0fi3q6L6HHa2dXtHrYTAYpCLnDX74+rP8nkoB/hWwYuklZOHREd9dIbuRShibh7k28FEwp3c/HiN793kRMx1m/kVVoDbale8Zt9ET/3Dxkp0X9CmVk8V4Z31RScJphfrWy3/pf7Z1WBIe4L54YGTIBQXHFxr3lhmA6uRwKNBqyV1keE+isxDPNFh9MmhN31/lAGZkQ6/XyDZv8qnP1pQ6Ipw8hJZIEDpS8rIjIkq8lGfp/hFl4sdT/kc7xSz3MyUySWv2osCGTJ/Vuo1Y8TVQHQcYcVTbgX2a8LloDwx67ST5fHQOuKScWqZBqMmW2n5atJ606T1uH7qmN/92jtY1RhSd2btNAEI6xD0XoZ4x7A8IiAu879tJkWb+fCJ+OFP/VQLg/cvZQDS3u594e+BtQVx
2025-08-08 13:50:05 [INFO]: item found in queue is if condition  14409
2025-08-08 13:50:05 [INFO]: item found in queue is  14409
2025-08-08 13:50:07 [INFO]: Message deleted from the queue for receipt handle: AQEBl/9lMo2HT0lmj2nGQBtNC0PdJEDuoccdtMGZTGQxPXjyvr2hDzdduzEKiTtcb/oFqwWTXQ26FmHQ4oh5dNp92J8dL/GtnYPY4Gkd9HrMywcEKg+M/6sOMrPhmjw85N1lvQxDKDxGHuLkGsHxiag9VwPid04iOrBypnZA1AbO2+mc/mIVL4+FDiwI8szGMVN3AA9AzuGIO0gKT99PMA091MeN4UO23I7xxWyEeFBHEJGkpPwNEFXUjb/GYSeE7hDinoHpsYVHk12oDhD3I43iu/Y6ufK+pYg9BdfZe21GJ1NUAyQv3P8HXOG/F8igwNzZjsE4xn+Qj1fisoRnLtEex+iFm8ZLTyqipdF3ULwymJd4qKww45npILa37cwg17dsL25Vtmp9fjaaMsv/PgsKpPAZNSKfPMgpKRIwcQQafaE62VErMmnDZN8sPcXcIpH3
2025-08-08 13:50:07 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-08 13:50:07 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-08 13:50:07 [INFO]: inside itemsold and closed 14409
2025-08-08 13:50:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 13:50:08 [INFO]: autolink for user_id 14409 is 1
2025-08-08 13:50:08 [INFO]: Ebay item id :: 404918103360 exists in Database
2025-08-08 13:50:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 13:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 13:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 13:50:08 [INFO]: inside itemsold and closed 14409
2025-08-08 13:50:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 13:50:10 [INFO]: autolink for user_id 14409 is 1
2025-08-08 13:50:10 [INFO]: Ebay item id :: 406095752579 exists in Database
2025-08-08 13:50:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 13:50:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 13:50:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 13:50:10 [INFO]: in processold action queue is array    for {"44772637":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772637","ebayitemid":"404918103360","shopifyproductid":"8395510513886","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"8395510513886","shopifyvariantid":"45145545146590","shopifyinventoryid":"47243414700254","shopifylocationid":"","product_id":"44772637","variant_id":"77681179","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45312992":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45312992","ebayitemid":"406095752579","shopifyproductid":"8976336879838","variants":[{"price":"266.99","quantity":0,"weight":"4","shopifyproductid":"8976336879838","shopifyvariantid":"47191955210462","shopifyinventoryid":"49303793139934","shopifylocationid":"58450641063","product_id":"45312992","variant_id":"78265505","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-08 13:50:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-08 13:50:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 13:50:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 13:50:10 [INFO]: Shopify Inventory id 47243414700254
2025-08-08 13:50:10 [INFO]: Shopify Location id 58450641063
2025-08-08 13:50:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 13:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T13:50:10Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-08 13:50:10 [INFO]: Change: available | Delta: -1
2025-08-08 13:50:10 [INFO]: Change: on_hand | Delta: -1
2025-08-08 13:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 13:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772637 and user_id = 14409 
2025-08-08 13:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681179 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 13:50:10 [INFO]: Shopify Inventory id 49303793139934
2025-08-08 13:50:10 [INFO]: Shopify Location id 58450641063
2025-08-08 13:50:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 13:50:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T13:50:11Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-08 13:50:11 [INFO]: Change: available | Delta: -1
2025-08-08 13:50:11 [INFO]: Change: on_hand | Delta: -1
2025-08-08 13:50:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 13:50:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45312992 and user_id = 14409 
2025-08-08 13:50:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265505 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 13:50:11 [INFO]: updateIdsQuantity -> ["77681179","78265505"]
2025-08-08 13:50:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-08 13:50:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77681179 THEN 0 WHEN id = 78265505 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77681179 THEN 0 WHEN id = 78265505 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77681179,78265505)
2025-08-08 13:50:11 [INFO]: QUANTITY Updated IDs: 77681179, 78265505
2025-08-08 13:50:11 [INFO]: Successfully processed data for user 14409
2025-08-08 13:50:11 [INFO]: Execution Started
2025-08-08 13:50:11 [INFO]: Execution Finished