2025-08-06 14:00:02 [INFO]: Execution Started
2025-08-06 14:00:02 [INFO]: old server sucessfully connected
2025-08-06 14:00:02 [INFO]: sqs client sucess created
2025-08-06 14:00:04 [INFO]: Number of messages in the queue: 0
2025-08-06 14:00:25 [INFO]: Execution Started
2025-08-06 14:00:25 [INFO]: Execution Finished
2025-08-06 14:10:01 [INFO]: Execution Started
2025-08-06 14:10:01 [INFO]: old server sucessfully connected
2025-08-06 14:10:01 [INFO]: sqs client sucess created
2025-08-06 14:10:03 [INFO]: Number of messages in the queue: 0
2025-08-06 14:10:24 [INFO]: Execution Started
2025-08-06 14:10:24 [INFO]: Execution Finished
2025-08-06 14:20:01 [INFO]: Execution Started
2025-08-06 14:20:01 [INFO]: old server sucessfully connected
2025-08-06 14:20:01 [INFO]: sqs client sucess created
2025-08-06 14:20:05 [INFO]: Number of messages in the queue: 0
2025-08-06 14:20:27 [INFO]: Execution Started
2025-08-06 14:20:27 [INFO]: Execution Finished
2025-08-06 14:30:01 [INFO]: Execution Started
2025-08-06 14:30:01 [INFO]: old server sucessfully connected
2025-08-06 14:30:01 [INFO]: sqs client sucess created
2025-08-06 14:30:05 [INFO]: Number of messages in the queue: 0
2025-08-06 14:30:26 [INFO]: Execution Started
2025-08-06 14:30:26 [INFO]: Execution Finished
2025-08-06 14:40:01 [INFO]: Execution Started
2025-08-06 14:40:01 [INFO]: old server sucessfully connected
2025-08-06 14:40:01 [INFO]: sqs client sucess created
2025-08-06 14:40:03 [INFO]: Number of messages in the queue: 1
2025-08-06 14:40:05 [INFO]: item found in queue is if condition  14409
2025-08-06 14:40:05 [INFO]: item found in queue is  14409
2025-08-06 14:40:06 [INFO]: Message deleted from the queue for receipt handle: AQEBWPzRYRwjh3Pu9LKSwvPcI362dHn7fzL/68L+P/Bh6GMnRZyQhkTngPqz+QPavhx4wUSfotA3JPmOExPbnyauYbzj4yBATJKGAL/5TOCLROevlK9ZmhPXvX5cmtGReqCBjlPDiKYxWzI9aN7M2hm9UYnyTNA4pTXBWyM69s/g/AuzkOXBK0hHlLnjYXHS84Iu5oI0fDKFFJ69pTEfx0tupiYIxDlq99IwgJvYQSoQmmjdqqxNXVHfzi7ub25N2rSLqe7Y2gckHx/hFe0OcJ4kzt+PxFuL/EOETe64bD7xK5qRLDeB7oB8idUlA1dv1okZbHU1QHBCRaAlkU8G+KVk/nRO2lH5iW8SQJntH6+HdB7Xf4VkRUanNuZJVHerR902SeydrvdfTRr4h5B5IDM0qDRBfp94fwC3fcrhnepm7Mw/A+YUw3hypHEP0lTyPS1D
2025-08-06 14:40:06 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-06 14:40:06 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 14:40:06 [INFO]: inside itemsold and closed 14409
2025-08-06 14:40:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 14:40:08 [INFO]: autolink for user_id 14409 is 1
2025-08-06 14:40:08 [INFO]: Ebay item id :: 226805662018 exists in Database
2025-08-06 14:40:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 14:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 14:40:08 [INFO]: in processold action queue is array    for []
2025-08-06 14:40:08 [INFO]: Successfully processed data for user 14409
2025-08-06 14:40:08 [INFO]: Execution Started
2025-08-06 14:40:08 [INFO]: Execution Finished
2025-08-06 14:50:01 [INFO]: Execution Started
2025-08-06 14:50:01 [INFO]: old server sucessfully connected
2025-08-06 14:50:01 [INFO]: sqs client sucess created
2025-08-06 14:50:05 [INFO]: Number of messages in the queue: 1
2025-08-06 14:50:05 [INFO]: item found in queue is if condition  14409
2025-08-06 14:50:05 [INFO]: item found in queue is  14409
2025-08-06 14:50:06 [INFO]: Message deleted from the queue for receipt handle: AQEBlqm4Stwz1UsPB+HQN6qP3345ZvDdad7pRH6aws3rygNzfLa69b5TUSLg5dvcH3HZDnVWrpeKxjP4jvHh1pk6O5gF21VKzSVKm9H8XmNRhflzk4PZYlM8N2q/VOMT3O7ESFDyteMwi5II+kgyyj4t6iQHKVKJUR3rQ6QqlZpHuRWwpAha579PvjMwhb51HaJ97TYC7kFbZhNFQ4w7vGvKclc70fLJyvA2RV0NUFqJEelpd0TM1PbJr07wcz8PoL3vcDVT7hp64G2uArfmDRaNhNbs0K2imosGj1OJVhPH4jRR4OcrKRzl1CxzOdWKSjIwo6jXQ8nZWiyU+/U7njwYO7xOFWIyevG/Oye1A3eNIom19Vsmm4Q/nRdtfRxYgyd45CrzBq0AKtE33GxyGMyOdboCt5LoLNHZgYCevwfmzUwxS8XGDPSVh0F5vg6Xumrg
2025-08-06 14:50:06 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-06 14:50:06 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 14:50:06 [INFO]: inside itemsold and closed 14409
2025-08-06 14:50:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 14:50:08 [INFO]: autolink for user_id 14409 is 1
2025-08-06 14:50:08 [INFO]: Ebay item id :: 335019137347 exists in Database
2025-08-06 14:50:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 14:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 14:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 14:50:08 [INFO]: in processold action queue is array    for {"44560668":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44560668","ebayitemid":"335019137347","shopifyproductid":"7886012219614","variants":[{"price":"10.99","quantity":0,"weight":"0.75","shopifyproductid":"7886012219614","shopifyvariantid":"43701703016670","shopifyinventoryid":"45797521883358","shopifylocationid":"","product_id":"44560668","variant_id":"77453348","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 14:50:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 14:50:08 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 14:50:08 [INFO]: Shopify Inventory id 45797521883358
2025-08-06 14:50:08 [INFO]: Shopify Location id 58450641063
2025-08-06 14:50:08 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 14:50:08 [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-06 14:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 14:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44560668 and user_id = 14409 
2025-08-06 14:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77453348 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 14:50:08 [INFO]: updateIdsQuantity -> ["77453348"]
2025-08-06 14:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-06 14:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77453348 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77453348 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77453348)
2025-08-06 14:50:08 [INFO]: QUANTITY Updated IDs: 77453348
2025-08-06 14:50:08 [INFO]: Successfully processed data for user 14409
2025-08-06 14:50:08 [INFO]: Execution Started
2025-08-06 14:50:08 [INFO]: Execution Finished