2025-08-12 12:00:01 [INFO]: Execution Started
2025-08-12 12:00:01 [INFO]: old server sucessfully connected
2025-08-12 12:00:01 [INFO]: sqs client sucess created
2025-08-12 12:00:10 [INFO]: Number of messages in the queue: 0
2025-08-12 12:00:31 [INFO]: Execution Started
2025-08-12 12:00:31 [INFO]: Execution Finished
2025-08-12 12:10:01 [INFO]: Execution Started
2025-08-12 12:10:01 [INFO]: old server sucessfully connected
2025-08-12 12:10:01 [INFO]: sqs client sucess created
2025-08-12 12:10:04 [INFO]: Number of messages in the queue: 0
2025-08-12 12:10:24 [INFO]: Execution Started
2025-08-12 12:10:24 [INFO]: Execution Finished
2025-08-12 12:20:01 [INFO]: Execution Started
2025-08-12 12:20:01 [INFO]: old server sucessfully connected
2025-08-12 12:20:01 [INFO]: sqs client sucess created
2025-08-12 12:20:03 [INFO]: Number of messages in the queue: 0
2025-08-12 12:20:23 [INFO]: Execution Started
2025-08-12 12:20:23 [INFO]: Execution Finished
2025-08-12 12:30:02 [INFO]: Execution Started
2025-08-12 12:30:02 [INFO]: old server sucessfully connected
2025-08-12 12:30:02 [INFO]: sqs client sucess created
2025-08-12 12:30:05 [INFO]: Number of messages in the queue: 3
2025-08-12 12:30:06 [INFO]: item found in queue is if condition  14409
2025-08-12 12:30:06 [INFO]: item found in queue is  14409
2025-08-12 12:30:07 [INFO]: Message deleted from the queue for receipt handle: AQEBKVq3sojvVL/fNQWWBGt3B8uJ44EtPlj2bM4nlZB0W2ew7kItWMmHLIPhGS0ZtScHrPnGk/cfiq8qEk627C6cuKwHWW8uWuR84rgiAtsACesG5pNR7HB2mIC63yQ1LUsu29ueLIr/ax06/I0K30Qy08gb9YQ91gGERtaHmxKHI3SZbkm85+skg6XTX4GOhDHnct59PIPPiS765vORE8B0o0rnOYs0xqLQngin/MyRG+BX3ZGRhwSwXUSE3tMFUiS8+bAQ86xV/reoR0g+V+NVKk3RXx1sExOhKN+FYUURye9A9Q4YKRAAMefB4O0zTnLJy0Jibp+xFDF2czV0OKywO8Zr8oDdzp+bBDKt8ZMjwemDa4BjjjxQdnIfk56ubzQrTmN8PjwhFGqx2t4hSnF0Fh//mtwbh64xOOr4P2Wyj/Oj+SoVybpj4hUalzlgtBUD
2025-08-12 12:30:08 [INFO]: item found in queue is if condition  14409
2025-08-12 12:30:08 [INFO]: item found in queue is  14409
2025-08-12 12:30:12 [INFO]: Message deleted from the queue for receipt handle: AQEBFOxTfP7a2GOfg580JQb7r+QTTNbd/kiJU2oJNSmoeJsOeVY0EpP4pCjGOk3W9/ZIg5VthoOgSr7AvaNzKzq99YaOtPw2A5Opps/Bg7SMgbj7I4pcbeRvYxqWVipXW11tmlnuIubG8ewNlE6dn+5MlTg9RxVlq2YWwLIVemUcGXwDTGSUCN/2OJBV4fIafpY6r1VsLUS5iekZX95gMW8GG7LhdCq7FLJhR7BOFg6gTB9zUkV53AO0aIPujsbuaMrqxFM4SObKdF/mVVg9f1ftqXAfxeH92IBkS5Rw7173VNmPmG4AtJcYzZD/owi7T2FUykYGHnJHPaVVumciNNru2hevYpJNMSK/G+0KiQihgCXElkz3Nv5SrlMfJa8YoZoHuGGPfm0/H1VYJq7ic0Oa3mgj8q3LexTqzgN3vGQE8oUkq1dnMdvZX6Fv/5U2qmIg
2025-08-12 12:30:12 [INFO]: item found in queue is if condition  14409
2025-08-12 12:30:12 [INFO]: item found in queue is  14409
2025-08-12 12:30:13 [INFO]: Message deleted from the queue for receipt handle: AQEBS1hYFCPsQ++TrQ857kVkY0RtmEVdQ4LZKNJ1kO53dQ9MDtQ8oxtIddWm+ZeNOci6SNEoqoZ5HvqXJvGgxydiXQIsOusg6Q2O64MxAps5hu6w21dHG5GeYM6JnAlRxaE1AOHYxRFpW4BZMJrB0gkuqhkbvoz8JgPMdS/aGj4tdrOMF7ICRm5spVpJgWF9BD37ixvTqy9xOl7HZV5Po1ZXI/swHK8c8iDe3eMYq4sqGYMmJ4zY77Xwifdm9XRE8XJaopMOCgRLXm5dKI+n9oj4TQ2Pna6PZp5UKyMM9VlDvgZGe3hjg63dMY1qf2SQ00D9eMt7K8SnNjyUPMpGMAkwOtGNoTgEfS6+dfCDeqkQ3X2H3k6ZrRopIfAGKP4Z3CAPDvjyJNh1wxvUKUWWMWr62TZ2yB+TuibopNywCWS8ryQmdWMF0fhNyQy3staHXxC4
2025-08-12 12:30:13 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-12 12:30:13 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 12:30:13 [INFO]: inside itemsold and closed 14409
2025-08-12 12:30:15 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 12:30:15 [INFO]: autolink for user_id 14409 is 1
2025-08-12 12:30:15 [INFO]: Ebay item id :: 285818250613 exists in Database
2025-08-12 12:30:15 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 12:30:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 12:30:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 12:30:15 [INFO]: inside itemsold and closed 14409
2025-08-12 12:30:18 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 12:30:18 [INFO]: autolink for user_id 14409 is 1
2025-08-12 12:30:18 [INFO]: Ebay item id :: 404952644903 exists in Database
2025-08-12 12:30:18 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 12:30:18 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 12:30:18 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 12:30:18 [INFO]: inside itemsold and closed 14409
2025-08-12 12:30:19 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 12:30:19 [INFO]: autolink for user_id 14409 is 1
2025-08-12 12:30:19 [INFO]: Ebay item id :: 404928085320 exists in Database
2025-08-12 12:30:19 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 12:30:19 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 12:30:19 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 12:30:19 [INFO]: in processold action queue is array    for {"44653010":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44653010","ebayitemid":"285818250613","shopifyproductid":"8409456705758","variants":[{"price":"149.99","quantity":0,"weight":"3","shopifyproductid":"8409456705758","shopifyvariantid":"45204584595678","shopifyinventoryid":"47302494781662","shopifylocationid":"","product_id":"44653010","variant_id":"77558199","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772871":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772871","ebayitemid":"404952644903","shopifyproductid":"8461630996702","variants":[{"price":"149.99","quantity":0,"weight":"3","shopifyproductid":"8461630996702","shopifyvariantid":"45305968885982","shopifyinventoryid":"47403893620958","shopifylocationid":"","product_id":"44772871","variant_id":"77681413","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44650514":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44650514","ebayitemid":"404928085320","shopifyproductid":"8407664853214","variants":[{"price":"499.99","quantity":0,"weight":"2","shopifyproductid":"8407664853214","shopifyvariantid":"45198780891358","shopifyinventoryid":"47296690618590","shopifylocationid":"","product_id":"44650514","variant_id":"77555703","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-12 12:30:19 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-12 12:30:19 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 12:30:19 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 12:30:19 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 12:30:19 [INFO]: Shopify Inventory id 47302494781662
2025-08-12 12:30:19 [INFO]: Shopify Location id 58450641063
2025-08-12 12:30:19 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 12:30:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T12:30:20Z","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-12 12:30:20 [INFO]: Change: available | Delta: -1
2025-08-12 12:30:20 [INFO]: Change: on_hand | Delta: -1
2025-08-12 12:30:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 12:30:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44653010 and user_id = 14409 
2025-08-12 12:30:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77558199 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 12:30:20 [INFO]: Shopify Inventory id 47403893620958
2025-08-12 12:30:20 [INFO]: Shopify Location id 58450641063
2025-08-12 12:30:20 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 12:30:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T12:30:20Z","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-12 12:30:20 [INFO]: Change: available | Delta: -1
2025-08-12 12:30:20 [INFO]: Change: on_hand | Delta: -1
2025-08-12 12:30:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 12:30:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772871 and user_id = 14409 
2025-08-12 12:30:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681413 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 12:30:20 [INFO]: Shopify Inventory id 47296690618590
2025-08-12 12:30:20 [INFO]: Shopify Location id 58450641063
2025-08-12 12:30:20 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 12:30:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T12:30:20Z","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-12 12:30:20 [INFO]: Change: available | Delta: -1
2025-08-12 12:30:20 [INFO]: Change: on_hand | Delta: -1
2025-08-12 12:30:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 12:30:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44650514 and user_id = 14409 
2025-08-12 12:30:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77555703 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 12:30:20 [INFO]: updateIdsQuantity -> ["77558199","77681413","77555703"]
2025-08-12 12:30:20 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-12 12:30:20 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77558199 THEN 0 WHEN id = 77681413 THEN 0 WHEN id = 77555703 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77558199 THEN 0 WHEN id = 77681413 THEN 0 WHEN id = 77555703 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77558199,77681413,77555703)
2025-08-12 12:30:20 [INFO]: QUANTITY Updated IDs: 77558199, 77681413, 77555703
2025-08-12 12:30:20 [INFO]: Successfully processed data for user 14409
2025-08-12 12:30:20 [INFO]: Execution Started
2025-08-12 12:30:20 [INFO]: Execution Finished
2025-08-12 12:40:01 [INFO]: Execution Started
2025-08-12 12:40:01 [INFO]: old server sucessfully connected
2025-08-12 12:40:01 [INFO]: sqs client sucess created
2025-08-12 12:40:06 [INFO]: Number of messages in the queue: 3
2025-08-12 12:40:07 [INFO]: item found in queue is if condition  14409
2025-08-12 12:40:07 [INFO]: item found in queue is  14409
2025-08-12 12:40:07 [INFO]: Message deleted from the queue for receipt handle: AQEBII8q+lGyyyj9AdbT6lWc2h4RZMjTlrf+V5P9Q9lOjy6KYNX2sItua6tqhHeqFnLS/vCz99Tzy3ZUR+cinjK4OQU8ZjDIQP6pDguO1KAfkApTb+bhlrT7ZhnLzBrm4naQ2Jr/WiN1HUExj+pNt3nMRuigxj3EbOWniWOwZL75hR1myKWgHg1PKFKr8WmNLh8ZlzyRpVAM6pMDjq43u+sVC7uGeiwHVexeaPm7J1BC2xOSeo6KMZgJOlGn1NetwcJoqYF3zMrJurjwlkpQAZK2BrfnXcE1KfLO8NIswDdWHqca6FPKR2zmlnWkmVm5kj9I7fIicIiP7JTPmp3xaX++oBz9Yr0NLQnJZkX3T+s6mZDgEYu9uMqkYMTdVxgBPYqilSZ4ipg7jqg+eFaz2d4ivzf1Saml67Zdt75iG8fNfMNz4ggSEwI0bGGN67cmv88/
2025-08-12 12:40:08 [INFO]: item found in queue is if condition  14409
2025-08-12 12:40:08 [INFO]: item found in queue is  14409
2025-08-12 12:40:08 [INFO]: Message deleted from the queue for receipt handle: AQEBH2p+KgiiX6G3ec0xjRwYuGm/tzVTVY1WcKqIDTRDtOP8ghJ2WfqLHl14aMB2u/rnzO979YeaP/MjgjolJy/KFpTnB2mDuCGJ+nwi7myjdDsuQ606k74gUKHEBNEuOMdIKPcWqFqsWWMGXnHD3BYNmcJMye6ublictZQc2hMEgnQmArSHEnCP0S4tSRPmRDO/eRgHSNE4UIsHtzeOQfiQHr1WRTPOmrlmxlQFGRK2qofWZ+fhux+fqjhkPxOWRnU4HQVEXJOiS2B1Bwq0L/dFvJrLMzbZW94e+tJNvcuo790Fa4S/9cm1Kw34Yk27VtF5Vd54YGaZQ8uSC9BgdMdqMa4V4GX9cydm4Ubh/gKPud8zQPwCmVl8QAIZoCROlTgvl69UAaHnE0J3+tPLNjzSIufcs40y6P6Dfd/nUAp9bn3xg6faz9+VdfnrsLajkGo2
2025-08-12 12:40:09 [INFO]: item found in queue is if condition  14409
2025-08-12 12:40:09 [INFO]: item found in queue is  14409
2025-08-12 12:40:10 [INFO]: Message deleted from the queue for receipt handle: AQEBehprTfXBRpF3IAC/lqsf7nAmTMqQZw4na2PWrhKlpydLzj0xewgd9fE7W1ZDQdziHzG7GLHEmP3tt3oGSTzhopr/IvFOOW8BQaULD6nRf46rMVtMa7DH3aMMddMCegmPSJwf0JLlVcYmmyEOe8wHkm62FfBKqzj7SwE1yulZ3mV9DJmX1pHX8kTVNVGYFA6wj9tXxAn71NoLr7MuJjNJhCGoK7plmLs/9JDtxPibuY8R1m6ULhzUzHma5303j5Oim9STQHHgi6aYKrciuoI5Br+PUvYrncpduDtWlqaANVS7EEaX2xOJ93k/bKdrqsocxrg0lISVpGdgAiZF40H8j7yXvHQLvwUniN1tyNZhFIo82EYIsiDiPoR2tYPcyqPahqme8dPa/MQj/0TjQY2obj4D7jlAupi1+/k3/3I9BMrYhqqKnOzFZcANxpdoGgZi
2025-08-12 12:40:10 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-12 12:40:10 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 12:40:10 [INFO]: inside itemsold and closed 14409
2025-08-12 12:40:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 12:40:11 [INFO]: autolink for user_id 14409 is 1
2025-08-12 12:40:11 [INFO]: Ebay item id :: 405234461710 exists in Database
2025-08-12 12:40:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 12:40:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 12:40:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 12:40:11 [INFO]: inside itemsold and closed 14409
2025-08-12 12:40:13 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 12:40:13 [INFO]: autolink for user_id 14409 is 1
2025-08-12 12:40:13 [INFO]: Ebay item id :: 404929359510 exists in Database
2025-08-12 12:40:13 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 12:40:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 12:40:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 12:40:13 [INFO]: inside itemsold and closed 14409
2025-08-12 12:40:15 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 12:40:15 [INFO]: autolink for user_id 14409 is 1
2025-08-12 12:40:15 [INFO]: Ebay item id :: 286133586057 exists in Database
2025-08-12 12:40:15 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 12:40:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 12:40:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 12:40:15 [INFO]: in processold action queue is array    for {"44690207":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44690207","ebayitemid":"405234461710","shopifyproductid":"8696093769950","variants":[{"price":"89.99","quantity":0,"weight":"3","shopifyproductid":"8696093769950","shopifyvariantid":"45936168763614","shopifyinventoryid":"48034617721054","shopifylocationid":"","product_id":"44690207","variant_id":"77595459","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44653111":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44653111","ebayitemid":"404929359510","shopifyproductid":"8243501957342","variants":[{"price":"89.99","quantity":0,"weight":"3","shopifyproductid":"8243501957342","shopifyvariantid":"44627390857438","shopifyinventoryid":"46725372444894","shopifylocationid":"","product_id":"44653111","variant_id":"77558300","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44717740":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44717740","ebayitemid":"286133586057","shopifyproductid":"8719458631902","variants":[{"price":"89.99","quantity":0,"weight":"3","shopifyproductid":"8719458631902","shopifyvariantid":"45993120596190","shopifyinventoryid":"48091462303966","shopifylocationid":"","product_id":"44717740","variant_id":"77625359","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-12 12:40:15 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-12 12:40:15 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 12:40:15 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 12:40:15 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 12:40:15 [INFO]: Shopify Inventory id 48034617721054
2025-08-12 12:40:15 [INFO]: Shopify Location id 58450641063
2025-08-12 12:40:15 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 12:40:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T12:40: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-12 12:40:15 [INFO]: Change: available | Delta: -1
2025-08-12 12:40:15 [INFO]: Change: on_hand | Delta: -1
2025-08-12 12:40:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 12:40:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44690207 and user_id = 14409 
2025-08-12 12:40:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77595459 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 12:40:15 [INFO]: Shopify Inventory id 46725372444894
2025-08-12 12:40:15 [INFO]: Shopify Location id 58450641063
2025-08-12 12:40:15 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 12:40:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T12:40: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-12 12:40:16 [INFO]: Change: available | Delta: -1
2025-08-12 12:40:16 [INFO]: Change: on_hand | Delta: -1
2025-08-12 12:40:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 12:40:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44653111 and user_id = 14409 
2025-08-12 12:40:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77558300 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 12:40:16 [INFO]: Shopify Inventory id 48091462303966
2025-08-12 12:40:16 [INFO]: Shopify Location id 58450641063
2025-08-12 12:40:16 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 12:40:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T12:40: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-12 12:40:16 [INFO]: Change: available | Delta: -1
2025-08-12 12:40:16 [INFO]: Change: on_hand | Delta: -1
2025-08-12 12:40:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 12:40:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44717740 and user_id = 14409 
2025-08-12 12:40:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77625359 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 12:40:16 [INFO]: updateIdsQuantity -> ["77595459","77558300","77625359"]
2025-08-12 12:40:16 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-12 12:40:16 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77595459 THEN 0 WHEN id = 77558300 THEN 0 WHEN id = 77625359 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77595459 THEN 0 WHEN id = 77558300 THEN 0 WHEN id = 77625359 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77595459,77558300,77625359)
2025-08-12 12:40:16 [INFO]: QUANTITY Updated IDs: 77595459, 77558300, 77625359
2025-08-12 12:40:16 [INFO]: Successfully processed data for user 14409
2025-08-12 12:40:16 [INFO]: Execution Started
2025-08-12 12:40:16 [INFO]: Execution Finished
2025-08-12 12:50:01 [INFO]: Execution Started
2025-08-12 12:50:01 [INFO]: old server sucessfully connected
2025-08-12 12:50:01 [INFO]: sqs client sucess created
2025-08-12 12:50:06 [INFO]: Number of messages in the queue: 0
2025-08-12 12:50:27 [INFO]: Execution Started
2025-08-12 12:50:27 [INFO]: Execution Finished