2025-08-13 10:00:01 [INFO]: Execution Started 2025-08-13 10:00:01 [INFO]: old server sucessfully connected 2025-08-13 10:00:01 [INFO]: sqs client sucess created 2025-08-13 10:00:03 [INFO]: Number of messages in the queue: 1 2025-08-13 10:00:03 [INFO]: item found in queue is if condition 14409 2025-08-13 10:00:03 [INFO]: item found in queue is 14409 2025-08-13 10:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBRJMEnuHWHmpPtShnLvgNpwT4JvyGmOiUbfTzexwjrsawl40ptI806wK9QxO0fKYUBqdVBeLF0V/xwilJG5EYX3IXSKD3l0sq6xDZI1vDJTv268xDuZhR+bOwZ4xqLIqYshOKlwIUhXLve6zFW4cvPrpX99zC1bTqR8IOCm/WLmOl9/cio/QQXY3dAPtJHKCQrBBOKfaJZ8U2oB1mAdcz1S/xMYnOa3UkxGL5kPyJBHnIYw+7ik7ghZKbgQOE7TmqlfEkVPaa55PFycuQFdj3qWcI3IUVqHQNvzsRTTJjywGqnY8x4a5ttZwqQd/cAd5QycvGkO/c6EhmvkhGj5fqfk8E3Bx6Om5YuYDl4oupohpQO0+xqSXsYjhjJamjmB5EGJA8GZ3M7ccatg2pUwDczRdQZYkNZRQKFE3zhtVV8cgWkjONhKljyF/viyUPwCrZ 2025-08-13 10:00:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-13 10:00:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 10:00:04 [INFO]: inside itemsold and closed 14409 2025-08-13 10:00:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 10:00:06 [INFO]: autolink for user_id 14409 is 1 2025-08-13 10:00:06 [INFO]: Ebay item id :: 226112491013 exists in Database 2025-08-13 10:00:06 [INFO]: Item is reliested :: exists in Database 2025-08-13 10:00:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 10:00:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 10:00:06 [INFO]: in processold action queue is array for {"44675173":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44675173","ebayitemid":"226112491013","shopifyproductid":"8445416374494","variants":[{"price":"14.99","quantity":0,"weight":"0.9375","shopifyproductid":"8445416374494","shopifyvariantid":"45268485013726","shopifyinventoryid":"47366403719390","shopifylocationid":"","product_id":"44675173","variant_id":"77580393","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 10:00:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 10:00:06 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 10:00:06 [INFO]: Shopify Inventory id 47366403719390 2025-08-13 10:00:06 [INFO]: Shopify Location id 58450641063 2025-08-13 10:00:06 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 10:00:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T10:00:06Z","reason":"correction","changes":[{"name":"available","delta":-4},{"name":"on_hand","delta":-4}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-13 10:00:06 [INFO]: Change: available | Delta: -4 2025-08-13 10:00:06 [INFO]: Change: on_hand | Delta: -4 2025-08-13 10:00:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 10:00:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44675173 and user_id = 14409 2025-08-13 10:00:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77580393 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 10:00:06 [INFO]: updateIdsQuantity -> ["77580393"] 2025-08-13 10:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 10:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77580393 THEN 0 END, quantityflag = CASE WHEN id = 77580393 THEN 0 END WHERE user_id = 14409 AND id IN (77580393) 2025-08-13 10:00:06 [INFO]: QUANTITY Updated IDs: 77580393 2025-08-13 10:00:06 [INFO]: Successfully processed data for user 14409 2025-08-13 10:00:06 [INFO]: Execution Started 2025-08-13 10:00:06 [INFO]: Execution Finished 2025-08-13 10:10:01 [INFO]: Execution Started 2025-08-13 10:10:01 [INFO]: old server sucessfully connected 2025-08-13 10:10:01 [INFO]: sqs client sucess created 2025-08-13 10:10:04 [INFO]: Number of messages in the queue: 2 2025-08-13 10:10:04 [INFO]: item found in queue is if condition 14409 2025-08-13 10:10:04 [INFO]: item found in queue is 14409 2025-08-13 10:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBzzU5sj5ocStwhutQqPek8hy4TyNwwWXMcbAMrkRjdos9mVd1y7+1ZrQt5+ZgcYscylyi2u22qf56pkc014tBnMdwihv2LrTWh6x7eSPDOUFfl7qfnjbruGcX7Gzz/ypms07QbMyj3iHoDNaWcVGxPRr4JiQsPIyR/L5ZLHvojS9V/Ub+xqqIvvJ3GL5WJ8Jen+nU8d7W6HN5aPafFaf2EeebkSH6+8+Vrt4ExWYURAqjU/LL6+HNGlK6272Wo8UBLXnJidxghrQ0RXNYR9OoPaqZQqOm7HuSoWX77SJcfKiqgDw7VVS8QYk9sJIkDhYpjWpUk2NIuJ3p3lkZ1rUpGGaFu/x5wK8VfPSxhWdccTv4pRsDZxs7Q3N1N0CscI2E/5kAw9Zp9i563pl2Hjul2+RCryvayTYCYcHGlw/KlORGjJMOqfqS7uOspbvWfLtF 2025-08-13 10:10:05 [INFO]: item found in queue is if condition 14409 2025-08-13 10:10:05 [INFO]: item found in queue is 14409 2025-08-13 10:10:07 [INFO]: Message deleted from the queue for receipt handle: AQEBLLJr++Sd+QuSAX6LZedUVPfJfKCX4hnZO4V0284UzLKgKldb3o5M9JJAeup30tqi+z1q3ySoN7YGJVAYRk5nFVWHpsiBxLrYO4isArP86pxaTQuOmIjwPBO1IGR53YspDtyA2ptPv4Zgbr5Vb/2Jx/iGy8G5n/e0qwbIvnYgKmgj/30zicoIgw86r0h4MG+cGO6fJ5lLRIqWL+EuX5pIv8rhXOl2bqv6/VrGMwUah9Or1/9kpjygXGFJqaHkEiOiwGfHAbgfBttQovzWUKcGr4BMonjqxtywZjGbegqd6Zvxfx+WeltdAoiCF7m8Jy9EZ+t5CJCMfGbEKNWaqnN8nT6YmMxV7GLZDu6sWn98p/b7GOyJ0FCO+T3MbMKkmMiD8SAMTUZRIllvQUxIFMAAfV5fX+9YfddmRG0UZU1VJ6okRxhLbbaD7P7YBWlS7mgc 2025-08-13 10:10:07 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-13 10:10:07 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 10:10:07 [INFO]: inside itemsold and closed 14409 2025-08-13 10:10:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 10:10:08 [INFO]: autolink for user_id 14409 is 1 2025-08-13 10:10:08 [INFO]: Ebay item id :: 226693242604 exists in Database 2025-08-13 10:10:08 [INFO]: Item is reliested :: exists in Database 2025-08-13 10:10:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 10:10:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 10:10:08 [INFO]: inside itemsold and closed 14409 2025-08-13 10:10:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 10:10:10 [INFO]: autolink for user_id 14409 is 1 2025-08-13 10:10:10 [INFO]: Ebay item id :: 225778699487 exists in Database 2025-08-13 10:10:10 [INFO]: Item is reliested :: exists in Database 2025-08-13 10:10:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 10:10:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 10:10:10 [INFO]: in processold action queue is array for {"44737693":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44737693","ebayitemid":"226693242604","shopifyproductid":"8872482013406","variants":[{"price":"14.99","quantity":0,"weight":"2","shopifyproductid":"8872482013406","shopifyvariantid":"46599744618718","shopifyinventoryid":"48702570987742","shopifylocationid":"","product_id":"44737693","variant_id":"77645630","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44657406":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44657406","ebayitemid":"225778699487","shopifyproductid":"8131488448734","variants":[{"price":"17.99","quantity":0,"weight":"0.75","shopifyproductid":"8131488448734","shopifyvariantid":"44352428736734","shopifyinventoryid":"46450195235038","shopifylocationid":"","product_id":"44657406","variant_id":"77562626","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 10:10:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 10:10:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 10:10:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 10:10:10 [INFO]: Shopify Inventory id 48702570987742 2025-08-13 10:10:10 [INFO]: Shopify Location id 58450641063 2025-08-13 10:10:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 10:10:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T10: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-13 10:10:10 [INFO]: Change: available | Delta: -1 2025-08-13 10:10:10 [INFO]: Change: on_hand | Delta: -1 2025-08-13 10:10:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 10:10:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44737693 and user_id = 14409 2025-08-13 10:10:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77645630 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 10:10:10 [INFO]: Shopify Inventory id 46450195235038 2025-08-13 10:10:10 [INFO]: Shopify Location id 58450641063 2025-08-13 10:10:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 10:10:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T10:10:11Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1982,"restoreRate":100}}}} 2025-08-13 10:10:11 [INFO]: Change: available | Delta: -1 2025-08-13 10:10:11 [INFO]: Change: on_hand | Delta: -1 2025-08-13 10:10:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 10:10:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44657406 and user_id = 14409 2025-08-13 10:10:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77562626 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 10:10:11 [INFO]: updateIdsQuantity -> ["77645630","77562626"] 2025-08-13 10:10:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-13 10:10:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77645630 THEN 0 WHEN id = 77562626 THEN 0 END, quantityflag = CASE WHEN id = 77645630 THEN 0 WHEN id = 77562626 THEN 0 END WHERE user_id = 14409 AND id IN (77645630,77562626) 2025-08-13 10:10:11 [INFO]: QUANTITY Updated IDs: 77645630, 77562626 2025-08-13 10:10:11 [INFO]: Successfully processed data for user 14409 2025-08-13 10:10:11 [INFO]: Execution Started 2025-08-13 10:10:11 [INFO]: Execution Finished 2025-08-13 10:19:29 [INFO]: Execution Started 2025-08-13 10:19:29 [INFO]: old server sucessfully connected 2025-08-13 10:19:29 [INFO]: sqs client sucess created 2025-08-13 10:19:31 [INFO]: Number of messages in the queue: 3 2025-08-13 10:19:32 [INFO]: item found in queue is if condition 14409 2025-08-13 10:19:32 [INFO]: item found in queue is 14409 2025-08-13 10:19:33 [INFO]: Message deleted from the queue for receipt handle: AQEBCV2eg1mPIrYoNlygPFwvAlrVe1rolmfZEsOR9j7TWQJdzTYIPNKHV4Cda0BlHgza8UVS6yDr6hKaWig59IxA0xII1dwbjBSsn5WeNwxFhsA4SKT89rol5mmHizw5/AelHIqwz1Gq+br1ztIUgwi6Iin+v8TwPL2YE2G1Emvu6YarQFUI3D2QLyhnGLIam6saeNxRbGsK2S+onbp8sUfbMYz44A8BDaSU2OtQEYgMeYWqfCNuZaJpRZQ4jqTEuDTaak9dA+0+6jd1n6nyY2/4iQL2LN4qry1JOR76ZTM4JOSFde8c0hfsNUdvKcH4cCJzttdVTZ9Plsa0cIX422QHztfrD2ioU1SZ4vmKRWTJaa93K3uqwfauVp7Hm9dMFIaYCP+T0zEBpMJYtNFrO8au0d+CC3SKg3wUtmgdNayprQprEDcH57Wq1rZqah/MD467 2025-08-13 10:19:33 [INFO]: item found in queue is if condition 14409 2025-08-13 10:19:33 [INFO]: item found in queue is 14409 2025-08-13 10:19:34 [INFO]: Message deleted from the queue for receipt handle: AQEBR+agv2/yLMFZ53Z3CstKNPDdsqBESToMliS/gpXqleuLvF9WIwwfRJhuzRPBEwtdMxaexKPKjGYbPYxK3rmRuwkZ6elX82T+MGrlUYpWonso3BqkGlX9M11xq9jpXLXxqalGLkknmsD4MhL3sBgJv3zUcj30IWJvcYibExloqzqI5sdmGG+obYaB8ee5HYPw39okCG/1hPWsZo3etIBO+LerugQy4h1apDZYAqdavoqrC4xT6H7azSDMNFWbmHctOwJ/7AiJtjN13NwmWI6t6dSf0x57TSVu20kkMOhZUAFqspYdBML161tImWfn3MagMtKHhci4AC/8SCAraYkv3TNWTMtxPX9p5EjBTmkHuo+0YByg37ZpcceHrB+kpj1Mw8zhH6tkecpjT/OXz7UuhqeD+KwVgcJBiqNA5XP6NdHQCpsHcuCz0axfIWwiWl9r 2025-08-13 10:19:34 [INFO]: item found in queue is if condition 14409 2025-08-13 10:19:34 [INFO]: item found in queue is 14409 2025-08-13 10:19:35 [INFO]: Message deleted from the queue for receipt handle: AQEBKT2XMIGjTCkW/yAmyZEATnHpaXegqTV9svDPzxMrWi+FbRQn1fvdbPlResaoeCE6Me7lUgY+Xhx/hmOyF09+uDBKyLtZiCC3jeDBp8Ga/vF3AurEvZax724FUxQGGsml/2vL3U77uuh6icN6kK5FOrXlaQmQSQM7z34L0JZm2OkFkAaOJOwOV10sw03qHiIJr07uQilJLqchoX0Mw/u3hnYLqMQGOjQ+7w3J5j2+qka96nhfoF/w+aKhSoNWz0/XCPxQwfjWu512HJFiKfWC62+YeGcTnLQtF0EEgepWrUhjj3HEfH/k93dIxX86TmjYb1EaZMK/xBUTXoNZDXPRxINschLYfCBYACwWijwMAokuM/W3wFm/L6w18qSz1Cxu43IsXZasfOFmUvpwO2NDDHJn7VXxqV30+JmMClYBfPQYMzoqt88ngw2AAgPIwp6n 2025-08-13 10:19:35 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-13 10:19:35 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 10:19:35 [INFO]: inside itemsold and closed 14409 2025-08-13 10:19:36 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 10:19:36 [INFO]: autolink for user_id 14409 is 1 2025-08-13 10:19:36 [INFO]: Ebay item id :: 226402076330 exists in Database 2025-08-13 10:19:36 [INFO]: Item is reliested :: exists in Database 2025-08-13 10:19:36 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 10:19:36 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 10:19:36 [INFO]: inside itemsold and closed 14409 2025-08-13 10:19:38 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 10:19:38 [INFO]: autolink for user_id 14409 is 1 2025-08-13 10:19:38 [INFO]: Ebay item id :: 226022632084 exists in Database 2025-08-13 10:19:38 [INFO]: Item is reliested :: exists in Database 2025-08-13 10:19:38 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 10:19:38 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 10:19:38 [INFO]: inside itemsold and closed 14409 2025-08-13 10:19:40 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 10:19:40 [INFO]: autolink for user_id 14409 is 1 2025-08-13 10:19:40 [INFO]: Ebay item id :: 226402078814 exists in Database 2025-08-13 10:19:40 [INFO]: Item is reliested :: exists in Database 2025-08-13 10:19:40 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 10:19:40 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 10:19:40 [INFO]: in processold action queue is array for {"44649752":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44649752","ebayitemid":"226402076330","shopifyproductid":"8124966731998","variants":[{"price":"149.99","quantity":0,"weight":"3","shopifyproductid":"8124966731998","shopifyvariantid":"44340389282014","shopifyinventoryid":"46438090473694","shopifylocationid":"","product_id":"44649752","variant_id":"77554941","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44682781":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44682781","ebayitemid":"226022632084","shopifyproductid":"8303328362718","variants":[{"price":"89.99","quantity":0,"weight":"3","shopifyproductid":"8303328362718","shopifyvariantid":"44851876954334","shopifyinventoryid":"46949921325278","shopifylocationid":"","product_id":"44682781","variant_id":"77588007","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44649759":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44649759","ebayitemid":"226402078814","shopifyproductid":"8201245262046","variants":[{"price":"149.99","quantity":0,"weight":"3","shopifyproductid":"8201245262046","shopifyvariantid":"44512823509214","shopifyinventoryid":"46610762072286","shopifylocationid":"","product_id":"44649759","variant_id":"77554948","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 10:19:40 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 10:19:40 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 10:19:40 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 10:19:40 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 10:19:40 [INFO]: Shopify Inventory id 46438090473694 2025-08-13 10:19:40 [INFO]: Shopify Location id 58450641063 2025-08-13 10:19:40 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 10:19:40 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T10:19:40Z","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-13 10:19:40 [INFO]: Change: available | Delta: -1 2025-08-13 10:19:40 [INFO]: Change: on_hand | Delta: -1 2025-08-13 10:19:40 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 10:19:40 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44649752 and user_id = 14409 2025-08-13 10:19:40 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77554941 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 10:19:40 [INFO]: Shopify Inventory id 46949921325278 2025-08-13 10:19:40 [INFO]: Shopify Location id 58450641063 2025-08-13 10:19:40 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 10:19:40 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T10:19:40Z","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-13 10:19:40 [INFO]: Change: available | Delta: -1 2025-08-13 10:19:40 [INFO]: Change: on_hand | Delta: -1 2025-08-13 10:19:40 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 10:19:40 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44682781 and user_id = 14409 2025-08-13 10:19:40 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77588007 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 10:19:40 [INFO]: Shopify Inventory id 46610762072286 2025-08-13 10:19:40 [INFO]: Shopify Location id 58450641063 2025-08-13 10:19:40 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 10:19:41 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T10:19:41Z","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-13 10:19:41 [INFO]: Change: available | Delta: -1 2025-08-13 10:19:41 [INFO]: Change: on_hand | Delta: -1 2025-08-13 10:19:41 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 10:19:41 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44649759 and user_id = 14409 2025-08-13 10:19:41 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77554948 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 10:19:41 [INFO]: updateIdsQuantity -> ["77554941","77588007","77554948"] 2025-08-13 10:19:41 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-13 10:19:41 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77554941 THEN 0 WHEN id = 77588007 THEN 0 WHEN id = 77554948 THEN 0 END, quantityflag = CASE WHEN id = 77554941 THEN 0 WHEN id = 77588007 THEN 0 WHEN id = 77554948 THEN 0 END WHERE user_id = 14409 AND id IN (77554941,77588007,77554948) 2025-08-13 10:19:41 [INFO]: QUANTITY Updated IDs: 77554941, 77588007, 77554948 2025-08-13 10:19:41 [INFO]: Successfully processed data for user 14409 2025-08-13 10:19:41 [INFO]: Execution Started 2025-08-13 10:19:41 [INFO]: Execution Finished 2025-08-13 10:20:01 [INFO]: Execution Started 2025-08-13 10:20:01 [INFO]: old server sucessfully connected 2025-08-13 10:20:01 [INFO]: sqs client sucess created 2025-08-13 10:20:03 [INFO]: Number of messages in the queue: 1 2025-08-13 10:20:03 [INFO]: item found in queue is if condition 14409 2025-08-13 10:20:03 [INFO]: item found in queue is 14409 2025-08-13 10:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBU6Ujd8kkK+DcrGxWb6Z6uxcEM7UVzaH29cwdNE+LqMv+PkvfpEraNU/yroa/DNghxmYwXlZ9fkwKjgpkTJAN8wdlU3TfmCcWV1Rr7ndXliMxoZpKB/Kx3XibMGnVa/Gq8JgN/6BIso5UpAq5IJipiei02Rv1drvfbpL3MUHFt7KxfKeipBnSoP9mZbyKH1MD0B0qdrjWhoAeefXJvzNQ1MaKW0X4L8eW6skiv1FOiR5esGdUbG20hYTsni5Td7H9KhJQlHnDcrY7gijqILkgdq2Lt7GZ6bzGHQs7X7l89TX0EEe/xRWSTjZtPc/YhLaEx82a/n7LQI9MnOIrT/P4ftZdEZp4Fgq6ZsmtJFfgIx74SFQgeLVZeFLijkUCHkP84i/nRMU9DSfyt0WjOQSC+C/pxEvv78wD9v2o1+cv3HAAqGIxiSMDs58P2sNwQfrv 2025-08-13 10:20:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-13 10:20:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 10:20:04 [INFO]: inside itemsold and closed 14409 2025-08-13 10:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 10:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-13 10:20:05 [INFO]: Ebay item id :: 226402082194 exists in Database 2025-08-13 10:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-13 10:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 10:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 10:20:05 [INFO]: in processold action queue is array for {"44649762":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44649762","ebayitemid":"226402082194","shopifyproductid":"8240510927070","variants":[{"price":"149.99","quantity":0,"weight":"3","shopifyproductid":"8240510927070","shopifyvariantid":"44617753198814","shopifyinventoryid":"46715734032606","shopifylocationid":"","product_id":"44649762","variant_id":"77554951","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 10:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 10:20:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 10:20:05 [INFO]: Shopify Inventory id 46715734032606 2025-08-13 10:20:05 [INFO]: Shopify Location id 58450641063 2025-08-13 10:20:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 10:20:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T10:20:06Z","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-13 10:20:06 [INFO]: Change: available | Delta: -1 2025-08-13 10:20:06 [INFO]: Change: on_hand | Delta: -1 2025-08-13 10:20:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 10:20:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44649762 and user_id = 14409 2025-08-13 10:20:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77554951 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 10:20:06 [INFO]: updateIdsQuantity -> ["77554951"] 2025-08-13 10:20:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 10:20:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77554951 THEN 0 END, quantityflag = CASE WHEN id = 77554951 THEN 0 END WHERE user_id = 14409 AND id IN (77554951) 2025-08-13 10:20:06 [INFO]: QUANTITY Updated IDs: 77554951 2025-08-13 10:20:06 [INFO]: Successfully processed data for user 14409 2025-08-13 10:20:06 [INFO]: Execution Started 2025-08-13 10:20:06 [INFO]: Execution Finished 2025-08-13 10:30:01 [INFO]: Execution Started 2025-08-13 10:30:01 [INFO]: old server sucessfully connected 2025-08-13 10:30:01 [INFO]: sqs client sucess created 2025-08-13 10:30:03 [INFO]: Number of messages in the queue: 1 2025-08-13 10:30:04 [INFO]: item found in queue is if condition 14409 2025-08-13 10:30:04 [INFO]: item found in queue is 14409 2025-08-13 10:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEB5ph4J4DlsxY40/MXgeIUlI4o6wSGLStdSapShSiT/78vUa7En3TX9p0IIMWUPIKIcdZ0UzNP80jveU97JRf+B5QxUexla96nA094Hmk9lhxqAUeIv2N8q3ohA8YSCnuAkOAD3Bp6qlzcgUqv2I8+VBV9OZ/AodcvB9fwr1kvgFMMzDB7eWbf/ES1UCPXoFQkV21+2yvpz6vR2KJ8L8ddOPpUmNFuLcU/0soU86OtD7oJdNOpmMdzCDhvUjrflIpukZO+w0UbBBLvDD+qTQXKqPngsecG8rn4bRwOD9wa48oKirhrzLh7NjYUGBIwrq1qT9TITc+wEaVMEGhNrF0AIbcb9P7iwwJ1e3jHoxXP7bDTJCHYP9Kn6SwEd0JwrDFLiDgNrYeAgfI1wug6uvzDORI5U6sX5kYkh6jwJ/8GXHQrnAdcmsLZj9svaL4ZoW5d 2025-08-13 10:30:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-13 10:30:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 10:30:04 [INFO]: inside itemsold and closed 14409 2025-08-13 10:30:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 10:30:06 [INFO]: autolink for user_id 14409 is 1 2025-08-13 10:30:06 [INFO]: Ebay item id :: 324850475745 exists in Database 2025-08-13 10:30:06 [INFO]: Item is reliested :: exists in Database 2025-08-13 10:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 10:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 10:30:06 [INFO]: in processold action queue is array for {"44678559":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44678559","ebayitemid":"324850475745","shopifyproductid":"7125338456231","variants":[{"price":"12.23","quantity":0,"weight":"0.75","shopifyproductid":"7125338456231","shopifyvariantid":"41624155881639","shopifyinventoryid":"43721080963239","shopifylocationid":"","product_id":"44678559","variant_id":"77583779","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 10:30:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 10:30:06 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 10:30:06 [INFO]: Shopify Inventory id 43721080963239 2025-08-13 10:30:06 [INFO]: Shopify Location id 58450641063 2025-08-13 10:30:06 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 10:30:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T10:30:06Z","reason":"correction","changes":[{"name":"available","delta":-4},{"name":"on_hand","delta":-4}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-13 10:30:06 [INFO]: Change: available | Delta: -4 2025-08-13 10:30:06 [INFO]: Change: on_hand | Delta: -4 2025-08-13 10:30:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 10:30:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44678559 and user_id = 14409 2025-08-13 10:30:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77583779 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 10:30:06 [INFO]: updateIdsQuantity -> ["77583779"] 2025-08-13 10:30:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 10:30:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77583779 THEN 0 END, quantityflag = CASE WHEN id = 77583779 THEN 0 END WHERE user_id = 14409 AND id IN (77583779) 2025-08-13 10:30:06 [INFO]: QUANTITY Updated IDs: 77583779 2025-08-13 10:30:06 [INFO]: Successfully processed data for user 14409 2025-08-13 10:30:06 [INFO]: Execution Started 2025-08-13 10:30:06 [INFO]: Execution Finished 2025-08-13 10:40:01 [INFO]: Execution Started 2025-08-13 10:40:01 [INFO]: old server sucessfully connected 2025-08-13 10:40:01 [INFO]: sqs client sucess created 2025-08-13 10:40:03 [INFO]: Number of messages in the queue: 0 2025-08-13 10:40:23 [INFO]: Execution Started 2025-08-13 10:40:23 [INFO]: Execution Finished 2025-08-13 10:50:01 [INFO]: Execution Started 2025-08-13 10:50:01 [INFO]: old server sucessfully connected 2025-08-13 10:50:01 [INFO]: sqs client sucess created 2025-08-13 10:50:03 [INFO]: Number of messages in the queue: 2 2025-08-13 10:50:05 [INFO]: item found in queue is if condition 14409 2025-08-13 10:50:05 [INFO]: item found in queue is 14409 2025-08-13 10:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEBxFx8eVEWeUzsdLJl3V6qfa4+r09r40VvZtsYvBsy2N4jCRDFnkH85t7DLIhKKq25gRX7cUO7puWuOKlKclZk0rcVvLJthNoZPwPkkVHbjAvIWWoMpjz+2JbslRUxvpGaknEvyLYsXDmgQ8RkeV7diecfLVDgvAv/EXFMNjSP/6h9etck6tEfx8Un/JOIJgMF6wxzfcwpV25eYzTcg/JX5QjizdvgH3R+c51o4uQ9n3v9Eb0qpjc9Sj2C9PrqIH1l6ZiyHn+eNFHRzYypDoylS6GsRbNzCGmQeWXqAMm6Zi3wUlmlzzHeilTv549oWYZ8s0BYb2vkqL5MC1AgCL35Cz28yOvpQ1Eu9GZ6XMPq5BqdcPC8+CFwPQ/ClgLJLvgzXTC4YftG6zenPdqxqOmZyAaHfmPyENbhz6TcnDIXKMLCEvL1YRISPCsEt3Z7VkXx 2025-08-13 10:50:06 [INFO]: item found in queue is if condition 14409 2025-08-13 10:50:06 [INFO]: item found in queue is 14409 2025-08-13 10:50:07 [INFO]: Message deleted from the queue for receipt handle: AQEBjYgCMF/ck3/dYUqqiphP024AC6cZ5o0ENrGwBNOp2H/Nqlh3dsGpTWcXpFeM6zW3xIHRdaiDBMMr2Q5o4OsPfriNQWeGNbOODFqe5NrnwNXDiVPdXTpCN+UxMVq5zqbwOlDa1xqyHRGcomBwkuLe1LB1kzyZuIrObFFYlJchkDrQabe8GGJjPXlc/w8GsKvlF33/CNzBxhmFsNIsJsnx3xNtIctMTZAlBbZwN40LH4otfAF3vFZ4gFzbVPq5qnlH7bZfYSErZNvZRHbFgUHeIQ1D8z8XkdZbrcaGuvF+JtYmr95hZualF4+ehcP54E3fULi0WwSqnuT7Quz6fQtApYnPPy2gvLvlVYlYAv6XBIcSPOllLA8bdftYp3Rc/dSWQ8fm+nQX21ebwTr9LhXP7qCHj3VD5HLWmtUjPNzwPQVuerEBEblOmiYpmMz9d1B6 2025-08-13 10:50:07 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-13 10:50:07 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 10:50:07 [INFO]: inside itemsold and closed 14409 2025-08-13 10:50:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 10:50:09 [INFO]: autolink for user_id 14409 is 1 2025-08-13 10:50:09 [INFO]: Ebay item id :: 225225733308 exists in Database 2025-08-13 10:50:09 [INFO]: Item is reliested :: exists in Database 2025-08-13 10:50:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 10:50:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 10:50:09 [INFO]: inside itemsold and closed 14409 2025-08-13 10:50:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 10:50:11 [INFO]: autolink for user_id 14409 is 1 2025-08-13 10:50:11 [INFO]: Ebay item id :: 324855118866 exists in Database 2025-08-13 10:50:11 [INFO]: Item is reliested :: exists in Database 2025-08-13 10:50:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 10:50:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 10:50:11 [INFO]: in processold action queue is array for {"44682393":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44682393","ebayitemid":"225225733308","shopifyproductid":"7626048995550","variants":[{"price":"10.99","quantity":0,"weight":"0.75","shopifyproductid":"7626048995550","shopifyvariantid":"42702865826014","shopifyinventoryid":"44797145612510","shopifylocationid":"","product_id":"44682393","variant_id":"77587618","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44685132":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44685132","ebayitemid":"324855118866","shopifyproductid":"7857248698590","variants":[{"price":"12.23","quantity":0,"weight":"0.75","shopifyproductid":"7857248698590","shopifyvariantid":"43594913415390","shopifyinventoryid":"45690581975262","shopifylocationid":"","product_id":"44685132","variant_id":"77590357","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 10:50:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 10:50:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 10:50:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 10:50:11 [INFO]: Shopify Inventory id 44797145612510 2025-08-13 10:50:11 [INFO]: Shopify Location id 58450641063 2025-08-13 10:50:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 10:50:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T10:50:11Z","reason":"correction","changes":[{"name":"available","delta":-4},{"name":"on_hand","delta":-4}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-13 10:50:11 [INFO]: Change: available | Delta: -4 2025-08-13 10:50:11 [INFO]: Change: on_hand | Delta: -4 2025-08-13 10:50:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 10:50:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44682393 and user_id = 14409 2025-08-13 10:50:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77587618 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 10:50:11 [INFO]: Shopify Inventory id 45690581975262 2025-08-13 10:50:11 [INFO]: Shopify Location id 58450641063 2025-08-13 10:50:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 10:50:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T10:50:11Z","reason":"correction","changes":[{"name":"available","delta":-4},{"name":"on_hand","delta":-4}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-13 10:50:12 [INFO]: Change: available | Delta: -4 2025-08-13 10:50:12 [INFO]: Change: on_hand | Delta: -4 2025-08-13 10:50:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 10:50:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44685132 and user_id = 14409 2025-08-13 10:50:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77590357 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 10:50:12 [INFO]: updateIdsQuantity -> ["77587618","77590357"] 2025-08-13 10:50:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-13 10:50:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77587618 THEN 0 WHEN id = 77590357 THEN 0 END, quantityflag = CASE WHEN id = 77587618 THEN 0 WHEN id = 77590357 THEN 0 END WHERE user_id = 14409 AND id IN (77587618,77590357) 2025-08-13 10:50:12 [INFO]: QUANTITY Updated IDs: 77587618, 77590357 2025-08-13 10:50:12 [INFO]: Successfully processed data for user 14409 2025-08-13 10:50:12 [INFO]: Execution Started 2025-08-13 10:50:12 [INFO]: Execution Finished