2025-08-07 22:00:02 [INFO]: Execution Started
2025-08-07 22:00:02 [INFO]: old server sucessfully connected
2025-08-07 22:00:02 [INFO]: sqs client sucess created
2025-08-07 22:00:03 [INFO]: Number of messages in the queue: 0
2025-08-07 22:00:23 [INFO]: Execution Started
2025-08-07 22:00:23 [INFO]: Execution Finished
2025-08-07 22:10:01 [INFO]: Execution Started
2025-08-07 22:10:01 [INFO]: old server sucessfully connected
2025-08-07 22:10:01 [INFO]: sqs client sucess created
2025-08-07 22:10:02 [INFO]: Number of messages in the queue: 0
2025-08-07 22:10:22 [INFO]: Execution Started
2025-08-07 22:10:22 [INFO]: Execution Finished
2025-08-07 22:20:01 [INFO]: Execution Started
2025-08-07 22:20:01 [INFO]: old server sucessfully connected
2025-08-07 22:20:01 [INFO]: sqs client sucess created
2025-08-07 22:20:02 [INFO]: Number of messages in the queue: 4
2025-08-07 22:20:02 [INFO]: item found in queue is if condition  14409
2025-08-07 22:20:02 [INFO]: item found in queue is  14409
2025-08-07 22:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBd9/3ATTS91j84+H9Tq0SxBizE6nCflXtgHxN8BGTFJivRIgKgwth1BPamTVRHEo9nMpp1FRw7XS9ma3/zNAijEb7pcH0rGHJH1Bx3gUwaL5ubhPZrfci4DcruAkMO72C9oBqvfzd4q3KLbbIsYY698Ec206RnWr9haVOhDEXwwCanpXl4I8IBqpEOneeizpF01onVOYwC2lITwi8bT7hDnoO5NJ5+0262XPDW/0sZueWLhmT6tG89qfoh6DHKAEFzEZ5/mwafmzFnnTWz0GG+lotmtw0XP1EWwDhkRmCesSAdQMSeb5JbTqgAMbe3Zdmx94GyXU8ADdGK2QAH7pmEsTPmmDCkWqin+Q2trPJvlFAZBM6aSyZ5mJrl9laqWDLraZWJTn4UjjpqaY/OLICMW8HjlkulCOarizLyHncUTW5Bnw5mMJ4sDqNRIbLN4Ln
2025-08-07 22:20:03 [INFO]: item found in queue is if condition  14409
2025-08-07 22:20:03 [INFO]: item found in queue is  14409
2025-08-07 22:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBmGawWdwUYpm7h/oou+zx94uAnpHDPSo2QIvd7d/MOoRAYRWHCCEJJv62gO5JfmPRIpTEmyR7cql/WFEVDh2W95rzeXfBhzpbdj1GChv7kVKp5KOnZ8qaohN+SZDqdiDS1ix5ipwkCjlkNUy/1ttmCPbBHeoFzE3eAbyocvN6KhHa9fU/v6lEuFuZ2KZso4EtUZgIfhY5SAk7l2Xsfntd4bPXyzY7i8lWw9eiSYDa3H9n/lDz3FpKEjO9t0DfLxB4zzrlHT25j/iDirgNAcsQJbPj9jRrtaNvqhavLaKSw71yLBUt3MRGl+EqsPFVZK9xk2+kBUSxRMAHxvOBq6CVvrKsfDntAuGyMG7ujXibV1T0mk+9usyZyyTwJyI7orarYq9xvJ4j7flhM4M9Fkj1A5gRxfjEgSK1c6HzAlnw1uANl6TXTCiHdvrVBAkCTndy
2025-08-07 22:20:03 [INFO]: item found in queue is if condition  14409
2025-08-07 22:20:03 [INFO]: item found in queue is  14409
2025-08-07 22:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBoRrSegC64teACdQlrrEAsbu2kRtaSSiFMpXGWhGMOg8OECEadVhcMuzR9mQSugLVdNLeLw9rVFRBK9rm/SNojHvGdDh9Bowki7YkgHjAQx5UpR4JS55F+CbwZ1c3POKACRLVUeJ7di592YLyl42URHsXzDw4/HQ52lF0OQc/e7f6fZoTcn3PMYU7/tEpoB6/Lkg/Se2opY+/F/dMX+XKPEBseFJtwxKVxKh5kfY/IIsYJv8W0Q8557OBaPx9iYRiRKnruy8GqCDH9bBbcrltUo1V0iPOJVQN0a2IWQaMwnA2cWUjSb7lkjmlE63xX7+ImvwEf1Ai1m4x+9rEVjCayLF8A0a2U2xiFnCVj3AVH54DolUlND0QjhfbvRCYmY8aXYAcg1uGavHDCnbG5g6sqCPQUmEr3CgHdcRpeNJ72md0IvfZC6JrcNS6XF5/ks9u
2025-08-07 22:20:04 [INFO]: item found in queue is if condition  14409
2025-08-07 22:20:04 [INFO]: item found in queue is  14409
2025-08-07 22:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBvzTH8gItGmARqYcO8FZi2q3wxpUZ/q8/6YUlap89TY+ZBWU2G1whJRCB8fX22he3fyOTm/UJRenq2mYlRyMBgXwbIsROM0mwSHZjhxVXe9Jig+fMFXkGM0DiZLra1dxdnEyyfMHvNL2Jf2kpRhIlLZXJ5cXyZKdyGYvfA6HHMQVj3FwjVqYQ1nlq2MfRumB9xW9Wx8B/++xW+Y4Qp01tFty54fsJtTvBOSP4Sc/VFsJmOwiWt/JVE5ErZI4Lcqkksq37iBYfFmhbvbssx6ZgDM89L+Wf7Q3STw2kjIvCIJiw1MfwO2+B9Ayn2wwcraU/jhmoobx3g2KaYmMZ8jb7DI0bLGJZ4pPY2aOBWd9q4q16yWwZvnGLj+yw5z57gaTqe551uc9y8lfMZ+Ii0Ujc6FSTfBKF12cEVHKBsurCh9UDoI70RzL/OtdzMDd/te+G
2025-08-07 22:20:04 [INFO]: Processed 4 messages, reached the limit of 4.
2025-08-07 22:20:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-07 22:20:04 [INFO]: inside itemsold and closed 14409
2025-08-07 22:20:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 22:20:06 [INFO]: autolink for user_id 14409 is 1
2025-08-07 22:20:06 [INFO]: Ebay item id :: 335352109145 exists in Database
2025-08-07 22:20:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 22:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 22:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 22:20:06 [INFO]: inside itemsold and closed 14409
2025-08-07 22:20:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 22:20:07 [INFO]: autolink for user_id 14409 is 1
2025-08-07 22:20:07 [INFO]: Ebay item id :: 285816879428 exists in Database
2025-08-07 22:20:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 22:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 22:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 22:20:07 [INFO]: inside itemsold and closed 14409
2025-08-07 22:20:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 22:20:09 [INFO]: autolink for user_id 14409 is 1
2025-08-07 22:20:09 [INFO]: Ebay item id :: 285816868790 exists in Database
2025-08-07 22:20:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 22:20:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 22:20:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 22:20:09 [INFO]: inside itemsold and closed 14409
2025-08-07 22:20:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 22:20:11 [INFO]: autolink for user_id 14409 is 1
2025-08-07 22:20:11 [INFO]: Ebay item id :: 285816861171 exists in Database
2025-08-07 22:20:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 22:20:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 22:20:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 22:20:11 [INFO]: in processold action queue is array    for {"44576143":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44576143","ebayitemid":"335352109145","shopifyproductid":"7699343540446","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"7699343540446","shopifyvariantid":"42995327697118","shopifyinventoryid":"45090525446366","shopifylocationid":"","product_id":"44576143","variant_id":"77468850","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44576175":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44576175","ebayitemid":"285816879428","shopifyproductid":"6803901743271","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"6803901743271","shopifyvariantid":"40216121770151","shopifyinventoryid":"42311382630567","shopifylocationid":"","product_id":"44576175","variant_id":"77468882","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44576152":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44576152","ebayitemid":"285816868790","shopifyproductid":"7694387183838","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"7694387183838","shopifyvariantid":"42971746664670","shopifyinventoryid":"45066922066142","shopifylocationid":"","product_id":"44576152","variant_id":"77468859","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44576128":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44576128","ebayitemid":"285816861171","shopifyproductid":"7699540312286","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"7699540312286","shopifyvariantid":"42995875152094","shopifyinventoryid":"45091073065182","shopifylocationid":"","product_id":"44576128","variant_id":"77468835","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-07 22:20:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-07 22:20:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 22:20:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 22:20:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 22:20:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 22:20:11 [INFO]: Shopify Inventory id 45090525446366
2025-08-07 22:20:11 [INFO]: Shopify Location id 58450641063
2025-08-07 22:20:11 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 22:20:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T22:20:11Z","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-07 22:20:11 [INFO]: Change: available | Delta: -1
2025-08-07 22:20:11 [INFO]: Change: on_hand | Delta: -1
2025-08-07 22:20:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 22:20:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44576143 and user_id = 14409 
2025-08-07 22:20:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77468850 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 22:20:11 [INFO]: Shopify Inventory id 42311382630567
2025-08-07 22:20:11 [INFO]: Shopify Location id 58450641063
2025-08-07 22:20:11 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 22:20:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T22: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-07 22:20:12 [INFO]: Change: available | Delta: -1
2025-08-07 22:20:12 [INFO]: Change: on_hand | Delta: -1
2025-08-07 22:20:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 22:20:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44576175 and user_id = 14409 
2025-08-07 22:20:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77468882 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 22:20:12 [INFO]: Shopify Inventory id 45066922066142
2025-08-07 22:20:12 [INFO]: Shopify Location id 58450641063
2025-08-07 22:20:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 22:20:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T22: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-07 22:20:12 [INFO]: Change: available | Delta: -1
2025-08-07 22:20:12 [INFO]: Change: on_hand | Delta: -1
2025-08-07 22:20:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 22:20:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44576152 and user_id = 14409 
2025-08-07 22:20:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77468859 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 22:20:12 [INFO]: Shopify Inventory id 45091073065182
2025-08-07 22:20:12 [INFO]: Shopify Location id 58450641063
2025-08-07 22:20:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 22:20:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T22: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-07 22:20:12 [INFO]: Change: available | Delta: -1
2025-08-07 22:20:12 [INFO]: Change: on_hand | Delta: -1
2025-08-07 22:20:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 22:20:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44576128 and user_id = 14409 
2025-08-07 22:20:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77468835 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 22:20:12 [INFO]: updateIdsQuantity -> ["77468850","77468882","77468859","77468835"]
2025-08-07 22:20:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4
2025-08-07 22:20:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77468850 THEN 0 WHEN id = 77468882 THEN 0 WHEN id = 77468859 THEN 0 WHEN id = 77468835 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77468850 THEN 0 WHEN id = 77468882 THEN 0 WHEN id = 77468859 THEN 0 WHEN id = 77468835 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77468850,77468882,77468859,77468835)
2025-08-07 22:20:12 [INFO]: QUANTITY Updated IDs: 77468850, 77468882, 77468859, 77468835
2025-08-07 22:20:12 [INFO]: Successfully processed data for user 14409
2025-08-07 22:20:12 [INFO]: Execution Started
2025-08-07 22:20:12 [INFO]: Execution Finished
2025-08-07 22:30:01 [INFO]: Execution Started
2025-08-07 22:30:01 [INFO]: old server sucessfully connected
2025-08-07 22:30:01 [INFO]: sqs client sucess created
2025-08-07 22:30:02 [INFO]: Number of messages in the queue: 4
2025-08-07 22:30:02 [INFO]: item found in queue is if condition  14409
2025-08-07 22:30:02 [INFO]: item found in queue is  14409
2025-08-07 22:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBjblQUkAchI5hPEtk6koxqQTEq/OrvaMDZybeXIL9qT1XWeRe/5E/cUx0S5+oGqLIstYS6cmoSSykkWjdROAcM8vx4zeLEc6JAYQRFAHi5Z47AHZUAyZjMcjtB7zjPFeehsHNPaMHYWfCru+r4wv5YWJ0K6jS8kua0/FQKmmvU06tiUOfr7MQQ6GePqL4hKPXpMsJ5yGRKaYBxAbQtxmkjJzSSFP9z9ZWQB/cTZzNKwxJTHUC53AumTtuAtKEkty6c7PN8wEzlagvLTErUu0skQn11Ohlq3TXahtG97griII4z6uDmoCyIeUI/GlFJX3dwPanN0N3pyLRNrAHRMPfoMde2NKXUsy563KCWjQuV3sqDCCGv6S1aLdjuto71EvQ8Tex+/5VF8yholBM+G/yBb+4i8ukwcGT8dVid6VLBFSgdqBx1+8scqPmR7CSZ5i8
2025-08-07 22:30:03 [INFO]: item found in queue is if condition  14409
2025-08-07 22:30:03 [INFO]: item found in queue is  14409
2025-08-07 22:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBYoUqiHrN/2WEEmimPx1KG7el0bczUR1B4Q5pVPesVlKzKCwzt10EwDArUXgY3JNhHx274in0p1CQXw0x6NreCJkn9uUWzaKC/xVWI9O2CyHZlO2pJGOJVNbdlhxDDGWW3ELcyeYLQon71M1UgeZAguTYiDFJlXdKCXJuQfgqX2lS2UdLxZzlNdDM14PFc5HrAoah4ig83hySg50O4799lgcFJul2J5hXm21EZ6HRbAEV6clEfr5PyKKQH9rwIzYqZrSR+b+dsBlMAGKK2PUK1GQfJhFSBL7K2HS6xoNcFD0QNlE7M1BKkJbtIwbmoOZEp4TgPriSykSN0+vuqG/ijDWbWFSy5cCSJaPuizCQfnSIB0iIX6n9xirqgzd4U0eZlLHTObXARuZ3T3//A2OKsHklMGKt//UbWF10Awyiw6ov4Qb/nbHQwyvDhipfbTs+
2025-08-07 22:30:03 [INFO]: item found in queue is if condition  14409
2025-08-07 22:30:03 [INFO]: item found in queue is  14409
2025-08-07 22:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBeUb/5PXtpC6c6Tp8LNDhkfJFzkmn1+Qj7AWCzmM78sr7fDzP4vCIVL8V3xR2nI60F3pWVCzSygjcISFoBr7d5xa+E48R2phQxs50J85tckfw85SE9VUc7zbV2JwiqzefwSmZhHGF2OzySIKKlrn/Ynq3oyLHSBU/+kiteoF0x7R+oJrJk3NZMcPcctXo4waR98BadIHOXxBqwr51ZqrVlXkgPZLu5GXTCC7nTWuis5bzB2//xSE6Fbo+7QrVf393/HL/nE+3WO8aex1MT0KrTMkTgUoh8dWUw/vV3l5efVCu+ZuU98hQhHmZXFYnb1peeui1cvisr+b0Zr4Vx2xerFhjaR/CoQVF/RwQRIL+szadV3ueg3VwaEw4TkCP0l1+ulObWsRWLBC5MU3yluyt6850Er7ZJCqpgdpxRB5jfvAnm4hkKEmvhMyaikMBt5PZ
2025-08-07 22:30:04 [INFO]: item found in queue is if condition  14409
2025-08-07 22:30:04 [INFO]: item found in queue is  14409
2025-08-07 22:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBuvhfOeOKeVUh4msi5Ld2te6+4Alcbo5kb+8vQ0MDdEtPpQkUJd6upE+2zmKBGsQvC1Pxf9VwvahzpWdTRH+LxQa9LfyEDZVXmHMeEew92GW9HkRYPObEz5he7fVnzVGE1faQfSwihnvq+NBSgYD/P+8/NzaMLttyiTh2wIj1tywFFWYDahBZQJdN3U3p3E2/Z9kCYj0uIRdU9Ac21YxpPDhiSW7ozEMBdwKZTei1C4IghEzQyt3UM/n+uzIQ+VTcoPRiHgDyVTbkHP5NVCcbxTTio1TGr6sWCAw7PuYhGRQMlnjYS3w+0CBsu/JOcK8GzbfANkGCPGjDtFCWjk4Ue00kbLkn7GtRX7gRz1UIhzcnkp2UqahUPiWRKytiDX3pBU+3f+efXa+qseE/rvDBDgZRXkQZjn9g+XMzfHa00Vq9xw48YXo4PSwet3tFG0QE
2025-08-07 22:30:04 [INFO]: Processed 4 messages, reached the limit of 4.
2025-08-07 22:30:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-07 22:30:04 [INFO]: inside itemsold and closed 14409
2025-08-07 22:30:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 22:30:06 [INFO]: autolink for user_id 14409 is 1
2025-08-07 22:30:06 [INFO]: Ebay item id :: 335352146215 exists in Database
2025-08-07 22:30:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 22:30:06 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-07 22:30:06 [INFO]: inside itemsold and closed 14409
2025-08-07 22:30:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 22:30:08 [INFO]: autolink for user_id 14409 is 1
2025-08-07 22:30:08 [INFO]: Ebay item id :: 335352138614 exists in Database
2025-08-07 22:30:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 22:30:08 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-07 22:30:08 [INFO]: inside itemsold and closed 14409
2025-08-07 22:30:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 22:30:09 [INFO]: autolink for user_id 14409 is 1
2025-08-07 22:30:09 [INFO]: Ebay item id :: 285816882996 exists in Database
2025-08-07 22:30:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 22:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 22:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 22:30:09 [INFO]: inside itemsold and closed 14409
2025-08-07 22:30:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 22:30:12 [INFO]: autolink for user_id 14409 is 1
2025-08-07 22:30:12 [INFO]: Ebay item id :: 335352143146 exists in Database
2025-08-07 22:30:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 22:30:12 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-07 22:30:12 [INFO]: in processold action queue is array    for {"45144015":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45144015","ebayitemid":"335352146215","deleted":1}},"45144005":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45144005","ebayitemid":"335352138614","deleted":1}},"44576181":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44576181","ebayitemid":"285816882996","shopifyproductid":"6733677789351","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"6733677789351","shopifyvariantid":"40036482777255","shopifyinventoryid":"42131701989543","shopifylocationid":"","product_id":"44576181","variant_id":"77468888","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45144011":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45144011","ebayitemid":"335352143146","deleted":1}}}
2025-08-07 22:30:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-07 22:30:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 22:30:12 [INFO]: productIds WHich are having null productid -> [45144015,45144005,45144011]
2025-08-07 22:30:12 [INFO]: ebayItemIds WHich are not imported-> ["335352146215","335352138614","335352143146"]
2025-08-07 22:30:12 [INFO]: Entered in bulkUpdateProducts function
2025-08-07 22:30:12 [INFO]: Transaction started for bulkUpdateProducts
2025-08-07 22:30:12 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45144015,45144005,45144011)
2025-08-07 22:30:12 [INFO]: Query executed successfully. Affected rows: 0
2025-08-07 22:30:12 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-07 22:30:12 [INFO]: Transaction committed successfully.
2025-08-07 22:30:12 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-07 22:30:12 [INFO]: Shopify Inventory id 42131701989543
2025-08-07 22:30:12 [INFO]: Shopify Location id 58450641063
2025-08-07 22:30:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 22:30:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T22:30: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-07 22:30:12 [INFO]: Change: available | Delta: -1
2025-08-07 22:30:12 [INFO]: Change: on_hand | Delta: -1
2025-08-07 22:30:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 22:30:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44576181 and user_id = 14409 
2025-08-07 22:30:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77468888 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 22:30:12 [INFO]: updateIdsQuantity -> ["77468888"]
2025-08-07 22:30:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-07 22:30:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77468888 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77468888 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77468888)
2025-08-07 22:30:12 [INFO]: QUANTITY Updated IDs: 77468888
2025-08-07 22:30:12 [INFO]: Successfully processed data for user 14409
2025-08-07 22:30:12 [INFO]: Execution Started
2025-08-07 22:30:12 [INFO]: Execution Finished
2025-08-07 22:40:02 [INFO]: Execution Started
2025-08-07 22:40:02 [INFO]: old server sucessfully connected
2025-08-07 22:40:02 [INFO]: sqs client sucess created
2025-08-07 22:40:03 [INFO]: Number of messages in the queue: 5
2025-08-07 22:40:03 [INFO]: item found in queue is if condition  14409
2025-08-07 22:40:03 [INFO]: item found in queue is  14409
2025-08-07 22:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEB8N6UnPQ5ZEKPZemNS49MgfBTVKxDZqHn2F7ixMHUDouys8ACPFk8q7ZFFfJAzuUrNtnG5xkl/vILCIkru23VEQeMRKrZx+i/bfbWeEsrnGx4TTRw/4ghu+Nd6owfBayhywr9peUxgNobjxOWH/cth+XpWCojxqeQk+Z1SgGAtKRuNCZOIO95BRHaKCP8osZRUgA9P9o674Q22BzVUwjoulVm3EaBG+e9WX+TBOfGy4Fs4eXk39Pt3vcvL/nHBWZP7xZvRcrbFhT/uBmpQMdPyGk9ZlGWSIMBCqGqKzdu+a3efrzmpzLgx4DpI3lVI14pjGDZYRigMDIlBblfx7lXBSgXetVl9ANkMT6v1IUf8Ky7jjhwC1VAzi5KcbW3mCf0+qKXmPJXdg+4j9OYqvqNmyP23rXMmAE63WX5P3jyf9TpB7cxysGwBAb4SPW54/Gm
2025-08-07 22:40:04 [INFO]: item found in queue is if condition  14409
2025-08-07 22:40:04 [INFO]: item found in queue is  14409
2025-08-07 22:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEB+FOrjKM9OpxArAbCwrw58qr1ie5lKUCEcE7YF7ETkVzClkxsPTb359MzQaDWUiqNkM+FhQmM4aNwJPhrYSF7+sL6xSCVyyiaJy41ixmZz5BqejB0uwmUBU4jcuCqkDGtfQYQA9yUKrZ3LZVfyZVYMHh9YjrS6tRzFYNKQmgT2VK2uO7ku9LKDcztoGQnkTtOcaE21ixlEG4H1ShfWMPAKqy3wit7YlMLbNTp04lGsQOqEyTi/Wp5sTK0eoMKlQPrqLXoCkW01kMgg32yKKUgaOYORAjQcfgI1sGnQ8USOqfAKpNaiWzOgvzUXki5FRcqKD9f5xogo0qY80S8HfcFANoZ5Wdzjf1/2MZWUmfhORP8YpAcuNF/P1cDE1HGr0Giw2h0KwIgdiUhCB0UYLIII9TocprJitnugGZHbnZk+7tU4290MRaPCzX3ZDhcmuQn
2025-08-07 22:40:04 [INFO]: item found in queue is if condition  14409
2025-08-07 22:40:04 [INFO]: item found in queue is  14409
2025-08-07 22:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEB6KcjAPa9ktLxIieW3Gab5/sw2SY1F0lPK4+fqOn1aW7a2uyENBM2frLWqFqe+J80lmqZ+T35jsgwHHXwdaOFzmlseBGvfSfFQexpbudN83KS8qyIRDd7SvqEwLTDPvna3N08uevspRiXGCV+KqjsGZv9t5zFOHElKApEdiIjal69pre+Qq+hqzyrSNTwJ3u+jL1HWOIBtEN4MPBUfSqxC+K9is56ofvWdR1EKUZ8NLr4uTp9HlTKIUKKhVUjwbHl0EPUaiaFwRvyTZIKGKTsDREe2XmkDap2B0qNVh/xX0FaQfF2h5+ImORhkwvf3PNNsneNOqVtg6FUhy8uNk0yY1kyrQvr0V87KTVC6/2Vlnr5OzXoGzamWZjdm9KhefjSXondzH5mMXiwJSw2AZ+RgjO7Wd/hx6eIxVLA8/fU4nWqY6Z5F3mmi9+FuUV8Dgag
2025-08-07 22:40:05 [INFO]: item found in queue is if condition  14409
2025-08-07 22:40:05 [INFO]: item found in queue is  14409
2025-08-07 22:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEBOqGP4hDBGyazMRkcaGckREUC3pUGG3q51lPT0e6XT43hiXqrZBm8bt9A6uWG27ksQUPFoNHPB4jOXd4sfEycELg8rzqhhaMML9Hn1EeoOAVCdrl4B7ofKDZnw5X/OlaMI/2fwt5nLNtLeQwGq+THwDVX0Goep5N08NZe3LEuMBruM6uXilrlXabX8RexHr2Vjuz6s/OjX8xG5Kxioj0QPeYafClXR6BGj3IJlJqWVHJOTos/PwKZ0kbWo1pbdMjJysIt1Kl67fTud8jcGm6vS67w4KtDOWvyziuv5eyr+lJSZTn0bpxdd+nBetM67jIM5Syr2QJQ/LLns5gnn9i5LRu+2HojWKVMnvw5wNOTVzfgWrdcFGlfK6kjAUZ/566Jv0Yo7LUP5NNdJsjdXST8eWHWMGMKJhofcQrl8JIhi0Z1kLdZ8lfM7lWN4EHCy0Zy
2025-08-07 22:40:05 [INFO]: item found in queue is if condition  14409
2025-08-07 22:40:05 [INFO]: item found in queue is  14409
2025-08-07 22:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEBpkHa4c9nxUabY11h5HrHDeWLEpOqxgwQ632OJCYX4ecYEXtQ6TLB1DdhMPDgAiF09FMS7s9Gre9mfuOz3wkjKUESUNnPu8NOmSkuhHNy0B58f+ogi0jUbVrVMVGRLuFE3IZliNxqVHCe2kD4O+2ASMn4xLKm6HhRauXQIuawNeJ3suTjWMSpgOtNByL8rBRnRZA9E/SDVhf8PPwJhrFs3SJV+nRfWMniAq7uD5wJUhVgJjgUsh90U2Mu1gWeICK5P8rujqFUkRoP+zOt1el5j3GGJbVC7WvGiuz1qIFw3PN8NeSYlMmvuggZeyA7RXXsyb4/gLgCZxpDBxfB+hDHt3jrAC9w+uRQG7BkGbfBKBm64aEeRXHWmgxaOtq6YDJOnd7MOzSHqdg6wxWe7iiiVBMGdRJTVVNRo+8nb6G7jVFfcn5+mUDybwBSno8yHE+E
2025-08-07 22:40:05 [INFO]: Processed 5 messages, reached the limit of 5.
2025-08-07 22:40:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-07 22:40:05 [INFO]: inside itemsold and closed 14409
2025-08-07 22:40:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 22:40:07 [INFO]: autolink for user_id 14409 is 1
2025-08-07 22:40:07 [INFO]: Ebay item id :: 335352152711 exists in Database
2025-08-07 22:40:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 22:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 22:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 22:40:07 [INFO]: inside itemsold and closed 14409
2025-08-07 22:40:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 22:40:09 [INFO]: autolink for user_id 14409 is 1
2025-08-07 22:40:09 [INFO]: Ebay item id :: 285549427321 exists in Database
2025-08-07 22:40:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 22:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 22:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 22:40:09 [INFO]: inside itemsold and closed 14409
2025-08-07 22:40:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 22:40:10 [INFO]: autolink for user_id 14409 is 1
2025-08-07 22:40:10 [INFO]: Ebay item id :: 335352119053 exists in Database
2025-08-07 22:40:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 22:40:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 22:40:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 22:40:10 [INFO]: inside itemsold and closed 14409
2025-08-07 22:40:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 22:40:12 [INFO]: autolink for user_id 14409 is 1
2025-08-07 22:40:12 [INFO]: Ebay item id :: 405826318227 exists in Database
2025-08-07 22:40:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 22:40:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 22:40:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 22:40:12 [INFO]: inside itemsold and closed 14409
2025-08-07 22:40:14 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 22:40:14 [INFO]: autolink for user_id 14409 is 1
2025-08-07 22:40:14 [INFO]: Ebay item id :: 306366717131 exists in Database
2025-08-07 22:40:14 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 22:40:14 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-07 22:40:14 [INFO]: in processold action queue is array    for {"44576227":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44576227","ebayitemid":"335352152711","shopifyproductid":"6680410947751","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"6680410947751","shopifyvariantid":"39865747800231","shopifyinventoryid":"41960657780903","shopifylocationid":"","product_id":"44576227","variant_id":"77468934","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44767833":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44767833","ebayitemid":"285549427321","shopifyproductid":"8197104763102","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8197104763102","shopifyvariantid":"44503082467550","shopifyinventoryid":"46601017589982","shopifylocationid":"","product_id":"44767833","variant_id":"77676375","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44576163":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44576163","ebayitemid":"335352119053","shopifyproductid":"8407671832798","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8407671832798","shopifyvariantid":"45198794227934","shopifyinventoryid":"47296703955166","shopifylocationid":"","product_id":"44576163","variant_id":"77468870","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44785257":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44785257","ebayitemid":"405826318227","shopifyproductid":"8917841084638","variants":[{"price":"10.99","quantity":0,"weight":"0.9375","shopifyproductid":"8917841084638","shopifyvariantid":"46726878265566","shopifyinventoryid":"48825365659870","shopifylocationid":"58450641063","product_id":"44785257","variant_id":"77694697","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45157727":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45157727","ebayitemid":"306366717131","deleted":1}}}
2025-08-07 22:40:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-07 22:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 22:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 22:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 22:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 22:40:14 [INFO]: productIds WHich are having null productid -> [45157727]
2025-08-07 22:40:14 [INFO]: ebayItemIds WHich are not imported-> ["306366717131"]
2025-08-07 22:40:14 [INFO]: Entered in bulkUpdateProducts function
2025-08-07 22:40:14 [INFO]: Transaction started for bulkUpdateProducts
2025-08-07 22:40:14 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45157727)
2025-08-07 22:40:14 [INFO]: Query executed successfully. Affected rows: 0
2025-08-07 22:40:14 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-07 22:40:14 [INFO]: Transaction committed successfully.
2025-08-07 22:40:14 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-07 22:40:14 [INFO]: Shopify Inventory id 41960657780903
2025-08-07 22:40:14 [INFO]: Shopify Location id 58450641063
2025-08-07 22:40:14 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 22:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T22:40:14Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-07 22:40:14 [INFO]: Change: available | Delta: -2
2025-08-07 22:40:14 [INFO]: Change: on_hand | Delta: -2
2025-08-07 22:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 22:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44576227 and user_id = 14409 
2025-08-07 22:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77468934 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 22:40:14 [INFO]: Shopify Inventory id 46601017589982
2025-08-07 22:40:14 [INFO]: Shopify Location id 58450641063
2025-08-07 22:40:14 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 22:40:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T22: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-07 22:40:15 [INFO]: Change: available | Delta: -1
2025-08-07 22:40:15 [INFO]: Change: on_hand | Delta: -1
2025-08-07 22:40:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 22:40:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44767833 and user_id = 14409 
2025-08-07 22:40:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77676375 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 22:40:15 [INFO]: Shopify Inventory id 47296703955166
2025-08-07 22:40:15 [INFO]: Shopify Location id 58450641063
2025-08-07 22:40:15 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 22:40:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T22:40:15Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-07 22:40:15 [INFO]: Change: available | Delta: -2
2025-08-07 22:40:15 [INFO]: Change: on_hand | Delta: -2
2025-08-07 22:40:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 22:40:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44576163 and user_id = 14409 
2025-08-07 22:40:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77468870 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 22:40:15 [INFO]: Shopify Inventory id 48825365659870
2025-08-07 22:40:15 [INFO]: Shopify Location id 58450641063
2025-08-07 22:40:15 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 22:40:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1928,"restoreRate":100}}}}
2025-08-07 22:40:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 22:40:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44785257 and user_id = 14409 
2025-08-07 22:40:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77694697 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 22:40:15 [INFO]: updateIdsQuantity -> ["77468934","77676375","77468870","77694697"]
2025-08-07 22:40:15 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4
2025-08-07 22:40:15 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77468934 THEN 0 WHEN id = 77676375 THEN 0 WHEN id = 77468870 THEN 0 WHEN id = 77694697 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77468934 THEN 0 WHEN id = 77676375 THEN 0 WHEN id = 77468870 THEN 0 WHEN id = 77694697 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77468934,77676375,77468870,77694697)
2025-08-07 22:40:15 [INFO]: QUANTITY Updated IDs: 77468934, 77676375, 77468870, 77694697
2025-08-07 22:40:15 [INFO]: Successfully processed data for user 14409
2025-08-07 22:40:15 [INFO]: Execution Started
2025-08-07 22:40:15 [INFO]: Execution Finished
2025-08-07 22:50:01 [INFO]: Execution Started
2025-08-07 22:50:01 [INFO]: old server sucessfully connected
2025-08-07 22:50:01 [INFO]: sqs client sucess created
2025-08-07 22:50:03 [INFO]: Number of messages in the queue: 0
2025-08-07 22:50:23 [INFO]: Execution Started
2025-08-07 22:50:23 [INFO]: Execution Finished
2025-08-07 22:51:16 [INFO]: Execution Started
2025-08-07 22:51:16 [INFO]: old server sucessfully connected
2025-08-07 22:51:16 [INFO]: sqs client sucess created
2025-08-07 22:51:17 [INFO]: Number of messages in the queue: 1
2025-08-07 22:51:17 [INFO]: item found in queue is if condition  14409
2025-08-07 22:51:17 [INFO]: item found in queue is  14409
2025-08-07 22:51:17 [INFO]: Message deleted from the queue for receipt handle: AQEBU47pdcrOv5VXtJ2kdgELXMWLXitnw7tHSFEwGcxEACJBB791XAf+1VummtiPTtXB8tP+FF1wAxMCmFnzeef+L+SYYSj0tUdv8Z/9t8uCw/KTrqLJG+490qu8nPyNDmShpmzQ/s5WpEPwFss3tmE3kmLgkmb3B0hPbulMMZi7cJ6FONXMfemaod6m8hiQxCL5fqcEYg2AyPB3qOb+1uni5Z2pNbZgmMeusP+w/iWb7d0CP9W9bL9AgqRMwFiJpbk4rbm5oX4ASTpABeVPWjqvuH/CD5llaJx6LC3/kXTR+P8rhQ9q79DqiE2+O7G9EpzgLkepXEgS3ufr5vBNVf2aGxUEzAoOV+ZT5V62ROyZNpChQktrkcMJ7rg0CJ4E21Xqw0M92EVmqfb9SH7gzhvvD1VueqMQWestDUoYAt4IV0QW4IyZC7M2eP5hdnvDTfB2
2025-08-07 22:51:17 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-07 22:51:17 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-07 22:51:17 [INFO]: inside itemsold and closed 14409
2025-08-07 22:51:19 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 22:51:19 [INFO]: autolink for user_id 14409 is 1
2025-08-07 22:51:19 [INFO]: Ebay item id :: 305846040340 exists in Database
2025-08-07 22:51:19 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 22:51:19 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 22:51:19 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 22:51:19 [INFO]: in processold action queue is array    for {"44578106":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44578106","ebayitemid":"305846040340","shopifyproductid":"8708824039646","variants":[{"price":"60.99","quantity":0,"weight":"2","shopifyproductid":"8708824039646","shopifyvariantid":"45967716745438","shopifyinventoryid":"48066467365086","shopifylocationid":"","product_id":"44578106","variant_id":"77470813","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-07 22:51:19 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-07 22:51:19 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 22:51:19 [INFO]: Shopify Inventory id 48066467365086
2025-08-07 22:51:19 [INFO]: Shopify Location id 58450641063
2025-08-07 22:51:19 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 22:51:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T22:51:19Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-07 22:51:19 [INFO]: Change: available | Delta: -2
2025-08-07 22:51:19 [INFO]: Change: on_hand | Delta: -2
2025-08-07 22:51:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 22:51:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44578106 and user_id = 14409 
2025-08-07 22:51:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77470813 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 22:51:19 [INFO]: updateIdsQuantity -> ["77470813"]
2025-08-07 22:51:19 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-07 22:51:19 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77470813 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77470813 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77470813)
2025-08-07 22:51:19 [INFO]: QUANTITY Updated IDs: 77470813
2025-08-07 22:51:19 [INFO]: Successfully processed data for user 14409
2025-08-07 22:51:19 [INFO]: Execution Started
2025-08-07 22:51:19 [INFO]: Execution Finished