2025-08-14 13:00:02 [INFO]: Execution Started
2025-08-14 13:00:02 [INFO]: old server sucessfully connected
2025-08-14 13:00:02 [INFO]: sqs client sucess created
2025-08-14 13:00:04 [INFO]: Number of messages in the queue: 0
2025-08-14 13:00:25 [INFO]: Execution Started
2025-08-14 13:00:25 [INFO]: Execution Finished
2025-08-14 13:10:01 [INFO]: Execution Started
2025-08-14 13:10:01 [INFO]: old server sucessfully connected
2025-08-14 13:10:01 [INFO]: sqs client sucess created
2025-08-14 13:10:03 [INFO]: Number of messages in the queue: 0
2025-08-14 13:10:25 [INFO]: Execution Started
2025-08-14 13:10:25 [INFO]: Execution Finished
2025-08-14 13:20:02 [INFO]: Execution Started
2025-08-14 13:20:02 [INFO]: old server sucessfully connected
2025-08-14 13:20:02 [INFO]: sqs client sucess created
2025-08-14 13:20:07 [INFO]: Number of messages in the queue: 1
2025-08-14 13:20:08 [INFO]: item found in queue is if condition  14409
2025-08-14 13:20:08 [INFO]: item found in queue is  14409
2025-08-14 13:20:10 [INFO]: Message deleted from the queue for receipt handle: AQEBp2jMY41tgiKTxUGxEvCxKmInAoDUoXOrnoXJ/qSxuKZgmDHU8cdYHdGSDEyryU9qIb8kRbjmSm1YOYhAN69ga96hXHsmdc/HNPvoRWLHKC+EU9SaEpxkA73Fku2zFfOmy2F3Sl2PuXqaFMZ7muxdt2FwPRppO1rlTT4QNZSiPZIcbW2yh0bYfnozSqwGBJsEUDwcFTmQ2dz1m6dCY0uE54xegYRygy5hxu+M+CT8qwn+dSmj0M8AKzB5B7pu2dRL/68SpNatnK7iYwWzp6yq5GJVspVrwG4Hy8YEllbvXgz0SIPEev+3Lr1eqtT+dM3AabbuWxCS77GHK/oP7WAX9iKgebtPm2ffjqPJDwDKXyc03nM+iVA8KKxpC25bsYxece4/r2rUVSKyOSM3uTOZ17Xv1UOrVMFj7uhXLDYI4zrganRhgY0LnFHEyApoB7x+
2025-08-14 13:20:10 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-14 13:20:10 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-14 13:20:10 [INFO]: inside itemsold and closed 14409
2025-08-14 13:20:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 13:20:12 [INFO]: autolink for user_id 14409 is 1
2025-08-14 13:20:12 [INFO]: Ebay item id :: 286765283971 exists in Database
2025-08-14 13:20:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 13:20:12 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-14 13:20:12 [INFO]: in processold action queue is array    for {"45314452":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45314452","ebayitemid":"286765283971","deleted":1}}}
2025-08-14 13:20:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-14 13:20:12 [INFO]: productIds WHich are having null productid -> [45314452]
2025-08-14 13:20:12 [INFO]: ebayItemIds WHich are not imported-> ["286765283971"]
2025-08-14 13:20:12 [INFO]: Entered in bulkUpdateProducts function
2025-08-14 13:20:12 [INFO]: Transaction started for bulkUpdateProducts
2025-08-14 13:20:12 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45314452)
2025-08-14 13:20:12 [INFO]: Query executed successfully. Affected rows: 0
2025-08-14 13:20:12 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-14 13:20:12 [INFO]: Transaction committed successfully.
2025-08-14 13:20:12 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-14 13:20:12 [INFO]: Successfully processed data for user 14409
2025-08-14 13:20:12 [INFO]: Execution Started
2025-08-14 13:20:12 [INFO]: Execution Finished
2025-08-14 13:30:01 [INFO]: Execution Started
2025-08-14 13:30:01 [INFO]: old server sucessfully connected
2025-08-14 13:30:01 [INFO]: sqs client sucess created
2025-08-14 13:30:12 [INFO]: Number of messages in the queue: 1
2025-08-14 13:30:15 [INFO]: item found in queue is if condition  14409
2025-08-14 13:30:15 [INFO]: item found in queue is  14409
2025-08-14 13:30:16 [INFO]: Message deleted from the queue for receipt handle: AQEB1aOYZzKS+9oSdheBiwr9XlMat5QDyv1SWlNNgFBxWVMrbB3VTk7BiFuutWD5PIpiBFh1W+03UP0bnhky0jYoWkK29q73W2Ai/fY1joBg9q6wAKG3L2kzfW3kGOH3D1VdLLclYe/OMJyBYaQ59UyYFnCkXBgEwZcxEJL4Q+zelVLaBK3S0NNmRtjQMH3Osdb90N2THovbpPtJgadnZhieSzEBZE1NLMCEcE7PFXbsTFUc1QjXttdu9szba8INlRnGjdozN1iW4fPyEQfc0kKM/aiXwc3LaWxitXDGdriv6/v8JJ4B49yMmZ2mrb6zXT7gbhD1dYxF/NTur+A/yuH3/ir7MWQBeCbIrOl8JsaCGEzTDCnuxK7RRHpAJJcGasW8BJmTuLjLvNpWg/toSinb1tuVVCrjsovDbTJnKOg5HqentGqR30y1dgj1Ki9xVWph
2025-08-14 13:30:16 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-14 13:30:16 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-14 13:30:16 [INFO]: inside itemsold and closed 14409
2025-08-14 13:30:17 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 13:30:17 [INFO]: autolink for user_id 14409 is 1
2025-08-14 13:30:17 [INFO]: Ebay item id :: 306419876833 exists in Database
2025-08-14 13:30:17 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 13:30:17 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-14 13:30:17 [INFO]: in processold action queue is array    for {"45309041":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45309041","ebayitemid":"306419876833","deleted":1}}}
2025-08-14 13:30:17 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-14 13:30:17 [INFO]: productIds WHich are having null productid -> [45309041]
2025-08-14 13:30:17 [INFO]: ebayItemIds WHich are not imported-> ["306419876833"]
2025-08-14 13:30:17 [INFO]: Entered in bulkUpdateProducts function
2025-08-14 13:30:17 [INFO]: Transaction started for bulkUpdateProducts
2025-08-14 13:30:17 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45309041)
2025-08-14 13:30:17 [INFO]: Query executed successfully. Affected rows: 0
2025-08-14 13:30:17 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-14 13:30:17 [INFO]: Transaction committed successfully.
2025-08-14 13:30:17 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-14 13:30:17 [INFO]: Successfully processed data for user 14409
2025-08-14 13:30:17 [INFO]: Execution Started
2025-08-14 13:30:17 [INFO]: Execution Finished
2025-08-14 13:40:01 [INFO]: Execution Started
2025-08-14 13:40:01 [INFO]: old server sucessfully connected
2025-08-14 13:40:01 [INFO]: sqs client sucess created
2025-08-14 13:40:04 [INFO]: Number of messages in the queue: 1
2025-08-14 13:40:05 [INFO]: item found in queue is if condition  14409
2025-08-14 13:40:05 [INFO]: item found in queue is  14409
2025-08-14 13:40:06 [INFO]: Message deleted from the queue for receipt handle: AQEBlmaP3t/x9eR3xkObrl6OiiFu+9gPcRUyjouKhSilYP/jMC8EORJasEl2WZ7OZkbNMrTAAis3XMtRxFTgYZ0gNPqRxpzjtfaOSUDYpPb32ocLKJ3fdzhPur3D8HQxC47y6oo+G3TZFbPIm+4adsXlT6mVNB4uV95XCUzrw/hioPKCkl5dHxU5ZCGRLXo0/54pvIM6dWlE821HHurY6ra4cRMeQ17sjZc6e10RqOFbKbt0kemhs1HLy3TvubQKQntCcYmxT1cdOHdVOvotS8dSe0QW1IBaPLuM3JT9GvMwsMGOZDEwzYjYoxrLNR9Q76zwEiYRz+g68P50LL7haEsIPiaylYgwosi/D+jx3fwHjCdPPApK+ZeoM8CGZmHYbIQwvXeGY6IS7vQ3Tr1sUIlwUXV+9kerPnTqFrtZhzyor4X3dV0qUlAJl/zUDJRDKxI3
2025-08-14 13:40:06 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-14 13:40:06 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-14 13:40:06 [INFO]: inside itemsold and closed 14409
2025-08-14 13:40:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 13:40:08 [INFO]: autolink for user_id 14409 is 1
2025-08-14 13:40:08 [INFO]: Ebay item id :: 332304511389 exists in Database
2025-08-14 13:40:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 13:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-14 13:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-14 13:40:08 [INFO]: in processold action queue is array    for {"44572278":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44572278","ebayitemid":"332304511389","shopifyproductid":"6855422378151","variants":[{"price":"9.95","quantity":0,"weight":"0.5","shopifyproductid":"6855422378151","shopifyvariantid":"40445799596199","shopifyinventoryid":"42541317390503","shopifylocationid":"","product_id":"44572278","variant_id":"77464962","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-14 13:40:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-14 13:40:08 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-14 13:40:08 [INFO]: Shopify Inventory id 42541317390503
2025-08-14 13:40:08 [INFO]: Shopify Location id 58450641063
2025-08-14 13:40:08 [INFO]: QUANTITY FOR UPDATE 0
2025-08-14 13:40:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1981,"restoreRate":100}}}}
2025-08-14 13:40:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-14 13:40:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44572278 and user_id = 14409 
2025-08-14 13:40:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77464962 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-14 13:40:08 [INFO]: updateIdsQuantity -> ["77464962"]
2025-08-14 13:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 0
2025-08-14 13:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77464962 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77464962 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77464962)
2025-08-14 13:40:08 [INFO]: QUANTITY Updated IDs: 
2025-08-14 13:40:08 [INFO]: Successfully processed data for user 14409
2025-08-14 13:40:08 [INFO]: Execution Started
2025-08-14 13:40:08 [INFO]: Execution Finished
2025-08-14 13:50:01 [INFO]: Execution Started
2025-08-14 13:50:01 [INFO]: old server sucessfully connected
2025-08-14 13:50:01 [INFO]: sqs client sucess created
2025-08-14 13:50:07 [INFO]: Number of messages in the queue: 1
2025-08-14 13:50:09 [INFO]: item found in queue is if condition  14409
2025-08-14 13:50:09 [INFO]: item found in queue is  14409
2025-08-14 13:50:10 [INFO]: Message deleted from the queue for receipt handle: AQEBVJQbcf+MurQmsli9o0vSJHVT/oUaWvj19V2qTrAtvBxfJkYpB9PD5QgwTLj5Nwqkf1YfWhkUH13isEGHMPdGQvME96FWTjBJVyi7cibkvTIlfvldrAY3e6TJqbkHKACY4YYP74RGorbGtnWP2YBK3rFBe32U3Nt5Uryu3P+/N0Jd6Gyx3a37CeGHHa4fhFbWHTFT884N+llwwcT3r/4j86O7fn/M7HF4yEij/Ay0nRaGrJz4x4TRiZLNrx7ccQ1JQsmR1sRDhKTHA7umGeBc/sMdu/LXNCbYCCIojJzfb74NkS9W5nfxRYzRQl6wji9nWttw9kD/KVLJlWe3ZNnnYYG4aORoJTURH1tGXurxfadiUuN4gvrElUNyJu+ATEz6icX54WFmDQcppTkkwosI7QedEkANyuA4mfHNFPZRTk6K903kwBSUAwxwxk9+C9bf
2025-08-14 13:50:10 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-14 13:50:10 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-14 13:50:10 [INFO]: inside itemsold and closed 14409
2025-08-14 13:50:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 13:50:12 [INFO]: autolink for user_id 14409 is 1
2025-08-14 13:50:12 [INFO]: Ebay item id :: 306207448859 exists in Database
2025-08-14 13:50:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 13:50:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-14 13:50:12 [INFO]: in processold action queue is array    for []
2025-08-14 13:50:12 [INFO]: Successfully processed data for user 14409
2025-08-14 13:50:12 [INFO]: Execution Started
2025-08-14 13:50:12 [INFO]: Execution Finished