2025-08-13 02:00:01 [INFO]: Execution Started 2025-08-13 02:00:01 [INFO]: old server sucessfully connected 2025-08-13 02:00:01 [INFO]: sqs client sucess created 2025-08-13 02:00:07 [INFO]: Number of messages in the queue: 1 2025-08-13 02:00:09 [INFO]: item found in queue is if condition 14409 2025-08-13 02:00:09 [INFO]: item found in queue is 14409 2025-08-13 02:00:10 [INFO]: Message deleted from the queue for receipt handle: AQEBVQ6taXQcvpsr8i+XYWRpd4vJ3ZoeMC1tWXcfv2xXfy+OHG2JQObKce/4XIW+jI2ExkWlwTrJjKGqZToTz/3T0UR/zVqNQB77jEt5rv3zgG/WQ3AIRtGPNhOfYKZhU8PMEVvi+0D3F3Un2X5Z/L9iKtRgIypBDA7HCXpjk/hX1Q29le3SW/4affa10klWz/rqEoKNHCpj5hTNr5bEFckSgwM3SEE4YN8Lm0y05PXbOLDbsFjcvCR9mq38fQmyziJ1syLb8b7jwlh7q8Y5o6czDzk/yQUuqQzSBPff2xNW01R5np9WbOPhliPQvXXL/fVp9xxbVh5fy6l3KUObigeUQOINfF+rAJg/5aqz6lVimT7Y8V2HFlQN0K+o+UjOlqd0CUsRSlVuHqpfjVLWNdiAfTS57eK87oc40Hrht7HDmMHOQ75titFmfgW96E80JaQ6 2025-08-13 02:00:10 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-13 02:00:10 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 02:00:10 [INFO]: inside itemsold and closed 14409 2025-08-13 02:00:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 02:00:12 [INFO]: autolink for user_id 14409 is 1 2025-08-13 02:00:12 [INFO]: Ebay item id :: 256701852678 exists in Database 2025-08-13 02:00:12 [INFO]: Item is reliested :: exists in Database 2025-08-13 02:00:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 02:00:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 02:00:12 [INFO]: in processold action queue is array for {"44776464":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44776464","ebayitemid":"256701852678","shopifyproductid":"8435833340126","variants":[{"price":"79.99","quantity":0,"weight":"3","shopifyproductid":"8435833340126","shopifyvariantid":"45247220416734","shopifyinventoryid":"47345135648990","shopifylocationid":"","product_id":"44776464","variant_id":"77685006","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 02:00:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 02:00:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 02:00:12 [INFO]: Shopify Inventory id 47345135648990 2025-08-13 02:00:12 [INFO]: Shopify Location id 58450641063 2025-08-13 02:00:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 02:00:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T02:00:12Z","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-13 02:00:12 [INFO]: Change: available | Delta: -1 2025-08-13 02:00:12 [INFO]: Change: on_hand | Delta: -1 2025-08-13 02:00:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 02:00:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44776464 and user_id = 14409 2025-08-13 02:00:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685006 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 02:00:12 [INFO]: updateIdsQuantity -> ["77685006"] 2025-08-13 02:00:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 02:00:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77685006 THEN 0 END, quantityflag = CASE WHEN id = 77685006 THEN 0 END WHERE user_id = 14409 AND id IN (77685006) 2025-08-13 02:00:12 [INFO]: QUANTITY Updated IDs: 77685006 2025-08-13 02:00:13 [INFO]: Successfully processed data for user 14409 2025-08-13 02:00:13 [INFO]: Execution Started 2025-08-13 02:00:13 [INFO]: Execution Finished 2025-08-13 02:10:02 [INFO]: Execution Started 2025-08-13 02:10:02 [INFO]: old server sucessfully connected 2025-08-13 02:10:02 [INFO]: sqs client sucess created 2025-08-13 02:10:05 [INFO]: Number of messages in the queue: 0 2025-08-13 02:10:26 [INFO]: Execution Started 2025-08-13 02:10:26 [INFO]: Execution Finished 2025-08-13 02:20:01 [INFO]: Execution Started 2025-08-13 02:20:01 [INFO]: old server sucessfully connected 2025-08-13 02:20:01 [INFO]: sqs client sucess created 2025-08-13 02:20:03 [INFO]: Number of messages in the queue: 1 2025-08-13 02:20:04 [INFO]: item found in queue is if condition 14409 2025-08-13 02:20:04 [INFO]: item found in queue is 14409 2025-08-13 02:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBw003JRUx0TIDewQ+QrR+1feSYvRAtr6l03UNMz0Xdke3fRYBdF75ZhVzGbMB008ZfrRXex0PS4iLzTC/Qw6v65QDw174xLB9jI51GSqEN/YOAXEotC+WaxhO2gcNzzV3lxzBCz5Kc8isTFWvIp3/fNcB29N60Q9CJtRTPHm2qbVOkAhrI/jXFdylT9QMXXpDcu+/Fgbtv8DpjLE0+1f6Zd9VNHN9s154a5LCJLs4xfNkNsbeEXuf1aadAP7lMmRhv3Yo+Ir4T15XjtUgb65aR0ylj7IQLlMKgvpGin7fzD0OS4rzCbPUw6Mlq/c852DfLnPu/1jCvTYHb5fl7iEpLwSe0+3IZO7vXaplMQq0B+ejp3DXKxwLiB/i1uU33v4dOWk3ghgaHAO3dIZ50+1LnMXhOMHE1BtY5Ey9qM6ScOmKGo7qQMxH+84AXEwH/bSI 2025-08-13 02:20:05 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-13 02:20:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 02:20:05 [INFO]: inside itemsold and closed 14409 2025-08-13 02:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 02:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-13 02:20:07 [INFO]: Ebay item id :: 335855462848 exists in Database 2025-08-13 02:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-13 02:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 02:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 02:20:07 [INFO]: in processold action queue is array for {"44567057":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44567057","ebayitemid":"335855462848","shopifyproductid":"8839650935006","variants":[{"price":"350.99","quantity":0,"weight":"15","shopifyproductid":"8839650935006","shopifyvariantid":"46357218033886","shopifyinventoryid":"48458982686942","shopifylocationid":"","product_id":"44567057","variant_id":"77459737","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 02:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 02:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 02:20:07 [INFO]: Shopify Inventory id 48458982686942 2025-08-13 02:20:07 [INFO]: Shopify Location id 58450641063 2025-08-13 02:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 02:20:07 [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-13 02:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 02:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44567057 and user_id = 14409 2025-08-13 02:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77459737 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 02:20:07 [INFO]: updateIdsQuantity -> ["77459737"] 2025-08-13 02:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 02:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77459737 THEN 0 END, quantityflag = CASE WHEN id = 77459737 THEN 0 END WHERE user_id = 14409 AND id IN (77459737) 2025-08-13 02:20:07 [INFO]: QUANTITY Updated IDs: 77459737 2025-08-13 02:20:07 [INFO]: Successfully processed data for user 14409 2025-08-13 02:20:07 [INFO]: Execution Started 2025-08-13 02:20:07 [INFO]: Execution Finished 2025-08-13 02:30:01 [INFO]: Execution Started 2025-08-13 02:30:01 [INFO]: old server sucessfully connected 2025-08-13 02:30:01 [INFO]: sqs client sucess created 2025-08-13 02:30:03 [INFO]: Number of messages in the queue: 1 2025-08-13 02:30:04 [INFO]: item found in queue is if condition 14409 2025-08-13 02:30:04 [INFO]: item found in queue is 14409 2025-08-13 02:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBUkIaHxjqbiTrLTdkDSt7w9+6Ob6hhEHi5VAsTMUE9rnmAsQEM6Bvvnx5AI+VY4SWp3pLSzOmCeQBP3kS6Sdd6a59UlOCv7kv+aM4rUrcA/kKGnRF6W1tfNLdiIuutxV4VXNvjtsevvJcssPXkQma7+HcBsXlJugDr74uQHzrITQl0NEDLiK8OOQuyu7irleOmAFfIKZDi4totvGfCwLmVu+KcO6NRnpApzPmZbza8B7gwtZqDgFX571tjx/hJ5dIxKwnfQfR3TtlXUL6xFEVicFajjVm31+48aNPiqsChBhJahoDLy0TgOPGmqq1qLaee2p6Jk50WzmGqIa/eors+ls9MPddDu8f4sVIegnPsrv0qImsxfIN7u/E9NwHSdhSsK13GLrCUnRtBJ7Vv2+7D8FpQWi7nF7WfkaC90UPnN7uAlBMs9AjmHflLgFem3cb 2025-08-13 02:30:05 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-13 02:30:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 02:30:05 [INFO]: inside itemsold and closed 14409 2025-08-13 02:30:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 02:30:06 [INFO]: autolink for user_id 14409 is 1 2025-08-13 02:30:06 [INFO]: Ebay item id :: 257061891606 exists in Database 2025-08-13 02:30:06 [INFO]: Item is reliested :: exists in Database 2025-08-13 02:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 02:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 02:30:06 [INFO]: in processold action queue is array for {"45314105":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45314105","ebayitemid":"257061891606","shopifyproductid":"8985420464350","variants":[{"price":"10.99","quantity":0,"weight":"0.5","shopifyproductid":"8985420464350","shopifyvariantid":"47439838970078","shopifyinventoryid":"49551696756958","shopifylocationid":"58450641063","product_id":"45314105","variant_id":"78266618","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 02:30:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 02:30:06 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 02:30:06 [INFO]: Shopify Inventory id 49551696756958 2025-08-13 02:30:06 [INFO]: Shopify Location id 58450641063 2025-08-13 02:30:06 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 02:30:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T02:30:06Z","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-13 02:30:06 [INFO]: Change: available | Delta: -1 2025-08-13 02:30:06 [INFO]: Change: on_hand | Delta: -1 2025-08-13 02:30:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 02:30:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45314105 and user_id = 14409 2025-08-13 02:30:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266618 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 02:30:06 [INFO]: updateIdsQuantity -> ["78266618"] 2025-08-13 02:30:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 02:30:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78266618 THEN 0 END, quantityflag = CASE WHEN id = 78266618 THEN 0 END WHERE user_id = 14409 AND id IN (78266618) 2025-08-13 02:30:06 [INFO]: QUANTITY Updated IDs: 78266618 2025-08-13 02:30:07 [INFO]: Successfully processed data for user 14409 2025-08-13 02:30:07 [INFO]: Execution Started 2025-08-13 02:30:07 [INFO]: Execution Finished 2025-08-13 02:40:02 [INFO]: Execution Started 2025-08-13 02:40:02 [INFO]: old server sucessfully connected 2025-08-13 02:40:02 [INFO]: sqs client sucess created 2025-08-13 02:40:04 [INFO]: Number of messages in the queue: 3 2025-08-13 02:40:05 [INFO]: item found in queue is if condition 14409 2025-08-13 02:40:05 [INFO]: item found in queue is 14409 2025-08-13 02:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEBBKZCOMk0pRtyxB7fFxJR0Bf9OeMM91kU5ylg1R4zhjeciK9h96e+5oWm2vaLRD87NNtDvlxwwNtxomjy63bU9i6dzzFz//gDUNohhbe1bL8zonLwoQp86ovjWQz6PzZzKfzzSUaFv6AjmgNI7LTyRNoxso6XQfK/2h/DQoTzHrV3AYKa609SSmTJXTMooM0L375GzRSxxFOy96LX02ZbCIFv+xZq+wkjYQgIkzTuaoimMlRRPedCtHV4jZkFGC4vjY2mYUrSrT9Klft5PPxWtINhA/0SlCkj2zai0IpmfS7TM2mX11/tUHWCSArPLRQTjXdm/gq4RrDOJsbQxygd6OGLecouIyn/USuCREco3Vd258hEdaw0Kli0uxBGZbsoo0iYjngBBpnIH7Mohofo0N4BTHMxqKQCq7q8DNGGd54ziwIyuJ0HFoaWNoz5lrr0 2025-08-13 02:40:08 [INFO]: item found in queue is if condition 14409 2025-08-13 02:40:08 [INFO]: item found in queue is 14409 2025-08-13 02:40:09 [INFO]: Message deleted from the queue for receipt handle: AQEBEeMwWBoPVqvSl596w6lvFvDEp8tdgiRPD+MBEt0EiBjfaYfQJtj88+UCC0YJXYmKLjx9pDWBtZP8c0nCYbi6jWDs20UcF4I2jaAyckClW0nzwVppwf1wNTYGxvo+rS+d4aphGBxHKgsb8NY/vyUiwCyJXFoOTSz9TMymMt/p0GdbkKDxNTjxmSacbgfbcayH33yqaDqcFFiRmfYtpEVLj6hLA2/Ul94Fe1gOtBrv3S/IMwr2N/U90ZkUoiGEYWskOFlStZJ56ooJotzSbUipEqwFPUbshz3BeGXORl2aYBPYDk8vNvmIrtv/qjytUoYTmhErOBtXaZ+WsnAG+aXVJ+jkvSIl+CqDnd0QcY4FqfK4GnxYoaCRv37yeu5AnDlS7db7LZXvh3eEcn47P01YmdTokrluQ47XjaOQm5AYkL1PLLPhfGKm/BePbnJ3m9yQ 2025-08-13 02:40:09 [INFO]: item found in queue is if condition 14409 2025-08-13 02:40:09 [INFO]: item found in queue is 14409 2025-08-13 02:40:09 [INFO]: Message deleted from the queue for receipt handle: AQEBy9iqrHy4qxUKocShm7F5XgkSN7WXQZ4wnHEDWO8Pcwb0THh9YIMUmuKZEfeFQPkg0Z1cWLzqVcL7FkSsBxkWgOAPxrpdrfRpf958d9qGoC1drAQebOw9zhURFyAjHkj8D50Dzgla7c4GQpFKs47VyUSUusNW4jhriAAq7keWz23Fzg3EEx18N6AUvPkguQXHJBkzG3+XKROdCb+0ATunWP1ZBMuBEAHV4vcxuyTebT8kjphcC6bRAdjdf44TvhOyGcyY4cIyfh6l3yzrrw6v5rwVYXjkWWj+vl8tRsIDpPmjA5qNlqMf1Xe/FM8Hj50oXlpDa7RMCH17KP3em3/WVBt97juSoD3Eb3ahPHDm0dsLMx/fMSeXgm/39junJHnR4Ewpc6Alf5vBUS77EeX0EJP7KGczwufvn55znx/uYaO7KAnJRo5pDR0IwopCviGm 2025-08-13 02:40:09 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-13 02:40:09 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 02:40:09 [INFO]: inside itemsold and closed 14409 2025-08-13 02:40:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 02:40:11 [INFO]: autolink for user_id 14409 is 1 2025-08-13 02:40:11 [INFO]: Ebay item id :: 257030625307 exists in Database 2025-08-13 02:40:11 [INFO]: Item is reliested :: exists in Database 2025-08-13 02:40:11 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-13 02:40:11 [INFO]: inside itemsold and closed 14409 2025-08-13 02:40:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 02:40:13 [INFO]: autolink for user_id 14409 is 1 2025-08-13 02:40:13 [INFO]: Ebay item id :: 286289087012 exists in Database 2025-08-13 02:40:13 [INFO]: Item is reliested :: exists in Database 2025-08-13 02:40:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 02:40:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 02:40:13 [INFO]: inside itemsold and closed 14409 2025-08-13 02:40:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 02:40:14 [INFO]: autolink for user_id 14409 is 1 2025-08-13 02:40:14 [INFO]: Ebay item id :: 226725863349 exists in Database 2025-08-13 02:40:14 [INFO]: Item is reliested :: exists in Database 2025-08-13 02:40:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 02:40:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 02:40:14 [INFO]: in processold action queue is array for {"45280729":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45280729","ebayitemid":"257030625307","deleted":1}},"44594963":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44594963","ebayitemid":"286289087012","shopifyproductid":"8801640775902","variants":[{"price":"300.00","quantity":0,"weight":"10","shopifyproductid":"8801640775902","shopifyvariantid":"46251100963038","shopifyinventoryid":"48351706185950","shopifylocationid":"","product_id":"44594963","variant_id":"77487672","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44684908":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44684908","ebayitemid":"226725863349","shopifyproductid":"8923157364958","variants":[{"price":"14.99","quantity":0,"weight":"2","shopifyproductid":"8923157364958","shopifyvariantid":"46827936383198","shopifyinventoryid":"48926398415070","shopifylocationid":"58450641063","product_id":"44684908","variant_id":"77590133","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 02:40:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 02:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 02:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 02:40:14 [INFO]: productIds WHich are having null productid -> [45280729] 2025-08-13 02:40:14 [INFO]: ebayItemIds WHich are not imported-> ["257030625307"] 2025-08-13 02:40:14 [INFO]: Entered in bulkUpdateProducts function 2025-08-13 02:40:14 [INFO]: Transaction started for bulkUpdateProducts 2025-08-13 02:40:14 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45280729) 2025-08-13 02:40:14 [INFO]: Query executed successfully. Affected rows: 0 2025-08-13 02:40:14 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-13 02:40:14 [INFO]: Transaction committed successfully. 2025-08-13 02:40:14 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-13 02:40:14 [INFO]: Shopify Inventory id 48351706185950 2025-08-13 02:40:14 [INFO]: Shopify Location id 58450641063 2025-08-13 02:40:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 02:40:15 [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-13 02:40:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 02:40:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44594963 and user_id = 14409 2025-08-13 02:40:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77487672 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 02:40:15 [INFO]: Shopify Inventory id 48926398415070 2025-08-13 02:40:15 [INFO]: Shopify Location id 58450641063 2025-08-13 02:40:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 02:40:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T02:40:15Z","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-13 02:40:15 [INFO]: Change: available | Delta: -1 2025-08-13 02:40:15 [INFO]: Change: on_hand | Delta: -1 2025-08-13 02:40:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 02:40:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44684908 and user_id = 14409 2025-08-13 02:40:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77590133 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 02:40:15 [INFO]: updateIdsQuantity -> ["77487672","77590133"] 2025-08-13 02:40:15 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-13 02:40:15 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77487672 THEN 0 WHEN id = 77590133 THEN 0 END, quantityflag = CASE WHEN id = 77487672 THEN 0 WHEN id = 77590133 THEN 0 END WHERE user_id = 14409 AND id IN (77487672,77590133) 2025-08-13 02:40:15 [INFO]: QUANTITY Updated IDs: 77487672, 77590133 2025-08-13 02:40:15 [INFO]: Successfully processed data for user 14409 2025-08-13 02:40:15 [INFO]: Execution Started 2025-08-13 02:40:15 [INFO]: Execution Finished 2025-08-13 02:50:02 [INFO]: Execution Started 2025-08-13 02:50:02 [INFO]: old server sucessfully connected 2025-08-13 02:50:02 [INFO]: sqs client sucess created 2025-08-13 02:50:04 [INFO]: Number of messages in the queue: 0 2025-08-13 02:50:25 [INFO]: Execution Started 2025-08-13 02:50:25 [INFO]: Execution Finished