2025-08-15 01:00:01 [INFO]: Execution Started
2025-08-15 01:00:01 [INFO]: old server sucessfully connected
2025-08-15 01:00:01 [INFO]: sqs client sucess created
2025-08-15 01:00:02 [INFO]: Number of messages in the queue: 2
2025-08-15 01:00:03 [INFO]: item found in queue is if condition  14409
2025-08-15 01:00:03 [INFO]: item found in queue is  14409
2025-08-15 01:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBlj6Eh+gYc/01iA97enfL5Ylgb2i6A9GZJXe36vNT+3PBYV120PmLYv05261e4a1PXUftie6Z0xszVIrLu60sOOHWqOaB0LLhKghPBhge1QyrJZ/n7DViYF0dHWDaTHel3fSuG01Rm/rJxxVx0BB5xaIyKOjVvgwl8RyggRn0viNwYKMPFcpKqhpph1VtAVyBufyuwJzfwj143hL6h4kqljtPZdR4sxYC2/TnTVnr3lEqwtdFiIPLq8ZyIVvp4JZ+RnueksrIdYHdGIwWEmnWoVE9Bt/6PrkIb92YnclfIJKF83EgGtyyw/FebspPUMDv6GHqJ1L4pyykA7i01t7HowyMy3dwPinhKrg/PBw+rxBVLZnXk8/1/TUk+HV7v2qKXQPSIuwE/UFV+KMoSLhS8vcz7bBWO85zmWjGwlJ0ZFo5WOo7K0TMxA3D/HhEMm42
2025-08-15 01:00:03 [INFO]: item found in queue is if condition  14409
2025-08-15 01:00:03 [INFO]: item found in queue is  14409
2025-08-15 01:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBywWz9UwZAQJg1dn9uoXocQe3Di8Y+ds/Xcxj4y5yYxefAlAmX9tqOaa+hQEA34qXTn4WhjvAfrUBpDClNk47ijuJrBurlXDm18avT8XX2hm4zNX3hHGkLk7bsO2ulGUKlfH0YgLk6ltDVPS56WwCSAXtXnOs7xptl4paoRvzEygC7PbaL1n3UQuCHWomdg/MgYzxRlQvy9iIRupyNPd1pVUJwBtHJlLtaq4ViacLV/Ir0CehLU3mceUYu7NJfEnsYfW+wAXBmCjWciK68n1Qyhtz7MbBZaBSgF9kZEFj/EfcYeDv4svqUWChk30qisuxUac4b93LaiHQWYHQXb1m0DhzOhxIsXVwHkIfeqz6KFMNLoBVSrDpprhw12Acgx85oCI02o6r4ouWE6nhSgoKVvLpVkWQ7KXt1osG5EYZC9C3rupsvEKkCTsRRccXjbEd
2025-08-15 01:00:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-15 01:00:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-15 01:00:04 [INFO]: inside itemsold and closed 14409
2025-08-15 01:00:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-15 01:00:05 [INFO]: autolink for user_id 14409 is 1
2025-08-15 01:00:05 [INFO]: Ebay item id :: 335569705365 exists in Database
2025-08-15 01:00:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-15 01:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-15 01:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-15 01:00:05 [INFO]: inside itemsold and closed 14409
2025-08-15 01:00:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-15 01:00:07 [INFO]: autolink for user_id 14409 is 1
2025-08-15 01:00:07 [INFO]: not in db for user_id 14409 and the ebayitemid226870946878
2025-08-15 01:00:07 [INFO]: in processold action queue is array    for {"44566904":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44566904","ebayitemid":"335569705365","shopifyproductid":"8706608136414","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8706608136414","shopifyvariantid":"45962831397086","shopifyinventoryid":"48061520380126","shopifylocationid":"","product_id":"44566904","variant_id":"77459584","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-15 01:00:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-15 01:00:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-15 01:00:07 [INFO]: Shopify Inventory id 48061520380126
2025-08-15 01:00:07 [INFO]: Shopify Location id 58450641063
2025-08-15 01:00:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-15 01:00: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-15 01:00:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-15 01:00:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44566904 and user_id = 14409 
2025-08-15 01:00:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77459584 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-15 01:00:08 [INFO]: updateIdsQuantity -> ["77459584"]
2025-08-15 01:00:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 0
2025-08-15 01:00:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77459584 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77459584 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77459584)
2025-08-15 01:00:08 [INFO]: QUANTITY Updated IDs: 
2025-08-15 01:00:08 [INFO]: Successfully processed data for user 14409
2025-08-15 01:00:08 [INFO]: Execution Started
2025-08-15 01:00:08 [INFO]: Execution Finished
2025-08-15 01:10:01 [INFO]: Execution Started
2025-08-15 01:10:01 [INFO]: old server sucessfully connected
2025-08-15 01:10:01 [INFO]: sqs client sucess created
2025-08-15 01:10:02 [INFO]: Number of messages in the queue: 0
2025-08-15 01:10:22 [INFO]: Execution Started
2025-08-15 01:10:22 [INFO]: Execution Finished
2025-08-15 01:20:01 [INFO]: Execution Started
2025-08-15 01:20:01 [INFO]: old server sucessfully connected
2025-08-15 01:20:01 [INFO]: sqs client sucess created
2025-08-15 01:20:02 [INFO]: Number of messages in the queue: 0
2025-08-15 01:20:22 [INFO]: Execution Started
2025-08-15 01:20:22 [INFO]: Execution Finished
2025-08-15 01:30:01 [INFO]: Execution Started
2025-08-15 01:30:01 [INFO]: old server sucessfully connected
2025-08-15 01:30:01 [INFO]: sqs client sucess created
2025-08-15 01:30:03 [INFO]: Number of messages in the queue: 0
2025-08-15 01:30:23 [INFO]: Execution Started
2025-08-15 01:30:23 [INFO]: Execution Finished
2025-08-15 01:40:01 [INFO]: Execution Started
2025-08-15 01:40:01 [INFO]: old server sucessfully connected
2025-08-15 01:40:01 [INFO]: sqs client sucess created
2025-08-15 01:40:02 [INFO]: Number of messages in the queue: 1
2025-08-15 01:40:02 [INFO]: item found in queue is if condition  14409
2025-08-15 01:40:02 [INFO]: item found in queue is  14409
2025-08-15 01:40:02 [INFO]: Message deleted from the queue for receipt handle: AQEBfHGsjKz/O5O0h4r6GgqnFVhRC2M/NtkYpH8HfigJn3WudzDKZLZbL9yq9+rNWX9wjS/71xwagNp9re1/4MNdr6RHKNDJ6QP9Gmf0AO3krXQBht8ABNOhNObrCded+S3h+oOE3TSa6ackb9Mhq0zYaWiDqcQdf5d+Pv9L9wCZdaBmXV1jp5rYVNvWZaer9GFyVahRdsRnpdMKhUdYlB8ZK4Y7aRK2bZAWF1NYZB87Yc9USjMUwQR4yv3hIIB2Z1TRjxHinC8EeWdDqN4cvGNnWDJT7GZJRMSslXNV261hr+027pdRKlscGZy6+NY1IA84wjgVS0rQ8EtmJKZVA6a7Uzk9oWBDfj7cInfNeiPBeisA6UaFuQ/XIk4skqxa+fb3YY5ZuxW3fzDX5sucDNDhTJqWwioktrZtdcBKuu3OTBpOMyRiBbys2wDGvfX9E72+
2025-08-15 01:40:02 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-15 01:40:02 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-15 01:40:02 [INFO]: inside itemsold and closed 14409
2025-08-15 01:40:04 [INFO]: autodelete for user_id 14409 is 0
2025-08-15 01:40:04 [INFO]: autolink for user_id 14409 is 1
2025-08-15 01:40:04 [INFO]: Ebay item id :: 286510481883 exists in Database
2025-08-15 01:40:04 [INFO]: Item is reliested  ::  exists in Database
2025-08-15 01:40:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-15 01:40:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-15 01:40:04 [INFO]: in processold action queue is array    for {"44667865":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44667865","ebayitemid":"286510481883","shopifyproductid":"8885233746142","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8885233746142","shopifyvariantid":"46639653093598","shopifyinventoryid":"48742618530014","shopifylocationid":"","product_id":"44667865","variant_id":"77573085","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-15 01:40:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-15 01:40:04 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-15 01:40:04 [INFO]: Shopify Inventory id 48742618530014
2025-08-15 01:40:04 [INFO]: Shopify Location id 58450641063
2025-08-15 01:40:04 [INFO]: QUANTITY FOR UPDATE 0
2025-08-15 01:40:04 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1979,"restoreRate":100}}}}
2025-08-15 01:40:04 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-15 01:40:04 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44667865 and user_id = 14409 
2025-08-15 01:40:04 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77573085 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-15 01:40:04 [INFO]: updateIdsQuantity -> ["77573085"]
2025-08-15 01:40:04 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-15 01:40:04 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77573085 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77573085 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77573085)
2025-08-15 01:40:04 [INFO]: QUANTITY Updated IDs: 77573085
2025-08-15 01:40:04 [INFO]: Successfully processed data for user 14409
2025-08-15 01:40:04 [INFO]: Execution Started
2025-08-15 01:40:04 [INFO]: Execution Finished
2025-08-15 01:50:01 [INFO]: Execution Started
2025-08-15 01:50:01 [INFO]: old server sucessfully connected
2025-08-15 01:50:01 [INFO]: sqs client sucess created
2025-08-15 01:50:02 [INFO]: Number of messages in the queue: 0
2025-08-15 01:50:22 [INFO]: Execution Started
2025-08-15 01:50:22 [INFO]: Execution Finished