2025-07-31 22:00:01 [INFO]: Execution Started 2025-07-31 22:00:01 [INFO]: old server sucessfully connected 2025-07-31 22:00:01 [INFO]: sqs client sucess created 2025-07-31 22:00:02 [INFO]: Number of messages in the queue: 1 2025-07-31 22:00:02 [INFO]: item found in queue is if condition 14409 2025-07-31 22:00:02 [INFO]: item found in queue is 14409 2025-07-31 22:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBhCr9oSuiECnauBK50CaVw/hmau/7cpiHfSp7FocN8sWID5EdjX4imUKt2w9Tkxv3AfozOqeRck8J5oFb3UwfNcSIGClVZDwy65ibeAoc4syNIATDOkvctoNPHmtkknheylsBcwJbhqMeMMPX9ic3wU1Yo5IpTU+/nTV+iEpzH6PVgSn14r6060F1qVh1rMhObEUVQI7Rgh/uq7EYz4UCJQWkNrtlVbqRhxfPnVqsmhOjwX6dZBjnHH8FFR+jK9XyCw+t3o27g5ntwuZHyStcMKOzIINEwIWP5TJr9+Gbw+gH69tQ5h7XBx069TFMtvzrOaaDZiuKH0XZm06nmLhzlseuIdhJWPDcUNGdkFuGrknl0mjA2MDr/yk9KJC8Bcq4SPgb0h5hCeF5KbwIHW54nMFxhwieOki07FHbfpggaVJpqqBX+ubgn8SPRmWorrGc 2025-07-31 22:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-07-31 22:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 22:00:03 [INFO]: inside itemsold and closed 14409 2025-07-31 22:00:04 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 22:00:04 [INFO]: autolink for user_id 14409 is 1 2025-07-31 22:00:04 [INFO]: Ebay item id :: 335353822818 exists in Database 2025-07-31 22:00:04 [INFO]: Item is reliested :: exists in Database 2025-07-31 22:00:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 22:00:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 22:00:04 [INFO]: in processold action queue is array for {"44577749":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44577749","ebayitemid":"335353822818","shopifyproductid":"8409608290526","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"8409608290526","shopifyvariantid":"45205190475998","shopifyinventoryid":"47303100924126","shopifylocationid":"","product_id":"44577749","variant_id":"77470456","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 22:00:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 22:00:04 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 22:00:04 [INFO]: Shopify Inventory id 47303100924126 2025-07-31 22:00:04 [INFO]: Shopify Location id 58450641063 2025-07-31 22:00:04 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 22:00:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T22: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-07-31 22:00:05 [INFO]: Change: available | Delta: -1 2025-07-31 22:00:05 [INFO]: Change: on_hand | Delta: -1 2025-07-31 22:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 22:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44577749 and user_id = 14409 2025-07-31 22:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77470456 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 22:00:05 [INFO]: updateIdsQuantity -> ["77470456"] 2025-07-31 22:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-07-31 22:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77470456 THEN 0 END, quantityflag = CASE WHEN id = 77470456 THEN 0 END WHERE user_id = 14409 AND id IN (77470456) 2025-07-31 22:00:05 [INFO]: QUANTITY Updated IDs: 77470456 2025-07-31 22:00:05 [INFO]: Successfully processed data for user 14409 2025-07-31 22:00:05 [INFO]: Execution Started 2025-07-31 22:00:05 [INFO]: Execution Finished 2025-07-31 22:10:01 [INFO]: Execution Started 2025-07-31 22:10:01 [INFO]: old server sucessfully connected 2025-07-31 22:10:01 [INFO]: sqs client sucess created 2025-07-31 22:10:02 [INFO]: Number of messages in the queue: 1 2025-07-31 22:10:02 [INFO]: item found in queue is if condition 14409 2025-07-31 22:10:02 [INFO]: item found in queue is 14409 2025-07-31 22:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEB/Lg7xNthuEhOXTebn3bh0jqusSehzKSpKMliDBddwMgGix/CUNNvznQ8RHLjXOsaoZF1cBvItwZEHDLy9NRh/1uzZONJwGMuM91XqJswibcvkHSdyMhw/05+E8N7PH2WaBcipGe3R+/U+3ImvY2n0PH30wdkJrR3wLieE+E5luuGIm9IvzXx9UqCgV3l6cyP8snAmGqdl0lkqEO6C6Jrv3bPrl0Iai89GLmDLgIjlbLAIg4APaxWVZSUo+DvLyrru+v3bpS5WFkG/fKhYsZJ5UvAeb/tPVLZ0PSnesaWSI0HqGfqcuRJb8cTwmFD4KwDPPgxTWFK4bcXsaJTRqXVuV8pIAgvCzlloYTqxuaHrZBSOUpDbzEz3kql4ImL1Q5M69nfNaoho9iud8omdF6oqV4SIslaLFa5O4dZYxXPS8N8UYUxQCGmjo4hGfggd0a/ 2025-07-31 22:10:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-07-31 22:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 22:10:03 [INFO]: inside itemsold and closed 14409 2025-07-31 22:10:04 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 22:10:04 [INFO]: autolink for user_id 14409 is 1 2025-07-31 22:10:04 [INFO]: Ebay item id :: 326656917681 exists in Database 2025-07-31 22:10:04 [INFO]: Item is reliested :: exists in Database 2025-07-31 22:10:04 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-07-31 22:10:04 [INFO]: in processold action queue is array for {"45158159":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45158159","ebayitemid":"326656917681","deleted":1}}} 2025-07-31 22:10:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 22:10:04 [INFO]: productIds WHich are having null productid -> [45158159] 2025-07-31 22:10:04 [INFO]: ebayItemIds WHich are not imported-> ["326656917681"] 2025-07-31 22:10:04 [INFO]: Entered in bulkUpdateProducts function 2025-07-31 22:10:04 [INFO]: Transaction started for bulkUpdateProducts 2025-07-31 22:10:04 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45158159) 2025-07-31 22:10:04 [INFO]: Query executed successfully. Affected rows: 0 2025-07-31 22:10:04 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-07-31 22:10:04 [INFO]: Transaction committed successfully. 2025-07-31 22:10:04 [INFO]: Transaction ended for bulkUpdateProducts 2025-07-31 22:10:04 [INFO]: Successfully processed data for user 14409 2025-07-31 22:10:04 [INFO]: Execution Started 2025-07-31 22:10:04 [INFO]: Execution Finished 2025-07-31 22:20:01 [INFO]: Execution Started 2025-07-31 22:20:01 [INFO]: old server sucessfully connected 2025-07-31 22:20:01 [INFO]: sqs client sucess created 2025-07-31 22:20:02 [INFO]: Number of messages in the queue: 1 2025-07-31 22:20:02 [INFO]: item found in queue is if condition 14409 2025-07-31 22:20:02 [INFO]: item found in queue is 14409 2025-07-31 22:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBj6nhd1tFVQJcxlOP9ZgTf7JBEIKdVBH65SZVlkbY1R6ccbONy/6Jz7Z8gHyzdLhXcyumng8E1VfqoeKCyUkUMJ6PVG2awBhAEqfYddtWYNqrfPgm18QBEUvJIcYr/a5nDOU+yftb+dSN/fHsDv1PLlL6VaJ7RJe6WgfLCRDI0iLYvdG9KQnU5S6/WJYEjWNFPyLpufSURwTyYH+Gbc5vhtA8rYLMWWQduTZ/adxPGZwTfQhmKxRRdzAufLMCyu+mJvilpim1IAPoy6iUpI8Ww0MO+ZY+H2TDUocG18iUXaWbEqf/44Q6zcSmOfSZdHv/z/PvKAiSx6bFoCpbwD9hEKz+12g4JYZ0PnRWUVlAdRBl5WLTzQALeGJqsLdgQV9Y6jo8YTSMPDXJYFMDt/kiQgQYfBlbtVOlHUDtpPHMYA0derG5iK7qXERz4fWJX6V0 2025-07-31 22:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-07-31 22:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 22:20:03 [INFO]: inside itemsold and closed 14409 2025-07-31 22:20:04 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 22:20:04 [INFO]: autolink for user_id 14409 is 1 2025-07-31 22:20:04 [INFO]: Ebay item id :: 405371345505 exists in Database 2025-07-31 22:20:04 [INFO]: Item is reliested :: exists in Database 2025-07-31 22:20:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 22:20:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 22:20:04 [INFO]: in processold action queue is array for {"44665664":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44665664","ebayitemid":"405371345505","shopifyproductid":"8742915539166","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8742915539166","shopifyvariantid":"46088291287262","shopifyinventoryid":"48187078115550","shopifylocationid":"","product_id":"44665664","variant_id":"77570883","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 22:20:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 22:20:04 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 22:20:04 [INFO]: Shopify Inventory id 48187078115550 2025-07-31 22:20:04 [INFO]: Shopify Location id 58450641063 2025-07-31 22:20:04 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 22:20:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T22: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-07-31 22:20:05 [INFO]: Change: available | Delta: -1 2025-07-31 22:20:05 [INFO]: Change: on_hand | Delta: -1 2025-07-31 22:20:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 22:20:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44665664 and user_id = 14409 2025-07-31 22:20:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77570883 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 22:20:05 [INFO]: updateIdsQuantity -> ["77570883"] 2025-07-31 22:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-07-31 22:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77570883 THEN 0 END, quantityflag = CASE WHEN id = 77570883 THEN 0 END WHERE user_id = 14409 AND id IN (77570883) 2025-07-31 22:20:05 [INFO]: QUANTITY Updated IDs: 77570883 2025-07-31 22:20:05 [INFO]: Successfully processed data for user 14409 2025-07-31 22:20:05 [INFO]: Execution Started 2025-07-31 22:20:05 [INFO]: Execution Finished 2025-07-31 22:30:02 [INFO]: Execution Started 2025-07-31 22:30:02 [INFO]: old server sucessfully connected 2025-07-31 22:30:02 [INFO]: sqs client sucess created 2025-07-31 22:30:03 [INFO]: Number of messages in the queue: 2 2025-07-31 22:30:03 [INFO]: item found in queue is if condition 14409 2025-07-31 22:30:03 [INFO]: item found in queue is 14409 2025-07-31 22:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBV0uC9ckldIAaRtYjLrLmSV82RyDecZh3vloUF5DztZzV0ZZgvtGxDhC6aQpLb7wcy9ZaAgxp8H2ULlkztzROCYhrmua6yBICjgF28lbiySe21HYKZy6sUqU8Aj3BJ+iMQaKWyFeRxQVM/qiiIDjujd5mMoiGw4JyZSmMPHq8ctS0xzAborUEnIMRMjAMah+fCrWRgcCS+LsTcFv6dZdH1TdZUcMiQndkmNsA6TVIQSYaX/9ucJElFo6fjvt7ANty/9/LpRkERiYAu4rIwn0cEgOhLf95s26BdkIFDW93SA9qQUl4psn3nhIkxYCRRi0kmW9pbRlhHtfzCDrLUOBepJkQ887Rt+kes6K0i3h3XFxpkO0dZ65HktZb3OlPtWYxzNonunqBLhDe6HlWVupqzb+VkP4OzlS6KQjGsc+ttMoSn7tcIOIA/poYnXPk7IMa 2025-07-31 22:30:03 [INFO]: item found in queue is if condition 14409 2025-07-31 22:30:03 [INFO]: item found in queue is 14409 2025-07-31 22:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBgI2PuRVbCnweGmdkOXnkoV66W2/heXJcRX5EB9QRoD8DyRSTmYf2wnd31oBArI06mzJH44luLIRQFvBps2NVCNUt11lJ9LksqWeL4njVPRplhthOL1qYOI179UOsQR+rreBRzyUDe+wHCwIeO36G6rf3B7I9Cvz91z8r1X8m652IxLxt+JFHFxsXoEYCJgH9IUYn0JLYIKDqzhKo/XkF1Cm5Ibm4cfFzB4SQfkY2QZQtFFeGb+FdLl1FIHPM8JstPRPr6WD6YBbGS84M8MPMXCC1YiewDg7D1r5xkklPlDe/jeJogQ6HILdyBGVz831bK/e28ZQ+xYRUyZ6pdtyGPq8qtv0C9gyoQWA81qB/2m4MRyyC8OVBmCJn9ZojIV2vFomrlMD+du+gdFhMC8QMzxKKgN7TP2czTtA3lGNIVhy8WrWLtwlBaKkH5Iw1lFuD 2025-07-31 22:30:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-07-31 22:30:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 22:30:04 [INFO]: inside itemsold and closed 14409 2025-07-31 22:30:06 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 22:30:06 [INFO]: autolink for user_id 14409 is 1 2025-07-31 22:30:06 [INFO]: Ebay item id :: 226190449864 exists in Database 2025-07-31 22:30:06 [INFO]: Item is reliested :: exists in Database 2025-07-31 22:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 22:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 22:30:06 [INFO]: inside itemsold and closed 14409 2025-07-31 22:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 22:30:07 [INFO]: autolink for user_id 14409 is 1 2025-07-31 22:30:07 [INFO]: Ebay item id :: 405881729737 exists in Database 2025-07-31 22:30:07 [INFO]: Item is reliested :: exists in Database 2025-07-31 22:30:07 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-07-31 22:30:07 [INFO]: in processold action queue is array for {"44735132":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44735132","ebayitemid":"226190449864","shopifyproductid":"8703284707550","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8703284707550","shopifyvariantid":"45954169831646","shopifyinventoryid":"48052772307166","shopifylocationid":"","product_id":"44735132","variant_id":"77643039","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45149239":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45149239","ebayitemid":"405881729737","deleted":1}}} 2025-07-31 22:30:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 22:30:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 22:30:07 [INFO]: productIds WHich are having null productid -> [45149239] 2025-07-31 22:30:07 [INFO]: ebayItemIds WHich are not imported-> ["405881729737"] 2025-07-31 22:30:07 [INFO]: Entered in bulkUpdateProducts function 2025-07-31 22:30:07 [INFO]: Transaction started for bulkUpdateProducts 2025-07-31 22:30:07 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45149239) 2025-07-31 22:30:07 [INFO]: Query executed successfully. Affected rows: 0 2025-07-31 22:30:07 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-07-31 22:30:07 [INFO]: Transaction committed successfully. 2025-07-31 22:30:07 [INFO]: Transaction ended for bulkUpdateProducts 2025-07-31 22:30:07 [INFO]: Shopify Inventory id 48052772307166 2025-07-31 22:30:07 [INFO]: Shopify Location id 58450641063 2025-07-31 22:30:07 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 22:30:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T22:30:08Z","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-07-31 22:30:08 [INFO]: Change: available | Delta: 1 2025-07-31 22:30:08 [INFO]: Change: on_hand | Delta: 1 2025-07-31 22:30:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 22:30:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44735132 and user_id = 14409 2025-07-31 22:30:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77643039 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 22:30:08 [INFO]: updateIdsQuantity -> ["77643039"] 2025-07-31 22:30:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-07-31 22:30:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77643039 THEN 0 END, quantityflag = CASE WHEN id = 77643039 THEN 0 END WHERE user_id = 14409 AND id IN (77643039) 2025-07-31 22:30:08 [INFO]: QUANTITY Updated IDs: 77643039 2025-07-31 22:30:08 [INFO]: Successfully processed data for user 14409 2025-07-31 22:30:08 [INFO]: Execution Started 2025-07-31 22:30:08 [INFO]: Execution Finished 2025-07-31 22:40:02 [INFO]: Execution Started 2025-07-31 22:40:02 [INFO]: old server sucessfully connected 2025-07-31 22:40:02 [INFO]: sqs client sucess created 2025-07-31 22:40:03 [INFO]: Number of messages in the queue: 0 2025-07-31 22:40:23 [INFO]: Execution Started 2025-07-31 22:40:23 [INFO]: Execution Finished 2025-07-31 22:50:02 [INFO]: Execution Started 2025-07-31 22:50:02 [INFO]: old server sucessfully connected 2025-07-31 22:50:02 [INFO]: sqs client sucess created 2025-07-31 22:50:03 [INFO]: Number of messages in the queue: 0 2025-07-31 22:50:23 [INFO]: Execution Started 2025-07-31 22:50:23 [INFO]: Execution Finished