2025-08-08 01:00:02 [INFO]: Execution Started 2025-08-08 01:00:02 [INFO]: old server sucessfully connected 2025-08-08 01:00:02 [INFO]: sqs client sucess created 2025-08-08 01:00:03 [INFO]: Number of messages in the queue: 1 2025-08-08 01:00:03 [INFO]: item found in queue is if condition 14409 2025-08-08 01:00:03 [INFO]: item found in queue is 14409 2025-08-08 01:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEB2k9uMff9eePpxzPKnrs7tZ7odCpThKZo1tpfN+cqWly5AIJHqjUvgfpjokLglX5o+ppSCn2kTKj3W9kakDc4rX5ZUap47gHSpERpP+D3fmpqHBifpZ9bWTVE4AE3Sts3Wx8huju7hfyQkm0xRxNTRL0uU7FjQ///Mis3f62QE6ft3kUhTi/y9NsxGB3MJdKvP1+YJOifEKwAZPVBXGDkDAM2oRpejHm6X2j8JfyvOYGMZ7KjFzBdHEdoZduGM++4v7D0ZsuerBxRyFBDRQNG7allv2fmjLjORW1d8+ewEWthJ4ynq8PcWR8GRd1Q13omvLwp+Ch0GdXq0bscjXzl0zPuq6fROC8mkonNylAPlznSkG2YLStvUnl+nMj7iPY53XuuLsj68A56m+zUaBCyRLzghIraKkvxG/W/y190BfseU82FXUllbidQ1xmHYeke 2025-08-08 01:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-08 01:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 01:00:03 [INFO]: inside itemsold and closed 14409 2025-08-08 01:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 01:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-08 01:00:05 [INFO]: Ebay item id :: 335747972020 exists in Database 2025-08-08 01:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-08 01:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 01:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 01:00:05 [INFO]: in processold action queue is array for {"44593669":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44593669","ebayitemid":"335747972020","shopifyproductid":"8784594010334","variants":[{"price":"34.99","quantity":0,"weight":"3","shopifyproductid":"8784594010334","shopifyvariantid":"46206055579870","shopifyinventoryid":"48305876893918","shopifylocationid":"","product_id":"44593669","variant_id":"77486378","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 01:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 01:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 01:00:05 [INFO]: Shopify Inventory id 48305876893918 2025-08-08 01:00:05 [INFO]: Shopify Location id 58450641063 2025-08-08 01:00:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 01:00:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T01:00:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-08 01:00:05 [INFO]: Change: available | Delta: -1 2025-08-08 01:00:05 [INFO]: Change: on_hand | Delta: -1 2025-08-08 01:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 01:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44593669 and user_id = 14409 2025-08-08 01:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77486378 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 01:00:05 [INFO]: updateIdsQuantity -> ["77486378"] 2025-08-08 01:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-08 01:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77486378 THEN 0 END, quantityflag = CASE WHEN id = 77486378 THEN 0 END WHERE user_id = 14409 AND id IN (77486378) 2025-08-08 01:00:05 [INFO]: QUANTITY Updated IDs: 77486378 2025-08-08 01:00:05 [INFO]: Successfully processed data for user 14409 2025-08-08 01:00:05 [INFO]: Execution Started 2025-08-08 01:00:05 [INFO]: Execution Finished 2025-08-08 01:10:01 [INFO]: Execution Started 2025-08-08 01:10:01 [INFO]: old server sucessfully connected 2025-08-08 01:10:02 [INFO]: sqs client sucess created 2025-08-08 01:10:03 [INFO]: Number of messages in the queue: 1 2025-08-08 01:10:03 [INFO]: item found in queue is if condition 14409 2025-08-08 01:10:03 [INFO]: item found in queue is 14409 2025-08-08 01:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBPAWZPLRo4piTQd4qk8NWfnXvwDwVTHYRy/0o9INEcX5iP5XjWMB8lt3ur+1JX4D+tSdqwJAJggtngkfm4SLtNlGwEL43IkQaT6NqdlkkukMdDAgoTFTBuR/+o5XSdMVHozYSfXGCj7TqR0Fbyrn17O0Oc8B2ucEsWavbGTUsjnfrgQ7WYhbEsUGk63TsLeTaBtRTu+9IrYzsvU12R9Cn7Mu5zLFNmcevBRNtQJYHwfldFTHNoJjTeVZyHKjNSVFP50+2JN/4ZQTF+rNTeGSM9HUfiOsdrufVpn5N5k9DRv6qM4Uztoniye6MitsjlGHYgw9Pb7rxQ6JsZlxgrOxw8Pc7En9EoBFttF9hQav9R90R+wJjtpYn/2n+pXZHjnZlq3mOa+THKph3OO8LYgE2C+DCs80RLW43DxsmTMCXMSRlHV14FSBahBQ4MK2Od30D 2025-08-08 01:10:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-08 01:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 01:10:03 [INFO]: inside itemsold and closed 14409 2025-08-08 01:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 01:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-08 01:10:05 [INFO]: Ebay item id :: 285836130828 exists in Database 2025-08-08 01:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-08 01:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 01:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 01:10:05 [INFO]: in processold action queue is array for {"44709662":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44709662","ebayitemid":"285836130828","shopifyproductid":"8100623089886","variants":[{"price":"74.99","quantity":0,"weight":"2","shopifyproductid":"8100623089886","shopifyvariantid":"44292823253214","shopifyinventoryid":"46390065561822","shopifylocationid":"","product_id":"44709662","variant_id":"77617268","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 01:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 01:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 01:10:05 [INFO]: Shopify Inventory id 46390065561822 2025-08-08 01:10:05 [INFO]: Shopify Location id 58450641063 2025-08-08 01:10:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 01:10:05 [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-08 01:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 01:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44709662 and user_id = 14409 2025-08-08 01:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77617268 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 01:10:05 [INFO]: updateIdsQuantity -> ["77617268"] 2025-08-08 01:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-08 01:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77617268 THEN 0 END, quantityflag = CASE WHEN id = 77617268 THEN 0 END WHERE user_id = 14409 AND id IN (77617268) 2025-08-08 01:10:05 [INFO]: QUANTITY Updated IDs: 77617268 2025-08-08 01:10:05 [INFO]: Successfully processed data for user 14409 2025-08-08 01:10:05 [INFO]: Execution Started 2025-08-08 01:10:05 [INFO]: Execution Finished 2025-08-08 01:20:02 [INFO]: Execution Started 2025-08-08 01:20:02 [INFO]: old server sucessfully connected 2025-08-08 01:20:02 [INFO]: sqs client sucess created 2025-08-08 01:20:03 [INFO]: Number of messages in the queue: 1 2025-08-08 01:20:03 [INFO]: item found in queue is if condition 14409 2025-08-08 01:20:03 [INFO]: item found in queue is 14409 2025-08-08 01:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBIV29yIpcM+eM+2xTt2HbxKQFbvSAKuA9Pae9boP4WiKWz13R9lPmcuOpG9UvEcVeaPX385bxsWwPn5rRfn/VUbaSEq7V/ivSLvf25j/1oYPKO2HKxL81pH1b9D7refAw7JoJDU/6igmO0BCnyt6jEhzVQjEnNOANgqyPaOkyzYImj6b2H27G3FqA7A9VEaAdvIumoJG4nH9y2+JK+vMN7mirrD7+XD/jwHObeymIT4NXIUw/+I2wuj1zrd51b8sr0DiYUm0F40Lx9+QOu1MT2G92gw6KhccDB+TjaCLROMCgC7hnaMQTQeAEmcVYMN0olaIm19T7U5XWha7Mbpo0RNyLmAPhmTOiFm9xJ1MQL2nj1YIm/Wv7uvkG5d4mkXF8iFoHDFoU5hwV1hKvndwEz8yaKvtO+BfTWf6KYmOTHsWQ4O2ClRq8vrvT10WXA44W 2025-08-08 01:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-08 01:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 01:20:03 [INFO]: inside itemsold and closed 14409 2025-08-08 01:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 01:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-08 01:20:05 [INFO]: Ebay item id :: 335868279291 exists in Database 2025-08-08 01:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-08 01:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 01:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 01:20:05 [INFO]: in processold action queue is array for {"44579138":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44579138","ebayitemid":"335868279291","shopifyproductid":"8155725758686","variants":[{"price":"39.99","quantity":0,"weight":"3","shopifyproductid":"8155725758686","shopifyvariantid":"44413149577438","shopifyinventoryid":"46510903722206","shopifylocationid":"","product_id":"44579138","variant_id":"77471845","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 01:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 01:20:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 01:20:05 [INFO]: Shopify Inventory id 46510903722206 2025-08-08 01:20:05 [INFO]: Shopify Location id 58450641063 2025-08-08 01:20:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 01:20:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T01:20:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-08 01:20:05 [INFO]: Change: available | Delta: -1 2025-08-08 01:20:05 [INFO]: Change: on_hand | Delta: -1 2025-08-08 01:20:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 01:20:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44579138 and user_id = 14409 2025-08-08 01:20:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77471845 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 01:20:05 [INFO]: updateIdsQuantity -> ["77471845"] 2025-08-08 01:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-08 01:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77471845 THEN 0 END, quantityflag = CASE WHEN id = 77471845 THEN 0 END WHERE user_id = 14409 AND id IN (77471845) 2025-08-08 01:20:05 [INFO]: QUANTITY Updated IDs: 77471845 2025-08-08 01:20:05 [INFO]: Successfully processed data for user 14409 2025-08-08 01:20:05 [INFO]: Execution Started 2025-08-08 01:20:05 [INFO]: Execution Finished 2025-08-08 01:30:01 [INFO]: Execution Started 2025-08-08 01:30:01 [INFO]: old server sucessfully connected 2025-08-08 01:30:01 [INFO]: sqs client sucess created 2025-08-08 01:30:02 [INFO]: Number of messages in the queue: 0 2025-08-08 01:30:22 [INFO]: Execution Started 2025-08-08 01:30:22 [INFO]: Execution Finished 2025-08-08 01:40:01 [INFO]: Execution Started 2025-08-08 01:40:01 [INFO]: old server sucessfully connected 2025-08-08 01:40:01 [INFO]: sqs client sucess created 2025-08-08 01:40:03 [INFO]: Number of messages in the queue: 0 2025-08-08 01:40:23 [INFO]: Execution Started 2025-08-08 01:40:23 [INFO]: Execution Finished 2025-08-08 01:50:02 [INFO]: Execution Started 2025-08-08 01:50:02 [INFO]: old server sucessfully connected 2025-08-08 01:50:02 [INFO]: sqs client sucess created 2025-08-08 01:50:03 [INFO]: Number of messages in the queue: 0 2025-08-08 01:50:23 [INFO]: Execution Started 2025-08-08 01:50:23 [INFO]: Execution Finished