2025-08-08 19:00:01 [INFO]: Execution Started
2025-08-08 19:00:01 [INFO]: old server sucessfully connected
2025-08-08 19:00:01 [INFO]: sqs client sucess created
2025-08-08 19:00:02 [INFO]: Number of messages in the queue: 1
2025-08-08 19:00:02 [INFO]: item found in queue is if condition  14409
2025-08-08 19:00:02 [INFO]: item found in queue is  14409
2025-08-08 19:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBLoUku0Z4Z3PNLJJGf+9zjCMWYiDE6+bPuth9SXAHYtVNOxWADZS0QD6+JIKK72ap4R6L6X2Cbvj4ZMkUlEnR28I+/ITE7mEPCKgUXk/8DCi7Qn19s0Azh0w+2I8UPoSQ9SDR9wEROeQuG4NGn9boQw17kseNVLUpW6RiKiXBSl5ZHzX7/YDBzQ9ZpZXWb00HK9+/ye6ONT4sT2RT9Ph8E61licVw1JlGVC7gLWnwUJjjkcq5gkaaXxEkCX3MKXfj5RUfjYNLqIbrRrfWtLOvV8fzFj9FnjjQaKwskDFYkwC9y1cuGGOaKpmltjMVpXP297KzR+Z8/Lr3+FAEae0pcPdKE/SYV9dERM0QNJtG99eSJQG+ua4GGM/oktoIO3p242WZGxhCURZFdtt/rpTFHJ3t3aoFZPeoCyVu4KrOO1c+GhNulJzK6TtS6BGK9q5B
2025-08-08 19:00:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-08 19:00:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-08 19:00:03 [INFO]: inside itemsold and closed 14409
2025-08-08 19:00:04 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 19:00:04 [INFO]: autolink for user_id 14409 is 1
2025-08-08 19:00:04 [INFO]: not in db for user_id 14409 and the ebayitemid286514427658
2025-08-08 19:00:04 [INFO]: in processold action queue is array    for []
2025-08-08 19:00:05 [INFO]: Successfully processed data for user 14409
2025-08-08 19:00:05 [INFO]: Execution Started
2025-08-08 19:00:05 [INFO]: Execution Finished
2025-08-08 19:10:01 [INFO]: Execution Started
2025-08-08 19:10:01 [INFO]: old server sucessfully connected
2025-08-08 19:10:01 [INFO]: sqs client sucess created
2025-08-08 19:10:02 [INFO]: Number of messages in the queue: 0
2025-08-08 19:10:23 [INFO]: Execution Started
2025-08-08 19:10:23 [INFO]: Execution Finished
2025-08-08 19:20:01 [INFO]: Execution Started
2025-08-08 19:20:01 [INFO]: old server sucessfully connected
2025-08-08 19:20:01 [INFO]: sqs client sucess created
2025-08-08 19:20:02 [INFO]: Number of messages in the queue: 0
2025-08-08 19:20:23 [INFO]: Execution Started
2025-08-08 19:20:23 [INFO]: Execution Finished
2025-08-08 19:30:01 [INFO]: Execution Started
2025-08-08 19:30:01 [INFO]: old server sucessfully connected
2025-08-08 19:30:01 [INFO]: sqs client sucess created
2025-08-08 19:30:02 [INFO]: Number of messages in the queue: 0
2025-08-08 19:30:23 [INFO]: Execution Started
2025-08-08 19:30:23 [INFO]: Execution Finished
2025-08-08 19:40:01 [INFO]: Execution Started
2025-08-08 19:40:01 [INFO]: old server sucessfully connected
2025-08-08 19:40:01 [INFO]: sqs client sucess created
2025-08-08 19:40:02 [INFO]: Number of messages in the queue: 2
2025-08-08 19:40:02 [INFO]: item found in queue is if condition  14409
2025-08-08 19:40:02 [INFO]: item found in queue is  14409
2025-08-08 19:40:02 [INFO]: Message deleted from the queue for receipt handle: AQEBpGxn4Ak7/CZ6fyhWXJDn+XVwl9uOq932r8G5faFleoXXQkE+2i5/5pJuVnyKMnPVRIIsfMk25WY9jNqkK0UGo8cVc52P+wIk0nyDpPYKjRxAYDZMVKl/mtbz4PkhFTaXXeJH2NuWV+re/P6NjOjaawWfgvyJEmq+doVSrcUYOPdpwGk25cBR1ev3MZl7HZT9fO9zIlVVL6LcObudM2XjKFKTxTaAqB/iWXmkF2Q6K2YvJO/gPO8AbXlfjkJkb4yD++2T46rFG/H/EPF0H3HeNgijoK7ULpyW1D3NtR+pa+GepKR2uNiXruaCJogzYh93mQNLpIpkKtTM/UIAG8s1J4xza8Kdf1X7+PVLob5GvC9hWDtWM9jxPjTl3H68UbL9QXOGrJFknCqR9rQkLKhSt6h4pIWEXE1ghw2yZUX+ruoC3paSw30ddZ1ncH302Kr6
2025-08-08 19:40:03 [INFO]: item found in queue is if condition  14409
2025-08-08 19:40:03 [INFO]: item found in queue is  14409
2025-08-08 19:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEByApJ7M2qfZjntuDbu6QZs/MZzPNx86x3xJ2LkyZk8+LyB+/0QNmXSPfdN0128V5D5rB2LstkbDh7UjbRDR/eTAO5nu98qe0LKff0UpGOrux2D04h0Kgg0M9dAn6fMuxzmobui53uQQRG5oRh+1Zila1c13ngr/QRm3rAHB0D/rWVtbo95yellytqxf4zcuxYEFepxVWPYpTRJovlj40RAx/TYa5fP8lMVlSPvmoTcG9TCJA1dsaPVmthrY0X7B0RUqBTV8lKTXpFncYHcZebUCLQ/9wXlKV4vwUZLDOCD/ni1cXd+ZfwrHdEw00nubGD/jiKvr7/fR7uuAKswLwl+VcxJn9ss+4DmejRy0KSCFxfcX0EV1FWb2KzoWfj4wGoYrzCAN6FwswEzWSv+tZ10ezL7PFp305WHi5+P2igdwUqcbfWyMl4Y8h9kEZIBI9T
2025-08-08 19:40:03 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-08 19:40:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-08 19:40:03 [INFO]: inside itemsold and closed 14409
2025-08-08 19:40:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 19:40:05 [INFO]: autolink for user_id 14409 is 1
2025-08-08 19:40:05 [INFO]: Ebay item id :: 286132653117 exists in Database
2025-08-08 19:40:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 19:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 19:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 19:40:05 [INFO]: inside itemsold and closed 14409
2025-08-08 19:40:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 19:40:07 [INFO]: autolink for user_id 14409 is 1
2025-08-08 19:40:07 [INFO]: Ebay item id :: 286007922308 exists in Database
2025-08-08 19:40:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 19:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 19:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 19:40:07 [INFO]: in processold action queue is array    for {"44595228":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44595228","ebayitemid":"286132653117","shopifyproductid":"7850379641054","variants":[{"price":"62.99","quantity":0,"weight":"3","shopifyproductid":"7850379641054","shopifyvariantid":"43570142052574","shopifyinventoryid":"45665787281630","shopifylocationid":"","product_id":"44595228","variant_id":"77487937","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44569873":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44569873","ebayitemid":"286007922308","shopifyproductid":"8694973858014","variants":[{"price":"549.99","quantity":0,"weight":"18","shopifyproductid":"8694973858014","shopifyvariantid":"45933680394462","shopifyinventoryid":"48032131580126","shopifylocationid":"","product_id":"44569873","variant_id":"77462557","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-08 19:40:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-08 19:40:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 19:40:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 19:40:07 [INFO]: Shopify Inventory id 45665787281630
2025-08-08 19:40:07 [INFO]: Shopify Location id 58450641063
2025-08-08 19:40:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 19:40:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T19:40:07Z","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-08 19:40:07 [INFO]: Change: available | Delta: -1
2025-08-08 19:40:07 [INFO]: Change: on_hand | Delta: -1
2025-08-08 19:40:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 19:40:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44595228 and user_id = 14409 
2025-08-08 19:40:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77487937 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 19:40:07 [INFO]: Shopify Inventory id 48032131580126
2025-08-08 19:40:07 [INFO]: Shopify Location id 58450641063
2025-08-08 19:40:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 19:40:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T19:40:07Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-08 19:40:08 [INFO]: Change: available | Delta: -2
2025-08-08 19:40:08 [INFO]: Change: on_hand | Delta: -2
2025-08-08 19:40:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 19:40:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44569873 and user_id = 14409 
2025-08-08 19:40:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77462557 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 19:40:08 [INFO]: updateIdsQuantity -> ["77487937","77462557"]
2025-08-08 19:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-08 19:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77487937 THEN 0 WHEN id = 77462557 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77487937 THEN 0 WHEN id = 77462557 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77487937,77462557)
2025-08-08 19:40:08 [INFO]: QUANTITY Updated IDs: 77487937, 77462557
2025-08-08 19:40:08 [INFO]: Successfully processed data for user 14409
2025-08-08 19:40:08 [INFO]: Execution Started
2025-08-08 19:40:08 [INFO]: Execution Finished
2025-08-08 19:50:01 [INFO]: Execution Started
2025-08-08 19:50:01 [INFO]: old server sucessfully connected
2025-08-08 19:50:01 [INFO]: sqs client sucess created
2025-08-08 19:50:02 [INFO]: Number of messages in the queue: 2
2025-08-08 19:50:03 [INFO]: item found in queue is if condition  14409
2025-08-08 19:50:03 [INFO]: item found in queue is  14409
2025-08-08 19:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBQgsCiFuHc/GQChsuceJh8aB1FuzN6ekFdzJL2BilRVZuWZv4OBSkvlJfR7Zxpv1d1PEtsHyJUrRhiQTdagnfLLhGgOOoyiszdPH/t6OweRx29q4Zc/9HGesQfDSUhajsjQBKAzWW9y64sYY8YOT2O76u5qhkRKlSot1VGQwlxFS2KpWHrskNOXW/hvqpswUCr/4h3J0lVK+bvo4dcGgr4Y9Kf4QmcuObHe4W/VWtZXzz3X48sed+dHc+xkhW8MJhyML0EU10ItAo8dqAEqwT3ILw3PWmwWFceCFfmJB4l8MFt3e8LUzV2xkV5RTJikuhW7omEv3perJTw/vxocduotvqJZUnzTY94v2rMu/PRIgU35j75OGMFmrpteJ8TvsVhXLUu3st6Xbg1KeaW6CSVwf39q5CoySsA5AYt0j6+81G7uA24GeWEluxKDnkNTly
2025-08-08 19:50:03 [INFO]: item found in queue is if condition  14409
2025-08-08 19:50:03 [INFO]: item found in queue is  14409
2025-08-08 19:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEB0bW7+SXn8Eb0HLMVZbKUTSrZpCp2WVDmKfTebzhzLzu5ieVwsSbjlzM0RcV8wqaiutBMwFE4H1jq+Hg9D1dpOcbFzFgRN95B8z/y7ALcImAGpwULWtjIHK55nLkjpWETGKNFqBncBoVbw+axJLXASzKG+ifrx70iMNEXKjg9IX5rbxBhyvPYAeuABtGgNI29YB3YWgvAuiTmzPKEKCs0/MYvBQ+Xp6ZfopK1Aw3tbIj/gHy1eYJlz/i8OjYWl7AjQHl39mpuIEURbXJecXqyRxPR/o+gSa/IMkL/zzO9szLHRNtsl67FeHpA82nVtm1RW5cV1ouqwrokcnFOPZMVWgWaic2/vpcMwCIvAXcAYNhqw8lR+ZoZ6KRnNQP5L0RoAcS7xVL9eF+0RmrhAZ+Olp8phglWZgEtoErXq9IWNGcvyEd/Nnt5ztic7ekX68/V
2025-08-08 19:50:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-08 19:50:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-08 19:50:04 [INFO]: inside itemsold and closed 14409
2025-08-08 19:50:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 19:50:05 [INFO]: autolink for user_id 14409 is 1
2025-08-08 19:50:05 [INFO]: Ebay item id :: 305868096547 exists in Database
2025-08-08 19:50:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 19:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 19:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 19:50:05 [INFO]: inside itemsold and closed 14409
2025-08-08 19:50:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 19:50:07 [INFO]: autolink for user_id 14409 is 1
2025-08-08 19:50:07 [INFO]: Ebay item id :: 305868083971 exists in Database
2025-08-08 19:50:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 19:50:07 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-08 19:50:07 [INFO]: in processold action queue is array    for {"44641590":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44641590","ebayitemid":"305868096547","shopifyproductid":"7848283472094","variants":[{"price":"62.99","quantity":0,"weight":"3","shopifyproductid":"7848283472094","shopifyvariantid":"43559375634654","shopifyinventoryid":"45655015424222","shopifylocationid":"","product_id":"44641590","variant_id":"77546779","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45145644":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45145644","ebayitemid":"305868083971","deleted":1}}}
2025-08-08 19:50:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-08 19:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 19:50:07 [INFO]: productIds WHich are having null productid -> [45145644]
2025-08-08 19:50:07 [INFO]: ebayItemIds WHich are not imported-> ["305868083971"]
2025-08-08 19:50:07 [INFO]: Entered in bulkUpdateProducts function
2025-08-08 19:50:07 [INFO]: Transaction started for bulkUpdateProducts
2025-08-08 19:50:07 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45145644)
2025-08-08 19:50:07 [INFO]: Query executed successfully. Affected rows: 0
2025-08-08 19:50:07 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-08 19:50:07 [INFO]: Transaction committed successfully.
2025-08-08 19:50:07 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-08 19:50:07 [INFO]: Shopify Inventory id 45655015424222
2025-08-08 19:50:07 [INFO]: Shopify Location id 58450641063
2025-08-08 19:50:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 19:50:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T19:50:07Z","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-08 19:50:07 [INFO]: Change: available | Delta: -1
2025-08-08 19:50:07 [INFO]: Change: on_hand | Delta: -1
2025-08-08 19:50:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 19:50:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44641590 and user_id = 14409 
2025-08-08 19:50:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77546779 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 19:50:07 [INFO]: updateIdsQuantity -> ["77546779"]
2025-08-08 19:50:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-08 19:50:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77546779 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77546779 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77546779)
2025-08-08 19:50:07 [INFO]: QUANTITY Updated IDs: 77546779
2025-08-08 19:50:07 [INFO]: Successfully processed data for user 14409
2025-08-08 19:50:07 [INFO]: Execution Started
2025-08-08 19:50:07 [INFO]: Execution Finished