2025-08-07 20:00:01 [INFO]: Execution Started 2025-08-07 20:00:01 [INFO]: old server sucessfully connected 2025-08-07 20:00:01 [INFO]: sqs client sucess created 2025-08-07 20:00:02 [INFO]: Number of messages in the queue: 2 2025-08-07 20:00:02 [INFO]: item found in queue is if condition 14409 2025-08-07 20:00:02 [INFO]: item found in queue is 14409 2025-08-07 20:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBFgXWQN9nxORW/zUY12pZLEuDamFkQWyrToxt+3aAT5STIDCU9wQHgje8LhsgkQVqwu6F3GRjjvvyievW8PXIGaQxN+4YMGHvm5zNPNI67W3IaMGhJSG8xe7bYgwz0JVt9A6jf7fO/s+f0S/NAVKflldT+6c03zfTpFdLIUrkV4LrWY4SZgDkrU5NANRC01otR55dl6rV94cKpVHhxa5m4mrDWfVsr+CtQcMoaOBCBtwvmywyiWFsBnRrVF1kjj8DLu4txLUMGrMuTnB9CZ6+taPPxq2gXZj1Ioai3k9QWuU2PM2OcH+xEKoz+E/xIz2TmMvl3cyS9dM3LccMPNtmqD2oPE0k89iPPWUAvfy7ih4g49brA39UQRTwhY36CtkIfUVzpSpksSqWvVjS3spNdZH3CCf06lyaozPY9lBaJlK/6nB70HsWmwtI6LrMKCaa 2025-08-07 20:00:03 [INFO]: item found in queue is if condition 14409 2025-08-07 20:00:03 [INFO]: item found in queue is 14409 2025-08-07 20:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBbY+M+zFov7wA1mm9JFhh3rxETwhiR/6OzNIKeNMl//BsDwNTu0tveVL46ZnwMOMELhn/aFUiP7NiZI2/14TuBkUQDB1Tfm6pwCn6Lba96tUAOY7vPV2q14r+A/ImcAuKsVidhPOZ/WCYb3yj1RJftVnFdqZI72hBGSGrr/78ZCT2aPHr+iBK2cBkQdBFshC30sAqEyUl6BCubdovjyEfX+4fSxoB8cPA29DCKLaB4rnCaHM7sVzfU/X+66uvPvDGj9BaVVvyRUX3dlvHopSVy1YEy/aeEagYoLCey0hHAhtzW3pUmyLMXlASJ+m8yh/hbXMWGNkGtHzRMWdBkNfdQyrwvoCJdKYzrZRSfQq7jm/V2PYXR//pEpJGqCWcEIZvV/uknv+6b5lIvzis1aqvZHWMGgzecy15U5bXoPKfPAn0kDai98Q1f3JFXPysiDEL 2025-08-07 20:00:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-07 20:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 20:00:03 [INFO]: inside itemsold and closed 14409 2025-08-07 20:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 20:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-07 20:00:05 [INFO]: Ebay item id :: 284812476350 exists in Database 2025-08-07 20:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-07 20:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 20:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 20:00:05 [INFO]: inside itemsold and closed 14409 2025-08-07 20:00:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 20:00:07 [INFO]: autolink for user_id 14409 is 1 2025-08-07 20:00:07 [INFO]: Ebay item id :: 284958877442 exists in Database 2025-08-07 20:00:07 [INFO]: Item is reliested :: exists in Database 2025-08-07 20:00:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 20:00:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 20:00:07 [INFO]: in processold action queue is array for {"44636702":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44636702","ebayitemid":"284812476350","shopifyproductid":"7654192611550","variants":[{"price":"9.99","quantity":0,"weight":"0","shopifyproductid":"7654192611550","shopifyvariantid":"42806770958558","shopifyinventoryid":"44901348573406","shopifylocationid":"","product_id":"44636702","variant_id":"77541891","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44758577":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44758577","ebayitemid":"284958877442","shopifyproductid":"7788018499806","variants":[{"price":"11.99","quantity":0,"weight":"0.5","shopifyproductid":"7788018499806","shopifyvariantid":"43371831558366","shopifyinventoryid":"45467135672542","shopifylocationid":"","product_id":"44758577","variant_id":"77667111","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 20:00:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 20:00:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 20:00:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 20:00:07 [INFO]: Shopify Inventory id 44901348573406 2025-08-07 20:00:07 [INFO]: Shopify Location id 58450641063 2025-08-07 20:00:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 20:00:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T20:00: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-07 20:00:07 [INFO]: Change: available | Delta: -1 2025-08-07 20:00:07 [INFO]: Change: on_hand | Delta: -1 2025-08-07 20:00:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 20:00:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44636702 and user_id = 14409 2025-08-07 20:00:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77541891 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 20:00:07 [INFO]: Shopify Inventory id 45467135672542 2025-08-07 20:00:07 [INFO]: Shopify Location id 58450641063 2025-08-07 20:00:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 20:00:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T20:00: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-07 20:00:08 [INFO]: Change: available | Delta: -1 2025-08-07 20:00:08 [INFO]: Change: on_hand | Delta: -1 2025-08-07 20:00:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 20:00:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44758577 and user_id = 14409 2025-08-07 20:00:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77667111 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 20:00:08 [INFO]: updateIdsQuantity -> ["77541891","77667111"] 2025-08-07 20:00:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-07 20:00:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77541891 THEN 0 WHEN id = 77667111 THEN 0 END, quantityflag = CASE WHEN id = 77541891 THEN 0 WHEN id = 77667111 THEN 0 END WHERE user_id = 14409 AND id IN (77541891,77667111) 2025-08-07 20:00:08 [INFO]: QUANTITY Updated IDs: 77541891, 77667111 2025-08-07 20:00:08 [INFO]: Successfully processed data for user 14409 2025-08-07 20:00:08 [INFO]: Execution Started 2025-08-07 20:00:08 [INFO]: Execution Finished 2025-08-07 20:10:01 [INFO]: Execution Started 2025-08-07 20:10:01 [INFO]: old server sucessfully connected 2025-08-07 20:10:01 [INFO]: sqs client sucess created 2025-08-07 20:10:02 [INFO]: Number of messages in the queue: 1 2025-08-07 20:10:03 [INFO]: item found in queue is if condition 14409 2025-08-07 20:10:03 [INFO]: item found in queue is 14409 2025-08-07 20:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBascyFFgQK3g2YghHZlV+aoZ3eggZmJUVkzeqlYeUpgGVSh4QFkUYmm+nkPIFUGwcgRHV/HMnPTLN7QsKIyaQQl10L8Pd8cMYp9nvvgSFsgB606NHGFLCx1qNA3AZ426mHhZSjwGYRjCNMNYWZ3vlGWtQhmGQRao1PRYZ7tYZo4HTkkbY3I25qb3Z37kMrUEOy6UQwFnqTUCLb3sOUACeJUW7hJfE6nKUfiXDgwwqyWO6mnpcT6lu3ndeTSZJHJtMR8VdTpdzq9SlmAW2hzYg+I7nm9eTAO0GqC7lYX6YSkJwvTvWRNxCdURTqzLUDW+JVCDI+MiMUXa4zv9VpujM/sBjh1RmmkBz33nWjWj4ei2La+wEbaWd22SFqpyjpr6ZCd5To6I3CUFjidDCS8adNTYnXFUYuvpum7tV3fe37Sfpvf+nlcAcQGq92xvOeK3N 2025-08-07 20:10:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 20:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 20:10:03 [INFO]: inside itemsold and closed 14409 2025-08-07 20:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 20:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-07 20:10:05 [INFO]: Ebay item id :: 285775178595 exists in Database 2025-08-07 20:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-07 20:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 20:10:05 [INFO]: in processold action queue is array for [] 2025-08-07 20:10:05 [INFO]: Successfully processed data for user 14409 2025-08-07 20:10:05 [INFO]: Execution Started 2025-08-07 20:10:05 [INFO]: Execution Finished 2025-08-07 20:20:02 [INFO]: Execution Started 2025-08-07 20:20:02 [INFO]: old server sucessfully connected 2025-08-07 20:20:02 [INFO]: sqs client sucess created 2025-08-07 20:20:03 [INFO]: Number of messages in the queue: 1 2025-08-07 20:20:03 [INFO]: item found in queue is if condition 14409 2025-08-07 20:20:03 [INFO]: item found in queue is 14409 2025-08-07 20:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBkN5cEKC5J5qRK39bqKmlPq7YyoAjTuppvb1KTZL3Drf7pnBx20J0VU5GKUmZuC8uRzxlNwDoFq8p02X454qsubfpoXx3ddMZsnkDgf4pm5xEJpgUiLDqrbtnvDv6ZwSpc6/9f0rajtS3sW58nIjSgFRCDCmsg1HQoS1/JwZgUp1DYRatwfeBUl0AvGCHcJgwwfAJN1hVYTQ2XNque4DRg2SWMuF6HRUAuaaN4/xGP1jGlE1lUq0kGJa/BMKmTh3YB2h53Ou9uRESkdVqd0m0IyO+577Y1SrrohNFwulF8YXnDd4cNqJsgkG+QipfkHGqtEoX3EjgWTJfD1LMbnGkE4yTHy+DI4DbDYe8gFYagtFn7S6PY5WFAN1ztz1F01iL/GNYeyjV9n9VYpeogu5QYTtZUXyZC0fs9SQ6Ja5PhWZwEzFX2ZaVpH4BPKbyWZpX 2025-08-07 20:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 20:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 20:20:03 [INFO]: inside itemsold and closed 14409 2025-08-07 20:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 20:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-07 20:20:05 [INFO]: Ebay item id :: 406014037002 exists in Database 2025-08-07 20:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-07 20:20:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-07 20:20:05 [INFO]: in processold action queue is array for {"45184456":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45184456","ebayitemid":"406014037002","deleted":1}}} 2025-08-07 20:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 20:20:05 [INFO]: productIds WHich are having null productid -> [45184456] 2025-08-07 20:20:05 [INFO]: ebayItemIds WHich are not imported-> ["406014037002"] 2025-08-07 20:20:05 [INFO]: Entered in bulkUpdateProducts function 2025-08-07 20:20:05 [INFO]: Transaction started for bulkUpdateProducts 2025-08-07 20:20:05 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45184456) 2025-08-07 20:20:05 [INFO]: Query executed successfully. Affected rows: 0 2025-08-07 20:20:05 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-07 20:20:05 [INFO]: Transaction committed successfully. 2025-08-07 20:20:05 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-07 20:20:05 [INFO]: Successfully processed data for user 14409 2025-08-07 20:20:05 [INFO]: Execution Started 2025-08-07 20:20:05 [INFO]: Execution Finished 2025-08-07 20:30:01 [INFO]: Execution Started 2025-08-07 20:30:01 [INFO]: old server sucessfully connected 2025-08-07 20:30:01 [INFO]: sqs client sucess created 2025-08-07 20:30:02 [INFO]: Number of messages in the queue: 1 2025-08-07 20:30:03 [INFO]: item found in queue is if condition 14409 2025-08-07 20:30:03 [INFO]: item found in queue is 14409 2025-08-07 20:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBYhYs3zVWR6dD/LOu2kf9pJ3knkLzRgjRzuzy3PRPO0v3twTXHQWSRbH0Aeqrfv+D1Aype9TRErk2GyRxnNytF+wteLE/yja11s4wLqB0JDVBnsSraeVy6WIhCPjpki5vofRbSbDXgMpdy/JzAaQzGPT5i8Hk+r/+HeBuOYhiJsU5GZnI4BjXGc1E4xSxyp3j5vFCOpsCvHAmE6+wvtZy/Wh1XIj7SJG+cy9PiLEXU1qxvjJ4B+wzU8L1qah8OtMrKRm3O0NOg7bSXz2gqAtr4Iye0bSWCClmjio10WZr4dcJWUfgSsh95UByM6q3fZAvEk6apAAqUzG6/Mng5N8rKtVk3y70p53S/WOXnC66jyIN/0xfxhLbFpS/8G+8Mn2oWvFH4+gLTdxF4K1o8vHXwR+Hslb+q2nzmLDz9sf0uiGTGy1c984Q3xP3I+/wREl+ 2025-08-07 20:30:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 20:30:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 20:30:03 [INFO]: inside itemsold and closed 14409 2025-08-07 20:30:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 20:30:05 [INFO]: autolink for user_id 14409 is 1 2025-08-07 20:30:05 [INFO]: Ebay item id :: 286598865151 exists in Database 2025-08-07 20:30:05 [INFO]: Item is reliested :: exists in Database 2025-08-07 20:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 20:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 20:30:05 [INFO]: in processold action queue is array for {"44885852":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44885852","ebayitemid":"286598865151","shopifyproductid":"8927056625886","variants":[{"price":"129.99","quantity":0,"weight":"3","shopifyproductid":"8927056625886","shopifyvariantid":"46842615890142","shopifyinventoryid":"48946566299870","shopifylocationid":"58450641063","product_id":"44885852","variant_id":"77797822","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 20:30:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 20:30:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 20:30:05 [INFO]: Shopify Inventory id 48946566299870 2025-08-07 20:30:05 [INFO]: Shopify Location id 58450641063 2025-08-07 20:30:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 20:30:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T20: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-07 20:30:05 [INFO]: Change: available | Delta: -1 2025-08-07 20:30:05 [INFO]: Change: on_hand | Delta: -1 2025-08-07 20:30:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 20:30:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44885852 and user_id = 14409 2025-08-07 20:30:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77797822 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 20:30:05 [INFO]: updateIdsQuantity -> ["77797822"] 2025-08-07 20:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 20:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77797822 THEN 0 END, quantityflag = CASE WHEN id = 77797822 THEN 0 END WHERE user_id = 14409 AND id IN (77797822) 2025-08-07 20:30:05 [INFO]: QUANTITY Updated IDs: 77797822 2025-08-07 20:30:05 [INFO]: Successfully processed data for user 14409 2025-08-07 20:30:05 [INFO]: Execution Started 2025-08-07 20:30:05 [INFO]: Execution Finished 2025-08-07 20:40:01 [INFO]: Execution Started 2025-08-07 20:40:01 [INFO]: old server sucessfully connected 2025-08-07 20:40:01 [INFO]: sqs client sucess created 2025-08-07 20:40:02 [INFO]: Number of messages in the queue: 0 2025-08-07 20:40:22 [INFO]: Execution Started 2025-08-07 20:40:22 [INFO]: Execution Finished 2025-08-07 20:50:01 [INFO]: Execution Started 2025-08-07 20:50:01 [INFO]: old server sucessfully connected 2025-08-07 20:50:01 [INFO]: sqs client sucess created 2025-08-07 20:50:02 [INFO]: Number of messages in the queue: 3 2025-08-07 20:50:02 [INFO]: item found in queue is if condition 14409 2025-08-07 20:50:02 [INFO]: item found in queue is 14409 2025-08-07 20:50:02 [INFO]: Message deleted from the queue for receipt handle: AQEB8f+LCvGJFmU3Uiy294nKXmTYYlElVK/4ilTzFzodSvqsyl/TD1gcxiir1ZWoPYcVnKtnde+0lEmdcc149+X5WgkAFbpW+1UsKJvQdXJoWcjnO8fWkJT5cACJNjedpeq3eQfUJiG71fQBbGtV71q90IsZtRgYfTlVssJ5dXeYZrIGiWkhCzLfC2pGrDQwS6nUmjgRAazjejLxmKOjW8l9lH2qoKn+9TaZAzu9FfLTrDrscKwYpzsdT1/338FfGi5LR1jgFm7nkO9sqZFXdcWLtGE4Ip8VdWwweTidF/QPAQLwul6OjeKsWL0QDgp+OM7Lna1H+bdQKWrF3jL3sAGlPize46tpuZDPd0LR+4S1QlLUH+1u/QZgi7IrXND150h24YFyHnHimVkmHCfApc8r+g4tPEMEAgZqvroJQtBneXWbOjPL2+MZBPGN/7N2YcuM 2025-08-07 20:50:03 [INFO]: item found in queue is if condition 14409 2025-08-07 20:50:03 [INFO]: item found in queue is 14409 2025-08-07 20:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBH32dghpF2XyP0XSFcxZpvN0Cp7YH0oJoqyEuM2LMoBGci9IEQlloGZ9d4vi+2JM/AxVXmegiy9DHHZJJYLeL+A+0Plu5QMLzgT347bGuXgdBDPXh0JRIL5zz1KwezBnsJ4UOKJK/bBLtnv16EKt4Rj1uMn8EDmJoxHJRv6IXTxyS7k1psVQ+iZ7rz+1k+ylq6/wUBr3XtB2gLxPxVaZwcaWKR/zNgeJc6SgyksmkVbaHYuYlV0YW6z3WUO25CWlwOxsjWO+OV6bafO180M/m5vRBKB18UtdOQ5ZiceYCJEx5Ttm6CUTr6VXteVcRhprN6J62yEI0PAiDKZPHWxDMmibbZG7y1tMSchcOxc2Y0t/4evDn7KMYQMUzhQSrVVM5xNeK/9NcjnZM4CH0O5scPZqtYPrJIPknFVD9lxeuH8RcitQbWFSgngBOBWOrXwC0 2025-08-07 20:50:03 [INFO]: item found in queue is if condition 14409 2025-08-07 20:50:03 [INFO]: item found in queue is 14409 2025-08-07 20:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBHsAR53pSV3ETkkP3uab2DcKSu+g8Z6Wiglys1/cKb+L6yo7kL9vF4Gaejcq+y3LklKq0sxC9l7GhkAzREUVcjewjqThDvYSi8USk/Dd2z7laiTAEIiL56RfX9StEKoHm+XP/TPWCRj82A7JEFaRe+WWFp8EuSg1A13Im1QmC9y7lerg+19c/Ja4qFPC769SEh2KpjC7CkyofkYhHXE+L2prHJ6ZbVEmwj13oZXI7rTm0tXb4lq5MWscF8n7gSO334Oi7WQtwLFcYKVAm1ZKPtMco9om3UOY6NNVh4CPl6okcHE5sERB/cK4olQ7LeN8MNhs/h5Sif1AR0gMWV+x4vV90mYOxVDhSapvXQrwCXX4wl4Rv1k49mC3gOTapOvFI6fuzK6HcpW6XZyGX7wlrf8vUMsAhE2Oz6gQ0KXSw1a5dayLgI4j5Z2mfOYusN63P 2025-08-07 20:50:03 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-07 20:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 20:50:03 [INFO]: inside itemsold and closed 14409 2025-08-07 20:50:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 20:50:06 [INFO]: autolink for user_id 14409 is 1 2025-08-07 20:50:06 [INFO]: Ebay item id :: 257030874874 exists in Database 2025-08-07 20:50:06 [INFO]: Item is reliested :: exists in Database 2025-08-07 20:50:06 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-07 20:50:06 [INFO]: inside itemsold and closed 14409 2025-08-07 20:50:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 20:50:08 [INFO]: autolink for user_id 14409 is 1 2025-08-07 20:50:08 [INFO]: not in db for user_id 14409 and the ebayitemid226807476171 2025-08-07 20:50:08 [INFO]: inside itemsold and closed 14409 2025-08-07 20:50:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 20:50:10 [INFO]: autolink for user_id 14409 is 1 2025-08-07 20:50:10 [INFO]: Ebay item id :: 405484025967 exists in Database 2025-08-07 20:50:10 [INFO]: Item is reliested :: exists in Database 2025-08-07 20:50:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 20:50:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 20:50:10 [INFO]: in processold action queue is array for {"45281424":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45281424","ebayitemid":"257030874874","deleted":1}},"44651802":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44651802","ebayitemid":"405484025967","shopifyproductid":"8792166727902","variants":[{"price":"59.99","quantity":0,"weight":"2","shopifyproductid":"8792166727902","shopifyvariantid":"46225223123166","shopifyinventoryid":"48325448794334","shopifylocationid":"","product_id":"44651802","variant_id":"77556991","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 20:50:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 20:50:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 20:50:11 [INFO]: productIds WHich are having null productid -> [45281424] 2025-08-07 20:50:11 [INFO]: ebayItemIds WHich are not imported-> ["257030874874"] 2025-08-07 20:50:11 [INFO]: Entered in bulkUpdateProducts function 2025-08-07 20:50:11 [INFO]: Transaction started for bulkUpdateProducts 2025-08-07 20:50:11 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45281424) 2025-08-07 20:50:11 [INFO]: Query executed successfully. Affected rows: 0 2025-08-07 20:50:11 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-07 20:50:11 [INFO]: Transaction committed successfully. 2025-08-07 20:50:11 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-07 20:50:11 [INFO]: Shopify Inventory id 48325448794334 2025-08-07 20:50:11 [INFO]: Shopify Location id 58450641063 2025-08-07 20:50:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 20:50:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T20:50:11Z","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-07 20:50:11 [INFO]: Change: available | Delta: -1 2025-08-07 20:50:11 [INFO]: Change: on_hand | Delta: -1 2025-08-07 20:50:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 20:50:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44651802 and user_id = 14409 2025-08-07 20:50:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77556991 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 20:50:11 [INFO]: updateIdsQuantity -> ["77556991"] 2025-08-07 20:50:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 20:50:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77556991 THEN 0 END, quantityflag = CASE WHEN id = 77556991 THEN 0 END WHERE user_id = 14409 AND id IN (77556991) 2025-08-07 20:50:11 [INFO]: QUANTITY Updated IDs: 77556991 2025-08-07 20:50:11 [INFO]: Successfully processed data for user 14409 2025-08-07 20:50:11 [INFO]: Execution Started 2025-08-07 20:50:11 [INFO]: Execution Finished