2025-08-12 18:00:01 [INFO]: Execution Started 2025-08-12 18:00:01 [INFO]: old server sucessfully connected 2025-08-12 18:00:01 [INFO]: sqs client sucess created 2025-08-12 18:00:03 [INFO]: Number of messages in the queue: 1 2025-08-12 18:00:04 [INFO]: item found in queue is if condition 14409 2025-08-12 18:00:04 [INFO]: item found in queue is 14409 2025-08-12 18:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBB64mlnLQ4t1byHzsJovQkvvlSBTSuXN2Nga7GXhNKc2WaKJcN11t++wuSlTW3aDAUJotM2ZDqks6Z5bXo5gbHMivj/1oF5O65Di08FCk64DJUV/khwUCgczi86SlpV4jAb9xAByhs76bfjSVzQhHHIQmGfYBHr01aDz9PfqHwtuwVmsDcjC5Qq4YsQqVVKDmT31LA0Lqpkf7KZWmfZ1jzYrHmwNKkoYbvIGavbDwSFx915DuOmVnig+2Q3sF12hyGk1akBn44gDMC1y0I6ZM0CPsQuOOnhRUlcD6QIZKPLcdTO0l5mSID3OORcmIXDYVpAorJ3bOYCtf1CHK1fUu+rE9ftJoZ/OMRnJ/MzbUNCchx9uow8s2MAGBs7LFwncGlRlAUHqVzwe1B27taJVUlJ9UAy8SOEbh7AzRQnUnK/oY9Rgush6YXlvPeapVJUQn 2025-08-12 18:00:05 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-12 18:00:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 18:00:05 [INFO]: inside itemsold and closed 14409 2025-08-12 18:00:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 18:00:07 [INFO]: autolink for user_id 14409 is 1 2025-08-12 18:00:07 [INFO]: Ebay item id :: 286760649359 exists in Database 2025-08-12 18:00:07 [INFO]: Item is reliested :: exists in Database 2025-08-12 18:00:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 18:00:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 18:00:07 [INFO]: in processold action queue is array for {"45314037":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45314037","ebayitemid":"286760649359","shopifyproductid":"8984862327006","variants":[{"price":"289.99","quantity":0,"weight":"18","shopifyproductid":"8984862327006","shopifyvariantid":"47438277116126","shopifyinventoryid":"49550142963934","shopifylocationid":"58450641063","product_id":"45314037","variant_id":"78266550","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 18:00:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 18:00:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 18:00:07 [INFO]: Shopify Inventory id 49550142963934 2025-08-12 18:00:07 [INFO]: Shopify Location id 58450641063 2025-08-12 18:00:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 18:00:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T18:00:07Z","reason":"correction","changes":[{"name":"available","delta":-3},{"name":"on_hand","delta":-3}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-12 18:00:07 [INFO]: Change: available | Delta: -3 2025-08-12 18:00:07 [INFO]: Change: on_hand | Delta: -3 2025-08-12 18:00:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 18:00:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45314037 and user_id = 14409 2025-08-12 18:00:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266550 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 18:00:07 [INFO]: updateIdsQuantity -> ["78266550"] 2025-08-12 18:00:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-12 18:00:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78266550 THEN 0 END, quantityflag = CASE WHEN id = 78266550 THEN 0 END WHERE user_id = 14409 AND id IN (78266550) 2025-08-12 18:00:07 [INFO]: QUANTITY Updated IDs: 78266550 2025-08-12 18:00:07 [INFO]: Successfully processed data for user 14409 2025-08-12 18:00:07 [INFO]: Execution Started 2025-08-12 18:00:07 [INFO]: Execution Finished 2025-08-12 18:10:01 [INFO]: Execution Started 2025-08-12 18:10:01 [INFO]: old server sucessfully connected 2025-08-12 18:10:01 [INFO]: sqs client sucess created 2025-08-12 18:10:03 [INFO]: Number of messages in the queue: 2 2025-08-12 18:10:03 [INFO]: item found in queue is if condition 14409 2025-08-12 18:10:03 [INFO]: item found in queue is 14409 2025-08-12 18:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEB+UfF9bJpjbY5gbZteE6rwJkL9RY1BS2vQv+YcPaslxAM5t7+tJuNcwHJgaHEVlmwlvHh1yWBzkuixQLWe4EhKNczqgabgR7/CxrFtF+HuMgSBcTXGnk1l1wAztH/r33JLnLL8l01Lq/Tr2hX2AkuAFF24T9d9ATC48GolXQpbUAgpHWyppQSx7SUGFkCSpkh76Pz5Hc0a1PoJ0qeK8gRaTN7X8z7aOtP39h10WFck+h043kh4OP++AvBrJkDIb9WT2RP0d+NvT43YrVXGiH/te80vhiGS8hqzeVB7u9ZWcTjR4rL2GdL8ibCGPxO6mGxmlPxBRj95gnr5MZiun60Ty8y3wipC9jJXbFqSgbSQo/nho1Jkv1j2Wb4zZlRsxuo77oMWKoUkEEs4bh1drodl3DP/Q5EX/ZT73JqmUGv2d1zmDAVgCvQ2tr/6WdQNSrU 2025-08-12 18:10:03 [INFO]: item found in queue is if condition 14409 2025-08-12 18:10:03 [INFO]: item found in queue is 14409 2025-08-12 18:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBM5ohOrwakES6j1AHvztQZC6g3g4mj1RHLqCQGvkaPfNzYXhIsqMR/tLHnGx48EmbKvcuInetLzbyfBSb+6Eq2lnAAipDyheiaSsafDmp0pZeAOvcXOzlFcT7eqwZGBoRgdvWEMMhs0sXw018Oi9bdgyuYUg+fbGqRIeS4G7r+SqiD6YMuJTD058wEfiHbeP+MMjVXGaCoAw7MzBbJBz2jxIkGVVJF2vlS3LXdh1hrG4QRbsyUPwECU//pI2AtY+P37qKmdhE75keoakMjR08bhH3/puWc1sqJHf7PgWw2qRNC6HUpvko5Py/i5SMVJtn6DgU5YLmxzButdjlxtxSBZIYEJLwKdu3c8DtD7jXV9OWo7TbJ3xjXpVr/H8v6T24EVSQjOQU2uQM+enh0SRftw3FCEVXV0TqWnLUAMCBXc3iCNcaw/UH2Vrl+kxk61CR 2025-08-12 18:10:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-12 18:10:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 18:10:04 [INFO]: inside itemsold and closed 14409 2025-08-12 18:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 18:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-12 18:10:05 [INFO]: Ebay item id :: 286197559319 exists in Database 2025-08-12 18:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-12 18:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 18:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 18:10:05 [INFO]: inside itemsold and closed 14409 2025-08-12 18:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 18:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-12 18:10:07 [INFO]: not in db for user_id 14409 and the ebayitemid286736969460 2025-08-12 18:10:07 [INFO]: in processold action queue is array for {"44556198":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44556198","ebayitemid":"286197559319","shopifyproductid":"7818465116382","variants":[{"price":"149.99","quantity":0,"weight":"2","shopifyproductid":"7818465116382","shopifyvariantid":"43466665984222","shopifyinventoryid":"45562111852766","shopifylocationid":"","product_id":"44556198","variant_id":"77448878","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 18:10:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 18:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 18:10:07 [INFO]: Shopify Inventory id 45562111852766 2025-08-12 18:10:07 [INFO]: Shopify Location id 58450641063 2025-08-12 18:10:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 18:10:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T18:10: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-12 18:10:07 [INFO]: Change: available | Delta: -1 2025-08-12 18:10:07 [INFO]: Change: on_hand | Delta: -1 2025-08-12 18:10:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 18:10:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44556198 and user_id = 14409 2025-08-12 18:10:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77448878 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 18:10:07 [INFO]: updateIdsQuantity -> ["77448878"] 2025-08-12 18:10:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-12 18:10:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77448878 THEN 0 END, quantityflag = CASE WHEN id = 77448878 THEN 0 END WHERE user_id = 14409 AND id IN (77448878) 2025-08-12 18:10:07 [INFO]: QUANTITY Updated IDs: 77448878 2025-08-12 18:10:07 [INFO]: Successfully processed data for user 14409 2025-08-12 18:10:07 [INFO]: Execution Started 2025-08-12 18:10:07 [INFO]: Execution Finished 2025-08-12 18:20:01 [INFO]: Execution Started 2025-08-12 18:20:01 [INFO]: old server sucessfully connected 2025-08-12 18:20:01 [INFO]: sqs client sucess created 2025-08-12 18:20:03 [INFO]: Number of messages in the queue: 3 2025-08-12 18:20:03 [INFO]: item found in queue is if condition 14409 2025-08-12 18:20:03 [INFO]: item found in queue is 14409 2025-08-12 18:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBFQOSF41wf9g2PXOKKFI1yjMt5MkxyxogFD7QTwigGerm0e4hDsnXSn1o4Bz67hDbnO/iN0HaoU4iL90/ZGtEJcpTn0g5nzYkCJ8vL+XaWFRGSLVkLR7V9BZsZjiIBB/tBN2JtqvBlRwzDDdH5LD3UdiQ6dPoMYjSTjs6U0w6y9L6z10G2aUV3VaDCkxIyTk3HjSHvlFUKGK+fbsmjUJoezTzIFuXaQ4bL4MPKBxcmwDKPVjs2icHdNG8GXTKU8wAgEKrC1LDuu/r8LK9LPp0fyHDh9H104eHIhvIMQc+rUW2rVZ5kW5vXFGQW3b+p5SnW9KCxlM3vPi15dimIeIftlER2xW+S0uc5jFOI5xmOum/lKHHzrTJAiz1P024l13U99mYLWXncoFz9J6qwwScT4ZLpkDUwU5J4JWg7NW6V1svp9KUmCnL5dHYr68YZCzK 2025-08-12 18:20:04 [INFO]: item found in queue is if condition 14409 2025-08-12 18:20:04 [INFO]: item found in queue is 14409 2025-08-12 18:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBvF+V9EzFM1CSRMnLprlKNbXh7k331mC8QW2JjXA7gfKwFRLB89Oyae+e6oGnLL4xo4zC2UsyGhe5u7l9belt23ex57m46osuDN7asGDx90EKTqUrbZGrOUMOVB+HVpZiUVXJJusaQQZt4fw7FMGG4sjKRe4KuhSXDBScpNgpsBNULgVhxvwf4fTHOENd6VBBKbxnsIOghGGOd7Kk0zX8htBvIrgoALSaLWcaWUczz5CRZjJJWhxXXN1w/7KDqGIqxyQMdRikHKvyARsWsdkn27UnSMQ3xPWViubE/WqHIl7errOanpoAygTBI+pujrgunfM7+UM3elRbxyPl7qLEYkp4d8W7P1DlzN1dSltKYdyjmiU+pcUiyrQ1XmOSyfbdCQvy4grVkqjryYb3JzM6SdlPGFW3tpF38LSeCL+LcG/4v/9A3gVMQ1WIvdlzmfIt 2025-08-12 18:20:04 [INFO]: item found in queue is if condition 14409 2025-08-12 18:20:04 [INFO]: item found in queue is 14409 2025-08-12 18:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEB06E22FFAw9s/HJz/Wwidk2yL8VoqSN1vb6g3lYWUnIIb+cy+mHwMQnL6G+0og2lYtulgbeYw4OpMC0YxMckdiRZF3J8nRRqzuoHwv9vBqinTdVDIFf7obtc2Eh2d5pY3quGqQdMRGp78qhOnvQbX7HQybbFRy40kF1IRHnWkCITK5rGxVa3VhM179DtxXKrrdl6xFAI8tU9I8byElpj3W4Tc1swyctNmg6WpXBDRUpJPHVoSIJ8b0Jtgk6Zsvqu71um5hn9xNSpq1+yY6xp/pnwmkodOatU0SNFIKB25aOD4F1hDWsKiiuKTdRv4+HFnZnkv3r45AqVl4oVAP8JHmA890Ut7aB+wAzg8xcKZ8PxHiPZoKmdvQ6unaa6vbuFEK0218zorVAbRU6AJiJ+rEGsCuMACOjzPwojFs2s/cZ4fImr/msqStnWjYKhCsPbk 2025-08-12 18:20:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-12 18:20:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 18:20:04 [INFO]: inside itemsold and closed 14409 2025-08-12 18:20:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 18:20:06 [INFO]: autolink for user_id 14409 is 1 2025-08-12 18:20:06 [INFO]: Ebay item id :: 286735185147 exists in Database 2025-08-12 18:20:06 [INFO]: Item is reliested :: exists in Database 2025-08-12 18:20:06 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-12 18:20:06 [INFO]: inside itemsold and closed 14409 2025-08-12 18:20:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 18:20:08 [INFO]: autolink for user_id 14409 is 1 2025-08-12 18:20:08 [INFO]: Ebay item id :: 326429740949 exists in Database 2025-08-12 18:20:08 [INFO]: Item is reliested :: exists in Database 2025-08-12 18:20:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 18:20:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 18:20:08 [INFO]: inside itemsold and closed 14409 2025-08-12 18:20:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 18:20:10 [INFO]: autolink for user_id 14409 is 1 2025-08-12 18:20:10 [INFO]: Ebay item id :: 256931646148 exists in Database 2025-08-12 18:20:10 [INFO]: Item is reliested :: exists in Database 2025-08-12 18:20:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 18:20:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 18:20:10 [INFO]: in processold action queue is array for {"45308852":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45308852","ebayitemid":"286735185147","deleted":1}},"44736812":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44736812","ebayitemid":"326429740949","shopifyproductid":"8811471601886","variants":[{"price":"199.99","quantity":0,"weight":"3","shopifyproductid":"8811471601886","shopifyvariantid":"46274707849438","shopifyinventoryid":"48375488970974","shopifylocationid":"","product_id":"44736812","variant_id":"77644749","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44989657":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44989657","ebayitemid":"256931646148","shopifyproductid":"8938588897502","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8938588897502","shopifyvariantid":"46995053412574","shopifyinventoryid":"49106446155998","shopifylocationid":"58450641063","product_id":"44989657","variant_id":"77910631","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 18:20:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 18:20:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 18:20:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 18:20:10 [INFO]: productIds WHich are having null productid -> [45308852] 2025-08-12 18:20:10 [INFO]: ebayItemIds WHich are not imported-> ["286735185147"] 2025-08-12 18:20:10 [INFO]: Entered in bulkUpdateProducts function 2025-08-12 18:20:10 [INFO]: Transaction started for bulkUpdateProducts 2025-08-12 18:20:10 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45308852) 2025-08-12 18:20:10 [INFO]: Query executed successfully. Affected rows: 0 2025-08-12 18:20:10 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-12 18:20:10 [INFO]: Transaction committed successfully. 2025-08-12 18:20:10 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-12 18:20:10 [INFO]: Shopify Inventory id 48375488970974 2025-08-12 18:20:10 [INFO]: Shopify Location id 58450641063 2025-08-12 18:20:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 18:20:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T18:20: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-12 18:20:10 [INFO]: Change: available | Delta: -1 2025-08-12 18:20:10 [INFO]: Change: on_hand | Delta: -1 2025-08-12 18:20:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 18:20:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44736812 and user_id = 14409 2025-08-12 18:20:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77644749 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 18:20:10 [INFO]: Shopify Inventory id 49106446155998 2025-08-12 18:20:10 [INFO]: Shopify Location id 58450641063 2025-08-12 18:20:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 18:20:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T18:20: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-12 18:20:10 [INFO]: Change: available | Delta: -1 2025-08-12 18:20:10 [INFO]: Change: on_hand | Delta: -1 2025-08-12 18:20:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 18:20:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44989657 and user_id = 14409 2025-08-12 18:20:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77910631 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 18:20:10 [INFO]: updateIdsQuantity -> ["77644749","77910631"] 2025-08-12 18:20:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-12 18:20:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77644749 THEN 0 WHEN id = 77910631 THEN 0 END, quantityflag = CASE WHEN id = 77644749 THEN 0 WHEN id = 77910631 THEN 0 END WHERE user_id = 14409 AND id IN (77644749,77910631) 2025-08-12 18:20:10 [INFO]: QUANTITY Updated IDs: 77644749, 77910631 2025-08-12 18:20:10 [INFO]: Successfully processed data for user 14409 2025-08-12 18:20:10 [INFO]: Execution Started 2025-08-12 18:20:10 [INFO]: Execution Finished 2025-08-12 18:30:02 [INFO]: Execution Started 2025-08-12 18:30:02 [INFO]: old server sucessfully connected 2025-08-12 18:30:02 [INFO]: sqs client sucess created 2025-08-12 18:30:03 [INFO]: Number of messages in the queue: 4 2025-08-12 18:30:04 [INFO]: item found in queue is if condition 14409 2025-08-12 18:30:04 [INFO]: item found in queue is 14409 2025-08-12 18:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBZSEm1gXsfE1Rrznut6qeRB2IuGZXGI9Zd766g49WJbuT1j+sMI4tgrx87Qp7dYXVYOaOJKm7jQjqYT7iYLG9VaLtoLlSGDmQZg1VwwGxmideW+aRCz80YdwwoJR4jeOossuDQvkrsgQutzyDmh2Zz4lwzWqHodYIaLhvQ/KVWD5lNGVhs5Wwr6xjrKNDMSdKoA953R5P6EKqfacglAm4jKx6hMnq7MduE1s1TiCG1A6eo4HjPQeOk4AHmujK+20PsY23A30ikedmIHKVKeceaq77ZeZbgbVfkOhMNdGz8+s/zI2RKAAYPIoRj4RA6QfYzVNyAU82ddBWREfv+is1GTM9argQlvPfNqxPWIe5Ek1tZdhUXiQogSZSpeIUx6CS/+1BdWizCnZ+huKcpjt2P7E+OUgK/qTL4TRtLIMnm+rtAogFi0eWIm5jHXoyoPaY 2025-08-12 18:30:04 [INFO]: item found in queue is if condition 14409 2025-08-12 18:30:04 [INFO]: item found in queue is 14409 2025-08-12 18:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEB9p5fovdDS8d5S+Ci/aL2pt1b2C+yLobdObcl/m+Jhd2dwT6/5jHjK7WBzkrfvHxFmff1GJSmUStDfJsgUrHR0Vxo0A5YucSUM3c00G2c/eXwOEBKpaqO6XC5R+2rMGRAMBvFgcI7fHAauV+81yIVJEQgo6bVw0/V2AEb4u5FgCrVkrqXNWQF1bVabrbLMr7m/XZiOBPppytfTwEWsLKGqOYlm8nu8BzzpkTNEefO3O0pa23199InaE808uaqtukeEBKcVNPIZkX5N0c5vLVqkdLnIaO3XP+0/cnzmKVHMCRHf8XD7/V9O5fU388g+b3Z6zYnGZNdpBgQudqVhwXSJE1f0gwxclHfP5sttdXOKTd2IV58EJqfDqUaArvg3DBWuY7otOwSbGm1AJeocojUx0ybVFAI8JwoKV+6gSKlrZhGjIPJDFkkFnZPX9+RlJ43 2025-08-12 18:30:05 [INFO]: item found in queue is if condition 14409 2025-08-12 18:30:05 [INFO]: item found in queue is 14409 2025-08-12 18:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEB1KQCFgKSz3pycyYPUHj4DWlPrbyFRHTir3jli5jWzcCx8Ry8yx/ck+5/OCu25eQBr2JKMsV4payhE0aWJtcIuKQS2rwVq8DZMCZgPlb5f1Dthvq8yHIMVnp8ftRmRXorvZ9rlNLW574VDCb6kixqerQSIYr1rjPNxSJNx7yPniq9KLocEurQmktpoarxAhhxDZDeg4YCMzzdwdkuwfHdC99YdKlDmAn18kAA0EAcmjvcTSkf8WDKMzyJdhU16QQllZyGMmt8CAXobVEyycFcZcmxfNN+/zVkW0iEIF0kXbRhEv5+5rk3BuGodODKpGxIrWyXImxK1VcFJ8yg15M7wJSKsizS3iP8rWDl9yP7Hm3sX0Pt+cjqYApYesJNd6VaKilCN8v0Tn9KYvFVvTpPQr9xnjWQy9ZZlGlyv24igOt4q2nwkelgDM1LYar6gOqp 2025-08-12 18:30:05 [INFO]: item found in queue is if condition 14409 2025-08-12 18:30:05 [INFO]: item found in queue is 14409 2025-08-12 18:30:06 [INFO]: Message deleted from the queue for receipt handle: AQEB5CIs5b8n/wCuhrQWLQGO4LCod91nAG6dotpRzrac2hH5w2N6iQpuMCFe3+uHdZMVJINlqQc0shq94tbvzTgfafjbV+5Seg77oo0+aDFB7iSQo31RpL+kDitz4rK8W8DruhrYb/D5flfskRZIE5KseioYsJyvvW4kOmhUII2WgLgXH3lG4F2SOrHom6osamso/gD8sB8XURIZoz+88BNcb1n6Nkm6dF2w3AqBQioqIVtoxaLaLvVaGhLFjuaBabnH5yy0XER/GOctjsJ1XP6FkOb2P0bm5w1JBWIyq0b7qg/L1IpY/Nev9U/VTW0w1N3E306e0Yll90vxvWdEv4gvXVG8YdqRVMeEbdeUq4S7pIHyfOJBCGSOWkj0iUqkzuF1ca8KqJ1pYmhfWoeXUngbgCbYfwBiuBnfEzvcOAITmeKuPUwTIyi7iNtMSNGVk91y 2025-08-12 18:30:06 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-12 18:30:06 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 18:30:06 [INFO]: inside itemsold and closed 14409 2025-08-12 18:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 18:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-12 18:30:07 [INFO]: Ebay item id :: 305686651804 exists in Database 2025-08-12 18:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-12 18:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 18:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 18:30:07 [INFO]: inside itemsold and closed 14409 2025-08-12 18:30:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 18:30:09 [INFO]: autolink for user_id 14409 is 1 2025-08-12 18:30:09 [INFO]: Ebay item id :: 335783142875 exists in Database 2025-08-12 18:30:09 [INFO]: Item is reliested :: exists in Database 2025-08-12 18:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 18:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 18:30:09 [INFO]: inside itemsold and closed 14409 2025-08-12 18:30:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 18:30:11 [INFO]: autolink for user_id 14409 is 1 2025-08-12 18:30:11 [INFO]: Ebay item id :: 326686456976 exists in Database 2025-08-12 18:30:11 [INFO]: Item is reliested :: exists in Database 2025-08-12 18:30:11 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-12 18:30:11 [INFO]: inside itemsold and closed 14409 2025-08-12 18:30:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 18:30:13 [INFO]: autolink for user_id 14409 is 1 2025-08-12 18:30:13 [INFO]: Ebay item id :: 335783142875 exists in Database 2025-08-12 18:30:13 [INFO]: Item is reliested :: exists in Database 2025-08-12 18:30:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 18:30:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 18:30:13 [INFO]: in processold action queue is array for {"44585891":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44585891","ebayitemid":"305686651804","shopifyproductid":"8694913630430","variants":[{"price":"149.99","quantity":0,"weight":"2","shopifyproductid":"8694913630430","shopifyvariantid":"45933554467038","shopifyinventoryid":"48032005652702","shopifylocationid":"","product_id":"44585891","variant_id":"77478600","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44589363":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44589363","ebayitemid":"335783142875","shopifyproductid":"8799212077278","variants":[{"price":"359.99","quantity":0,"weight":"18","shopifyproductid":"8799212077278","shopifyvariantid":"46243135029470","shopifyinventoryid":"48343609409758","shopifylocationid":"","product_id":"44589363","variant_id":"77482072","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45224710":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45224710","ebayitemid":"326686456976","deleted":1}}} 2025-08-12 18:30:13 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 18:30:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 18:30:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 18:30:13 [INFO]: productIds WHich are having null productid -> [45224710] 2025-08-12 18:30:13 [INFO]: ebayItemIds WHich are not imported-> ["326686456976"] 2025-08-12 18:30:13 [INFO]: Entered in bulkUpdateProducts function 2025-08-12 18:30:13 [INFO]: Transaction started for bulkUpdateProducts 2025-08-12 18:30:13 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45224710) 2025-08-12 18:30:13 [INFO]: Query executed successfully. Affected rows: 0 2025-08-12 18:30:13 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-12 18:30:13 [INFO]: Transaction committed successfully. 2025-08-12 18:30:13 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-12 18:30:13 [INFO]: Shopify Inventory id 48032005652702 2025-08-12 18:30:13 [INFO]: Shopify Location id 58450641063 2025-08-12 18:30:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 18:30:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T18:30:13Z","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-12 18:30:13 [INFO]: Change: available | Delta: -1 2025-08-12 18:30:13 [INFO]: Change: on_hand | Delta: -1 2025-08-12 18:30:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 18:30:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44585891 and user_id = 14409 2025-08-12 18:30:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77478600 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 18:30:13 [INFO]: Shopify Inventory id 48343609409758 2025-08-12 18:30:13 [INFO]: Shopify Location id 58450641063 2025-08-12 18:30:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 18:30:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T18:30:13Z","reason":"correction","changes":[{"name":"available","delta":-3},{"name":"on_hand","delta":-3}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-12 18:30:13 [INFO]: Change: available | Delta: -3 2025-08-12 18:30:13 [INFO]: Change: on_hand | Delta: -3 2025-08-12 18:30:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 18:30:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44589363 and user_id = 14409 2025-08-12 18:30:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77482072 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 18:30:13 [INFO]: updateIdsQuantity -> ["77478600","77482072"] 2025-08-12 18:30:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-12 18:30:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77478600 THEN 0 WHEN id = 77482072 THEN 0 END, quantityflag = CASE WHEN id = 77478600 THEN 0 WHEN id = 77482072 THEN 0 END WHERE user_id = 14409 AND id IN (77478600,77482072) 2025-08-12 18:30:13 [INFO]: QUANTITY Updated IDs: 77478600, 77482072 2025-08-12 18:30:13 [INFO]: Successfully processed data for user 14409 2025-08-12 18:30:13 [INFO]: Execution Started 2025-08-12 18:30:13 [INFO]: Execution Finished 2025-08-12 18:40:01 [INFO]: Execution Started 2025-08-12 18:40:01 [INFO]: old server sucessfully connected 2025-08-12 18:40:01 [INFO]: sqs client sucess created 2025-08-12 18:40:02 [INFO]: Number of messages in the queue: 3 2025-08-12 18:40:03 [INFO]: item found in queue is if condition 14409 2025-08-12 18:40:03 [INFO]: item found in queue is 14409 2025-08-12 18:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBEBEJ9wV1+R4KWuLqDepIBPwDiynRZcr9EJd7n6En9b6s4ikU5nKuiPhjbu+kMeyBQcp1MsL/KRILSSPRRC2IXPF3omVfGpENf6SW8L7T7xe8jznLbjqOepq0J2uAOwDXJ9WBfFFnQUvobDotK6Evz2wMyRsdLFKtpSmatxFNt+5x3ZBKAC0rrcE9ClQKWj3exYGyw6XmkCS8WXi9umgtUi8R5ZfSNfrnD0Gx04w4hJpOYym1ZGEtYSwj5gQ8EX+AccyIbOPAMK4MGRi0IsRYPCg3SM3qqESQ5TSuX1tz3cDb+DDDcFlDTWunPPMCf3Mo7FIuFmHJtQduPcpFpR505c0NDXQcCV4sCfAex6dLHizev9r6ZcVxaDbgnONLJFI0HxLdYgjvL9xJnG7mB3K2JaqyoRuQsOCvVFKRnGgUwwxnj3ser4H6NSn8li7drD8V 2025-08-12 18:40:03 [INFO]: item found in queue is if condition 14409 2025-08-12 18:40:03 [INFO]: item found in queue is 14409 2025-08-12 18:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBJ/42R1eX0Nb6tXxsilQguuTWwJdbseoVvU7n9Ct3RP9nEyjR64VES+VD5KRYv63Wl8CwqciaDfUUZrSwkMzJhayS+ilagqtbjTJ6W5qIAu6mSniAebo478RiFebLpzIqrAqPZ6oUHYwrbx+w5OzbKpSL81XXssk3B10UEpIsSxwEIHwrQsY/LJuKh1X0+63BYNx9i2rF5jK0QrVxJ1Hr/2LAYXXSile8T1uzL2cB0mDp5937i30tObj3c97p3eJxlFpV24lWR8tNLoTMaTFoLHdmPnpHRtLWrgFo/voPeS0SX7sBtNFyvOkWcaWiQKoHo4tG5J4Ksf7yGlAHqEc7e24U1ytAyIH0b0KZds7Ny0lcLpeXbpITS3T/N5NqpFoW6/I10+9Yf9e1gyjJZYdLVfsFAu1ZynEM1XUTw+3EHnweAL2hEYW68RD0F7iQpFDP 2025-08-12 18:40:04 [INFO]: item found in queue is if condition 14409 2025-08-12 18:40:04 [INFO]: item found in queue is 14409 2025-08-12 18:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBN+HZbma90v/F5vPKG8Hptem6NEvDbmpxcRoiXfuf54YUqcDqDPxpOFJSxy8JBO25CkWELVtVC+oyHp+tvfAXmwGqPZl3Z5eu968eWtSlb/+WFtMiVX1T1Z0/nAD4qy+ebF2hb5RO0moS14O0ag2RL6gDObIVIYmzMYCq5U0m1S2DLBbeXaBzbMFChQ9/SzsbJuGimZ/tOXWl0qxpeOXlvVCSB2sWoEPa8oAlOszC1kzZOBNy5v3nuvLGJmddPC3PUhhk8eeq6VB2L6o3xoO6CMUGoQ6Nup6s9PhUGPT/E6poaUCvPIRNRKiSN72AQsMqCiYntv3TLkY9hQ43k1XgZi+bhxiYAjXhkJAWfS/W5Gmgl5mBGjs6gg/BmnyB0iKnkKi9vjK9SwZHgHspB9+wvLtetk2NgzDEHwZRkCUqjG/rZiMI5SKHb8eCH5hcSum4 2025-08-12 18:40:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-12 18:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 18:40:04 [INFO]: inside itemsold and closed 14409 2025-08-12 18:40:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 18:40:06 [INFO]: autolink for user_id 14409 is 1 2025-08-12 18:40:06 [INFO]: Ebay item id :: 286030457418 exists in Database 2025-08-12 18:40:06 [INFO]: Item is reliested :: exists in Database 2025-08-12 18:40:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 18:40:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 18:40:06 [INFO]: inside itemsold and closed 14409 2025-08-12 18:40:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 18:40:08 [INFO]: autolink for user_id 14409 is 1 2025-08-12 18:40:08 [INFO]: Ebay item id :: 285657015150 exists in Database 2025-08-12 18:40:08 [INFO]: Item is reliested :: exists in Database 2025-08-12 18:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 18:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 18:40:08 [INFO]: inside itemsold and closed 14409 2025-08-12 18:40:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 18:40:09 [INFO]: autolink for user_id 14409 is 1 2025-08-12 18:40:09 [INFO]: Ebay item id :: 226534051108 exists in Database 2025-08-12 18:40:09 [INFO]: Item is reliested :: exists in Database 2025-08-12 18:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 18:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 18:40:09 [INFO]: in processold action queue is array for {"44591753":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44591753","ebayitemid":"286030457418","shopifyproductid":"8445879845086","variants":[{"price":"82.99","quantity":0,"weight":"2","shopifyproductid":"8445879845086","shopifyvariantid":"45269200601310","shopifyinventoryid":"47367119569118","shopifylocationid":"","product_id":"44591753","variant_id":"77484462","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44576138":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44576138","ebayitemid":"285657015150","shopifyproductid":"8255197216990","variants":[{"price":"149.00","quantity":0,"weight":"1","shopifyproductid":"8255197216990","shopifyvariantid":"44678310887646","shopifyinventoryid":"46776269668574","shopifylocationid":"","product_id":"44576138","variant_id":"77468845","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44736571":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44736571","ebayitemid":"226534051108","shopifyproductid":"8127636701406","variants":[{"price":"34.99","quantity":0,"weight":"2","shopifyproductid":"8127636701406","shopifyvariantid":"44345337905374","shopifyinventoryid":"46443068162270","shopifylocationid":"","product_id":"44736571","variant_id":"77644508","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 18:40:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 18:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 18:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 18:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 18:40:09 [INFO]: Shopify Inventory id 47367119569118 2025-08-12 18:40:09 [INFO]: Shopify Location id 58450641063 2025-08-12 18:40:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 18:40:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T18:40:09Z","reason":"correction","changes":[{"name":"available","delta":-4},{"name":"on_hand","delta":-4}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-12 18:40:10 [INFO]: Change: available | Delta: -4 2025-08-12 18:40:10 [INFO]: Change: on_hand | Delta: -4 2025-08-12 18:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 18:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44591753 and user_id = 14409 2025-08-12 18:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77484462 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 18:40:10 [INFO]: Shopify Inventory id 46776269668574 2025-08-12 18:40:10 [INFO]: Shopify Location id 58450641063 2025-08-12 18:40:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 18:40:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T18:40: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-12 18:40:10 [INFO]: Change: available | Delta: -1 2025-08-12 18:40:10 [INFO]: Change: on_hand | Delta: -1 2025-08-12 18:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 18:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44576138 and user_id = 14409 2025-08-12 18:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77468845 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 18:40:10 [INFO]: Shopify Inventory id 46443068162270 2025-08-12 18:40:10 [INFO]: Shopify Location id 58450641063 2025-08-12 18:40:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 18:40: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-12 18:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 18:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44736571 and user_id = 14409 2025-08-12 18:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77644508 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 18:40:10 [INFO]: updateIdsQuantity -> ["77484462","77468845","77644508"] 2025-08-12 18:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-12 18:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77484462 THEN 0 WHEN id = 77468845 THEN 0 WHEN id = 77644508 THEN 0 END, quantityflag = CASE WHEN id = 77484462 THEN 0 WHEN id = 77468845 THEN 0 WHEN id = 77644508 THEN 0 END WHERE user_id = 14409 AND id IN (77484462,77468845,77644508) 2025-08-12 18:40:10 [INFO]: QUANTITY Updated IDs: 77484462, 77468845, 77644508 2025-08-12 18:40:10 [INFO]: Successfully processed data for user 14409 2025-08-12 18:40:10 [INFO]: Execution Started 2025-08-12 18:40:10 [INFO]: Execution Finished 2025-08-12 18:50:02 [INFO]: Execution Started 2025-08-12 18:50:02 [INFO]: old server sucessfully connected 2025-08-12 18:50:02 [INFO]: sqs client sucess created 2025-08-12 18:50:03 [INFO]: Number of messages in the queue: 0 2025-08-12 18:50:23 [INFO]: Execution Started 2025-08-12 18:50:23 [INFO]: Execution Finished