2025-08-01 19:00:01 [INFO]: Execution Started 2025-08-01 19:00:01 [INFO]: old server sucessfully connected 2025-08-01 19:00:01 [INFO]: sqs client sucess created 2025-08-01 19:00:02 [INFO]: Number of messages in the queue: 1 2025-08-01 19:00:03 [INFO]: item found in queue is if condition 14409 2025-08-01 19:00:03 [INFO]: item found in queue is 14409 2025-08-01 19:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBjSJBXtmIRwMJMu4uvuRCMuS6DthR16ti5ZkslJIOKBhy7Gu0ksZWoHlTFJMmYYDjRja7LSZMUIEs79l+ekvsdh4T7PS+PQ/ulnRvGgPLWJ5NSkzGhQRbxezASlTTlsujTYri0MH6PWhEsUQCM4zdaipFQ8FaiMsMfRbPmEgkNE9J0csjetF7Ur5VKJ5drKgMGQzzXpom+/PunQznaPuLU3iit3Zg9NmliQEMsL2cJ+j4PyF2pT7A9l+BaLEq4U22bLTjSIlCrkBG6ds+ZReBCxDA8UaogZpzx8CXoCkUETqgcA3ZUTz0M3MDJOre5HuGbHEyOtjGJuLNjYvq/DfFOdCZB0O/+FkParNi1UwyEunhBP7UlD6f4Wfhe+kz6d6Cin3Yhme9JxDYIYRgSprhxFWWcPr3gWs0FkLv8LopJbjaXqnOwTIGmi2pzN+ivwU8 2025-08-01 19:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-01 19:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 19:00:03 [INFO]: inside itemsold and closed 14409 2025-08-01 19:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 19:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-01 19:00:05 [INFO]: Ebay item id :: 226642777392 exists in Database 2025-08-01 19:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-01 19:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 19:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 19:00:05 [INFO]: in processold action queue is array for {"44737385":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44737385","ebayitemid":"226642777392","shopifyproductid":"8839693172958","variants":[{"price":"43.99","quantity":0,"weight":"0.75","shopifyproductid":"8839693172958","shopifyvariantid":"46357269905630","shopifyinventoryid":"48459037868254","shopifylocationid":"","product_id":"44737385","variant_id":"77645322","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 19:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 19:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 19:00:05 [INFO]: Shopify Inventory id 48459037868254 2025-08-01 19:00:05 [INFO]: Shopify Location id 58450641063 2025-08-01 19:00:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 19:00:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T19: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-01 19:00:05 [INFO]: Change: available | Delta: -1 2025-08-01 19:00:05 [INFO]: Change: on_hand | Delta: -1 2025-08-01 19:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 19:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44737385 and user_id = 14409 2025-08-01 19:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77645322 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 19:00:05 [INFO]: updateIdsQuantity -> ["77645322"] 2025-08-01 19:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-01 19:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77645322 THEN 0 END, quantityflag = CASE WHEN id = 77645322 THEN 0 END WHERE user_id = 14409 AND id IN (77645322) 2025-08-01 19:00:05 [INFO]: QUANTITY Updated IDs: 77645322 2025-08-01 19:00:05 [INFO]: Successfully processed data for user 14409 2025-08-01 19:00:05 [INFO]: Execution Started 2025-08-01 19:00:05 [INFO]: Execution Finished 2025-08-01 19:10:01 [INFO]: Execution Started 2025-08-01 19:10:01 [INFO]: old server sucessfully connected 2025-08-01 19:10:01 [INFO]: sqs client sucess created 2025-08-01 19:10:02 [INFO]: Number of messages in the queue: 1 2025-08-01 19:10:02 [INFO]: item found in queue is if condition 14409 2025-08-01 19:10:02 [INFO]: item found in queue is 14409 2025-08-01 19:10:02 [INFO]: Message deleted from the queue for receipt handle: AQEBbgvHeG/vte9UNNUhLXRp7UK55OZW5CYWegZup6GfTThvT1/uVqFndnuCxAcw1NYELbgY+sIEDtQ1P552EUq9h7qc9eG2xyFhMnGtfyEiwbZUf/QBNLfheTiF35R/E+Dgo5iIt+mkj+w0Jm91vQaHrcuMQEr392rkZ2Ub0Hku3CCmhNrnnJIuOdln6I6IdztLnUo46oTM52xi/auSckWGMf+kcRYaU1eVpcslJSxKItLpACJ0UP7eYAP/I6mZvJ+WrKyt969tTHUzR+MzE/zfHYtPIcEPLKC4CVbkxqjvRkXlmaP2vf4/CIAbp66RCygtyrpXTeclj4Ka5nCoON/98qnr1Doev8WHPw4CCx5vIEfOWgCQm0lW58SmbNP4NXOsgfa/9iP8/EmTXNblT1eLzR3x4rOl+RcKHPS9yegZzKsNXR56eCfCXjBBn7l6K8zR 2025-08-01 19:10:02 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-01 19:10:02 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 19:10:02 [INFO]: inside itemsold and closed 14409 2025-08-01 19:10:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 19:10:04 [INFO]: autolink for user_id 14409 is 1 2025-08-01 19:10:04 [INFO]: Ebay item id :: 226499266739 exists in Database 2025-08-01 19:10:04 [INFO]: Item is reliested :: exists in Database 2025-08-01 19:10:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 19:10:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 19:10:04 [INFO]: in processold action queue is array for {"44651009":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44651009","ebayitemid":"226499266739","shopifyproductid":"8766510465246","variants":[{"price":"34.99","quantity":0,"weight":"3","shopifyproductid":"8766510465246","shopifyvariantid":"46158746124510","shopifyinventoryid":"48258079817950","shopifylocationid":"","product_id":"44651009","variant_id":"77556198","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 19:10:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 19:10:04 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 19:10:04 [INFO]: Shopify Inventory id 48258079817950 2025-08-01 19:10:04 [INFO]: Shopify Location id 58450641063 2025-08-01 19:10:04 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 19:10:04 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T19:10:04Z","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 19:10:04 [INFO]: Change: available | Delta: -1 2025-08-01 19:10:04 [INFO]: Change: on_hand | Delta: -1 2025-08-01 19:10:04 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 19:10:04 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44651009 and user_id = 14409 2025-08-01 19:10:04 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77556198 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 19:10:04 [INFO]: updateIdsQuantity -> ["77556198"] 2025-08-01 19:10:04 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-01 19:10:04 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77556198 THEN 0 END, quantityflag = CASE WHEN id = 77556198 THEN 0 END WHERE user_id = 14409 AND id IN (77556198) 2025-08-01 19:10:04 [INFO]: QUANTITY Updated IDs: 77556198 2025-08-01 19:10:04 [INFO]: Successfully processed data for user 14409 2025-08-01 19:10:04 [INFO]: Execution Started 2025-08-01 19:10:04 [INFO]: Execution Finished 2025-08-01 19:20:01 [INFO]: Execution Started 2025-08-01 19:20:01 [INFO]: old server sucessfully connected 2025-08-01 19:20:01 [INFO]: sqs client sucess created 2025-08-01 19:20:02 [INFO]: Number of messages in the queue: 1 2025-08-01 19:20:02 [INFO]: item found in queue is if condition 14409 2025-08-01 19:20:02 [INFO]: item found in queue is 14409 2025-08-01 19:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBzNyvT829hvIp1LpeGwqDR8NlMFAwDg/zubQRYj5s4em+4w1XXjrBDzQtsDK4RHBzFSZnGCZfZsPlobamyHjbiDTVDPpE5tGjohmpD3ldK2nV9URwS9joQrR8Psg6qzfpTKKYaLNlvCABogExp6duR8s9PBpu6uDEkZS+9u2lf6GhlvbZLHPLQ+9aFtJNTgSlLdEHmQ0GXLPpwdKBRagtCX26jAJoN864HaVrIrNS71o4Yk1xnF+f1n3KQvawbMsQXtOFgLjUHWZEtv2qUXkhcX49x9dQ74TBREAw5ttURfTgsN8lCKnDOQ0t4TOarslVx9PD9ccuR+9Px0y31jluwgvK9NlUU1amKuvcJAab7HUNQz5ULL0dlOaWoxjpEtMmb8g9RZSxvFPgNCFtRJDzh3Uel1NZJwqC6Q3XXIPU3Q0bYzmQ7zyY6AdHUuLBEgqH 2025-08-01 19:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-01 19:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 19:20:03 [INFO]: inside itemsold and closed 14409 2025-08-01 19:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 19:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-01 19:20:05 [INFO]: Ebay item id :: 226705965303 exists in Database 2025-08-01 19:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-01 19:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 19:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 19:20:05 [INFO]: in processold action queue is array for {"44650844":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44650844","ebayitemid":"226705965303","shopifyproductid":"8878302626014","variants":[{"price":"9.99","quantity":0,"weight":"0.9375","shopifyproductid":"8878302626014","shopifyvariantid":"46620002287838","shopifyinventoryid":"48722897043678","shopifylocationid":"","product_id":"44650844","variant_id":"77556033","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 19:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 19:20:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 19:20:05 [INFO]: Shopify Inventory id 48722897043678 2025-08-01 19:20:05 [INFO]: Shopify Location id 58450641063 2025-08-01 19:20:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 19:20:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T19:20: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-01 19:20:05 [INFO]: Change: available | Delta: -1 2025-08-01 19:20:05 [INFO]: Change: on_hand | Delta: -1 2025-08-01 19:20:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 19:20:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44650844 and user_id = 14409 2025-08-01 19:20:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77556033 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 19:20:05 [INFO]: updateIdsQuantity -> ["77556033"] 2025-08-01 19:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-01 19:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77556033 THEN 0 END, quantityflag = CASE WHEN id = 77556033 THEN 0 END WHERE user_id = 14409 AND id IN (77556033) 2025-08-01 19:20:05 [INFO]: QUANTITY Updated IDs: 77556033 2025-08-01 19:20:05 [INFO]: Successfully processed data for user 14409 2025-08-01 19:20:05 [INFO]: Execution Started 2025-08-01 19:20:05 [INFO]: Execution Finished 2025-08-01 19:30:01 [INFO]: Execution Started 2025-08-01 19:30:01 [INFO]: old server sucessfully connected 2025-08-01 19:30:01 [INFO]: sqs client sucess created 2025-08-01 19:30:02 [INFO]: Number of messages in the queue: 3 2025-08-01 19:30:03 [INFO]: item found in queue is if condition 14409 2025-08-01 19:30:03 [INFO]: item found in queue is 14409 2025-08-01 19:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEB6b5KUsZChZQBFIVoIhEnnywB9jI1voyMZcWlA86i3hqbMXxeQ/dq6ZvPlikTVyIcnGg3HxifGVEyoXQXLz+UeceOquUV8SCVWJeIL3kQXJNLBeWLvU5dfRl0FRS3OtJpvVxziRQ5d2IsBsQe4QOo7ALkMXMMeNlnq42S6VJmfK1mq/eWrIpije37KycoUT/M4oJDSLX8iKJSBfC8Z83xzzxT/so7ixoWj560GGbpkn6DZ6gpZ0JOKI3sudLVwrn5hx5ALKw6J5iANJfprJSu9iTohGJ1qhn+PDPrOCTBxsg0jYhKAUycecNu/KVpDVt7Fv1IFGCHK/U8oMtx+P+KqYQWuZ5JvWd9rxqzFPoUMM9sj6hhg/3H3cyu2ea2v9GD89O8NQXudSR67nmsEfXdlqdt20nok+PVTBOUajSCC4Yn5buoWrQFG1tovN4vpLmd 2025-08-01 19:30:03 [INFO]: item found in queue is if condition 14409 2025-08-01 19:30:03 [INFO]: item found in queue is 14409 2025-08-01 19:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBWZhFWUx0wHDTajL7kMQsVJ/K8O/5j9l2Xz+Xwq4OUGhcojKlo7n2owQJkmZRUXDy+0zXOhvL7mEQb809aEFAnLBxF2FoQhK6f63I8cpmPDnG1y4uky5NIr9m21WZ40M5Ie1hPcRQAvQqVKfbNp1uJvpTz+zs23MOk9iRks3op4YrQY4bHVbA6mhnbEcZ9DyLKmhL5aBvIcTt1I8oqtqcrTEcGJFlGVgOtABOTgbq0ryIs1Ph4UOD78G4RMHyrm7taCIMqfjfE6JgkYrdpDa90gv3VQF2mVbQasZjpMHQ6uaVciyN0BiXTWgD7mvfnwYovDD3/brxP8kRffiIIZpm3Rk9JDgX0JPlcUA4ZrWlstiP42Gw/EFZe8io11D7b7UZtyxlsRTYG/V8oP5kKYzNN3+SdN3H6/SMfNloNx43xKftfSc95fc/SVOPQ6O506kL 2025-08-01 19:30:04 [INFO]: item found in queue is if condition 14409 2025-08-01 19:30:04 [INFO]: item found in queue is 14409 2025-08-01 19:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBc/ktOIxtuY9DDZ1rFI0+4/aGIgQYPafh34dwbwW+Sjije62WSVNQNbh7vAPr1aZiXohDl0rq3Nx/6fjwATK/CMFqMeRpXOU164X6Bwdt4GgWkWGGDTO/KB/v+0J4J5wtc0SaZmGzwkjGu2QFlMC46c1bsM81c18xFicJNyAxk6YqNiv5Ehelq9XONElMISTSzkNynFmsk6qL4GX0BUz/s6tPC7yn7UbS0HMHhYH2Kxhk7b8sUpX+hbrkrqfpAAK3whky/eNxJRYW64lY2EYroexgMvt7iXU/POIWYtAQnpLv9NatrPJtnjnK4nYZbKM+iwuXNWcq2lIsN5a1Mey2t9WDI4cwaeZ8VTbFNlK0/zpFV98qrDfoy9x3W/4YImhw8Kd7VegP4Zj+7x/ybNlryJGQBKhDBodK2NosankNqWnyqy6yWEADn3XIdvWmpV6g 2025-08-01 19:30:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-01 19:30:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 19:30:04 [INFO]: inside itemsold and closed 14409 2025-08-01 19:30:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 19:30:06 [INFO]: autolink for user_id 14409 is 1 2025-08-01 19:30:06 [INFO]: Ebay item id :: 285654646491 exists in Database 2025-08-01 19:30:06 [INFO]: Item is reliested :: exists in Database 2025-08-01 19:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 19:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 19:30:06 [INFO]: inside itemsold and closed 14409 2025-08-01 19:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 19:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-01 19:30:07 [INFO]: Ebay item id :: 405888728025 exists in Database 2025-08-01 19:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-01 19:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 19:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 19:30:07 [INFO]: inside itemsold and closed 14409 2025-08-01 19:30:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 19:30:09 [INFO]: autolink for user_id 14409 is 1 2025-08-01 19:30:09 [INFO]: Ebay item id :: 326550422564 exists in Database 2025-08-01 19:30:09 [INFO]: Item is reliested :: exists in Database 2025-08-01 19:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 19:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 19:30:09 [INFO]: in processold action queue is array for {"44644520":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44644520","ebayitemid":"285654646491","shopifyproductid":"8254042865886","variants":[{"price":"77.99","quantity":0,"weight":"3","shopifyproductid":"8254042865886","shopifyvariantid":"44672490537182","shopifyinventoryid":"46770471010526","shopifylocationid":"","product_id":"44644520","variant_id":"77549709","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44837562":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44837562","ebayitemid":"405888728025","shopifyproductid":"8927144542430","variants":[{"price":"10.99","quantity":0,"weight":"2","shopifyproductid":"8927144542430","shopifyvariantid":"46845888692446","shopifyinventoryid":"48956095365342","shopifylocationid":"58450641063","product_id":"44837562","variant_id":"77748496","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44676695":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44676695","ebayitemid":"326550422564","shopifyproductid":"8886648701150","variants":[{"price":"49.99","quantity":0,"weight":"3","shopifyproductid":"8886648701150","shopifyvariantid":"46643705643230","shopifyinventoryid":"48746674716894","shopifylocationid":"","product_id":"44676695","variant_id":"77581915","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 19:30:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 19:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 19:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 19:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 19:30:09 [INFO]: Shopify Inventory id 46770471010526 2025-08-01 19:30:09 [INFO]: Shopify Location id 58450641063 2025-08-01 19:30:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 19:30:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T19:30:09Z","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 19:30:09 [INFO]: Change: available | Delta: -1 2025-08-01 19:30:09 [INFO]: Change: on_hand | Delta: -1 2025-08-01 19:30:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 19:30:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44644520 and user_id = 14409 2025-08-01 19:30:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77549709 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 19:30:09 [INFO]: Shopify Inventory id 48956095365342 2025-08-01 19:30:09 [INFO]: Shopify Location id 58450641063 2025-08-01 19:30:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 19:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T19:30:09Z","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 19:30:10 [INFO]: Change: available | Delta: -1 2025-08-01 19:30:10 [INFO]: Change: on_hand | Delta: -1 2025-08-01 19:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 19:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44837562 and user_id = 14409 2025-08-01 19:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77748496 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 19:30:10 [INFO]: Shopify Inventory id 48746674716894 2025-08-01 19:30:10 [INFO]: Shopify Location id 58450641063 2025-08-01 19:30:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 19:30:10 [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 19:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 19:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44676695 and user_id = 14409 2025-08-01 19:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77581915 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 19:30:10 [INFO]: updateIdsQuantity -> ["77549709","77748496","77581915"] 2025-08-01 19:30:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-01 19:30:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77549709 THEN 0 WHEN id = 77748496 THEN 0 WHEN id = 77581915 THEN 0 END, quantityflag = CASE WHEN id = 77549709 THEN 0 WHEN id = 77748496 THEN 0 WHEN id = 77581915 THEN 0 END WHERE user_id = 14409 AND id IN (77549709,77748496,77581915) 2025-08-01 19:30:10 [INFO]: QUANTITY Updated IDs: 77549709, 77748496, 77581915 2025-08-01 19:30:10 [INFO]: Successfully processed data for user 14409 2025-08-01 19:30:10 [INFO]: Execution Started 2025-08-01 19:30:10 [INFO]: Execution Finished 2025-08-01 19:40:01 [INFO]: Execution Started 2025-08-01 19:40:01 [INFO]: old server sucessfully connected 2025-08-01 19:40:01 [INFO]: sqs client sucess created 2025-08-01 19:40:02 [INFO]: Number of messages in the queue: 3 2025-08-01 19:40:03 [INFO]: item found in queue is if condition 14409 2025-08-01 19:40:03 [INFO]: item found in queue is 14409 2025-08-01 19:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBjT0h784vy6Z7hlEbOA3qYTMVslqVBNN+8jW7GAt/x4b9KrohpRk6cx/8ibYG90W3UORHBBsUrjEvs2KNcvNSy6EEfgyu9sha22SW7Gyl3gPfyz61oW5ZNLUY6pIXuGUGMGnQmTbqys4E1Y+in1ce774AokD2d7QwwGmcieWcwkGxVq9YI8eUTzqgVD75NMvI6PzIrrSspnXBMlw+CV89d2JF+oyzZbI2CImudMfCKsSZvpYSjCP3qnpimHLxWW6lXGs0y+c4oLuy0ZFG2JRGB0Z9xN0miT0TIQv/DyVeXRdRDJq0upj0zkD1Sl5taEKTaTo3KEIr2oJn8lNeGS7fG3LbLew6z86kD9PWkkskqAP/hVVTIa/K8F8bahEtViw3cZlETDY90BPfcvq8ZzsaWc6KIfVKpqPg/7zxhD53LiPsKPgjAm7uv0on++7AfOFM 2025-08-01 19:40:03 [INFO]: item found in queue is if condition 14409 2025-08-01 19:40:03 [INFO]: item found in queue is 14409 2025-08-01 19:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBw/mqtQIZaOttnumxs2wqZOpPqnOakmnPfzokTeemcGzdCvwaxzCy54jVRCjl87mgW/xQ4KaX6de9yhN5t5uGszxrCLbA4BHZcpDFyxCdIcPOkbHNYqrBsCluci+Yc4lHMsxPzdkBNKByF8vdKGqFTFs/FfJ0xoc+4v+4CS7utfV6OYgIoxcZ2HA28bVj1OSEbXHtVieaiuwCIqELHhA02/gB0ot/72NioIUD0DRW/NNXTO1HrOIVMP50lYD5xd4Ds7Yof3XhcjMLUlZ1YPOdLP4yVx9amYWzNrIPVWvg2cMPbfqS6kCO8xYD46WQ7b69PByUAN5768lP2q+34+OzMcrOgoYRiOnYJfyTNvFTX7LXblY5bHIs9c15N5WLTWSbZjwUXp3y+p9lx7fc3bl8e4X3zC/RPKNW4TwzhZdAT/BmHavoiz49/Oa4dEiGR9cQ 2025-08-01 19:40:04 [INFO]: item found in queue is if condition 14409 2025-08-01 19:40:04 [INFO]: item found in queue is 14409 2025-08-01 19:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBJKii6WpJG3vBvHSWThT1qCjf4W9Q0pa2jENXnOUDc39VxMPkeqC5x15gZ76rUHg2M5XB/Y2TfKGRSxdcWr/mY5fs/OCxdXQpfn05SvZo2M441XpVowiMAKYnUSejMxMnMKShAlfWDSUNtO/ZAGCsOZdNLHRuSJr9z1gPyyhruL32Se62gmtMKaQDEH3mtnQVgTmiRHInbcDvmjbFqgFbEXXLnuJAFcYXf4T5bj5cLo3QLPhMrQsezGFZDJYNIuCTaDMBDILAaC7xFN5WEDWGmKDg41h9qmlTrBK8yubNmvKg9t2dYD/M+MIySIAFjrcFvRddUXKvv+79H4xVq+oMp9g7hqBbNT30snGaEHVDj1XUTVQWF6IyS3RNb44wxIIZXbOFEKYs+VjlOKhWwcopSgl81kllPPIjD21IhdbLPm5M4rs+p2b275vd3rWlahiR 2025-08-01 19:40:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-01 19:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 19:40:04 [INFO]: inside itemsold and closed 14409 2025-08-01 19:40:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 19:40:06 [INFO]: autolink for user_id 14409 is 1 2025-08-01 19:40:06 [INFO]: Ebay item id :: 224599725781 exists in Database 2025-08-01 19:40:06 [INFO]: Item is reliested :: exists in Database 2025-08-01 19:40:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 19:40:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 19:40:06 [INFO]: inside itemsold and closed 14409 2025-08-01 19:40:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 19:40:08 [INFO]: autolink for user_id 14409 is 1 2025-08-01 19:40:08 [INFO]: Ebay item id :: 225564698611 exists in Database 2025-08-01 19:40:08 [INFO]: Item is reliested :: exists in Database 2025-08-01 19:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 19:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 19:40:08 [INFO]: inside itemsold and closed 14409 2025-08-01 19:40:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 19:40:09 [INFO]: autolink for user_id 14409 is 1 2025-08-01 19:40:09 [INFO]: Ebay item id :: 285644421211 exists in Database 2025-08-01 19:40:09 [INFO]: Item is reliested :: exists in Database 2025-08-01 19:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 19:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 19:40:09 [INFO]: in processold action queue is array for {"44730224":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44730224","ebayitemid":"224599725781","shopifyproductid":"7022352269479","variants":[{"price":"9.99","quantity":0,"weight":"0","shopifyproductid":"7022352269479","shopifyvariantid":"41198691942567","shopifyinventoryid":"43294748082343","shopifylocationid":"","product_id":"44730224","variant_id":"77638109","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44733064":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44733064","ebayitemid":"225564698611","shopifyproductid":"6805815296167","variants":[{"price":"17.99","quantity":0,"weight":"3","shopifyproductid":"6805815296167","shopifyvariantid":"40224149045415","shopifyinventoryid":"42319409348775","shopifylocationid":"","product_id":"44733064","variant_id":"77640949","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44770211":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44770211","ebayitemid":"285644421211","shopifyproductid":"8249578651870","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"8249578651870","shopifyvariantid":"44654442938590","shopifyinventoryid":"46752432488670","shopifylocationid":"","product_id":"44770211","variant_id":"77678753","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 19:40:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 19:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 19:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 19:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 19:40:09 [INFO]: Shopify Inventory id 43294748082343 2025-08-01 19:40:09 [INFO]: Shopify Location id 58450641063 2025-08-01 19:40:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 19:40:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T19:40: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-01 19:40:10 [INFO]: Change: available | Delta: -1 2025-08-01 19:40:10 [INFO]: Change: on_hand | Delta: -1 2025-08-01 19:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 19:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44730224 and user_id = 14409 2025-08-01 19:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77638109 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 19:40:10 [INFO]: Shopify Inventory id 42319409348775 2025-08-01 19:40:10 [INFO]: Shopify Location id 58450641063 2025-08-01 19:40:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 19:40:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T19:40: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-01 19:40:10 [INFO]: Change: available | Delta: -1 2025-08-01 19:40:10 [INFO]: Change: on_hand | Delta: -1 2025-08-01 19:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 19:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44733064 and user_id = 14409 2025-08-01 19:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77640949 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 19:40:10 [INFO]: Shopify Inventory id 46752432488670 2025-08-01 19:40:10 [INFO]: Shopify Location id 58450641063 2025-08-01 19:40:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 19:40:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T19:40: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-01 19:40:10 [INFO]: Change: available | Delta: -1 2025-08-01 19:40:10 [INFO]: Change: on_hand | Delta: -1 2025-08-01 19:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 19:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44770211 and user_id = 14409 2025-08-01 19:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77678753 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 19:40:10 [INFO]: updateIdsQuantity -> ["77638109","77640949","77678753"] 2025-08-01 19:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-01 19:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77638109 THEN 0 WHEN id = 77640949 THEN 0 WHEN id = 77678753 THEN 0 END, quantityflag = CASE WHEN id = 77638109 THEN 0 WHEN id = 77640949 THEN 0 WHEN id = 77678753 THEN 0 END WHERE user_id = 14409 AND id IN (77638109,77640949,77678753) 2025-08-01 19:40:10 [INFO]: QUANTITY Updated IDs: 77638109, 77640949, 77678753 2025-08-01 19:40:10 [INFO]: Successfully processed data for user 14409 2025-08-01 19:40:10 [INFO]: Execution Started 2025-08-01 19:40:10 [INFO]: Execution Finished 2025-08-01 19:50:01 [INFO]: Execution Started 2025-08-01 19:50:01 [INFO]: old server sucessfully connected 2025-08-01 19:50:01 [INFO]: sqs client sucess created 2025-08-01 19:50:02 [INFO]: Number of messages in the queue: 0 2025-08-01 19:50:23 [INFO]: Execution Started 2025-08-01 19:50:23 [INFO]: Execution Finished