2025-08-10 19:00:01 [INFO]: Execution Started 2025-08-10 19:00:01 [INFO]: old server sucessfully connected 2025-08-10 19:00:01 [INFO]: sqs client sucess created 2025-08-10 19:00:02 [INFO]: Number of messages in the queue: 1 2025-08-10 19:00:02 [INFO]: item found in queue is if condition 14409 2025-08-10 19:00:02 [INFO]: item found in queue is 14409 2025-08-10 19:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBT/VnRM+GrPl6iy/jGPhyL710ozhOT9JeMlsbf6kyYKz7Yr46G/sqB08yLR4bgHVDAsCxuVNKfsTnCKzyYNxESydVjOInbLyosOCGPjwlLJBUrpOC8Xonm/b4y8CCGNjirZyIkCWhPoyb5reKKGQtuWnXHOT5MDuYW1Asp9V56md76t8+E2LskYixnWHHBFON4HtG33stLdeURrMLqQIpriiNhMjKCtILidxcwFZfHseNa5VdH3jobaG/UIClmbbTqBRY8bm6Bh7ahXCeP+MwfuQksZaaBqy5qmVWl1daBc9JqxbAlWHu9iaTcoEKT+jrYWx3N18oSqzD2jYukSvyIJDofw3KuxuH/bNg7p2AXk+YFsPYQPbmBk1TzUWLxNPUrR8k9uYu0bCkdIiG2zJzGGVHWNWqwpSePmcKdhg7owxnb8Yxcegus97h6Utw3O00 2025-08-10 19:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-10 19:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-10 19:00:03 [INFO]: inside itemsold and closed 14409 2025-08-10 19:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-10 19:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-10 19:00:05 [INFO]: Ebay item id :: 226738357544 exists in Database 2025-08-10 19:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-10 19:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-10 19:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-10 19:00:05 [INFO]: in processold action queue is array for {"44737904":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44737904","ebayitemid":"226738357544","shopifyproductid":"8132430725342","variants":[{"price":"51.99","quantity":0,"weight":"2","shopifyproductid":"8132430725342","shopifyvariantid":"44354451767518","shopifyinventoryid":"46452221903070","shopifylocationid":"","product_id":"44737904","variant_id":"77645841","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-10 19:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-10 19:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-10 19:00:05 [INFO]: Shopify Inventory id 46452221903070 2025-08-10 19:00:05 [INFO]: Shopify Location id 58450641063 2025-08-10 19:00:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-10 19: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-10 19:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-10 19:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44737904 and user_id = 14409 2025-08-10 19:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77645841 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-10 19:00:05 [INFO]: updateIdsQuantity -> ["77645841"] 2025-08-10 19:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-10 19:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77645841 THEN 0 END, quantityflag = CASE WHEN id = 77645841 THEN 0 END WHERE user_id = 14409 AND id IN (77645841) 2025-08-10 19:00:05 [INFO]: QUANTITY Updated IDs: 77645841 2025-08-10 19:00:05 [INFO]: Successfully processed data for user 14409 2025-08-10 19:00:05 [INFO]: Execution Started 2025-08-10 19:00:05 [INFO]: Execution Finished 2025-08-10 19:10:01 [INFO]: Execution Started 2025-08-10 19:10:01 [INFO]: old server sucessfully connected 2025-08-10 19:10:01 [INFO]: sqs client sucess created 2025-08-10 19:10:02 [INFO]: Number of messages in the queue: 0 2025-08-10 19:10:22 [INFO]: Execution Started 2025-08-10 19:10:22 [INFO]: Execution Finished 2025-08-10 19:20:01 [INFO]: Execution Started 2025-08-10 19:20:01 [INFO]: old server sucessfully connected 2025-08-10 19:20:01 [INFO]: sqs client sucess created 2025-08-10 19:20:02 [INFO]: Number of messages in the queue: 1 2025-08-10 19:20:02 [INFO]: item found in queue is if condition 14409 2025-08-10 19:20:02 [INFO]: item found in queue is 14409 2025-08-10 19:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBW+RkLHh5lvfM9oC31MVX/vNz9G6t/ZpX7T9+3B5CLa+uLd0mYfeXLzdye0HkTpsGYRKQxymZyaVH9Ly6bfqUwYWNcU49oW2fuoQli7pUt5UMh1NVk5TONcXC5VaGdXPJa9SI31HBexzZMl2vDDWuzvivwXit5KstZF0iNIJl57HlBIauoMYeBrHhzRHdWpFyCf7OuCwle9c/4curh7k4e0DseW+mY2KUAlRFrtj5n3Betoc3ZsXS8JKudNX5WMENMu0tH6jU29Qv6a8lRxoyztIHVJXS3QJUQ6OgtYa2RQoIH16bz5kveBHfCi/ROCWJyyO3nrvsO9iKz6svswxQD9GA1OOvaTUr7r+BOHvGQeHBUFDPMW5ZUU3lP2vlSykWlfu3wLetekhq1TzgNqUfeo4IBUVXYiWEF2XwUO9NqWkHJWTaXWhpGn7qPXVCkkKp 2025-08-10 19:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-10 19:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-10 19:20:03 [INFO]: inside itemsold and closed 14409 2025-08-10 19:20:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-10 19:20:04 [INFO]: autolink for user_id 14409 is 1 2025-08-10 19:20:04 [INFO]: Ebay item id :: 285808597137 exists in Database 2025-08-10 19:20:04 [INFO]: Item is reliested :: exists in Database 2025-08-10 19:20:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-10 19:20:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-10 19:20:04 [INFO]: in processold action queue is array for {"44567284":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44567284","ebayitemid":"285808597137","shopifyproductid":"8390858637534","variants":[{"price":"55.99","quantity":0,"weight":"3","shopifyproductid":"8390858637534","shopifyvariantid":"45129409495262","shopifyinventoryid":"47227273740510","shopifylocationid":"","product_id":"44567284","variant_id":"77459964","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-10 19:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-10 19:20:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-10 19:20:05 [INFO]: Shopify Inventory id 47227273740510 2025-08-10 19:20:05 [INFO]: Shopify Location id 58450641063 2025-08-10 19:20:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-10 19:20:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-10T19: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-10 19:20:05 [INFO]: Change: available | Delta: -1 2025-08-10 19:20:05 [INFO]: Change: on_hand | Delta: -1 2025-08-10 19:20:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-10 19:20:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44567284 and user_id = 14409 2025-08-10 19:20:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77459964 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-10 19:20:05 [INFO]: updateIdsQuantity -> ["77459964"] 2025-08-10 19:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-10 19:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77459964 THEN 0 END, quantityflag = CASE WHEN id = 77459964 THEN 0 END WHERE user_id = 14409 AND id IN (77459964) 2025-08-10 19:20:05 [INFO]: QUANTITY Updated IDs: 77459964 2025-08-10 19:20:05 [INFO]: Successfully processed data for user 14409 2025-08-10 19:20:05 [INFO]: Execution Started 2025-08-10 19:20:05 [INFO]: Execution Finished 2025-08-10 19:30:01 [INFO]: Execution Started 2025-08-10 19:30:01 [INFO]: old server sucessfully connected 2025-08-10 19:30:01 [INFO]: sqs client sucess created 2025-08-10 19:30:02 [INFO]: Number of messages in the queue: 0 2025-08-10 19:30:22 [INFO]: Execution Started 2025-08-10 19:30:22 [INFO]: Execution Finished 2025-08-10 19:40:01 [INFO]: Execution Started 2025-08-10 19:40:01 [INFO]: old server sucessfully connected 2025-08-10 19:40:01 [INFO]: sqs client sucess created 2025-08-10 19:40:02 [INFO]: Number of messages in the queue: 1 2025-08-10 19:40:03 [INFO]: item found in queue is if condition 14409 2025-08-10 19:40:03 [INFO]: item found in queue is 14409 2025-08-10 19:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBPFgnFJtd5dgKFofVrb0ypx4AnjtdoVmZ4cbpE2rzJnDR14qlveqX9sOyMsGd2OH0xw1VQTqiHQ1mGrhrfHrMU0gs511Z7SwwydaJkvrzWRUisvENuXiJbPVMjl8D6+xpQCvv8mc6+EKzqfIr3RaoZlzi47jyqPH+POa57e93ikftNU6NXpmuIwNu/cNah9Fq42ebOQTIV2rv0RonM8rwknIx8cidrIMPymtsbuTg1D/2mwr9XVkXauNfUgSWuBu89fYinsRtwWvXHbvtUt54fr45+Nb1m/yZ8/7gPnXgrmPUaGEvaXzfk9WOm9BXNM0U0tq5vnF4wMEwS1ZAK3hwQjnUN3xIwJQxTxdf9GBZX8CHpEJ0s/av9vv7fgILVOyfca35Gy7L5fPSVy67KMZoyKgwlRMU86qOPt5VPtBjrccF/SJxGec3QcvG3geOv/Vj 2025-08-10 19:40:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-10 19:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-10 19:40:03 [INFO]: inside itemsold and closed 14409 2025-08-10 19:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-10 19:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-10 19:40:05 [INFO]: Ebay item id :: 326368881576 exists in Database 2025-08-10 19:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-10 19:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-10 19:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-10 19:40:05 [INFO]: in processold action queue is array for {"44736374":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44736374","ebayitemid":"326368881576","shopifyproductid":"8100542906590","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8100542906590","shopifyvariantid":"44292644536542","shopifyinventoryid":"46389883928798","shopifylocationid":"","product_id":"44736374","variant_id":"77644311","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-10 19:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-10 19:40:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-10 19:40:05 [INFO]: Shopify Inventory id 46389883928798 2025-08-10 19:40:05 [INFO]: Shopify Location id 58450641063 2025-08-10 19:40:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-10 19:40:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-10T19:40: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-10 19:40:05 [INFO]: Change: available | Delta: -1 2025-08-10 19:40:05 [INFO]: Change: on_hand | Delta: -1 2025-08-10 19:40:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-10 19:40:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44736374 and user_id = 14409 2025-08-10 19:40:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77644311 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-10 19:40:05 [INFO]: updateIdsQuantity -> ["77644311"] 2025-08-10 19:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-10 19:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77644311 THEN 0 END, quantityflag = CASE WHEN id = 77644311 THEN 0 END WHERE user_id = 14409 AND id IN (77644311) 2025-08-10 19:40:05 [INFO]: QUANTITY Updated IDs: 77644311 2025-08-10 19:40:05 [INFO]: Successfully processed data for user 14409 2025-08-10 19:40:05 [INFO]: Execution Started 2025-08-10 19:40:05 [INFO]: Execution Finished 2025-08-10 19:50:01 [INFO]: Execution Started 2025-08-10 19:50:01 [INFO]: old server sucessfully connected 2025-08-10 19:50:01 [INFO]: sqs client sucess created 2025-08-10 19:50:02 [INFO]: Number of messages in the queue: 1 2025-08-10 19:50:03 [INFO]: item found in queue is if condition 14409 2025-08-10 19:50:03 [INFO]: item found in queue is 14409 2025-08-10 19:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBUTtDCarSDnwSihzSziIXXUDqkR2t9cL6DuWisJiddST5v0aKvjL6AkzgZcxTDT35pWXVYGn762Ak434ge9Emq5Oh5a98rxkyUl1xb8LUm6AKLvsY7Cqo1Negm1NKJxCg5xeQfc0Ba+Rw32jEBbG/x4YNZpQZfLtrmKPZx5ztQkBY+OrCRfefmf4tAGB/8P4gG8z8oPRLghMP+H6rENYeWFNP+g8CaKcRkx7t14j1zL7yi3p/s+MnWXInKxtRMXAsgQL09bzlkP7Vylp9nYFCFvB4ekgmEVEGYTftwFIEF0vvhfJJ87W28De3SDn8MZIYUG3KNeOKnexOIAAVCeaWMit/y3D8FSTD9uUbfD7azXpKxCY5rNaiN6uhEp2DbUIobccDZrSc+ukJZ958vHkOSA/svtoVg43onZMJ2tz7oUKI6jNCwxwA9yK3otYJmPGb 2025-08-10 19:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-10 19:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-10 19:50:03 [INFO]: inside itemsold and closed 14409 2025-08-10 19:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-10 19:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-10 19:50:05 [INFO]: Ebay item id :: 333260950426 exists in Database 2025-08-10 19:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-10 19:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-10 19:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-10 19:50:05 [INFO]: in processold action queue is array for {"44563466":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44563466","ebayitemid":"333260950426","shopifyproductid":"6821601804455","variants":[{"price":"9.95","quantity":0,"weight":"0.5","shopifyproductid":"6821601804455","shopifyvariantid":"40294770081959","shopifyinventoryid":"42390102048935","shopifylocationid":"","product_id":"44563466","variant_id":"77456146","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-10 19:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-10 19:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-10 19:50:05 [INFO]: Shopify Inventory id 42390102048935 2025-08-10 19:50:05 [INFO]: Shopify Location id 58450641063 2025-08-10 19:50:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-10 19:50: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-10 19:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-10 19:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44563466 and user_id = 14409 2025-08-10 19:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77456146 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-10 19:50:05 [INFO]: updateIdsQuantity -> ["77456146"] 2025-08-10 19:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-10 19:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77456146 THEN 0 END, quantityflag = CASE WHEN id = 77456146 THEN 0 END WHERE user_id = 14409 AND id IN (77456146) 2025-08-10 19:50:05 [INFO]: QUANTITY Updated IDs: 77456146 2025-08-10 19:50:05 [INFO]: Successfully processed data for user 14409 2025-08-10 19:50:05 [INFO]: Execution Started 2025-08-10 19:50:05 [INFO]: Execution Finished