2025-08-05 09:00:01 [INFO]: Execution Started 2025-08-05 09:00:01 [INFO]: old server sucessfully connected 2025-08-05 09:00:01 [INFO]: sqs client sucess created 2025-08-05 09:00:02 [INFO]: Number of messages in the queue: 1 2025-08-05 09:00:03 [INFO]: item found in queue is if condition 14409 2025-08-05 09:00:03 [INFO]: item found in queue is 14409 2025-08-05 09:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEB2K44mt5n7gLvz/0/JSlbcgxc4BbUjZCjc69UYfxvkOU2dgdjcEHKB6J8fCeP2hQelXYokK/u8Za9PXUdVJHI23aKZA2/zpNRick6fqj1Ir/wIhKx41h2eWbMu9uZ+fgyfAMzUzr8+iWXAvXtj28oegimw6Ms8DLwXzHcSZeNFBzzvQX2bdlfpOfJ4erHAQEnuw2jqkgb8vFMNFAzRu1QD8rgiL3npXDEfzaVI/NRV7ZqITVmFk58Hh30tG4MKrGuB9NBSlxqTfZDxmrnun9uYXZxPr3ZnGnQhJFHqndDqpkahqDgfBcYH9/5kK5kId76xxxJK8QGMFZi5RCLrBo39lKUOxSCbG0ipvgclA1LPyFbee1p8jLkgKzGT6Z9FoZYgsqK4lPFCkUjBqQtPDwMvgbGq3yTQX3JJd4IlSEbM25D26DtHha6Eb798gydohzN 2025-08-05 09:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-05 09:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 09:00:03 [INFO]: inside itemsold and closed 14409 2025-08-05 09:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 09:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-05 09:00:05 [INFO]: Ebay item id :: 405816971616 exists in Database 2025-08-05 09:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-05 09:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 09:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 09:00:05 [INFO]: in processold action queue is array for {"44713968":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44713968","ebayitemid":"405816971616","shopifyproductid":"8926264492254","variants":[{"price":"69.99","quantity":0,"weight":"3","shopifyproductid":"8926264492254","shopifyvariantid":"46837925413086","shopifyinventoryid":"48936413298910","shopifylocationid":"58450641063","product_id":"44713968","variant_id":"77621581","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 09:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 09:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 09:00:05 [INFO]: Shopify Inventory id 48936413298910 2025-08-05 09:00:05 [INFO]: Shopify Location id 58450641063 2025-08-05 09:00:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 09:00:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T09:00:06Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1929,"restoreRate":100}}}} 2025-08-05 09:00:06 [INFO]: Change: available | Delta: -1 2025-08-05 09:00:06 [INFO]: Change: on_hand | Delta: -1 2025-08-05 09:00:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 09:00:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44713968 and user_id = 14409 2025-08-05 09:00:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77621581 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 09:00:06 [INFO]: updateIdsQuantity -> ["77621581"] 2025-08-05 09:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-05 09:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77621581 THEN 0 END, quantityflag = CASE WHEN id = 77621581 THEN 0 END WHERE user_id = 14409 AND id IN (77621581) 2025-08-05 09:00:06 [INFO]: QUANTITY Updated IDs: 77621581 2025-08-05 09:00:06 [INFO]: Successfully processed data for user 14409 2025-08-05 09:00:06 [INFO]: Execution Started 2025-08-05 09:00:06 [INFO]: Execution Finished 2025-08-05 09:10:02 [INFO]: Execution Started 2025-08-05 09:10:02 [INFO]: old server sucessfully connected 2025-08-05 09:10:02 [INFO]: sqs client sucess created 2025-08-05 09:10:03 [INFO]: Number of messages in the queue: 1 2025-08-05 09:10:03 [INFO]: item found in queue is if condition 14409 2025-08-05 09:10:03 [INFO]: item found in queue is 14409 2025-08-05 09:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEB4x4xnxOZSOQRLkd7LFWUIKUyKHC6A2N8i7bVSVOztmBuavA8Zow4gfTIeWjOHPmR6XOorFQ0cRRAjP95O9UmP8MTo6E/97ZOF9vahw4AyKEhu+dRjIyjCAufWbCek2WbzbZ7hAtjhPEVLkdpZA/l/xJy9O1SNdwK9RKuOUiZpQeDZIZBtGj2wez/Jjo2QcHMkSyEYRZBF4TZRsZKJhQNMG1uYHQbsit05A7E7S9UYJHUcK0f/Byerav072eGO6eYt/S68s6ewQrrhIiZJE4nApQrdB2/xQHYU9lwu8dkkrMVsq0RQ/eyoEUPriK4K6Fsg+h2YlCOUBe8FDQg6/EVJLKOAAfZebpIxaw90ZJUD8pSuO+77hJRfh3yNE62tp5TOG33LfKXWHiIRyFQvMZSzS/clYjmM3LtRYAjOXw/6i+AWRyEpk1NucrhheRs/Z0f 2025-08-05 09:10:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-05 09:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 09:10:03 [INFO]: inside itemsold and closed 14409 2025-08-05 09:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 09:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-05 09:10:05 [INFO]: Ebay item id :: 285793100867 exists in Database 2025-08-05 09:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-05 09:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 09:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 09:10:05 [INFO]: in processold action queue is array for {"44772241":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772241","ebayitemid":"285793100867","shopifyproductid":"8355501408478","variants":[{"price":"169.99","quantity":0,"weight":"2","shopifyproductid":"8355501408478","shopifyvariantid":"45032807760094","shopifyinventoryid":"47130602668254","shopifylocationid":"","product_id":"44772241","variant_id":"77680783","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 09:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 09:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 09:10:05 [INFO]: Shopify Inventory id 47130602668254 2025-08-05 09:10:05 [INFO]: Shopify Location id 58450641063 2025-08-05 09:10:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 09:10:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T09:10:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1933,"restoreRate":100}}}} 2025-08-05 09:10:06 [INFO]: Change: available | Delta: -1 2025-08-05 09:10:06 [INFO]: Change: on_hand | Delta: -1 2025-08-05 09:10:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 09:10:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772241 and user_id = 14409 2025-08-05 09:10:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680783 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 09:10:06 [INFO]: updateIdsQuantity -> ["77680783"] 2025-08-05 09:10:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-05 09:10:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77680783 THEN 0 END, quantityflag = CASE WHEN id = 77680783 THEN 0 END WHERE user_id = 14409 AND id IN (77680783) 2025-08-05 09:10:06 [INFO]: QUANTITY Updated IDs: 77680783 2025-08-05 09:10:06 [INFO]: Successfully processed data for user 14409 2025-08-05 09:10:06 [INFO]: Execution Started 2025-08-05 09:10:06 [INFO]: Execution Finished 2025-08-05 09:20:01 [INFO]: Execution Started 2025-08-05 09:20:01 [INFO]: old server sucessfully connected 2025-08-05 09:20:01 [INFO]: sqs client sucess created 2025-08-05 09:20:02 [INFO]: Number of messages in the queue: 2 2025-08-05 09:20:02 [INFO]: item found in queue is if condition 14409 2025-08-05 09:20:02 [INFO]: item found in queue is 14409 2025-08-05 09:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBWUlSemvWCTqez6pr/PYjB6OWaf5ubU68za/CbxdohLb/esgwsj5UiLEMFB/oZ//Gw9vxy50hFGqFt4mv+dc/Gy8XFi9J88w78ZED7zTIh3bzKOX7yBM3A7wUFOgZzfPN2XRQdaxwtZ26HdKbPvUdw3h2bpFU6UuJBcLGhqBqmxwNR97TMRiU0jyyf9lJwepzzg0EfaP2raz94l7rZM7dp1S10YWLNDlOS9LzmrKAPh6vIVhdKGLDL1g+KRPwHGNrkUrXyDHQSXqOp/qWib6VAmQv1J81PBFV/McsuU11TMX2Cg40BtMvoCETlFqzzlDO9dBN7QfHAOtqgkfXXciQrDT2VbBNGfrdrhiIr38he1tCaqQelibbymYrC4B8wgFZvu2pyxARojEuOql1JbqsmGsw/S/GLzbM1wwwmWVz5oDjD4FReCslBc90SU7fvCSL 2025-08-05 09:20:03 [INFO]: item found in queue is if condition 14409 2025-08-05 09:20:03 [INFO]: item found in queue is 14409 2025-08-05 09:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEB8XvC1rYbnlMW3cVMzuZBGsYvK9mylt6hQilQt32CHDd9cNu3ZlzRnGjb4GP379sez5YQzlxsUL2IPlnjUwRF/RVivtoo247tBABvQ3upk3KCg7XviNbH2UkdXKvxh99iU94fgCDfuzNBzJZkokupPljKaitNgTXpbQ/EfWl8IN/u4EKkUGlAMtC2ZBTktZ8uS8gBqve4uZW66Y3sA6tWOkxxjxrQLdbevE5e5MxzE34Pwpb4Gx/6MPpN2S0o9dJRXQbE5CBrBpPcYVvvrmuexXACO7lXjpQj5YWrwEmsgQwg/UXimi49M0A8zXRyuBocnYT+tpFQMAJNryXyfFEVipINtGN74VqFW5Oj+MqmQzaiJ+pdEBB64FiW84sIXWAHZHJSIDFwJ+WIOmL9hDEiReXWkKFhpdeRtfu0AvoMrfIkWZ91IpRed2X6jWRb2Fq+ 2025-08-05 09:20:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-05 09:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 09:20:03 [INFO]: inside itemsold and closed 14409 2025-08-05 09:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 09:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-05 09:20:05 [INFO]: Ebay item id :: 256467351118 exists in Database 2025-08-05 09:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-05 09:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 09:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 09:20:05 [INFO]: inside itemsold and closed 14409 2025-08-05 09:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 09:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-05 09:20:07 [INFO]: Ebay item id :: 285794978422 exists in Database 2025-08-05 09:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-05 09:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 09:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 09:20:07 [INFO]: in processold action queue is array for {"44772299":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772299","ebayitemid":"256467351118","shopifyproductid":"8362468966622","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"8362468966622","shopifyvariantid":"45052120695006","shopifyinventoryid":"47149920190686","shopifylocationid":"","product_id":"44772299","variant_id":"77680841","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772271":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772271","ebayitemid":"285794978422","shopifyproductid":"8358885621982","variants":[{"price":"233.99","quantity":0,"weight":"2","shopifyproductid":"8358885621982","shopifyvariantid":"45045547499742","shopifyinventoryid":"47143346602206","shopifylocationid":"","product_id":"44772271","variant_id":"77680813","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 09:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 09:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 09:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 09:20:07 [INFO]: Shopify Inventory id 47149920190686 2025-08-05 09:20:07 [INFO]: Shopify Location id 58450641063 2025-08-05 09:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 09:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T09:20: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-05 09:20:07 [INFO]: Change: available | Delta: -1 2025-08-05 09:20:07 [INFO]: Change: on_hand | Delta: -1 2025-08-05 09:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 09:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772299 and user_id = 14409 2025-08-05 09:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680841 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 09:20:07 [INFO]: Shopify Inventory id 47143346602206 2025-08-05 09:20:07 [INFO]: Shopify Location id 58450641063 2025-08-05 09:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 09:20:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T09:20: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-05 09:20:08 [INFO]: Change: available | Delta: -1 2025-08-05 09:20:08 [INFO]: Change: on_hand | Delta: -1 2025-08-05 09:20:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 09:20:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772271 and user_id = 14409 2025-08-05 09:20:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680813 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 09:20:08 [INFO]: updateIdsQuantity -> ["77680841","77680813"] 2025-08-05 09:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-05 09:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77680841 THEN 0 WHEN id = 77680813 THEN 0 END, quantityflag = CASE WHEN id = 77680841 THEN 0 WHEN id = 77680813 THEN 0 END WHERE user_id = 14409 AND id IN (77680841,77680813) 2025-08-05 09:20:08 [INFO]: QUANTITY Updated IDs: 77680841, 77680813 2025-08-05 09:20:08 [INFO]: Successfully processed data for user 14409 2025-08-05 09:20:08 [INFO]: Execution Started 2025-08-05 09:20:08 [INFO]: Execution Finished 2025-08-05 09:30:01 [INFO]: Execution Started 2025-08-05 09:30:01 [INFO]: old server sucessfully connected 2025-08-05 09:30:01 [INFO]: sqs client sucess created 2025-08-05 09:30:02 [INFO]: Number of messages in the queue: 1 2025-08-05 09:30:03 [INFO]: item found in queue is if condition 14409 2025-08-05 09:30:03 [INFO]: item found in queue is 14409 2025-08-05 09:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBtbw/wRCg7c499cbSDLeOWohzPot1VexGOZEgvDfSWY3cNNvT9mG3tATam2fu4WiEriTnr4QzBymT/OunM3p6GeaRmkn/xlrAKaeprxhjZqbHEPoMHJTHB0ypB1OAJkXyudNwiCDREINrvHmgiYd9EJzKedh0qChJesHsfZ6N6D7ta8+2S5ZR5QaRcqAeh6JIUmaTKTFmCMbju0Kuf9Z3ws7I0OIoqGI0P74QS/2ilUO6uJzHysnrXFe0ZPLwZX3ky5jY3m/MN62IX78HYRBzkXT42B3M223we39gCMes1XVpxl2GVoDDuSdThY5SjDBZowtfUtrGgjDprg4d5ivUu9TTkoAoZo+7UymmEMG+fdS6TP+pewXougpB9fd3Xc8JXddRrqxou4Zu0RXbXNUQ84PvTOanBq0+Ftbh30rVRebl5zjdDLsSNRmMKXFi+9bd 2025-08-05 09:30:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-05 09:30:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 09:30:03 [INFO]: inside itemsold and closed 14409 2025-08-05 09:30:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 09:30:05 [INFO]: autolink for user_id 14409 is 1 2025-08-05 09:30:05 [INFO]: Ebay item id :: 256467356228 exists in Database 2025-08-05 09:30:05 [INFO]: Item is reliested :: exists in Database 2025-08-05 09:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 09:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 09:30:05 [INFO]: in processold action queue is array for {"44772300":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772300","ebayitemid":"256467356228","shopifyproductid":"8362384720094","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"8362384720094","shopifyvariantid":"45052000141534","shopifyinventoryid":"47149799637214","shopifylocationid":"","product_id":"44772300","variant_id":"77680842","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 09:30:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 09:30:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 09:30:05 [INFO]: Shopify Inventory id 47149799637214 2025-08-05 09:30:05 [INFO]: Shopify Location id 58450641063 2025-08-05 09:30:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 09:30:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T09: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-05 09:30:06 [INFO]: Change: available | Delta: -1 2025-08-05 09:30:06 [INFO]: Change: on_hand | Delta: -1 2025-08-05 09:30:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 09:30:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772300 and user_id = 14409 2025-08-05 09:30:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680842 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 09:30:06 [INFO]: updateIdsQuantity -> ["77680842"] 2025-08-05 09:30:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-05 09:30:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77680842 THEN 0 END, quantityflag = CASE WHEN id = 77680842 THEN 0 END WHERE user_id = 14409 AND id IN (77680842) 2025-08-05 09:30:06 [INFO]: QUANTITY Updated IDs: 77680842 2025-08-05 09:30:06 [INFO]: Successfully processed data for user 14409 2025-08-05 09:30:06 [INFO]: Execution Started 2025-08-05 09:30:06 [INFO]: Execution Finished 2025-08-05 09:35:26 [INFO]: Execution Started 2025-08-05 09:35:26 [INFO]: old server sucessfully connected 2025-08-05 09:35:26 [INFO]: sqs client sucess created 2025-08-05 09:35:27 [INFO]: Number of messages in the queue: 1 2025-08-05 09:35:27 [INFO]: item found in queue is if condition 14409 2025-08-05 09:35:27 [INFO]: item found in queue is 14409 2025-08-05 09:35:27 [INFO]: Message deleted from the queue for receipt handle: AQEB2kGgXvNrZCsrVXTeRn1i/SUn7Luhxlpj6DD9J1DmLqWcqpaRb1tsDf718FTCKc5HJIQhiSclV/L/Be8qfdHSdbGVuZe9C++/JpNg1+3jxu3pnw02i5G4MXc0Yo8qeIFwRTkJwp+KO8mXF3RTg9eH8eXPIiFK/Ec3pY5DbnZqd6wdTqoRd+Hvuf3GLwfvFq00Fd1GOEjPBPrOWM2N8VBamBjzQlqziud3414YKZQ0pBGabel5C1cKdg4Al3GFGnmFl4gW4eSR0zItxwp4rLuPCmq4gnPGQO5dRKz5dyXyTjVo1lEc3oZS6une95Of7jUeuTTsUtXWPY/RlI/fZDwlwax0EuHiHZc4J19sGhzlLMkC8465xXaZURhRs4O+yZSw+iBvggJ+NPxbjQWI9b1OmoMoV0yHJOXMf9sF5SrvymRRBgcBciYifJvuo2Mnvxod 2025-08-05 09:35:27 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-05 09:35:27 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 09:35:27 [INFO]: inside itemsold and closed 14409 2025-08-05 09:35:29 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 09:35:29 [INFO]: autolink for user_id 14409 is 1 2025-08-05 09:35:29 [INFO]: Ebay item id :: 285796606024 exists in Database 2025-08-05 09:35:29 [INFO]: Item is reliested :: exists in Database 2025-08-05 09:35:29 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 09:35:29 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 09:35:29 [INFO]: in processold action queue is array for {"44772308":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772308","ebayitemid":"285796606024","shopifyproductid":"8917744648414","variants":[{"price":"89.99","quantity":0,"weight":"0.5","shopifyproductid":"8917744648414","shopifyvariantid":"46726689489118","shopifyinventoryid":"48825176162526","shopifylocationid":"58450641063","product_id":"44772308","variant_id":"77680850","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 09:35:29 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 09:35:29 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 09:35:29 [INFO]: Shopify Inventory id 48825176162526 2025-08-05 09:35:29 [INFO]: Shopify Location id 58450641063 2025-08-05 09:35:29 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 09:35:30 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T09:35:30Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 09:35:30 [INFO]: Change: available | Delta: -2 2025-08-05 09:35:30 [INFO]: Change: on_hand | Delta: -2 2025-08-05 09:35:30 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 09:35:30 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772308 and user_id = 14409 2025-08-05 09:35:30 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680850 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 09:35:30 [INFO]: updateIdsQuantity -> ["77680850"] 2025-08-05 09:35:30 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-05 09:35:30 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77680850 THEN 0 END, quantityflag = CASE WHEN id = 77680850 THEN 0 END WHERE user_id = 14409 AND id IN (77680850) 2025-08-05 09:35:30 [INFO]: QUANTITY Updated IDs: 77680850 2025-08-05 09:35:30 [INFO]: Successfully processed data for user 14409 2025-08-05 09:35:30 [INFO]: Execution Started 2025-08-05 09:35:30 [INFO]: Execution Finished 2025-08-05 09:40:02 [INFO]: Execution Started 2025-08-05 09:40:02 [INFO]: old server sucessfully connected 2025-08-05 09:40:02 [INFO]: sqs client sucess created 2025-08-05 09:40:03 [INFO]: Number of messages in the queue: 2 2025-08-05 09:40:03 [INFO]: item found in queue is if condition 14409 2025-08-05 09:40:03 [INFO]: item found in queue is 14409 2025-08-05 09:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEB4+1N56i85dlB5OieYvAKMREdg//h+27vb/eqPJhsTZD3X1fW4HVtKEdjk/FTJG2rcvvl08EOh34KuGfpKLeKnaLa3p1qopBffxqvwlUZS97qTh6cckBTiN7Q1XZxt7kVJVjXXhisxJyYnpRL7Zi9RfRJu2m18oKZQAapXt4xWPg1j7mEGRUvSz0cXwtf1T+JYxc+dn3IDJ02xEssPv7/jlqqnvytugAzJYOOKZ56fAFK3RtQj2dfw5L4dafJAGAbdkB1pZ+/3w5KvT1AMmXGfE8Pqv2kKLEsym1Kt7dThG/jpOQa2m3JC4Vc9+KnHq87ireg3W1ovaUS6Pk6oitIGtJfrQ2fvdV2NVSQo7ID3y7aYYhc3B2sktJY9tq0IZQt4xCHizuePFZsmIbDn/eY+/rZyLadBoA8IM4y7BnaKTeptp7QHmiIJM20ZSsLuSOb 2025-08-05 09:40:04 [INFO]: item found in queue is if condition 14409 2025-08-05 09:40:04 [INFO]: item found in queue is 14409 2025-08-05 09:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBgc7+zKpiZHGvp7xqOD8zfoDyglc6jlAv5j0aR7iwqQR1QcyL8x1fEGNycQYRu0liOGE3khO/obxu57ZZY4pkex+JikFwCbQntnzVGp78FpYTC8r7wv5rBQX4JpyKeUt+3TJIn/MOwfx+TWd890qOUOTTyfc8A4qkdjUY3GVVJZfmAbzN767rvFdi0ZegonPxieE0BUvmeKAztdA1ajXYuadJphDEKDhYJ0sbl0+ijF4+23WlxHe0dBWsFzPxT/9/oefj4v6ia7FaqYv5X8xMKFQoPLWM9LNoJH9qlWOaZbowN5G+ruFV1BgEWK4Lgcnu8LuRoc7+QdIGHzXUqmj2mNsm2J4jLz/xCL2JV/ckuqvRER2e9V32BHckE5xXAHbVO7Ej3ARR72P/8qceT3iZusTAv8MAfSBOPAzv0GRLyhrCvq9AHcPToRoMs5GPcaqz 2025-08-05 09:40:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-05 09:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 09:40:04 [INFO]: inside itemsold and closed 14409 2025-08-05 09:40:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 09:40:06 [INFO]: autolink for user_id 14409 is 1 2025-08-05 09:40:06 [INFO]: Ebay item id :: 404900211947 exists in Database 2025-08-05 09:40:06 [INFO]: Item is reliested :: exists in Database 2025-08-05 09:40:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 09:40:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 09:40:06 [INFO]: inside itemsold and closed 14409 2025-08-05 09:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 09:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-05 09:40:07 [INFO]: Ebay item id :: 404900211947 exists in Database 2025-08-05 09:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-05 09:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 09:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 09:40:07 [INFO]: in processold action queue is array for {"44772317":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772317","ebayitemid":"404900211947","shopifyproductid":"8917746614494","variants":[{"price":"139.99","quantity":0,"weight":"2","shopifyproductid":"8917746614494","shopifyvariantid":"46726692602078","shopifyinventoryid":"48825179275486","shopifylocationid":"58450641063","product_id":"44772317","variant_id":"77680859","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 09:40:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 09:40:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 09:40:08 [INFO]: Shopify Inventory id 48825179275486 2025-08-05 09:40:08 [INFO]: Shopify Location id 58450641063 2025-08-05 09:40:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 09:40:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T09:40:08Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 09:40:08 [INFO]: Change: available | Delta: -2 2025-08-05 09:40:08 [INFO]: Change: on_hand | Delta: -2 2025-08-05 09:40:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 09:40:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772317 and user_id = 14409 2025-08-05 09:40:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680859 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 09:40:08 [INFO]: updateIdsQuantity -> ["77680859"] 2025-08-05 09:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-05 09:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77680859 THEN 0 END, quantityflag = CASE WHEN id = 77680859 THEN 0 END WHERE user_id = 14409 AND id IN (77680859) 2025-08-05 09:40:08 [INFO]: QUANTITY Updated IDs: 77680859 2025-08-05 09:40:08 [INFO]: Successfully processed data for user 14409 2025-08-05 09:40:08 [INFO]: Execution Started 2025-08-05 09:40:08 [INFO]: Execution Finished 2025-08-05 09:50:01 [INFO]: Execution Started 2025-08-05 09:50:01 [INFO]: old server sucessfully connected 2025-08-05 09:50:01 [INFO]: sqs client sucess created 2025-08-05 09:50:03 [INFO]: Number of messages in the queue: 5 2025-08-05 09:50:03 [INFO]: item found in queue is if condition 14409 2025-08-05 09:50:03 [INFO]: item found in queue is 14409 2025-08-05 09:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEB02+7mqF5RIJI7k2Bu0dAXvANSOVTC+GHRiRC34IapVZkybi3mI1uvxksn5qy8QhOPdkRkZE15lRJ30d6FZbYscg5ecZ4izU6MkYHPWxdXGx1SqwlqJh92+/BfPJGYC//bfe/8cIvzuFiUnoc7HS+2rdzvLJ8liimKao5aCo1VtaDTLP7rVs7MvqPLvKjZGd3quXQ3sz4xAuQ/oPa+hiZcNgGNyi9FrJoPM9USk50m7oxUwX7uX3qBJ+fnHRuDL56ABCTZjcvsxQ5T11fk3rJMgq8ZNABEL8ptDfR4tJOiHAK1NtOo+Xfk9Y645zvFin2mU3mcHrUUAuQICz7RNbJkoEkdw/pFbxiKyhzkwGTDJ9v3OoxMAQx2Lnamf4X3DkOcXXT4hHJ1Sr2X5tXbuAwGFZdfeiZjJOTRKNEvl5h8gtwqwDfqv0A4uSmRwguhjZ4 2025-08-05 09:50:03 [INFO]: item found in queue is if condition 14409 2025-08-05 09:50:03 [INFO]: item found in queue is 14409 2025-08-05 09:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBPWjGJvd4Kws0CdOTzfH1shTRhVbjUy0hNvmqXTWjaDLvPOo8mZKmHAd7FK/683BPvjyGDdq4+F4bWCu6v59WEdlhjSs8euYSYuSgJMb+Zu2GzF1dYGuI0Ecba4hUm24ipEJBegCMa3KS5feuFlyC7f8d1oL/DjLuygkyEB5FlBRonND7benYGm+vdzS/SD7McE0Mh2zJlGJ214dVffT5GZyNCpGb4ZG8Xr97CDzNt3wM2h+xGBpryKpV2R2phJuM43T6Ng8Y9J4GPInlxFBhERYjEt18f8+dzhoP1A1h8SKOogegRM8Kdp3omHklFQyk5f2C4+8RwL0Yr8akQZYtlO0A8Gdf+FL31xZ0lr1x9jKi725hieEepS6i6oJOc95ZUUGJl2vs65OVr+oACJNw9dRRceruOtZ7grG3i0pEEGhvdFDbh322LjWypreAV9ie 2025-08-05 09:50:04 [INFO]: item found in queue is if condition 14409 2025-08-05 09:50:04 [INFO]: item found in queue is 14409 2025-08-05 09:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBc8GTT31yzaxn8vEcKguAPsxJehTYiHayYjAv1S2DMyrI4pnDut60caVgjdMvMMo/JgwBn7VzmH7kDcWckGRP7Jo+63GJnmda2kjoZVCVS6j2R/6RSVaa1wJSiehBRGsJuRbKdXqyu0xmyv6G3guVNM1o/v2w1Neavl3K04lEYzk2FEAHj2Fg9ir1MZKwu56VJOEsNaD0DQBq+1Mg6cfnj8AG/78DtbuUwkhNFIWdTyIIiFyc7Dv2Q14nSSk0d8kFGX7Y36wa1yy72piib/6sSlkSKfg+MDT+Ya03Vhrs0lPyDJwqDWOtNvMlxoSZeq1as8ikocC2qYM2jIZzKGwtPtWaC7pCCcN89/jfQv3QaaZrv1K/Bp3dgKbJBqlq4Di3rRx2sB9u/i7Elv1T4dQVT8TNRIegxpmkrNK3gOsbmQ5P6NWkTwG9d46EkqsSgm9N 2025-08-05 09:50:05 [INFO]: item found in queue is if condition 14409 2025-08-05 09:50:05 [INFO]: item found in queue is 14409 2025-08-05 09:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEBuR+WcQgvCExqkCfpKnlN1kD226ICd1OdJ3dkwIwJ+bZHtWSFAnbZhBXypOrKqdnnPgtqGhfML8+sbCwvGLH/oVM2LiNHvG6/CQqNed8vilAl8YHFM7rYoUpCSbMHcwDAUmYvjMXTw24vUXOdUVmPlwWcIVMWiLlYq4DsMjBrPybkqICg+An3rS1iO4YRnAS0NIOb1q31JGTXEJvewFxz225r5TeGH5kw3ZKg+onKxuOLKkK7Nhak1aljfSltaX2bBnCMNRb0X6TNCKCkUScZ6t6BTPMFYXcEjIJAqvznXxQkOtMKzIXJ4GweWai1HIfu30zFSInPuEjkjMYO0lswN3qZA7cSCgx3NOElCgolDB6g03ciPMUWMC97aigKnPNbqISVXwT/LV+OT22MwKQDGjyFLWDKeZjLK6CsAP1KSCZ1xI/x64lfIeuij8mzTDuZ 2025-08-05 09:50:05 [INFO]: item found in queue is if condition 14409 2025-08-05 09:50:05 [INFO]: item found in queue is 14409 2025-08-05 09:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEBJ8P/6qcZ2VY0jUuqhGaF8rjGWyxVpMWZk/9CyZWjooIwufC1jEEiokV1aW/UNr8J6bujW4yi/4ltv3Wvj9vedQMuYEpRG+l4c7RtiUU43fXmL2RXYRdlz8Gbtgn1Bxn+9AOSLkEyWzzSGT9z4H/sO+c1nj1lDw8FS/ldR0mvLmxNPLIB4T7fZTMnSZfCfktLfNAhRr2HQDsZBZRlRGO2wHhZX8sj6QSuR/sk9FtplRjLK3tN2WrdgUh6UU8BdbvInZ2f3mHoCmMXQrvhI0qtb9ekaEi9isvYXgGsuCXww+WFwE+/ZCSWOq3n8KGlv19MfABvBc/tVXHvZbgoIGSctmsN5I+GOTPIEquIGwJahhyoAhE/RfME1mlOQed87qWeOK4aJA5zGBtUKgEMGqSIcoOZRsyGKiQene8SUiaLlq6Wvo8aGYmMhkASlFsLZudt 2025-08-05 09:50:05 [INFO]: Processed 5 messages, reached the limit of 5. 2025-08-05 09:50:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 09:50:05 [INFO]: inside itemsold and closed 14409 2025-08-05 09:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 09:50:07 [INFO]: autolink for user_id 14409 is 1 2025-08-05 09:50:07 [INFO]: Ebay item id :: 226419929972 exists in Database 2025-08-05 09:50:07 [INFO]: Item is reliested :: exists in Database 2025-08-05 09:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 09:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 09:50:07 [INFO]: inside itemsold and closed 14409 2025-08-05 09:50:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 09:50:09 [INFO]: autolink for user_id 14409 is 1 2025-08-05 09:50:09 [INFO]: Ebay item id :: 226082407302 exists in Database 2025-08-05 09:50:09 [INFO]: Item is reliested :: exists in Database 2025-08-05 09:50:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 09:50:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 09:50:09 [INFO]: inside itemsold and closed 14409 2025-08-05 09:50:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 09:50:10 [INFO]: autolink for user_id 14409 is 1 2025-08-05 09:50:10 [INFO]: Ebay item id :: 326216613547 exists in Database 2025-08-05 09:50:10 [INFO]: Item is reliested :: exists in Database 2025-08-05 09:50:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 09:50:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 09:50:10 [INFO]: inside itemsold and closed 14409 2025-08-05 09:50:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 09:50:12 [INFO]: autolink for user_id 14409 is 1 2025-08-05 09:50:12 [INFO]: Ebay item id :: 226082406137 exists in Database 2025-08-05 09:50:12 [INFO]: Item is reliested :: exists in Database 2025-08-05 09:50:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 09:50:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 09:50:12 [INFO]: inside itemsold and closed 14409 2025-08-05 09:50:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 09:50:14 [INFO]: autolink for user_id 14409 is 1 2025-08-05 09:50:14 [INFO]: Ebay item id :: 226378126293 exists in Database 2025-08-05 09:50:14 [INFO]: Item is reliested :: exists in Database 2025-08-05 09:50:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 09:50:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 09:50:14 [INFO]: in processold action queue is array for {"44681386":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44681386","ebayitemid":"226419929972","shopifyproductid":"8717904216286","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8717904216286","shopifyvariantid":"45988639670494","shopifyinventoryid":"48087400841438","shopifylocationid":"","product_id":"44681386","variant_id":"77586611","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44734625":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44734625","ebayitemid":"226082407302","shopifyproductid":"8379316306142","variants":[{"price":"17.99","quantity":0,"weight":"2","shopifyproductid":"8379316306142","shopifyvariantid":"45098822140126","shopifyinventoryid":"47196685435102","shopifylocationid":"","product_id":"44734625","variant_id":"77642518","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44687503":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44687503","ebayitemid":"326216613547","shopifyproductid":"8707757375710","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8707757375710","shopifyvariantid":"45965172637918","shopifyinventoryid":"48063909822686","shopifylocationid":"","product_id":"44687503","variant_id":"77592728","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44734623":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44734623","ebayitemid":"226082406137","shopifyproductid":"8379317158110","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8379317158110","shopifyvariantid":"45098829021406","shopifyinventoryid":"47196692316382","shopifylocationid":"","product_id":"44734623","variant_id":"77642516","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44688438":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44688438","ebayitemid":"226378126293","shopifyproductid":"8705197375710","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8705197375710","shopifyvariantid":"45959194443998","shopifyinventoryid":"48057828606174","shopifylocationid":"","product_id":"44688438","variant_id":"77593684","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 09:50:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 09:50:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 09:50:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 09:50:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 09:50:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 09:50:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 09:50:14 [INFO]: Shopify Inventory id 48087400841438 2025-08-05 09:50:14 [INFO]: Shopify Location id 58450641063 2025-08-05 09:50:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 09:50:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T09:50:14Z","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 09:50:14 [INFO]: Change: available | Delta: -1 2025-08-05 09:50:14 [INFO]: Change: on_hand | Delta: -1 2025-08-05 09:50:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 09:50:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44681386 and user_id = 14409 2025-08-05 09:50:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77586611 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 09:50:14 [INFO]: Shopify Inventory id 47196685435102 2025-08-05 09:50:14 [INFO]: Shopify Location id 58450641063 2025-08-05 09:50:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 09:50:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T09:50:14Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 09:50:14 [INFO]: Change: available | Delta: -2 2025-08-05 09:50:14 [INFO]: Change: on_hand | Delta: -2 2025-08-05 09:50:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 09:50:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44734625 and user_id = 14409 2025-08-05 09:50:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77642518 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 09:50:14 [INFO]: Shopify Inventory id 48063909822686 2025-08-05 09:50:14 [INFO]: Shopify Location id 58450641063 2025-08-05 09:50:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 09:50:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T09:50: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-05 09:50:15 [INFO]: Change: available | Delta: -1 2025-08-05 09:50:15 [INFO]: Change: on_hand | Delta: -1 2025-08-05 09:50:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 09:50:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44687503 and user_id = 14409 2025-08-05 09:50:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77592728 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 09:50:15 [INFO]: Shopify Inventory id 47196692316382 2025-08-05 09:50:15 [INFO]: Shopify Location id 58450641063 2025-08-05 09:50:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 09:50:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T09:50: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-05 09:50:15 [INFO]: Change: available | Delta: -1 2025-08-05 09:50:15 [INFO]: Change: on_hand | Delta: -1 2025-08-05 09:50:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 09:50:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44734623 and user_id = 14409 2025-08-05 09:50:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77642516 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 09:50:15 [INFO]: Shopify Inventory id 48057828606174 2025-08-05 09:50:15 [INFO]: Shopify Location id 58450641063 2025-08-05 09:50:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 09:50:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T09:50: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-05 09:50:15 [INFO]: Change: available | Delta: -1 2025-08-05 09:50:15 [INFO]: Change: on_hand | Delta: -1 2025-08-05 09:50:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 09:50:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44688438 and user_id = 14409 2025-08-05 09:50:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77593684 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 09:50:15 [INFO]: updateIdsQuantity -> ["77586611","77642518","77592728","77642516","77593684"] 2025-08-05 09:50:15 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 5. Affected rows: 5 2025-08-05 09:50:15 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77586611 THEN 0 WHEN id = 77642518 THEN 0 WHEN id = 77592728 THEN 0 WHEN id = 77642516 THEN 0 WHEN id = 77593684 THEN 0 END, quantityflag = CASE WHEN id = 77586611 THEN 0 WHEN id = 77642518 THEN 0 WHEN id = 77592728 THEN 0 WHEN id = 77642516 THEN 0 WHEN id = 77593684 THEN 0 END WHERE user_id = 14409 AND id IN (77586611,77642518,77592728,77642516,77593684) 2025-08-05 09:50:15 [INFO]: QUANTITY Updated IDs: 77586611, 77642518, 77592728, 77642516, 77593684 2025-08-05 09:50:15 [INFO]: Successfully processed data for user 14409 2025-08-05 09:50:15 [INFO]: Execution Started 2025-08-05 09:50:15 [INFO]: Execution Finished