2025-08-11 16:00:01 [INFO]: Execution Started 2025-08-11 16:00:01 [INFO]: old server sucessfully connected 2025-08-11 16:00:01 [INFO]: sqs client sucess created 2025-08-11 16:00:07 [INFO]: Number of messages in the queue: 0 2025-08-11 16:00:28 [INFO]: Execution Started 2025-08-11 16:00:28 [INFO]: Execution Finished 2025-08-11 16:10:01 [INFO]: Execution Started 2025-08-11 16:10:01 [INFO]: old server sucessfully connected 2025-08-11 16:10:01 [INFO]: sqs client sucess created 2025-08-11 16:10:04 [INFO]: Number of messages in the queue: 1 2025-08-11 16:10:05 [INFO]: item found in queue is if condition 14409 2025-08-11 16:10:05 [INFO]: item found in queue is 14409 2025-08-11 16:10:06 [INFO]: Message deleted from the queue for receipt handle: AQEBAdVNDe+TzYP58tIKcztzBmSltAEee04wMNIzD9dKPCvgZUbgPnO8nJ0DfE+GZ+SYRdsx+5IlU3DLs3i5nDH3KE1lQwg+b4Zi73Rk8veMLmm9n6iHrWMkw0GJSvnFr+gRZarTZgjIXlDhRcLlnfZx66eqMa6BeylgmVyMJ5m4gYq8KzYwQR7IdUzpVPCALu3YWMDL09WLVqI7uOynD+w+1oxVS+N/ps4n7dU0sCs7MlAvlxwbm2TtOnpPzOXBkUkNTlstTe4dtfOkWgynmFZeAcqje4ua9IWfdxr8zKps2ZkmOHNflN2AwAh20XzbFWSQIhNz287oVvC9mBzAjOeY1qH5+QMDnwVsjr6Dc05I57XSguTPX9dN6EqDxkWrH4oKzr5MoqqfQETjSVChbESJz8MKdyxTGkVDoigwcPMRGDUcl7PCVFHhen9Djpx5UW0B 2025-08-11 16:10:06 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-11 16:10:06 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 16:10:06 [INFO]: inside itemsold and closed 14409 2025-08-11 16:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 16:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-11 16:10:07 [INFO]: Ebay item id :: 304535436555 exists in Database 2025-08-11 16:10:07 [INFO]: Item is reliested :: exists in Database 2025-08-11 16:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 16:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 16:10:07 [INFO]: in processold action queue is array for {"44583441":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44583441","ebayitemid":"304535436555","shopifyproductid":"7699326894302","variants":[{"price":"11.99","quantity":0,"weight":"0.5","shopifyproductid":"7699326894302","shopifyvariantid":"42995253706974","shopifyinventoryid":"45090451456222","shopifylocationid":"","product_id":"44583441","variant_id":"77476150","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 16:10:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 16:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 16:10:07 [INFO]: Shopify Inventory id 45090451456222 2025-08-11 16:10:07 [INFO]: Shopify Location id 58450641063 2025-08-11 16:10:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 16:10:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T16:10: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-08-11 16:10:08 [INFO]: Change: available | Delta: -1 2025-08-11 16:10:08 [INFO]: Change: on_hand | Delta: -1 2025-08-11 16:10:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 16:10:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44583441 and user_id = 14409 2025-08-11 16:10:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77476150 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 16:10:08 [INFO]: updateIdsQuantity -> ["77476150"] 2025-08-11 16:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 16:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77476150 THEN 0 END, quantityflag = CASE WHEN id = 77476150 THEN 0 END WHERE user_id = 14409 AND id IN (77476150) 2025-08-11 16:10:08 [INFO]: QUANTITY Updated IDs: 77476150 2025-08-11 16:10:08 [INFO]: Successfully processed data for user 14409 2025-08-11 16:10:08 [INFO]: Execution Started 2025-08-11 16:10:08 [INFO]: Execution Finished 2025-08-11 16:20:02 [INFO]: Execution Started 2025-08-11 16:20:02 [INFO]: old server sucessfully connected 2025-08-11 16:20:02 [INFO]: sqs client sucess created 2025-08-11 16:20:03 [INFO]: Number of messages in the queue: 0 2025-08-11 16:20:23 [INFO]: Execution Started 2025-08-11 16:20:23 [INFO]: Execution Finished 2025-08-11 16:30:01 [INFO]: Execution Started 2025-08-11 16:30:01 [INFO]: old server sucessfully connected 2025-08-11 16:30:01 [INFO]: sqs client sucess created 2025-08-11 16:30:04 [INFO]: Number of messages in the queue: 3 2025-08-11 16:30:05 [INFO]: item found in queue is if condition 14409 2025-08-11 16:30:05 [INFO]: item found in queue is 14409 2025-08-11 16:30:06 [INFO]: Message deleted from the queue for receipt handle: AQEB2pND6nF6pisgGe7UH/Cuq0uOKdtfY706XqaVuisFDZghbLBfF3xkBJZSk4PSmtolp3ygs9d25ZBHwX1+LBvyNSPNCOALqlzc4YYCo4tfe+c9PYq87Fw0Lv/7dKJTNqG83NFVdlY5rEAHym+bEsQKFPczW2uaPNLPBS7pt+NaoG//N6VaoHHGdNVmbRGPagOI/rp4PHGmB+cGS7BGmQyNg5pd+mE14Cd2oeuE4zcngDLdJv4P41fHT/6eZEM56YYUW3ejeM4Q6vmDyNJhMxkLxV5nhrbemom+bg9X+bYVCc9oUI2sN9BAAQVCCibq7CVHccnPMyfjRq25aFqAMVwlZ7SLmhOHX2p0yThvDWIReIVmb1iECfj1NVCYbVbh7Rb9zjUrkmkGYWYZtI5o248qG44xfYUifhfKYQp0FStLeDUN9iOiSKbvHfUPHvmhh6PW 2025-08-11 16:30:07 [INFO]: item found in queue is if condition 14409 2025-08-11 16:30:07 [INFO]: item found in queue is 14409 2025-08-11 16:30:07 [INFO]: Message deleted from the queue for receipt handle: AQEByoYopCKs/lIHtouhnkYwtG1QOx0HLytLy9rMYjtGMOMLmcEJHpV11fiUmY+5hUs4JIBvuhwxlFhYYeqR/oMtLlULT8kQ5DGsQpZoGefWqMlVsnr0BCawYs36x1o8b3S3dsXz9SS3dWLC++J8nGXiEjm0UQ3DQ/uMuhJnbEkBIW6MFGNdnS660BQxCaGZpuauqMwifAcEsVrpnqY5jV/rA4TdCSjLSYuw+9ksM7EYRlcieB3ayOGbUFc39Zr/X8i9rgxrnlf52ZAXtvqeSIsQhyu8ND8r0UMbpVYqZCyCbiPStWEpn1Imng4AlGydjyXHAo5xUaYUei+4kFoQR1HXwPiIw5BbydPzTbOHkA9ii669vGFqhk3cmnvCfSHC+tiv0qfzEMWVQqLumNsNlqwf7zCDiMi0Z8QhQkyr8A9f6aJQC2ASnxdqaPH554BJ4Fwp 2025-08-11 16:30:09 [INFO]: item found in queue is if condition 14409 2025-08-11 16:30:09 [INFO]: item found in queue is 14409 2025-08-11 16:30:10 [INFO]: Message deleted from the queue for receipt handle: AQEBkVzGHlzlZymBDi2eWKvvlt5352K7fw4Sc2K+g9pRYTqVnkcj/jMXpNyDayHcfC3wS+Vk4QlLD/hEMIt8YZp36R9eDzEgr5PLHuVaMx71GDmPwPTSdIm4qTXSBSN8amCWm/0YpIeB+dyNrhyVn3HzXKNbm+SKowULJU5wxaoKn2+xps+3pOSC7MxoJhCm6RJRVx/O+qmHn6hmyLXJHU84drkSFzGFKFq8E4MrHYKKVc0LIHRpCZeHFgSzZr0wHKWj0tQmxupiSzQeFeC52Rjh0fm0Uh/vd7CBRAq86Xt+kyzOFFUqyvp+7BHeVFMZdasBsS0ve1SXvjgFloFysWr95iMZa1AC2/2ZXwOIwkM4BGsoULCfaHeL/xlCnaZZybX8cQJbijn2vds7tVpuCwwQUq/o2zmWk9WVtOhocqWypU+XP9a8lFe4xKLqvQ1S8CSq 2025-08-11 16:30:10 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-11 16:30:10 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 16:30:10 [INFO]: inside itemsold and closed 14409 2025-08-11 16:30:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 16:30:12 [INFO]: autolink for user_id 14409 is 1 2025-08-11 16:30:12 [INFO]: Ebay item id :: 306397095240 exists in Database 2025-08-11 16:30:12 [INFO]: Item is reliested :: exists in Database 2025-08-11 16:30:12 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-11 16:30:12 [INFO]: inside itemsold and closed 14409 2025-08-11 16:30:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 16:30:13 [INFO]: autolink for user_id 14409 is 1 2025-08-11 16:30:13 [INFO]: Ebay item id :: 406016848868 exists in Database 2025-08-11 16:30:13 [INFO]: Item is reliested :: exists in Database 2025-08-11 16:30:13 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-11 16:30:13 [INFO]: inside itemsold and closed 14409 2025-08-11 16:30:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 16:30:15 [INFO]: autolink for user_id 14409 is 1 2025-08-11 16:30:15 [INFO]: Ebay item id :: 226620696819 exists in Database 2025-08-11 16:30:15 [INFO]: Item is reliested :: exists in Database 2025-08-11 16:30:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 16:30:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 16:30:15 [INFO]: in processold action queue is array for {"45234621":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45234621","ebayitemid":"306397095240","deleted":1}},"45190178":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45190178","ebayitemid":"406016848868","deleted":1}},"44680904":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44680904","ebayitemid":"226620696819","shopifyproductid":"8829323215070","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8829323215070","shopifyvariantid":"46326282518750","shopifyinventoryid":"48427494703326","shopifylocationid":"","product_id":"44680904","variant_id":"77586124","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 16:30:15 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 16:30:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 16:30:15 [INFO]: productIds WHich are having null productid -> [45234621,45190178] 2025-08-11 16:30:15 [INFO]: ebayItemIds WHich are not imported-> ["306397095240","406016848868"] 2025-08-11 16:30:15 [INFO]: Entered in bulkUpdateProducts function 2025-08-11 16:30:15 [INFO]: Transaction started for bulkUpdateProducts 2025-08-11 16:30:15 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45234621,45190178) 2025-08-11 16:30:15 [INFO]: Query executed successfully. Affected rows: 0 2025-08-11 16:30:15 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-11 16:30:15 [INFO]: Transaction committed successfully. 2025-08-11 16:30:15 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-11 16:30:15 [INFO]: Shopify Inventory id 48427494703326 2025-08-11 16:30:15 [INFO]: Shopify Location id 58450641063 2025-08-11 16:30:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 16:30:16 [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-11 16:30:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 16:30:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44680904 and user_id = 14409 2025-08-11 16:30:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77586124 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 16:30:16 [INFO]: updateIdsQuantity -> ["77586124"] 2025-08-11 16:30:16 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 16:30:16 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77586124 THEN 0 END, quantityflag = CASE WHEN id = 77586124 THEN 0 END WHERE user_id = 14409 AND id IN (77586124) 2025-08-11 16:30:16 [INFO]: QUANTITY Updated IDs: 77586124 2025-08-11 16:30:16 [INFO]: Successfully processed data for user 14409 2025-08-11 16:30:16 [INFO]: Execution Started 2025-08-11 16:30:16 [INFO]: Execution Finished 2025-08-11 16:40:01 [INFO]: Execution Started 2025-08-11 16:40:01 [INFO]: old server sucessfully connected 2025-08-11 16:40:01 [INFO]: sqs client sucess created 2025-08-11 16:40:05 [INFO]: Number of messages in the queue: 0 2025-08-11 16:40:26 [INFO]: Execution Started 2025-08-11 16:40:26 [INFO]: Execution Finished 2025-08-11 16:50:01 [INFO]: Execution Started 2025-08-11 16:50:01 [INFO]: old server sucessfully connected 2025-08-11 16:50:01 [INFO]: sqs client sucess created 2025-08-11 16:50:04 [INFO]: Number of messages in the queue: 0 2025-08-11 16:50:09 [INFO]: item found in queue is if condition 14409 2025-08-11 16:50:09 [INFO]: item found in queue is 14409 2025-08-11 16:50:14 [INFO]: Message deleted from the queue for receipt handle: AQEBdiGOkwYcfePz9hfiY+VpPtxXeAMLPFOgWo1go0Ludda1OZq3+KfysgU74Ze/4zOp4PmSkaggdDzicoljxF6cf0bdyY4cTpfRnKiJJewAn83MnWo1sqADxOerhJNDvwJqlQeGX31ufah94GJl3ezjNaqcxO0PITfWnfok8wvccc1WxfZabdUrhjr5l85p/J0Locjgrz9wewLy7ubWl+WXKs/CeRBP4Fr6pgQ3Rq2+sydf4B7TiLR2ERAqnL/GER9jmEVBGePhHLGmn/yHa1ULESsrsgr905rHV/oSWNkZIqp9ME0mq5SLvj/HAokgKt8E6jCo+p1G4+tYINPJqaVbdHRPLspW6s/x/5/S7Yac34YwIxSW1DmWM8488sCzhvPO26vtQ1pxhXELG/Vza/oO6gfRFGkslIfaqMzozHjWo/M9wteBb8lUTl8iSOA3NXnc 2025-08-11 16:50:14 [INFO]: Processed 1 messages, reached the limit of 0. 2025-08-11 16:50:14 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 16:50:14 [INFO]: inside itemsold and closed 14409 2025-08-11 16:50:16 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 16:50:16 [INFO]: autolink for user_id 14409 is 1 2025-08-11 16:50:16 [INFO]: Ebay item id :: 225264619952 exists in Database 2025-08-11 16:50:16 [INFO]: Item is reliested :: exists in Database 2025-08-11 16:50:16 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 16:50:16 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 16:50:16 [INFO]: in processold action queue is array for {"44668947":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44668947","ebayitemid":"225264619952","shopifyproductid":"8922089062622","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8922089062622","shopifyvariantid":"46811491139806","shopifyinventoryid":"48909961429214","shopifylocationid":"58450641063","product_id":"44668947","variant_id":"77574167","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 16:50:16 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 16:50:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 16:50:16 [INFO]: Shopify Inventory id 48909961429214 2025-08-11 16:50:16 [INFO]: Shopify Location id 58450641063 2025-08-11 16:50:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 16:50:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T16:50:16Z","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-11 16:50:16 [INFO]: Change: available | Delta: -1 2025-08-11 16:50:16 [INFO]: Change: on_hand | Delta: -1 2025-08-11 16:50:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 16:50:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44668947 and user_id = 14409 2025-08-11 16:50:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77574167 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 16:50:16 [INFO]: updateIdsQuantity -> ["77574167"] 2025-08-11 16:50:16 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 16:50:16 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77574167 THEN 0 END, quantityflag = CASE WHEN id = 77574167 THEN 0 END WHERE user_id = 14409 AND id IN (77574167) 2025-08-11 16:50:16 [INFO]: QUANTITY Updated IDs: 77574167 2025-08-11 16:50:16 [INFO]: Successfully processed data for user 14409 2025-08-11 16:50:16 [INFO]: Execution Started 2025-08-11 16:50:16 [INFO]: Execution Finished