2025-08-12 05:00:01 [INFO]: Execution Started
2025-08-12 05:00:02 [INFO]: old server sucessfully connected
2025-08-12 05:00:02 [INFO]: sqs client sucess created
2025-08-12 05:00:03 [INFO]: Number of messages in the queue: 0
2025-08-12 05:00:23 [INFO]: Execution Started
2025-08-12 05:00:23 [INFO]: Execution Finished
2025-08-12 05:10:02 [INFO]: Execution Started
2025-08-12 05:10:02 [INFO]: old server sucessfully connected
2025-08-12 05:10:02 [INFO]: sqs client sucess created
2025-08-12 05:10:03 [INFO]: Number of messages in the queue: 1
2025-08-12 05:10:03 [INFO]: item found in queue is if condition  14409
2025-08-12 05:10:03 [INFO]: item found in queue is  14409
2025-08-12 05:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBSJPzAUZuDNBM3t2Bw02M0Kkl62xLpK8Ml79EIYB5Y2NQH+Qlfxk+0v7o6amKp1uvbagdpuQPKerRUT1ZCoSnBh+MJqTB0En4P3t2jZspb2eLij5M5E9/sqA//arP/4yvwCjqWgLPs5TbWzdFtMAZCJr9JMLlc8z5NSIHyIxLKnrPQGVLDeZ5RO1ONwOhrn9PzNa3sTQ256pTPHy5LAfxL5YkxRMsTtrNH4B38l4kuvIlKwq9E5DPOJQsCcq/E80cApS0EI3lDwikdvp+ugFTzOmwiQDU+whPmYgrNBWSHuPJDXsdtmoRZzeMZ2QRwWou+Vybotrkd2+iulU2w+XwHAnjgpmK/T5vgU1kRUr1VK8i+cIj3LJkOGOz83DzW25m6NC+0MVBoLFSVwH2VkzHsLFVbvpbE4FdA//hLinQgLjSS8c2xFfeoFKrKmkZUpZL
2025-08-12 05:10:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-12 05:10:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 05:10:03 [INFO]: inside itemsold and closed 14409
2025-08-12 05:10:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 05:10:05 [INFO]: autolink for user_id 14409 is 1
2025-08-12 05:10:05 [INFO]: Ebay item id :: 306188987381 exists in Database
2025-08-12 05:10:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 05:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 05:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 05:10:05 [INFO]: in processold action queue is array    for {"44582227":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44582227","ebayitemid":"306188987381","shopifyproductid":"8784601514206","variants":[{"price":"269.99","quantity":0,"weight":"10","shopifyproductid":"8784601514206","shopifyvariantid":"46206064165086","shopifyinventoryid":"48305885479134","shopifylocationid":"","product_id":"44582227","variant_id":"77474936","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-12 05:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-12 05:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 05:10:05 [INFO]: Shopify Inventory id 48305885479134
2025-08-12 05:10:05 [INFO]: Shopify Location id 58450641063
2025-08-12 05:10:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 05:10: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-12 05:10:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 05:10:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44582227 and user_id = 14409 
2025-08-12 05:10:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77474936 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 05:10:06 [INFO]: updateIdsQuantity -> ["77474936"]
2025-08-12 05:10:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-12 05:10:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77474936 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77474936 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77474936)
2025-08-12 05:10:06 [INFO]: QUANTITY Updated IDs: 77474936
2025-08-12 05:10:06 [INFO]: Successfully processed data for user 14409
2025-08-12 05:10:06 [INFO]: Execution Started
2025-08-12 05:10:06 [INFO]: Execution Finished
2025-08-12 05:20:01 [INFO]: Execution Started
2025-08-12 05:20:01 [INFO]: old server sucessfully connected
2025-08-12 05:20:01 [INFO]: sqs client sucess created
2025-08-12 05:20:03 [INFO]: Number of messages in the queue: 0
2025-08-12 05:20:23 [INFO]: Execution Started
2025-08-12 05:20:23 [INFO]: Execution Finished
2025-08-12 05:30:02 [INFO]: Execution Started
2025-08-12 05:30:02 [INFO]: old server sucessfully connected
2025-08-12 05:30:02 [INFO]: sqs client sucess created
2025-08-12 05:30:03 [INFO]: Number of messages in the queue: 1
2025-08-12 05:30:03 [INFO]: item found in queue is if condition  14409
2025-08-12 05:30:03 [INFO]: item found in queue is  14409
2025-08-12 05:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBvSObNfzPVnJCrzAK1SkLKWJEdNRP28tQeS/WlluzLNq/LU5YfXEBVr2Uq+kn5goe56NsJvBSJ9F4qhYGZn5K+r9E2QpLE1n7U6mAsMQmrqp8GgRGMAv2Z2Ti0gRBsTg2H0P6X1KI4nca4bRp3Djx4tuLfpO9ZWqwbjrwieajvOMdUhgHPExPIf4UeFSB/4pW6zAO5hjXbe18RlwnLHXrPINeIv76eYJncoqgtqSMTgwXIDVALQOew2mFpJ3ezrukixQP0sz8WPdbspYf9HDCULeaOMpmaAsNrIk2+omIotkUL92/dCPyhG8atQNl4R0thx5lXRD2gXLxdKCg0hfryQi2tu6hTwyRuRcuQeBqLDY5OtXzVeeWDAD5/cFvhka6PGy7OeLWS7jHQqw+vrQPFDELN2dCRWFEFXU7KJ1UGxcdwov9pFQkUxE4Y7lARLPY
2025-08-12 05:30:04 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-12 05:30:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 05:30:04 [INFO]: inside itemsold and closed 14409
2025-08-12 05:30:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 05:30:06 [INFO]: autolink for user_id 14409 is 1
2025-08-12 05:30:06 [INFO]: Ebay item id :: 306205353701 exists in Database
2025-08-12 05:30:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 05:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 05:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 05:30:06 [INFO]: in processold action queue is array    for {"44593476":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44593476","ebayitemid":"306205353701","shopifyproductid":"8857356107998","variants":[{"price":"20.99","quantity":0,"weight":"2","shopifyproductid":"8857356107998","shopifyvariantid":"46493909844190","shopifyinventoryid":"48596121092318","shopifylocationid":"","product_id":"44593476","variant_id":"77486185","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-12 05:30:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-12 05:30:06 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 05:30:06 [INFO]: Shopify Inventory id 48596121092318
2025-08-12 05:30:06 [INFO]: Shopify Location id 58450641063
2025-08-12 05:30:06 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 05: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-12 05:30:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 05:30:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44593476 and user_id = 14409 
2025-08-12 05:30:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77486185 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 05:30:06 [INFO]: updateIdsQuantity -> ["77486185"]
2025-08-12 05:30:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-12 05:30:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77486185 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77486185 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77486185)
2025-08-12 05:30:06 [INFO]: QUANTITY Updated IDs: 77486185
2025-08-12 05:30:06 [INFO]: Successfully processed data for user 14409
2025-08-12 05:30:06 [INFO]: Execution Started
2025-08-12 05:30:06 [INFO]: Execution Finished
2025-08-12 05:40:01 [INFO]: Execution Started
2025-08-12 05:40:01 [INFO]: old server sucessfully connected
2025-08-12 05:40:01 [INFO]: sqs client sucess created
2025-08-12 05:40:02 [INFO]: Number of messages in the queue: 0
2025-08-12 05:40:23 [INFO]: Execution Started
2025-08-12 05:40:23 [INFO]: Execution Finished
2025-08-12 05:50:01 [INFO]: Execution Started
2025-08-12 05:50:01 [INFO]: old server sucessfully connected
2025-08-12 05:50:01 [INFO]: sqs client sucess created
2025-08-12 05:50:03 [INFO]: Number of messages in the queue: 0
2025-08-12 05:50:24 [INFO]: Execution Started
2025-08-12 05:50:24 [INFO]: Execution Finished