2025-08-02 21:00:01 [INFO]: Execution Started
2025-08-02 21:00:01 [INFO]: old server sucessfully connected
2025-08-02 21:00:01 [INFO]: sqs client sucess created
2025-08-02 21:00:02 [INFO]: Number of messages in the queue: 1
2025-08-02 21:00:02 [INFO]: item found in queue is if condition  14409
2025-08-02 21:00:02 [INFO]: item found in queue is  14409
2025-08-02 21:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBDcg+bFSdkMxkm1kr6BWO9KyBg3KdohqUFM2tDOunJMRwZeWw9b0duMkpucE+2BrWi2/ULjNmcOOhs/JBUYWglnj5TxmuMuDlRPQ6xSKf9gPF+7Qi5gefHmOd46O+drvIkWV0X0WL78c+r8wlT7Ba8ao6B4HthEFnd8C+8U/c2cgu1IzBfdr9Dobk6IrEGiy61AeAoF1SxrGWKkV7ocsY/MgOLLwS29tP04L+hX6PMES8ipBeQSq8WWgbU43i8/c8OTlD/JMGYJ3he4xM470O5Vz57ABZN4A1+MVTevtj3aYrbx47W0+ah3YbzWJj+DKPHx0MA0ovKpDB7ijuj5zTInCMejbCpEBB5/pItwrWtW7VK+3cVOLZodartBj3y6GgnBjQmIbKkC+o6myV/3ptQ/dO5SwHPubctYIlLBxzk3GAtG0Y5yMM8Qy2PFMrYFUN
2025-08-02 21:00:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-02 21:00:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-02 21:00:03 [INFO]: inside itemsold and closed 14409
2025-08-02 21:00:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-02 21:00:05 [INFO]: autolink for user_id 14409 is 1
2025-08-02 21:00:05 [INFO]: Ebay item id :: 285043700507 exists in Database
2025-08-02 21:00:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-02 21:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-02 21:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-02 21:00:05 [INFO]: in processold action queue is array    for {"44656932":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44656932","ebayitemid":"285043700507","shopifyproductid":"7876538138846","variants":[{"price":"10.99","quantity":0,"weight":"0","shopifyproductid":"7876538138846","shopifyvariantid":"43676188704990","shopifyinventoryid":"45771978735838","shopifylocationid":"","product_id":"44656932","variant_id":"77562152","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-02 21:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-02 21:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-02 21:00:05 [INFO]: Shopify Inventory id 45771978735838
2025-08-02 21:00:05 [INFO]: Shopify Location id 58450641063
2025-08-02 21:00:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-02 21:00:06 [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-02 21:00:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-02 21:00:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44656932 and user_id = 14409 
2025-08-02 21:00:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77562152 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-02 21:00:06 [INFO]: updateIdsQuantity -> ["77562152"]
2025-08-02 21:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-02 21:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77562152 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77562152 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77562152)
2025-08-02 21:00:06 [INFO]: QUANTITY Updated IDs: 77562152
2025-08-02 21:00:06 [INFO]: Successfully processed data for user 14409
2025-08-02 21:00:06 [INFO]: Execution Started
2025-08-02 21:00:06 [INFO]: Execution Finished
2025-08-02 21:10:01 [INFO]: Execution Started
2025-08-02 21:10:01 [INFO]: old server sucessfully connected
2025-08-02 21:10:01 [INFO]: sqs client sucess created
2025-08-02 21:10:02 [INFO]: Number of messages in the queue: 0
2025-08-02 21:10:22 [INFO]: Execution Started
2025-08-02 21:10:22 [INFO]: Execution Finished
2025-08-02 21:20:01 [INFO]: Execution Started
2025-08-02 21:20:01 [INFO]: old server sucessfully connected
2025-08-02 21:20:01 [INFO]: sqs client sucess created
2025-08-02 21:20:02 [INFO]: Number of messages in the queue: 0
2025-08-02 21:20:22 [INFO]: Execution Started
2025-08-02 21:20:22 [INFO]: Execution Finished
2025-08-02 21:30:02 [INFO]: Execution Started
2025-08-02 21:30:02 [INFO]: old server sucessfully connected
2025-08-02 21:30:02 [INFO]: sqs client sucess created
2025-08-02 21:30:03 [INFO]: Number of messages in the queue: 1
2025-08-02 21:30:04 [INFO]: item found in queue is if condition  14409
2025-08-02 21:30:04 [INFO]: item found in queue is  14409
2025-08-02 21:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBPCWptWq6kTPp5Xh/fgP+6GupcRgWK+cpdF6OhhxzkJu3lhNTBKC/oLqQaiX/hhp6TeqZ5J7xVFK6nvQCTIfc1fCSjMzn/SaFaWPmtx8/uMW0WJ2epcActgm3guiV2A+8dYYd/JCJg6F07vu2OCJsu2hX4Uuzjw/9ZKzS/PQXROIuNhj9BNW5H5O3Itk7nqKNql/vODZzqayEoHSEBtuH6s9mhwjxZAQtXcZWI3ZqreQdywjWVIiYayzBBVWa8ViOlgyO3VqxFxw4TFZCJyo6L8amPlRyOFuyxZJJ5JImfHAy8EwyNlleASSU84AQFjcJX2hNYOW+4zSvfD1GqSQzXdg179Te1gKuszkuPNdia0JLJ8e/UOr65q9eJcCDQRo7+6fUMwu9JikKD1T0p/Tyt+q4ShznbIC+PKnkpCEPh9GRgmN58nSIeehJauNIvLk4
2025-08-02 21:30:04 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-02 21:30:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-02 21:30:04 [INFO]: inside itemsold and closed 14409
2025-08-02 21:30:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-02 21:30:06 [INFO]: autolink for user_id 14409 is 1
2025-08-02 21:30:06 [INFO]: Ebay item id :: 286098621801 exists in Database
2025-08-02 21:30:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-02 21:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-02 21:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-02 21:30:06 [INFO]: in processold action queue is array    for {"44563854":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44563854","ebayitemid":"286098621801","shopifyproductid":"8700362588382","variants":[{"price":"849.99","quantity":0,"weight":"18","shopifyproductid":"8700362588382","shopifyvariantid":"45946823868638","shopifyinventoryid":"48045377028318","shopifylocationid":"","product_id":"44563854","variant_id":"77456534","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-02 21:30:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-02 21:30:06 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-02 21:30:06 [INFO]: Shopify Inventory id 48045377028318
2025-08-02 21:30:06 [INFO]: Shopify Location id 58450641063
2025-08-02 21:30:06 [INFO]: QUANTITY FOR UPDATE 0
2025-08-02 21:30:06 [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-02 21:30:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-02 21:30:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44563854 and user_id = 14409 
2025-08-02 21:30:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77456534 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-02 21:30:06 [INFO]: updateIdsQuantity -> ["77456534"]
2025-08-02 21:30:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-02 21:30:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77456534 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77456534 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77456534)
2025-08-02 21:30:06 [INFO]: QUANTITY Updated IDs: 77456534
2025-08-02 21:30:06 [INFO]: Successfully processed data for user 14409
2025-08-02 21:30:06 [INFO]: Execution Started
2025-08-02 21:30:06 [INFO]: Execution Finished
2025-08-02 21:40:01 [INFO]: Execution Started
2025-08-02 21:40:01 [INFO]: old server sucessfully connected
2025-08-02 21:40:01 [INFO]: sqs client sucess created
2025-08-02 21:40:02 [INFO]: Number of messages in the queue: 0
2025-08-02 21:40:23 [INFO]: Execution Started
2025-08-02 21:40:23 [INFO]: Execution Finished
2025-08-02 21:50:02 [INFO]: Execution Started
2025-08-02 21:50:02 [INFO]: old server sucessfully connected
2025-08-02 21:50:02 [INFO]: sqs client sucess created
2025-08-02 21:50:03 [INFO]: Number of messages in the queue: 1
2025-08-02 21:50:03 [INFO]: item found in queue is if condition  14409
2025-08-02 21:50:03 [INFO]: item found in queue is  14409
2025-08-02 21:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBNE7j1Eniwy7DHVF8jKC98nf1TLYj2JNweMwIWZMwaMhZLnnffUCqyfNOYbnCicxbeixU9px4w8gZPYhnIvSvBhzQXoaHbMwtxG/ZqY4/o+YTsjMp7lTsXBAdUaroTxaJ6gx3mwIAIKSiolhzNmzikOABarmZQZYBkRvK2PErhXN0EzTgevvZKfkYBmfFPByP5QXOBoIbk1cCCEh74B8ud63z9TSq05GJLMN6KTznduVRme2v0YhZGxPzVTT2nEQTW8XJqwU9BWZe6/quAzgthhKtDeRPWBHhisH08zD6DS3awfsKLaMqInV6lSIdNkSBNmkNO1tUB/D9G7aLdf8NwZydCwiI7PN1EFeMN5+3wlOsjm6vqUB4QnnQ+SJ9T46vlBNRkeg509WLslej3DXTIIUl2LzY+jDOuJsVqZOcTy5xUpLywVmKf455Z8XSjt3K
2025-08-02 21:50:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-02 21:50:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-02 21:50:03 [INFO]: inside itemsold and closed 14409
2025-08-02 21:50:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-02 21:50:05 [INFO]: autolink for user_id 14409 is 1
2025-08-02 21:50:05 [INFO]: Ebay item id :: 285548156422 exists in Database
2025-08-02 21:50:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-02 21:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-02 21:50:05 [INFO]: in processold action queue is array    for []
2025-08-02 21:50:05 [INFO]: Successfully processed data for user 14409
2025-08-02 21:50:05 [INFO]: Execution Started
2025-08-02 21:50:05 [INFO]: Execution Finished