2025-08-01 16:00:01 [INFO]: Execution Started 2025-08-01 16:00:01 [INFO]: old server sucessfully connected 2025-08-01 16:00:01 [INFO]: sqs client sucess created 2025-08-01 16:00:03 [INFO]: Number of messages in the queue: 1 2025-08-01 16:00:03 [INFO]: item found in queue is if condition 14409 2025-08-01 16:00:03 [INFO]: item found in queue is 14409 2025-08-01 16:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBiVhwJlCYQU6tTmGy57UTLxyr9v5kfv5aIP3mgHfzezIiedBE+d+J6k7S2mSiaxa/XRqDnxugHe/hPZYE+aMMBxc24N+eRWuXfJ6ANqxBvt6MF9/2PommQbbPUGlCoQqs57lQZzhILHuuSJgE3JYtg72VUPmuIuPgE1piSCVDEkdcimxSlHRk26WdCs6xBa02H4PJ+lGmdPOwO2jb7NGimGz9c3kF6Nm0r/TgLc5jcWYWn1cXLxPj756QSmqWDNEmInOmWD7SnOs9lPJGFHA9Q1LmSGD3VuCPijko+oeVPWJUxJC7t6ApPVONXuWFfJZ84PkVPW8sITKLOWU6k5AWyPHtp5/WrJv9ztfzaN3jBerr3mWs2C+QXEImWP/6ECwlNamB64HDNDDRL64iU/5xJwZC1aMnojthML85VEcOUoJUJTeRAwU5ImSXhL7QFkb4 2025-08-01 16:00:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-01 16:00:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 16:00:04 [INFO]: inside itemsold and closed 14409 2025-08-01 16:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 16:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-01 16:00:05 [INFO]: Ebay item id :: 284478084013 exists in Database 2025-08-01 16:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-01 16:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 16:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 16:00:05 [INFO]: in processold action queue is array for {"44559563":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44559563","ebayitemid":"284478084013","shopifyproductid":"7088641179815","variants":[{"price":"10.00","quantity":0,"weight":"0","shopifyproductid":"7088641179815","shopifyvariantid":"41494664872103","shopifyinventoryid":"43591127892135","shopifylocationid":"","product_id":"44559563","variant_id":"77452243","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 16:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 16:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 16:00:05 [INFO]: Shopify Inventory id 43591127892135 2025-08-01 16:00:05 [INFO]: Shopify Location id 58450641063 2025-08-01 16:00:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 16:00:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T16:00: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-01 16:00:06 [INFO]: Change: available | Delta: -1 2025-08-01 16:00:06 [INFO]: Change: on_hand | Delta: -1 2025-08-01 16:00:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 16:00:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44559563 and user_id = 14409 2025-08-01 16:00:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77452243 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 16:00:06 [INFO]: updateIdsQuantity -> ["77452243"] 2025-08-01 16:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-01 16:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77452243 THEN 0 END, quantityflag = CASE WHEN id = 77452243 THEN 0 END WHERE user_id = 14409 AND id IN (77452243) 2025-08-01 16:00:06 [INFO]: QUANTITY Updated IDs: 77452243 2025-08-01 16:00:06 [INFO]: Successfully processed data for user 14409 2025-08-01 16:00:06 [INFO]: Execution Started 2025-08-01 16:00:06 [INFO]: Execution Finished 2025-08-01 16:10:02 [INFO]: Execution Started 2025-08-01 16:10:02 [INFO]: old server sucessfully connected 2025-08-01 16:10:02 [INFO]: sqs client sucess created 2025-08-01 16:10:03 [INFO]: Number of messages in the queue: 1 2025-08-01 16:10:04 [INFO]: item found in queue is if condition 14409 2025-08-01 16:10:04 [INFO]: item found in queue is 14409 2025-08-01 16:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBclItVjRnRJ9IDcRdvDhyprlqhgCWrNX8mKB2LiTUovZJbVbQiX46WWfIny+1pxZPEaGkVwIOgBhvhuI5cgNNob2wAvN6UqFUctYnnsN5mA/+krdzB77hCu8AaKJgdpIKaph6zOptqNVB+IdCKllIDa5Vk2wHAqxXlZhBo8RxmY/YCzNPGMXmZvxkAICCeAcu/xuoFYNsDc2vUXpRHtafVD6rh30qDVPrIjvtD+yNVD2PzNOf88HryCstbn4eu2RkDYnwDNgP3/CRP/gPQ7fS5QRy0edtsI0hyLAev+jR6SS6CaXmILMhDceaEEx0CqfsblMxCiXUqI+Ie67ZOhBp6/ZnUb/c/rFlhIgX5+pzwKpDfY6Qbub2Fgmt9ukc2P15VfWTqa3/zw9wpGp+hr2OLZO5ZnS0BLHUXD1luKJzhuB70v6IgS07Go5zTEtep64g 2025-08-01 16:10:05 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-01 16:10:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 16:10:05 [INFO]: inside itemsold and closed 14409 2025-08-01 16:10:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 16:10:06 [INFO]: autolink for user_id 14409 is 1 2025-08-01 16:10:06 [INFO]: Ebay item id :: 286278280895 exists in Database 2025-08-01 16:10:06 [INFO]: Item is reliested :: exists in Database 2025-08-01 16:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 16:10:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 16:10:06 [INFO]: in processold action queue is array for {"44587000":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44587000","ebayitemid":"286278280895","shopifyproductid":"8797282631902","variants":[{"price":"440.99","quantity":0,"weight":"18","shopifyproductid":"8797282631902","shopifyvariantid":"46238739071198","shopifyinventoryid":"48339165839582","shopifylocationid":"","product_id":"44587000","variant_id":"77479709","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 16:10:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 16:10:06 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 16:10:06 [INFO]: Shopify Inventory id 48339165839582 2025-08-01 16:10:06 [INFO]: Shopify Location id 58450641063 2025-08-01 16:10:06 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 16:10: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-01 16:10:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 16:10:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44587000 and user_id = 14409 2025-08-01 16:10:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77479709 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 16:10:07 [INFO]: updateIdsQuantity -> ["77479709"] 2025-08-01 16:10:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-01 16:10:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77479709 THEN 0 END, quantityflag = CASE WHEN id = 77479709 THEN 0 END WHERE user_id = 14409 AND id IN (77479709) 2025-08-01 16:10:07 [INFO]: QUANTITY Updated IDs: 77479709 2025-08-01 16:10:07 [INFO]: Successfully processed data for user 14409 2025-08-01 16:10:07 [INFO]: Execution Started 2025-08-01 16:10:07 [INFO]: Execution Finished 2025-08-01 16:20:01 [INFO]: Execution Started 2025-08-01 16:20:01 [INFO]: old server sucessfully connected 2025-08-01 16:20:01 [INFO]: sqs client sucess created 2025-08-01 16:20:03 [INFO]: Number of messages in the queue: 0 2025-08-01 16:20:24 [INFO]: Execution Started 2025-08-01 16:20:24 [INFO]: Execution Finished 2025-08-01 16:30:01 [INFO]: Execution Started 2025-08-01 16:30:01 [INFO]: old server sucessfully connected 2025-08-01 16:30:01 [INFO]: sqs client sucess created 2025-08-01 16:30:02 [INFO]: Number of messages in the queue: 0 2025-08-01 16:30:16 [INFO]: item found in queue is if condition 14409 2025-08-01 16:30:16 [INFO]: item found in queue is 14409 2025-08-01 16:30:16 [INFO]: Message deleted from the queue for receipt handle: AQEBLOLKZH8ssebkqZ7e2Om1AIQwn+CwVHS3mTRqTr1zJXEnV2ofrc075VRciiufCcn6M4lugTohbbEV3cDIfiazEGm7l0LXF6S2mdRHJ4bb6xly9BfskGZAFHxHch/aGqsh/dK3Yy+8GObYyQHo7aabizjrnucq1jQmKx29jTirKR8/RHXyhnczOwg06YRHKrIWIlL4F+9/gv9HghFVlGkQBiJAqoDRqVdI0z4MUVyimnr6uq3WdolhR42nAf0QXI6vF+wN25nwJh9ad8Uk/eTYbJoan8tIR2hmDO5760ldG0zBqCSLr3uyUl7wr00cA0yJ4XrMRcIF/OLKdOQrMTL82SJV6CZfevy/W7z1kODy+DiXVx3shs8aQYND+IQyHeOBGNRpMyEMKD2C4EhTM8SHRHyXcuSezyDwGQnQ9a2cV3pGLkoTHDG40EhWvyVoXIe7 2025-08-01 16:30:16 [INFO]: Processed 1 messages, reached the limit of 0. 2025-08-01 16:30:16 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 16:30:16 [INFO]: inside itemsold and closed 14409 2025-08-01 16:30:18 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 16:30:18 [INFO]: autolink for user_id 14409 is 1 2025-08-01 16:30:18 [INFO]: Ebay item id :: 306425281057 exists in Database 2025-08-01 16:30:18 [INFO]: Item is reliested :: exists in Database 2025-08-01 16:30:18 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 16:30:18 [INFO]: in processold action queue is array for [] 2025-08-01 16:30:18 [INFO]: Successfully processed data for user 14409 2025-08-01 16:30:18 [INFO]: Execution Started 2025-08-01 16:30:18 [INFO]: Execution Finished 2025-08-01 16:40:01 [INFO]: Execution Started 2025-08-01 16:40:01 [INFO]: old server sucessfully connected 2025-08-01 16:40:01 [INFO]: sqs client sucess created 2025-08-01 16:40:02 [INFO]: Number of messages in the queue: 0 2025-08-01 16:40:22 [INFO]: item found in queue is if condition 14409 2025-08-01 16:40:22 [INFO]: item found in queue is 14409 2025-08-01 16:40:22 [INFO]: Message deleted from the queue for receipt handle: AQEBfLi8sztiaVfYAj+V8UN2CmyViPDZzJbQl78YQFFpPYF6uNQCMWusBnfCoXsV7rGP52f/J8NawF6aloAqS90U3WRoWUkLN/etIOXv0T4d6jNGOKJeynZp9ifgmbPONcNmyH3AIYLSoUdjThTbtii1cFJAMme+SHj08FIhFDkkR23IR9j+FMO/AkPcYsXwgHJC9oFlLbFUXp7VtSk747LRo4OO7pl4HSl4fpGs4Y7zmrPYvtv/eHI2sjSUA9MFN2WAoLxT/sIDdm3mbhukUsxXCCfiGhGVRQ/Oy9uCJjxiUSQ2Pju2MkkMO8UeYORe8L5ebk+qdBmMm4c8vBHCsy6+gEDURpCNMobMAkmycxCrhIpzFPGworBe+ZmGEmrCztVey1wiNepHy3H0/e81XghlQK95AQ7lmuVykgbL4/kU6DNdu9eL03zHmzEPHVsXDgyg 2025-08-01 16:40:22 [INFO]: Processed 1 messages, reached the limit of 0. 2025-08-01 16:40:22 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 16:40:22 [INFO]: inside itemsold and closed 14409 2025-08-01 16:40:24 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 16:40:24 [INFO]: autolink for user_id 14409 is 1 2025-08-01 16:40:24 [INFO]: Ebay item id :: 326340158521 exists in Database 2025-08-01 16:40:24 [INFO]: Item is reliested :: exists in Database 2025-08-01 16:40:24 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 16:40:24 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 16:40:24 [INFO]: in processold action queue is array for {"44649447":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44649447","ebayitemid":"326340158521","shopifyproductid":"8920540086494","variants":[{"price":"19.99","quantity":0,"weight":"0.9375","shopifyproductid":"8920540086494","shopifyvariantid":"46781901439198","shopifyinventoryid":"48880415473886","shopifylocationid":"58450641063","product_id":"44649447","variant_id":"77554636","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 16:40:24 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 16:40:24 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 16:40:24 [INFO]: Shopify Inventory id 48880415473886 2025-08-01 16:40:24 [INFO]: Shopify Location id 58450641063 2025-08-01 16:40:24 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 16:40:25 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T16:40:24Z","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-01 16:40:25 [INFO]: Change: available | Delta: -1 2025-08-01 16:40:25 [INFO]: Change: on_hand | Delta: -1 2025-08-01 16:40:25 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 16:40:25 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44649447 and user_id = 14409 2025-08-01 16:40:25 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77554636 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 16:40:25 [INFO]: updateIdsQuantity -> ["77554636"] 2025-08-01 16:40:25 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-01 16:40:25 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77554636 THEN 0 END, quantityflag = CASE WHEN id = 77554636 THEN 0 END WHERE user_id = 14409 AND id IN (77554636) 2025-08-01 16:40:25 [INFO]: QUANTITY Updated IDs: 77554636 2025-08-01 16:40:25 [INFO]: Successfully processed data for user 14409 2025-08-01 16:40:25 [INFO]: Execution Started 2025-08-01 16:40:25 [INFO]: Execution Finished 2025-08-01 16:50:01 [INFO]: Execution Started 2025-08-01 16:50:01 [INFO]: old server sucessfully connected 2025-08-01 16:50:01 [INFO]: sqs client sucess created 2025-08-01 16:50:02 [INFO]: Number of messages in the queue: 0 2025-08-01 16:50:23 [INFO]: Execution Started 2025-08-01 16:50:23 [INFO]: Execution Finished