2025-08-09 21:00:01 [INFO]: Execution Started 2025-08-09 21:00:01 [INFO]: old server sucessfully connected 2025-08-09 21:00:01 [INFO]: sqs client sucess created 2025-08-09 21:00:02 [INFO]: Number of messages in the queue: 1 2025-08-09 21:00:02 [INFO]: item found in queue is if condition 14409 2025-08-09 21:00:02 [INFO]: item found in queue is 14409 2025-08-09 21:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBDhPEJZQwzF0y9nrbIXMUv6obHeXUHEJz+7o2SJRyJyvoikxYGxbu6eWyUWqDLgd27pMpJK6jg3zERv4z7SmwZ3qLxHZYbJivT/icppOwcf1zlp37NDiOVDB2BR/Q8IeOYlfEtL99+gk6bgTTYi5oovJBz/6ivlC19dePk93zFcYo7XpdJdb2KWJHhWFYgUc2q/Sx1qMQuSFxCffjRwbP7RrZqlkkRRol7zmKnRkD3XeH7goxNsI0dStu2zghcXySbqi81vxthTePnSchCsMDxlYCQXGBkpOBBoV4s5c3efHZjFp9nAqjr0uWeuqNmEt2t5jGUlvM93ypuOPehg88P8ehkjjH3WqhjHRgUxYNQ1Sw+sM1a+Ir22rtiShJ3Q3tcy5SK3d4hpByq7jw2TfqZE/Kgukt3cM5ulG2g4cpAHQIy9XPY0zvmqcG4J99Kw1v 2025-08-09 21:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-09 21:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-09 21:00:03 [INFO]: inside itemsold and closed 14409 2025-08-09 21:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-09 21:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-09 21:00:05 [INFO]: Ebay item id :: 226642843998 exists in Database 2025-08-09 21:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-09 21:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-09 21:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-09 21:00:05 [INFO]: in processold action queue is array for {"44737394":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44737394","ebayitemid":"226642843998","shopifyproductid":"8839680753886","variants":[{"price":"379.99","quantity":0,"weight":"2","shopifyproductid":"8839680753886","shopifyvariantid":"46357255160030","shopifyinventoryid":"48459019878622","shopifylocationid":"","product_id":"44737394","variant_id":"77645331","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-09 21:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-09 21:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-09 21:00:05 [INFO]: Shopify Inventory id 48459019878622 2025-08-09 21:00:05 [INFO]: Shopify Location id 58450641063 2025-08-09 21:00:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-09 21:00:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-09T21: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-09 21:00:05 [INFO]: Change: available | Delta: -1 2025-08-09 21:00:05 [INFO]: Change: on_hand | Delta: -1 2025-08-09 21:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-09 21:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44737394 and user_id = 14409 2025-08-09 21:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77645331 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-09 21:00:05 [INFO]: updateIdsQuantity -> ["77645331"] 2025-08-09 21:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-09 21:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77645331 THEN 0 END, quantityflag = CASE WHEN id = 77645331 THEN 0 END WHERE user_id = 14409 AND id IN (77645331) 2025-08-09 21:00:05 [INFO]: QUANTITY Updated IDs: 77645331 2025-08-09 21:00:05 [INFO]: Successfully processed data for user 14409 2025-08-09 21:00:05 [INFO]: Execution Started 2025-08-09 21:00:05 [INFO]: Execution Finished 2025-08-09 21:10:01 [INFO]: Execution Started 2025-08-09 21:10:01 [INFO]: old server sucessfully connected 2025-08-09 21:10:01 [INFO]: sqs client sucess created 2025-08-09 21:10:02 [INFO]: Number of messages in the queue: 0 2025-08-09 21:10:23 [INFO]: Execution Started 2025-08-09 21:10:23 [INFO]: Execution Finished 2025-08-09 21:20:01 [INFO]: Execution Started 2025-08-09 21:20:01 [INFO]: old server sucessfully connected 2025-08-09 21:20:01 [INFO]: sqs client sucess created 2025-08-09 21:20:02 [INFO]: Number of messages in the queue: 0 2025-08-09 21:20:22 [INFO]: Execution Started 2025-08-09 21:20:22 [INFO]: Execution Finished 2025-08-09 21:30:02 [INFO]: Execution Started 2025-08-09 21:30:02 [INFO]: old server sucessfully connected 2025-08-09 21:30:02 [INFO]: sqs client sucess created 2025-08-09 21:30:03 [INFO]: Number of messages in the queue: 2 2025-08-09 21:30:03 [INFO]: item found in queue is if condition 14409 2025-08-09 21:30:03 [INFO]: item found in queue is 14409 2025-08-09 21:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBc9ZdRO/cmcZ0QdkJNf+DAKDPT5Ligk4BZB9tt9I0TybXcEuKWzafviGcgjXu+Md/2+AKPDLND0YfifzrZTHIA1cL4lQlW+6uuvLy2zmMuVuo0Dv/IE3H5Zgas1ArCtnN9YiHqaCfBY7oZvL8na0xpwJ7FdPrTzQ4FdO2kxNe06fj8wYSBsiJn7yeeCfG2Z3l4EWUR1LbYEUW9+kw+IcGW8gFUYulpsTd1KzBcEc19suzrCCct6HXmVTXb4EqYO389AFoW9q6pOVME5cSsS68+0UKdJwbJ7vHetop4w/Z9uHat7N0ytkgv35cUeXT+lDPwYR2UkmS4FeUIC1QJPP75djhN5mFkKHolugpwnu+WSxirn/HzauKAhQo+gvTtaCLk6MN79huIwC6Qi3KAU7lw7mYPJ4zHTxSOTqwqum12FzDxn54dqTqYq7sTl1NLtdx 2025-08-09 21:30:04 [INFO]: item found in queue is if condition 14409 2025-08-09 21:30:04 [INFO]: item found in queue is 14409 2025-08-09 21:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBXuSbczV+1LzmS765vaDzkxUaYQvb6jibN5X5dfD0cRwCJCg+W+DqSKD2Tp9nj9yiUVxIzYuwDO2ckoduxQx8dAfecbOFG5mgqw86J0btRi6SqvxFXq0O5RULMTf0Q0SSYG+mv8YGuMFXK4PW7OgKIKuQYAtZ7J4a5NpKTXvXHFbI/MTkp/F8S1cJqKpzvfc3o2l22nFE1dEsTUUSh1HK+FJG4a4RomKoVZ5m/GLAnl3MCwm2vtU0Z9qyQ1pYTuz9rHY2WpzDBltfgNZ8rC94K7A0LC3IXYvCVPd1O5ejHctS344yJmtSSrcjMnIST0OyNaoeKmPJaDbXrSobqOld8wwFkBdRyYtkOf7zGlv7Lbg/TMRpxBwVP4QOpuFtvmBBVoXl5pgfifjiEgscUby+MjjX09BWXIypT0WKqIumCLmrj6KQQSFysbehBoAkVEfC 2025-08-09 21:30:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-09 21:30:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-09 21:30:04 [INFO]: inside itemsold and closed 14409 2025-08-09 21:30:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-09 21:30:06 [INFO]: autolink for user_id 14409 is 1 2025-08-09 21:30:06 [INFO]: Ebay item id :: 405670357872 exists in Database 2025-08-09 21:30:06 [INFO]: Item is reliested :: exists in Database 2025-08-09 21:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-09 21:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-09 21:30:06 [INFO]: inside itemsold and closed 14409 2025-08-09 21:30:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-09 21:30:08 [INFO]: autolink for user_id 14409 is 1 2025-08-09 21:30:08 [INFO]: Ebay item id :: 285601967178 exists in Database 2025-08-09 21:30:08 [INFO]: Item is reliested :: exists in Database 2025-08-09 21:30:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-09 21:30:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-09 21:30:08 [INFO]: in processold action queue is array for {"44653860":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44653860","ebayitemid":"405670357872","shopifyproductid":"8043126522078","variants":[{"price":"39.99","quantity":0,"weight":"3","shopifyproductid":"8043126522078","shopifyvariantid":"44192616743134","shopifyinventoryid":"46289679515870","shopifylocationid":"","product_id":"44653860","variant_id":"77559049","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44567391":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44567391","ebayitemid":"285601967178","shopifyproductid":"8232972517598","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8232972517598","shopifyvariantid":"44597284339934","shopifyinventoryid":"46695256359134","shopifylocationid":"","product_id":"44567391","variant_id":"77460071","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-09 21:30:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-09 21:30:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-09 21:30:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-09 21:30:08 [INFO]: Shopify Inventory id 46289679515870 2025-08-09 21:30:08 [INFO]: Shopify Location id 58450641063 2025-08-09 21:30:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-09 21:30:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1930,"restoreRate":100}}}} 2025-08-09 21:30:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-09 21:30:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44653860 and user_id = 14409 2025-08-09 21:30:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77559049 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-09 21:30:08 [INFO]: Shopify Inventory id 46695256359134 2025-08-09 21:30:08 [INFO]: Shopify Location id 58450641063 2025-08-09 21:30:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-09 21:30:09 [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-09 21:30:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-09 21:30:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44567391 and user_id = 14409 2025-08-09 21:30:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77460071 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-09 21:30:09 [INFO]: updateIdsQuantity -> ["77559049","77460071"] 2025-08-09 21:30:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-09 21:30:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77559049 THEN 0 WHEN id = 77460071 THEN 0 END, quantityflag = CASE WHEN id = 77559049 THEN 0 WHEN id = 77460071 THEN 0 END WHERE user_id = 14409 AND id IN (77559049,77460071) 2025-08-09 21:30:09 [INFO]: QUANTITY Updated IDs: 77559049, 77460071 2025-08-09 21:30:09 [INFO]: Successfully processed data for user 14409 2025-08-09 21:30:09 [INFO]: Execution Started 2025-08-09 21:30:09 [INFO]: Execution Finished 2025-08-09 21:40:01 [INFO]: Execution Started 2025-08-09 21:40:01 [INFO]: old server sucessfully connected 2025-08-09 21:40:01 [INFO]: sqs client sucess created 2025-08-09 21:40:02 [INFO]: Number of messages in the queue: 0 2025-08-09 21:40:22 [INFO]: Execution Started 2025-08-09 21:40:22 [INFO]: Execution Finished 2025-08-09 21:50:01 [INFO]: Execution Started 2025-08-09 21:50:01 [INFO]: old server sucessfully connected 2025-08-09 21:50:01 [INFO]: sqs client sucess created 2025-08-09 21:50:02 [INFO]: Number of messages in the queue: 1 2025-08-09 21:50:03 [INFO]: item found in queue is if condition 14409 2025-08-09 21:50:03 [INFO]: item found in queue is 14409 2025-08-09 21:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBKzHHIFGyxuRnOefznwzPIZu04z2O27VJIWQUd9YKbk/VXSazOLSORqYTrjTOUAdVkM9bPPwAEW8OwFSDM9fPsVoErbJgzTkPLG6vWV7cUtfiKDZXY3kg0mOnJr6qynM/5b7yisqcHHNTqMJAFSujUSlGOQoGt909E9dXv+Sz3VyN+DAo7rB9BxEXiSaTPLjQvHpPq+UfeMQQeETTjzfQgOSCmnbnVwWvchtCwvnsTu36VNzaVJYTYZAxc0OBh/7j1inp9cYoMsEWzpZmM/VzXbYVNfeP16gROpDyYDFCMdW7v7/AV4BmURf/PbwgQ7MUq8Z3IeRXM7hzzhzNg2E9FJMHIQUovVjwqnKmWbx3Js8AW6ZfYuS7BZVsjb8+C0r9YMRjhS3hUMxPZ4sclZzlYzPtOKxDPwLquvb4yopPEv9zED2epAvSYab2rrfCK+97 2025-08-09 21:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-09 21:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-09 21:50:03 [INFO]: inside itemsold and closed 14409 2025-08-09 21:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-09 21:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-09 21:50:05 [INFO]: Ebay item id :: 256716627988 exists in Database 2025-08-09 21:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-09 21:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-09 21:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-09 21:50:05 [INFO]: in processold action queue is array for {"44644182":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44644182","ebayitemid":"256716627988","shopifyproductid":"8736411648222","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8736411648222","shopifyvariantid":"46054416482526","shopifyinventoryid":"48153144000734","shopifylocationid":"","product_id":"44644182","variant_id":"77549371","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-09 21:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-09 21:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-09 21:50:05 [INFO]: Shopify Inventory id 48153144000734 2025-08-09 21:50:05 [INFO]: Shopify Location id 58450641063 2025-08-09 21:50:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-09 21:50:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-09T21:50: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-09 21:50:05 [INFO]: Change: available | Delta: -1 2025-08-09 21:50:05 [INFO]: Change: on_hand | Delta: -1 2025-08-09 21:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-09 21:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44644182 and user_id = 14409 2025-08-09 21:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77549371 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-09 21:50:05 [INFO]: updateIdsQuantity -> ["77549371"] 2025-08-09 21:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-09 21:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77549371 THEN 0 END, quantityflag = CASE WHEN id = 77549371 THEN 0 END WHERE user_id = 14409 AND id IN (77549371) 2025-08-09 21:50:05 [INFO]: QUANTITY Updated IDs: 77549371 2025-08-09 21:50:05 [INFO]: Successfully processed data for user 14409 2025-08-09 21:50:05 [INFO]: Execution Started 2025-08-09 21:50:05 [INFO]: Execution Finished