2025-08-05 18:00:02 [INFO]: Execution Started 2025-08-05 18:00:02 [INFO]: old server sucessfully connected 2025-08-05 18:00:02 [INFO]: sqs client sucess created 2025-08-05 18:00:03 [INFO]: Number of messages in the queue: 5 2025-08-05 18:00:04 [INFO]: item found in queue is if condition 14409 2025-08-05 18:00:04 [INFO]: item found in queue is 14409 2025-08-05 18:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBiGwNUbenTxsI/TRL+wVB2jEpwQ3h/djCBSi/5FkJuy4FC6VcZb8o7OokQ3MTFlHIo+7pklwG994xBEVrZCcKSzgXwqlOtwQ8dbz0WQZQs4+WczEVKehDSjik70KOUbpVjiJz5ucqSDBRo6NKF4XXSQNv/sJh3CrM5GrEjegBqh30ezLkdX1TweJnQGBsCfNbb0foKCSpNAuAuRUClpvxU6VK8nA0WSNEW9Rl50V0vo4ck6QLCWBt/3+9LhOLdeyIl7mFgGqgUQZPQh9mI2uIF0RgxENQQQn7cRe9lNVamVrI1b5nMrR+QVpzaml/y5Ojva9qDQnYW/hTgGgJ2wULIzEk27JQp+enc5A4pcLf8RMQfq07Qqz07TTAuF5uz/sFJ5v/kVqdFshn4P7dfmJSTR4lj7jApn461DVJ4AXyGG6K3pOspaqIuDAxVLMyAj2K 2025-08-05 18:00:05 [INFO]: item found in queue is if condition 14409 2025-08-05 18:00:05 [INFO]: item found in queue is 14409 2025-08-05 18:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEB/Qjo7J0TciFZNISlpDWea+iRvryWo6H7vnswcR1kNb/c1Qqjcz13yRJazetdKn35QSw49CVMUjBvFFI4nWGDuuzFSjj39aJf8RXChREdgPDoOF4vX/9KE1M2GkbAjOuEuHmMN8S1rRVMRuT1rNOd8zG2Na4OoiQTToNFfi8R9ElyLnjMcTI7Ch8zZHOHoJK89gX98SILVCccFKcZTUClhBR2B8N3z1UpUcp16jVsVOccCG9l6DyPtdcLJRwLlP1simmyWGLbDSIWiOxOb17XINUrHhl43xGPIytewM88VxdGH8Z/ou6PRvZbUhHk9SCPgxlEjymvauOCZ9H5MyAHXILCCffpOtrwu4mGD67A4i4V1cibgVhl5WZgPADtvUPGv+DN+IwJa/Mgy63bSCrztATgFVU8gC7M636BihVo3NTX7fXfY2OX/WkVTOsNTGxg 2025-08-05 18:00:05 [INFO]: item found in queue is if condition 14409 2025-08-05 18:00:05 [INFO]: item found in queue is 14409 2025-08-05 18:00:06 [INFO]: Message deleted from the queue for receipt handle: AQEBy1+llFls3k9+lwp4jgvf+hSkWLhDdXViQuTWzkKYB840nZaoTH+ap0nEFc86VY74sUKkul52U3El0I2NnZEtXYRWObItKqaRe+NbtLJH3VSQsaSdg/c1yXiY241/mbPMxcULdQTrOW7XVfpsrsOIPpMO9Vjpc3uAMyByiAOmHHYcPH0SVbmpERjSnd4846xf3RinMA3Cyo0FwZVpBDK44bTp7FII9diCuClNbOlBV6p6ce2re7MGSi/gJBZQIF0vMr1aGWCj43EZb/wxsajtTZQ+eD3nO2aRKxyfcFYQ4ePZ+bg8wHkwl/qCJ27nLQUXyr8/pHeQiFxN+myJL16OZnnH8IanrIooxukvlFy/llas05QK1rudpaZFxYncmOda16u+EWtP/0LkZgKjvTLr5oOWqkw0S039idMIgTKQ2PmJ83diKV0O8eLKlOsf8c/b 2025-08-05 18:00:06 [INFO]: item found in queue is if condition 14409 2025-08-05 18:00:06 [INFO]: item found in queue is 14409 2025-08-05 18:00:06 [INFO]: Message deleted from the queue for receipt handle: AQEBXbSk8YR82+bUiHKgMXWnLIDhpleNNe2IjzUkf+jdXvbZAlDZur++Pz9ftEu/MM5Voz+0A3sOW/JoT9vLgwadxyH3ALUOpwkIiGYYafrNdc/oNGdHPKb3761bNeTTSxnaWa2ps1FagcfjpaOn5UL+PA90rAHP2IZ3Spj0ldEO9iN891moXMuuTF+lZP0T9u4sWAWIpftIoNotOVzE2wNMPS7r3MQhCfuzFpwErV0bWSRlaMNoiwPA071LXFgUryNehtcddIExQMorJmMrxUm/V12SB6WiKS2Gbsz0RRuQQa4EY+ndF5DiLuyJgMnxCPjpfxceJsUeLgTFQBupE/5zD+/lEfV1AF6jjBsVc/IGNSiA77ifHxV8Ic86mxtfGCdx5/SK6c3xL67wxTsxTh6WdOr+GcMvz1PyXqqOLV4cNI9O0CkFgYncBPt5+DsI76HQ 2025-08-05 18:00:06 [INFO]: item found in queue is if condition 14409 2025-08-05 18:00:06 [INFO]: item found in queue is 14409 2025-08-05 18:00:07 [INFO]: Message deleted from the queue for receipt handle: AQEBgN0ig/+uiVDObo4+c8RhN4S/XEz+xeuo/k7EfiiQLV686HxRfAnSuBhU6WiJZRsSoeCFcMPa4HnnCh0w7uyMGAzZplpVcWHfcWeEggkvMG4oQyN8V6AeQ3XUTtQbrqI9vX3H9lSLZu2pPl/L+KM6bMgveZTwGBHJTRafxAl1kMVT7ScWjBTBFbvEkuCVTHPFjVnsfdjncwBhNO66T4Xr0/D087R7skA+iFOFflqd9lywTkNg2cBqIbWlPwRq7AeIN4CRHytyfAhv/JJjEAZzSWaqUsUjuVJOMaLwU0NJvIQgFkQZblRWwrQ4T8Me/EPROzrR72xsXat+1q2vVWknAbrEBSJ52mTQzOCevJ3/YgNoKsoSLimn5zQfRbH0BYyoVrY0k5vcoxYRY+Xt8gSBtWWdnm2MLhKJI5H8/S1IJjgT/oG/PVHubPEMoMAIr5Mx 2025-08-05 18:00:07 [INFO]: Processed 5 messages, reached the limit of 5. 2025-08-05 18:00:07 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 18:00:07 [INFO]: inside itemsold and closed 14409 2025-08-05 18:00:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 18:00:08 [INFO]: autolink for user_id 14409 is 1 2025-08-05 18:00:08 [INFO]: Ebay item id :: 286165097479 exists in Database 2025-08-05 18:00:08 [INFO]: Item is reliested :: exists in Database 2025-08-05 18:00:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 18:00:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 18:00:08 [INFO]: inside itemsold and closed 14409 2025-08-05 18:00:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 18:00:10 [INFO]: autolink for user_id 14409 is 1 2025-08-05 18:00:10 [INFO]: Ebay item id :: 286165092482 exists in Database 2025-08-05 18:00:10 [INFO]: Item is reliested :: exists in Database 2025-08-05 18:00:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 18:00:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 18:00:10 [INFO]: inside itemsold and closed 14409 2025-08-05 18:00:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 18:00:12 [INFO]: autolink for user_id 14409 is 1 2025-08-05 18:00:12 [INFO]: Ebay item id :: 335676551827 exists in Database 2025-08-05 18:00:12 [INFO]: Item is reliested :: exists in Database 2025-08-05 18:00:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 18:00:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 18:00:12 [INFO]: inside itemsold and closed 14409 2025-08-05 18:00:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 18:00:14 [INFO]: autolink for user_id 14409 is 1 2025-08-05 18:00:14 [INFO]: Ebay item id :: 286165084193 exists in Database 2025-08-05 18:00:14 [INFO]: Item is reliested :: exists in Database 2025-08-05 18:00:14 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-05 18:00:14 [INFO]: inside itemsold and closed 14409 2025-08-05 18:00:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 18:00:15 [INFO]: autolink for user_id 14409 is 1 2025-08-05 18:00:15 [INFO]: Ebay item id :: 255197607046 exists in Database 2025-08-05 18:00:15 [INFO]: Item is reliested :: exists in Database 2025-08-05 18:00:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 18:00:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 18:00:15 [INFO]: in processold action queue is array for {"44574515":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44574515","ebayitemid":"286165097479","shopifyproductid":"7078880411815","variants":[{"price":"39.99","quantity":0,"weight":"2","shopifyproductid":"7078880411815","shopifyvariantid":"41464109105319","shopifyinventoryid":"43560564129959","shopifylocationid":"","product_id":"44574515","variant_id":"77467222","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44574487":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44574487","ebayitemid":"286165092482","shopifyproductid":"7108816109735","variants":[{"price":"39.99","quantity":0,"weight":"2","shopifyproductid":"7108816109735","shopifyvariantid":"41572376019111","shopifyinventoryid":"43668875280551","shopifylocationid":"","product_id":"44574487","variant_id":"77467195","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44574459":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44574459","ebayitemid":"335676551827","shopifyproductid":"7106519138471","variants":[{"price":"39.99","quantity":0,"weight":"2","shopifyproductid":"7106519138471","shopifyvariantid":"41563957657767","shopifyinventoryid":"43660457345191","shopifylocationid":"","product_id":"44574459","variant_id":"77467166","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45143785":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45143785","ebayitemid":"286165084193","deleted":1}},"44682942":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44682942","ebayitemid":"255197607046","shopifyproductid":"7126634135719","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"7126634135719","shopifyvariantid":"41626260275367","shopifyinventoryid":"43723191189671","shopifylocationid":"","product_id":"44682942","variant_id":"77588167","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 18:00:15 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 18:00:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 18:00:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 18:00:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 18:00:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 18:00:15 [INFO]: productIds WHich are having null productid -> [45143785] 2025-08-05 18:00:15 [INFO]: ebayItemIds WHich are not imported-> ["286165084193"] 2025-08-05 18:00:15 [INFO]: Entered in bulkUpdateProducts function 2025-08-05 18:00:15 [INFO]: Transaction started for bulkUpdateProducts 2025-08-05 18:00:15 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45143785) 2025-08-05 18:00:15 [INFO]: Query executed successfully. Affected rows: 0 2025-08-05 18:00:15 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-05 18:00:15 [INFO]: Transaction committed successfully. 2025-08-05 18:00:15 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-05 18:00:15 [INFO]: Shopify Inventory id 43560564129959 2025-08-05 18:00:15 [INFO]: Shopify Location id 58450641063 2025-08-05 18:00:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 18:00:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T18:00:16Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 18:00:16 [INFO]: Change: available | Delta: -2 2025-08-05 18:00:16 [INFO]: Change: on_hand | Delta: -2 2025-08-05 18:00:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 18:00:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44574515 and user_id = 14409 2025-08-05 18:00:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77467222 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 18:00:16 [INFO]: Shopify Inventory id 43668875280551 2025-08-05 18:00:16 [INFO]: Shopify Location id 58450641063 2025-08-05 18:00:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 18:00:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T18:00:16Z","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-05 18:00:16 [INFO]: Change: available | Delta: -1 2025-08-05 18:00:16 [INFO]: Change: on_hand | Delta: -1 2025-08-05 18:00:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 18:00:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44574487 and user_id = 14409 2025-08-05 18:00:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77467195 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 18:00:16 [INFO]: Shopify Inventory id 43660457345191 2025-08-05 18:00:16 [INFO]: Shopify Location id 58450641063 2025-08-05 18:00:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 18:00:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T18:00:16Z","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-05 18:00:16 [INFO]: Change: available | Delta: -1 2025-08-05 18:00:16 [INFO]: Change: on_hand | Delta: -1 2025-08-05 18:00:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 18:00:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44574459 and user_id = 14409 2025-08-05 18:00:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77467166 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 18:00:16 [INFO]: Shopify Inventory id 43723191189671 2025-08-05 18:00:16 [INFO]: Shopify Location id 58450641063 2025-08-05 18:00:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 18:00:16 [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-05 18:00:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 18:00:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44682942 and user_id = 14409 2025-08-05 18:00:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77588167 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 18:00:16 [INFO]: updateIdsQuantity -> ["77467222","77467195","77467166","77588167"] 2025-08-05 18:00:16 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 3 2025-08-05 18:00:16 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77467222 THEN 0 WHEN id = 77467195 THEN 0 WHEN id = 77467166 THEN 0 WHEN id = 77588167 THEN 0 END, quantityflag = CASE WHEN id = 77467222 THEN 0 WHEN id = 77467195 THEN 0 WHEN id = 77467166 THEN 0 WHEN id = 77588167 THEN 0 END WHERE user_id = 14409 AND id IN (77467222,77467195,77467166,77588167) 2025-08-05 18:00:16 [INFO]: QUANTITY Updated IDs: 77467222, 77467195, 77467166, 77588167 2025-08-05 18:00:16 [INFO]: Successfully processed data for user 14409 2025-08-05 18:00:16 [INFO]: Execution Started 2025-08-05 18:00:16 [INFO]: Execution Finished 2025-08-05 18:10:01 [INFO]: Execution Started 2025-08-05 18:10:01 [INFO]: old server sucessfully connected 2025-08-05 18:10:01 [INFO]: sqs client sucess created 2025-08-05 18:10:02 [INFO]: Number of messages in the queue: 3 2025-08-05 18:10:03 [INFO]: item found in queue is if condition 14409 2025-08-05 18:10:03 [INFO]: item found in queue is 14409 2025-08-05 18:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBQGIVbN3znhELHLkQ+t9KwTUqmvQnT0T/nmahdUi7PuC8dr8qyoRYls8DnQiLf3dxLUBsFxk1GjJC+kuVEhc0rL1hYY16W6LlECcM0yh21TM3lPU1nkVt0dwd46yjl+s2O8KWYfn3hY4y2bIUEGGhuQP5CCW+9wiaFs3qTqBo4dlBHVsObw3EwAo5Qzlyg3OcZ6AqBm2DvPLaX+62unEX/CnTPEXfVc13DzY/Aa+365GFCGDxslPCJ5qtVVSEKzC0I/BY7LGuZwLCAvqSrKD08AbNlljbpLTWftJVOiBo4UkK1vOLCdp9JAb7i4KMxqaaWMidzkvNBy+Y+U8TNKYVghXt5z6rybFVILY+K4KNYwuyQfCpJN9fc92EgJZyrsaWeTrwjdlYHm3PczWRmBdJICxqN39De+aO84BOUAl5fLxdMQVE7EaPdA1FZEskJqN2 2025-08-05 18:10:03 [INFO]: item found in queue is if condition 14409 2025-08-05 18:10:03 [INFO]: item found in queue is 14409 2025-08-05 18:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBZp04PEfOS4MipDw36kToI7cfBSHeyROO3IG+M/livUnWYrxShLdBzfDlMFfOEDJWLGp7DP33vHtru3t0gUL6I4LYA8dWVPQEwEyS3Y5Rb7YgUXzlWNvwo0ajLjkhuIflW4hbljnf1srvm524Nn5RM/su/jdVddlCnY/csd2uvPq7T5VVYSZ122X0Xh2nJ6FMP7J5QLb7sXh5t4N9dvKISKU0+hXTqDr3AJrMO6CTdIaKgtJpYZ0QU2+youG1BrBBe/0S7hMV2WM8nGTQNcNX6fiWJrRCBznvA8qhEX08jYQVlq9ZX4NDpRv/SU6JZnJPJMDDjnE2epRD3ATZPI9j99j2+SBFA6Am1iaAzyMz0XbWAAqArLx4Gv0ZOhBoyhCh0kZOSNo8uPIf2zkeQ9hVY4tfP7hdAcMRSpv9mUVzNewHVa7OiYJG3fABzlpIiq7d 2025-08-05 18:10:04 [INFO]: item found in queue is if condition 14409 2025-08-05 18:10:04 [INFO]: item found in queue is 14409 2025-08-05 18:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBY54sekGlT9NKk8M60qTnH8q4SCxSmlKZBhfDqq3qsSyvDYJm+JcamwnSQftqVTOHdFI3qhAwgyezTXTvuM0iDu9ntroGwFr9jx3PYeGqXewLzmWnYGrVbjLK0xDKlZmZ0RRCsuxEFtOrVl24J19aBWaKkCc2gPfTYOTGFccw7E7pmtWY3yjVM/yv3b6WrdCAgfJny+PICGq4iDSQsArPuoMbt+sslRfM6a2bugRxAVfe7kPmWm/76UT6E0ocAHRuE0G7I8fNOA03/hscN2ov8dQatZPpH6JGANuUoHEzMyc6UN1DVqxaAU3Sq0hp+udu+Vjaqc8O3olvMhopsWhCNVvHseJw66WEmFy8KrmUEAYv7uNaqm91PXCqyLArtRBG7fPXFpaLGYjlK74TLDSe4kUrTSPRVVRnG4Kc8ClknU/EKmZlZrrplw8lZNjWhn5H 2025-08-05 18:10:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-05 18:10:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 18:10:04 [INFO]: inside itemsold and closed 14409 2025-08-05 18:10:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 18:10:06 [INFO]: autolink for user_id 14409 is 1 2025-08-05 18:10:06 [INFO]: Ebay item id :: 256942467326 exists in Database 2025-08-05 18:10:06 [INFO]: Item is reliested :: exists in Database 2025-08-05 18:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 18:10:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 18:10:06 [INFO]: inside itemsold and closed 14409 2025-08-05 18:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 18:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-05 18:10:07 [INFO]: Ebay item id :: 335324538829 exists in Database 2025-08-05 18:10:07 [INFO]: Item is reliested :: exists in Database 2025-08-05 18:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 18:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 18:10:07 [INFO]: inside itemsold and closed 14409 2025-08-05 18:10:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 18:10:09 [INFO]: autolink for user_id 14409 is 1 2025-08-05 18:10:09 [INFO]: Ebay item id :: 285784207814 exists in Database 2025-08-05 18:10:09 [INFO]: Item is reliested :: exists in Database 2025-08-05 18:10:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 18:10:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 18:10:09 [INFO]: in processold action queue is array for {"44836142":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44836142","ebayitemid":"256942467326","shopifyproductid":"8927143264478","variants":[{"price":"10.99","quantity":0,"weight":"2","shopifyproductid":"8927143264478","shopifyvariantid":"46845836099806","shopifyinventoryid":"48955942109406","shopifylocationid":"58450641063","product_id":"44836142","variant_id":"77747083","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44596523":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44596523","ebayitemid":"335324538829","shopifyproductid":"8347424063710","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"8347424063710","shopifyvariantid":"45002630201566","shopifyinventoryid":"47100424487134","shopifylocationid":"","product_id":"44596523","variant_id":"77489232","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44591762":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44591762","ebayitemid":"285784207814","shopifyproductid":"8340623524062","variants":[{"price":"39.99","quantity":0,"weight":"2","shopifyproductid":"8340623524062","shopifyvariantid":"44984859263198","shopifyinventoryid":"47082646274270","shopifylocationid":"","product_id":"44591762","variant_id":"77484471","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 18:10:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 18:10:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 18:10:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 18:10:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 18:10:09 [INFO]: Shopify Inventory id 48955942109406 2025-08-05 18:10:09 [INFO]: Shopify Location id 58450641063 2025-08-05 18:10:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 18:10:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T18:10:09Z","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-05 18:10:09 [INFO]: Change: available | Delta: -1 2025-08-05 18:10:09 [INFO]: Change: on_hand | Delta: -1 2025-08-05 18:10:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 18:10:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44836142 and user_id = 14409 2025-08-05 18:10:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77747083 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 18:10:09 [INFO]: Shopify Inventory id 47100424487134 2025-08-05 18:10:09 [INFO]: Shopify Location id 58450641063 2025-08-05 18:10:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 18:10:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T18:10:09Z","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-05 18:10:10 [INFO]: Change: available | Delta: -1 2025-08-05 18:10:10 [INFO]: Change: on_hand | Delta: -1 2025-08-05 18:10:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 18:10:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44596523 and user_id = 14409 2025-08-05 18:10:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77489232 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 18:10:10 [INFO]: Shopify Inventory id 47082646274270 2025-08-05 18:10:10 [INFO]: Shopify Location id 58450641063 2025-08-05 18:10:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 18:10:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T18:10: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-05 18:10:10 [INFO]: Change: available | Delta: -1 2025-08-05 18:10:10 [INFO]: Change: on_hand | Delta: -1 2025-08-05 18:10:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 18:10:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44591762 and user_id = 14409 2025-08-05 18:10:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77484471 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 18:10:10 [INFO]: updateIdsQuantity -> ["77747083","77489232","77484471"] 2025-08-05 18:10:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-05 18:10:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77747083 THEN 0 WHEN id = 77489232 THEN 0 WHEN id = 77484471 THEN 0 END, quantityflag = CASE WHEN id = 77747083 THEN 0 WHEN id = 77489232 THEN 0 WHEN id = 77484471 THEN 0 END WHERE user_id = 14409 AND id IN (77747083,77489232,77484471) 2025-08-05 18:10:10 [INFO]: QUANTITY Updated IDs: 77747083, 77489232, 77484471 2025-08-05 18:10:10 [INFO]: Successfully processed data for user 14409 2025-08-05 18:10:10 [INFO]: Execution Started 2025-08-05 18:10:10 [INFO]: Execution Finished 2025-08-05 18:20:01 [INFO]: Execution Started 2025-08-05 18:20:01 [INFO]: old server sucessfully connected 2025-08-05 18:20:01 [INFO]: sqs client sucess created 2025-08-05 18:20:02 [INFO]: Number of messages in the queue: 2 2025-08-05 18:20:03 [INFO]: item found in queue is if condition 14409 2025-08-05 18:20:03 [INFO]: item found in queue is 14409 2025-08-05 18:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEB8qS+ON1yvPgapifkx1OcWRIAg4fATvaR4XMi5m/EpB9u2t7rdR0Rgwp5Y4aJgmNDSZQ0VDsRgq48FsmjDvsNzzJkd9U3iNGmHBqWVwwXL6fpdZ2YBwNoHnHjiT/heCdldLLcbe7CU18YbGxhhxOMr2P8Tk7qO/7CTsairTSfV2r8fmrxezoSjlX/KneoHXF2hBluyZfaipCm0F2NoTWmukthF625KJkjiGvUWiD33WNWO4BBAP55+zLeJcFfThrTyft5BCfaIhSaDAdJjpY2ZOCByYnmngBThM6CsHXB8nNgMRZ4VepqwhslG2VmAD2E9atdMcgc4MR5UFeinNexUv7YuFe2wy7LzpFhEsfApHiWKWM7wVoo9F2cTtsBp+guww+BSU025DbPohlDH4Aj8aiWqm3lZfWf90uLCln++khXD1Fa4dfoDUye3jLfPs1/ 2025-08-05 18:20:03 [INFO]: item found in queue is if condition 14409 2025-08-05 18:20:03 [INFO]: item found in queue is 14409 2025-08-05 18:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBUiTHB1fenvlDAUPdx0WzQvKNezCo6pP2KM9PCt5BFEI97RDgCf9/DcS8oVgKHPVSz3pk1iZa/A+UhP1JyMFrDNp84DY6E7FlsBsp+cgsXT+LdRn7GKte7k6N7VD1IQT6oD3hORRTQZPW3Wf2aKL+wn6x3mKyhJFCeonlK02A84nnM6IRH4uU1JFrERHt5v5136LZ185wICKNsevIAdR1v9rgY+r1qMPIz/GUHrvCCowh6iIPsMxJ5zEbpWVJyYSNLDw9HS6WFE2GMkNeQdktqVLLs7s03rBIjQimQEUM7gt6jhPA+MjveKYxHoG/9sa0FaXznzrPRLbFL9whDZs6pxqyiQ7Rl+JOVgjcYZnaWn/EE8cvRKUvPiXAf/kk5Ev27TTUTq/LKnSGGpPAHDpjG8Cx3hYE5iWIaDhrpOmXUflNNtxxd+UQw3TBpqCX2pKC 2025-08-05 18:20:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-05 18:20:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 18:20:04 [INFO]: inside itemsold and closed 14409 2025-08-05 18:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 18:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-05 18:20:05 [INFO]: Ebay item id :: 285793373106 exists in Database 2025-08-05 18:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-05 18:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 18:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 18:20:05 [INFO]: inside itemsold and closed 14409 2025-08-05 18:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 18:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-05 18:20:07 [INFO]: Ebay item id :: 305601197265 exists in Database 2025-08-05 18:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-05 18:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 18:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 18:20:07 [INFO]: in processold action queue is array for {"44599326":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44599326","ebayitemid":"285793373106","shopifyproductid":"8356345413854","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"8356345413854","shopifyvariantid":"45039002419422","shopifyinventoryid":"47136798474462","shopifylocationid":"","product_id":"44599326","variant_id":"77492035","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44780557":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44780557","ebayitemid":"305601197265","shopifyproductid":"8112364650718","variants":[{"price":"24.99","quantity":0,"weight":"2","shopifyproductid":"8112364650718","shopifyvariantid":"44315734212830","shopifyinventoryid":"46413283459294","shopifylocationid":"","product_id":"44780557","variant_id":"77689131","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 18:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 18:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 18:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 18:20:07 [INFO]: Shopify Inventory id 47136798474462 2025-08-05 18:20:07 [INFO]: Shopify Location id 58450641063 2025-08-05 18:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 18:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T18:20: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-05 18:20:07 [INFO]: Change: available | Delta: -1 2025-08-05 18:20:07 [INFO]: Change: on_hand | Delta: -1 2025-08-05 18:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 18:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44599326 and user_id = 14409 2025-08-05 18:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77492035 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 18:20:07 [INFO]: Shopify Inventory id 46413283459294 2025-08-05 18:20:07 [INFO]: Shopify Location id 58450641063 2025-08-05 18:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 18:20:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T18:20:08Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 18:20:08 [INFO]: Change: available | Delta: -2 2025-08-05 18:20:08 [INFO]: Change: on_hand | Delta: -2 2025-08-05 18:20:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 18:20:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44780557 and user_id = 14409 2025-08-05 18:20:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77689131 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 18:20:08 [INFO]: updateIdsQuantity -> ["77492035","77689131"] 2025-08-05 18:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-05 18:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77492035 THEN 0 WHEN id = 77689131 THEN 0 END, quantityflag = CASE WHEN id = 77492035 THEN 0 WHEN id = 77689131 THEN 0 END WHERE user_id = 14409 AND id IN (77492035,77689131) 2025-08-05 18:20:08 [INFO]: QUANTITY Updated IDs: 77492035, 77689131 2025-08-05 18:20:08 [INFO]: Successfully processed data for user 14409 2025-08-05 18:20:08 [INFO]: Execution Started 2025-08-05 18:20:08 [INFO]: Execution Finished 2025-08-05 18:30:01 [INFO]: Execution Started 2025-08-05 18:30:01 [INFO]: old server sucessfully connected 2025-08-05 18:30:01 [INFO]: sqs client sucess created 2025-08-05 18:30:02 [INFO]: Number of messages in the queue: 3 2025-08-05 18:30:03 [INFO]: item found in queue is if condition 14409 2025-08-05 18:30:03 [INFO]: item found in queue is 14409 2025-08-05 18:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEB8RGp/zGchpORHq7XNLlW46HcgEDBFNjtnkd9DkOC3KVbcOJHebcTMarcUmcBVeedBFaKOxhjQVtN8OSmU/08aFVcruh8zpx0mhaLIS+UbLB0If67UamMOP6MWfljv2XO9VTQCV8PL4DgDICQiR0oI/urvUH8YnGpgeOLqY/QUWKzGi3e9Z/Uob9SWDsIFUv7jZ0pEA5Y6j+Tbe4irmXthjiV8wn8DkiQ655ON7c2XsgXqcDzHB36aLnSkyFTnqGbRaWJ4cbhb+H3DvScoEE4wMfoOn2StSJHdfGSbgAFBR3Bem75IMgnz2fBfFSKcZuZXGgE72LMMuD2ulHWZkit9a2PRQHw/L3BgcZskmW01Yjk9rkDnL98if107BBPLCPZmhmbCoe9HraV9iH6BSdN5bJYL2qjBRr0JTPb8EyYVUqvZtE/+htPWvqGaJe8KLWz 2025-08-05 18:30:03 [INFO]: item found in queue is if condition 14409 2025-08-05 18:30:03 [INFO]: item found in queue is 14409 2025-08-05 18:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEB0YUJ+1HyyEFS7H9dXElWia1frrXEjI7LZK14Pc/4qvwftRu4HedjLIpcj8v8BHZRV7T3XJum8PlgnAqu289QFVzdYYH5TV26GlL4giZWVj1EJXe5jT9RjShqYlbThQhympYdeivL7MBqbf8jXeVmzMZzr85Xh840N891ec4dj0a/NHz5G5xnGcwhLLYuc2VX8xowRXvcamjODtPkBCalt0Hzp6R1ZC8vrRvSOiscRq3odIZNNQKdqi7F0wfBgsPum6wHbIrpFSP+rI45NHCnRpo4n2YnncNjEuHZ1ezFIK3SG9kMQ5xACMQfCsgodLKAwsLMvjHGagEilv2k8cd3/Uip/VEewQ0jW7wp3qB4Ir835/1RyRbB79zt7+TrQaczqUGyeTZo9uyvSSDGENH6iW/ciPQNS6cseESaj/GJscZqjap2kzUvallpodFVuWLJ 2025-08-05 18:30:04 [INFO]: item found in queue is if condition 14409 2025-08-05 18:30:04 [INFO]: item found in queue is 14409 2025-08-05 18:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBBNDXz2WBlLQjrRyjNYH69g4ZbRxWDjd2XVGbnJKLHMmK7/SS1Sv2Ky2MCyIlAMQaABqHq+d+Z1V4NtwezkeSSjzs36DOEGt9RZkJBzOohuIhxtqGeke9XrmwIG6uHlydnVRMKr8PX6R6DrsEZIC7nBqGQiVvTrTZLHd7Lf8gS0sFrm5rhfS8eUaYnCTr7+sP4r0+w5BYIY+UtOvOHuDqdmp/9wISMB3mcAXZ93orDdA8cbYegwOGucUJjaLaeu5yBTUT5IQ+spqUTZKFAja7wpl9ZGq/5RSYTvX7/pGUiWG6HaKr49vxQvcPE1QCp+gBteg+JT7apEpn2OQ45og0+dz9uT6GapIXFxzlM5F+exxUKcmGQvWYd7s7/CPJBeFaoljHE86kwX2WzbtxXeA0lYAlnpmErV2tHOEuaHm6vKFHkICB/QRGFlwlWlJsthak 2025-08-05 18:30:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-05 18:30:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 18:30:04 [INFO]: inside itemsold and closed 14409 2025-08-05 18:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 18:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-05 18:30:07 [INFO]: Ebay item id :: 285323012383 exists in Database 2025-08-05 18:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-05 18:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 18:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 18:30:07 [INFO]: inside itemsold and closed 14409 2025-08-05 18:30:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 18:30:08 [INFO]: autolink for user_id 14409 is 1 2025-08-05 18:30:08 [INFO]: Ebay item id :: 335338598100 exists in Database 2025-08-05 18:30:08 [INFO]: Item is reliested :: exists in Database 2025-08-05 18:30:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 18:30:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 18:30:08 [INFO]: inside itemsold and closed 14409 2025-08-05 18:30:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 18:30:10 [INFO]: autolink for user_id 14409 is 1 2025-08-05 18:30:10 [INFO]: Ebay item id :: 335334664218 exists in Database 2025-08-05 18:30:10 [INFO]: Item is reliested :: exists in Database 2025-08-05 18:30:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 18:30:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 18:30:10 [INFO]: in processold action queue is array for {"44763674":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44763674","ebayitemid":"285323012383","shopifyproductid":"8059773452510","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"8059773452510","shopifyvariantid":"44222116790494","shopifyinventoryid":"46319220981982","shopifylocationid":"","product_id":"44763674","variant_id":"77672216","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44562741":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44562741","ebayitemid":"335338598100","shopifyproductid":"8378672578782","variants":[{"price":"289.99","quantity":0,"weight":"2","shopifyproductid":"8378672578782","shopifyvariantid":"45094597918942","shopifyinventoryid":"47192461050078","shopifylocationid":"","product_id":"44562741","variant_id":"77455421","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44558903":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44558903","ebayitemid":"335334664218","shopifyproductid":"8369981522142","variants":[{"price":"53.99","quantity":0,"weight":"2","shopifyproductid":"8369981522142","shopifyvariantid":"45070828306654","shopifyinventoryid":"47168687833310","shopifylocationid":"","product_id":"44558903","variant_id":"77451583","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 18:30:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 18:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 18:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 18:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 18:30:10 [INFO]: Shopify Inventory id 46319220981982 2025-08-05 18:30:10 [INFO]: Shopify Location id 58450641063 2025-08-05 18:30:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 18:30:11 [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-05 18:30:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 18:30:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44763674 and user_id = 14409 2025-08-05 18:30:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77672216 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 18:30:11 [INFO]: Shopify Inventory id 47192461050078 2025-08-05 18:30:11 [INFO]: Shopify Location id 58450641063 2025-08-05 18:30:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 18:30:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T18:30: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-05 18:30:11 [INFO]: Change: available | Delta: -1 2025-08-05 18:30:11 [INFO]: Change: on_hand | Delta: -1 2025-08-05 18:30:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 18:30:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44562741 and user_id = 14409 2025-08-05 18:30:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77455421 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 18:30:11 [INFO]: Shopify Inventory id 47168687833310 2025-08-05 18:30:11 [INFO]: Shopify Location id 58450641063 2025-08-05 18:30:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 18:30:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T18:30: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-05 18:30:11 [INFO]: Change: available | Delta: -1 2025-08-05 18:30:11 [INFO]: Change: on_hand | Delta: -1 2025-08-05 18:30:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 18:30:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44558903 and user_id = 14409 2025-08-05 18:30:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77451583 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 18:30:11 [INFO]: updateIdsQuantity -> ["77672216","77455421","77451583"] 2025-08-05 18:30:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-05 18:30:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77672216 THEN 0 WHEN id = 77455421 THEN 0 WHEN id = 77451583 THEN 0 END, quantityflag = CASE WHEN id = 77672216 THEN 0 WHEN id = 77455421 THEN 0 WHEN id = 77451583 THEN 0 END WHERE user_id = 14409 AND id IN (77672216,77455421,77451583) 2025-08-05 18:30:11 [INFO]: QUANTITY Updated IDs: 77672216, 77455421, 77451583 2025-08-05 18:30:11 [INFO]: Successfully processed data for user 14409 2025-08-05 18:30:11 [INFO]: Execution Started 2025-08-05 18:30:11 [INFO]: Execution Finished 2025-08-05 18:40:01 [INFO]: Execution Started 2025-08-05 18:40:01 [INFO]: old server sucessfully connected 2025-08-05 18:40:01 [INFO]: sqs client sucess created 2025-08-05 18:40:02 [INFO]: Number of messages in the queue: 1 2025-08-05 18:40:02 [INFO]: item found in queue is if condition 14409 2025-08-05 18:40:02 [INFO]: item found in queue is 14409 2025-08-05 18:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBvqLOwrBerlYbQSTGD1Lbdm4nxcwLqNLaphFkt/eCq7B3LPDzLwi8j+sDcwOQTOP8ThNwKMNKEn7nU/OLnix1/s8Q0pN5b3lg7pvnBqCoC6uwhBwcRLGDFbr2S8AdyQVOkOFsKGaF+aDaNQZMGR6m3gb6I6oAIDIbuPqhPd/C/+8SR9RztZlBO5vJfoksiKYiOsF4bxkdypryRlU3zTe+rk7Sie533MJIv2ONxiMxKFMSw9AWzpoud05MfS059ZQjPlQ1YJd96DElVAVAxTdCCG+fvQOnwzK9RjEpIIkBENoOzn/Z/YNgPZMeO38xI6/foeaVZo2Nw1VA5tVctrt1FpyXNA0MTGtPufqRSPtUMK7IpHotRXlxPNLtM2/t2hJDBIGDXnwPCeuH8vtp/yDxEMUeInKkFFjuZYarwR0fU+OCqaeMy2LfzYjz+alGk16E 2025-08-05 18:40:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-05 18:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 18:40:03 [INFO]: inside itemsold and closed 14409 2025-08-05 18:40:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 18:40:04 [INFO]: autolink for user_id 14409 is 1 2025-08-05 18:40:04 [INFO]: Ebay item id :: 285811207497 exists in Database 2025-08-05 18:40:04 [INFO]: Item is reliested :: exists in Database 2025-08-05 18:40:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 18:40:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 18:40:04 [INFO]: in processold action queue is array for {"44570031":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44570031","ebayitemid":"285811207497","shopifyproductid":"8395929616606","variants":[{"price":"59.99","quantity":0,"weight":"2","shopifyproductid":"8395929616606","shopifyvariantid":"45146775617758","shopifyinventoryid":"47244646875358","shopifylocationid":"","product_id":"44570031","variant_id":"77462715","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 18:40:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 18:40:04 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 18:40:04 [INFO]: Shopify Inventory id 47244646875358 2025-08-05 18:40:04 [INFO]: Shopify Location id 58450641063 2025-08-05 18:40:04 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 18:40:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T18:40:05Z","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-05 18:40:05 [INFO]: Change: available | Delta: -1 2025-08-05 18:40:05 [INFO]: Change: on_hand | Delta: -1 2025-08-05 18:40:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 18:40:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44570031 and user_id = 14409 2025-08-05 18:40:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77462715 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 18:40:05 [INFO]: updateIdsQuantity -> ["77462715"] 2025-08-05 18:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-05 18:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77462715 THEN 0 END, quantityflag = CASE WHEN id = 77462715 THEN 0 END WHERE user_id = 14409 AND id IN (77462715) 2025-08-05 18:40:05 [INFO]: QUANTITY Updated IDs: 77462715 2025-08-05 18:40:05 [INFO]: Successfully processed data for user 14409 2025-08-05 18:40:05 [INFO]: Execution Started 2025-08-05 18:40:05 [INFO]: Execution Finished 2025-08-05 18:50:02 [INFO]: Execution Started 2025-08-05 18:50:02 [INFO]: old server sucessfully connected 2025-08-05 18:50:02 [INFO]: sqs client sucess created 2025-08-05 18:50:03 [INFO]: Number of messages in the queue: 3 2025-08-05 18:50:03 [INFO]: item found in queue is if condition 14409 2025-08-05 18:50:03 [INFO]: item found in queue is 14409 2025-08-05 18:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEB7Ot9GkFgPr0FSz7l9A7N6Zvn9Lc4e+M7a7GKx9c2GuK6gU1SRA4WOufEZ71uOzi0KUyLoGEV6akKiOVy7JX5dVb5OrEuhgzZ0tYP4bMqeABWAQD/Xxzb1L4MgXbrhhmUdsZU20q0GdjO+owLucFXOyLOb90XR/enLeUX0MJ49O9cUT4pStTgFWt+9P2iT5NuClZLN6yymB4fZYkfSLtn4/ODjQhtiGZWgMAu15+CVO2jiwHW6jIY8cktUBRJt+tY51kQKwHcSeMkgDb6w1+hS+masTBezmiio2q+P1sGOV4ahk9UdORCQ0uGvEHWzyHcUX03cSWBMS25QiWuIvtP15bpaEOqysxXySOWGxjhVcFeXXe+rKPzFxcB5jQWJoOsKpX69KHCgKLKzIW/DCPh/SjAfhSId8NUZffiM06o7nl1yAkSbiJlyU0FHA0NbtIJ 2025-08-05 18:50:04 [INFO]: item found in queue is if condition 14409 2025-08-05 18:50:04 [INFO]: item found in queue is 14409 2025-08-05 18:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEB7pGuezCtHStStwHAoE9L7vjtbOrZgL9lUDsf/wcIxXSPDOiY/uU7hdiKScdJp3g9gSGKuXYi8+pAVbVZeUwtbQQESHxz9b/0sTIm8R3iMkIZcxYVw9eVAUsi3wmwMfxmZPzObGqE7g9/jCUsTa+nSnpEsvxhu8ryb/OOgXPsFue3HOEmL3iIso+9MAFH885PiQB4esjnYzTpm330CvNK8MYdCrXBIBzNswAkzJzDMOOTJODLxGaOYm89Gw3E8iQa0+X9lNLiA5VUmq+2VOzxdQR+qDPvhQ9Y6VGxufgrZ0DgxK59w7uLGHr57LeBxBOgZ04znp2tqiPqIIW4sZrsW9lEys5vFgr+tTEH2Yl1vm5Hxd+aWbqvglyW9Mzc3PyA0u+l1Rd5uI0FEj9LMtyQQPy9UOtwBfhlbOMPu3IQChfPYxFqQrkV3MF7yN4zWIdE 2025-08-05 18:50:04 [INFO]: item found in queue is if condition 14409 2025-08-05 18:50:04 [INFO]: item found in queue is 14409 2025-08-05 18:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBz85irJMlpHutEWelGZIW+GNlIIkOqnJJ4eu9ISgekpiXk5XuYr+ZVe+zW0Pnvt5VcFMsRXoMVfrKOM2g/0Z5Hj8B3Pn1ql5v1Qls6JlgY06lPg9VQ4uCDy7BEKOM3dK03V+6fBjvzJKi+I06lOA73NdXUOj6x+hoA4hMaAqYoc5MfJxcXQD2Y/rFW1GfwBva4rxuT+pquRkHfZMIJjy93UvGq8paWxTyEU6/7y1Nt7+Ycnp2Wxd8/LQqr5qOQW6xjPg3Fz8vJcpwpolPHzVCOJiFcw3Mq8EYnKrD67uEubKMJEKoWxgLq9Rg5erubfxx0dTvQ8I/M+/LQgR5o+Cb8QtCRoddCudkTt/tqfHwXFnIw7Uuq72wXEqNcFPfE4bA3uzwDMpn7LzKwwKJy8Xw9pTspKwl+qS3Jg4loKrPG+D6oh7Z/Vyv0UUnhs/BR46Q 2025-08-05 18:50:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-05 18:50:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 18:50:04 [INFO]: inside itemsold and closed 14409 2025-08-05 18:50:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 18:50:06 [INFO]: autolink for user_id 14409 is 1 2025-08-05 18:50:06 [INFO]: Ebay item id :: 285818619974 exists in Database 2025-08-05 18:50:06 [INFO]: Item is reliested :: exists in Database 2025-08-05 18:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 18:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 18:50:06 [INFO]: inside itemsold and closed 14409 2025-08-05 18:50:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 18:50:08 [INFO]: autolink for user_id 14409 is 1 2025-08-05 18:50:08 [INFO]: Ebay item id :: 257045625372 exists in Database 2025-08-05 18:50:08 [INFO]: Item is reliested :: exists in Database 2025-08-05 18:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 18:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 18:50:08 [INFO]: inside itemsold and closed 14409 2025-08-05 18:50:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 18:50:09 [INFO]: autolink for user_id 14409 is 1 2025-08-05 18:50:09 [INFO]: Ebay item id :: 335884833207 exists in Database 2025-08-05 18:50:09 [INFO]: Item is reliested :: exists in Database 2025-08-05 18:50:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 18:50:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 18:50:09 [INFO]: in processold action queue is array for {"44577827":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44577827","ebayitemid":"285818619974","shopifyproductid":"8804000727262","variants":[{"price":"74.99","quantity":0,"weight":"2","shopifyproductid":"8804000727262","shopifyvariantid":"46255456911582","shopifyinventoryid":"48356079501534","shopifylocationid":"","product_id":"44577827","variant_id":"77470534","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45313000":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313000","ebayitemid":"257045625372","shopifyproductid":"8976339009758","variants":[{"price":"89.99","quantity":0,"weight":"3","shopifyproductid":"8976339009758","shopifyvariantid":"47192032248030","shopifyinventoryid":"49303871226078","shopifylocationid":"58450641063","product_id":"45313000","variant_id":"78265513","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44594587":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44594587","ebayitemid":"335884833207","shopifyproductid":"8857420726494","variants":[{"price":"26.99","quantity":0,"weight":"0.5","shopifyproductid":"8857420726494","shopifyvariantid":"46494748606686","shopifyinventoryid":"48596959854814","shopifylocationid":"","product_id":"44594587","variant_id":"77487296","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 18:50:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 18:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 18:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 18:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 18:50:09 [INFO]: Shopify Inventory id 48356079501534 2025-08-05 18:50:09 [INFO]: Shopify Location id 58450641063 2025-08-05 18:50:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 18:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T18:50:10Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 18:50:10 [INFO]: Change: available | Delta: -2 2025-08-05 18:50:10 [INFO]: Change: on_hand | Delta: -2 2025-08-05 18:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 18:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44577827 and user_id = 14409 2025-08-05 18:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77470534 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 18:50:10 [INFO]: Shopify Inventory id 49303871226078 2025-08-05 18:50:10 [INFO]: Shopify Location id 58450641063 2025-08-05 18:50:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 18:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T18: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-05 18:50:10 [INFO]: Change: available | Delta: -1 2025-08-05 18:50:10 [INFO]: Change: on_hand | Delta: -1 2025-08-05 18:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 18:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313000 and user_id = 14409 2025-08-05 18:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265513 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 18:50:10 [INFO]: Shopify Inventory id 48596959854814 2025-08-05 18:50:10 [INFO]: Shopify Location id 58450641063 2025-08-05 18:50:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 18:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T18: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-05 18:50:10 [INFO]: Change: available | Delta: -1 2025-08-05 18:50:10 [INFO]: Change: on_hand | Delta: -1 2025-08-05 18:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 18:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44594587 and user_id = 14409 2025-08-05 18:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77487296 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 18:50:10 [INFO]: updateIdsQuantity -> ["77470534","78265513","77487296"] 2025-08-05 18:50:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-05 18:50:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77470534 THEN 0 WHEN id = 78265513 THEN 0 WHEN id = 77487296 THEN 0 END, quantityflag = CASE WHEN id = 77470534 THEN 0 WHEN id = 78265513 THEN 0 WHEN id = 77487296 THEN 0 END WHERE user_id = 14409 AND id IN (77470534,78265513,77487296) 2025-08-05 18:50:10 [INFO]: QUANTITY Updated IDs: 77470534, 78265513, 77487296 2025-08-05 18:50:10 [INFO]: Successfully processed data for user 14409 2025-08-05 18:50:10 [INFO]: Execution Started 2025-08-05 18:50:10 [INFO]: Execution Finished