2025-08-07 18:00:02 [INFO]: Execution Started 2025-08-07 18:00:02 [INFO]: old server sucessfully connected 2025-08-07 18:00:02 [INFO]: sqs client sucess created 2025-08-07 18:00:03 [INFO]: Number of messages in the queue: 0 2025-08-07 18:00:23 [INFO]: Execution Started 2025-08-07 18:00:23 [INFO]: Execution Finished 2025-08-07 18:10:01 [INFO]: Execution Started 2025-08-07 18:10:01 [INFO]: old server sucessfully connected 2025-08-07 18:10:01 [INFO]: sqs client sucess created 2025-08-07 18:10:03 [INFO]: Number of messages in the queue: 0 2025-08-07 18:10:23 [INFO]: Execution Started 2025-08-07 18:10:23 [INFO]: Execution Finished 2025-08-07 18:20:02 [INFO]: Execution Started 2025-08-07 18:20:02 [INFO]: old server sucessfully connected 2025-08-07 18:20:02 [INFO]: sqs client sucess created 2025-08-07 18:20:03 [INFO]: Number of messages in the queue: 0 2025-08-07 18:20:23 [INFO]: Execution Started 2025-08-07 18:20:23 [INFO]: Execution Finished 2025-08-07 18:30:01 [INFO]: Execution Started 2025-08-07 18:30:01 [INFO]: old server sucessfully connected 2025-08-07 18:30:01 [INFO]: sqs client sucess created 2025-08-07 18:30:03 [INFO]: Number of messages in the queue: 0 2025-08-07 18:30:23 [INFO]: Execution Started 2025-08-07 18:30:23 [INFO]: Execution Finished 2025-08-07 18:40:01 [INFO]: Execution Started 2025-08-07 18:40:01 [INFO]: old server sucessfully connected 2025-08-07 18:40:01 [INFO]: sqs client sucess created 2025-08-07 18:40:02 [INFO]: Number of messages in the queue: 1 2025-08-07 18:40:03 [INFO]: item found in queue is if condition 14409 2025-08-07 18:40:03 [INFO]: item found in queue is 14409 2025-08-07 18:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEB5M7jb30ztNA/1RFcI/5VLXhLQ9dRAzhKeDnDtIZUVHyof7A8tu+ZLdOIOQqR5u5C6McNqLgBSvDCYkt9x/PCOjLtyOtxJ/LY0MVWNg7H9C3IV1o1e/tWzryW9wQyjfhqL0MfGr+ku5J7HxNuGDF/nbMWxgQlJV60qpB3Ug+2dFmdv84S5dz2feBOeovcRPaH1NtcvQMXiB5zdmAIsFGGALambcE2qinMotY7ZT+bBcEFA9cH3IR8BtRJe8gEELRm3DdoCrh95BWniYat6ChirMdo+4BU2IGjPf+Ev6ACVDV1cXQRbEpJZg6t92rDSocMoPHiEV4Eo+QXdeVrM/aF58ih93YPg8azpHHwKGSL9q5Kw19GjpIUeLQJBAthgW77J5DfMD6gPCTYUhujTY9yNulQhn9T10eUm+XUn73wdUfK3gAK/9kYXHismmjGfQ2B 2025-08-07 18:40:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 18:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 18:40:03 [INFO]: inside itemsold and closed 14409 2025-08-07 18:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 18:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-07 18:40:05 [INFO]: Ebay item id :: 257008676142 exists in Database 2025-08-07 18:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-07 18:40:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-07 18:40:05 [INFO]: in processold action queue is array for {"45205758":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45205758","ebayitemid":"257008676142","deleted":1}}} 2025-08-07 18:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 18:40:05 [INFO]: productIds WHich are having null productid -> [45205758] 2025-08-07 18:40:05 [INFO]: ebayItemIds WHich are not imported-> ["257008676142"] 2025-08-07 18:40:05 [INFO]: Entered in bulkUpdateProducts function 2025-08-07 18:40:05 [INFO]: Transaction started for bulkUpdateProducts 2025-08-07 18:40:05 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45205758) 2025-08-07 18:40:05 [INFO]: Query executed successfully. Affected rows: 0 2025-08-07 18:40:05 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-07 18:40:05 [INFO]: Transaction committed successfully. 2025-08-07 18:40:05 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-07 18:40:05 [INFO]: Successfully processed data for user 14409 2025-08-07 18:40:05 [INFO]: Execution Started 2025-08-07 18:40:05 [INFO]: Execution Finished 2025-08-07 18:50:01 [INFO]: Execution Started 2025-08-07 18:50:01 [INFO]: old server sucessfully connected 2025-08-07 18:50:01 [INFO]: sqs client sucess created 2025-08-07 18:50:02 [INFO]: Number of messages in the queue: 3 2025-08-07 18:50:02 [INFO]: item found in queue is if condition 14409 2025-08-07 18:50:02 [INFO]: item found in queue is 14409 2025-08-07 18:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBMhcS89m94IPwCVws6cJrFHkml8pv74M2VuAxy7CAzRW5TP18JDrldrtgPnRFiV8JqhJABcRVeC/DBalrvod+weD3bA5qpmiI+tfOMidFklH9RM9cEWGILjed7wuj6z2je1yR2p+D9SBi8gyZDEekFbWSXDnWVAbmA5lPyoKe0XESfu36GfBG9OTnmIQDS+eMs8OCD9Vtf/lR9P1sSeFyGOLqyWj/jv3zCittUBMtUHIlsZP5ndHey2tVmWbhuKAWDHdKLZ+HZmf5R0I+vxXNor+U+zAncDDKSSu/g25FWxXT/0vUVivmTqVGxb5M+mdLPSqsEwaZj/gp+VT1KhriSngiFZvgpD6V2FSkNZBlDekfmaKFdwTdocX0xTRMtHGvm4JQEPkN7ufRSIBy6rGt547cAvkYwMB7a2nPpzARIs+9UO0bYQ7LXxms2BiIVH/G 2025-08-07 18:50:03 [INFO]: item found in queue is if condition 14409 2025-08-07 18:50:03 [INFO]: item found in queue is 14409 2025-08-07 18:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBzBCz7blUT+zBTKUbMtUsLK4UPqm4QvLst+bfrNqtHxBYMk1QEt2AM2caJzTvFkT1B/MQu9kHDelLI1KcwTpLcxZgGaXToCu1dM5GzHC+ew0qm8RYyWPzrcNYsJgodXxnt/+rXf6NgBG4SHwLvOHv5gcfXdQqjEfn9MW4YfzSZofXkD1qt3vUMXFM2lukAmwqiuvMfAT7cXjNd4Q1rHfBBF+kuUsGD09/mZ1ErRCimboPkPdgst7cxEl1SV26slHC4PeeJMrnBCi+LMLpE3ShWUWLSXsHMIlJQ78i/B0qewp0Vu2johnbiuStykGVbWIdCWL5HcmLz98A9IlE1GdA//S6YkmE6UEmDCdu15bHw5eMjBJjzMwXsZV514QdUd/CYEtmpnIJy+HBNqHdrVugMnRpaxN7W1UMKIX0y0WKHXr8Mcksc304YLM1/WA4y24S 2025-08-07 18:50:03 [INFO]: item found in queue is if condition 14409 2025-08-07 18:50:03 [INFO]: item found in queue is 14409 2025-08-07 18:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBVY5U5fqflL4aTCPRIIwYHOPVvnL8aPN3cUJsSUvFZYoYs38Me7wKv7vH8muFdSPRif4aJquYjPXM14WQIyLrQFV2mCFq7bxu02q5FRWmUnDGvIwWuorbEGiw9kdg5Ru67X+MQEsYeJa87YCKR/Vl/fKoezosA82yPgITBG6ro9sB4Z5QPuzlw5Ll+PzMs+I5lJ9yk6OJ55TM0IE4Nt0YEKK1iajFn+X6xm660WbQSZLmqvC33grhCdDU8kjBsaDEP6qRteZ3evrWHTNq+FPwkyaBphQrNhrrh6/C4v6rarvY0Qqni7mQkfEt27zMxbSqXQD4LmXDK4VyMIy/7ZEteDOqqDE+1KFMDo/IcLAH41HnvfxL5SLZfaB4CFcsiYMyYC3Wuc6nrzhiwj02sE3ayFHRLgY0mBVSK2OQw/2gCSbME8U8tJfZc5/FZkhebUDG 2025-08-07 18:50:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-07 18:50:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 18:50:04 [INFO]: inside itemsold and closed 14409 2025-08-07 18:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 18:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-07 18:50:05 [INFO]: Ebay item id :: 286740282695 exists in Database 2025-08-07 18:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-07 18:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 18:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 18:50:05 [INFO]: inside itemsold and closed 14409 2025-08-07 18:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 18:50:07 [INFO]: autolink for user_id 14409 is 1 2025-08-07 18:50:07 [INFO]: Ebay item id :: 335797671672 exists in Database 2025-08-07 18:50:07 [INFO]: Item is reliested :: exists in Database 2025-08-07 18:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 18:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 18:50:07 [INFO]: inside itemsold and closed 14409 2025-08-07 18:50:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 18:50:09 [INFO]: autolink for user_id 14409 is 1 2025-08-07 18:50:09 [INFO]: Ebay item id :: 326442574757 exists in Database 2025-08-07 18:50:09 [INFO]: Item is reliested :: exists in Database 2025-08-07 18:50:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 18:50:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 18:50:09 [INFO]: in processold action queue is array for {"45312854":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45312854","ebayitemid":"286740282695","shopifyproductid":"8976153018590","variants":[{"price":"69.99","quantity":0,"weight":"3","shopifyproductid":"8976153018590","shopifyvariantid":"47182381220062","shopifyinventoryid":"49294216921310","shopifylocationid":"58450641063","product_id":"45312854","variant_id":"78265367","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44557478":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44557478","ebayitemid":"335797671672","shopifyproductid":"8811485659358","variants":[{"price":"10.99","quantity":0,"weight":"2","shopifyproductid":"8811485659358","shopifyvariantid":"46274730262750","shopifyinventoryid":"48375511384286","shopifylocationid":"","product_id":"44557478","variant_id":"77450158","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44644331":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44644331","ebayitemid":"326442574757","shopifyproductid":"8817220026590","variants":[{"price":"9.99","quantity":0,"weight":"0.9375","shopifyproductid":"8817220026590","shopifyvariantid":"46289374707934","shopifyinventoryid":"48390298829022","shopifylocationid":"","product_id":"44644331","variant_id":"77549520","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 18:50:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 18:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 18:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 18:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 18:50:09 [INFO]: Shopify Inventory id 49294216921310 2025-08-07 18:50:09 [INFO]: Shopify Location id 58450641063 2025-08-07 18:50:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 18:50:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T18:50: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-07 18:50:09 [INFO]: Change: available | Delta: -1 2025-08-07 18:50:09 [INFO]: Change: on_hand | Delta: -1 2025-08-07 18:50:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 18:50:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45312854 and user_id = 14409 2025-08-07 18:50:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265367 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 18:50:09 [INFO]: Shopify Inventory id 48375511384286 2025-08-07 18:50:09 [INFO]: Shopify Location id 58450641063 2025-08-07 18:50:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 18:50:10 [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-07 18:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 18:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44557478 and user_id = 14409 2025-08-07 18:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77450158 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 18:50:10 [INFO]: Shopify Inventory id 48390298829022 2025-08-07 18:50:10 [INFO]: Shopify Location id 58450641063 2025-08-07 18:50:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 18:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T18: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-07 18:50:10 [INFO]: Change: available | Delta: -1 2025-08-07 18:50:10 [INFO]: Change: on_hand | Delta: -1 2025-08-07 18:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 18:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44644331 and user_id = 14409 2025-08-07 18:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77549520 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 18:50:10 [INFO]: updateIdsQuantity -> ["78265367","77450158","77549520"] 2025-08-07 18:50:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-07 18:50:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78265367 THEN 0 WHEN id = 77450158 THEN 0 WHEN id = 77549520 THEN 0 END, quantityflag = CASE WHEN id = 78265367 THEN 0 WHEN id = 77450158 THEN 0 WHEN id = 77549520 THEN 0 END WHERE user_id = 14409 AND id IN (78265367,77450158,77549520) 2025-08-07 18:50:10 [INFO]: QUANTITY Updated IDs: 78265367, 77450158, 77549520 2025-08-07 18:50:10 [INFO]: Successfully processed data for user 14409 2025-08-07 18:50:10 [INFO]: Execution Started 2025-08-07 18:50:10 [INFO]: Execution Finished