2025-08-14 20:00:02 [INFO]: Execution Started 2025-08-14 20:00:02 [INFO]: old server sucessfully connected 2025-08-14 20:00:02 [INFO]: sqs client sucess created 2025-08-14 20:00:03 [INFO]: Number of messages in the queue: 1 2025-08-14 20:00:03 [INFO]: item found in queue is if condition 14409 2025-08-14 20:00:03 [INFO]: item found in queue is 14409 2025-08-14 20:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBDpoE7HYzb+95n/9DBNGZBWwyr8/pygVxeDq6CswvAfn5md/c6dRr6s2Sp4qZDYIQxmjb1EefdKXHzjSJnP0/VCtWKS8n28trjgd+aCZpvXaQIDSh+Tm0S6H6Geeq6kVNn+yVg1XQ1+SVA81RvpzzFWSzaETiYw7rTypNrDlAZ2seI8dyzH/5YaXgeT84/gBOVptBeJBrke+uyDHPBJcOL17bc45LuXtaoQrEo1Xar18VHvjySnkFQl6UGEtWKrISJ7v+3WFFgTDo8UhK0ahaCBYeyyaD2PtWdnTwODVT/VnyrFMFJ2MXrZaoQ1oWl/6gNEhKKAWBbUgpK5+ovwUjvg/BxVVAQ2ZFuiDcKqqKuzTQD+TloBvkLUQKiSCoouWW3BZd1w6FhWDly6KGoR0bw3CNczBY13tY2/R/6qlsracW8w5mhYXohXkfe5MqKDze 2025-08-14 20:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-14 20:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 20:00:03 [INFO]: inside itemsold and closed 14409 2025-08-14 20:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 20:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-14 20:00:05 [INFO]: Ebay item id :: 335831916610 exists in Database 2025-08-14 20:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-14 20:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 20:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 20:00:05 [INFO]: in processold action queue is array for {"44590816":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44590816","ebayitemid":"335831916610","shopifyproductid":"7117731135655","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"7117731135655","shopifyvariantid":"41598268113063","shopifyinventoryid":"43694884028583","shopifylocationid":"","product_id":"44590816","variant_id":"77483525","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 20:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 20:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 20:00:05 [INFO]: Shopify Inventory id 43694884028583 2025-08-14 20:00:05 [INFO]: Shopify Location id 58450641063 2025-08-14 20:00:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 20:00:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T20: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":1984,"restoreRate":100}}}} 2025-08-14 20:00:05 [INFO]: Change: available | Delta: -1 2025-08-14 20:00:05 [INFO]: Change: on_hand | Delta: -1 2025-08-14 20:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 20:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44590816 and user_id = 14409 2025-08-14 20:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77483525 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 20:00:05 [INFO]: updateIdsQuantity -> ["77483525"] 2025-08-14 20:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-14 20:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77483525 THEN 0 END, quantityflag = CASE WHEN id = 77483525 THEN 0 END WHERE user_id = 14409 AND id IN (77483525) 2025-08-14 20:00:05 [INFO]: QUANTITY Updated IDs: 77483525 2025-08-14 20:00:05 [INFO]: Successfully processed data for user 14409 2025-08-14 20:00:05 [INFO]: Execution Started 2025-08-14 20:00:05 [INFO]: Execution Finished 2025-08-14 20:10:01 [INFO]: Execution Started 2025-08-14 20:10:01 [INFO]: old server sucessfully connected 2025-08-14 20:10:01 [INFO]: sqs client sucess created 2025-08-14 20:10:02 [INFO]: Number of messages in the queue: 0 2025-08-14 20:10:22 [INFO]: Execution Started 2025-08-14 20:10:22 [INFO]: Execution Finished 2025-08-14 20:20:01 [INFO]: Execution Started 2025-08-14 20:20:01 [INFO]: old server sucessfully connected 2025-08-14 20:20:01 [INFO]: sqs client sucess created 2025-08-14 20:20:02 [INFO]: Number of messages in the queue: 0 2025-08-14 20:20:22 [INFO]: Execution Started 2025-08-14 20:20:22 [INFO]: Execution Finished 2025-08-14 20:30:01 [INFO]: Execution Started 2025-08-14 20:30:01 [INFO]: old server sucessfully connected 2025-08-14 20:30:01 [INFO]: sqs client sucess created 2025-08-14 20:30:02 [INFO]: Number of messages in the queue: 1 2025-08-14 20:30:02 [INFO]: item found in queue is if condition 14409 2025-08-14 20:30:02 [INFO]: item found in queue is 14409 2025-08-14 20:30:02 [INFO]: Message deleted from the queue for receipt handle: AQEB/NXAt0+5edFXXPtBFu7HOEbdynivBus7yHIz6W6/BSKZM0XAIYJIlwkiyXe0duc3R35zP0/xagc1uCSdZo4qMQHqYZiko+fhfREsmAG7AULzvZUlsdwvamLCUrvIr6HF/5w8OCux9s7rNISDprzq0wQkksxeQRiS1dftdVVpcFZJ6lW7/rYXIGPhjnhvFQC3Y1daDUNOaDtiLM4gvUlHnRNrl6e6Tn4kQlFG9DE4BEqA9EZFXIDTvdIoKxpIY7Bg1r0hMcovUeYNjHeOvy3vXDl1iLSjnSDgShU+g3QYPOpcSwKFvx3Eez5AzGy2HslInlB/1x46ksbv1jYPShozm5pNO9wZzah3vjx+PtaCwh0AT085TaPkcvxO8rKnuDFmR6y9hYcnIwrwf5CvO23t0zTq9dJ6CSP1u+AH3D7TCPD73ekNc87Ulz4pTAhqHMEv 2025-08-14 20:30:02 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-14 20:30:02 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 20:30:02 [INFO]: inside itemsold and closed 14409 2025-08-14 20:30:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 20:30:04 [INFO]: autolink for user_id 14409 is 1 2025-08-14 20:30:04 [INFO]: Ebay item id :: 306004582892 exists in Database 2025-08-14 20:30:04 [INFO]: Item is reliested :: exists in Database 2025-08-14 20:30:04 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-14 20:30:04 [INFO]: in processold action queue is array for {"45145680":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45145680","ebayitemid":"306004582892","deleted":1}}} 2025-08-14 20:30:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 20:30:04 [INFO]: productIds WHich are having null productid -> [45145680] 2025-08-14 20:30:04 [INFO]: ebayItemIds WHich are not imported-> ["306004582892"] 2025-08-14 20:30:04 [INFO]: Entered in bulkUpdateProducts function 2025-08-14 20:30:04 [INFO]: Transaction started for bulkUpdateProducts 2025-08-14 20:30:04 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45145680) 2025-08-14 20:30:04 [INFO]: Query executed successfully. Affected rows: 0 2025-08-14 20:30:04 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-14 20:30:04 [INFO]: Transaction committed successfully. 2025-08-14 20:30:04 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-14 20:30:04 [INFO]: Successfully processed data for user 14409 2025-08-14 20:30:04 [INFO]: Execution Started 2025-08-14 20:30:04 [INFO]: Execution Finished 2025-08-14 20:40:01 [INFO]: Execution Started 2025-08-14 20:40:01 [INFO]: old server sucessfully connected 2025-08-14 20:40:01 [INFO]: sqs client sucess created 2025-08-14 20:40:02 [INFO]: Number of messages in the queue: 3 2025-08-14 20:40:02 [INFO]: item found in queue is if condition 14409 2025-08-14 20:40:02 [INFO]: item found in queue is 14409 2025-08-14 20:40:02 [INFO]: Message deleted from the queue for receipt handle: AQEBzblu9+1hNo2kMEdTzoV69V1TraTEHVI+WN4Z/JoAwMh+1TceBSqO+RVpsJcTHfDqNAh/JUQJ3go53YuGNXRGfR3gPIhvvUnS41jm/bZoEepA6C4suYC6pV/y9bZ1hFQp8MnEDIP/7iCVa2GJC4WNindPs92Oo50DWgD5L/yAsyCIm88L9X7Atym7QjUPNnplCskFB7RBNo5mstzYoELNdZ6jT3I8y6ekGkLxExOX/+QkxKd5rj8hMRJgtUeXOIa5oUuZswsgRmx8gA6SwUrh6D3+JRf93JIOVf1Y+RrtWT1wEmORpUoOWZYiJJh3i/bPY1wkBBj06G06cq1HL7teCCSaxbEBc3K33RAUzsT9XCieLZrnM85QIoRexaZrkzzeZAPMt8o4Z+TeUSoHC4Oggvwsj+XoiARQ0gBSOX1t7+EOr+ElJ2gXDnlZwoCsP33t 2025-08-14 20:40:03 [INFO]: item found in queue is if condition 14409 2025-08-14 20:40:03 [INFO]: item found in queue is 14409 2025-08-14 20:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBz2cGpn1wrKCPnqNvf6r6pu/xyKL9vRO9XGTe2/h1+LIjpkT+suTXIAI8Yoc/XidafWn+16fOKNFBNF/2c2JC0CPF4M3p4n4G8Vku1o7Q4w4hQ14o8na7U6YrULIDsODIveCMdL1SI8YPuTpUYTtawX6bJEfD96bHbvigp5vnp97OnJtG5wsL5Id++Sf/3i8abFyFHXkPVLHxsD513kBo6cY9hn7iT5Z5mE7Q2N7V5F6vurzMKAD/sbZ5oBtWbIX5cA8UZuihY3jCfsVeSr2R9Bk03cHAifvCPtLht9U2us+QCd6vdEyhzQkcSjicSgGsAw4dEtNS1o3HcX9MMc1UpqPKJdhc4Uw77ik2ah2cbQL0GX4pEQhWyXUoKGfphwvUdkRzLF3a1Mf8cGrjyih+l/cUgIjDxuxipgvS0D7YSENSrDprRj5LHkHLgv1/Ic4E 2025-08-14 20:40:03 [INFO]: item found in queue is if condition 14409 2025-08-14 20:40:03 [INFO]: item found in queue is 14409 2025-08-14 20:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEB+QdrnFt61T45qLUZR70sPgf2Zz61V3fD4e1D72MClkSgS6mOi3EALeCEUdvjMD6fuvtkVtiM9e+k2ZylQIAQQq3jHMyFD1Y2ckJeezY/kP8TAwQwErOXC/1e5hueAJydJ3oZQIxXx15BPm1BWL6iMdj7wgGaiA1a96Ry3bKrmBFkpFQ14bJFbqEhOyaWOeD+/fR1QrqXjFN+dT+YaqrDmYh9ZfSu50LPV6N0MTRYIxcHHqSMw2sBFPuAo6uiW5xpbobMyJQpqv7YTg0FbNfDrub+rUcpGcMJMYRL434JAJfxd9LjlO/VjgKdCqKEOepuY0L6R1115USuRYkfgtXBKU73dHv5YhbC+xAuX+j2/hGLk4JPtgICCMx3gB413ejkr81adlF2Heb4UyYAIj3jOyxjIVRu0UgEfK5W6kMrGDTJT9CWojnfQ5uEcSMiQn7f 2025-08-14 20:40:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-14 20:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 20:40:04 [INFO]: inside itemsold and closed 14409 2025-08-14 20:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 20:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-14 20:40:05 [INFO]: Ebay item id :: 226869152095 exists in Database 2025-08-14 20:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-14 20:40:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-14 20:40:05 [INFO]: inside itemsold and closed 14409 2025-08-14 20:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 20:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-14 20:40:07 [INFO]: Ebay item id :: 286213799373 exists in Database 2025-08-14 20:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-14 20:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 20:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 20:40:07 [INFO]: inside itemsold and closed 14409 2025-08-14 20:40:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 20:40:08 [INFO]: autolink for user_id 14409 is 1 2025-08-14 20:40:08 [INFO]: Ebay item id :: 305973601529 exists in Database 2025-08-14 20:40:08 [INFO]: Item is reliested :: exists in Database 2025-08-14 20:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 20:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 20:40:08 [INFO]: in processold action queue is array for {"45237266":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45237266","ebayitemid":"226869152095","deleted":1}},"44571422":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44571422","ebayitemid":"286213799373","shopifyproductid":"8143308488926","variants":[{"price":"61.99","quantity":0,"weight":"3","shopifyproductid":"8143308488926","shopifyvariantid":"44376565579998","shopifyinventoryid":"46474354950366","shopifylocationid":"","product_id":"44571422","variant_id":"77464106","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44571432":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44571432","ebayitemid":"305973601529","shopifyproductid":"7848286945502","variants":[{"price":"61.99","quantity":0,"weight":"3","shopifyproductid":"7848286945502","shopifyvariantid":"43559379894494","shopifyinventoryid":"45655019684062","shopifylocationid":"","product_id":"44571432","variant_id":"77464116","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 20:40:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 20:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 20:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 20:40:09 [INFO]: productIds WHich are having null productid -> [45237266] 2025-08-14 20:40:09 [INFO]: ebayItemIds WHich are not imported-> ["226869152095"] 2025-08-14 20:40:09 [INFO]: Entered in bulkUpdateProducts function 2025-08-14 20:40:09 [INFO]: Transaction started for bulkUpdateProducts 2025-08-14 20:40:09 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45237266) 2025-08-14 20:40:09 [INFO]: Query executed successfully. Affected rows: 0 2025-08-14 20:40:09 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-14 20:40:09 [INFO]: Transaction committed successfully. 2025-08-14 20:40:09 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-14 20:40:09 [INFO]: Shopify Inventory id 46474354950366 2025-08-14 20:40:09 [INFO]: Shopify Location id 58450641063 2025-08-14 20:40:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 20:40:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T20:40:09Z","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-14 20:40:09 [INFO]: Change: available | Delta: -1 2025-08-14 20:40:09 [INFO]: Change: on_hand | Delta: -1 2025-08-14 20:40:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 20:40:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44571422 and user_id = 14409 2025-08-14 20:40:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77464106 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 20:40:09 [INFO]: Shopify Inventory id 45655019684062 2025-08-14 20:40:09 [INFO]: Shopify Location id 58450641063 2025-08-14 20:40:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 20:40:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T20:40:09Z","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-14 20:40:09 [INFO]: Change: available | Delta: -1 2025-08-14 20:40:09 [INFO]: Change: on_hand | Delta: -1 2025-08-14 20:40:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 20:40:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44571432 and user_id = 14409 2025-08-14 20:40:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77464116 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 20:40:09 [INFO]: updateIdsQuantity -> ["77464106","77464116"] 2025-08-14 20:40:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-14 20:40:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77464106 THEN 0 WHEN id = 77464116 THEN 0 END, quantityflag = CASE WHEN id = 77464106 THEN 0 WHEN id = 77464116 THEN 0 END WHERE user_id = 14409 AND id IN (77464106,77464116) 2025-08-14 20:40:09 [INFO]: QUANTITY Updated IDs: 77464106, 77464116 2025-08-14 20:40:09 [INFO]: Successfully processed data for user 14409 2025-08-14 20:40:09 [INFO]: Execution Started 2025-08-14 20:40:09 [INFO]: Execution Finished 2025-08-14 20:50:01 [INFO]: Execution Started 2025-08-14 20:50:01 [INFO]: old server sucessfully connected 2025-08-14 20:50:01 [INFO]: sqs client sucess created 2025-08-14 20:50:03 [INFO]: Number of messages in the queue: 3 2025-08-14 20:50:03 [INFO]: item found in queue is if condition 14409 2025-08-14 20:50:03 [INFO]: item found in queue is 14409 2025-08-14 20:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBhGOS4U98Gn1UMyA8Seu2iPau2DXly9ysMzjm/RZ3we33ka3iFJQYhgV0C0ZUepJe3h+KUOXM3x1cFmtWf0ijoJUAJAQ3PaUcW8ZkqRSdQyxprGvkvwQ03lq+XcDFClFYxZgiHRU8f0vWlVwp4sEC49pvmzGQapC1ydWYMjWQSuVo2vHVjQzPuX6Zc5iXfUifwTm5rm4jZHf0trcvyCPEgyk9dckhRrpXONwyaFUv3zJFTqQ7+6jOCXzn/Ae5kRR1in6zjQzr05k2dOxPU+egSJjbfHh+mvBEiot5g/G4D2TEAXbF/kkY6T/rkI/aueG88Fgv2wqAmPSjPZZQ8HEw7It2M5xzjgOtW1VVq/17atcy9b+BZwRlazmutBR382Nj+UqFXqBZlrBX3s4ZDO6HQpEMHvFJuYRP5O4RfLfhU3BOcBmNfHmwAtCCM4u8A93y 2025-08-14 20:50:03 [INFO]: item found in queue is if condition 14409 2025-08-14 20:50:03 [INFO]: item found in queue is 14409 2025-08-14 20:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBxMn/u5tzJ5BFzZdv3NUAOCKeAfssR1S6Mi9h2gq5eL/qhPCqQ1z7Cl+Sm44IGj7f62ip4LF8iPH33lz03FTUu7nIKEUkLFm0So3aKIxZ9NUupkhfLt0iYWlE7C8UeGB8Q7uCpsTbt75alRjCV1TUIr9yZDNIyL271yCcwKiY1Bb+TzsShc1vONwb87xuI0X0ikaHxYJqup/tdFQF4p4pw6j1AbloK56qA39unx5WH8gQwQPs1aEVm3rDCxUd+Jdb0w/Or9BdQU7DsIxOjw09faTRdO7pF6BnD3lRTSyoTIh9Hg63y8MmsFIskyLGYDBzd6y1q6ap1jOs/na43nKp5b4cBMw+SOsGWI+yMWB2ihOBvDKxoHCRuJQuQCLfOS40X5mZvmHEdg3OVUeNtSPwGizsPrL96msWTWW7YhMzJPOuWFkNLGKHGYxN1Iy68pzz 2025-08-14 20:50:04 [INFO]: item found in queue is if condition 14409 2025-08-14 20:50:04 [INFO]: item found in queue is 14409 2025-08-14 20:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEB/AW1v4+jP57DFPRYSKUw4bqNAEHO2hoTx4i9RFma56U4cdKWq8k+KZGe/JsveI4+XUh0kFt69v+bjiOLDKkbgGg3Vl5Kdrx1nJp1ypJbEQru1DQChD4qzltPbJkYTieMCvNBPLo7pOF0tCgPh3GucYC8iSwdq7vgdpajex8IpLvVb1WIFrbC1skM8C0XrnKTamkt38vO20Mldz68Mo9HzqqitAuLZM4lP8yyvLjf5Okj8iVpOJ1mKI/XS9PSnHf8fhoVX1kXySPA0vVl9k3JSSx3pJ35t09lZ+Vv/H79wVGozDkPBsF+5e7dKzP09P0Eu+w2YQUYj7GZbRdYHMAa8rqlT3CrsiQ8szniQZ8N+rk5XHwGvhDnRF9wmfqvF2+e8Gr/PI0Q0knw8YuUFXEHABcn3kV8SsWkkGCe7QnbL5LR5wblRwXC8X9kHmRkKe8G 2025-08-14 20:50:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-14 20:50:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 20:50:04 [INFO]: inside itemsold and closed 14409 2025-08-14 20:50:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 20:50:06 [INFO]: autolink for user_id 14409 is 1 2025-08-14 20:50:06 [INFO]: Ebay item id :: 405801582546 exists in Database 2025-08-14 20:50:06 [INFO]: Item is reliested :: exists in Database 2025-08-14 20:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 20:50:06 [INFO]: inside itemsold and closed 14409 2025-08-14 20:50:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 20:50:08 [INFO]: autolink for user_id 14409 is 1 2025-08-14 20:50:08 [INFO]: Ebay item id :: 335727906706 exists in Database 2025-08-14 20:50:08 [INFO]: Item is reliested :: exists in Database 2025-08-14 20:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 20:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 20:50:08 [INFO]: inside itemsold and closed 14409 2025-08-14 20:50:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 20:50:09 [INFO]: autolink for user_id 14409 is 1 2025-08-14 20:50:09 [INFO]: Ebay item id :: 305973593842 exists in Database 2025-08-14 20:50:09 [INFO]: Item is reliested :: exists in Database 2025-08-14 20:50:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 20:50:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 20:50:09 [INFO]: in processold action queue is array for {"44571414":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44571414","ebayitemid":"335727906706","shopifyproductid":"7626180624606","variants":[{"price":"61.99","quantity":0,"weight":"3","shopifyproductid":"7626180624606","shopifyvariantid":"42703423897822","shopifyinventoryid":"44797703684318","shopifylocationid":"","product_id":"44571414","variant_id":"77464098","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44571419":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44571419","ebayitemid":"305973593842","shopifyproductid":"7829900099806","variants":[{"price":"61.99","quantity":0,"weight":"3","shopifyproductid":"7829900099806","shopifyvariantid":"43500712526046","shopifyinventoryid":"45596242542814","shopifylocationid":"","product_id":"44571419","variant_id":"77464103","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 20:50:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 20:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 20:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 20:50:09 [INFO]: Shopify Inventory id 44797703684318 2025-08-14 20:50:09 [INFO]: Shopify Location id 58450641063 2025-08-14 20:50:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 20:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T20:50:10Z","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-14 20:50:10 [INFO]: Change: available | Delta: -1 2025-08-14 20:50:10 [INFO]: Change: on_hand | Delta: -1 2025-08-14 20:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 20:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44571414 and user_id = 14409 2025-08-14 20:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77464098 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 20:50:10 [INFO]: Shopify Inventory id 45596242542814 2025-08-14 20:50:10 [INFO]: Shopify Location id 58450641063 2025-08-14 20:50:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 20:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T20:50:10Z","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-14 20:50:10 [INFO]: Change: available | Delta: -1 2025-08-14 20:50:10 [INFO]: Change: on_hand | Delta: -1 2025-08-14 20:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 20:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44571419 and user_id = 14409 2025-08-14 20:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77464103 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 20:50:10 [INFO]: updateIdsQuantity -> ["77464098","77464103"] 2025-08-14 20:50:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-14 20:50:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77464098 THEN 0 WHEN id = 77464103 THEN 0 END, quantityflag = CASE WHEN id = 77464098 THEN 0 WHEN id = 77464103 THEN 0 END WHERE user_id = 14409 AND id IN (77464098,77464103) 2025-08-14 20:50:10 [INFO]: QUANTITY Updated IDs: 77464098, 77464103 2025-08-14 20:50:10 [INFO]: Successfully processed data for user 14409 2025-08-14 20:50:10 [INFO]: Execution Started 2025-08-14 20:50:10 [INFO]: Execution Finished