2025-08-07 16:00:01 [INFO]: Execution Started 2025-08-07 16:00:01 [INFO]: old server sucessfully connected 2025-08-07 16:00:01 [INFO]: sqs client sucess created 2025-08-07 16:00:06 [INFO]: Number of messages in the queue: 2 2025-08-07 16:00:07 [INFO]: item found in queue is if condition 14409 2025-08-07 16:00:07 [INFO]: item found in queue is 14409 2025-08-07 16:00:07 [INFO]: Message deleted from the queue for receipt handle: AQEBivjOkbFN5wNFI6LMq5Gz3+TMBGN+VcXh+1vxI1Gauen23Wynw3YSgdGNWoG4oNLxqnOH59ui0b+zAjSlIXmt2yYTa5vTUe1c4ExttBXcTzgrkaMSqLPFxCgP8wWnsYWuLFe6CYKw4yrAjGDaDaCRPPR2PxZxE6Y8mWDHKG4WgjYNZvjhVsY43qDAnRvz07Mdr5yiB7wOsGann0G6FRrcwtRB+/k2cK6f/wgl6L7+bVYQ1OqwKnL4KKgx2JRo5IrKCBanTH6kkSBkVEo7lo2XadnRoh5UdRLk42O4uusUiuj2oK66uwwV4bx4O/Wgtai2hpmIB4g0LAjpqd18Z7MPjxYOHAElglnH9TRqurJLlrSBt5uID+gXBPaWOFODeHi0+srVLz7uD12dctu3PVFNcJHkep3Yssx2PItS0/YiGwgXGxkRcwNE1fei2Vblbrvk 2025-08-07 16:00:08 [INFO]: item found in queue is if condition 14409 2025-08-07 16:00:08 [INFO]: item found in queue is 14409 2025-08-07 16:00:10 [INFO]: Message deleted from the queue for receipt handle: AQEBE7xSoi6M5c937VNltRe2JynYhLfLfmJX52u9Z+EMKoE6fLumngrHNtkCTdVSGiQG7JbmS2Z3SuIwmXVM5TKZBUOBF/e70GFF09tvCChXoH3hVilauTEJ4QXV5TMCEpgp6QJ2vLKMq9uzvaDh8r2aT2VBN+VEFUbwyqC4lALQY/bfTddFjgFlyUdZRxGM4g1onI4y4pgAgum/EYCb3wAvTERsH8HGNGm2QVachd8Ixj1NLtjzZRNwaHlb75FmZKi/jlObEGO4D9CBaNlPW5ozkFpfjtriTVgPRqqZvVLKJhD3zvf4VEpgE5vWUTenVzY/pYzmSFN7gYycyzstGh/+zdKmbBM48MBJodkRy+u9Q9uHajaLW/sF5SnIWwGcCgFmLcxXxX/2VZd4Oxuzprqxkl2w0A+Os+H4QVqD4gk3oFw8/8XNS5T2jW7qCLlkD8rh 2025-08-07 16:00:10 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-07 16:00:10 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 16:00:10 [INFO]: inside itemsold and closed 14409 2025-08-07 16:00:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 16:00:12 [INFO]: autolink for user_id 14409 is 1 2025-08-07 16:00:12 [INFO]: Ebay item id :: 306234052317 exists in Database 2025-08-07 16:00:12 [INFO]: Item is reliested :: exists in Database 2025-08-07 16:00:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 16:00:12 [INFO]: inside itemsold and closed 14409 2025-08-07 16:00:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 16:00:13 [INFO]: autolink for user_id 14409 is 1 2025-08-07 16:00:13 [INFO]: Ebay item id :: 286381593803 exists in Database 2025-08-07 16:00:13 [INFO]: Item is reliested :: exists in Database 2025-08-07 16:00:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 16:00:13 [INFO]: in processold action queue is array for [] 2025-08-07 16:00:13 [INFO]: Successfully processed data for user 14409 2025-08-07 16:00:13 [INFO]: Execution Started 2025-08-07 16:00:13 [INFO]: Execution Finished 2025-08-07 16:10:01 [INFO]: Execution Started 2025-08-07 16:10:01 [INFO]: old server sucessfully connected 2025-08-07 16:10:01 [INFO]: sqs client sucess created 2025-08-07 16:10:03 [INFO]: Number of messages in the queue: 2 2025-08-07 16:10:06 [INFO]: item found in queue is if condition 14409 2025-08-07 16:10:06 [INFO]: item found in queue is 14409 2025-08-07 16:10:06 [INFO]: Message deleted from the queue for receipt handle: AQEBDVJoTcvP9vfnHMmRHRT7R89D2BM9vdxON6Jf4KLx7i9bl0IqllEH7d/5zB/W6CcGL+vH6ZPZhk6igA2AJvedfsbQ3jVttgKBaWcVP5KsnDCtx2dgsTUMdj0AAyEywi/i2Sg+MZxCjU5/RG+WhBqaBJciCS0ZTBoiHzscZlv9oGeZepWizMsdEqw/BAQa85q2tf73Z8d5F+HqDQ/tuJm70u5VFp6IxoSKC5eyKmHcfKkc0fkajbt57iyAHWylsU3FS88ZmjS13QB9IsA2OFFiLQHDFNB+/vqQCPTCRZXnV69XMLyUEP844AKT1FgVZ3KZyBOrFzVhhgnquiXlbFehkVmRk6vS9nvz+OYXoHywS5yJKauxIW/PbJ3JKeeUI/8rfEojm1OjgAJSCaBhXG1/pEEIjI8PR2s1f70pTHDV6pcoHve7w2Tpr4WFA/8sTnPg 2025-08-07 16:10:07 [INFO]: item found in queue is if condition 14409 2025-08-07 16:10:07 [INFO]: item found in queue is 14409 2025-08-07 16:10:07 [INFO]: Message deleted from the queue for receipt handle: AQEBEY0MsbvO40fc2oAByoUVMs0x9MDewU4dVIIT1e+Q+WZRnB9kEQBSFcdFyoeVnoBR/d+n0djaFudae3vDmByh1+/Clk4YHOiwuksxQJ5lNAE/2jKZ+hYf3jnRHUxQSGt02P7jWZqMkPsgoLz6+M2msRenj88Hb+m2xYF879pke91P9zEb1RuRUfQQI5swnhLAJK8Qr9CuQ9wKg9egZsN1T8B3WDGPLFgdCDnem+4Ilg3GbAriY5N8roZFC5ICInbjajG3CcgbyP5MHdmN/TFcZCUziZ0cBcENv9BTJEuU/vOIYxrihUzvmqev4WYNyIQMoRTI7R9qs8VSFwPt3Y+udX9cmnaW5eT7kRZyEQc5xd3XtNjltHk0mrdSTMIRG0AbUblrnZtPi8S+g6iVMBk9jSAjcpg7thM3MHv1vX6VNCuOnCMAm0o4Qq8G5CXn342q 2025-08-07 16:10:07 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-07 16:10:07 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 16:10:07 [INFO]: inside itemsold and closed 14409 2025-08-07 16:10:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 16:10:09 [INFO]: autolink for user_id 14409 is 1 2025-08-07 16:10:09 [INFO]: Ebay item id :: 336072449704 exists in Database 2025-08-07 16:10:09 [INFO]: Item is reliested :: exists in Database 2025-08-07 16:10:09 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-07 16:10:09 [INFO]: inside itemsold and closed 14409 2025-08-07 16:10:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 16:10:11 [INFO]: autolink for user_id 14409 is 1 2025-08-07 16:10:11 [INFO]: Ebay item id :: 405320384435 exists in Database 2025-08-07 16:10:11 [INFO]: Item is reliested :: exists in Database 2025-08-07 16:10:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 16:10:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 16:10:11 [INFO]: in processold action queue is array for {"45241600":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45241600","ebayitemid":"336072449704","deleted":1}},"44776379":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44776379","ebayitemid":"405320384435","shopifyproductid":"8722190926046","variants":[{"price":"11.99","quantity":0,"weight":"0.5","shopifyproductid":"8722190926046","shopifyvariantid":"46002054725854","shopifyinventoryid":"48100472881374","shopifylocationid":"","product_id":"44776379","variant_id":"77684920","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 16:10:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 16:10:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 16:10:11 [INFO]: productIds WHich are having null productid -> [45241600] 2025-08-07 16:10:11 [INFO]: ebayItemIds WHich are not imported-> ["336072449704"] 2025-08-07 16:10:11 [INFO]: Entered in bulkUpdateProducts function 2025-08-07 16:10:11 [INFO]: Transaction started for bulkUpdateProducts 2025-08-07 16:10:11 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45241600) 2025-08-07 16:10:11 [INFO]: Query executed successfully. Affected rows: 0 2025-08-07 16:10:11 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-07 16:10:11 [INFO]: Transaction committed successfully. 2025-08-07 16:10:11 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-07 16:10:11 [INFO]: Shopify Inventory id 48100472881374 2025-08-07 16:10:11 [INFO]: Shopify Location id 58450641063 2025-08-07 16:10:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 16:10: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-07 16:10:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 16:10:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44776379 and user_id = 14409 2025-08-07 16:10:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77684920 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 16:10:11 [INFO]: updateIdsQuantity -> ["77684920"] 2025-08-07 16:10:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 16:10:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77684920 THEN 0 END, quantityflag = CASE WHEN id = 77684920 THEN 0 END WHERE user_id = 14409 AND id IN (77684920) 2025-08-07 16:10:11 [INFO]: QUANTITY Updated IDs: 77684920 2025-08-07 16:10:11 [INFO]: Successfully processed data for user 14409 2025-08-07 16:10:11 [INFO]: Execution Started 2025-08-07 16:10:11 [INFO]: Execution Finished 2025-08-07 16:20:01 [INFO]: Execution Started 2025-08-07 16:20:01 [INFO]: old server sucessfully connected 2025-08-07 16:20:01 [INFO]: sqs client sucess created 2025-08-07 16:20:03 [INFO]: Number of messages in the queue: 0 2025-08-07 16:20:24 [INFO]: Execution Started 2025-08-07 16:20:24 [INFO]: Execution Finished 2025-08-07 16:30:01 [INFO]: Execution Started 2025-08-07 16:30:01 [INFO]: old server sucessfully connected 2025-08-07 16:30:01 [INFO]: sqs client sucess created 2025-08-07 16:30:03 [INFO]: Number of messages in the queue: 0 2025-08-07 16:30:23 [INFO]: Execution Started 2025-08-07 16:30:23 [INFO]: Execution Finished 2025-08-07 16:40:01 [INFO]: Execution Started 2025-08-07 16:40:01 [INFO]: old server sucessfully connected 2025-08-07 16:40:01 [INFO]: sqs client sucess created 2025-08-07 16:40:02 [INFO]: Number of messages in the queue: 4 2025-08-07 16:40:03 [INFO]: item found in queue is if condition 14409 2025-08-07 16:40:03 [INFO]: item found in queue is 14409 2025-08-07 16:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBY0cv4XEVfH8cw3RaiwnFiMApaVPscH/aG3PFhPw6mtG6Ku/qGJlV1zjW0EoVOGsIbKwAFa1JwHfm4VRxcte+FTUNWh1ytYAZkwRAE1Vuasqeok9FJH5ldoTQSshFdZA1P5f/3zjfPzrgvEhVKgWkUykQWqDxzdTmtaIIdGBypkUfuUzWj9tdYSQQJ9HKU51NRyTizV2VXdhn52mgTVZx6jJ7R3tncBYz9EYVM3vNBO6X+yvDhtPfdF3D+QGnVbklt+b0fAu2sbVbdZBUTZagXMy2j9UltSOd/hi0+QSkp9EsjKoBSi7+ZneV+KcEjqWnIQbFEsrqShBiwEHX2oZh81vkeEoa5/llxFJf9jDFgT1NN1OsKvfxPYNrAfTbvW5d21hfSYlv9VUw99ZZFIvVK6LEF6erOfkmJVO9pFywJlvnbGei6T/6AZG0K6VGbe3X 2025-08-07 16:40:03 [INFO]: item found in queue is if condition 14409 2025-08-07 16:40:03 [INFO]: item found in queue is 14409 2025-08-07 16:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBtsE+qmmeq0UvNSx7YmX8vFwMEMQ791FkS6LO9hwDkH6/yTtuE9EdNZx/gOw6Utz+nwCrKhtpDiaK651UeVqqD5XIx+efiY65vRE5u2xHOhXXqTgxB7TlXVcVa7954SOpi/+i/WzIkOfXZ1VCwsbswlK84zhOVv62mTN6irbUAnrW7FEy3DDLjZDhn1RZum6CeQylaguWoBkS7H9EsoUyLKwHMNpBdVNPLIWAEuHekCO7kH/iWe0hP3TO8PVO/1x3DeMTmhIVnVUt2EUmBNqCToZsZnBMqhF6IjQl3c8vzEXCcpRyRVHmkbLuj/rtNAkVE/nhVE7MV+Ddxz77JjHmkMDRZYtcQNrwsT7xrlCY61sQz6/EbN04S4oALzpqD3ZrwLGUJnPjkta3GNMs+7sJV0kecg0kt8S0neE3vsAeUEgHFsepXoymHGrMoQ43+oxK 2025-08-07 16:40:03 [INFO]: item found in queue is if condition 14409 2025-08-07 16:40:03 [INFO]: item found in queue is 14409 2025-08-07 16:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBfAQ0E+sxkVzKYPZBQvskBykLj2IcHlDgen0IIDOD2NIFJV0ine9sbVk1iQoxKkr70n7XYaZiBkUpH9NAFgpH5D5D8mo6dTzoiasUiKg/50eWSk/4V3C8EQB4/nscAOFOiPee1/ptumMZ3J1u8qkJAEdKXmyXmPi/P5bMGg3u6M/RmfPt1k6ENGdkOGstGuud/uK8ei5nxR+ab6v6KwFRTUoiDFbRiS37VOg9M/q2VdYFhVsbMtBSBOFK03Q+QD2IMhtj5AXt5mzkDhQKVkbi/tqJiAHwnyjQhnVGVZ9TJEbgEPQBaeatponD3YZKKWw+T/lG3OyXYVK8Bvz82SZnhga0k9GjgOCBnEKJMX1Z8EqAsQtpfI0BhiDkXTMAvawAL3COjcxByx9yhXGE1kR2vmUcKXVZukgArTMuXkph9TH8m6MzUWnqpvpYJYCdH/nV 2025-08-07 16:40:04 [INFO]: item found in queue is if condition 14409 2025-08-07 16:40:04 [INFO]: item found in queue is 14409 2025-08-07 16:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBqyy+PmL+tQ0RnsgGBa5IIb9ZCAGwcxN9xkldAliVsFJLgHGvo5lPYi2JSBNWO8PMr06ziABjtPhERV4muSvbVjluoxfAJ7qK5hJj7vzfVf2Mq+dYtuthhiaGWikXP7Jtg0XYiGG7SmPbYexXiNXvXyULtCJjn0+M9DIp1PMzL87IXlKlAqm4rvyKYvRnqCBGEhuneJvYnmKIVZ25W1BEuxcJVq1Cec+nCeZAoSCU9h2EIBBh3mWHX7hWcWTS7dkJig0sA65I3YyvqJNweZF2KXoeKu6fhKV7C8qOvuZ1pC2vM3kY3LfTS5zwzO+ve86Hv1ZM2RONI11Lc8JY7VwnO/kJNZHg2UCTwjYtCR1Mg4OgAx3/aXAWjGttn7nGFIISmCjtrLJPhpscmFvUQSTCQd9KD2YKrtPw9yFZ1cQ4DHqfqeB4+bB4mxMc4Di1mK3W 2025-08-07 16:40:04 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-07 16:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 16:40:04 [INFO]: inside itemsold and closed 14409 2025-08-07 16:40:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 16:40:06 [INFO]: autolink for user_id 14409 is 1 2025-08-07 16:40:06 [INFO]: Ebay item id :: 405711535289 exists in Database 2025-08-07 16:40:06 [INFO]: Item is reliested :: exists in Database 2025-08-07 16:40:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 16:40:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 16:40:06 [INFO]: inside itemsold and closed 14409 2025-08-07 16:40:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 16:40:08 [INFO]: autolink for user_id 14409 is 1 2025-08-07 16:40:08 [INFO]: Ebay item id :: 285077078093 exists in Database 2025-08-07 16:40:08 [INFO]: Item is reliested :: exists in Database 2025-08-07 16:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 16:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 16:40:08 [INFO]: inside itemsold and closed 14409 2025-08-07 16:40:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 16:40:10 [INFO]: autolink for user_id 14409 is 1 2025-08-07 16:40:10 [INFO]: Ebay item id :: 256518573921 exists in Database 2025-08-07 16:40:10 [INFO]: Item is reliested :: exists in Database 2025-08-07 16:40:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 16:40:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 16:40:10 [INFO]: inside itemsold and closed 14409 2025-08-07 16:40:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 16:40:11 [INFO]: autolink for user_id 14409 is 1 2025-08-07 16:40:11 [INFO]: Ebay item id :: 286491074497 exists in Database 2025-08-07 16:40:11 [INFO]: Item is reliested :: exists in Database 2025-08-07 16:40:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 16:40:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 16:40:11 [INFO]: in processold action queue is array for {"44785225":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44785225","ebayitemid":"405711535289","shopifyproductid":"8917838233822","variants":[{"price":"29.99","quantity":0,"weight":"3","shopifyproductid":"8917838233822","shopifyvariantid":"46726870499550","shopifyinventoryid":"48825357893854","shopifylocationid":"58450641063","product_id":"44785225","variant_id":"77694665","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44646027":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44646027","ebayitemid":"285077078093","shopifyproductid":"7921576444126","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"7921576444126","shopifyvariantid":"43855857844446","shopifyinventoryid":"45951973851358","shopifylocationid":"","product_id":"44646027","variant_id":"77551216","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44664195":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44664195","ebayitemid":"256518573921","shopifyproductid":"8495747268830","variants":[{"price":"28.99","quantity":0,"weight":"0.75","shopifyproductid":"8495747268830","shopifyvariantid":"45400929468638","shopifyinventoryid":"47498908303582","shopifylocationid":"","product_id":"44664195","variant_id":"77569415","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44574043":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44574043","ebayitemid":"286491074497","shopifyproductid":"8876441600222","variants":[{"price":"313.49","quantity":0,"weight":"15","shopifyproductid":"8876441600222","shopifyvariantid":"46610029117662","shopifyinventoryid":"48712886550750","shopifylocationid":"","product_id":"44574043","variant_id":"77466750","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 16:40:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 16:40:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 16:40:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 16:40:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 16:40:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 16:40:12 [INFO]: Shopify Inventory id 48825357893854 2025-08-07 16:40:12 [INFO]: Shopify Location id 58450641063 2025-08-07 16:40:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 16:40:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T16:40:12Z","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-07 16:40:12 [INFO]: Change: available | Delta: -1 2025-08-07 16:40:12 [INFO]: Change: on_hand | Delta: -1 2025-08-07 16:40:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 16:40:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44785225 and user_id = 14409 2025-08-07 16:40:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77694665 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 16:40:12 [INFO]: Shopify Inventory id 45951973851358 2025-08-07 16:40:12 [INFO]: Shopify Location id 58450641063 2025-08-07 16:40:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 16:40:12 [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-07 16:40:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 16:40:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44646027 and user_id = 14409 2025-08-07 16:40:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77551216 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 16:40:12 [INFO]: Shopify Inventory id 47498908303582 2025-08-07 16:40:12 [INFO]: Shopify Location id 58450641063 2025-08-07 16:40:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 16:40:12 [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-07 16:40:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 16:40:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44664195 and user_id = 14409 2025-08-07 16:40:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77569415 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 16:40:12 [INFO]: Shopify Inventory id 48712886550750 2025-08-07 16:40:12 [INFO]: Shopify Location id 58450641063 2025-08-07 16:40:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 16:40:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T16:40:13Z","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-07 16:40:13 [INFO]: Change: available | Delta: -1 2025-08-07 16:40:13 [INFO]: Change: on_hand | Delta: -1 2025-08-07 16:40:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 16:40:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44574043 and user_id = 14409 2025-08-07 16:40:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77466750 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 16:40:13 [INFO]: updateIdsQuantity -> ["77694665","77551216","77569415","77466750"] 2025-08-07 16:40:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4 2025-08-07 16:40:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77694665 THEN 0 WHEN id = 77551216 THEN 0 WHEN id = 77569415 THEN 0 WHEN id = 77466750 THEN 0 END, quantityflag = CASE WHEN id = 77694665 THEN 0 WHEN id = 77551216 THEN 0 WHEN id = 77569415 THEN 0 WHEN id = 77466750 THEN 0 END WHERE user_id = 14409 AND id IN (77694665,77551216,77569415,77466750) 2025-08-07 16:40:13 [INFO]: QUANTITY Updated IDs: 77694665, 77551216, 77569415, 77466750 2025-08-07 16:40:13 [INFO]: Successfully processed data for user 14409 2025-08-07 16:40:13 [INFO]: Execution Started 2025-08-07 16:40:13 [INFO]: Execution Finished 2025-08-07 16:50:01 [INFO]: Execution Started 2025-08-07 16:50:01 [INFO]: old server sucessfully connected 2025-08-07 16:50:01 [INFO]: sqs client sucess created 2025-08-07 16:50:02 [INFO]: Number of messages in the queue: 1 2025-08-07 16:50:03 [INFO]: item found in queue is if condition 14409 2025-08-07 16:50:03 [INFO]: item found in queue is 14409 2025-08-07 16:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBxf8Nj1YkOhfxpDAAnoc5RbyWtlIQMphlMm1rN6WtRgOheqvcv+25FQIDaKRtb0mvqHQKTAMkRFi/nf4ATStHXn70nSUQlpdmBDvBktzLXOR9O/AArREC3J9vpvY5AQGk3SuVsP9Ch1gRWtNrlLfIqoMKEs3Hz8jZI14a3iCyR1ki6oAbJXkE2+BL2OB8OVwAbhhIE4rwsBozkSPwLFBkEPcZy6Kjb+kLK3J1u2o9pWHajp3TMB0Fa/lvpDckvK9uu5Jc8KR+dmlJGUSGHgOm2J2SeFkBu7DhupWvVO97vihNxSVMkrDL+3gqwcXOpUu1Jqyal2UBzuyOs/S7z7SLn/E/5Uwy+DC7rGBz9EZplLXEkZKGubzFZSpX4l1arnT7Zg6uvHTJZaJEGUsHJWm3F0iIC0umi5L9bE97Z1INkWOk1SIMwJdDTy8h37JfZDof 2025-08-07 16:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 16:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 16:50:03 [INFO]: inside itemsold and closed 14409 2025-08-07 16:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 16:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-07 16:50:05 [INFO]: Ebay item id :: 286640742321 exists in Database 2025-08-07 16:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-07 16:50:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-07 16:50:05 [INFO]: in processold action queue is array for {"45113669":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45113669","ebayitemid":"286640742321","deleted":1}}} 2025-08-07 16:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 16:50:05 [INFO]: productIds WHich are having null productid -> [45113669] 2025-08-07 16:50:05 [INFO]: ebayItemIds WHich are not imported-> ["286640742321"] 2025-08-07 16:50:05 [INFO]: Entered in bulkUpdateProducts function 2025-08-07 16:50:05 [INFO]: Transaction started for bulkUpdateProducts 2025-08-07 16:50:05 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45113669) 2025-08-07 16:50:05 [INFO]: Query executed successfully. Affected rows: 0 2025-08-07 16:50:05 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-07 16:50:05 [INFO]: Transaction committed successfully. 2025-08-07 16:50:05 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-07 16:50:05 [INFO]: Successfully processed data for user 14409 2025-08-07 16:50:05 [INFO]: Execution Started 2025-08-07 16:50:05 [INFO]: Execution Finished