2025-08-01 15:00:01 [INFO]: Execution Started 2025-08-01 15:00:01 [INFO]: old server sucessfully connected 2025-08-01 15:00:01 [INFO]: sqs client sucess created 2025-08-01 15:00:03 [INFO]: Number of messages in the queue: 0 2025-08-01 15:00:24 [INFO]: item found in queue is if condition 14409 2025-08-01 15:00:24 [INFO]: item found in queue is 14409 2025-08-01 15:00:24 [INFO]: Message deleted from the queue for receipt handle: AQEBwrTXEixq+pK6KjGrmh9J0AOPNJHk9NBMk746Wc0GXSWLogTcnjGBwuhpqn8PEHB2x45+VSkZYdmSkWWgKby/R/kRioHaV9XKZYhebWuDZRw6sI3v2qdoqoi9Eo4tk5ghkR9dJ5yXYORCEalh+UePq7wiTYLsS9skUyGADJsVR4czFAf7yy4lWfrOJpC0ATan+YvNUXLJ06B5iUV9OuTzrt0/iPGqvKWHt//D+cOcGAvWvJsTUHKyKgypR1C7tP/ZERuSeenqncmzttrnrw6x1bqzk5Q92qq3Iterhf79NbPiwkH5/zxJ0lRNGrLy4JO013psKkzHrLhNgZhJlx55WmqlTHcpa3b8R/3WfJj2rJZ4uFU7xjRf08Ln+/jHBfiyUvMAYaQfpuLbPE9b/bu0OXpOy+MQo/G8ronGmoUHDbSGQYZUqqOrV6GsD2ZpqlwI 2025-08-01 15:00:24 [INFO]: Processed 1 messages, reached the limit of 0. 2025-08-01 15:00:24 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 15:00:24 [INFO]: inside itemsold and closed 14409 2025-08-01 15:00:26 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 15:00:26 [INFO]: autolink for user_id 14409 is 1 2025-08-01 15:00:26 [INFO]: Ebay item id :: 256755169627 exists in Database 2025-08-01 15:00:26 [INFO]: Item is reliested :: exists in Database 2025-08-01 15:00:26 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 15:00:26 [INFO]: in processold action queue is array for [] 2025-08-01 15:00:26 [INFO]: Successfully processed data for user 14409 2025-08-01 15:00:26 [INFO]: Execution Started 2025-08-01 15:00:26 [INFO]: Execution Finished 2025-08-01 15:10:01 [INFO]: Execution Started 2025-08-01 15:10:01 [INFO]: old server sucessfully connected 2025-08-01 15:10:01 [INFO]: sqs client sucess created 2025-08-01 15:10:03 [INFO]: Number of messages in the queue: 0 2025-08-01 15:10:24 [INFO]: Execution Started 2025-08-01 15:10:24 [INFO]: Execution Finished 2025-08-01 15:20:01 [INFO]: Execution Started 2025-08-01 15:20:01 [INFO]: old server sucessfully connected 2025-08-01 15:20:01 [INFO]: sqs client sucess created 2025-08-01 15:20:03 [INFO]: Number of messages in the queue: 0 2025-08-01 15:20:24 [INFO]: Execution Started 2025-08-01 15:20:24 [INFO]: Execution Finished 2025-08-01 15:30:01 [INFO]: Execution Started 2025-08-01 15:30:01 [INFO]: old server sucessfully connected 2025-08-01 15:30:01 [INFO]: sqs client sucess created 2025-08-01 15:30:03 [INFO]: Number of messages in the queue: 2 2025-08-01 15:30:04 [INFO]: item found in queue is if condition 14409 2025-08-01 15:30:04 [INFO]: item found in queue is 14409 2025-08-01 15:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBISeW0c2gW60ZrdMGpWk62hrq32hHupqcATsJD4WCazq7AWzkUQQKAA3921trvmJJa6RfM14K06/cDeryDo4Ya1q1YMymotjL6tvnj83DbOyzY+8QsvxyBxrbwDbONEErjNOObqRvMPCx1jb56r54PvfZ9PpRSc29ufmTRbk111Nq052hdrwX8D8ER9vV9Jn9E0nU/iLX6WiNRbBzSqzQxVtXlAP1tk1O2heHB2NAC2xNcCk7wBE9NplLyoOD2tlwLk5jdhpPd+HX7Kklkp5EN6bB5sQFoYQLU9xo/TvQf6cjrSPBPum6IGaGVmvED78APiNpcloznuqH8mgQ5TlxzRHbMVBTEfKWM1VuwpqRdqEs61AD9yGLJ+r+gtrqtCJxlh60QuyRxpCgztgaCusyfvb9pbtzEiuUREhDCqULTymE+ypk+FOU7LwpqxlZc3V7 2025-08-01 15:30:04 [INFO]: item found in queue is if condition 14409 2025-08-01 15:30:04 [INFO]: item found in queue is 14409 2025-08-01 15:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEB2Hwop7CPR7KYKB0u4JE1h3wNDVJl/IplqHO9NlV3I7Px3s31SpXKuPGAjDWtHseeRREtbngak/52erLgQhTqhTXNnZ4bDwOs+WuHU+yEIwSiBuaRTcc0HWYSnb4gcw9l0UBD0TU4labYGYg5ZLWg95PCLRaV5nEDke0whlsKrocYHRBL6MMPk+dZY1q+K2SscNVLcDg/B24YEc0FBKTUr+PTBd8/RbHj/if5Q5/G/6LOEeeaSG7OisQA4x8Jw9abE7az8PC+Abrb6LL8QDAaSQuH58kbHeugTdJWOJFLfoMO6P5rkRoECNP2VP05QrahAUTNXdS6yHcj4AbWE4Iua87PS1KpvP0t6Y02u2Z3AnTLIRNi8a93Z56JdJnZeg5okDMlg5z8uQkqmcAYMZScTM/0vfE8n8WtCG/flfxYPirCNFezpBtXIQd0kX/Z4wxa 2025-08-01 15:30:05 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-01 15:30:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 15:30:05 [INFO]: inside itemsold and closed 14409 2025-08-01 15:30:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 15:30:06 [INFO]: autolink for user_id 14409 is 1 2025-08-01 15:30:06 [INFO]: Ebay item id :: 306238380299 exists in Database 2025-08-01 15:30:06 [INFO]: Item is reliested :: exists in Database 2025-08-01 15:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 15:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 15:30:06 [INFO]: inside itemsold and closed 14409 2025-08-01 15:30:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 15:30:09 [INFO]: autolink for user_id 14409 is 1 2025-08-01 15:30:09 [INFO]: not in db for user_id 14409 and the ebayitemid326432720067 2025-08-01 15:30:09 [INFO]: in processold action queue is array for {"44566933":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44566933","ebayitemid":"306238380299","shopifyproductid":"8286049861854","variants":[{"price":"39.99","quantity":0,"weight":"3","shopifyproductid":"8286049861854","shopifyvariantid":"44806606880990","shopifyinventoryid":"46904634310878","shopifylocationid":"","product_id":"44566933","variant_id":"77459613","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 15:30:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 15:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 15:30:09 [INFO]: Shopify Inventory id 46904634310878 2025-08-01 15:30:09 [INFO]: Shopify Location id 58450641063 2025-08-01 15:30:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 15:30:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T15:30:09Z","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-01 15:30:09 [INFO]: Change: available | Delta: -1 2025-08-01 15:30:09 [INFO]: Change: on_hand | Delta: -1 2025-08-01 15:30:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 15:30:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44566933 and user_id = 14409 2025-08-01 15:30:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77459613 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 15:30:09 [INFO]: updateIdsQuantity -> ["77459613"] 2025-08-01 15:30:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-01 15:30:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77459613 THEN 0 END, quantityflag = CASE WHEN id = 77459613 THEN 0 END WHERE user_id = 14409 AND id IN (77459613) 2025-08-01 15:30:09 [INFO]: QUANTITY Updated IDs: 77459613 2025-08-01 15:30:09 [INFO]: Successfully processed data for user 14409 2025-08-01 15:30:09 [INFO]: Execution Started 2025-08-01 15:30:09 [INFO]: Execution Finished 2025-08-01 15:40:01 [INFO]: Execution Started 2025-08-01 15:40:01 [INFO]: old server sucessfully connected 2025-08-01 15:40:01 [INFO]: sqs client sucess created 2025-08-01 15:40:03 [INFO]: Number of messages in the queue: 1 2025-08-01 15:40:03 [INFO]: item found in queue is if condition 14409 2025-08-01 15:40:03 [INFO]: item found in queue is 14409 2025-08-01 15:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBjnZuodBtgIB5u3tNIhQmBW4C54O5cDtOsRPN5qa/ZFAGQbizR9yQH4ow7K5Os0rL40rCzw7PJcQzukb1IKUu49/a61t2bBdmC08HB+Lga8V10QmC1n7ealgU92KXxXtUj9gH6/RjErZbeksSyT5Vdsbp1F1rDW2JCkcLE74eA+TVnRgy7vx6NJSKjciAQapkMaalDXdgrtlx1KATZ5F+tIHzZeT90ZNXuG01satchZypHGK4IYRBEVFZj4kTQ0nOM5YRd1knuzorZc/kxbHsWnxDIPbwjEQM+c26W/H/IBr/8Ky0jA+1YW39Rjukj2sLGlDKukaok7kFfLUk6fCCi8aCo8tafP5eJBOif9sg5g3RoGRX4BPHC0CGzUO5k6Ym+Tbf4Lu81/xT8aAdsVq2HMgVoCmPSQMiEwE9rqQcn/ixeOzwuoeIseTBQikdTZta 2025-08-01 15:40:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-01 15:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 15:40:04 [INFO]: inside itemsold and closed 14409 2025-08-01 15:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 15:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-01 15:40:05 [INFO]: Ebay item id :: 335324222003 exists in Database 2025-08-01 15:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-01 15:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 15:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 15:40:05 [INFO]: in processold action queue is array for {"44595985":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44595985","ebayitemid":"335324222003","shopifyproductid":"8347199275230","variants":[{"price":"12.99","quantity":0,"weight":"1","shopifyproductid":"8347199275230","shopifyvariantid":"45002040082654","shopifyinventoryid":"47099834171614","shopifylocationid":"","product_id":"44595985","variant_id":"77488694","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 15:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 15:40:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 15:40:05 [INFO]: Shopify Inventory id 47099834171614 2025-08-01 15:40:05 [INFO]: Shopify Location id 58450641063 2025-08-01 15:40:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 15:40:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T15:40:06Z","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-01 15:40:06 [INFO]: Change: available | Delta: -1 2025-08-01 15:40:06 [INFO]: Change: on_hand | Delta: -1 2025-08-01 15:40:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 15:40:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44595985 and user_id = 14409 2025-08-01 15:40:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77488694 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 15:40:06 [INFO]: updateIdsQuantity -> ["77488694"] 2025-08-01 15:40:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-01 15:40:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77488694 THEN 0 END, quantityflag = CASE WHEN id = 77488694 THEN 0 END WHERE user_id = 14409 AND id IN (77488694) 2025-08-01 15:40:06 [INFO]: QUANTITY Updated IDs: 77488694 2025-08-01 15:40:06 [INFO]: Successfully processed data for user 14409 2025-08-01 15:40:06 [INFO]: Execution Started 2025-08-01 15:40:06 [INFO]: Execution Finished 2025-08-01 15:50:01 [INFO]: Execution Started 2025-08-01 15:50:01 [INFO]: old server sucessfully connected 2025-08-01 15:50:01 [INFO]: sqs client sucess created 2025-08-01 15:50:03 [INFO]: Number of messages in the queue: 1 2025-08-01 15:50:03 [INFO]: item found in queue is if condition 14409 2025-08-01 15:50:03 [INFO]: item found in queue is 14409 2025-08-01 15:50:07 [INFO]: Message deleted from the queue for receipt handle: AQEBW9L6Ptxr+eecpqwwZHrvjJTDZ9/TUhBogSHZaD8tr7YRrUyaGQEEHvVRjEwD97ZnWq7/vbHJ/4ncKdLu6fgb0ODveT45rfHXE8AYLFLEh5JAk6j1s9OCiagF2NF7jMoeN2qaU99a8P2z0R8M8Y3m2jr/W+DkhqeCI5vLVhtIvpiJEnd/u8EVhL0/gx7sqzkZ9g+otVVpRR+loTz3yX45cXHtmgdIprgOfLWeTvWY1xfADggbQveTXFnkDF5nM42LsuyVi/E4RLip31DaAObN08qMkAJ5X7fQInLCJm4Zk1jKBhlIiqHnQokqiia/0uGYyFODhgSyRMt4VjbIRomTj9PUJRvvBcwKx6CpYN2G5iRINzCcmVhQYnSUfD5BS/7glAuFrWYvaqq0i/1jgQXrnQudGrUrGSfaw3eIji7+OAJfi/XeaDd4F+p5wmb9gHCF 2025-08-01 15:50:07 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-01 15:50:07 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 15:50:07 [INFO]: inside itemsold and closed 14409 2025-08-01 15:50:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 15:50:08 [INFO]: autolink for user_id 14409 is 1 2025-08-01 15:50:08 [INFO]: Ebay item id :: 285500886329 exists in Database 2025-08-01 15:50:08 [INFO]: Item is reliested :: exists in Database 2025-08-01 15:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 15:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 15:50:08 [INFO]: in processold action queue is array for {"44555091":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44555091","ebayitemid":"285500886329","shopifyproductid":"8143314518238","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8143314518238","shopifyvariantid":"44376584585438","shopifyinventoryid":"46474373955806","shopifylocationid":"","product_id":"44555091","variant_id":"77447771","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 15:50:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 15:50:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 15:50:08 [INFO]: Shopify Inventory id 46474373955806 2025-08-01 15:50:08 [INFO]: Shopify Location id 58450641063 2025-08-01 15:50:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 15:50:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T15:50:09Z","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-01 15:50:09 [INFO]: Change: available | Delta: -1 2025-08-01 15:50:09 [INFO]: Change: on_hand | Delta: -1 2025-08-01 15:50:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 15:50:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44555091 and user_id = 14409 2025-08-01 15:50:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77447771 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 15:50:09 [INFO]: updateIdsQuantity -> ["77447771"] 2025-08-01 15:50:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-01 15:50:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77447771 THEN 0 END, quantityflag = CASE WHEN id = 77447771 THEN 0 END WHERE user_id = 14409 AND id IN (77447771) 2025-08-01 15:50:09 [INFO]: QUANTITY Updated IDs: 77447771 2025-08-01 15:50:09 [INFO]: Successfully processed data for user 14409 2025-08-01 15:50:09 [INFO]: Execution Started 2025-08-01 15:50:09 [INFO]: Execution Finished