2025-08-05 15:00:02 [INFO]: Execution Started 2025-08-05 15:00:02 [INFO]: old server sucessfully connected 2025-08-05 15:00:02 [INFO]: sqs client sucess created 2025-08-05 15:00:05 [INFO]: Number of messages in the queue: 2 2025-08-05 15:00:05 [INFO]: item found in queue is if condition 14409 2025-08-05 15:00:05 [INFO]: item found in queue is 14409 2025-08-05 15:00:06 [INFO]: Message deleted from the queue for receipt handle: AQEBH4Twd3uUHeVfTgsG4aPe9kDUAGCrtakhVc4OjI0ZaWOBeNWxy1Aj9hQSByatr5EnSv+Nkehva02aMlbUuGcklnpccoIXXmcmUnq3nk/uxBcOXCtuYF+5PYFI47Hgir2DAaOw6wN24AomvzgjEvcDgl4lgVwMiTb8zQ2TPoFD32ahflqiroJkIprtXPPwIxiJ8Xjt61vcwpVRkYX5IxvnkBkI809MyJltO7DjjUaWedouGpNJwW1GF3q6It88vu/7AHdws8wVJzu2bf6Tb6ecxATxdFk0u49GgYSBA7s4lBQvV+1spUJpzyUwpDGJAUbT2A5l7BNjLlNWL9wFjW2smH/PAhDaWFOqL9X5474fgWfLwnoylRa+/6jIPe5OtuvdptQzXB4PPX2/xTA6rYI4datJ6WXohgJyvbqF2ZJ17wgrizpK0j8w0TOAV/B72Por 2025-08-05 15:00:06 [INFO]: item found in queue is if condition 14409 2025-08-05 15:00:06 [INFO]: item found in queue is 14409 2025-08-05 15:00:06 [INFO]: Message deleted from the queue for receipt handle: AQEBHgm6QuVuI7KZDqgra/+XWMGGbY3SUjHrbXWDdsnmYDgjJmf153CNAbJ2nyoo1uxxXY2krGAXIBwhR8kD4No2q1JNPyBvmjrvFEWEpgN/d2OUCcLY0Mga4fa6ZPPaOQfwDWsDjt+QJOPPboGVnBBrjP7pQYNeS+J/2WUV5/gyqMDv2XMiQlPNUmYJ+vYF6z87szHj6RjaoN1KZu9fTK8w9NcB3UIb+nR56Aosylwew2UHKRMaK56AkrSB4HVMY5qZgbBLBQsRytrnvl/+Pdn7fCDV7zJLaQVZga5hWs7EZnZVg8lNA2LMxhi1KubnMH1p8bEl9lW8ApCOO+eRgnoFzAyzJpeN+mSRm4no3wXlCQRMclG91fW/sQ9b1MgDLffkulaofNs0CKCvrVOPgrhJQkEA2r4SAI5WJGkeE5wXxhBzGjWPYaow+4MMikTptkpE 2025-08-05 15:00:06 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-05 15:00:06 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 15:00:06 [INFO]: inside itemsold and closed 14409 2025-08-05 15:00:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 15:00:08 [INFO]: autolink for user_id 14409 is 1 2025-08-05 15:00:08 [INFO]: Ebay item id :: 257040614405 exists in Database 2025-08-05 15:00:08 [INFO]: Item is reliested :: exists in Database 2025-08-05 15:00:08 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-05 15:00:08 [INFO]: inside itemsold and closed 14409 2025-08-05 15:00:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 15:00:10 [INFO]: autolink for user_id 14409 is 1 2025-08-05 15:00:10 [INFO]: Ebay item id :: 305375948666 exists in Database 2025-08-05 15:00:10 [INFO]: Item is reliested :: exists in Database 2025-08-05 15:00:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 15:00:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 15:00:10 [INFO]: in processold action queue is array for {"45312714":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45312714","ebayitemid":"257040614405","deleted":1}},"44596255":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44596255","ebayitemid":"305375948666","shopifyproductid":"8269392281822","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"8269392281822","shopifyvariantid":"44742026199262","shopifyinventoryid":"46840033280222","shopifylocationid":"","product_id":"44596255","variant_id":"77488964","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 15:00:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 15:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 15:00:10 [INFO]: productIds WHich are having null productid -> [45312714] 2025-08-05 15:00:10 [INFO]: ebayItemIds WHich are not imported-> ["257040614405"] 2025-08-05 15:00:10 [INFO]: Entered in bulkUpdateProducts function 2025-08-05 15:00:10 [INFO]: Transaction started for bulkUpdateProducts 2025-08-05 15:00:10 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45312714) 2025-08-05 15:00:10 [INFO]: Query executed successfully. Affected rows: 0 2025-08-05 15:00:10 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-05 15:00:10 [INFO]: Transaction committed successfully. 2025-08-05 15:00:10 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-05 15:00:10 [INFO]: Shopify Inventory id 46840033280222 2025-08-05 15:00:10 [INFO]: Shopify Location id 58450641063 2025-08-05 15:00:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 15:00:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T15:00:10Z","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-05 15:00:10 [INFO]: Change: available | Delta: -3 2025-08-05 15:00:10 [INFO]: Change: on_hand | Delta: -3 2025-08-05 15:00:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 15:00:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44596255 and user_id = 14409 2025-08-05 15:00:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77488964 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 15:00:10 [INFO]: updateIdsQuantity -> ["77488964"] 2025-08-05 15:00:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-05 15:00:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77488964 THEN 0 END, quantityflag = CASE WHEN id = 77488964 THEN 0 END WHERE user_id = 14409 AND id IN (77488964) 2025-08-05 15:00:10 [INFO]: QUANTITY Updated IDs: 77488964 2025-08-05 15:00:10 [INFO]: Successfully processed data for user 14409 2025-08-05 15:00:10 [INFO]: Execution Started 2025-08-05 15:00:10 [INFO]: Execution Finished 2025-08-05 15:10:01 [INFO]: Execution Started 2025-08-05 15:10:01 [INFO]: old server sucessfully connected 2025-08-05 15:10:01 [INFO]: sqs client sucess created 2025-08-05 15:10:03 [INFO]: Number of messages in the queue: 1 2025-08-05 15:10:03 [INFO]: item found in queue is if condition 14409 2025-08-05 15:10:03 [INFO]: item found in queue is 14409 2025-08-05 15:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBE1MVDcrmJ+0CaynA2IGtRfiyZ2S8Y71hUWmwCR4JWfsDaMMRv9NvNO0z/Q0FcuU0UDJwX+J6E9ik4nIkcERY3qbv4GVPq2ttWWzPXRKdGECPhpDrjFIH6C5pO8/uD+MSo+3A9n4tlt3ZMX+Fc0htzVT6fcp1MINHiEkEG7JuA4NsPjFOzXTicZ56L82mS1EXN97pKv920/3PlMurOsUtbMOe6rBiLpr6QKpJvyztekvZgi6uQqbM/2nePZPSeWVeCD6P4gwFNrJB8ErlJBbMdoEMvR1uZh9VkahuFAqwe7ZzmPXiNf0ku+3Pk8V/F6I5gBSHn58btqwQjGyoXbkdEzWbsN1nbbiEGG76jP0tM8qzXKol7hQ6hhrWHZ3jvWMkKQZgWU/CwU49Ed7XMKcjgqmmuFfJf4Dqkj9CfFvwCntR0FlrHKk4svumgDB5o3Sb 2025-08-05 15:10:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-05 15:10:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 15:10:04 [INFO]: inside itemsold and closed 14409 2025-08-05 15:10:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 15:10:06 [INFO]: autolink for user_id 14409 is 1 2025-08-05 15:10:06 [INFO]: Ebay item id :: 405030181440 exists in Database 2025-08-05 15:10:06 [INFO]: Item is reliested :: exists in Database 2025-08-05 15:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 15:10:06 [INFO]: in processold action queue is array for [] 2025-08-05 15:10:06 [INFO]: Successfully processed data for user 14409 2025-08-05 15:10:06 [INFO]: Execution Started 2025-08-05 15:10:06 [INFO]: Execution Finished 2025-08-05 15:20:01 [INFO]: Execution Started 2025-08-05 15:20:01 [INFO]: old server sucessfully connected 2025-08-05 15:20:01 [INFO]: sqs client sucess created 2025-08-05 15:20:09 [INFO]: Number of messages in the queue: 3 2025-08-05 15:20:09 [INFO]: item found in queue is if condition 14409 2025-08-05 15:20:09 [INFO]: item found in queue is 14409 2025-08-05 15:20:11 [INFO]: Message deleted from the queue for receipt handle: AQEBL2N20CNSFDasuqpdviREeQzmlBd+umAnTnf7hw70QEEtqZf05O/cRnMpt31GZcVJwPh6E+B+G3v7o3isDGUdnhqN5ltliqBcusESEoftgfB4kXEkP/oGuQf13aZWwW3qtFtNlakQ02A/lTUKv5C3i1k1qxX5COW80Wyar/haIKNeaTCYxe21amSI5IV0r3aiRDqQhOEl/vWl3vHv4aPpPdRIaY5tbVtqetJPpZWzEkF1Vaf9OVnscPe2hk7payDdJYJXl+3pv5Zm7eotUHwbOvqZO2PtqiFoVhHM+QeWEbfnec9Jmx6dQFdvc7Qo3FnzApfHEal0XEjsRu8e5UFY/j1JYVDPMin6rHOj7yyitrSjhB03fvwuk1YQIWhwXKrv8q+f6QHupq+eEMrK4YxuwkJssxNTXBLqsPDqMKubAqaEz81Rdz0dnuMB/3bSVAHO 2025-08-05 15:20:11 [INFO]: item found in queue is if condition 14409 2025-08-05 15:20:11 [INFO]: item found in queue is 14409 2025-08-05 15:20:13 [INFO]: Message deleted from the queue for receipt handle: AQEBcZ7FaL9bYOruwC8k8e7Q4mjygYO34IWTJoUQo6p2WX/Y1h7KBjP3beLx7ylOveQSMwcLyDt9Q3chVneePbbhtaB5yzElckI2jC7nzmaJIDMpUsXxKDhZGSCVm1lFiOaWfMBmE8UGmlnSCfxBEbS6WkqMls20Voibv9oOYid3VQbzH5Mc0c2EXX4hWNMuGQ1r0lu6eXSR15DnCJ2r1E2c8RAHr+TKL84WFhL+Qu9XdkTiSJm/qD5BvjKre3suEk8Tioxw+6MOR55zuor4NU7lo6eJW12ciIqcriazv7Kamkr4Pyjy6XlMOIENthssz2zImXpQLdH5dp3zmuw2FBH+MpBMl+FqQZ4womnf1ynfEHav/FKAEN81z63v1mp+0ecZ5ZaBlbCO8lvDnwNF6uuEB0VRX/f0gD/+SxOLh0nW49avpmBvbF6bxxE99CUuKQRG 2025-08-05 15:20:14 [INFO]: item found in queue is if condition 14409 2025-08-05 15:20:14 [INFO]: item found in queue is 14409 2025-08-05 15:20:14 [INFO]: Message deleted from the queue for receipt handle: AQEBqyL4kLx++8ESgwksLITkKqJN9ljI5FYei+LUlLjl4Z8Cb/d4Xy+5epB4efi/za9Qr+qkiQPA+0QfNWC6EOEogNugeDQwBvj1IZjXZYMX2gmJo+JmA+HNOJCPQzbfKFvfIrTUSL7BEjkAZHuLu9Qecn3tMKfvSu0VlBwsTBzl91+g4cD2/gsBWkkRR4qlu6Ica2MexRsrErFU3h4PmjcL7QYs4RxjzSfDYC4k5CPL2G2vqR5Q5iiiTmzC+ZjTJFbajAEua6b6cKR8Kb1+1/O8wDJzTsQSWSDxepyzd+VBzribRiL6FeNc6HmTPZlFefnxjdSgXuRUGZDDF0JKEvkLCrEa+8wGPCg/g105GIC3ineC3jxX4n47ehwZiP+Yf4F1mxEgUHzJW9QzFO6M5g4zjN38Rqm72C47DqZUbJO0miE7Iz99My8HtiyN5W7n6h9U 2025-08-05 15:20:14 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-05 15:20:14 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 15:20:14 [INFO]: inside itemsold and closed 14409 2025-08-05 15:20:16 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 15:20:16 [INFO]: autolink for user_id 14409 is 1 2025-08-05 15:20:16 [INFO]: Ebay item id :: 305405931466 exists in Database 2025-08-05 15:20:16 [INFO]: Item is reliested :: exists in Database 2025-08-05 15:20:16 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 15:20:16 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 15:20:16 [INFO]: inside itemsold and closed 14409 2025-08-05 15:20:18 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 15:20:18 [INFO]: autolink for user_id 14409 is 1 2025-08-05 15:20:18 [INFO]: Ebay item id :: 335245839683 exists in Database 2025-08-05 15:20:18 [INFO]: Item is reliested :: exists in Database 2025-08-05 15:20:18 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 15:20:18 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 15:20:18 [INFO]: inside itemsold and closed 14409 2025-08-05 15:20:19 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 15:20:19 [INFO]: autolink for user_id 14409 is 1 2025-08-05 15:20:19 [INFO]: Ebay item id :: 256953568677 exists in Database 2025-08-05 15:20:19 [INFO]: Item is reliested :: exists in Database 2025-08-05 15:20:19 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 15:20:19 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 15:20:19 [INFO]: in processold action queue is array for {"44583047":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44583047","ebayitemid":"305405931466","shopifyproductid":"8286115987678","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8286115987678","shopifyvariantid":"44806892781790","shopifyinventoryid":"46904920211678","shopifylocationid":"","product_id":"44583047","variant_id":"77475756","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44559861":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44559861","ebayitemid":"335245839683","shopifyproductid":"8245559591134","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8245559591134","shopifyvariantid":"44636756869342","shopifyinventoryid":"46734739800286","shopifylocationid":"","product_id":"44559861","variant_id":"77452541","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44932180":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44932180","ebayitemid":"256953568677","shopifyproductid":"8940777275614","variants":[{"price":"19.99","quantity":0,"weight":"3","shopifyproductid":"8940777275614","shopifyvariantid":"47001642107102","shopifyinventoryid":"49112842207454","shopifylocationid":"58450641063","product_id":"44932180","variant_id":"77850353","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 15:20:19 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 15:20:19 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 15:20:19 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 15:20:19 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 15:20:19 [INFO]: Shopify Inventory id 46904920211678 2025-08-05 15:20:19 [INFO]: Shopify Location id 58450641063 2025-08-05 15:20:19 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 15:20:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T15:20:20Z","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-05 15:20:20 [INFO]: Change: available | Delta: -4 2025-08-05 15:20:20 [INFO]: Change: on_hand | Delta: -4 2025-08-05 15:20:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 15:20:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44583047 and user_id = 14409 2025-08-05 15:20:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77475756 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 15:20:20 [INFO]: Shopify Inventory id 46734739800286 2025-08-05 15:20:20 [INFO]: Shopify Location id 58450641063 2025-08-05 15:20:20 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 15:20:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T15:20:20Z","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-05 15:20:20 [INFO]: Change: available | Delta: -4 2025-08-05 15:20:20 [INFO]: Change: on_hand | Delta: -4 2025-08-05 15:20:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 15:20:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44559861 and user_id = 14409 2025-08-05 15:20:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77452541 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 15:20:20 [INFO]: Shopify Inventory id 49112842207454 2025-08-05 15:20:20 [INFO]: Shopify Location id 58450641063 2025-08-05 15:20:20 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 15:20:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T15:20:20Z","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-05 15:20:20 [INFO]: Change: available | Delta: -1 2025-08-05 15:20:20 [INFO]: Change: on_hand | Delta: -1 2025-08-05 15:20:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 15:20:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44932180 and user_id = 14409 2025-08-05 15:20:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77850353 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 15:20:20 [INFO]: updateIdsQuantity -> ["77475756","77452541","77850353"] 2025-08-05 15:20:20 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-05 15:20:20 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77475756 THEN 0 WHEN id = 77452541 THEN 0 WHEN id = 77850353 THEN 0 END, quantityflag = CASE WHEN id = 77475756 THEN 0 WHEN id = 77452541 THEN 0 WHEN id = 77850353 THEN 0 END WHERE user_id = 14409 AND id IN (77475756,77452541,77850353) 2025-08-05 15:20:20 [INFO]: QUANTITY Updated IDs: 77475756, 77452541, 77850353 2025-08-05 15:20:20 [INFO]: Successfully processed data for user 14409 2025-08-05 15:20:20 [INFO]: Execution Started 2025-08-05 15:20:20 [INFO]: Execution Finished 2025-08-05 15:30:01 [INFO]: Execution Started 2025-08-05 15:30:01 [INFO]: old server sucessfully connected 2025-08-05 15:30:01 [INFO]: sqs client sucess created 2025-08-05 15:30:04 [INFO]: Number of messages in the queue: 1 2025-08-05 15:30:08 [INFO]: item found in queue is if condition 14409 2025-08-05 15:30:08 [INFO]: item found in queue is 14409 2025-08-05 15:30:09 [INFO]: Message deleted from the queue for receipt handle: AQEBkJgnW++ag7nFRxmjBNONQvyLXQnuJGuSqz3NZ7uKUsaArw9YpG5GFNT6DpxzIjw5Ga+K0VEv7cI4hq2HX2qQYHrcdts4N/CDCpNIAwjj53a4jTp4q87GgLPV+NIFZRouDEEs4ZVRKqc5sePTH2SwfqCSdoMi00KUxj1DNtWKs6oVCz3dzIIGrUJM/9zUUkyXE/89iWn/7+YPo6eFoD8p27sFu/Ar7rkjGFrIHoF4HYxHeYbNXNltgEzAgJFyCh3OCQbeN1mqVl85bSUYIculhYvYEtQtwYME5uKlHO5y+Cp5M3Y6Pn0cqVPRxRUtcQ4vI+mg1yFF2SnL66TzgFDVSNW9/RAgMJH21ryU3MVNlMEQYeT1liPpKjzOZrLmM7fpsdQG6AzN5ApK4n/Uqu8J9cVKbAV+2Nz4i+wjmoZrYNLvQCrmQzA+0ewnj1LiHKhd 2025-08-05 15:30:09 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-05 15:30:09 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 15:30:09 [INFO]: inside itemsold and closed 14409 2025-08-05 15:30:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 15:30:10 [INFO]: autolink for user_id 14409 is 1 2025-08-05 15:30:10 [INFO]: not in db for user_id 14409 and the ebayitemid406092858399 2025-08-05 15:30:10 [INFO]: in processold action queue is array for [] 2025-08-05 15:30:10 [INFO]: Successfully processed data for user 14409 2025-08-05 15:30:10 [INFO]: Execution Started 2025-08-05 15:30:10 [INFO]: Execution Finished 2025-08-05 15:40:01 [INFO]: Execution Started 2025-08-05 15:40:02 [INFO]: old server sucessfully connected 2025-08-05 15:40:02 [INFO]: sqs client sucess created 2025-08-05 15:40:05 [INFO]: Number of messages in the queue: 2 2025-08-05 15:40:06 [INFO]: item found in queue is if condition 14409 2025-08-05 15:40:06 [INFO]: item found in queue is 14409 2025-08-05 15:40:06 [INFO]: Message deleted from the queue for receipt handle: AQEBifdws/S5pWYMK5AZmY+79PeZOOLh+DbrSEcrqVh8o22yk6ANXInV0PpP8ZWpd0+TRBsbktMf6lQwkApaykp8q+QGidMigrOZv2ZQesJNykdVmqk6DG1h38uLm5JlCgOCNkF9acMVvmYfjX4Eu4ci/DX3VaUY2iCSA28d9Zea3/PKxRvzsvk03kiceKSkhSPEA1BeY43QofbV861HJAwGbt3aSVdOaqJBnXIGSDhGSbVZV6lony+KG6GjkMmTHkDI6ftECkh1kY8okZHD4A17dZIzDfPbrNUUuhbYl3T0GpVuSWL4CEIaOrCHsmPE7+cjSmXK1S46TB06cyNnL124lweNEq7KB+anqaYV5+73Nt3xvenzRhB88rPp0lqzIKu51OCwO5YDwGbkO7BWbiQM0wtuysoMjENHRO/9dGDY6SZDtnQoFaIMCnxEZEj2CZd3 2025-08-05 15:40:07 [INFO]: item found in queue is if condition 14409 2025-08-05 15:40:07 [INFO]: item found in queue is 14409 2025-08-05 15:40:08 [INFO]: Message deleted from the queue for receipt handle: AQEBj6jrjyjq5hboqY1NAS8erdlyqJsNWS3Kjk9zK8t/nAGk3fQwRM//bhqIRL6jvAuvh8cXgkMela/1P0/L78TGm3LvHN8lnO+fbKCS8apcctKFYkNWLbSpgR9JcZ9spFGGkAc3YY04pmj8FN4sTO1CO6yNb7n3pwsXW8fi1JYZQP0rtDQEK/+1EA6CVxQIA2p55OgU0B06j8D8mHskzZMDzV62VPQwyY7LmkXrEQDjxS03c38GyfYGbWxRdnKNRWQGzwh1W3XBEvL6agDsiToUJp/riApzdRUU1wsz1dMqN9n9WVS3jV0nk4kphn1g14tPI0iCIbrbsgKkeAqpX1XJfpXqDtRc1qBRxhfxQFF4FTrOeOmXk1XAByRqc+VdJRBNTlEAlvZDy2LM5uqEER8NyOZewM+BPMgQMm072STBeL2tt/2Vh1pzSzyp0uQKYfGk 2025-08-05 15:40:08 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-05 15:40:08 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 15:40:08 [INFO]: inside itemsold and closed 14409 2025-08-05 15:40:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 15:40:10 [INFO]: autolink for user_id 14409 is 1 2025-08-05 15:40:10 [INFO]: Ebay item id :: 226868832855 exists in Database 2025-08-05 15:40:10 [INFO]: Item is reliested :: exists in Database 2025-08-05 15:40:10 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-05 15:40:10 [INFO]: inside itemsold and closed 14409 2025-08-05 15:40:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 15:40:11 [INFO]: autolink for user_id 14409 is 1 2025-08-05 15:40:11 [INFO]: Ebay item id :: 285717968771 exists in Database 2025-08-05 15:40:11 [INFO]: Item is reliested :: exists in Database 2025-08-05 15:40:11 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-05 15:40:11 [INFO]: in processold action queue is array for {"45237000":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45237000","ebayitemid":"226868832855","deleted":1}},"45144761":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45144761","ebayitemid":"285717968771","deleted":1}}} 2025-08-05 15:40:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 15:40:11 [INFO]: productIds WHich are having null productid -> [45237000,45144761] 2025-08-05 15:40:11 [INFO]: ebayItemIds WHich are not imported-> ["226868832855","285717968771"] 2025-08-05 15:40:11 [INFO]: Entered in bulkUpdateProducts function 2025-08-05 15:40:11 [INFO]: Transaction started for bulkUpdateProducts 2025-08-05 15:40:11 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45237000,45144761) 2025-08-05 15:40:11 [INFO]: Query executed successfully. Affected rows: 0 2025-08-05 15:40:11 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-05 15:40:11 [INFO]: Transaction committed successfully. 2025-08-05 15:40:11 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-05 15:40:11 [INFO]: Successfully processed data for user 14409 2025-08-05 15:40:11 [INFO]: Execution Started 2025-08-05 15:40:11 [INFO]: Execution Finished 2025-08-05 15:50:01 [INFO]: Execution Started 2025-08-05 15:50:01 [INFO]: old server sucessfully connected 2025-08-05 15:50:01 [INFO]: sqs client sucess created 2025-08-05 15:50:04 [INFO]: Number of messages in the queue: 6 2025-08-05 15:50:07 [INFO]: item found in queue is if condition 14409 2025-08-05 15:50:07 [INFO]: item found in queue is 14409 2025-08-05 15:50:07 [INFO]: Message deleted from the queue for receipt handle: AQEBvXjOhBbKCzhnVMqdOneREmK1WFaEho7zqt+5yfiaiX6jHpr66knWm/xogQStXxSkCYXUdrZW+MGwyvtH+slln8p9IobguGtao1Ina0OaBlunTkv7TWiYZA45VCKvLl97DKPUZe21JX+72CFtb9pKSzyx9o/BMl/oMH666kZdZaKA34u/fhHaFZ5zRlLNWZhbvB1b3BFI7JUSfCZyiKOnt04hED4RTeq+DQPhldLvTcuBRz8vfFc7jX0sLeSGfnNFw0gn2L2m+rWB1Di7o1YmMbWsixmR5CjiMCSRBtzDE8uDbFhlO6Gli4FUzw3SZynbJBTe5XlrIMPrdqb5K7CnKNzOpbnWyEMdwNHZ3LkR4ZLAXTZZFjZbaRNT3nCvdvdel6dWXu8szrhCMRfjJ3TOfLt6YnkLTQNk2u5yo8XZaIFNh/r6oJMkxRIGg+iLLJlC 2025-08-05 15:50:07 [INFO]: item found in queue is if condition 14409 2025-08-05 15:50:07 [INFO]: item found in queue is 14409 2025-08-05 15:50:08 [INFO]: Message deleted from the queue for receipt handle: AQEBxxPi4IefqdJqEcYU9lqX8Y2mkAj6jP4I+F7kexdH196eqR4U93VO6eSDH4rYhBqdMgosVNl+Dw1MgXrDKQIj3Ksxqb2EXtReTz+y34ZEBuGGWOPb4KMLToadIAI5ZbGQNH5e+YSnqLfgcvWyOq8LKsdGyjZG7MedcrakUsVy2/RVLaNIXh3yFvZU9H8AVXVWkKTZTsFA+pAouBKHfd9wFXYIea2dxUxi8W6MBBv3UWVlTKj0jYn8qYCS41dGTfOyhp4qkPLC4X1mMH40OSCTlzpH3DPw8iAdnD/dQ4rfBcOuR7CDjE8GwCYjo4fa/UoObTK+AETSOjV3iutyp1KnRRBC31bPKZszeeFth9Vdu5KJXjOASYaq5Uslx8RHtzaKOcyveZtQwrFXcIDZ8wuK4v/ZGCfl4bBXRwV973eELI24RiQDXiy9Of1lwN2n7oqU 2025-08-05 15:50:08 [INFO]: item found in queue is if condition 14409 2025-08-05 15:50:08 [INFO]: item found in queue is 14409 2025-08-05 15:50:08 [INFO]: Message deleted from the queue for receipt handle: AQEBaVFs4Hc1iBQgwWNkBGhRIkLQHV5Z/zdqYuAj/YMQhGgQB1NLhRZh5G/tLrWkcc2lPwq4kvF+zboUNpr/uCvwsqqycJrCoDnbVquvotMnJTbfoZvMW/DO03aBW/2bNhwPe94OE+vu5v3Jmy8D8/yDystKCEGjTJTT4qdju+f7yaymIlK4nk/+ZwFRT7RNsQQO5OdXPSY+CSSxa6kIsHHVM/yyKHaIlzabmBvxQEQBTZlSxIcODH/wS+B482M9FuFiSeFPF8h0kChZS42EOHP9DdTZiJKTqEe8NubbTMRLblwuuuZHXIWCvMudu8FiAYYE1AJgFyrh2MckVsHG6YHO9LiJc5/10aZlrcT3xwgTsnS/3q/duWGGNyjKeC++oyvtqW/DVUa8S+aAqLEWveblHRlTpvRTdNTHKnMTKhWZkFJ4NpmbsSqNuFkIT9b4lEs/ 2025-08-05 15:50:09 [INFO]: item found in queue is if condition 14409 2025-08-05 15:50:09 [INFO]: item found in queue is 14409 2025-08-05 15:50:10 [INFO]: Message deleted from the queue for receipt handle: AQEB1xYJOJmArC5/OvhdetJITDTJmc1gH+EkLoftaFy5AHUkQfNu1pyB5y0Z/odGUynfyi8O9Q62d8JmDpBwQA2RDu3pAIDzzXuom1jotbhhgoch1oGfP8dI02EMfd9qf48lhjFzkjefVZcn+t+WKEB5V/Qks0DYTgy588Tw7jVe6kpU9SVxYPDGWs/uKksjlHgK+NTtQvGDy7zYR48GVpHurqlgBKm397Ee9vPOE0f2OlJgG7MdzLmyZcs8xOgga88QOJsilJuB1M9LHxexh9DwyHffApk3/cg4blBcub51i1HLackLRGfAM4sfbUhlk+Fbl2wXFSlSRLRoP0jXOY0WyK8pGM1Ukr6SbjMSypY/o0O6WZraxhd3+FoOOQxIqTnwwiA80iL0sy1iWIU/zMlG/Ym+8p0bobd0KKtXbZvMptSzirk162QsIgukQD2CCtZB 2025-08-05 15:50:10 [INFO]: item found in queue is if condition 14409 2025-08-05 15:50:10 [INFO]: item found in queue is 14409 2025-08-05 15:50:11 [INFO]: Message deleted from the queue for receipt handle: AQEBsqtaKos04GqfTqEWXMFdH/v2Tgf5n/82NLAWvEgKjnBSJjcDtrxoO2GoSaQ/gGR807PQTVVz78ZFDW7uJfdxJ2p/gLB/k3ldb1H1KHOQJwtg0pPuKl+d/0zfzJxPJQRFUhYkc4AZRBIaLVyH+K7/6PSSIoRqi+x5obibvfbvjCcPnXK7I7OFVEysd8cCGul3mq/RLXkc+trUMF9//kaf/zqa4tZOqrGPOcf/qIka/cvqYMK3wsGa8ContAW8m31HYUmiznVbEvkrOkuaYnd2qSN5BHFvpmwOqDr4NOEEM889E3eco09UZ50ydTGfIDnzGIr86FGfY98ShJgMsUFYvToQbeeyaCVv3TQcwYqKg8TfIM6Bn84NhO+jIFRMIgG5WHVxdyuKnJ2e7DskQId1jEAUGs5nDrQnDSlVUbiKtzfZ9gRP0Vl1PaxNFmklGVkZ 2025-08-05 15:50:11 [INFO]: item found in queue is if condition 14409 2025-08-05 15:50:11 [INFO]: item found in queue is 14409 2025-08-05 15:50:12 [INFO]: Message deleted from the queue for receipt handle: AQEBAXHiMM2kcybFB58fyMf89IMEPchMG4CJ8aoO5Sq+/AHpEhHBg2ZdVTOnDV6lL112m8DmKS5soj62ET3Oo7EQ39+hajGcXk+sYffI9yG34CSF0bn4dkL3P95pogCkgqyQvaqhDAydPxsG6LbWjHIz8zTKeq6YsC1UKZBWZ4lNmAEB6t7n5FtMa3biwTH0yVk83o23Lt6kUuvKy1iasQ4XYiyWPcOVyeBt76mEK6vPgwzyxo8EeyJVuo3r2jGF0Q1OfzWN1jVSgEH/xpNXRPOetqFfN90RNUHvQp1J9aq5BS3vfdRgJf/Z1IlHCklPU1pOCsp4yvnr0qdj9WKa8nzeikbqcMXeUvfe4EFlOK7FPrZ4/KpRn2WaDALVlxZW4K8QAa/IDVSsTqzIBNDjJa2/31E+GBOGhBj15S8HPjyvSSUizCbzZe3cHuuVFuKqWnOL 2025-08-05 15:50:12 [INFO]: Processed 6 messages, reached the limit of 6. 2025-08-05 15:50:12 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 15:50:12 [INFO]: inside itemsold and closed 14409 2025-08-05 15:50:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 15:50:14 [INFO]: autolink for user_id 14409 is 1 2025-08-05 15:50:14 [INFO]: Ebay item id :: 285818240573 exists in Database 2025-08-05 15:50:14 [INFO]: Item is reliested :: exists in Database 2025-08-05 15:50:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 15:50:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 15:50:14 [INFO]: inside itemsold and closed 14409 2025-08-05 15:50:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 15:50:15 [INFO]: autolink for user_id 14409 is 1 2025-08-05 15:50:15 [INFO]: Ebay item id :: 306203880457 exists in Database 2025-08-05 15:50:15 [INFO]: Item is reliested :: exists in Database 2025-08-05 15:50:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 15:50:15 [INFO]: inside itemsold and closed 14409 2025-08-05 15:50:17 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 15:50:17 [INFO]: autolink for user_id 14409 is 1 2025-08-05 15:50:17 [INFO]: Ebay item id :: 256498569327 exists in Database 2025-08-05 15:50:17 [INFO]: Item is reliested :: exists in Database 2025-08-05 15:50:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 15:50:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 15:50:17 [INFO]: inside itemsold and closed 14409 2025-08-05 15:50:19 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 15:50:19 [INFO]: autolink for user_id 14409 is 1 2025-08-05 15:50:19 [INFO]: Ebay item id :: 405342626348 exists in Database 2025-08-05 15:50:19 [INFO]: Item is reliested :: exists in Database 2025-08-05 15:50:19 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 15:50:19 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 15:50:19 [INFO]: inside itemsold and closed 14409 2025-08-05 15:50:21 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 15:50:21 [INFO]: autolink for user_id 14409 is 1 2025-08-05 15:50:21 [INFO]: Ebay item id :: 285840742822 exists in Database 2025-08-05 15:50:21 [INFO]: Item is reliested :: exists in Database 2025-08-05 15:50:21 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 15:50:21 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 15:50:21 [INFO]: inside itemsold and closed 14409 2025-08-05 15:50:22 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 15:50:22 [INFO]: autolink for user_id 14409 is 1 2025-08-05 15:50:22 [INFO]: Ebay item id :: 285839167709 exists in Database 2025-08-05 15:50:22 [INFO]: Item is reliested :: exists in Database 2025-08-05 15:50:22 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 15:50:22 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 15:50:22 [INFO]: in processold action queue is array for {"44652965":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44652965","ebayitemid":"285818240573","shopifyproductid":"8409457852638","variants":[{"price":"77.99","quantity":0,"weight":"2","shopifyproductid":"8409457852638","shopifyvariantid":"45204586463454","shopifyinventoryid":"47302496649438","shopifylocationid":"","product_id":"44652965","variant_id":"77558154","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772929":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772929","ebayitemid":"256498569327","shopifyproductid":"8463226962142","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8463226962142","shopifyvariantid":"45308065087710","shopifyinventoryid":"47405989986526","shopifylocationid":"","product_id":"44772929","variant_id":"77681471","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44776692":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44776692","ebayitemid":"405342626348","shopifyproductid":"8730449641694","variants":[{"price":"77.99","quantity":0,"weight":"2","shopifyproductid":"8730449641694","shopifyvariantid":"46027237458142","shopifyinventoryid":"48125848060126","shopifylocationid":"","product_id":"44776692","variant_id":"77685234","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772912":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772912","ebayitemid":"285840742822","shopifyproductid":"8463033893086","variants":[{"price":"355.99","quantity":0,"weight":"2","shopifyproductid":"8463033893086","shopifyvariantid":"45307492368606","shopifyinventoryid":"47405417103582","shopifylocationid":"","product_id":"44772912","variant_id":"77681454","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772868":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772868","ebayitemid":"285839167709","shopifyproductid":"8461829800158","variants":[{"price":"77.99","quantity":0,"weight":"2","shopifyproductid":"8461829800158","shopifyvariantid":"45306172113118","shopifyinventoryid":"47404096848094","shopifylocationid":"","product_id":"44772868","variant_id":"77681410","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 15:50:22 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 15:50:22 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 15:50:22 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 15:50:22 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 15:50:22 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 15:50:22 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 15:50:22 [INFO]: Shopify Inventory id 47302496649438 2025-08-05 15:50:22 [INFO]: Shopify Location id 58450641063 2025-08-05 15:50:22 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 15:50:23 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T15:50:23Z","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-05 15:50:23 [INFO]: Change: available | Delta: -1 2025-08-05 15:50:23 [INFO]: Change: on_hand | Delta: -1 2025-08-05 15:50:23 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 15:50:23 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44652965 and user_id = 14409 2025-08-05 15:50:23 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77558154 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 15:50:23 [INFO]: Shopify Inventory id 47405989986526 2025-08-05 15:50:23 [INFO]: Shopify Location id 58450641063 2025-08-05 15:50:23 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 15:50:23 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T15:50:23Z","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-05 15:50:23 [INFO]: Change: available | Delta: -1 2025-08-05 15:50:23 [INFO]: Change: on_hand | Delta: -1 2025-08-05 15:50:23 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 15:50:23 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772929 and user_id = 14409 2025-08-05 15:50:23 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681471 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 15:50:23 [INFO]: Shopify Inventory id 48125848060126 2025-08-05 15:50:23 [INFO]: Shopify Location id 58450641063 2025-08-05 15:50:23 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 15:50:23 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T15:50:23Z","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-05 15:50:23 [INFO]: Change: available | Delta: -1 2025-08-05 15:50:23 [INFO]: Change: on_hand | Delta: -1 2025-08-05 15:50:23 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 15:50:23 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44776692 and user_id = 14409 2025-08-05 15:50:23 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685234 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 15:50:23 [INFO]: Shopify Inventory id 47405417103582 2025-08-05 15:50:23 [INFO]: Shopify Location id 58450641063 2025-08-05 15:50:23 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 15:50:24 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T15:50:23Z","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-05 15:50:24 [INFO]: Change: available | Delta: -1 2025-08-05 15:50:24 [INFO]: Change: on_hand | Delta: -1 2025-08-05 15:50:24 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 15:50:24 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772912 and user_id = 14409 2025-08-05 15:50:24 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681454 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 15:50:24 [INFO]: Shopify Inventory id 47404096848094 2025-08-05 15:50:24 [INFO]: Shopify Location id 58450641063 2025-08-05 15:50:24 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 15:50:24 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T15:50:24Z","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-05 15:50:24 [INFO]: Change: available | Delta: -1 2025-08-05 15:50:24 [INFO]: Change: on_hand | Delta: -1 2025-08-05 15:50:24 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 15:50:24 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772868 and user_id = 14409 2025-08-05 15:50:24 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681410 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 15:50:24 [INFO]: updateIdsQuantity -> ["77558154","77681471","77685234","77681454","77681410"] 2025-08-05 15:50:24 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 5. Affected rows: 5 2025-08-05 15:50:24 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77558154 THEN 0 WHEN id = 77681471 THEN 0 WHEN id = 77685234 THEN 0 WHEN id = 77681454 THEN 0 WHEN id = 77681410 THEN 0 END, quantityflag = CASE WHEN id = 77558154 THEN 0 WHEN id = 77681471 THEN 0 WHEN id = 77685234 THEN 0 WHEN id = 77681454 THEN 0 WHEN id = 77681410 THEN 0 END WHERE user_id = 14409 AND id IN (77558154,77681471,77685234,77681454,77681410) 2025-08-05 15:50:24 [INFO]: QUANTITY Updated IDs: 77558154, 77681471, 77685234, 77681454, 77681410 2025-08-05 15:50:24 [INFO]: Successfully processed data for user 14409 2025-08-05 15:50:24 [INFO]: Execution Started 2025-08-05 15:50:24 [INFO]: Execution Finished