2025-08-07 00:00:01 [INFO]: Execution Started 2025-08-07 00:00:01 [INFO]: old server sucessfully connected 2025-08-07 00:00:01 [INFO]: sqs client sucess created 2025-08-07 00:00:02 [INFO]: Number of messages in the queue: 1 2025-08-07 00:00:03 [INFO]: item found in queue is if condition 14409 2025-08-07 00:00:03 [INFO]: item found in queue is 14409 2025-08-07 00:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBjyZGLowHa5B/QJsHjlVFLXYpw86qJSVOuJvOAiUPmdv5XhUHHp8IJOaYOdKlrOt06BubbjaR/jffCAqL+2MH1K3xYbxlpywI+VyHW4UuxHQohawtJcGLkuOpDdJKkjZ+x/o4Jmx0QnCnEHWXDvJSrN9FXiofDOTmQXgB24PAWdT5vF2UwgTDfVFkyXQUpJMTn43+9fU8hmHDErdeDumgH9KVg9a0bkzrh11tnKWCilpEJfJWPAHGeqHzDcj+iv2sOnhtfYFA47N8GLU67fzrdUd4cudL2ajsWdDwS2OdXhR2f2yMiMRZaR09enh2xMBAPoqZ1uIgzb1dNLk/trEfiEWLMgTNLvDqY0TEXrsI9PuTWtV7mgFElANlEeuh35Bxmdk7jUYPQ212alg/crnbD+x70PVuzKztmpFH2laHia6gOeoCqb3yFNmqs+gVoKo7 2025-08-07 00:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 00:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 00:00:03 [INFO]: inside itemsold and closed 14409 2025-08-07 00:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 00:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-07 00:00:05 [INFO]: Ebay item id :: 404425762292 exists in Database 2025-08-07 00:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-07 00:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 00:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 00:00:05 [INFO]: in processold action queue is array for {"44764896":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44764896","ebayitemid":"404425762292","shopifyproductid":"8104877981918","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8104877981918","shopifyvariantid":"44300019990750","shopifyinventoryid":"46397355196638","shopifylocationid":"","product_id":"44764896","variant_id":"77673438","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 00:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 00:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 00:00:05 [INFO]: Shopify Inventory id 46397355196638 2025-08-07 00:00:05 [INFO]: Shopify Location id 58450641063 2025-08-07 00:00:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 00:00: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-07 00:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 00:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44764896 and user_id = 14409 2025-08-07 00:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77673438 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 00:00:05 [INFO]: updateIdsQuantity -> ["77673438"] 2025-08-07 00:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 00:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77673438 THEN 0 END, quantityflag = CASE WHEN id = 77673438 THEN 0 END WHERE user_id = 14409 AND id IN (77673438) 2025-08-07 00:00:05 [INFO]: QUANTITY Updated IDs: 77673438 2025-08-07 00:00:05 [INFO]: Successfully processed data for user 14409 2025-08-07 00:00:05 [INFO]: Execution Started 2025-08-07 00:00:05 [INFO]: Execution Finished 2025-08-07 00:10:01 [INFO]: Execution Started 2025-08-07 00:10:01 [INFO]: old server sucessfully connected 2025-08-07 00:10:01 [INFO]: sqs client sucess created 2025-08-07 00:10:02 [INFO]: Number of messages in the queue: 1 2025-08-07 00:10:04 [INFO]: item found in queue is if condition 14409 2025-08-07 00:10:04 [INFO]: item found in queue is 14409 2025-08-07 00:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBojvvxlH67mPITj+ynPDcYqv+uiXEZ9rwFvYv8ZFxBf/rtUtmG1WJuISOEzeMjP74ypSctw8/r6ffb/c+ZnuwkSPIPcmmrq6R/SoKamQEcj2GeCVtcCzmU6DRtgKwK5TwQNushCqIJPj2MJ+Qzs+X53fdQwzLLsAE+vEoOeLaMpik5llltulEiZdl0tk7vsXZPTRfbLoJS5wWN5Mnane+FX9J4+QgoUYDLLywBXVrOlJEHvIuAuWU9Em4MevgS7sK/TXHOr8LqO5IWSIbKSqREoidMlTo5oqqLd14NLLWoTeNBew5IPgeJGY7J03ehCjX0xfHgErr7FvQD3zzMFYRsCPi6wFtTeHl2Qr53mtoj5c35kOKo3QIJctJ2RLvZPReKcRMEB/onCRztxbG2kE0DF9KopI0Pjf+iiZ28ql4lAviCSVlfihdUnRdTmn0Omtk 2025-08-07 00:10:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 00:10:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 00:10:04 [INFO]: inside itemsold and closed 14409 2025-08-07 00:10:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 00:10:06 [INFO]: autolink for user_id 14409 is 1 2025-08-07 00:10:06 [INFO]: Ebay item id :: 323087950174 exists in Database 2025-08-07 00:10:06 [INFO]: Item is reliested :: exists in Database 2025-08-07 00:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 00:10:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 00:10:06 [INFO]: in processold action queue is array for {"44662576":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44662576","ebayitemid":"323087950174","shopifyproductid":"6633916661927","variants":[{"price":"9.94","quantity":0,"weight":"0.5","shopifyproductid":"6633916661927","shopifyvariantid":"39652275126439","shopifyinventoryid":"41746915786919","shopifylocationid":"","product_id":"44662576","variant_id":"77567796","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 00:10:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 00:10:06 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 00:10:06 [INFO]: Shopify Inventory id 41746915786919 2025-08-07 00:10:06 [INFO]: Shopify Location id 58450641063 2025-08-07 00:10:06 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 00:10:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T00:10: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-07 00:10:06 [INFO]: Change: available | Delta: -1 2025-08-07 00:10:06 [INFO]: Change: on_hand | Delta: -1 2025-08-07 00:10:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 00:10:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44662576 and user_id = 14409 2025-08-07 00:10:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77567796 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 00:10:06 [INFO]: updateIdsQuantity -> ["77567796"] 2025-08-07 00:10:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 00:10:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77567796 THEN 0 END, quantityflag = CASE WHEN id = 77567796 THEN 0 END WHERE user_id = 14409 AND id IN (77567796) 2025-08-07 00:10:06 [INFO]: QUANTITY Updated IDs: 77567796 2025-08-07 00:10:06 [INFO]: Successfully processed data for user 14409 2025-08-07 00:10:06 [INFO]: Execution Started 2025-08-07 00:10:06 [INFO]: Execution Finished 2025-08-07 00:20:02 [INFO]: Execution Started 2025-08-07 00:20:02 [INFO]: old server sucessfully connected 2025-08-07 00:20:02 [INFO]: sqs client sucess created 2025-08-07 00:20:03 [INFO]: Number of messages in the queue: 1 2025-08-07 00:20:03 [INFO]: item found in queue is if condition 14409 2025-08-07 00:20:03 [INFO]: item found in queue is 14409 2025-08-07 00:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBLcG35V78aYLNOwVfeDM0ltwqqXSq60tq7FC9//jOauL0DU6ITj+AKv4dSBx9Y8GkAJ9b3f0g9Booals83t5aGv9APYmtejxtwX/RdKG9lU0LqSNAwQ5g2K4fe+/EE978Md3c22BzrIlQB+M7M6W0TkzNuzl2nbCIFFJzEpjVx1BkfI7BhKPxf4rqvaY7O6vjzbacwQm/zCxob8WgIo3SK15cVazDKWugqAHfJbsia3z80KvibF96cI+geN6HY9atqsvyJR0B/ONuH5DAORTEgzbf9u/G6d0Y0x7iHvkSRZEUcqoZGTuAhnrJn58buuQH8lbyXw2T+6gdAQlpxyf2ieEWtR2q4YVkR5Vz8h7bX4DQJ0pftZ/bAnGGbqcwfqxaZzZaCDJnZFlxbm/CO0L4Gu+Hb2ucVpAKnE7QloUEwxIGVvnBUragTEbhTcgEpwBl 2025-08-07 00:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 00:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 00:20:03 [INFO]: inside itemsold and closed 14409 2025-08-07 00:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 00:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-07 00:20:05 [INFO]: Ebay item id :: 326582311098 exists in Database 2025-08-07 00:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-07 00:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 00:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 00:20:05 [INFO]: in processold action queue is array for {"44791172":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44791172","ebayitemid":"326582311098","shopifyproductid":"8918140649694","variants":[{"price":"21.99","quantity":0,"weight":"1","shopifyproductid":"8918140649694","shopifyvariantid":"46733787365598","shopifyinventoryid":"48832274628830","shopifylocationid":"58450641063","product_id":"44791172","variant_id":"77701421","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 00:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 00:20:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 00:20:05 [INFO]: Shopify Inventory id 48832274628830 2025-08-07 00:20:05 [INFO]: Shopify Location id 58450641063 2025-08-07 00:20:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 00:20:06 [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 00:20:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 00:20:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44791172 and user_id = 14409 2025-08-07 00:20:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77701421 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 00:20:06 [INFO]: updateIdsQuantity -> ["77701421"] 2025-08-07 00:20:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 00:20:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77701421 THEN 0 END, quantityflag = CASE WHEN id = 77701421 THEN 0 END WHERE user_id = 14409 AND id IN (77701421) 2025-08-07 00:20:06 [INFO]: QUANTITY Updated IDs: 77701421 2025-08-07 00:20:06 [INFO]: Successfully processed data for user 14409 2025-08-07 00:20:06 [INFO]: Execution Started 2025-08-07 00:20:06 [INFO]: Execution Finished 2025-08-07 00:30:01 [INFO]: Execution Started 2025-08-07 00:30:01 [INFO]: old server sucessfully connected 2025-08-07 00:30:01 [INFO]: sqs client sucess created 2025-08-07 00:30:03 [INFO]: Number of messages in the queue: 1 2025-08-07 00:30:03 [INFO]: item found in queue is if condition 14409 2025-08-07 00:30:03 [INFO]: item found in queue is 14409 2025-08-07 00:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBDvqidQgZRbfCL+HDCOemE/3RyUdQdV1qekkJzTuKDZ0tKXY4Ojf6VpUjZUK0fI2JDi0eQc3NyAtTpgOk4PUPL3k0u7B9xWHr1KvQ5mBmMHbhBCXkhWuwDj7jne2H13rwWf+KFvQo7Ab3fPrewFg0PErbm55oYBbODj/X1POEKKwkeMj9GcTDs3CVQUVF/QXG8nhPncBv0kaemwTGYYIrNrY84QuujYMx77KIYkIW7GBS9M8v3f4+uwwYBdUGqpOm+gqUTnwcMRFyuTlsoIcKT8w3iJ6uJxK0w+ZQX0iOFqt12ai709gdqiDg3urEgjMAo/2FMW15VgecRfT1e+DzPAslo4UARd0uYNJWoURLwxJEXcC7l95nNaKdwEHM8SEYDr6yUcMptzwr7+zBHTbh59Uhbd3sdgPoN9YQg4oSK4qssjSkXab2rA8y/r8aZE+n 2025-08-07 00:30:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 00:30:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 00:30:03 [INFO]: inside itemsold and closed 14409 2025-08-07 00:30:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 00:30:05 [INFO]: autolink for user_id 14409 is 1 2025-08-07 00:30:05 [INFO]: Ebay item id :: 305979947155 exists in Database 2025-08-07 00:30:05 [INFO]: Item is reliested :: exists in Database 2025-08-07 00:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 00:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 00:30:05 [INFO]: in processold action queue is array for {"44576497":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44576497","ebayitemid":"305979947155","shopifyproductid":"8766564204766","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"8766564204766","shopifyvariantid":"46158946369758","shopifyinventoryid":"48258280063198","shopifylocationid":"","product_id":"44576497","variant_id":"77469204","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 00:30:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 00:30:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 00:30:05 [INFO]: Shopify Inventory id 48258280063198 2025-08-07 00:30:05 [INFO]: Shopify Location id 58450641063 2025-08-07 00:30:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 00:30: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-07 00:30:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 00:30:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44576497 and user_id = 14409 2025-08-07 00:30:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77469204 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 00:30:05 [INFO]: updateIdsQuantity -> ["77469204"] 2025-08-07 00:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 00:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77469204 THEN 0 END, quantityflag = CASE WHEN id = 77469204 THEN 0 END WHERE user_id = 14409 AND id IN (77469204) 2025-08-07 00:30:05 [INFO]: QUANTITY Updated IDs: 77469204 2025-08-07 00:30:05 [INFO]: Successfully processed data for user 14409 2025-08-07 00:30:05 [INFO]: Execution Started 2025-08-07 00:30:05 [INFO]: Execution Finished 2025-08-07 00:40:01 [INFO]: Execution Started 2025-08-07 00:40:01 [INFO]: old server sucessfully connected 2025-08-07 00:40:01 [INFO]: sqs client sucess created 2025-08-07 00:40:02 [INFO]: Number of messages in the queue: 0 2025-08-07 00:40:22 [INFO]: Execution Started 2025-08-07 00:40:22 [INFO]: Execution Finished 2025-08-07 00:50:01 [INFO]: Execution Started 2025-08-07 00:50:01 [INFO]: old server sucessfully connected 2025-08-07 00:50:01 [INFO]: sqs client sucess created 2025-08-07 00:50:02 [INFO]: Number of messages in the queue: 0 2025-08-07 00:50:23 [INFO]: Execution Started 2025-08-07 00:50:23 [INFO]: Execution Finished