2025-08-01 05:00:01 [INFO]: Execution Started
2025-08-01 05:00:01 [INFO]: old server sucessfully connected
2025-08-01 05:00:01 [INFO]: sqs client sucess created
2025-08-01 05:00:02 [INFO]: Number of messages in the queue: 1
2025-08-01 05:00:02 [INFO]: item found in queue is if condition  14409
2025-08-01 05:00:02 [INFO]: item found in queue is  14409
2025-08-01 05:00:02 [INFO]: Message deleted from the queue for receipt handle: AQEBDhnzELYhnvD005tByitJDzfjkkV8se33IAYxART3vgkYi6VVlnY3vVusJ7KGuYIq6+IDDzSoDk/IlRq8MNS143foOMdgynjBwZRVJvxwlOnplNS2Axd+7clSBDSIiB2TP30HWSUHcS9n+OYk8XX705moLH1Y6Q4rAQvHugybGqHP7OWM3AgiFwi29pMBMBZaWWT8aofIszM9FKCy4UjMqEucV4rolrGpJJ0MaC8xaXf4Bo8rR7bixAUqmljpTeLFlAVRhP8TrWyie3QAbnET1oav1flwCnu5QwT808gJppH+eEHGIJNvIzdViQZARKmu1BNt0d+fpS06f3Nji5wtYrUwYMsqGUeTomdo19a2wZTKrFIMFnvdIhR+71kHgLzo23zv3ZVX2XmimNTG6TzFNAAg7VPFA/L3G24GK999JQCW+FsfQgT7QDiZDCudJkBm
2025-08-01 05:00:02 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-01 05:00:02 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-01 05:00:02 [INFO]: inside itemsold and closed 14409
2025-08-01 05:00:04 [INFO]: autodelete for user_id 14409 is 0
2025-08-01 05:00:04 [INFO]: autolink for user_id 14409 is 1
2025-08-01 05:00:04 [INFO]: Ebay item id :: 285613329902 exists in Database
2025-08-01 05:00:04 [INFO]: Item is reliested  ::  exists in Database
2025-08-01 05:00:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-01 05:00:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-01 05:00:04 [INFO]: in processold action queue is array    for {"44654700":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44654700","ebayitemid":"285613329902","shopifyproductid":"8240590684382","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8240590684382","shopifyvariantid":"44617932931294","shopifyinventoryid":"46715913765086","shopifylocationid":"","product_id":"44654700","variant_id":"77559889","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-01 05:00:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-01 05:00:04 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-01 05:00:04 [INFO]: Shopify Inventory id 46715913765086
2025-08-01 05:00:04 [INFO]: Shopify Location id 58450641063
2025-08-01 05:00:04 [INFO]: QUANTITY FOR UPDATE 0
2025-08-01 05:00:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T05:00: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-01 05:00:05 [INFO]: Change: available | Delta: -1
2025-08-01 05:00:05 [INFO]: Change: on_hand | Delta: -1
2025-08-01 05:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-01 05:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44654700 and user_id = 14409 
2025-08-01 05:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77559889 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-01 05:00:05 [INFO]: updateIdsQuantity -> ["77559889"]
2025-08-01 05:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-01 05:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77559889 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77559889 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77559889)
2025-08-01 05:00:05 [INFO]: QUANTITY Updated IDs: 77559889
2025-08-01 05:00:05 [INFO]: Successfully processed data for user 14409
2025-08-01 05:00:05 [INFO]: Execution Started
2025-08-01 05:00:05 [INFO]: Execution Finished
2025-08-01 05:10:01 [INFO]: Execution Started
2025-08-01 05:10:01 [INFO]: old server sucessfully connected
2025-08-01 05:10:01 [INFO]: sqs client sucess created
2025-08-01 05:10:02 [INFO]: Number of messages in the queue: 2
2025-08-01 05:10:03 [INFO]: item found in queue is if condition  14409
2025-08-01 05:10:03 [INFO]: item found in queue is  14409
2025-08-01 05:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEB9Oe446K/xVVAvk8Iylh5cnUUgoTi05ZyOkEBnXeoK0VJMJeRDmrZ0yTCy/4OcOkZjGLLYGEt8D7Y9x/cVJ+SlFRRw/WD8o0/vUtUoIBgH/yH6sETzaQCibvUcNekhXnoVlaHSbj+/CKsS0EUFakJza4gLZ9gvaePwNCIVjWNsbH3IaPyWwF1ZqWbG/A2XKGluv5F+yvw+nGhwbvvHpSL8jFrg99t8PhiAxDWsyhHPEtW1mpZ0qmHpCyzZV7MalE0OB6fb6XgjMh29N6pwj5XRnrfl8pKbB1qkvIJO14QwU7T7Od7FQwN+t9F+6IOarLCDVR9hL8TClWbCyzK2Nh3lPZmQBiFgjv/tEi8px1OW/nzlKdGCQZwLBmh/yOHIrmtnW9GGWsqJXMg8MgrkyHIOzp+/VpQiuvDhOwDdObPB0g/xKSbQADzXfP2TNyL5icq
2025-08-01 05:10:03 [INFO]: item found in queue is if condition  14409
2025-08-01 05:10:03 [INFO]: item found in queue is  14409
2025-08-01 05:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBVti6wMqMO5wSMCK3eWGadJFs1rbNtQMR8zAJClaq7MXQ2QNqGNEQ/Y96oL9shr+IHenclee6JCqVwTsfbaWTf2Wgb9JpGaVYihN//ds9u0Mxfz+5oh0SRSE4/2tWNhe82zNX5oxFpAnrGmPrVQK4xawiRajPHbTwWofsnwlRhfmm+naS6vp10fRJxzAs7v97S8E4riaKlWw6fHktxNqMzF+/Ateperknw2BSxJJ+mhhPL1vh30G0/Wr8z3BsHUQl2ld00Xhrur29lxrGzuuLDD9vZIpXvtz4y+FMqoPfFXCXkGUmKEWO0A9ysQFcb8cUqXozfD93YvE+UuUT09RLN5ZAtT3X5Lu+EjXBGLUl+fTGgddqWhvIJYU929H06FKf8K0Bcn00G0b/dD2AqPNwqPIGCGPJjSLoFKSrZu6sWDAeDCM9ExNCeFgDyDjEiKE9
2025-08-01 05:10:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-01 05:10:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-01 05:10:04 [INFO]: inside itemsold and closed 14409
2025-08-01 05:10:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-01 05:10:05 [INFO]: autolink for user_id 14409 is 1
2025-08-01 05:10:05 [INFO]: Ebay item id :: 286533318589 exists in Database
2025-08-01 05:10:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-01 05:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-01 05:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-01 05:10:05 [INFO]: inside itemsold and closed 14409
2025-08-01 05:10:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-01 05:10:07 [INFO]: autolink for user_id 14409 is 1
2025-08-01 05:10:07 [INFO]: Ebay item id :: 335877384395 exists in Database
2025-08-01 05:10:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-01 05:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-01 05:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-01 05:10:07 [INFO]: in processold action queue is array    for {"44748778":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44748778","ebayitemid":"286533318589","shopifyproductid":"7626561454302","variants":[{"price":"14.99","quantity":0,"weight":"3","shopifyproductid":"7626561454302","shopifyvariantid":"42705225908446","shopifyinventoryid":"44799507890398","shopifylocationid":"","product_id":"44748778","variant_id":"77657254","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44588577":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44588577","ebayitemid":"335877384395","shopifyproductid":"8854724149470","variants":[{"price":"500.00","quantity":0,"weight":"15","shopifyproductid":"8854724149470","shopifyvariantid":"46485250080990","shopifyinventoryid":"48587299651806","shopifylocationid":"","product_id":"44588577","variant_id":"77481286","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-01 05:10:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-01 05:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-01 05:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-01 05:10:07 [INFO]: Shopify Inventory id 44799507890398
2025-08-01 05:10:07 [INFO]: Shopify Location id 58450641063
2025-08-01 05:10:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-01 05:10: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-01 05:10:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-01 05:10:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44748778 and user_id = 14409 
2025-08-01 05:10:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77657254 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-01 05:10:08 [INFO]: Shopify Inventory id 48587299651806
2025-08-01 05:10:08 [INFO]: Shopify Location id 58450641063
2025-08-01 05:10:08 [INFO]: QUANTITY FOR UPDATE 0
2025-08-01 05:10: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-01 05:10:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-01 05:10:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44588577 and user_id = 14409 
2025-08-01 05:10:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77481286 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-01 05:10:08 [INFO]: updateIdsQuantity -> ["77657254","77481286"]
2025-08-01 05:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-01 05:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77657254 THEN 0 WHEN id = 77481286 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77657254 THEN 0 WHEN id = 77481286 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77657254,77481286)
2025-08-01 05:10:08 [INFO]: QUANTITY Updated IDs: 77657254, 77481286
2025-08-01 05:10:08 [INFO]: Successfully processed data for user 14409
2025-08-01 05:10:08 [INFO]: Execution Started
2025-08-01 05:10:08 [INFO]: Execution Finished
2025-08-01 05:20:01 [INFO]: Execution Started
2025-08-01 05:20:01 [INFO]: old server sucessfully connected
2025-08-01 05:20:01 [INFO]: sqs client sucess created
2025-08-01 05:20:02 [INFO]: Number of messages in the queue: 0
2025-08-01 05:20:23 [INFO]: Execution Started
2025-08-01 05:20:23 [INFO]: Execution Finished
2025-08-01 05:30:01 [INFO]: Execution Started
2025-08-01 05:30:01 [INFO]: old server sucessfully connected
2025-08-01 05:30:01 [INFO]: sqs client sucess created
2025-08-01 05:30:03 [INFO]: Number of messages in the queue: 0
2025-08-01 05:30:23 [INFO]: Execution Started
2025-08-01 05:30:23 [INFO]: Execution Finished
2025-08-01 05:40:01 [INFO]: Execution Started
2025-08-01 05:40:01 [INFO]: old server sucessfully connected
2025-08-01 05:40:01 [INFO]: sqs client sucess created
2025-08-01 05:40:02 [INFO]: Number of messages in the queue: 0
2025-08-01 05:40:22 [INFO]: Execution Started
2025-08-01 05:40:22 [INFO]: Execution Finished
2025-08-01 05:50:01 [INFO]: Execution Started
2025-08-01 05:50:01 [INFO]: old server sucessfully connected
2025-08-01 05:50:01 [INFO]: sqs client sucess created
2025-08-01 05:50:02 [INFO]: Number of messages in the queue: 0
2025-08-01 05:50:22 [INFO]: Execution Started
2025-08-01 05:50:22 [INFO]: Execution Finished