2025-08-14 11:00:01 [INFO]: Execution Started 2025-08-14 11:00:02 [INFO]: old server sucessfully connected 2025-08-14 11:00:02 [INFO]: sqs client sucess created 2025-08-14 11:00:03 [INFO]: Number of messages in the queue: 0 2025-08-14 11:00:23 [INFO]: Execution Started 2025-08-14 11:00:23 [INFO]: Execution Finished 2025-08-14 11:10:02 [INFO]: Execution Started 2025-08-14 11:10:02 [INFO]: old server sucessfully connected 2025-08-14 11:10:02 [INFO]: sqs client sucess created 2025-08-14 11:10:04 [INFO]: Number of messages in the queue: 2 2025-08-14 11:10:04 [INFO]: item found in queue is if condition 14409 2025-08-14 11:10:04 [INFO]: item found in queue is 14409 2025-08-14 11:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBx72Pg7GquQgvPOxHy7czb+iyczsWjanP8irSHPjAq7nWJLcpJwyzV7mdoxaIu/8/OGXO8679OlZtxIf+wwkCDYEmRnTY/GAd+kwxUyZH+HlnFxsvzbE7GYogX5IfN2qGHtoB8GrfU55izCJWDj2kPQ/b3x0umcfBayATmHW5bHQJaizZA9Y9MGsKkBa9fn4blhtc4czvjBkCngQU/HXmTRS1oiX6plPnVb+kFnhoOeHAVyU/t+iSZtiKF/IMDEG7amQal3w/X0zr/LulRUemrXK+MPyEeUSIHfH7TlsQUNwVxE2SEKKjoEvBIOxH6qywPwjXtg04FtmMsn3EIshGUWBmh0qCcl5m6yiEsSJSGvtxfSZ5HfF1uaAyrhxWnProNaBkucxTcWLO1cjHH3BlxmPZGVZndrb7MPmUPyIJ9TpXM69/flssk2SUoLjAq1Vd 2025-08-14 11:10:05 [INFO]: item found in queue is if condition 14409 2025-08-14 11:10:05 [INFO]: item found in queue is 14409 2025-08-14 11:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEB2xv/dtYfSw7hIXPPwfGVq9CfJXvfwV/Cq0gdyhPrk3mDaBk7qivt8ZU53WaP/uo6QYSLIUfsrz5ZGwU0pYyiCnJSgAwibTlSmSIzDm3rszbIFnxy4/DDCiG+VTLR3I9f08tGufMEjytSkNqTJKajNyLSW/epnOlU2g28v449hVkOEcYZeexhQCUY7U9XPrCcvCP/SeKd/iCNcyvW1IRDJ9Unl51nRgx7yXdtOGImgmc1NOJ3pLPicO7DRMA+hapKjfd1fyHXiTH3Lo/secIMTmJ6xIOsTRCpJqj5LsuP6gY6mutatGzb0w95PJRnc9u4McZLyTR9toef47o/S1XTfX1volLQl3r9guUE14hViB4yK4WQ+R/yN1V5TFnyGZtg98lpAaJTQfrOUTDUX8d4Zlyw68qpv7huiJGj9d6Y8YtYbKjtBrnX22GDBOMHey3G 2025-08-14 11:10:05 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-14 11:10:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 11:10:05 [INFO]: inside itemsold and closed 14409 2025-08-14 11:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 11:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-14 11:10:07 [INFO]: Ebay item id :: 285954389041 exists in Database 2025-08-14 11:10:07 [INFO]: Item is reliested :: exists in Database 2025-08-14 11:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 11:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 11:10:07 [INFO]: inside itemsold and closed 14409 2025-08-14 11:10:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 11:10:09 [INFO]: autolink for user_id 14409 is 1 2025-08-14 11:10:09 [INFO]: Ebay item id :: 404832084737 exists in Database 2025-08-14 11:10:09 [INFO]: Item is reliested :: exists in Database 2025-08-14 11:10:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 11:10:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 11:10:09 [INFO]: in processold action queue is array for {"44774088":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44774088","ebayitemid":"285954389041","shopifyproductid":"8696069718238","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"8696069718238","shopifyvariantid":"45936112664798","shopifyinventoryid":"48034561589470","shopifylocationid":"","product_id":"44774088","variant_id":"77682630","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44771816":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44771816","ebayitemid":"404832084737","shopifyproductid":"8303410741470","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"8303410741470","shopifyvariantid":"44852087029982","shopifyinventoryid":"46950131368158","shopifylocationid":"","product_id":"44771816","variant_id":"77680358","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 11:10:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 11:10:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 11:10:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 11:10:09 [INFO]: Shopify Inventory id 48034561589470 2025-08-14 11:10:09 [INFO]: Shopify Location id 58450641063 2025-08-14 11:10:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 11:10:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T11:10: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-14 11:10:10 [INFO]: Change: available | Delta: -1 2025-08-14 11:10:10 [INFO]: Change: on_hand | Delta: -1 2025-08-14 11:10:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 11:10:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44774088 and user_id = 14409 2025-08-14 11:10:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77682630 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 11:10:10 [INFO]: Shopify Inventory id 46950131368158 2025-08-14 11:10:10 [INFO]: Shopify Location id 58450641063 2025-08-14 11:10:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 11:10:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T11:10:10Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1964,"restoreRate":100}}}} 2025-08-14 11:10:10 [INFO]: Change: available | Delta: -1 2025-08-14 11:10:10 [INFO]: Change: on_hand | Delta: -1 2025-08-14 11:10:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 11:10:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44771816 and user_id = 14409 2025-08-14 11:10:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680358 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 11:10:10 [INFO]: updateIdsQuantity -> ["77682630","77680358"] 2025-08-14 11:10:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-14 11:10:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77682630 THEN 0 WHEN id = 77680358 THEN 0 END, quantityflag = CASE WHEN id = 77682630 THEN 0 WHEN id = 77680358 THEN 0 END WHERE user_id = 14409 AND id IN (77682630,77680358) 2025-08-14 11:10:10 [INFO]: QUANTITY Updated IDs: 77682630, 77680358 2025-08-14 11:10:10 [INFO]: Successfully processed data for user 14409 2025-08-14 11:10:10 [INFO]: Execution Started 2025-08-14 11:10:10 [INFO]: Execution Finished 2025-08-14 11:20:01 [INFO]: Execution Started 2025-08-14 11:20:01 [INFO]: old server sucessfully connected 2025-08-14 11:20:02 [INFO]: sqs client sucess created 2025-08-14 11:20:03 [INFO]: Number of messages in the queue: 4 2025-08-14 11:20:04 [INFO]: item found in queue is if condition 14409 2025-08-14 11:20:04 [INFO]: item found in queue is 14409 2025-08-14 11:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBKAWWqw7Ch9jK225chLNjNNRxJBhtlobXbNasjA0PiUU0LtHy8UdrDAJ7VML1esAqu7Ho9+awD9C3dtgrxER3hgYnOhzUwROsikDojRg88B/ZRR9uipkcup54J1qIkr41pyWJ2LiR3S4fQdxX/tAp0SprE5AbRF7lCxJaA7vi4SLsJ98CsISDwH+OsH5y3l3WlTj4ony+YcUN9FoRSWHx0a5QN0sHv8WU2LQQgvOquCgvf8wKA2WgW66qX6y9iA7xETA2eZwISxcU8HlJ3e5Kv8jtZ+HQQQTZ8dewrA/EMr+IZ8GnrmO71LrCJRyxE22HiD/I/d6YRRYEkcqp7cIUjwWaAal6z0EqCCtGu1iSuT+3hV6YhUe8rpLh4sYihSO//ftoxurSYvmjbGuzixnwUw6Dx7pnV+q8bDgwGmRT7YO9h1kUvMof+NQxdlOQRHHB 2025-08-14 11:20:05 [INFO]: item found in queue is if condition 14409 2025-08-14 11:20:05 [INFO]: item found in queue is 14409 2025-08-14 11:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBT6T54kOHenp3DwkVmn0Q2CsqMpIPsCDxN9zNeevW3e7rIXfoXFVrqQaMJIpOvNt0UueZUcjErW1JIThJM2dCK5ySqLTYa6Ags7eY38EOK3E+jV6cO7gMNIPEYdSVlv0f0O5qsXpmr82opLCCcLlicUJviXScYqpadb8bqF4tee2DZbgac7QHJDS+CW0JPk2S7pujSiuiOR6GCwi3puTd0e4SnRkgkTDzAnriVmHvhfyFI/i6EuRlX8lKlrwWm2CViaL4zMy3+vhiaKzE8mQWfyEgRVbOQxVh5PVRQE2t1m0WgXDkzA6Gb5Fwy4w+Vp4jMXAZGIEigqU52QqPzjQu78q/AzAPwDEU12wlea41Lwk2KGXHAbtNxLjl9ngZspHtqlB14c6e8PqvsQljTHHUds/8xCLz815VM5aPosHCmN9GRqVol7ENqBr2gKHFE+yi 2025-08-14 11:20:06 [INFO]: item found in queue is if condition 14409 2025-08-14 11:20:06 [INFO]: item found in queue is 14409 2025-08-14 11:20:08 [INFO]: Message deleted from the queue for receipt handle: AQEBQod/5MFU1aHVID4hq4L7N3zInbQOZTaL3upqj6cs7gOxbxxW9ikXBjfZsTMAo+c12zpl5WduZtwh2Awr9i2uBUP+PgiMxQIVVuxIVbR86qjNRiFzQgTsN6yXU9q6pWgUKal2W/Z8iLE47fbzjB+y9PWtJAsa7oDhOR3ZyRdYH6d6ZM9KVmQXYW19MwK4kVoh/ukJ+URYdV1AAnQIR8dQDqrBXBldsdAcV2HmkCTHXjAX/rkFPFz57f/0VSvHwRUtl/B9r8of98tu7EXvn0zHcHQj7WuauEr1PjZIs3d+xF2Zn9UZQ+iGbj/EWuZKmWDerwyqxbanInQbsdLQSkl3ihJRC8mWOV9PCRl701G+OgCbZRcCr1gcPxAjSELtudmBZVOldqhAo483EE0MdcTUPC9oV+x+Nth2qdxOHHywnlNzPBMX8O7ICy2whyVdGCeC 2025-08-14 11:20:08 [INFO]: item found in queue is if condition 14409 2025-08-14 11:20:08 [INFO]: item found in queue is 14409 2025-08-14 11:20:08 [INFO]: Message deleted from the queue for receipt handle: AQEBiL4ScpCsJvduHH7y8OxAfGO7EOaU1vSAYW4yV9bT885wv4VmuYlpNON2jjgiF/rSkYJKPEFEIGMyYqYLR4j5oG1tjYVV5F5/q+nNAkqhvbDntIeP2tjL4WhX8T6NqiEvokfEd0wCThSZzFcxFN5kZp3ZSftsyX4P1GeGSqVnAexfk7htlfC76SoUjQ25z/FiZMFQrYRi7iSCWHIk4XzcFoZd7doNOOQuJtOGh3Zm329vTunb4iRNSYrh36ckLU9FllM6swR55lByT4NfkaSCEaKlvqWjj9T+2wM/hqgsM1QIfsbZx8CEyc2dz7Jq+WJGN7FdIFDzUL5ETiv5F3VGvtatMZ3PYbiAeMz+bj2LN2F3fj/VUytTVHr0kKCyEA2AwnX0Xqh0mw0w5EAzHjDMebjA466jXiXswwOfHbrLujK0DIBiXnYZFkwnoIVkZiSc 2025-08-14 11:20:08 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-14 11:20:08 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 11:20:08 [INFO]: inside itemsold and closed 14409 2025-08-14 11:20:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 11:20:10 [INFO]: autolink for user_id 14409 is 1 2025-08-14 11:20:10 [INFO]: Ebay item id :: 286048821402 exists in Database 2025-08-14 11:20:10 [INFO]: Item is reliested :: exists in Database 2025-08-14 11:20:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 11:20:10 [INFO]: inside itemsold and closed 14409 2025-08-14 11:20:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 11:20:12 [INFO]: autolink for user_id 14409 is 1 2025-08-14 11:20:12 [INFO]: Ebay item id :: 285977976910 exists in Database 2025-08-14 11:20:12 [INFO]: Item is reliested :: exists in Database 2025-08-14 11:20:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 11:20:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 11:20:12 [INFO]: inside itemsold and closed 14409 2025-08-14 11:20:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 11:20:13 [INFO]: autolink for user_id 14409 is 1 2025-08-14 11:20:13 [INFO]: Ebay item id :: 326558123385 exists in Database 2025-08-14 11:20:13 [INFO]: Item is reliested :: exists in Database 2025-08-14 11:20:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 11:20:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 11:20:13 [INFO]: inside itemsold and closed 14409 2025-08-14 11:20:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 11:20:15 [INFO]: autolink for user_id 14409 is 1 2025-08-14 11:20:15 [INFO]: Ebay item id :: 285984250721 exists in Database 2025-08-14 11:20:15 [INFO]: Item is reliested :: exists in Database 2025-08-14 11:20:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 11:20:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 11:20:15 [INFO]: in processold action queue is array for {"44678579":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44678579","ebayitemid":"285977976910","shopifyproductid":"8696080629982","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"8696080629982","shopifyvariantid":"45936136913118","shopifyinventoryid":"48034585870558","shopifylocationid":"","product_id":"44678579","variant_id":"77583799","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44688435":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44688435","ebayitemid":"326558123385","shopifyproductid":"7844833132766","variants":[{"price":"11.99","quantity":0,"weight":"0.75","shopifyproductid":"7844833132766","shopifyvariantid":"43544603230430","shopifyinventoryid":"45640236302558","shopifylocationid":"","product_id":"44688435","variant_id":"77593681","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44718087":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44718087","ebayitemid":"285984250721","shopifyproductid":"8696049795294","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"8696049795294","shopifyvariantid":"45936019243230","shopifyinventoryid":"48034468167902","shopifylocationid":"","product_id":"44718087","variant_id":"77625706","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 11:20:15 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 11:20:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 11:20:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 11:20:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 11:20:15 [INFO]: Shopify Inventory id 48034585870558 2025-08-14 11:20:15 [INFO]: Shopify Location id 58450641063 2025-08-14 11:20:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 11:20:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T11:20:15Z","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-14 11:20:15 [INFO]: Change: available | Delta: -1 2025-08-14 11:20:15 [INFO]: Change: on_hand | Delta: -1 2025-08-14 11:20:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 11:20:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44678579 and user_id = 14409 2025-08-14 11:20:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77583799 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 11:20:15 [INFO]: Shopify Inventory id 45640236302558 2025-08-14 11:20:15 [INFO]: Shopify Location id 58450641063 2025-08-14 11:20:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 11:20:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1981,"restoreRate":100}}}} 2025-08-14 11:20:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 11:20:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44688435 and user_id = 14409 2025-08-14 11:20:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77593681 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 11:20:16 [INFO]: Shopify Inventory id 48034468167902 2025-08-14 11:20:16 [INFO]: Shopify Location id 58450641063 2025-08-14 11:20:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 11:20:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T11:20:16Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1967,"restoreRate":100}}}} 2025-08-14 11:20:16 [INFO]: Change: available | Delta: -1 2025-08-14 11:20:16 [INFO]: Change: on_hand | Delta: -1 2025-08-14 11:20:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 11:20:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44718087 and user_id = 14409 2025-08-14 11:20:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77625706 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 11:20:16 [INFO]: updateIdsQuantity -> ["77583799","77593681","77625706"] 2025-08-14 11:20:16 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 2 2025-08-14 11:20:16 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77583799 THEN 0 WHEN id = 77593681 THEN 0 WHEN id = 77625706 THEN 0 END, quantityflag = CASE WHEN id = 77583799 THEN 0 WHEN id = 77593681 THEN 0 WHEN id = 77625706 THEN 0 END WHERE user_id = 14409 AND id IN (77583799,77593681,77625706) 2025-08-14 11:20:16 [INFO]: QUANTITY Updated IDs: 77583799, 77593681, 77625706 2025-08-14 11:20:16 [INFO]: Successfully processed data for user 14409 2025-08-14 11:20:16 [INFO]: Execution Started 2025-08-14 11:20:16 [INFO]: Execution Finished 2025-08-14 11:30:01 [INFO]: Execution Started 2025-08-14 11:30:01 [INFO]: old server sucessfully connected 2025-08-14 11:30:01 [INFO]: sqs client sucess created 2025-08-14 11:30:03 [INFO]: Number of messages in the queue: 4 2025-08-14 11:30:03 [INFO]: item found in queue is if condition 14409 2025-08-14 11:30:03 [INFO]: item found in queue is 14409 2025-08-14 11:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEB5VukFwEFLjcAn1Ai1RjzeptgfATTvSW8SYKWkJhwnwYU0EdzBLsU7zBRWFrCtuZeRIM5ABUGbGW95QE+YLkELM3dJFLzCuCbI9qQfZykuSWCdSXUo/8UihJZ1vdMGjXd8k5s4KfIPlYJq1L40U5StvlvCDPSAz60GlGpdhOlWRyXqS7oovgKLZIqW26P9gjpLoH/dgqh6t5Khv1/n+cR61TE3KAOFaa2WHf7q1s5NgZVjpX4EjfJYJwZqfFqyfxfRiQCR85inuRf8u9zewhhUYToBNophV3uLmtWUv9zuJm+sgVH35MXhbqVY1nNYt23U1RIJz0/7lZ9W490zC6vql30RaRLdCP7SJzRjFoYIWN671+99YLOmUcWv0qcHG8yNMzjnqV2bjefbKD/gw9h1rqmK1P/YhzVDSZNMuqJ3rhBex+YpHiIygjgwROl/Tld 2025-08-14 11:30:04 [INFO]: item found in queue is if condition 14409 2025-08-14 11:30:04 [INFO]: item found in queue is 14409 2025-08-14 11:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBbb6o8/RBz3EN1wzVw3aEOaQLowgub1hLS+pZxqeIN+4NGJHh0hDWV5LFXHuhpyLtInsXIPW+OrJ6wki/avOA7ewBnY7vVW2+p410Ukt4dRgwbRHBClnfH68IgQ8aFYRibiv5AmM0RwVxhsXHXbuPK8mjsGKERC1OBe92NkeXuQfZSGCJS8NQpKxujDtZ6n6lVClduHc1WdMUKg2hNBDt2rPCTe889bP72t7bI63q0R2KJTIG129QV0EKPKh92o7yVlh6nlquECrj2tyzo/M7OrKtgaBNGfKCd+jrJNRr/oEM0q5jRu4o0ncF3sHYEHhHjYAWot0aJDQzPgdIt26T2FprT7AKHI4J/7DRZH1JRGXUqzeKdAXtmuyltcxx1IjYoOo/w88oqIB4Jz67zdmrkHfMvzIo9SyUZWNoxIujkNzgDtPrnKZ7d5kZmqIAc4Ye 2025-08-14 11:30:05 [INFO]: item found in queue is if condition 14409 2025-08-14 11:30:05 [INFO]: item found in queue is 14409 2025-08-14 11:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBKt33CDgM50hhXXBgnKlBON9iBBANkFJbk4fwebR2MEwIAPsPhucqWGCmV5597XhNx2XoZ2Zpz8udtNs1YFMEAlBnJJWATBZKuvpRifYvhjCS61i48D429LWPdmUNTUA6NlkHUqg1MTGAXEv+tHI/qAWzhYkmPbc9PYdaiy2r6SlEYCn4AV5FqxqusYoPg+/Nm898jbbZDPFFWTqkmX95teAXQFVtTiqODoy4jVoiKUkjpSmme0grCamnDXoRgJBxHX0CGGnQ8WPU+x7ikKTwwOK/iqWtwOyiWOYrJp8QpdeRGQPZCA/+B0m+AhpKUsT+rVHTa7IJl+wn+c29AUC8Iiq5ub9jAoi4M8o4W8/Ggnv8K9WQqZJxHk2nnmgmWqUs2R/DOjRiLU5/CZiuESlY2QMT7wgLDoTu+6EnpXZLb6OcTAZXq8IgS+QoxnRdLfiS 2025-08-14 11:30:06 [INFO]: item found in queue is if condition 14409 2025-08-14 11:30:06 [INFO]: item found in queue is 14409 2025-08-14 11:30:07 [INFO]: Message deleted from the queue for receipt handle: AQEBZfEvgOmP1ltDlmss8kKT08RR7xoZo2ANXNC7xj898uwgqFwZ8CqmOvOR5xsyl3sTklvQKIFsc6AJj56Wa8j2MYgCsAxVP+vPr0MkPHXcMOGTuYgKizA63a849RWBTaXgwmbuLjUhKZSiSbueu+zpC8sturr44WOUn5CF904go+rOCoxbQnRNUAwCFTWR+AX+GIfu3hTEztZ2Uz/v37usa4z0ly1e6/9aSpQa26Utu2USGq+7bdMkjlUc0ZAOBmw3CaD+5FkgkcjLv7W7SLTzwXoQlqC4IDiIh1FncBRD1eHNwwI5jbYJHzksCwMf0+VEfkILyBKIKuXI1B+DU0jwRofn5EbMeQo6YdeeQstiBevPJZ6/5hmky9mK6yQVUbl6UbRUk/TaLVhBjCNRhg/YjcWaaCTUaShf7JZSpL9Anjj5B8dvJ7FrPAgFpt70R9kj 2025-08-14 11:30:07 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-14 11:30:07 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 11:30:07 [INFO]: inside itemsold and closed 14409 2025-08-14 11:30:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 11:30:09 [INFO]: autolink for user_id 14409 is 1 2025-08-14 11:30:09 [INFO]: Ebay item id :: 405299453088 exists in Database 2025-08-14 11:30:09 [INFO]: Item is reliested :: exists in Database 2025-08-14 11:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 11:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 11:30:09 [INFO]: inside itemsold and closed 14409 2025-08-14 11:30:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 11:30:11 [INFO]: autolink for user_id 14409 is 1 2025-08-14 11:30:11 [INFO]: Ebay item id :: 286050170977 exists in Database 2025-08-14 11:30:11 [INFO]: Item is reliested :: exists in Database 2025-08-14 11:30:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 11:30:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 11:30:11 [INFO]: inside itemsold and closed 14409 2025-08-14 11:30:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 11:30:12 [INFO]: autolink for user_id 14409 is 1 2025-08-14 11:30:12 [INFO]: Ebay item id :: 405317136747 exists in Database 2025-08-14 11:30:12 [INFO]: Item is reliested :: exists in Database 2025-08-14 11:30:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 11:30:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 11:30:12 [INFO]: inside itemsold and closed 14409 2025-08-14 11:30:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 11:30:14 [INFO]: autolink for user_id 14409 is 1 2025-08-14 11:30:14 [INFO]: Ebay item id :: 405150697795 exists in Database 2025-08-14 11:30:14 [INFO]: Item is reliested :: exists in Database 2025-08-14 11:30:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 11:30:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 11:30:14 [INFO]: in processold action queue is array for {"44664698":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44664698","ebayitemid":"405299453088","shopifyproductid":"8711247462622","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"8711247462622","shopifyvariantid":"45972441301214","shopifyinventoryid":"48071232422110","shopifylocationid":"","product_id":"44664698","variant_id":"77569918","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44775388":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44775388","ebayitemid":"286050170977","shopifyproductid":"8696074764510","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"8696074764510","shopifyvariantid":"45936124428510","shopifyinventoryid":"48034573385950","shopifylocationid":"","product_id":"44775388","variant_id":"77683930","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44776321":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44776321","ebayitemid":"405317136747","shopifyproductid":"8220310962398","variants":[{"price":"62.99","quantity":0,"weight":"3","shopifyproductid":"8220310962398","shopifyvariantid":"44562687688926","shopifyinventoryid":"46660642078942","shopifylocationid":"","product_id":"44776321","variant_id":"77684863","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44774631":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44774631","ebayitemid":"405150697795","shopifyproductid":"8696066867422","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"8696066867422","shopifyvariantid":"45936104636638","shopifyinventoryid":"48034553561310","shopifylocationid":"","product_id":"44774631","variant_id":"77683173","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 11:30:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 11:30:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 11:30:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 11:30:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 11:30:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 11:30:14 [INFO]: Shopify Inventory id 48071232422110 2025-08-14 11:30:14 [INFO]: Shopify Location id 58450641063 2025-08-14 11:30:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 11:30:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T11:30:14Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1978,"restoreRate":100}}}} 2025-08-14 11:30:15 [INFO]: Change: available | Delta: -1 2025-08-14 11:30:15 [INFO]: Change: on_hand | Delta: -1 2025-08-14 11:30:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 11:30:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44664698 and user_id = 14409 2025-08-14 11:30:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77569918 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 11:30:15 [INFO]: Shopify Inventory id 48034573385950 2025-08-14 11:30:15 [INFO]: Shopify Location id 58450641063 2025-08-14 11:30:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 11:30:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T11:30:15Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1974,"restoreRate":100}}}} 2025-08-14 11:30:15 [INFO]: Change: available | Delta: -1 2025-08-14 11:30:15 [INFO]: Change: on_hand | Delta: -1 2025-08-14 11:30:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 11:30:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44775388 and user_id = 14409 2025-08-14 11:30:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77683930 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 11:30:15 [INFO]: Shopify Inventory id 46660642078942 2025-08-14 11:30:15 [INFO]: Shopify Location id 58450641063 2025-08-14 11:30:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 11:30:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T11:30:15Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1967,"restoreRate":100}}}} 2025-08-14 11:30:15 [INFO]: Change: available | Delta: -1 2025-08-14 11:30:15 [INFO]: Change: on_hand | Delta: -1 2025-08-14 11:30:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 11:30:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44776321 and user_id = 14409 2025-08-14 11:30:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77684863 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 11:30:15 [INFO]: Shopify Inventory id 48034553561310 2025-08-14 11:30:15 [INFO]: Shopify Location id 58450641063 2025-08-14 11:30:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 11:30:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T11:30:15Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1974,"restoreRate":100}}}} 2025-08-14 11:30:15 [INFO]: Change: available | Delta: -1 2025-08-14 11:30:15 [INFO]: Change: on_hand | Delta: -1 2025-08-14 11:30:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 11:30:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44774631 and user_id = 14409 2025-08-14 11:30:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77683173 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 11:30:15 [INFO]: updateIdsQuantity -> ["77569918","77683930","77684863","77683173"] 2025-08-14 11:30:15 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4 2025-08-14 11:30:15 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77569918 THEN 0 WHEN id = 77683930 THEN 0 WHEN id = 77684863 THEN 0 WHEN id = 77683173 THEN 0 END, quantityflag = CASE WHEN id = 77569918 THEN 0 WHEN id = 77683930 THEN 0 WHEN id = 77684863 THEN 0 WHEN id = 77683173 THEN 0 END WHERE user_id = 14409 AND id IN (77569918,77683930,77684863,77683173) 2025-08-14 11:30:15 [INFO]: QUANTITY Updated IDs: 77569918, 77683930, 77684863, 77683173 2025-08-14 11:30:15 [INFO]: Successfully processed data for user 14409 2025-08-14 11:30:15 [INFO]: Execution Started 2025-08-14 11:30:15 [INFO]: Execution Finished 2025-08-14 11:40:01 [INFO]: Execution Started 2025-08-14 11:40:01 [INFO]: old server sucessfully connected 2025-08-14 11:40:02 [INFO]: sqs client sucess created 2025-08-14 11:40:04 [INFO]: Number of messages in the queue: 2 2025-08-14 11:40:04 [INFO]: item found in queue is if condition 14409 2025-08-14 11:40:04 [INFO]: item found in queue is 14409 2025-08-14 11:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEBBl89k7MyPskAJc4xE71nwuc79eOnnUrDhHuUtZtE1ZJx/L1TIzLVe8Hm+OR1S7ExTzeXikF68ApPdhXo0yY7v6bDo5vAbSx6rbgxkgvSll96fwHebtXKvnEvaJ+TsZv1jC6nxcu/Kvl8/ndWSCse1UQr5wEnqh2Ugc7WXaQmQMLWF+XWcZ3uzphLuXPf5GrQxyb2y4nvnwWzVIUhQPRJT4W0DwBQ8ZzJPaPENBD9n+3vjAM/s7Cwa4YFeLrp+D1FSryIiip+a8gPK7TujauO6IAWp9BbWXN1hJm7z8CSW5IGvivesLpGzjYBt3UvgSxpY6zavceFTOG0mDpoYs6gejL4+/2XcDkMCYPH000Y8J0k99f6mWZkiR3NV20PgoxLZ5Bl5+bD9YEVR8zZHvggyK8QAp8g06m2bOlOV0PoCoAay3WYOwgmB8IassBLbeeU 2025-08-14 11:40:05 [INFO]: item found in queue is if condition 14409 2025-08-14 11:40:05 [INFO]: item found in queue is 14409 2025-08-14 11:40:06 [INFO]: Message deleted from the queue for receipt handle: AQEBqAs7pTBj61qf/YDMutl9lkVpULxpJGlLAJmuaHKJZ+VQ2V/rxDyn6dWoQSoTyX/Dy/nfyPwi7tedppPZgmNBf2ueZj5nCd81BQN9keMRcdQJlhTjWl//sY1XdAwd4Dx//VTzNCN7Sy5+SfYHNFsqHVfSdbIw1+ThUeg29kAbC7mjBSoaXvRsA/oj/rHs2nfF2QKXd+9DtIjXKkybqf8rNSU4LUR/hF/ksCLWXuVrXV3FMig3TGeNYgeCvbly/TrIVuJAZimUqECRLf3bCUYWrChdPeDllUZNAnaTINf/F+ZV5nu1pmDKD1hJmLCNmDW5xYEhPoNBgyxJVbz9UjyKAy7n57uYEnhYSTAtQfV+7y19pGIcdhtvWbuN+nW/Lq7IKrWe80+wWanHhjnwPfMjIJxD3bfXUtvkbTOgGVs0aSn/WZnFn/9L0XJXFEICosVL 2025-08-14 11:40:06 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-14 11:40:06 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 11:40:06 [INFO]: inside itemsold and closed 14409 2025-08-14 11:40:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 11:40:08 [INFO]: autolink for user_id 14409 is 1 2025-08-14 11:40:08 [INFO]: Ebay item id :: 405317187760 exists in Database 2025-08-14 11:40:08 [INFO]: Item is reliested :: exists in Database 2025-08-14 11:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 11:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 11:40:08 [INFO]: inside itemsold and closed 14409 2025-08-14 11:40:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 11:40:09 [INFO]: autolink for user_id 14409 is 1 2025-08-14 11:40:09 [INFO]: Ebay item id :: 256695680796 exists in Database 2025-08-14 11:40:09 [INFO]: Item is reliested :: exists in Database 2025-08-14 11:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 11:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 11:40:09 [INFO]: in processold action queue is array for {"44776323":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44776323","ebayitemid":"405317187760","shopifyproductid":"8143307669726","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"8143307669726","shopifyvariantid":"44376563417310","shopifyinventoryid":"46474352787678","shopifylocationid":"","product_id":"44776323","variant_id":"77684865","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44776322":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44776322","ebayitemid":"256695680796","shopifyproductid":"8052602274014","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"8052602274014","shopifyvariantid":"44210564858078","shopifyinventoryid":"46307652010206","shopifylocationid":"","product_id":"44776322","variant_id":"77684864","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 11:40:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 11:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 11:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 11:40:09 [INFO]: Shopify Inventory id 46474352787678 2025-08-14 11:40:09 [INFO]: Shopify Location id 58450641063 2025-08-14 11:40:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 11:40:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T11:40:10Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1974,"restoreRate":100}}}} 2025-08-14 11:40:10 [INFO]: Change: available | Delta: -1 2025-08-14 11:40:10 [INFO]: Change: on_hand | Delta: -1 2025-08-14 11:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 11:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44776323 and user_id = 14409 2025-08-14 11:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77684865 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 11:40:10 [INFO]: Shopify Inventory id 46307652010206 2025-08-14 11:40:10 [INFO]: Shopify Location id 58450641063 2025-08-14 11:40:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 11:40:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T11:40:10Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1972,"restoreRate":100}}}} 2025-08-14 11:40:10 [INFO]: Change: available | Delta: -1 2025-08-14 11:40:10 [INFO]: Change: on_hand | Delta: -1 2025-08-14 11:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 11:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44776322 and user_id = 14409 2025-08-14 11:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77684864 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 11:40:10 [INFO]: updateIdsQuantity -> ["77684865","77684864"] 2025-08-14 11:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-14 11:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77684865 THEN 0 WHEN id = 77684864 THEN 0 END, quantityflag = CASE WHEN id = 77684865 THEN 0 WHEN id = 77684864 THEN 0 END WHERE user_id = 14409 AND id IN (77684865,77684864) 2025-08-14 11:40:10 [INFO]: QUANTITY Updated IDs: 77684865, 77684864 2025-08-14 11:40:10 [INFO]: Successfully processed data for user 14409 2025-08-14 11:40:10 [INFO]: Execution Started 2025-08-14 11:40:10 [INFO]: Execution Finished 2025-08-14 11:50:01 [INFO]: Execution Started 2025-08-14 11:50:01 [INFO]: old server sucessfully connected 2025-08-14 11:50:01 [INFO]: sqs client sucess created 2025-08-14 11:50:03 [INFO]: Number of messages in the queue: 2 2025-08-14 11:50:04 [INFO]: item found in queue is if condition 14409 2025-08-14 11:50:04 [INFO]: item found in queue is 14409 2025-08-14 11:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBwvUkQiH1CmHnmVNg/SwSec2jujUpqFTVvZ2oew0+r7uErdPbuH27TPAQfk3Ecty/kiCstKplah+plK+ANENfQF4s/zfpKhipoG6kDYctSQzLpkU8rHR+G4dTlxQIxVTNW6S3mWYWVJDp4LNM6wFNvAGs0jsCwEiYSJRYeqwgukjHK+mdgMMx99hRavQvaYBsjVGTRvdEov4gipcefz+OOmuIo9iIbG/GTCcOCD5SowyGkHXv2XnQ/6iayzhyrtXTE5GDXEr8uT2kUHjntB2nM1MeqBod8MDAsBE0C81xdmhTraMgfypUoOh5y0HwKnorNC0v2mOWNLq2tcNtlHtDxW7aEJ9OjM2xZE8BW3R8Nx4MVDhAeD7oKuWbqLT1WswIS8Lp1o4Y9/ntJWMaysRFvNU53XOSciexUH7YMNfofwY4TVfYMv/WkFf/tG6ijmQG 2025-08-14 11:50:05 [INFO]: item found in queue is if condition 14409 2025-08-14 11:50:05 [INFO]: item found in queue is 14409 2025-08-14 11:50:08 [INFO]: Message deleted from the queue for receipt handle: AQEBGbK5Oi4UfwJooiMXFwlRU5Aq6viebg85NPSDWTkT2cOlH3ZnxeToqL/b8/eSGnljBnfEX4YGmLG9ZZik5LkgKWf/dzEFuvors2jVXbce4LdQzisbi9GwKKL6f6ukCjq/+G9kB5pQjcCOw3EuhoTB7Ub23b6PTtWhO2sg4gsbYnRJAxIGxjVQ3yaV6icrq//tEGcpN/LPgSo/PSf1ZsqmP76jXy9Kdz+Nr77Ctc23N4tCjX0sHjrjWMVu4K13baqrXRTjCElMCF5aKFVrq0sDnzPDsn2kNHXbGZcgp2Wz/Nb81A0T5D7W/71tvCKEr6a+q/HaWf+DLP2GZ1M1TgQaG09c0Kbtr4ab6es4MoDa0k1+vX+mAP5XQg8yHjF8xQQk7WGxyZ3hLtwAJ28kbN4XA4V+sv7ATA/hfG1Bhqvb1JmwK6ZGDa9WgsdkeiptoWqw 2025-08-14 11:50:08 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-14 11:50:08 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 11:50:08 [INFO]: inside itemsold and closed 14409 2025-08-14 11:50:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 11:50:10 [INFO]: autolink for user_id 14409 is 1 2025-08-14 11:50:10 [INFO]: Ebay item id :: 256720715587 exists in Database 2025-08-14 11:50:10 [INFO]: Item is reliested :: exists in Database 2025-08-14 11:50:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 11:50:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 11:50:10 [INFO]: inside itemsold and closed 14409 2025-08-14 11:50:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 11:50:12 [INFO]: autolink for user_id 14409 is 1 2025-08-14 11:50:12 [INFO]: Ebay item id :: 405318274929 exists in Database 2025-08-14 11:50:12 [INFO]: Item is reliested :: exists in Database 2025-08-14 11:50:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 11:50:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 11:50:12 [INFO]: in processold action queue is array for {"44655615":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44655615","ebayitemid":"256720715587","shopifyproductid":"8739632808158","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"8739632808158","shopifyvariantid":"46070804218078","shopifyinventoryid":"48169549201630","shopifylocationid":"","product_id":"44655615","variant_id":"77560804","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44776331":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44776331","ebayitemid":"405318274929","shopifyproductid":"7677862740190","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"7677862740190","shopifyvariantid":"42911615975646","shopifyinventoryid":"45006547517662","shopifylocationid":"","product_id":"44776331","variant_id":"77684873","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 11:50:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 11:50:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 11:50:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 11:50:12 [INFO]: Shopify Inventory id 48169549201630 2025-08-14 11:50:12 [INFO]: Shopify Location id 58450641063 2025-08-14 11:50:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 11:50:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T11:50:12Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1967,"restoreRate":100}}}} 2025-08-14 11:50:12 [INFO]: Change: available | Delta: -1 2025-08-14 11:50:12 [INFO]: Change: on_hand | Delta: -1 2025-08-14 11:50:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 11:50:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44655615 and user_id = 14409 2025-08-14 11:50:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77560804 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 11:50:12 [INFO]: Shopify Inventory id 45006547517662 2025-08-14 11:50:12 [INFO]: Shopify Location id 58450641063 2025-08-14 11:50:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 11:50:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T11:50:13Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1968,"restoreRate":100}}}} 2025-08-14 11:50:13 [INFO]: Change: available | Delta: -1 2025-08-14 11:50:13 [INFO]: Change: on_hand | Delta: -1 2025-08-14 11:50:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 11:50:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44776331 and user_id = 14409 2025-08-14 11:50:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77684873 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 11:50:13 [INFO]: updateIdsQuantity -> ["77560804","77684873"] 2025-08-14 11:50:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-14 11:50:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77560804 THEN 0 WHEN id = 77684873 THEN 0 END, quantityflag = CASE WHEN id = 77560804 THEN 0 WHEN id = 77684873 THEN 0 END WHERE user_id = 14409 AND id IN (77560804,77684873) 2025-08-14 11:50:13 [INFO]: QUANTITY Updated IDs: 77560804, 77684873 2025-08-14 11:50:13 [INFO]: Successfully processed data for user 14409 2025-08-14 11:50:13 [INFO]: Execution Started 2025-08-14 11:50:13 [INFO]: Execution Finished