2025-08-06 16:00:02 [INFO]: Execution Started 2025-08-06 16:00:02 [INFO]: old server sucessfully connected 2025-08-06 16:00:02 [INFO]: sqs client sucess created 2025-08-06 16:00:07 [INFO]: Number of messages in the queue: 1 2025-08-06 16:00:09 [INFO]: item found in queue is if condition 14409 2025-08-06 16:00:09 [INFO]: item found in queue is 14409 2025-08-06 16:00:10 [INFO]: Message deleted from the queue for receipt handle: AQEBjoBM7yfjtqzUPM+5itt0CHIqscZatLbHM42s440M9Gqgym9bv1drhXtEmn5AgCZkyVMkISjreZbZ1ZzegJMqxKnkTHNXYlTMm4WlSxEjUOqJrFYwp4A2XXSdVmn+7a13uS9CDgBvQtuv+nt4BEl/lH2TbU0iRDpmDUpTeWSCjSajQAomr9bKU8XC9ZppsU89F/I79dxFQd4d5bodIMVGG1jJ+v0zFFxurxq5w8Txe0MxP32pXen9ITtvg7Z6jomIkCW4/+i969mmGqcN+tgshWnyYhz9UWoxm70T64ESrLOaeE7mtnoZkD8+l60qHeiAwL/+qWUvWsmvqY49snhDSvx9HmuPvlNUCPMGEAW8gQ9HkHZIJySNbAvjw2SIsHuQnWSg5kjj1WwvBuyb83flCRa8zVMG0gyQB5WJGlVOhPR59Ris7Dr8CI6UMWaa1u1n 2025-08-06 16:00:10 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-06 16:00:10 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-06 16:00:10 [INFO]: inside itemsold and closed 14409 2025-08-06 16:00:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 16:00:11 [INFO]: autolink for user_id 14409 is 1 2025-08-06 16:00:11 [INFO]: Ebay item id :: 326696611859 exists in Database 2025-08-06 16:00:11 [INFO]: Item is reliested :: exists in Database 2025-08-06 16:00:11 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-06 16:00:11 [INFO]: in processold action queue is array for {"45272970":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45272970","ebayitemid":"326696611859","deleted":1}}} 2025-08-06 16:00:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-06 16:00:11 [INFO]: productIds WHich are having null productid -> [45272970] 2025-08-06 16:00:11 [INFO]: ebayItemIds WHich are not imported-> ["326696611859"] 2025-08-06 16:00:11 [INFO]: Entered in bulkUpdateProducts function 2025-08-06 16:00:11 [INFO]: Transaction started for bulkUpdateProducts 2025-08-06 16:00:11 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45272970) 2025-08-06 16:00:11 [INFO]: Query executed successfully. Affected rows: 0 2025-08-06 16:00:11 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-06 16:00:11 [INFO]: Transaction committed successfully. 2025-08-06 16:00:11 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-06 16:00:11 [INFO]: Successfully processed data for user 14409 2025-08-06 16:00:11 [INFO]: Execution Started 2025-08-06 16:00:11 [INFO]: Execution Finished 2025-08-06 16:10:01 [INFO]: Execution Started 2025-08-06 16:10:01 [INFO]: old server sucessfully connected 2025-08-06 16:10:01 [INFO]: sqs client sucess created 2025-08-06 16:10:04 [INFO]: Number of messages in the queue: 1 2025-08-06 16:10:04 [INFO]: item found in queue is if condition 14409 2025-08-06 16:10:04 [INFO]: item found in queue is 14409 2025-08-06 16:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBMbC5kOSopdofrCZRXcKEVjepzePNYY2DKjmFWVZsbdL5mm/LB4dKmn44KWxvjX0ralIRNyXESVmeYfDq0Mtb245eoF5XM209UPPvA5ogn3vcWLQvKqButV6dV3uazn+K/Jia7O0Drbj09Cq5AaQLUn8q05kKBWdz4AcfdFXpXp3PRKGGg3uN/7ZJG6KkfDay2+TrebEN0Nw+SoaB5togttdN1OcxzN5Xauc8zhbj4KkpISwVLeh7wshs370Hws4j/6ECxyPk2FSHBFlSKZYegCE4SrXIefLDhh4trJsJC+OVNEDRbckTjaAk4eHmjlzYdlJ4ZpSsb8507EGi2xHYcI3Ess064+3PvY9J1qouIygyhSBGpanGVTS3YspDqu8T9Hx1lWchsllb34XL/NkkZF3/n9BrONUWhH0rglT63GbE8VseK2kM5n1g04RUZJy+ 2025-08-06 16:10:05 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-06 16:10:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-06 16:10:05 [INFO]: inside itemsold and closed 14409 2025-08-06 16:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 16:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-06 16:10:07 [INFO]: Ebay item id :: 326202187837 exists in Database 2025-08-06 16:10:07 [INFO]: Item is reliested :: exists in Database 2025-08-06 16:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-06 16:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-06 16:10:07 [INFO]: in processold action queue is array for {"44653135":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44653135","ebayitemid":"326202187837","shopifyproductid":"8699153055966","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8699153055966","shopifyvariantid":"45943376511198","shopifyinventoryid":"48041867509982","shopifylocationid":"","product_id":"44653135","variant_id":"77558324","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-06 16:10:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-06 16:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-06 16:10:07 [INFO]: Shopify Inventory id 48041867509982 2025-08-06 16:10:07 [INFO]: Shopify Location id 58450641063 2025-08-06 16:10:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-06 16:10:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T16:10:07Z","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-06 16:10:07 [INFO]: Change: available | Delta: -1 2025-08-06 16:10:07 [INFO]: Change: on_hand | Delta: -1 2025-08-06 16:10:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-06 16:10:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44653135 and user_id = 14409 2025-08-06 16:10:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77558324 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-06 16:10:07 [INFO]: updateIdsQuantity -> ["77558324"] 2025-08-06 16:10:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-06 16:10:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77558324 THEN 0 END, quantityflag = CASE WHEN id = 77558324 THEN 0 END WHERE user_id = 14409 AND id IN (77558324) 2025-08-06 16:10:07 [INFO]: QUANTITY Updated IDs: 77558324 2025-08-06 16:10:07 [INFO]: Successfully processed data for user 14409 2025-08-06 16:10:07 [INFO]: Execution Started 2025-08-06 16:10:07 [INFO]: Execution Finished 2025-08-06 16:20:01 [INFO]: Execution Started 2025-08-06 16:20:01 [INFO]: old server sucessfully connected 2025-08-06 16:20:01 [INFO]: sqs client sucess created 2025-08-06 16:20:04 [INFO]: Number of messages in the queue: 2 2025-08-06 16:20:12 [INFO]: item found in queue is if condition 14409 2025-08-06 16:20:12 [INFO]: item found in queue is 14409 2025-08-06 16:20:12 [INFO]: Message deleted from the queue for receipt handle: AQEBzj5N6bQ+J1wuseE0sHFqnUwW/oMFlzaUGqaGUFufaXK1TbDb1hozuKWP8b340qzaTh9x7F235YUdPfapc4e0th6gOn+0rNNrFqGJ7zOqofrIH31odltHRaE7Jl1UcjxTeorhf8QHviNLC9JnTiTAf2zvomktU4VNz2TsSKmlWOYCBlJ31G/1EGnIzfwqlFOW3VMveItIwEA8lu61Up/EldGktAQh1hcOdvhFuLJJNU+vA/xqDda3KkXs3mZnjeo9OU+D0Gds+wtzIPbrzhCMBBy2a5aIpyh6lg3ekQ3YOY59sfwtkluQ0Nw1RbBKs/2ixRiufRIfd0jy69nPoGks1bDU2fW6sMgOpOGEM2H1AP3T134taIqk5EsYCGRRNyjJfOwUf2sDXOmFgip1OtFzfhETvd2N9pFiZEqaECh2rw/Z/7obU0kPfLZgeALFKKTi 2025-08-06 16:20:14 [INFO]: item found in queue is if condition 14409 2025-08-06 16:20:14 [INFO]: item found in queue is 14409 2025-08-06 16:20:14 [INFO]: Message deleted from the queue for receipt handle: AQEBlK9k3olZjU6YBfqxsCE/yl/oPTyMihqSsczh6avK1TZCjYN455abCN0NnYmiVTwpi8jhUzeUTELtqQDWL14A/z0+2R5OZnxQgeQvPIGKQUZXtD49P+Gdi4Hll0zhwTG9cvDsno84B0I3/QaT6CGvkHoB//o9LCgPeSovq11gNaTIumsSKBcQ2wUQrimP2/1IeEvXHS34AKwA7QTfoHu8eVoeEd1j/7ebx3J2HlvdGa2uPyFr41JsTNQJ9Kid43/eYIxDKo8rfAeDYMRb7OaLfhZa8emW7pIBM36AC2AhANHWWPKvcwsK6bW1xL/UW+qBuKwR6FP18qowMYMJCyhPSyjWjtpQuoI0ELwHa22sR5HL85pDJgL79kVEzP3QTGh0pGxYzTaCaEz+08SBkDeozZhkTSpBuLOguJlKz9E1tStq7z/EjrCBZMKlbyq9vT0X 2025-08-06 16:20:14 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-06 16:20:14 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-06 16:20:14 [INFO]: inside itemsold and closed 14409 2025-08-06 16:20:16 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 16:20:16 [INFO]: autolink for user_id 14409 is 1 2025-08-06 16:20:16 [INFO]: Ebay item id :: 286398273706 exists in Database 2025-08-06 16:20:16 [INFO]: Item is reliested :: exists in Database 2025-08-06 16:20:16 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-06 16:20:16 [INFO]: inside itemsold and closed 14409 2025-08-06 16:20:18 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 16:20:18 [INFO]: autolink for user_id 14409 is 1 2025-08-06 16:20:18 [INFO]: Ebay item id :: 256851251883 exists in Database 2025-08-06 16:20:18 [INFO]: Item is reliested :: exists in Database 2025-08-06 16:20:18 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-06 16:20:18 [INFO]: in processold action queue is array for {"44873198":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"44873198","ebayitemid":"286398273706","deleted":1}},"44873197":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"44873197","ebayitemid":"256851251883","deleted":1}}} 2025-08-06 16:20:18 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-06 16:20:18 [INFO]: productIds WHich are having null productid -> [44873198,44873197] 2025-08-06 16:20:18 [INFO]: ebayItemIds WHich are not imported-> ["286398273706","256851251883"] 2025-08-06 16:20:18 [INFO]: Entered in bulkUpdateProducts function 2025-08-06 16:20:18 [INFO]: Transaction started for bulkUpdateProducts 2025-08-06 16:20:18 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (44873198,44873197) 2025-08-06 16:20:18 [INFO]: Query executed successfully. Affected rows: 0 2025-08-06 16:20:18 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-06 16:20:18 [INFO]: Transaction committed successfully. 2025-08-06 16:20:18 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-06 16:20:18 [INFO]: Successfully processed data for user 14409 2025-08-06 16:20:18 [INFO]: Execution Started 2025-08-06 16:20:18 [INFO]: Execution Finished 2025-08-06 16:30:01 [INFO]: Execution Started 2025-08-06 16:30:01 [INFO]: old server sucessfully connected 2025-08-06 16:30:01 [INFO]: sqs client sucess created 2025-08-06 16:30:05 [INFO]: Number of messages in the queue: 0 2025-08-06 16:30:25 [INFO]: Execution Started 2025-08-06 16:30:25 [INFO]: Execution Finished 2025-08-06 16:40:01 [INFO]: Execution Started 2025-08-06 16:40:01 [INFO]: old server sucessfully connected 2025-08-06 16:40:01 [INFO]: sqs client sucess created 2025-08-06 16:40:02 [INFO]: Number of messages in the queue: 1 2025-08-06 16:40:03 [INFO]: item found in queue is if condition 14409 2025-08-06 16:40:03 [INFO]: item found in queue is 14409 2025-08-06 16:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEB/PpPjCzClULi26CXGouao5uy1Ib8e1II6UN7KmC8cG4hXLP8Q12rW3WFeoxekKMmNJyBFvtOJbaQqEZe0z1Y9LWA82F0lcOVAk0xtWWdD4qTMcFmUnsf6MZLrw8NZw5MBOVY0eOJt1n9EJqt8lN6xpjAHj3+R2hQX44HubiqKAyENlaH0V6flbj39Tate0j4H6cH+ldGE+O8g6MgO9qeDx/zP3uolH1vK+7It+u6u7ayEr3yUSRzCrmZXC7lBySF/M+r6go0BpnU5VdYRuatIxxobdbweZsIncvlpd4kqUP4Tttyk83mjoZ/TwbULJVjeYSMnZeXlJbNZ7JRRDMhziKEF/xP5Rji7D2e9/jPIRFTW3xiVpK0AYnpLuCP4NbA8r0q0dTXPKV2l77W+GHQ7OHJYQ2HYygX/RGZiMZqZhpvkTYdtvpClF4BH7+R6SkG 2025-08-06 16:40:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-06 16:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-06 16:40:03 [INFO]: inside itemsold and closed 14409 2025-08-06 16:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 16:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-06 16:40:05 [INFO]: Ebay item id :: 226110898798 exists in Database 2025-08-06 16:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-06 16:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-06 16:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-06 16:40:05 [INFO]: in processold action queue is array for {"44673124":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44673124","ebayitemid":"226110898798","shopifyproductid":"8440773509342","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"8440773509342","shopifyvariantid":"45257764700382","shopifyinventoryid":"47355681341662","shopifylocationid":"","product_id":"44673124","variant_id":"77578344","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-06 16:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-06 16:40:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-06 16:40:05 [INFO]: Shopify Inventory id 47355681341662 2025-08-06 16:40:05 [INFO]: Shopify Location id 58450641063 2025-08-06 16:40:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-06 16:40:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T16: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-06 16:40:05 [INFO]: Change: available | Delta: -1 2025-08-06 16:40:05 [INFO]: Change: on_hand | Delta: -1 2025-08-06 16:40:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-06 16:40:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44673124 and user_id = 14409 2025-08-06 16:40:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77578344 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-06 16:40:05 [INFO]: updateIdsQuantity -> ["77578344"] 2025-08-06 16:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-06 16:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77578344 THEN 0 END, quantityflag = CASE WHEN id = 77578344 THEN 0 END WHERE user_id = 14409 AND id IN (77578344) 2025-08-06 16:40:05 [INFO]: QUANTITY Updated IDs: 77578344 2025-08-06 16:40:05 [INFO]: Successfully processed data for user 14409 2025-08-06 16:40:05 [INFO]: Execution Started 2025-08-06 16:40:05 [INFO]: Execution Finished 2025-08-06 16:50:01 [INFO]: Execution Started 2025-08-06 16:50:01 [INFO]: old server sucessfully connected 2025-08-06 16:50:01 [INFO]: sqs client sucess created 2025-08-06 16:50:03 [INFO]: Number of messages in the queue: 1 2025-08-06 16:50:04 [INFO]: item found in queue is if condition 14409 2025-08-06 16:50:04 [INFO]: item found in queue is 14409 2025-08-06 16:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBWe1WXJpRBbmEAGZ+aKfEKDJ/ROgtWIDc2xHynwzWGJnAB7AxmctfjE4mlwGV9MUK/DIN5rvdqmiRhtdbk88HwWoOZItPTRc2f9g/3fJkXovzP5MLBOW0MfUWSIEytAPbKFR1IMEGAjr3fLX1GcvJaBzxd6XpfI7ep4ytB9kw1Pk6AmifvHiV4p6sJiVmfoa2MNqpla/6qe0uTVW87XfwCbGgHZNWMHB8TPU1FAfhHYtIM2SxxmcyiLxkhG2b8NDD4I2McVznVzQ1FYClFQctNtfIXnR1GzXcQypxUtBA2Lo1JXlGC1Yfh5d6KG50DtPT0M0u1FGYxEBYYemyKIzaxvRno6TykrKNfOa5XdBg3uvq9N50z6pskfCsVb0oxm8o3sJzJyiVvefmmfZKIMLsxlNJlCyBXAGi5k4GJisomopQb7NoO2facnVzi9oZaMmx 2025-08-06 16:50:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-06 16:50:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-06 16:50:04 [INFO]: inside itemsold and closed 14409 2025-08-06 16:50:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 16:50:06 [INFO]: autolink for user_id 14409 is 1 2025-08-06 16:50:06 [INFO]: Ebay item id :: 286696069515 exists in Database 2025-08-06 16:50:06 [INFO]: Item is reliested :: exists in Database 2025-08-06 16:50:06 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-06 16:50:06 [INFO]: in processold action queue is array for {"45204667":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45204667","ebayitemid":"286696069515","deleted":1}}} 2025-08-06 16:50:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-06 16:50:06 [INFO]: productIds WHich are having null productid -> [45204667] 2025-08-06 16:50:06 [INFO]: ebayItemIds WHich are not imported-> ["286696069515"] 2025-08-06 16:50:06 [INFO]: Entered in bulkUpdateProducts function 2025-08-06 16:50:06 [INFO]: Transaction started for bulkUpdateProducts 2025-08-06 16:50:06 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45204667) 2025-08-06 16:50:06 [INFO]: Query executed successfully. Affected rows: 0 2025-08-06 16:50:06 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-06 16:50:06 [INFO]: Transaction committed successfully. 2025-08-06 16:50:06 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-06 16:50:06 [INFO]: Successfully processed data for user 14409 2025-08-06 16:50:06 [INFO]: Execution Started 2025-08-06 16:50:06 [INFO]: Execution Finished