2025-08-14 21:00:02 [INFO]: Execution Started 2025-08-14 21:00:02 [INFO]: old server sucessfully connected 2025-08-14 21:00:02 [INFO]: sqs client sucess created 2025-08-14 21:00:03 [INFO]: Number of messages in the queue: 4 2025-08-14 21:00:03 [INFO]: item found in queue is if condition 14409 2025-08-14 21:00:03 [INFO]: item found in queue is 14409 2025-08-14 21:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBAwQd0Jr1NdZJv+QoG9RdCBqtJ2PB+HJqE0PUtPvw4i047nCOQ8oSp9lavVLylTj0XdOkAl+mjVoTCaCzQGC21Mv0YbxAX7EHPIJ+u+MHnja/9Vvm0AGoTtc0gfxLUVCQYIoXJfxexN1ufVyEK4fjj1yRUaCqipKfl3exBjZjtdin4GLkta2LTL24VE7H46xmrjXHfBUjaZjAhUwstHGmQfzTRfRtjgtCqBfhAfk6qx502zBz5gi3YIXxAkJl1LrWm4J24HoLD+rJkvFxG6flm7UnAIRcP8hugCWEkEPq4hCD6Q6xzxPvqU7ibTD9V4hS1hHb9mHGuK3jiuGleZ8ShDcScywKbRVAZPaoJz+erDvXF7akcIhnDGrpuTlAcOiq9e9zHlbG7umW5kOdNyf4x6o47ngTX3jOTvBXlIdDYEC2rWHzXnf4GW/xkhS884O8 2025-08-14 21:00:04 [INFO]: item found in queue is if condition 14409 2025-08-14 21:00:04 [INFO]: item found in queue is 14409 2025-08-14 21:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBrnK+I4QIukyFc/gpFkxjNG6D7b1e2bNNwh1pd7KZRJ+isFpNdLKvurAuxfsQz3Lr+QnB1slB+EBGvQuGUxNAEJdpR6xf2TpMq+AgUAJ59HPJYJCn2fNAD+/BchiOXhRJaC3FbU5k82OP+RoU9FpzbErJxjXXWFdX24GqfUaJ6wFV9/V+71o44kG+SBUh2MwEfYu3d1rG8xj7dwpwkwEba8NJH/VNEY89IfTq8+Rrd5IDykQG4M/w6CMMaFmYOMpV/64CabNGKaJIGRfTTyzJ7wdBvFADTikTPs8ZlDBJ3FPaPswyqiXRaXvhhJIR79CeZragPhBrXWnZTVouJnIXsHwbP7lZtq0IO/dUAqePaf7NTTs1JotvbaAJSnZzVD26u1jOsRh6ZNYQ5PD44DYwyJgLATzIh8BKh2LxCLF0lHJpRNfaVHRJxKx3s+VQUrMO 2025-08-14 21:00:04 [INFO]: item found in queue is if condition 14409 2025-08-14 21:00:04 [INFO]: item found in queue is 14409 2025-08-14 21:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBIxC7ZrIpdDkk6ZFXQQ5QPZ2d1iA1edG6y+laRX4aA/Hdis5yOiSyC40dK6FE6HTGLDb0HWxiU2zeL8DoMIXtISAj3naAH3vNPJQG4Q4v2VWS5AwdAyMsWFBD7HZf7rXGXCnmKyWE3jjoLTvMQ6RoKLMk+eJUsc2kXVTFLfP5v0u9SsoxG411V6fY+hpTxqWEUvDB1Z7cA5vglAZUpULXS89I6tlOhWngeJUIl5f63lXaJJqwpJLJ43v2H6z6FqkroEHftGpoF2EQ187fYLpenIjEGhRJGyba9aLcE/xIT0DE0e/Sp2TvNE9SUm5bvGbbjh9UBUCROIb5PQMKRLCnNOhRSmFCZl0K8I9RuFlHGEZybNk9QR95bpvgV5IfEggm0fsGAs8xUeOaZyVh8kTZIqHu1dB4Rn+jjRmDZBlxM3y54Ge7CE8kGF7/2hch5mPm 2025-08-14 21:00:04 [INFO]: item found in queue is if condition 14409 2025-08-14 21:00:04 [INFO]: item found in queue is 14409 2025-08-14 21:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBmYKiBMkPSI48FA6Gl9o6MBZ2xSEheha/2wjIcGZBlcCP9epeUtQGUIaUbVi1doQCZSaqUU6ZYcrkHYCKz5THoh31+6Ag6b2ShhI2YvSfLD9vP8T4n1t669tZvSvGDrvjVF/hBAPOa6vZulcjXuNGl8CSjeDEal8XCDk5rHTQ3XU5LtIhBEu5gZcsigYHklj3jjMPHA6b3MqsIWw5XqZz/aYR11dKS6nt+d4ITXo7I34+DDLNyqtSxR1SM2nUMptVjahlfVxqQnE4bjiEY64H5yi+7/EJfGWr4XvAL2KAvsbdUQP2i9d0iWaCa/pgKcUXVek8aZV5FlPuJz7rRdEKtelnWKHzPAPPxYMu87DFZbuGpUzYiyXJqvI8susu39AzDcvppVoaPYX6S+5wFkZQQjLEfqtcwski37lzrEbUd+2xJtK670PfCWEVBZjr0cLI 2025-08-14 21:00:05 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-14 21:00:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 21:00:05 [INFO]: inside itemsold and closed 14409 2025-08-14 21:00:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 21:00:06 [INFO]: autolink for user_id 14409 is 1 2025-08-14 21:00:06 [INFO]: Ebay item id :: 326429323856 exists in Database 2025-08-14 21:00:06 [INFO]: Item is reliested :: exists in Database 2025-08-14 21:00:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 21:00:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 21:00:06 [INFO]: inside itemsold and closed 14409 2025-08-14 21:00:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 21:00:08 [INFO]: autolink for user_id 14409 is 1 2025-08-14 21:00:08 [INFO]: Ebay item id :: 305973578058 exists in Database 2025-08-14 21:00:08 [INFO]: Item is reliested :: exists in Database 2025-08-14 21:00:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 21:00:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 21:00:08 [INFO]: inside itemsold and closed 14409 2025-08-14 21:00:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 21:00:10 [INFO]: autolink for user_id 14409 is 1 2025-08-14 21:00:10 [INFO]: Ebay item id :: 305937555919 exists in Database 2025-08-14 21:00:10 [INFO]: Item is reliested :: exists in Database 2025-08-14 21:00:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 21:00:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 21:00:10 [INFO]: inside itemsold and closed 14409 2025-08-14 21:00:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 21:00:12 [INFO]: autolink for user_id 14409 is 1 2025-08-14 21:00:12 [INFO]: Ebay item id :: 226175663457 exists in Database 2025-08-14 21:00:12 [INFO]: Item is reliested :: exists in Database 2025-08-14 21:00:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 21:00:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 21:00:12 [INFO]: in processold action queue is array for {"44736791":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44736791","ebayitemid":"326429323856","shopifyproductid":"8811481006302","variants":[{"price":"64.99","quantity":0,"weight":"3","shopifyproductid":"8811481006302","shopifyvariantid":"46274724266206","shopifyinventoryid":"48375505387742","shopifylocationid":"","product_id":"44736791","variant_id":"77644728","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44571410":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44571410","ebayitemid":"305973578058","shopifyproductid":"7968547078366","variants":[{"price":"61.99","quantity":0,"weight":"3","shopifyproductid":"7968547078366","shopifyvariantid":"44034662138078","shopifyinventoryid":"46131383107806","shopifylocationid":"","product_id":"44571410","variant_id":"77464094","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44593544":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44593544","ebayitemid":"305937555919","shopifyproductid":"8748560613598","variants":[{"price":"18.99","quantity":0,"weight":"1","shopifyproductid":"8748560613598","shopifyvariantid":"46110950162654","shopifyinventoryid":"48209930223838","shopifylocationid":"","product_id":"44593544","variant_id":"77486253","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44734923":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44734923","ebayitemid":"226175663457","shopifyproductid":"8695084777694","variants":[{"price":"134.99","quantity":0,"weight":"4","shopifyproductid":"8695084777694","shopifyvariantid":"45933928087774","shopifyinventoryid":"48032379470046","shopifylocationid":"","product_id":"44734923","variant_id":"77642816","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 21:00:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 21:00:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 21:00:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 21:00:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 21:00:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 21:00:12 [INFO]: Shopify Inventory id 48375505387742 2025-08-14 21:00:12 [INFO]: Shopify Location id 58450641063 2025-08-14 21:00:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 21:00:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1980,"restoreRate":100}}}} 2025-08-14 21:00:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 21:00:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44736791 and user_id = 14409 2025-08-14 21:00:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77644728 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 21:00:12 [INFO]: Shopify Inventory id 46131383107806 2025-08-14 21:00:12 [INFO]: Shopify Location id 58450641063 2025-08-14 21:00:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 21:00:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T21:00: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-14 21:00:12 [INFO]: Change: available | Delta: -1 2025-08-14 21:00:12 [INFO]: Change: on_hand | Delta: -1 2025-08-14 21:00:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 21:00:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44571410 and user_id = 14409 2025-08-14 21:00:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77464094 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 21:00:12 [INFO]: Shopify Inventory id 48209930223838 2025-08-14 21:00:12 [INFO]: Shopify Location id 58450641063 2025-08-14 21:00:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 21:00:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T21:00: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-14 21:00:13 [INFO]: Change: available | Delta: -1 2025-08-14 21:00:13 [INFO]: Change: on_hand | Delta: -1 2025-08-14 21:00:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 21:00:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44593544 and user_id = 14409 2025-08-14 21:00:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77486253 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 21:00:13 [INFO]: Shopify Inventory id 48032379470046 2025-08-14 21:00:13 [INFO]: Shopify Location id 58450641063 2025-08-14 21:00:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 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":1979,"restoreRate":100}}}} 2025-08-14 21:00:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 21:00:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44734923 and user_id = 14409 2025-08-14 21:00:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77642816 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 21:00:13 [INFO]: updateIdsQuantity -> ["77644728","77464094","77486253","77642816"] 2025-08-14 21:00:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 2 2025-08-14 21:00:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77644728 THEN 0 WHEN id = 77464094 THEN 0 WHEN id = 77486253 THEN 0 WHEN id = 77642816 THEN 0 END, quantityflag = CASE WHEN id = 77644728 THEN 0 WHEN id = 77464094 THEN 0 WHEN id = 77486253 THEN 0 WHEN id = 77642816 THEN 0 END WHERE user_id = 14409 AND id IN (77644728,77464094,77486253,77642816) 2025-08-14 21:00:13 [INFO]: QUANTITY Updated IDs: 77644728, 77464094, 77486253, 77642816 2025-08-14 21:00:13 [INFO]: Successfully processed data for user 14409 2025-08-14 21:00:13 [INFO]: Execution Started 2025-08-14 21:00:13 [INFO]: Execution Finished 2025-08-14 21:10:01 [INFO]: Execution Started 2025-08-14 21:10:01 [INFO]: old server sucessfully connected 2025-08-14 21:10:01 [INFO]: sqs client sucess created 2025-08-14 21:10:02 [INFO]: Number of messages in the queue: 1 2025-08-14 21:10:02 [INFO]: item found in queue is if condition 14409 2025-08-14 21:10:02 [INFO]: item found in queue is 14409 2025-08-14 21:10:02 [INFO]: Message deleted from the queue for receipt handle: AQEB2WiwIq9NiDBihRpTfQ0XvI4++V6/oaPTbnTBAszy063C1fzC8SvRbWDTFTWhSey+CCdp3bC8F8TD+fp9Pho6dLf/vmfDTpKRX9TScH0cv33+PGbAmj3ClDThov2WVOU7wy6d+UUXq2hZ0uKuiiy4TCyH79KkEnmnYJ6BYb6kh87KZC2dw69GNyTSOH1jVTW1Caaa9ZByrRan5IkTjgN+fjzcgQInOfAaJUblyqbsnqKQKblVxOY8NFAsAuIks4aLguymKk+Tm9FE9NRSX+0zcT/sQim7DQVPH0e5/2APESgKBi1N8tCCUULr7/6DCd0ZjDHPkDTkdnhvhSaPwFVuSCis1deWQmQMmECg4aAgKAKUsHn414OISC6Hl6EINHiPOZSsHRE8h7fRqDUAgxNZ1bdo4Jb+cgIQBb5dhzXyANxM3abO0lGrqCPZpTesGegh 2025-08-14 21:10:02 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-14 21:10:02 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 21:10:02 [INFO]: inside itemsold and closed 14409 2025-08-14 21:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 21:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-14 21:10:05 [INFO]: Ebay item id :: 286274418569 exists in Database 2025-08-14 21:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-14 21:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 21:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 21:10:05 [INFO]: in processold action queue is array for {"44661855":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44661855","ebayitemid":"286274418569","shopifyproductid":"8921771245790","variants":[{"price":"9.99","quantity":0,"weight":"0.9375","shopifyproductid":"8921771245790","shopifyvariantid":"46810084802782","shopifyinventoryid":"48908562628830","shopifylocationid":"58450641063","product_id":"44661855","variant_id":"77567075","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 21:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 21:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 21:10:05 [INFO]: Shopify Inventory id 48908562628830 2025-08-14 21:10:05 [INFO]: Shopify Location id 58450641063 2025-08-14 21:10:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 21:10:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-14 21:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 21:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44661855 and user_id = 14409 2025-08-14 21:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77567075 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 21:10:05 [INFO]: updateIdsQuantity -> ["77567075"] 2025-08-14 21:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-14 21:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77567075 THEN 0 END, quantityflag = CASE WHEN id = 77567075 THEN 0 END WHERE user_id = 14409 AND id IN (77567075) 2025-08-14 21:10:05 [INFO]: QUANTITY Updated IDs: 77567075 2025-08-14 21:10:05 [INFO]: Successfully processed data for user 14409 2025-08-14 21:10:05 [INFO]: Execution Started 2025-08-14 21:10:05 [INFO]: Execution Finished 2025-08-14 21:20:01 [INFO]: Execution Started 2025-08-14 21:20:01 [INFO]: old server sucessfully connected 2025-08-14 21:20:01 [INFO]: sqs client sucess created 2025-08-14 21:20:03 [INFO]: Number of messages in the queue: 1 2025-08-14 21:20:03 [INFO]: item found in queue is if condition 14409 2025-08-14 21:20:03 [INFO]: item found in queue is 14409 2025-08-14 21:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBfw+k8EBd66cGFhGNUuaGSmGC7LIIxFBcfK2zCaC3o9kBMPFxIK+QzTlHIAQHTaH4cugrW4RuTO6ZKFCBBGNB2GYi2e5vp961HgYxNb42uUzW7HN1EMsraRLyffUQkwCqAkqpHFIGyPYkqF+GKnzv8NbaLzbuKqcMc8sCoN6OjOK0bSkD5k/32Rjor5lGcvw4+G1MqIzmRHeByHA6kLVEjW8ikrNFvNesQ0mBlxxKP59vXCfcI5LktemRB4UliZoVr3YbMpyc2FHa+GPPhZaJoWWEVKmWwnlwZ0QqcCTtuoIOz2MpLVO+WShFAP3YlO5jjXkrL71K2MrEcuAyboZeLnw73s4E0lkAXJITwBR+gHlLAqZ9q8hUSGDeU5tDMzYApgyJZB9ptR26aip4/kCLjYRd027Safosy87lNxzs7nXkj+iqIWTGRfwxv9lFmgTg 2025-08-14 21:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-14 21:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 21:20:03 [INFO]: inside itemsold and closed 14409 2025-08-14 21:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 21:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-14 21:20:05 [INFO]: Ebay item id :: 335529666083 exists in Database 2025-08-14 21:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-14 21:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 21:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 21:20:05 [INFO]: in processold action queue is array for {"44571237":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44571237","ebayitemid":"335529666083","shopifyproductid":"8699177861342","variants":[{"price":"15.99","quantity":0,"weight":"0.9375","shopifyproductid":"8699177861342","shopifyvariantid":"45943427727582","shopifyinventoryid":"48041920430302","shopifylocationid":"","product_id":"44571237","variant_id":"77463921","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 21:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 21:20:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 21:20:05 [INFO]: Shopify Inventory id 48041920430302 2025-08-14 21:20:05 [INFO]: Shopify Location id 58450641063 2025-08-14 21:20:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 21:20:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T21:20:05Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1986,"restoreRate":100}}}} 2025-08-14 21:20:05 [INFO]: Change: available | Delta: -2 2025-08-14 21:20:05 [INFO]: Change: on_hand | Delta: -2 2025-08-14 21:20:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 21:20:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44571237 and user_id = 14409 2025-08-14 21:20:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77463921 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 21:20:05 [INFO]: updateIdsQuantity -> ["77463921"] 2025-08-14 21:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-14 21:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77463921 THEN 0 END, quantityflag = CASE WHEN id = 77463921 THEN 0 END WHERE user_id = 14409 AND id IN (77463921) 2025-08-14 21:20:05 [INFO]: QUANTITY Updated IDs: 77463921 2025-08-14 21:20:05 [INFO]: Successfully processed data for user 14409 2025-08-14 21:20:05 [INFO]: Execution Started 2025-08-14 21:20:05 [INFO]: Execution Finished 2025-08-14 21:30:01 [INFO]: Execution Started 2025-08-14 21:30:01 [INFO]: old server sucessfully connected 2025-08-14 21:30:01 [INFO]: sqs client sucess created 2025-08-14 21:30:02 [INFO]: Number of messages in the queue: 0 2025-08-14 21:30:22 [INFO]: Execution Started 2025-08-14 21:30:22 [INFO]: Execution Finished 2025-08-14 21:40:01 [INFO]: Execution Started 2025-08-14 21:40:01 [INFO]: old server sucessfully connected 2025-08-14 21:40:01 [INFO]: sqs client sucess created 2025-08-14 21:40:02 [INFO]: Number of messages in the queue: 5 2025-08-14 21:40:03 [INFO]: item found in queue is if condition 14409 2025-08-14 21:40:03 [INFO]: item found in queue is 14409 2025-08-14 21:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBwxhRecRiL0Pxt3ep3XetomW+vvrdpKEsNgSfhj0b3kNZsIEzX8ibhBsBqZygcBpLbh80avUkIZxPIUuBHq4SLZzFWUdxNk8C6Tn6CjBLkF2VPyVpgx/hMNcBBxJTKYXQK2Lxyk81IAl1lXLAlbiScYSh0pEJVtArkLnREGUfDk6e/pBp/jIJr8sNJo0q8mCPf71l8ih/OghBkiZd2zkm4KqIlMzh4eucluyJYhi2dBneR3NSO4ttwUcpBFHroHoMo7DhrG0ZavDLbS8f/5ru1iF7Qdw7GtV73eJsvADdRbP/D1vu8TXYxHq9qmCLz4f52CSDT+INagOgMZwMtzJd13YAfgHNIrc1l8i5GRTsO6t05hte8vVzpUJndAD8YlW0Ni0ECBalo8FGRD+sosY9Fa58TldRCgHniwiBumgUvBM2Sr9HPgzy8q1NcqXl6GUD 2025-08-14 21:40:03 [INFO]: item found in queue is if condition 14409 2025-08-14 21:40:03 [INFO]: item found in queue is 14409 2025-08-14 21:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBxUQTXocL2xjpo9zQXGsjM6F2pgcKhKbBa9YM1TQrfYgN8w5+FQLWKCNx/NpPjL+viS+cHYUdBgQXdd+L1HVcSJPML2+RCMf2TqFm1I+JJacVDmd0aCaaDnXfTF6tRBAcm/uBzWcXyB6Gwm09MUvwODxe4hibJUP69x0ivJn7O0fgxJxqahCpsxxRQnZ7ucwtu+vwE+iid6DlMX3sEN7iI19H/heERHfjfEiq298FUdtKX0mJi1ZcZ7D2syFme+judfdoqVw9uv5EIlRPNFbMoyZm7ypKfAbwacBBFfv7gCH4mxt0CxcYUHD9HRu9l5YVV1n+0BCunppM0UjQTvcBUOb32ccMaz2yJqOZIaOnpJ8zNXG0+p0euQcnDmMa6LImbiXb5OxXhFl+LzXa7U+hyt489gmxZX/GWHOGzI7xzUd3Gsb+U9naLY/mFPY8EVDq 2025-08-14 21:40:04 [INFO]: item found in queue is if condition 14409 2025-08-14 21:40:04 [INFO]: item found in queue is 14409 2025-08-14 21:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEB2dD7ZdAhCR+aOyHjoq/JdSz08UkDTxwqpzVkBXqdmJ6F/YaqXw1PpP1LPNLfRlNJdzCV+a1Z8Mvlw9inqZCInc3vi0EAiw6bq4VLAYwq6PWDDTQcKlaSgMiqmZqNAdC/kJp+1RpkfoKbfZAPmAWlbr6jL9i9guPYkcf7hUbyRwHNs0IVfNyW+cIKkDFY5zmlfiETPtA371y786txUgyyHw6pkVSg3bgiNZ6wePsvNhPMk4nN9PMTs+2zXMOPas1od2FjV9GDqM6IWOMO27OQG1GUhI7IX5tkkB3Bpot6z889/oiwDcMvCNGZOS1oBjySCSsO28XIcYaH0SUazWt/qofuOdbFnU7R4XZnkN5gzGtYp6d1/U7ixsgdTNUei9PqMTw5bHCTcTDhEtya1svJFiBuwcNgnmiPoAhAGO15El0zPw/ZJYi026wJeujqda3c 2025-08-14 21:40:04 [INFO]: item found in queue is if condition 14409 2025-08-14 21:40:04 [INFO]: item found in queue is 14409 2025-08-14 21:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBQWv+UMh4NUBKW0mGrWt08VYILq/oXkvpBlzdKfY/kpw1AzPaSKsS10CLTgpDizW5mvHNqGhBCVTaWMs09GUUoG9hlGSljesVwnoNi4yYVx7xT55aZdihCBvddpY0KoIIWm0QuGtXZ9/ObSiiPwi4ao89FRUtmRe5iZ8m8xaIAKa7uJf1f1k3clgIwMu2rnL7Y1DgQKpZcLlIWfsFKBbIvdh9uDrkLCDQ4N3MzOGDCvKGAe9ybDbItMmdRtJvnAgEhsW5fxLI1N9u0arRjEgVFHnEp49yJd0pIWXQ3nygB/hAWMm8eUz5ljBcMZeL1a2qgxeAlDSBwNgkC8PXGfWmyhegiArJKWj7r9MJEiA6UU0gnI8S0/POk+qlOdHXdbZcdOSW5RE/0fuS1W9NlUmK8zbkGr42lDDozWwP6N/nR0PerKTs/NB9I9Xihq1CQoNJ 2025-08-14 21:40:04 [INFO]: item found in queue is if condition 14409 2025-08-14 21:40:04 [INFO]: item found in queue is 14409 2025-08-14 21:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEB0FFFS0jlPs/wYOt4f0SDGZRfSSQvOCy5iEDnFjiySWALkwavcC7fp7oF03sHKC1Eqc2fJA9M1bCEDk1aY/jMF7TpFmzjfFZSIXkwfQil4jVLLXKkYtzfQYOq/dXJH7QLF8PsUFfu2absko2POZ8lo0Vcvx2Q656dQ8X1KuHviKxdXiXR0j1VzmcGfyXpz3WIqw3HiB586C5gSvAEJv6tC+JEAtvPoA93lLTGJb+JX8ZNOSZI7tioeuSHaEJjI6FstYCNEpoCLxXpGuo55FFOstb+H8MU6CYD2audfDafK0u38V2+QKcKrrJIsCxVZ6ukdkZd2U4aETZWqz/jvq4RX69y44pZ/9z5X6Fc1YXImBSdCUwuVse5SFCAh5Ecn6GF3cmwHoOU4yN0rVdmVG6ZTP8PQHTHLfafXS+I+FQGXrmNdE/dnIAhC5cCypN5a6yP 2025-08-14 21:40:04 [INFO]: Processed 5 messages, reached the limit of 5. 2025-08-14 21:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 21:40:04 [INFO]: inside itemsold and closed 14409 2025-08-14 21:40:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 21:40:06 [INFO]: autolink for user_id 14409 is 1 2025-08-14 21:40:06 [INFO]: Ebay item id :: 326601167291 exists in Database 2025-08-14 21:40:06 [INFO]: Item is reliested :: exists in Database 2025-08-14 21:40:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 21:40:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 21:40:06 [INFO]: inside itemsold and closed 14409 2025-08-14 21:40:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 21:40:08 [INFO]: autolink for user_id 14409 is 1 2025-08-14 21:40:08 [INFO]: Ebay item id :: 326464934152 exists in Database 2025-08-14 21:40:08 [INFO]: Item is reliested :: exists in Database 2025-08-14 21:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 21:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 21:40:08 [INFO]: inside itemsold and closed 14409 2025-08-14 21:40:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 21:40:10 [INFO]: autolink for user_id 14409 is 1 2025-08-14 21:40:10 [INFO]: Ebay item id :: 336119665664 exists in Database 2025-08-14 21:40:10 [INFO]: Item is reliested :: exists in Database 2025-08-14 21:40:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 21:40:10 [INFO]: inside itemsold and closed 14409 2025-08-14 21:40:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 21:40:12 [INFO]: autolink for user_id 14409 is 1 2025-08-14 21:40:12 [INFO]: Ebay item id :: 306358307546 exists in Database 2025-08-14 21:40:12 [INFO]: Item is reliested :: exists in Database 2025-08-14 21:40:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 21:40:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 21:40:12 [INFO]: inside itemsold and closed 14409 2025-08-14 21:40:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 21:40:13 [INFO]: autolink for user_id 14409 is 1 2025-08-14 21:40:13 [INFO]: Ebay item id :: 226682393960 exists in Database 2025-08-14 21:40:13 [INFO]: Item is reliested :: exists in Database 2025-08-14 21:40:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 21:40:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 21:40:13 [INFO]: in processold action queue is array for {"44885021":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44885021","ebayitemid":"326601167291","shopifyproductid":"8927012978910","variants":[{"price":"11.99","quantity":0,"weight":"1","shopifyproductid":"8927012978910","shopifyvariantid":"46841900171486","shopifyinventoryid":"48944554344670","shopifylocationid":"58450641063","product_id":"44885021","variant_id":"77796991","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44682408":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44682408","ebayitemid":"326464934152","shopifyproductid":"8830073045214","variants":[{"price":"21.99","quantity":0,"weight":"1","shopifyproductid":"8830073045214","shopifyvariantid":"46328706728158","shopifyinventoryid":"48429952205022","shopifylocationid":"","product_id":"44682408","variant_id":"77587633","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44709644":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44709644","ebayitemid":"306358307546","shopifyproductid":"8233880584414","variants":[{"price":"14.99","quantity":0,"weight":"1","shopifyproductid":"8233880584414","shopifyvariantid":"44599923769566","shopifyinventoryid":"46697895821534","shopifylocationid":"","product_id":"44709644","variant_id":"77617250","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44737490":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44737490","ebayitemid":"226682393960","shopifyproductid":"8863916458206","variants":[{"price":"21.99","quantity":0,"weight":"1","shopifyproductid":"8863916458206","shopifyvariantid":"46521959088350","shopifyinventoryid":"48624407838942","shopifylocationid":"","product_id":"44737490","variant_id":"77645427","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 21:40:13 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 21:40:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 21:40:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 21:40:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 21:40:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 21:40:13 [INFO]: Shopify Inventory id 48944554344670 2025-08-14 21:40:13 [INFO]: Shopify Location id 58450641063 2025-08-14 21:40:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 21:40:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T21:40:13Z","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 21:40:13 [INFO]: Change: available | Delta: -1 2025-08-14 21:40:13 [INFO]: Change: on_hand | Delta: -1 2025-08-14 21:40:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 21:40:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44885021 and user_id = 14409 2025-08-14 21:40:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77796991 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 21:40:13 [INFO]: Shopify Inventory id 48429952205022 2025-08-14 21:40:13 [INFO]: Shopify Location id 58450641063 2025-08-14 21:40:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 21:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T21:40: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 21:40:14 [INFO]: Change: available | Delta: -1 2025-08-14 21:40:14 [INFO]: Change: on_hand | Delta: -1 2025-08-14 21:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 21:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44682408 and user_id = 14409 2025-08-14 21:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77587633 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 21:40:14 [INFO]: Shopify Inventory id 46697895821534 2025-08-14 21:40:14 [INFO]: Shopify Location id 58450641063 2025-08-14 21:40:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 21:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T21:40:14Z","reason":"correction","changes":[{"name":"available","delta":1},{"name":"on_hand","delta":1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1984,"restoreRate":100}}}} 2025-08-14 21:40:14 [INFO]: Change: available | Delta: 1 2025-08-14 21:40:14 [INFO]: Change: on_hand | Delta: 1 2025-08-14 21:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 21:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44709644 and user_id = 14409 2025-08-14 21:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77617250 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 21:40:14 [INFO]: Shopify Inventory id 48624407838942 2025-08-14 21:40:14 [INFO]: Shopify Location id 58450641063 2025-08-14 21:40:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 21:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T21:40: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-14 21:40:14 [INFO]: Change: available | Delta: -1 2025-08-14 21:40:14 [INFO]: Change: on_hand | Delta: -1 2025-08-14 21:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 21:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44737490 and user_id = 14409 2025-08-14 21:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77645427 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 21:40:14 [INFO]: updateIdsQuantity -> ["77796991","77587633","77617250","77645427"] 2025-08-14 21:40:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4 2025-08-14 21:40:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77796991 THEN 0 WHEN id = 77587633 THEN 0 WHEN id = 77617250 THEN 0 WHEN id = 77645427 THEN 0 END, quantityflag = CASE WHEN id = 77796991 THEN 0 WHEN id = 77587633 THEN 0 WHEN id = 77617250 THEN 0 WHEN id = 77645427 THEN 0 END WHERE user_id = 14409 AND id IN (77796991,77587633,77617250,77645427) 2025-08-14 21:40:14 [INFO]: QUANTITY Updated IDs: 77796991, 77587633, 77617250, 77645427 2025-08-14 21:40:14 [INFO]: Successfully processed data for user 14409 2025-08-14 21:40:14 [INFO]: Execution Started 2025-08-14 21:40:14 [INFO]: Execution Finished 2025-08-14 21:50:01 [INFO]: Execution Started 2025-08-14 21:50:01 [INFO]: old server sucessfully connected 2025-08-14 21:50:01 [INFO]: sqs client sucess created 2025-08-14 21:50:02 [INFO]: Number of messages in the queue: 1 2025-08-14 21:50:02 [INFO]: item found in queue is if condition 14409 2025-08-14 21:50:02 [INFO]: item found in queue is 14409 2025-08-14 21:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBLk4t/rla93Z/CgNzHBZVoDPDd1hdrAMWfqNH3djxSaJcx+UpHVWCqvfQokJ3fYxcZB41HQ1MqA0hxVqXngOXwMwUnE0IU0hQsD+lS97BfV77psXGY2fJGdYjz22bIWBNuHm/Ivo9Z01coOKW2pxeuQINoFZl4Y24Z11RMekZpymZ/SeB2/uLGtXWF9OkX8rFNNu35bFIwkbjKtKRE39hkybNi6p6MVhDw0GkYvCVifLnD4nhxnOL2mfAnFly+QGHbcBb40EY/COCut6qS97AvRIc+mlmXfMKFdYhN0UeAPgKDTrhoSx0Dyrn3ve7d++9+soWuN+P2P6lgJWwvCU7ERlnilqZiIhPQLY9zTixpMCjVB/CZElpIbNhemJschstRY+lS5YHZ/NoEyUDwS3sEtYYBtIjveWrlWrkLuHvpnyayIFh66su2wwbdkoNABJV 2025-08-14 21:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-14 21:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 21:50:03 [INFO]: inside itemsold and closed 14409 2025-08-14 21:50:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 21:50:04 [INFO]: autolink for user_id 14409 is 1 2025-08-14 21:50:04 [INFO]: Ebay item id :: 406098475184 exists in Database 2025-08-14 21:50:04 [INFO]: Item is reliested :: exists in Database 2025-08-14 21:50:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 21:50:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 21:50:04 [INFO]: in processold action queue is array for {"45313063":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313063","ebayitemid":"406098475184","shopifyproductid":"8976977854686","variants":[{"price":"19.99","quantity":0,"weight":"1","shopifyproductid":"8976977854686","shopifyvariantid":"47220883816670","shopifyinventoryid":"49332734722270","shopifylocationid":"58450641063","product_id":"45313063","variant_id":"78265576","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 21:50:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 21:50:04 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 21:50:04 [INFO]: Shopify Inventory id 49332734722270 2025-08-14 21:50:04 [INFO]: Shopify Location id 58450641063 2025-08-14 21:50:04 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 21:50:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T21:50:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-14 21:50:05 [INFO]: Change: available | Delta: -1 2025-08-14 21:50:05 [INFO]: Change: on_hand | Delta: -1 2025-08-14 21:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 21:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313063 and user_id = 14409 2025-08-14 21:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265576 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 21:50:05 [INFO]: updateIdsQuantity -> ["78265576"] 2025-08-14 21:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-14 21:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78265576 THEN 0 END, quantityflag = CASE WHEN id = 78265576 THEN 0 END WHERE user_id = 14409 AND id IN (78265576) 2025-08-14 21:50:05 [INFO]: QUANTITY Updated IDs: 78265576 2025-08-14 21:50:05 [INFO]: Successfully processed data for user 14409 2025-08-14 21:50:05 [INFO]: Execution Started 2025-08-14 21:50:05 [INFO]: Execution Finished