2025-08-13 04:00:02 [INFO]: Execution Started 2025-08-13 04:00:02 [INFO]: old server sucessfully connected 2025-08-13 04:00:02 [INFO]: sqs client sucess created 2025-08-13 04:00:03 [INFO]: Number of messages in the queue: 1 2025-08-13 04:00:04 [INFO]: item found in queue is if condition 14409 2025-08-13 04:00:04 [INFO]: item found in queue is 14409 2025-08-13 04:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBn6LlZcnuZo5RWNotca8wRmkGeuP16pkzj1CbCd92Em3Y4fwvbvDgSDSRpLefLt9U9WFV+tqSGt6iKTteTN+2DyU4wuQwhzmpgu0WICJ6El6B+G7ti0Jpx+vbwqpEJ83BkZ3Dxyc4FOCGK6T30Ad7Vm24HmI2EJEN9vkyZlcBwPubuT25gaIAmMYGErpzpx+nShOJaQX2AMtA6oNjb51OwIsPhELOxDN7f785fgxJBc3GuviYDAB4aVW3t4s6zDe2v/2Y1M8jzk3gKG/YuEcKHvduIQ2QR+aDicBH57JSx9dGNoQsYyBI+ei/ba5rIsQ7HcmUfYtIXcK5Ivo4kMZOcxgV8l1e598LGKiiGJjqXwXJ1euGh//eue3MRPSJFcvmtLjhieBv1BISFHsJcf/exjLJXyl/cKFJKrXMUrd9H1w10wCAY2YM08jBhKsWnUM4 2025-08-13 04:00:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-13 04:00:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 04:00:04 [INFO]: inside itemsold and closed 14409 2025-08-13 04:00:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 04:00:06 [INFO]: autolink for user_id 14409 is 1 2025-08-13 04:00:06 [INFO]: Ebay item id :: 404995478851 exists in Database 2025-08-13 04:00:06 [INFO]: Item is reliested :: exists in Database 2025-08-13 04:00:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 04:00:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 04:00:06 [INFO]: in processold action queue is array for {"44675305":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44675305","ebayitemid":"404995478851","shopifyproductid":"8506639778014","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"8506639778014","shopifyvariantid":"45419044733150","shopifyinventoryid":"47517022912734","shopifylocationid":"","product_id":"44675305","variant_id":"77580525","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 04:00:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 04:00:06 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 04:00:06 [INFO]: Shopify Inventory id 47517022912734 2025-08-13 04:00:06 [INFO]: Shopify Location id 58450641063 2025-08-13 04:00:06 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 04:00:06 [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-13 04:00:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 04:00:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44675305 and user_id = 14409 2025-08-13 04:00:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77580525 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 04:00:06 [INFO]: updateIdsQuantity -> ["77580525"] 2025-08-13 04:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 04:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77580525 THEN 0 END, quantityflag = CASE WHEN id = 77580525 THEN 0 END WHERE user_id = 14409 AND id IN (77580525) 2025-08-13 04:00:06 [INFO]: QUANTITY Updated IDs: 77580525 2025-08-13 04:00:07 [INFO]: Successfully processed data for user 14409 2025-08-13 04:00:07 [INFO]: Execution Started 2025-08-13 04:00:07 [INFO]: Execution Finished 2025-08-13 04:10:01 [INFO]: Execution Started 2025-08-13 04:10:01 [INFO]: old server sucessfully connected 2025-08-13 04:10:01 [INFO]: sqs client sucess created 2025-08-13 04:10:03 [INFO]: Number of messages in the queue: 0 2025-08-13 04:10:24 [INFO]: Execution Started 2025-08-13 04:10:24 [INFO]: Execution Finished 2025-08-13 04:20:01 [INFO]: Execution Started 2025-08-13 04:20:01 [INFO]: old server sucessfully connected 2025-08-13 04:20:01 [INFO]: sqs client sucess created 2025-08-13 04:20:03 [INFO]: Number of messages in the queue: 2 2025-08-13 04:20:04 [INFO]: item found in queue is if condition 14409 2025-08-13 04:20:04 [INFO]: item found in queue is 14409 2025-08-13 04:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBVlocOCLN9+R2ScKV3ArFilNu0aaBQ8sdxp/xOLQpwVtMgVX5tLHTfliXcD5h5wgGeA7P/XBQH6cbDLSaydM+BN1KjD7U9ntjDINDVsT29iwHocYiC6Kc+hAO6336WHo2Py1Ik/0z7a0GUB4vSxmDV+hWT0EjDeXdGTEvxw4Y2ZyyPC7FOgnk7MXm815qQkPL5P6b6hlIAiP+IHgG0VFD+u4rrqoX/CsSjl3vQmJvqPdf66E6SqwQ85t21LlqwIR/OOEIApc+JB03a8HFUAEHoyz9qo69PnEXYbuguzYYXcUH16NCQl5jWj8Ueuex2vkEntY7CRN4ROm6LKMbEiOGn/1Aj1V8H9pbp2NUWXH1nziVY/zRyy4Eu4GmvGf4EHcbUopVTl6V95yP2e/abrUBgoAaUNB0AwK7p/6deyJt6oA5KpRaA80nDbMlABjOowq3 2025-08-13 04:20:06 [INFO]: item found in queue is if condition 14409 2025-08-13 04:20:06 [INFO]: item found in queue is 14409 2025-08-13 04:20:06 [INFO]: Message deleted from the queue for receipt handle: AQEBJfWg0wtw7+6g5IiEqMkeKgq7LxKwRSs3cBT4ki1p6C13sGU7yzHI+4rPS88wDdu4HLF/GZo/uLnuxLnhBDgqKFrQhpslFK0+vHi9R6cdQlyw8xsYsPLqOtMpExPwyfnEKF/3irDTEsOZz50krP8YUgtMSBSZl1lIXVnYZ3+vd5nQb/UT6CQyXSAKkgTZXnl/GawjE1iZf64EjXBNw3aI641i1fGwrE1oBe2gcXlR89+kCzLdNG8lSLllypBBYRjrsWzfPj/YHjDOysJLdyi4r3bKek5yFM1fE6VZfn7OoVdnzMWgvvxudrV/a7hhAKLO5gr7CMATNR1Q+8kA0sZdXPtPDomOYAdwOGjrEb2X4CValawpQU1GNt+r/HiW2YN+O2jYjE0DXDNPlFOnTUzx9aFQc1VF5035c9web53tL6BwWgVDeKseMbkniGpvTqts 2025-08-13 04:20:06 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-13 04:20:06 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 04:20:06 [INFO]: inside itemsold and closed 14409 2025-08-13 04:20:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 04:20:08 [INFO]: autolink for user_id 14409 is 1 2025-08-13 04:20:08 [INFO]: Ebay item id :: 306431959909 exists in Database 2025-08-13 04:20:08 [INFO]: Item is reliested :: exists in Database 2025-08-13 04:20:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 04:20:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 04:20:08 [INFO]: inside itemsold and closed 14409 2025-08-13 04:20:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 04:20:10 [INFO]: autolink for user_id 14409 is 1 2025-08-13 04:20:10 [INFO]: Ebay item id :: 286346616521 exists in Database 2025-08-13 04:20:10 [INFO]: Item is reliested :: exists in Database 2025-08-13 04:20:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 04:20:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 04:20:10 [INFO]: in processold action queue is array for {"45313312":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313312","ebayitemid":"306431959909","shopifyproductid":"8980025147614","variants":[{"price":"329.99","quantity":0,"weight":"18","shopifyproductid":"8980025147614","shopifyvariantid":"47293342548190","shopifyinventoryid":"49405163110622","shopifylocationid":"58450641063","product_id":"45313312","variant_id":"78265825","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44662384":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44662384","ebayitemid":"286346616521","shopifyproductid":"8828593144030","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8828593144030","shopifyvariantid":"46324192968926","shopifyinventoryid":"48425377399006","shopifylocationid":"","product_id":"44662384","variant_id":"77567604","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 04:20:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 04:20:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 04:20:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 04:20:10 [INFO]: Shopify Inventory id 49405163110622 2025-08-13 04:20:10 [INFO]: Shopify Location id 58450641063 2025-08-13 04:20:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 04:20:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T04:20:10Z","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-13 04:20:10 [INFO]: Change: available | Delta: -1 2025-08-13 04:20:10 [INFO]: Change: on_hand | Delta: -1 2025-08-13 04:20:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 04:20:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313312 and user_id = 14409 2025-08-13 04:20:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265825 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 04:20:10 [INFO]: Shopify Inventory id 48425377399006 2025-08-13 04:20:10 [INFO]: Shopify Location id 58450641063 2025-08-13 04:20:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 04:20:10 [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-13 04:20:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 04:20:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44662384 and user_id = 14409 2025-08-13 04:20:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77567604 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 04:20:10 [INFO]: updateIdsQuantity -> ["78265825","77567604"] 2025-08-13 04:20:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-13 04:20:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78265825 THEN 0 WHEN id = 77567604 THEN 0 END, quantityflag = CASE WHEN id = 78265825 THEN 0 WHEN id = 77567604 THEN 0 END WHERE user_id = 14409 AND id IN (78265825,77567604) 2025-08-13 04:20:10 [INFO]: QUANTITY Updated IDs: 78265825, 77567604 2025-08-13 04:20:10 [INFO]: Successfully processed data for user 14409 2025-08-13 04:20:10 [INFO]: Execution Started 2025-08-13 04:20:10 [INFO]: Execution Finished 2025-08-13 04:30:02 [INFO]: Execution Started 2025-08-13 04:30:02 [INFO]: old server sucessfully connected 2025-08-13 04:30:02 [INFO]: sqs client sucess created 2025-08-13 04:30:04 [INFO]: Number of messages in the queue: 1 2025-08-13 04:30:05 [INFO]: item found in queue is if condition 14409 2025-08-13 04:30:05 [INFO]: item found in queue is 14409 2025-08-13 04:30:06 [INFO]: Message deleted from the queue for receipt handle: AQEB8JCp75shWNnmP5YtTxfCM897eFQSiFhlxvhsCfOt7dM9a0XDB8N3mkKBqei/eO5OJVx9lvmSjWQlDd1jKt8zINs1GTQhSgKgnhurb/xfpjBkTOnDXnj2EwIfzfy8D4OCvitFPKD3AP3+f/H7f8egcLzuSyPRRMM1gkRCYWZZfsiKSPadFaMNv3vAZ9mmp6IGPaxGBGtAm3tXvPlPXEUI63QIUmg7uBdnlq7QeywalhYz9bJaLHqO+FnWGCYDBKaWoqBUKvquXD9Tq07jTOaDaav8Hji2i0vKJXVvkudOh9u/sL6eHuRqvZYluXAPq50SkNp10PgMxdqvfDfP9AW+fqHWdq97TY7f3v19N9OgzPk7+yb/LeoTouqudzpetysTgqS+bsU6I4HbQ9LeNOCw+YkQYaDOGK7ngU6RFI3Qb2leHkfVSwt+2wGUD7IfeLZf 2025-08-13 04:30:06 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-13 04:30:06 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 04:30:06 [INFO]: inside itemsold and closed 14409 2025-08-13 04:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 04:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-13 04:30:07 [INFO]: Ebay item id :: 256455191409 exists in Database 2025-08-13 04:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-13 04:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 04:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 04:30:07 [INFO]: in processold action queue is array for {"44669964":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44669964","ebayitemid":"256455191409","shopifyproductid":"8338770362590","variants":[{"price":"15.99","quantity":0,"weight":"0.75","shopifyproductid":"8338770362590","shopifyvariantid":"44980005798110","shopifyinventoryid":"47077791334622","shopifylocationid":"","product_id":"44669964","variant_id":"77575184","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 04:30:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 04:30:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 04:30:08 [INFO]: Shopify Inventory id 47077791334622 2025-08-13 04:30:08 [INFO]: Shopify Location id 58450641063 2025-08-13 04:30:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 04:30:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T04: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-08-13 04:30:08 [INFO]: Change: available | Delta: -1 2025-08-13 04:30:08 [INFO]: Change: on_hand | Delta: -1 2025-08-13 04:30:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 04:30:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44669964 and user_id = 14409 2025-08-13 04:30:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77575184 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 04:30:08 [INFO]: updateIdsQuantity -> ["77575184"] 2025-08-13 04:30:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 04:30:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77575184 THEN 0 END, quantityflag = CASE WHEN id = 77575184 THEN 0 END WHERE user_id = 14409 AND id IN (77575184) 2025-08-13 04:30:08 [INFO]: QUANTITY Updated IDs: 77575184 2025-08-13 04:30:08 [INFO]: Successfully processed data for user 14409 2025-08-13 04:30:08 [INFO]: Execution Started 2025-08-13 04:30:08 [INFO]: Execution Finished 2025-08-13 04:40:01 [INFO]: Execution Started 2025-08-13 04:40:01 [INFO]: old server sucessfully connected 2025-08-13 04:40:01 [INFO]: sqs client sucess created 2025-08-13 04:40:03 [INFO]: Number of messages in the queue: 1 2025-08-13 04:40:03 [INFO]: item found in queue is if condition 14409 2025-08-13 04:40:03 [INFO]: item found in queue is 14409 2025-08-13 04:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBwsrR0obZ0h3k7L1uQQXgDqlRLbSq9jBoC8W5EQw4y8OpW55GljlQAZt0zaRi4eiPQC7aJFqX+Eqod+uXUjJ8uxnMc+xo4PQuna1nlG81CPehuz35rofLLjKm7QgiPd0g+da8tovkFLufztbU0vyfLZS03+BtTK8288k9WdRMjKH5Zdxly1W1f0hadnZjvx3eObRP8+G0dDyxw/erSgcXrtbdZlcqviGcxeADA5WUt6iGOLHPHZVspr+5QeI/vm4+9LypH6GHjYo1HBQdc7Y+nCvYX+M63FZOBaMxN2brDjTtxjvmPA5on7DRt3GlFTe1HoCy/ldsFkZgBYyrrO7gylpj4GW1y3ZQBA5mbmbar4oxlG154BZd6XPXuAM14k1TxWfJgKuNDFXt9J6ZVWlydxIwLE7StpZ1AKc2vuhPJFElWPvKf2bzhN6x1Om6tUhV 2025-08-13 04:40:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-13 04:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 04:40:03 [INFO]: inside itemsold and closed 14409 2025-08-13 04:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 04:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-13 04:40:05 [INFO]: Ebay item id :: 256054116438 exists in Database 2025-08-13 04:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-13 04:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 04:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 04:40:05 [INFO]: in processold action queue is array for {"44675460":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44675460","ebayitemid":"256054116438","shopifyproductid":"8025112314078","variants":[{"price":"10.99","quantity":0,"weight":"0.5","shopifyproductid":"8025112314078","shopifyvariantid":"44158554177758","shopifyinventoryid":"46255530770654","shopifylocationid":"","product_id":"44675460","variant_id":"77580680","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 04:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 04:40:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 04:40:05 [INFO]: Shopify Inventory id 46255530770654 2025-08-13 04:40:05 [INFO]: Shopify Location id 58450641063 2025-08-13 04:40:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 04:40:05 [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-13 04:40:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 04:40:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44675460 and user_id = 14409 2025-08-13 04:40:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77580680 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 04:40:05 [INFO]: updateIdsQuantity -> ["77580680"] 2025-08-13 04:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 04:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77580680 THEN 0 END, quantityflag = CASE WHEN id = 77580680 THEN 0 END WHERE user_id = 14409 AND id IN (77580680) 2025-08-13 04:40:05 [INFO]: QUANTITY Updated IDs: 77580680 2025-08-13 04:40:05 [INFO]: Successfully processed data for user 14409 2025-08-13 04:40:05 [INFO]: Execution Started 2025-08-13 04:40:05 [INFO]: Execution Finished 2025-08-13 04:50:02 [INFO]: Execution Started 2025-08-13 04:50:02 [INFO]: old server sucessfully connected 2025-08-13 04:50:02 [INFO]: sqs client sucess created 2025-08-13 04:50:04 [INFO]: Number of messages in the queue: 2 2025-08-13 04:50:05 [INFO]: item found in queue is if condition 14409 2025-08-13 04:50:05 [INFO]: item found in queue is 14409 2025-08-13 04:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEBnjsQ6i63Ta5oz7KMiN4qiWcpycETWTJslLur7BukT7UPXrz4VCc9VAOhKCzxUCPWLIv1f1zRpruuPFZy5ziJhPJUPHWfC25Za3+oMNnhg6C1Dz32l9uwWNtgiIGxwz7/9hhiXIl6ExdjoEL0ehB91BwnHaAT0gAdgYwfv2SPiGw05kv3X4CQ79S5AA8cYVrzJnwb9CjJIN3ST/s3sBu141CVLL53kN/W3AOiVWNP2wz2uyHTwu6PdxMC1G0o3BaDqyI9/kqIGrRMd85FP//Pf7olLAJSgvST4KSSIJm4oT1M6qcn5/4mYiC/hOLc5jCksXkRapPaRhrUWFuL9D3/T6fahMn1q3f8NpuVVK5Mo7O6v+PXAi0mBgCwgL4nAj5lPHK6EyCYDd7tp8eLDZsfsIkHjzONpXwESKkhDY+LQ3v85r+lHqKJrTx8eEVJGram 2025-08-13 04:50:10 [INFO]: item found in queue is if condition 14409 2025-08-13 04:50:10 [INFO]: item found in queue is 14409 2025-08-13 04:50:10 [INFO]: Message deleted from the queue for receipt handle: AQEB2UWs2vEPZsj9+KcSrir6ZAmDdp2sQRZdKplHr/+ddv5etAIOd7WZSf/s0MfyzUbMmQdOjf6Tmn2NZD7YE/iY4vi6jTnCw+YYHo3iYLn/i9vzJ3zTZknyFdMg11MyCMHTuMbFVc5R1ROvIhVM0WDSByeymx8N1v3TFoHkRAN0g7Rw2GclTL+2Usg8TbxyP6aTiZ7BbwnETE5UocddHQah88dQi8cHCg67AGfQmiRk6FGKm9Vy0cidMzMn2yNCPOebogWT0bZKQzd5+KoPLk42eHmJBzSldSdOvGf3p3z32zvfzDx/rlx5Rc1Wyb2Z4TRLn+6SuTyKimB+3zd0fUpAq84f1C7C5OwakQMC43lEldkvmj5ESFCKn/v7wvnPhZS36pPEKu2oLa0KPEYRiXU65rZ5EkTcnU/hvA403d+2T9diHnikX235pbzfKv6UoDuS 2025-08-13 04:50:10 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-13 04:50:10 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 04:50:10 [INFO]: inside itemsold and closed 14409 2025-08-13 04:50:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 04:50:12 [INFO]: autolink for user_id 14409 is 1 2025-08-13 04:50:12 [INFO]: Ebay item id :: 305590661913 exists in Database 2025-08-13 04:50:12 [INFO]: Item is reliested :: exists in Database 2025-08-13 04:50:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 04:50:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 04:50:12 [INFO]: inside itemsold and closed 14409 2025-08-13 04:50:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 04:50:14 [INFO]: autolink for user_id 14409 is 1 2025-08-13 04:50:14 [INFO]: Ebay item id :: 336034315760 exists in Database 2025-08-13 04:50:14 [INFO]: Item is reliested :: exists in Database 2025-08-13 04:50:14 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-13 04:50:14 [INFO]: in processold action queue is array for {"44595281":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44595281","ebayitemid":"305590661913","shopifyproductid":"8514613969118","variants":[{"price":"14.99","quantity":0,"weight":"1","shopifyproductid":"8514613969118","shopifyvariantid":"45443708551390","shopifyinventoryid":"47541688467678","shopifylocationid":"","product_id":"44595281","variant_id":"77487990","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45165209":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45165209","ebayitemid":"336034315760","deleted":1}}} 2025-08-13 04:50:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 04:50:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 04:50:14 [INFO]: productIds WHich are having null productid -> [45165209] 2025-08-13 04:50:14 [INFO]: ebayItemIds WHich are not imported-> ["336034315760"] 2025-08-13 04:50:14 [INFO]: Entered in bulkUpdateProducts function 2025-08-13 04:50:14 [INFO]: Transaction started for bulkUpdateProducts 2025-08-13 04:50:14 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45165209) 2025-08-13 04:50:14 [INFO]: Query executed successfully. Affected rows: 0 2025-08-13 04:50:14 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-13 04:50:14 [INFO]: Transaction committed successfully. 2025-08-13 04:50:14 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-13 04:50:14 [INFO]: Shopify Inventory id 47541688467678 2025-08-13 04:50:14 [INFO]: Shopify Location id 58450641063 2025-08-13 04:50:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 04:50:14 [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-13 04:50:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 04:50:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44595281 and user_id = 14409 2025-08-13 04:50:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77487990 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 04:50:14 [INFO]: updateIdsQuantity -> ["77487990"] 2025-08-13 04:50:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 04:50:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77487990 THEN 0 END, quantityflag = CASE WHEN id = 77487990 THEN 0 END WHERE user_id = 14409 AND id IN (77487990) 2025-08-13 04:50:14 [INFO]: QUANTITY Updated IDs: 77487990 2025-08-13 04:50:14 [INFO]: Successfully processed data for user 14409 2025-08-13 04:50:14 [INFO]: Execution Started 2025-08-13 04:50:14 [INFO]: Execution Finished