2025-08-03 01:00:02 [INFO]: Execution Started
2025-08-03 01:00:02 [INFO]: old server sucessfully connected
2025-08-03 01:00:02 [INFO]: sqs client sucess created
2025-08-03 01:00:03 [INFO]: Number of messages in the queue: 0
2025-08-03 01:00:23 [INFO]: Execution Started
2025-08-03 01:00:23 [INFO]: Execution Finished
2025-08-03 01:10:01 [INFO]: Execution Started
2025-08-03 01:10:01 [INFO]: old server sucessfully connected
2025-08-03 01:10:02 [INFO]: sqs client sucess created
2025-08-03 01:10:03 [INFO]: Number of messages in the queue: 0
2025-08-03 01:10:23 [INFO]: Execution Started
2025-08-03 01:10:23 [INFO]: Execution Finished
2025-08-03 01:20:01 [INFO]: Execution Started
2025-08-03 01:20:01 [INFO]: old server sucessfully connected
2025-08-03 01:20:01 [INFO]: sqs client sucess created
2025-08-03 01:20:02 [INFO]: Number of messages in the queue: 0
2025-08-03 01:20:23 [INFO]: Execution Started
2025-08-03 01:20:23 [INFO]: Execution Finished
2025-08-03 01:30:01 [INFO]: Execution Started
2025-08-03 01:30:01 [INFO]: old server sucessfully connected
2025-08-03 01:30:01 [INFO]: sqs client sucess created
2025-08-03 01:30:02 [INFO]: Number of messages in the queue: 1
2025-08-03 01:30:02 [INFO]: item found in queue is if condition  14409
2025-08-03 01:30:02 [INFO]: item found in queue is  14409
2025-08-03 01:30:02 [INFO]: Message deleted from the queue for receipt handle: AQEBqTaFeQp0zp6zQ9updnYvjbTLiarnAOGmZpWfWoyDtpRgZ4fKd/ckQ2eDO7qRNzLkMRPW+yR0etwWqBxx5BcxxhyMx1XxTczKhP2krpKeD0p7CwtUmXMhBQ0jPvP+owjuXq2R+lE3jUPfdI5phijoF4wAAGzoHixPvqlGRl9L4Ug+uwwwIsF+9TtNA4cpMT4Bda4tJlreiEfMT9Y+F5/1t5+Q/hC7i/OcvGlHZlvw+zRhXttIfz6QBy9Ne0/qHnSX7cVmvXFjXkO/Sj1ZZlvYrMRpAm1KjSzanHdmbTXvGNCrKhegh+C/yL3HNjEbvCg1M+7yWJM4C0UTQ09iLQFtF5d6GxOAhO5t3EJhBJBILhqnCZo/lV1rwah5kFU8Z3LPOz+Bgv+fBAbC0/fPzHD5BEQovhi68J2EZUyfS1hkyVvTBAIaRqrM3jS55xFC1WoZ
2025-08-03 01:30:02 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-03 01:30:02 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-03 01:30:02 [INFO]: inside itemsold and closed 14409
2025-08-03 01:30:04 [INFO]: autodelete for user_id 14409 is 0
2025-08-03 01:30:04 [INFO]: autolink for user_id 14409 is 1
2025-08-03 01:30:04 [INFO]: Ebay item id :: 306121878605 exists in Database
2025-08-03 01:30:04 [INFO]: Item is reliested  ::  exists in Database
2025-08-03 01:30:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-03 01:30:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-03 01:30:04 [INFO]: in processold action queue is array    for {"44577172":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44577172","ebayitemid":"306121878605","shopifyproductid":"8819733889246","variants":[{"price":"15.99","quantity":0,"weight":"0.5","shopifyproductid":"8819733889246","shopifyvariantid":"46296801509598","shopifyinventoryid":"48397764985054","shopifylocationid":"","product_id":"44577172","variant_id":"77469879","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-03 01:30:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-03 01:30:04 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-03 01:30:04 [INFO]: Shopify Inventory id 48397764985054
2025-08-03 01:30:04 [INFO]: Shopify Location id 58450641063
2025-08-03 01:30:04 [INFO]: QUANTITY FOR UPDATE 0
2025-08-03 01:30:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-03T01:30:05Z","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-03 01:30:05 [INFO]: Change: available | Delta: -1
2025-08-03 01:30:05 [INFO]: Change: on_hand | Delta: -1
2025-08-03 01:30:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-03 01:30:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44577172 and user_id = 14409 
2025-08-03 01:30:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77469879 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-03 01:30:05 [INFO]: updateIdsQuantity -> ["77469879"]
2025-08-03 01:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-03 01:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77469879 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77469879 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77469879)
2025-08-03 01:30:05 [INFO]: QUANTITY Updated IDs: 77469879
2025-08-03 01:30:05 [INFO]: Successfully processed data for user 14409
2025-08-03 01:30:05 [INFO]: Execution Started
2025-08-03 01:30:05 [INFO]: Execution Finished
2025-08-03 01:40:01 [INFO]: Execution Started
2025-08-03 01:40:01 [INFO]: old server sucessfully connected
2025-08-03 01:40:01 [INFO]: sqs client sucess created
2025-08-03 01:40:02 [INFO]: Number of messages in the queue: 1
2025-08-03 01:40:02 [INFO]: item found in queue is if condition  14409
2025-08-03 01:40:02 [INFO]: item found in queue is  14409
2025-08-03 01:40:02 [INFO]: Message deleted from the queue for receipt handle: AQEBhM4EOTNVjs5hFlZNHClPMr+eed84uDiFnV2XxcJjM690nB12Z11jk3BULi4arcUnbncyBFBMPwRkNaDgKrzC7btCtEcUsvkXVCnxqL+p00Jy+r+8Ljst5krInxavDg1qi5XVLP6Y1sCJ97xB+ZaeZkw/swOVzPE6w/8qf5NP3ZE6mZi1P3Afw/e5RFaiAPIo0jYTiN7nt6tdUgb6hyPLPAuKXXiWqLSq01c8vNegCuQOaUnJAPUay9SmPU4rBPw7txQZ9jBOySJESWExsK4DI+oOFBkxVt0T7nJwSXfYQsPy0xxtJAqBA1G3qtqEaI9QzRJXURp/58aV/jjDzvZP8UPzo7/9jRm5L2gmwgehYnVBkRO1wDsmGc6sHoVqbVdidquLo8nvbuiC8P7mr1Ivq0DSGXcNO1Ndtu3E9rWN9QY8uPu5clcnoPnCPoalxJg7
2025-08-03 01:40:02 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-03 01:40:02 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-03 01:40:02 [INFO]: inside itemsold and closed 14409
2025-08-03 01:40:04 [INFO]: autodelete for user_id 14409 is 0
2025-08-03 01:40:04 [INFO]: autolink for user_id 14409 is 1
2025-08-03 01:40:04 [INFO]: Ebay item id :: 256924078064 exists in Database
2025-08-03 01:40:04 [INFO]: Item is reliested  ::  exists in Database
2025-08-03 01:40:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-03 01:40:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-03 01:40:04 [INFO]: in processold action queue is array    for {"44861815":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44861815","ebayitemid":"256924078064","shopifyproductid":"8927201427678","variants":[{"price":"14.99","quantity":0,"weight":"2","shopifyproductid":"8927201427678","shopifyvariantid":"46846611718366","shopifyinventoryid":"48958056366302","shopifylocationid":"58450641063","product_id":"44861815","variant_id":"77773203","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-03 01:40:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-03 01:40:04 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-03 01:40:04 [INFO]: Shopify Inventory id 48958056366302
2025-08-03 01:40:04 [INFO]: Shopify Location id 58450641063
2025-08-03 01:40:04 [INFO]: QUANTITY FOR UPDATE 0
2025-08-03 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":1990,"restoreRate":100}}}}
2025-08-03 01:40:04 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-03 01:40:04 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44861815 and user_id = 14409 
2025-08-03 01:40:04 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77773203 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-03 01:40:04 [INFO]: updateIdsQuantity -> ["77773203"]
2025-08-03 01:40:04 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-03 01:40:04 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77773203 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77773203 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77773203)
2025-08-03 01:40:04 [INFO]: QUANTITY Updated IDs: 77773203
2025-08-03 01:40:04 [INFO]: Successfully processed data for user 14409
2025-08-03 01:40:04 [INFO]: Execution Started
2025-08-03 01:40:04 [INFO]: Execution Finished
2025-08-03 01:50:01 [INFO]: Execution Started
2025-08-03 01:50:01 [INFO]: old server sucessfully connected
2025-08-03 01:50:01 [INFO]: sqs client sucess created
2025-08-03 01:50:02 [INFO]: Number of messages in the queue: 0
2025-08-03 01:50:23 [INFO]: Execution Started
2025-08-03 01:50:23 [INFO]: Execution Finished