2025-08-08 21:00:01 [INFO]: Execution Started 2025-08-08 21:00:01 [INFO]: old server sucessfully connected 2025-08-08 21:00:01 [INFO]: sqs client sucess created 2025-08-08 21:00:02 [INFO]: Number of messages in the queue: 4 2025-08-08 21:00:02 [INFO]: item found in queue is if condition 14409 2025-08-08 21:00:02 [INFO]: item found in queue is 14409 2025-08-08 21:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBMdDLH22R9WpYajhKqHQTN70ITzRx78TgrTkisu/XmwODkv5gfx76b7gvrXoP20nm6HAqMT13SLfIkaL95/1EiwGryNmGBQdQAO3HSZYMVklQyjeHqE8xqMr7wcS36dgf781+2wsCBqr5ZeCn+EvkX9rshROvW/nTf6J5ntUM836NZftQUPB9ncg7ku+Of5vD5UTQZenlxp5JyQB86Gfpm6Ld/OOiUh/SQaZ3mot4/GQiEYFH+9ulD3DK/qutXoU80twNAQzwmlSFZCOt+ODARRsG09oxEIu/STYZknRsjg7QoLcnKhOddeHEKMWCfsZbJhjuqRjibHyFAm+IXvQtjySthw71hVXgbhFdNseX1nysQQU1xSO9+G09qhu6Sm17gw9MkeUJ1A9rO/+JfauoSCHTuU4T/TH4CK5PVfTYCAHAX+mrtA7QncXZs1XiPJw1 2025-08-08 21:00:03 [INFO]: item found in queue is if condition 14409 2025-08-08 21:00:03 [INFO]: item found in queue is 14409 2025-08-08 21:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBggkof1GDt8Lx7lyoPZzb6ENfNMG3g0aUgJz30ZoBjozC8gRaIIAyeqIbYOH3Ks3Iwf2UEqxg50Tpzbq8E6/Fq5S8vTOUU0DLgp3d68SuiN/JLmDVLIZYfvX9MWqD1zWlvoSEbU6xVE7Rl6syi/hJDEKtiiMlWK6AI+59Bb+cYmaGkBCD/xyuPl72M9135H6sC2DO9Z3z47XByDhc1t/41jAkjwXuG8FPB0mLNgZnULkdz8X+Av1V4NbzlWmk6BkLpE3JbgiPgXmO5X3mQLvee73EemT+IAhXHBc2BHfTVdui1GB0mTjzdXSvQ3iN3T8dkv+TRnVqdDX3Tlqp6OZr/4w3YvigjCXiUc5aZWdiBv8NAt1M3AptOoLtg//Xkk59+WMdhML+pUVrkqfMdFU670uHW6mgAraMu0wwgEVQoc+r0VWJW9KqMQUnLQsWYeyG 2025-08-08 21:00:03 [INFO]: item found in queue is if condition 14409 2025-08-08 21:00:03 [INFO]: item found in queue is 14409 2025-08-08 21:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBupbzjxIijcfOMIrHPocSfL9Wism08rvBhQhXxupifPQ/RrLrUxhr+iTi6kuDM31x6U/w1G05M3B5VfD3MXcC/gwTCN74ISffmBiivH9QPoAFY2HyrtXydl0+n4f4wMm/qS/By1yix0R5FOdWf4fSTigTFhwHvpgr4U0XDN5Jm/jDh8DumKJMQIIXPMi/IPOPIub+ZqwsYSa2h4Vj+vnHAK1dGjKxVWhAZwGt+3LW41jz4wCtzbC/qvlZxzYCCKXwZiZGIOp04syLqiOe2iSihDWKSW3ttrwX4hWXuelS/dJsAiPFXmQzJPBuTuh38K5f+6j8r4lAXC1iBNpXD4zn9YMU0zlQlG9ulE1clm3xxro6I2/cLHnambId/2AKuI9AESPd+ReRQ4G1oLtxyNDPNOqpUOnlm33R2ji8ddPS7uOWJlTYbRBTZmyydJ62FmWz 2025-08-08 21:00:03 [INFO]: item found in queue is if condition 14409 2025-08-08 21:00:03 [INFO]: item found in queue is 14409 2025-08-08 21:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBnpmuckXDrcLOcmP/zJkFGKi3kyoSUqbDOmRonccE1jig4/vHRb7iEmtTM/QKVndcFP0O81lp9iW3C21OanHQstXrbghEnYiQ4s6fDueEPaHJjJghYBGlMXr6MHvf4zsGQGfwAfEUlqO7AzqyuYfs8lgyR9Cv/xaRuxKfY7DWE+62TCgttv6yXPVKdNI8BXxC0EHxuuT5UVCpGDdaSxXBqMhWikxDco9PpGdUlDssTBCjqdHCH++q0B9h0JFwTlEaLJlqgNjZHEJTCFJ6LcBzZ6conFAYqegJAq05Ekwq1jzFuI0XimQnWxRIM4BDBebI59JPsVpuybsdcu1upeWEv3V2bmoCSNO+iLjhI2xDyxCelH48sD8MNOxPvmahD2GP2j/mLbVOLgD9kFWGtux41t13KZDhTU7kUwLQWtU6Yeyq94c9B1PgQBeaMRPcyVOf 2025-08-08 21:00:04 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-08 21:00:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 21:00:04 [INFO]: inside itemsold and closed 14409 2025-08-08 21:00:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 21:00:06 [INFO]: autolink for user_id 14409 is 1 2025-08-08 21:00:06 [INFO]: Ebay item id :: 305947494709 exists in Database 2025-08-08 21:00:06 [INFO]: Item is reliested :: exists in Database 2025-08-08 21:00:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 21:00:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 21:00:06 [INFO]: inside itemsold and closed 14409 2025-08-08 21:00:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 21:00:09 [INFO]: autolink for user_id 14409 is 1 2025-08-08 21:00:09 [INFO]: Ebay item id :: 225388175020 exists in Database 2025-08-08 21:00:09 [INFO]: Item is reliested :: exists in Database 2025-08-08 21:00:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 21:00:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 21:00:09 [INFO]: inside itemsold and closed 14409 2025-08-08 21:00:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 21:00:11 [INFO]: autolink for user_id 14409 is 1 2025-08-08 21:00:11 [INFO]: Ebay item id :: 286194469633 exists in Database 2025-08-08 21:00:11 [INFO]: Item is reliested :: exists in Database 2025-08-08 21:00:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 21:00:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 21:00:11 [INFO]: inside itemsold and closed 14409 2025-08-08 21:00:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 21:00:13 [INFO]: autolink for user_id 14409 is 1 2025-08-08 21:00:13 [INFO]: Ebay item id :: 305947484131 exists in Database 2025-08-08 21:00:13 [INFO]: Item is reliested :: exists in Database 2025-08-08 21:00:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 21:00:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 21:00:13 [INFO]: in processold action queue is array for {"44600214":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44600214","ebayitemid":"305947494709","shopifyproductid":"6790560776359","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"6790560776359","shopifyvariantid":"40146454053031","shopifyinventoryid":"42241686634663","shopifylocationid":"","product_id":"44600214","variant_id":"77492923","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44688684":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44688684","ebayitemid":"225388175020","shopifyproductid":"7943460782302","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"7943460782302","shopifyvariantid":"43952723951838","shopifyinventoryid":"46049172553950","shopifylocationid":"","product_id":"44688684","variant_id":"77593930","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44600219":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44600219","ebayitemid":"286194469633","shopifyproductid":"6858228236455","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"6858228236455","shopifyvariantid":"40457014509735","shopifyinventoryid":"42552536596647","shopifylocationid":"","product_id":"44600219","variant_id":"77492928","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44600212":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44600212","ebayitemid":"305947484131","shopifyproductid":"6733397393575","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"6733397393575","shopifyvariantid":"40034805940391","shopifyinventoryid":"42130016731303","shopifylocationid":"","product_id":"44600212","variant_id":"77492921","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 21:00:13 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 21:00:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 21:00:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 21:00:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 21:00:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 21:00:13 [INFO]: Shopify Inventory id 42241686634663 2025-08-08 21:00:13 [INFO]: Shopify Location id 58450641063 2025-08-08 21:00:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 21:00:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T21:00:13Z","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-08 21:00:13 [INFO]: Change: available | Delta: -1 2025-08-08 21:00:13 [INFO]: Change: on_hand | Delta: -1 2025-08-08 21:00:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 21:00:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44600214 and user_id = 14409 2025-08-08 21:00:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77492923 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 21:00:13 [INFO]: Shopify Inventory id 46049172553950 2025-08-08 21:00:13 [INFO]: Shopify Location id 58450641063 2025-08-08 21:00:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 21:00:13 [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-08 21:00:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 21:00:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44688684 and user_id = 14409 2025-08-08 21:00:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77593930 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 21:00:13 [INFO]: Shopify Inventory id 42552536596647 2025-08-08 21:00:13 [INFO]: Shopify Location id 58450641063 2025-08-08 21:00:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 21:00:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T21:00:14Z","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-08 21:00:14 [INFO]: Change: available | Delta: -1 2025-08-08 21:00:14 [INFO]: Change: on_hand | Delta: -1 2025-08-08 21:00:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 21:00:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44600219 and user_id = 14409 2025-08-08 21:00:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77492928 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 21:00:14 [INFO]: Shopify Inventory id 42130016731303 2025-08-08 21:00:14 [INFO]: Shopify Location id 58450641063 2025-08-08 21:00:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 21:00:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T21:00:14Z","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-08 21:00:14 [INFO]: Change: available | Delta: -1 2025-08-08 21:00:14 [INFO]: Change: on_hand | Delta: -1 2025-08-08 21:00:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 21:00:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44600212 and user_id = 14409 2025-08-08 21:00:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77492921 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 21:00:14 [INFO]: updateIdsQuantity -> ["77492923","77593930","77492928","77492921"] 2025-08-08 21:00:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 3 2025-08-08 21:00:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77492923 THEN 0 WHEN id = 77593930 THEN 0 WHEN id = 77492928 THEN 0 WHEN id = 77492921 THEN 0 END, quantityflag = CASE WHEN id = 77492923 THEN 0 WHEN id = 77593930 THEN 0 WHEN id = 77492928 THEN 0 WHEN id = 77492921 THEN 0 END WHERE user_id = 14409 AND id IN (77492923,77593930,77492928,77492921) 2025-08-08 21:00:14 [INFO]: QUANTITY Updated IDs: 77492923, 77593930, 77492928, 77492921 2025-08-08 21:00:14 [INFO]: Successfully processed data for user 14409 2025-08-08 21:00:14 [INFO]: Execution Started 2025-08-08 21:00:14 [INFO]: Execution Finished 2025-08-08 21:10:02 [INFO]: Execution Started 2025-08-08 21:10:02 [INFO]: old server sucessfully connected 2025-08-08 21:10:02 [INFO]: sqs client sucess created 2025-08-08 21:10:03 [INFO]: Number of messages in the queue: 2 2025-08-08 21:10:03 [INFO]: item found in queue is if condition 14409 2025-08-08 21:10:03 [INFO]: item found in queue is 14409 2025-08-08 21:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEB0J7wjmUBkxJ5RVANdW3dXDDtvPtxolcXzdGl0OWor/23xuIRyHCkg1bGZ7s1mW4nB4D2wthTdt9Ew+AAELWcKlZnNSu4eDh29yUbHvm2bvTCpFHPPqdKfmjahAFKgrhql7UTJaMOlx9gnA7qR6Yaie6vLuZGrXKbr5AIcSFU7433geo95z3+e5jACNTRgDLMLubwz+AEKBv9WtIc++hOrfS5DWE5+kNYrgGYpwquua6NDYDYxu/YbPyY6Z2Qw+KnmiWJ0WU4nYjLQUMIzYaRfFB0USsmnmiN8d8BKstx4gU92trYqhIfg85+jW5l6Qw+KALR6Exn9iyVjiZRSzwK5DNJ3aRdrWbwIEh88dK8L6mOhwDbEs/n2U38ewl1bCsbK7eCFWhHYKbcmaj9XEx1vX3nhmx/va7GThWFnOhFscvnJCmT0wGEyIbAs8D+/Myj 2025-08-08 21:10:04 [INFO]: item found in queue is if condition 14409 2025-08-08 21:10:04 [INFO]: item found in queue is 14409 2025-08-08 21:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBSLyc9HAZL1gKNnVUa/DrRlFREHlO5J71uv50PQqaTfZJp1WcVAvWNqsPw4qpa46YxSueSqfWr/FPpy33fubsbAXvsBvyLh7kZIrIdFDU98P2Am9NWHEQi/6edR/0WdCLFrT1pVusFGUP8ld/pzVCXVLy6srMoNS6J6cyb+pcklKW+8VGai7MYiBXutsRs5KyuGdRD6ij0v6SlhlMuXoQxscYTmgjUYGBN43T55qu5beAvPY75vJolP/TpFgWU/UpcBjRY1uounU3Yy19yQeF5SW6IyEzko7uQDu/F5OGsccn0br25xKe9I5ICkRf1ene682fjMM/Om0uHJ01hXnbOvq4sEBg3w23LEij3GSUZLrkt23+X+aTDVKwallf64TcopnUXcFYJhSIKDYe9uQNpFj9gaovNtqKqJCgCgk+KAaPpTES4uHzIA7Ucv3TxZNW 2025-08-08 21:10:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-08 21:10:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 21:10:04 [INFO]: inside itemsold and closed 14409 2025-08-08 21:10:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 21:10:06 [INFO]: autolink for user_id 14409 is 1 2025-08-08 21:10:06 [INFO]: Ebay item id :: 286194972893 exists in Database 2025-08-08 21:10:06 [INFO]: Item is reliested :: exists in Database 2025-08-08 21:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 21:10:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 21:10:06 [INFO]: inside itemsold and closed 14409 2025-08-08 21:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 21:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-08 21:10:07 [INFO]: Ebay item id :: 286194969352 exists in Database 2025-08-08 21:10:07 [INFO]: Item is reliested :: exists in Database 2025-08-08 21:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 21:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 21:10:07 [INFO]: in processold action queue is array for {"44600709":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44600709","ebayitemid":"286194972893","shopifyproductid":"8150914662622","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"8150914662622","shopifyvariantid":"44400422355166","shopifyinventoryid":"46498221293790","shopifylocationid":"","product_id":"44600709","variant_id":"77493418","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44600704":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44600704","ebayitemid":"286194969352","shopifyproductid":"8015340667102","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"8015340667102","shopifyvariantid":"44142408499422","shopifyinventoryid":"46239314346206","shopifylocationid":"","product_id":"44600704","variant_id":"77493413","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 21:10:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 21:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 21:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 21:10:07 [INFO]: Shopify Inventory id 46498221293790 2025-08-08 21:10:07 [INFO]: Shopify Location id 58450641063 2025-08-08 21:10:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 21:10:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T21:10:08Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-08 21:10:08 [INFO]: Change: available | Delta: -1 2025-08-08 21:10:08 [INFO]: Change: on_hand | Delta: -1 2025-08-08 21:10:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 21:10:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44600709 and user_id = 14409 2025-08-08 21:10:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77493418 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 21:10:08 [INFO]: Shopify Inventory id 46239314346206 2025-08-08 21:10:08 [INFO]: Shopify Location id 58450641063 2025-08-08 21:10:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 21:10:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T21:10:08Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-08 21:10:08 [INFO]: Change: available | Delta: -1 2025-08-08 21:10:08 [INFO]: Change: on_hand | Delta: -1 2025-08-08 21:10:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 21:10:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44600704 and user_id = 14409 2025-08-08 21:10:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77493413 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 21:10:08 [INFO]: updateIdsQuantity -> ["77493418","77493413"] 2025-08-08 21:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-08 21:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77493418 THEN 0 WHEN id = 77493413 THEN 0 END, quantityflag = CASE WHEN id = 77493418 THEN 0 WHEN id = 77493413 THEN 0 END WHERE user_id = 14409 AND id IN (77493418,77493413) 2025-08-08 21:10:08 [INFO]: QUANTITY Updated IDs: 77493418, 77493413 2025-08-08 21:10:08 [INFO]: Successfully processed data for user 14409 2025-08-08 21:10:08 [INFO]: Execution Started 2025-08-08 21:10:08 [INFO]: Execution Finished 2025-08-08 21:20:01 [INFO]: Execution Started 2025-08-08 21:20:01 [INFO]: old server sucessfully connected 2025-08-08 21:20:01 [INFO]: sqs client sucess created 2025-08-08 21:20:02 [INFO]: Number of messages in the queue: 4 2025-08-08 21:20:03 [INFO]: item found in queue is if condition 14409 2025-08-08 21:20:03 [INFO]: item found in queue is 14409 2025-08-08 21:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBisHcOLWSPeMKfENNE19yBaK9eYMQSQV5Vy15PhWyfU2Ki0hjdf2dEG2kZdNJrEbom+G/kEqbOURF0QWkX00jYfk96UTpt9iuGiTmsbUd/om57OlConJdqbmfKtR1GWFrHwtC/s81jsIMxaYpLmg/Pg0h5fOUEIyrM5na0Precb0sQn/lVKh9ty489hUe+Yr/KdVyuU7qzQjs/cIvmmL2bsGmnsOClf2DOeoHCiJeX92Eu3LU2+rAFPklEFMk7Hdy2+Y9DWgQvpRCuvHkKSiipXYjIC2YbjXE58mCbYs1oEPp+OLsw8vbRlAOFj1PWk0Ql/FhwaSckxmGFxks9yLtrYPp3/DPv5c5h52yx7mD1B5nGgk3g15oXiD/mRyQmpzI9zAMI9u6fudEtiNY8r46Ioa1y1Vhi/rd/96NUDgI17McDODWOLnN5lKhNZXCpyqW 2025-08-08 21:20:03 [INFO]: item found in queue is if condition 14409 2025-08-08 21:20:03 [INFO]: item found in queue is 14409 2025-08-08 21:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBLldXBibmF1PERwArVN2O7LLfLQYzxyZFUdrezuMRlkmJ6PnlNqZRX1EShwbasUZ76XOItWmIKEglaGhdXf5gksdc2iPnNZARSzW65pflMLHkPuESnm15xEDZ4Xz4sa8S2uC08PwVLUojjjXFpxfzwpZm/Rd1ptnAyrJlxSvI2/VBhoA/rz6kBSRJx4uQ9HMrDDoPMhpAELpVAK92yW55+vbQtSvidH4WUgvlfSUuVLqy1nAhKrVnXGaJaMAI3HJU4ydZUz62dlyRtEFESnsxSv2DBwM6FQ3aHNSXBhz798kHCZ4X0b5HhfM7VoG0gi++2ZHpzmSFDyEzdePJmtENoVuUW2Pi6svNmYTGQ1SniCB7B8PD/3aWz8BN45v2ReNcyFra3Mrq9w6ZTM2UzX5KH+nyDIl8e5JTHc8YGx78QvKdIFWwX6EHyEmFhKNEGGY1 2025-08-08 21:20:04 [INFO]: item found in queue is if condition 14409 2025-08-08 21:20:04 [INFO]: item found in queue is 14409 2025-08-08 21:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEB85PeQ9KlwPbX5zcimepDMdnltKqqtqeHAU8Cj112/ITet+xV6a1VHay26a3sKed7qyeZzW6a10o1MQ/0Od7P8AH1etYdbEkX/nLBo0UcWqfKxvGmNwRDnBbmBqQDm8WWQYlpMst+OUWSwhvZMx/jIzStH3zLVTE5LaeEi9dZlCOEgAFvEJiaxIUSIlmYj30kLAbh2xaSENtW/LaHgVmtAg3ZPrs10gqfRAC7P/6gZfmuKXGL/sanDTHn1v1rxbD/k03GnnjH6D8wi2SWl2NNLkz4zxsOc5r8lMeWNrryUsodXuVcYO3IM3BDD8vWSxsmNEkJ5rkB65IBPmBDNGBFrPpil9YkVzPPuQ2UbU2A5DESg3APS1JOOs4yz7RlOtlxp9F5k8mpWtKWWhFGm2YXWcMz+uwYIZ7StpvHuHwvqLLjth8v+3Q/3E/l53TT95d9 2025-08-08 21:20:04 [INFO]: item found in queue is if condition 14409 2025-08-08 21:20:04 [INFO]: item found in queue is 14409 2025-08-08 21:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBqtNyT9mrxBzPhFLem7owBsYZAkcbcce5FCnzRTzd4l7dkp4/kjRgBUpgXDR+yQIWuD+UlanJVAv+SSMWUdcaA0e/fHjSQ/Q++WVL7QCFl4br6We8vLxq17Srd06ELuTmHzyVhiUWlK7wpNfNvzxBt7WZBPLsXVixmcOpXkx6gb/8G5eLVxuF7PMUdh2C8sO9ZXteUUOmWUIwkOa5aALpzQW+zoTsYAbINeEk8n64iQ9dQUhe87jIADnT/jb28VFRh8188Uznse2er2lz7tnio9FCLD0zMi/sXuYejyIyfczeDgglZQve3y07CKHmbWAPw1XB5jZv7jjMEDXC08h8mGdtt2ThvtlNZknydoeQSNUjOGC4Z8YAI1CUq8vZx71PYOCI98YO6CJ9mMkgwXxzADJFpMTgPw+MO/LdHAMhHvXz4+iH+2+JUFoyBhE6NI4s 2025-08-08 21:20:04 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-08 21:20:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 21:20:04 [INFO]: inside itemsold and closed 14409 2025-08-08 21:20:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 21:20:06 [INFO]: autolink for user_id 14409 is 1 2025-08-08 21:20:06 [INFO]: Ebay item id :: 305948035522 exists in Database 2025-08-08 21:20:06 [INFO]: Item is reliested :: exists in Database 2025-08-08 21:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 21:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 21:20:06 [INFO]: inside itemsold and closed 14409 2025-08-08 21:20:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 21:20:08 [INFO]: autolink for user_id 14409 is 1 2025-08-08 21:20:08 [INFO]: Ebay item id :: 305947553768 exists in Database 2025-08-08 21:20:08 [INFO]: Item is reliested :: exists in Database 2025-08-08 21:20:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 21:20:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 21:20:08 [INFO]: inside itemsold and closed 14409 2025-08-08 21:20:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 21:20:10 [INFO]: autolink for user_id 14409 is 1 2025-08-08 21:20:10 [INFO]: Ebay item id :: 286194962933 exists in Database 2025-08-08 21:20:10 [INFO]: Item is reliested :: exists in Database 2025-08-08 21:20:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 21:20:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 21:20:10 [INFO]: inside itemsold and closed 14409 2025-08-08 21:20:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 21:20:11 [INFO]: autolink for user_id 14409 is 1 2025-08-08 21:20:11 [INFO]: Ebay item id :: 286194957348 exists in Database 2025-08-08 21:20:11 [INFO]: Item is reliested :: exists in Database 2025-08-08 21:20:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 21:20:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 21:20:11 [INFO]: in processold action queue is array for {"44600696":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44600696","ebayitemid":"305948035522","shopifyproductid":"8016380428510","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"8016380428510","shopifyvariantid":"44144747315422","shopifyinventoryid":"46241651327198","shopifylocationid":"","product_id":"44600696","variant_id":"77493405","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44600249":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44600249","ebayitemid":"305947553768","shopifyproductid":"7639683563742","variants":[{"price":"69.99","quantity":0,"weight":"2","shopifyproductid":"7639683563742","shopifyvariantid":"42754643886302","shopifyinventoryid":"44849133519070","shopifylocationid":"","product_id":"44600249","variant_id":"77492958","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44600691":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44600691","ebayitemid":"286194962933","shopifyproductid":"7683760750814","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"7683760750814","shopifyvariantid":"42930236096734","shopifyinventoryid":"45025251623134","shopifylocationid":"","product_id":"44600691","variant_id":"77493400","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44604905":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44604905","ebayitemid":"286194957348","shopifyproductid":"8044137447646","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"8044137447646","shopifyvariantid":"44194599272670","shopifyinventoryid":"46291668107486","shopifylocationid":"","product_id":"44604905","variant_id":"77499856","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 21:20:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 21:20:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 21:20:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 21:20:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 21:20:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 21:20:12 [INFO]: Shopify Inventory id 46241651327198 2025-08-08 21:20:12 [INFO]: Shopify Location id 58450641063 2025-08-08 21:20:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 21:20:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T21:20:12Z","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-08 21:20:12 [INFO]: Change: available | Delta: -1 2025-08-08 21:20:12 [INFO]: Change: on_hand | Delta: -1 2025-08-08 21:20:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 21:20:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44600696 and user_id = 14409 2025-08-08 21:20:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77493405 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 21:20:12 [INFO]: Shopify Inventory id 44849133519070 2025-08-08 21:20:12 [INFO]: Shopify Location id 58450641063 2025-08-08 21:20:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 21:20:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T21:20:12Z","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-08 21:20:12 [INFO]: Change: available | Delta: -1 2025-08-08 21:20:12 [INFO]: Change: on_hand | Delta: -1 2025-08-08 21:20:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 21:20:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44600249 and user_id = 14409 2025-08-08 21:20:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77492958 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 21:20:12 [INFO]: Shopify Inventory id 45025251623134 2025-08-08 21:20:12 [INFO]: Shopify Location id 58450641063 2025-08-08 21:20:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 21:20:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T21:20:12Z","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-08 21:20:12 [INFO]: Change: available | Delta: -1 2025-08-08 21:20:12 [INFO]: Change: on_hand | Delta: -1 2025-08-08 21:20:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 21:20:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44600691 and user_id = 14409 2025-08-08 21:20:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77493400 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 21:20:12 [INFO]: Shopify Inventory id 46291668107486 2025-08-08 21:20:12 [INFO]: Shopify Location id 58450641063 2025-08-08 21:20:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 21:20:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T21:20:13Z","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-08 21:20:13 [INFO]: Change: available | Delta: -1 2025-08-08 21:20:13 [INFO]: Change: on_hand | Delta: -1 2025-08-08 21:20:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 21:20:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44604905 and user_id = 14409 2025-08-08 21:20:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77499856 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 21:20:13 [INFO]: updateIdsQuantity -> ["77493405","77492958","77493400","77499856"] 2025-08-08 21:20:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4 2025-08-08 21:20:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77493405 THEN 0 WHEN id = 77492958 THEN 0 WHEN id = 77493400 THEN 0 WHEN id = 77499856 THEN 0 END, quantityflag = CASE WHEN id = 77493405 THEN 0 WHEN id = 77492958 THEN 0 WHEN id = 77493400 THEN 0 WHEN id = 77499856 THEN 0 END WHERE user_id = 14409 AND id IN (77493405,77492958,77493400,77499856) 2025-08-08 21:20:13 [INFO]: QUANTITY Updated IDs: 77493405, 77492958, 77493400, 77499856 2025-08-08 21:20:13 [INFO]: Successfully processed data for user 14409 2025-08-08 21:20:13 [INFO]: Execution Started 2025-08-08 21:20:13 [INFO]: Execution Finished 2025-08-08 21:30:01 [INFO]: Execution Started 2025-08-08 21:30:01 [INFO]: old server sucessfully connected 2025-08-08 21:30:01 [INFO]: sqs client sucess created 2025-08-08 21:30:02 [INFO]: Number of messages in the queue: 5 2025-08-08 21:30:03 [INFO]: item found in queue is if condition 14409 2025-08-08 21:30:03 [INFO]: item found in queue is 14409 2025-08-08 21:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEB9qyDikR7GC6DnSA8gfdaQIJEEr3FOP1W9cFPzAPgCuI21ZuToToipRCgyve/WjDeEVB9H6pWMvw7iQ2MS3QVWeYNBVrxRjAp6coCQXYe7L7wK1/99u9HyGfbY1bg9PHd54DXGBK20funemvfUalEUOFNqtmdmjpsrhdS+C5mNbKBM99ZjHfVD3K0jvYVAe3Zih9AkZ+lOKJHUIXD8mmYcdOoc9cuWBfgkpF3Wr627+SGn4P7VHBwtqXZPq3XVkLF7WiTw/78LkFCw3CHpPV/OD+Es7p30jJPfnXGUOAl5J3yFORvq+r5dFp399uOAoATM8Djc1r2Y0JvDoJtwDc+dMSnFgkps1q7G+J5W5rjI6GvYC0cd+gdXfp4Q1EcmXHOERP8i8MP5IffqdHS3dPXHNeH1N9NjTSTabYv9RvQcCk2ZvaXsa/jIImLBduTgyY/ 2025-08-08 21:30:03 [INFO]: item found in queue is if condition 14409 2025-08-08 21:30:03 [INFO]: item found in queue is 14409 2025-08-08 21:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBuDzYSbChAod9JgiZeAMKbkEFvJTY+6RctMeMzUsaCv0g9WkjVd/HmhPlUez8WB3m1NVGAUxc6bvDJ1zuFgRMowDQpLtYH2qWiNjlT7BGsc3+NNwR3uvb3nkilUIFm3SSYgwjyscT/e54YxXkFWC5h+prArfCV9p2BzI9oXbHUhwf+Ukkge+xdgaCh36bCDTTehquDx+6a0AcfbA99iVnMIz//LTT6gcOo5YaGlHkhPzNeiShdlUtizWIasFeQaGgrcrrB5kTdteoCA6LKuyZYDvIUYXcwW8QWz7WsumKvgPfaYDg2jffPw8hQvqxDg7j64b168r0lnl6Yu1KjGzNdpFV+FJfvPHBIM0O7SiCNw4RbBoFp5F33mWECFu79jMGtuyievp//iTBKBBr1lvOS11ILHOxA4vrbO4oC5Z5WTHD3pmXfwaGkJieZFH8L0G5 2025-08-08 21:30:04 [INFO]: item found in queue is if condition 14409 2025-08-08 21:30:04 [INFO]: item found in queue is 14409 2025-08-08 21:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBQXCkXWQDs6JcimPyfMwYBmQi5gyHI78nQkeUQeqoXt0Nks2jvGmZca88mKHk9ZAIiCyBnIRkGdJXCnXUPj67JMna+ri8guPNL3s7dqgynhxyYNLPojJ6ay99gPyITHDXqpFG1Cwy0oLqEOs09I8F3aDm1q3r3TvXGH8aHe3H5wR5Sx5oELs+9kKr5mHOtG7eQQv8mzL3LMI0jlan8WGQ4SQDCK4k/wM3Y+1kg9KNTauIqO+XH21jTeBF8caJ0sY9XWtKwqSrjMnapHftZ87/7U2HH25qO4wpQlPfS4ezVdtwil12R9oxMAJ6Fx2mvH1sHh/PUh+4ZLGUSGrLaH6TIqVEnoANQAxRQvVFPDGNl4KVNrwLklU98ILZJZNIAu/XmdF8NmXhsS6EHPIjsIDVjQjmUVCn9MtKvrebWbPY7xYKy8by2WN7aRlvUK9uSAbJ 2025-08-08 21:30:04 [INFO]: item found in queue is if condition 14409 2025-08-08 21:30:04 [INFO]: item found in queue is 14409 2025-08-08 21:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBhGE4DBxYLQysmTmQ+vLVRI1F7Lk6LbigLGbgiOiIClFCpwCyN5n4S3Nk8fY8ooWsg207Ur2vZ9qAM7CT3xenyskvsdrv8NxHD2jAENRl0moyA/k2PpInldRcgTeVf4+2+M/BrubN4+MJ+Q2mApzRWB7MUBeOGi/GEsbvuhj5iiDu9KJ+44sD2bnikHOW2GyhxWWeAXhEthw7eUMatVQpLyoj1LMMnDIbJAJ2m56lOQ2qafKeCc0wKqrJbabMPAWwpGk21CXZWv2or0KOHF9tvhXAsLiT49Zpgl9D8sAKSDqHAQm3H2LES106yUcRqH0Xa/L3ikBfniS7ZAAR92QPSfueGJbROSsin+teL0lLkp8d9iC5/Aa+zAUKYkR/qdq4a52SssXDme68MzEgtiXUAbl1OOC7vdOjmcJJPHeZ62e6D1udX8yc1UTs//A6DWEX 2025-08-08 21:30:05 [INFO]: item found in queue is if condition 14409 2025-08-08 21:30:05 [INFO]: item found in queue is 14409 2025-08-08 21:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBC9nJYCR2+7KQobx29MrQu54lAz1jSkaiKsoMlMPiiQ07sqO83rjJuAkVHdlQYVpFk20A9itbK9r++htXFa2IG1jir6bu3XAzOmcevubETnbBADbLhHU0omJgz0UuHuoi7sjU05PWuxPJIYwFr2S6HXeiS0sNsfPzod1CWY815QptMS3imGttG3D7HSrNOQli+kG/5rcfKM8bu+lY4MDHBBxcppkHcjHHLjlk0ls6ubl0yW6cfKmyI+oLPMu9nn/Oxr8LYssiih60/54uDOXZp0oJX8FCexfKodVJtYSEtDagU5t+zSMGYd+/YVQmP/nU83suUCBJ+rkQrGkFTXKIsMZJU0sYG/PRWndsAaei4SIkTkfDL8tUcLgTUpGlvCeljJsVDB0/HfkRq6hI5gqeGUa9tt9ea+sSbMmWo10lcEMd93vGfg8PZA+OImdVV6ir 2025-08-08 21:30:05 [INFO]: Processed 5 messages, reached the limit of 5. 2025-08-08 21:30:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 21:30:05 [INFO]: inside itemsold and closed 14409 2025-08-08 21:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 21:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-08 21:30:07 [INFO]: Ebay item id :: 286656092798 exists in Database 2025-08-08 21:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-08 21:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 21:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 21:30:07 [INFO]: inside itemsold and closed 14409 2025-08-08 21:30:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 21:30:09 [INFO]: autolink for user_id 14409 is 1 2025-08-08 21:30:09 [INFO]: Ebay item id :: 326104016369 exists in Database 2025-08-08 21:30:09 [INFO]: Item is reliested :: exists in Database 2025-08-08 21:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 21:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 21:30:09 [INFO]: inside itemsold and closed 14409 2025-08-08 21:30:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 21:30:11 [INFO]: autolink for user_id 14409 is 1 2025-08-08 21:30:11 [INFO]: Ebay item id :: 305948125329 exists in Database 2025-08-08 21:30:11 [INFO]: Item is reliested :: exists in Database 2025-08-08 21:30:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 21:30:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 21:30:11 [INFO]: inside itemsold and closed 14409 2025-08-08 21:30:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 21:30:13 [INFO]: autolink for user_id 14409 is 1 2025-08-08 21:30:13 [INFO]: Ebay item id :: 286213283574 exists in Database 2025-08-08 21:30:13 [INFO]: Item is reliested :: exists in Database 2025-08-08 21:30:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 21:30:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 21:30:13 [INFO]: inside itemsold and closed 14409 2025-08-08 21:30:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 21:30:15 [INFO]: autolink for user_id 14409 is 1 2025-08-08 21:30:15 [INFO]: Ebay item id :: 405514734800 exists in Database 2025-08-08 21:30:15 [INFO]: Item is reliested :: exists in Database 2025-08-08 21:30:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 21:30:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 21:30:15 [INFO]: in processold action queue is array for {"44773090":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44773090","ebayitemid":"286656092798","shopifyproductid":"8475822751966","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8475822751966","shopifyvariantid":"45341517742302","shopifyinventoryid":"47439464333534","shopifylocationid":"","product_id":"44773090","variant_id":"77681632","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44677543":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44677543","ebayitemid":"326104016369","shopifyproductid":"8450289008862","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8450289008862","shopifyvariantid":"45275581087966","shopifyinventoryid":"47373500023006","shopifylocationid":"","product_id":"44677543","variant_id":"77582763","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44600796":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44600796","ebayitemid":"305948125329","shopifyproductid":"7689541845214","variants":[{"price":"69.99","quantity":0,"weight":"2","shopifyproductid":"7689541845214","shopifyvariantid":"42951496663262","shopifyinventoryid":"45046586212574","shopifylocationid":"","product_id":"44600796","variant_id":"77493505","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44638819":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44638819","ebayitemid":"286213283574","shopifyproductid":"8097872642270","variants":[{"price":"49.99","quantity":0,"weight":"3","shopifyproductid":"8097872642270","shopifyvariantid":"44287679594718","shopifyinventoryid":"46384857088222","shopifylocationid":"","product_id":"44638819","variant_id":"77544008","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44785289":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44785289","ebayitemid":"405514734800","shopifyproductid":"7673679642846","variants":[{"price":"44.99","quantity":0,"weight":"3","shopifyproductid":"7673679642846","shopifyvariantid":"42892865536222","shopifyinventoryid":"44987697070302","shopifylocationid":"","product_id":"44785289","variant_id":"77694729","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 21:30:15 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 21:30:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 21:30:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 21:30:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 21:30:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 21:30:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 21:30:15 [INFO]: Shopify Inventory id 47439464333534 2025-08-08 21:30:15 [INFO]: Shopify Location id 58450641063 2025-08-08 21:30:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 21:30:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T21: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":1989,"restoreRate":100}}}} 2025-08-08 21:30:15 [INFO]: Change: available | Delta: -1 2025-08-08 21:30:15 [INFO]: Change: on_hand | Delta: -1 2025-08-08 21:30:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 21:30:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44773090 and user_id = 14409 2025-08-08 21:30:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681632 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 21:30:15 [INFO]: Shopify Inventory id 47373500023006 2025-08-08 21:30:15 [INFO]: Shopify Location id 58450641063 2025-08-08 21:30:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 21:30:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T21: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":1989,"restoreRate":100}}}} 2025-08-08 21:30:15 [INFO]: Change: available | Delta: -1 2025-08-08 21:30:15 [INFO]: Change: on_hand | Delta: -1 2025-08-08 21:30:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 21:30:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44677543 and user_id = 14409 2025-08-08 21:30:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77582763 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 21:30:15 [INFO]: Shopify Inventory id 45046586212574 2025-08-08 21:30:15 [INFO]: Shopify Location id 58450641063 2025-08-08 21:30:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 21:30:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T21:30:16Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1932,"restoreRate":100}}}} 2025-08-08 21:30:16 [INFO]: Change: available | Delta: -1 2025-08-08 21:30:16 [INFO]: Change: on_hand | Delta: -1 2025-08-08 21:30:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 21:30:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44600796 and user_id = 14409 2025-08-08 21:30:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77493505 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 21:30:16 [INFO]: Shopify Inventory id 46384857088222 2025-08-08 21:30:16 [INFO]: Shopify Location id 58450641063 2025-08-08 21:30:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 21:30:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T21:30:16Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-08 21:30:16 [INFO]: Change: available | Delta: -1 2025-08-08 21:30:16 [INFO]: Change: on_hand | Delta: -1 2025-08-08 21:30:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 21:30:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44638819 and user_id = 14409 2025-08-08 21:30:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77544008 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 21:30:16 [INFO]: Shopify Inventory id 44987697070302 2025-08-08 21:30:16 [INFO]: Shopify Location id 58450641063 2025-08-08 21:30:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 21:30:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T21:30:16Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-08 21:30:16 [INFO]: Change: available | Delta: -1 2025-08-08 21:30:16 [INFO]: Change: on_hand | Delta: -1 2025-08-08 21:30:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 21:30:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44785289 and user_id = 14409 2025-08-08 21:30:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77694729 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 21:30:16 [INFO]: updateIdsQuantity -> ["77681632","77582763","77493505","77544008","77694729"] 2025-08-08 21:30:16 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 5. Affected rows: 5 2025-08-08 21:30:16 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77681632 THEN 0 WHEN id = 77582763 THEN 0 WHEN id = 77493505 THEN 0 WHEN id = 77544008 THEN 0 WHEN id = 77694729 THEN 0 END, quantityflag = CASE WHEN id = 77681632 THEN 0 WHEN id = 77582763 THEN 0 WHEN id = 77493505 THEN 0 WHEN id = 77544008 THEN 0 WHEN id = 77694729 THEN 0 END WHERE user_id = 14409 AND id IN (77681632,77582763,77493505,77544008,77694729) 2025-08-08 21:30:16 [INFO]: QUANTITY Updated IDs: 77681632, 77582763, 77493505, 77544008, 77694729 2025-08-08 21:30:16 [INFO]: Successfully processed data for user 14409 2025-08-08 21:30:16 [INFO]: Execution Started 2025-08-08 21:30:16 [INFO]: Execution Finished 2025-08-08 21:40:01 [INFO]: Execution Started 2025-08-08 21:40:01 [INFO]: old server sucessfully connected 2025-08-08 21:40:01 [INFO]: sqs client sucess created 2025-08-08 21:40:02 [INFO]: Number of messages in the queue: 0 2025-08-08 21:40:22 [INFO]: Execution Started 2025-08-08 21:40:22 [INFO]: Execution Finished 2025-08-08 21:50:01 [INFO]: Execution Started 2025-08-08 21:50:01 [INFO]: old server sucessfully connected 2025-08-08 21:50:01 [INFO]: sqs client sucess created 2025-08-08 21:50:03 [INFO]: Number of messages in the queue: 2 2025-08-08 21:50:03 [INFO]: item found in queue is if condition 14409 2025-08-08 21:50:03 [INFO]: item found in queue is 14409 2025-08-08 21:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBGzmEG6kjUidcOqFWsgSWnkGr11gSKKcSKBv4uZzYF5uCqq9Lzmccl+4csvngLledKieOA7TRhltkkwPPyG3QpgHopkyUq80yaBukgGDnk/R5TT2F6j5TAq98fruPUYiDY+ZNqU11wdnmHbUcguhleIUBvQDmqsT09/NIT9f2CkvmSqVAo6IUqskxJ3EdeRyvvKSjUAXbqyDbuCqdV+jMQiHFxP9FJNQsxn27PiOw6VsbraZELYyb/BA8Vc5FFKp3QoBdiu1Yt7mYJNpiSrhkjWalChIBcuvHWe0BepWKrkF/DF7gZ7Nb04FYjxsbmVSZAy7LshbfIIJdsDcTIPnvn8NwyYh9V0XBHeE4dKfblFeCZAv4BhYSOQ41ZfKIERzeu4T7OGAsrrFw5/UHCv/64g0+rSQhSOxHeHgIaIwTEqn6woVx6E2F3YM6gN1HuyvT 2025-08-08 21:50:03 [INFO]: item found in queue is if condition 14409 2025-08-08 21:50:03 [INFO]: item found in queue is 14409 2025-08-08 21:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBqRXnql7Bl104aE3YR4QDfbGNI+9eEMW4pU4+CVnj5QzS3tk3D0LqMdRKlNcXhYyIW4tT4uMZF+uoQr4d4vWo8baDD4vwD6MMsaSo/Xrsrv1JGLmFvLqoi8fVS1boHmT+zGnLvyOQ+1/+iDn7o1Ux1IJ77EABUrVI9wioTrEX0pQjRh59UVEFaZHOSc3+PsgV4/mSogNj/mdt1c9zngH4NycmkE8Rdm7KEQPdIrpReVs33UokySMafURqzbuukvFLGCoeRg4b3ah+YdOq2B0p9cGB1NXghMT+qDkMlhHclImrSNNg4/4Q97KxDzfKfwGaeq2K5cVaBj4bEcI/Z3KEstPlF0tYFd1/r5mWXO+GC7Sj3U45AyTopW4a81aGdNRRIaKlYj4F99afEpPvRktsad+0fhuvXUnYbspqq1bcEac2vfnlA4NzGWTerXbGWe/J 2025-08-08 21:50:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-08 21:50:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 21:50:04 [INFO]: inside itemsold and closed 14409 2025-08-08 21:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 21:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-08 21:50:05 [INFO]: Ebay item id :: 284486416401 exists in Database 2025-08-08 21:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-08 21:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 21:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 21:50:05 [INFO]: inside itemsold and closed 14409 2025-08-08 21:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 21:50:07 [INFO]: autolink for user_id 14409 is 1 2025-08-08 21:50:07 [INFO]: Ebay item id :: 284487789459 exists in Database 2025-08-08 21:50:07 [INFO]: Item is reliested :: exists in Database 2025-08-08 21:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 21:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 21:50:07 [INFO]: in processold action queue is array for {"44569999":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44569999","ebayitemid":"284486416401","shopifyproductid":"7100416458919","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"7100416458919","shopifyvariantid":"41542437339303","shopifyinventoryid":"43638924574887","shopifylocationid":"","product_id":"44569999","variant_id":"77462683","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44571521":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44571521","ebayitemid":"284487789459","shopifyproductid":"7102651596967","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"7102651596967","shopifyvariantid":"41551686238375","shopifyinventoryid":"43648174456999","shopifylocationid":"","product_id":"44571521","variant_id":"77464205","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 21:50:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 21:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 21:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 21:50:07 [INFO]: Shopify Inventory id 43638924574887 2025-08-08 21:50:07 [INFO]: Shopify Location id 58450641063 2025-08-08 21:50:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 21:50:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T21:50:07Z","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-08 21:50:08 [INFO]: Change: available | Delta: -1 2025-08-08 21:50:08 [INFO]: Change: on_hand | Delta: -1 2025-08-08 21:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 21:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44569999 and user_id = 14409 2025-08-08 21:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77462683 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 21:50:08 [INFO]: Shopify Inventory id 43648174456999 2025-08-08 21:50:08 [INFO]: Shopify Location id 58450641063 2025-08-08 21:50:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 21:50:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T21:50: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-08 21:50:08 [INFO]: Change: available | Delta: -1 2025-08-08 21:50:08 [INFO]: Change: on_hand | Delta: -1 2025-08-08 21:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 21:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44571521 and user_id = 14409 2025-08-08 21:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77464205 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 21:50:08 [INFO]: updateIdsQuantity -> ["77462683","77464205"] 2025-08-08 21:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-08 21:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77462683 THEN 0 WHEN id = 77464205 THEN 0 END, quantityflag = CASE WHEN id = 77462683 THEN 0 WHEN id = 77464205 THEN 0 END WHERE user_id = 14409 AND id IN (77462683,77464205) 2025-08-08 21:50:08 [INFO]: QUANTITY Updated IDs: 77462683, 77464205 2025-08-08 21:50:08 [INFO]: Successfully processed data for user 14409 2025-08-08 21:50:08 [INFO]: Execution Started 2025-08-08 21:50:08 [INFO]: Execution Finished