2025-08-12 23:00:01 [INFO]: Execution Started 2025-08-12 23:00:01 [INFO]: old server sucessfully connected 2025-08-12 23:00:01 [INFO]: sqs client sucess created 2025-08-12 23:00:02 [INFO]: Number of messages in the queue: 1 2025-08-12 23:00:03 [INFO]: item found in queue is if condition 14409 2025-08-12 23:00:03 [INFO]: item found in queue is 14409 2025-08-12 23:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBtoSuN4mY0BO8HI08dkC1OLHbIecj5dkbBfCahk5EydRp6BjfFrJxqsnTnqGdhf7tmZDaIm4EvgmXDCZ6Rp9/nwZMf30vSDqXQYIwyZTgJE7p6vGBAkn6u0qJ00ON0yryNkerdS90PcSm+Q5wphqu5z6zYL0LAUyhUIUuhnWYiEc2Ob6Qw0jp7xCMDGATVWASEarL3gr9Iu+fbIjo69yvAdNQAxyoR2GTbzXURiwX5DpKGHKhw0vV2v+U65uG2/d50Bb53Skub9xpJqL831ssVIbcpsQUcmBDS9Pnpe5NVAuTrqnFL5SwoEoe3pXJJq3gqslm23uN2Rvy15EXwueXd3LFMisdXQ6QW2FYfCKGhCl5LKxMFTl9+fZ34SvadNDBrdzKzPxaa92n++hX5E9JtE5GiI2zC/lUrDgd8wxio/TJLGltstauy3US5zlyRZ8X 2025-08-12 23:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-12 23:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 23:00:03 [INFO]: inside itemsold and closed 14409 2025-08-12 23:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 23:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-12 23:00:05 [INFO]: Ebay item id :: 257060567902 exists in Database 2025-08-12 23:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-12 23:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 23:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 23:00:05 [INFO]: in processold action queue is array for {"45313973":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313973","ebayitemid":"257060567902","shopifyproductid":"8984581734622","variants":[{"price":"69.99","quantity":0,"weight":"3","shopifyproductid":"8984581734622","shopifyvariantid":"47437148520670","shopifyinventoryid":"49549002539230","shopifylocationid":"58450641063","product_id":"45313973","variant_id":"78266486","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 23:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 23:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 23:00:05 [INFO]: Shopify Inventory id 49549002539230 2025-08-12 23:00:05 [INFO]: Shopify Location id 58450641063 2025-08-12 23:00:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 23:00:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T23:00: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-12 23:00:05 [INFO]: Change: available | Delta: -1 2025-08-12 23:00:05 [INFO]: Change: on_hand | Delta: -1 2025-08-12 23:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 23:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313973 and user_id = 14409 2025-08-12 23:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266486 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 23:00:05 [INFO]: updateIdsQuantity -> ["78266486"] 2025-08-12 23:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-12 23:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78266486 THEN 0 END, quantityflag = CASE WHEN id = 78266486 THEN 0 END WHERE user_id = 14409 AND id IN (78266486) 2025-08-12 23:00:05 [INFO]: QUANTITY Updated IDs: 78266486 2025-08-12 23:00:05 [INFO]: Successfully processed data for user 14409 2025-08-12 23:00:05 [INFO]: Execution Started 2025-08-12 23:00:05 [INFO]: Execution Finished 2025-08-12 23:10:01 [INFO]: Execution Started 2025-08-12 23:10:01 [INFO]: old server sucessfully connected 2025-08-12 23:10:01 [INFO]: sqs client sucess created 2025-08-12 23:10:02 [INFO]: Number of messages in the queue: 1 2025-08-12 23:10:03 [INFO]: item found in queue is if condition 14409 2025-08-12 23:10:03 [INFO]: item found in queue is 14409 2025-08-12 23:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBKDGaVq+SIO/ib45hX1pF+fPC4QnX4Hf0L7IvdgwCMxN81AogZUmvdmgmZwHbxIDstBhpuGMBWcoyg61TBBUS+vD3sN2LxIr9xin+Tw4QMdkPxjCnpswIvX6EFRpzOCOdIpxHVFgB+ueiW4bBWRktSkMkXEs7X8KES3K99EUqp3NSc+vP0njhIheNoioJTo1XD1Q5YV848ZwmFlvof1M6MGcCzTje9hYbl6jk6hfqElPOHPEoKFCZbxBy0zxjsP7vPNHXiyeA+3w4RSvipCCf7YBOkJFbRcKNPC5YgNSD/9JblpujELYhRb7X3MNj/uj8VULyzs0mHhAYxIqy6xeXBkRqLe3pnj+0X6ajY1dksmxfDydeGFAphg4Yd1MdyNlw7hV4WtxsUwN1lXWo18z7s73GXpbacYHUUkoiLHTPgFiVD/SBKIg3i6FagMGka3yS 2025-08-12 23:10:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-12 23:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 23:10:03 [INFO]: inside itemsold and closed 14409 2025-08-12 23:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 23:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-12 23:10:05 [INFO]: Ebay item id :: 254795321711 exists in Database 2025-08-12 23:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-12 23:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 23:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 23:10:05 [INFO]: in processold action queue is array for {"44746349":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44746349","ebayitemid":"254795321711","shopifyproductid":"6639103017127","variants":[{"price":"9.99","quantity":0,"weight":"0","shopifyproductid":"6639103017127","shopifyvariantid":"39671178789031","shopifyinventoryid":"41765884625063","shopifylocationid":"","product_id":"44746349","variant_id":"77654757","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 23:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 23:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 23:10:05 [INFO]: Shopify Inventory id 41765884625063 2025-08-12 23:10:05 [INFO]: Shopify Location id 58450641063 2025-08-12 23:10:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 23:10:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-12 23:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 23:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44746349 and user_id = 14409 2025-08-12 23:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77654757 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 23:10:05 [INFO]: updateIdsQuantity -> ["77654757"] 2025-08-12 23:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-12 23:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77654757 THEN 0 END, quantityflag = CASE WHEN id = 77654757 THEN 0 END WHERE user_id = 14409 AND id IN (77654757) 2025-08-12 23:10:05 [INFO]: QUANTITY Updated IDs: 77654757 2025-08-12 23:10:05 [INFO]: Successfully processed data for user 14409 2025-08-12 23:10:05 [INFO]: Execution Started 2025-08-12 23:10:05 [INFO]: Execution Finished 2025-08-12 23:20:01 [INFO]: Execution Started 2025-08-12 23:20:01 [INFO]: old server sucessfully connected 2025-08-12 23:20:01 [INFO]: sqs client sucess created 2025-08-12 23:20:02 [INFO]: Number of messages in the queue: 2 2025-08-12 23:20:03 [INFO]: item found in queue is if condition 14409 2025-08-12 23:20:03 [INFO]: item found in queue is 14409 2025-08-12 23:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBVjxgOnPOQJFn36lDDj5IdsAj0ol+SC3PRWR26Nsk4+JELQGTKUyRplvubA7pFl9s9iLByiI+QzB2HdwZHYXNdudHOgDvqwwNBw3H5VUbkwzgt6xy16j9h/reo6q7RIAUVKq8GvUvyz7ESqyDf0fIN957S3HEZrfL9Id2Q9DriYipS/akggk4zy7GZiJL0tQf4lPmpg2QThLV4WtprN3zX/XtKdZNQVUjZeHPwYwPkYAHsoiXb1XsEPaejQsotUgDQRtEHuZh04IuTLEWupEY36b0OUxQ4qy0s7YPQu7j9QwNS4GtP2FlCnbI5srjoWM7NOm4bOjfv9utV7EFWW14mZFgmn3Al3gDhNAmYCeGSF1VMPr4pmoGv9S55aZGSVYrh1GG9La+eYAbk4c92zj2BpvImpJiqwxzrdEikHyjOQPU2cpGvoGJw40C/t/BD3DJ 2025-08-12 23:20:03 [INFO]: item found in queue is if condition 14409 2025-08-12 23:20:03 [INFO]: item found in queue is 14409 2025-08-12 23:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBGj7/Xf8P3l1AsOyoyEvVOyyANaPN+iWIOiHAk9CQ1j2lSMC0uBdq6yY65qi8+wsiM/cFK6LlVdLoz5+l7zbj22vZJ/fga498YCEQXEcNUWh+grf4UI5if6rBbpo/p19rLI50rRYI95xzo32TG2l+K2gKysYObKvbJGzh2nY4zJgj2TFuYUAfZC+hQO/zmpZnVmZYAN4P16veeiGVG6LAFqhLUyeVzeUMBkJ4TD+egfqjqPVux08lnqyqJMdSkXRSPpIoIyU13vkgmRMlciqtF4dCsyNO2x95TAjhf20v5/UF4FJpOiuj+K8fVggAv8mfLvKLkeP5NOqW2rYuuWkFf+m2VU3bdtCIKt6cZf1noG3S1WXDY85roEbIQLF91h0xLClIM95ZObnCufjC/K96kcwAXeAHBP0glHdd1rr20906rXwiXOcfC0Lj1guUBuyM 2025-08-12 23:20:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-12 23:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 23:20:03 [INFO]: inside itemsold and closed 14409 2025-08-12 23:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 23:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-12 23:20:05 [INFO]: Ebay item id :: 326136958305 exists in Database 2025-08-12 23:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-12 23:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 23:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 23:20:05 [INFO]: inside itemsold and closed 14409 2025-08-12 23:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 23:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-12 23:20:07 [INFO]: Ebay item id :: 256921463534 exists in Database 2025-08-12 23:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-12 23:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 23:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 23:20:07 [INFO]: in processold action queue is array for {"44669747":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44669747","ebayitemid":"326136958305","shopifyproductid":"8501634302174","variants":[{"price":"9.99","quantity":0,"weight":"1","shopifyproductid":"8501634302174","shopifyvariantid":"45411839508702","shopifyinventoryid":"47509817360606","shopifylocationid":"","product_id":"44669747","variant_id":"77574967","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44856127":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44856127","ebayitemid":"256921463534","shopifyproductid":"8927159451870","variants":[{"price":"11.99","quantity":0,"weight":"0.75","shopifyproductid":"8927159451870","shopifyvariantid":"46846381293790","shopifyinventoryid":"48957509697758","shopifylocationid":"58450641063","product_id":"44856127","variant_id":"77767086","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 23:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 23:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 23:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 23:20:07 [INFO]: Shopify Inventory id 47509817360606 2025-08-12 23:20:07 [INFO]: Shopify Location id 58450641063 2025-08-12 23:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 23:20:07 [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-12 23:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 23:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44669747 and user_id = 14409 2025-08-12 23:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77574967 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 23:20:07 [INFO]: Shopify Inventory id 48957509697758 2025-08-12 23:20:07 [INFO]: Shopify Location id 58450641063 2025-08-12 23:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 23:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T23: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-12 23:20:07 [INFO]: Change: available | Delta: -1 2025-08-12 23:20:07 [INFO]: Change: on_hand | Delta: -1 2025-08-12 23:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 23:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44856127 and user_id = 14409 2025-08-12 23:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77767086 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 23:20:07 [INFO]: updateIdsQuantity -> ["77574967","77767086"] 2025-08-12 23:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-12 23:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77574967 THEN 0 WHEN id = 77767086 THEN 0 END, quantityflag = CASE WHEN id = 77574967 THEN 0 WHEN id = 77767086 THEN 0 END WHERE user_id = 14409 AND id IN (77574967,77767086) 2025-08-12 23:20:07 [INFO]: QUANTITY Updated IDs: 77574967, 77767086 2025-08-12 23:20:07 [INFO]: Successfully processed data for user 14409 2025-08-12 23:20:07 [INFO]: Execution Started 2025-08-12 23:20:07 [INFO]: Execution Finished 2025-08-12 23:25:15 [INFO]: Execution Started 2025-08-12 23:25:15 [INFO]: old server sucessfully connected 2025-08-12 23:25:15 [INFO]: sqs client sucess created 2025-08-12 23:25:16 [INFO]: Number of messages in the queue: 2 2025-08-12 23:25:16 [INFO]: item found in queue is if condition 14409 2025-08-12 23:25:16 [INFO]: item found in queue is 14409 2025-08-12 23:25:17 [INFO]: Message deleted from the queue for receipt handle: AQEB/5Y8aw6ZZy17u0m/SCTIT7d1ElOX5LHrvGSlAeNFxvB6s6n+PSu9mC7hRNvSDbV9pl7vUaS1PcJz88XzT8r+nNlSFWaFjVxM7m8Lx1nbpDV92fHrPVw7jbRPlaLeI38XsN1NLw37prKaFtz5jiBFdPLtY7OkNwtkds6cMMSwdNy6pNpVXU0OWP8ROAVg7NnUnIfcFaY7p+bKr1uMHggZrVi7p1FDD1gT18xL5DtlrHT07rNty4Tf+i/hGJkKanqBdWbsfjWNz64AnxnAmeJPD0F8/DziMZ5NKa435rSv1OA27SjE+bpIT/co7VLDHcWQcGROc0gv5QeWLkOcjbRIPOxvBQ/kHZcRRNk5B3C5nSxbYu+8cxFr64XoJDYGaJpOR6ShtKhRgMTFAp1HvxiyClmSUs9iK8EKMEavgjn6rGEHFjRkFgNQZST1v3oBnDla 2025-08-12 23:25:17 [INFO]: item found in queue is if condition 14409 2025-08-12 23:25:17 [INFO]: item found in queue is 14409 2025-08-12 23:25:17 [INFO]: Message deleted from the queue for receipt handle: AQEBAFcy65yezpA35Ik0lMwRoDxWTt8FHXXRvV9YFzswE/dcF2Q+VxSh1jRxXZ/sSZACD8JUo6RzPQN7MVwS5WjTORaSQ+gHKUsBiqajVO+xlEEN14NXCHHicXTFH3MaeOBy0wpj60ZoraOKD2sahfRhfhqndMcFiBGDxpAa26dwZtRd4fqf3+3T9gNpIZBqDWillQeQOFr2TbzH69E5v5YDExaJweDWoo0Krxb81paKzaUNNVruJhyh+RhnZm5VjPrAi48/DbXLxdEi36GxyUSp7arvJ6HLe4Vn37WdPVodQx+1SXEuznFcNzUdd7U0RQS9K5fbIpCDLxTTYtv1smAsvoC/BkfcL0gf7HLugFK5+ZqKhWb8Rrwods92JqchNOfOQj//j82IJXvjJSTlge5/gv75lO9mq9HoLC1NqEyXzEaa35r/A+lMdznQNFC3RdCp 2025-08-12 23:25:17 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-12 23:25:17 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 23:25:17 [INFO]: inside itemsold and closed 14409 2025-08-12 23:25:19 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 23:25:19 [INFO]: autolink for user_id 14409 is 1 2025-08-12 23:25:19 [INFO]: Ebay item id :: 257054958603 exists in Database 2025-08-12 23:25:19 [INFO]: Item is reliested :: exists in Database 2025-08-12 23:25:19 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 23:25:19 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 23:25:19 [INFO]: inside itemsold and closed 14409 2025-08-12 23:25:21 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 23:25:21 [INFO]: autolink for user_id 14409 is 1 2025-08-12 23:25:21 [INFO]: Ebay item id :: 323991688082 exists in Database 2025-08-12 23:25:21 [INFO]: Item is reliested :: exists in Database 2025-08-12 23:25:21 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 23:25:21 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 23:25:21 [INFO]: in processold action queue is array for {"45313756":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313756","ebayitemid":"257054958603","shopifyproductid":"8983195386078","variants":[{"price":"24.99","quantity":0,"weight":"1","shopifyproductid":"8983195386078","shopifyvariantid":"47431159840990","shopifyinventoryid":"49542977487070","shopifylocationid":"58450641063","product_id":"45313756","variant_id":"78266269","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44675262":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44675262","ebayitemid":"323991688082","shopifyproductid":"6636634964135","variants":[{"price":"5.97","quantity":0,"weight":"0.5","shopifyproductid":"6636634964135","shopifyvariantid":"39661832470695","shopifyinventoryid":"41756516221095","shopifylocationid":"","product_id":"44675262","variant_id":"77580482","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 23:25:21 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 23:25:21 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 23:25:21 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 23:25:21 [INFO]: Shopify Inventory id 49542977487070 2025-08-12 23:25:21 [INFO]: Shopify Location id 58450641063 2025-08-12 23:25:21 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 23:25:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T23:25:21Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1984,"restoreRate":100}}}} 2025-08-12 23:25:21 [INFO]: Change: available | Delta: -1 2025-08-12 23:25:21 [INFO]: Change: on_hand | Delta: -1 2025-08-12 23:25:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 23:25:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313756 and user_id = 14409 2025-08-12 23:25:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266269 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 23:25:21 [INFO]: Shopify Inventory id 41756516221095 2025-08-12 23:25:21 [INFO]: Shopify Location id 58450641063 2025-08-12 23:25:21 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 23:25:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T23:25:21Z","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-12 23:25:21 [INFO]: Change: available | Delta: -1 2025-08-12 23:25:21 [INFO]: Change: on_hand | Delta: -1 2025-08-12 23:25:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 23:25:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44675262 and user_id = 14409 2025-08-12 23:25:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77580482 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 23:25:21 [INFO]: updateIdsQuantity -> ["78266269","77580482"] 2025-08-12 23:25:21 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-12 23:25:21 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78266269 THEN 0 WHEN id = 77580482 THEN 0 END, quantityflag = CASE WHEN id = 78266269 THEN 0 WHEN id = 77580482 THEN 0 END WHERE user_id = 14409 AND id IN (78266269,77580482) 2025-08-12 23:25:21 [INFO]: QUANTITY Updated IDs: 78266269, 77580482 2025-08-12 23:25:21 [INFO]: Successfully processed data for user 14409 2025-08-12 23:25:21 [INFO]: Execution Started 2025-08-12 23:25:21 [INFO]: Execution Finished 2025-08-12 23:30:01 [INFO]: Execution Started 2025-08-12 23:30:01 [INFO]: old server sucessfully connected 2025-08-12 23:30:01 [INFO]: sqs client sucess created 2025-08-12 23:30:02 [INFO]: Number of messages in the queue: 0 2025-08-12 23:30:22 [INFO]: Execution Started 2025-08-12 23:30:22 [INFO]: Execution Finished 2025-08-12 23:40:01 [INFO]: Execution Started 2025-08-12 23:40:01 [INFO]: old server sucessfully connected 2025-08-12 23:40:01 [INFO]: sqs client sucess created 2025-08-12 23:40:02 [INFO]: Number of messages in the queue: 0 2025-08-12 23:40:23 [INFO]: Execution Started 2025-08-12 23:40:23 [INFO]: Execution Finished 2025-08-12 23:50:01 [INFO]: Execution Started 2025-08-12 23:50:01 [INFO]: old server sucessfully connected 2025-08-12 23:50:01 [INFO]: sqs client sucess created 2025-08-12 23:50:02 [INFO]: Number of messages in the queue: 0 2025-08-12 23:50:22 [INFO]: Execution Started 2025-08-12 23:50:22 [INFO]: Execution Finished