2025-08-11 23:00:01 [INFO]: Execution Started 2025-08-11 23:00:01 [INFO]: old server sucessfully connected 2025-08-11 23:00:01 [INFO]: sqs client sucess created 2025-08-11 23:00:02 [INFO]: Number of messages in the queue: 0 2025-08-11 23:00:22 [INFO]: Execution Started 2025-08-11 23:00:22 [INFO]: Execution Finished 2025-08-11 23:10:01 [INFO]: Execution Started 2025-08-11 23:10:01 [INFO]: old server sucessfully connected 2025-08-11 23:10:01 [INFO]: sqs client sucess created 2025-08-11 23:10:02 [INFO]: Number of messages in the queue: 0 2025-08-11 23:10:23 [INFO]: Execution Started 2025-08-11 23:10:23 [INFO]: Execution Finished 2025-08-11 23:17:59 [INFO]: Execution Started 2025-08-11 23:17:59 [INFO]: old server sucessfully connected 2025-08-11 23:18:00 [INFO]: sqs client sucess created 2025-08-11 23:18:01 [INFO]: Number of messages in the queue: 0 2025-08-11 23:18:21 [INFO]: Execution Started 2025-08-11 23:18:21 [INFO]: Execution Finished 2025-08-11 23:20:01 [INFO]: Execution Started 2025-08-11 23:20:01 [INFO]: old server sucessfully connected 2025-08-11 23:20:01 [INFO]: sqs client sucess created 2025-08-11 23:20:02 [INFO]: Number of messages in the queue: 1 2025-08-11 23:20:02 [INFO]: item found in queue is if condition 14409 2025-08-11 23:20:02 [INFO]: item found in queue is 14409 2025-08-11 23:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBJ5Cw7RqZJUDvHKc4KHyvfepUDZ/ArpGBIxiuahY9QZPA2a1fnzLX/5ZwNRTVmta5xiXarDIuSvqc5fo2y+k3q4X3TKZEDI/8ltxNBEOAJrFHlhTW5iQwnexBgkQwvSocDH4MVJbidwhzEKG87rHOqRE3/3YOW89UkNDkDxJgql7dhobAUOEDHo8dGnhVqEWUwgCiDchv0TiJjbUeGjg5sZxuzJE5FQh+2nnYBLiheHA08qFWr2NOdJN9xfiDA++3dPd/r22V0HWF953L83en0j/BtNnSPIp8OzzoblX4VghAzIBxfjusGHAQ+RqKA21us2GblK8CAiX/eRyuBkk18Z1LEl4C1hxnQVCCFtPnYOUkFHAXAig6/DXh6QjHoh7S9UTt+jVL0i0fcbCb5Mynto22eQPzSYZjk6QnsSF43c2nJQKibOwIDz5sFItSEwpI 2025-08-11 23:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-11 23:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 23:20:03 [INFO]: inside itemsold and closed 14409 2025-08-11 23:20:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 23:20:04 [INFO]: autolink for user_id 14409 is 1 2025-08-11 23:20:04 [INFO]: Ebay item id :: 255946754309 exists in Database 2025-08-11 23:20:04 [INFO]: Item is reliested :: exists in Database 2025-08-11 23:20:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 23:20:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 23:20:04 [INFO]: in processold action queue is array for {"44681398":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44681398","ebayitemid":"255946754309","shopifyproductid":"7940045242590","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"7940045242590","shopifyvariantid":"43933505519838","shopifyinventoryid":"46029932921054","shopifylocationid":"","product_id":"44681398","variant_id":"77586623","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 23:20:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 23:20:04 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 23:20:04 [INFO]: Shopify Inventory id 46029932921054 2025-08-11 23:20:04 [INFO]: Shopify Location id 58450641063 2025-08-11 23:20:04 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 23:20:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T23:20:04Z","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-11 23:20:05 [INFO]: Change: available | Delta: -1 2025-08-11 23:20:05 [INFO]: Change: on_hand | Delta: -1 2025-08-11 23:20:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 23:20:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44681398 and user_id = 14409 2025-08-11 23:20:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77586623 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 23:20:05 [INFO]: updateIdsQuantity -> ["77586623"] 2025-08-11 23:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 23:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77586623 THEN 0 END, quantityflag = CASE WHEN id = 77586623 THEN 0 END WHERE user_id = 14409 AND id IN (77586623) 2025-08-11 23:20:05 [INFO]: QUANTITY Updated IDs: 77586623 2025-08-11 23:20:05 [INFO]: Successfully processed data for user 14409 2025-08-11 23:20:05 [INFO]: Execution Started 2025-08-11 23:20:05 [INFO]: Execution Finished 2025-08-11 23:30:02 [INFO]: Execution Started 2025-08-11 23:30:02 [INFO]: old server sucessfully connected 2025-08-11 23:30:02 [INFO]: sqs client sucess created 2025-08-11 23:30:03 [INFO]: Number of messages in the queue: 0 2025-08-11 23:30:23 [INFO]: Execution Started 2025-08-11 23:30:23 [INFO]: Execution Finished 2025-08-11 23:40:01 [INFO]: Execution Started 2025-08-11 23:40:01 [INFO]: old server sucessfully connected 2025-08-11 23:40:01 [INFO]: sqs client sucess created 2025-08-11 23:40:02 [INFO]: Number of messages in the queue: 1 2025-08-11 23:40:03 [INFO]: item found in queue is if condition 14409 2025-08-11 23:40:03 [INFO]: item found in queue is 14409 2025-08-11 23:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBm3wxj8gUfuFmBma5QaUkqd6x1fa2Vv8a+Vtn1AlJke7taD8MQTncXPBmdSqNgRVZ97chk7GWr6Ycsu0CVQRkB91bZgq1sWM/pQA38sUPQrQr3AXaND8KI+i8LinhyeIIu6nRaI66pqDzcPpxy+U5id+apuEteIWhW1VcGK1gP6QIP+LO7HsgafmFUq6aJs8MP+Fjht0pS0J02qP7Vu5QT8ZZMbxzBe7frress7fnAFobZGbVnGhG/svVZotJfw6Od+TksaOSg6HiwmuED07qZ+yWXlXz0PWXnbIaxJj4/wPzSFmV4c9QjZTlCRElB/k1hQtV61+Z7Wnogu7w7JWRwIfawhMCTCTSnrGwX4TWq8so6cm6R8oBd3Wck6yvQEwxKcXEBoJY7Vf2xDNWaSgV8wH/k58XJRAYJd+ZX7q/fyUDUzO3KiKDppjEksiCIRNU 2025-08-11 23:40:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-11 23:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 23:40:03 [INFO]: inside itemsold and closed 14409 2025-08-11 23:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 23:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-11 23:40:05 [INFO]: Ebay item id :: 226006070112 exists in Database 2025-08-11 23:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-11 23:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 23:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 23:40:05 [INFO]: in processold action queue is array for {"44652032":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44652032","ebayitemid":"226006070112","shopifyproductid":"8286165369054","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8286165369054","shopifyvariantid":"44807066616030","shopifyinventoryid":"46905094045918","shopifylocationid":"","product_id":"44652032","variant_id":"77557221","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 23:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 23:40:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 23:40:05 [INFO]: Shopify Inventory id 46905094045918 2025-08-11 23:40:05 [INFO]: Shopify Location id 58450641063 2025-08-11 23:40:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 23:40: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-11 23:40:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 23:40:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44652032 and user_id = 14409 2025-08-11 23:40:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77557221 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 23:40:05 [INFO]: updateIdsQuantity -> ["77557221"] 2025-08-11 23:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 23:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77557221 THEN 0 END, quantityflag = CASE WHEN id = 77557221 THEN 0 END WHERE user_id = 14409 AND id IN (77557221) 2025-08-11 23:40:05 [INFO]: QUANTITY Updated IDs: 77557221 2025-08-11 23:40:05 [INFO]: Successfully processed data for user 14409 2025-08-11 23:40:05 [INFO]: Execution Started 2025-08-11 23:40:05 [INFO]: Execution Finished 2025-08-11 23:50:01 [INFO]: Execution Started 2025-08-11 23:50:01 [INFO]: old server sucessfully connected 2025-08-11 23:50:01 [INFO]: sqs client sucess created 2025-08-11 23:50:02 [INFO]: Number of messages in the queue: 1 2025-08-11 23:50:03 [INFO]: item found in queue is if condition 14409 2025-08-11 23:50:03 [INFO]: item found in queue is 14409 2025-08-11 23:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBoJ53yFn1k6QHYvmxstRkXRyxQo/TfNLOVP5iMPDzn5PbGNyTMvS94QqffcV1egHXncRu1fdD+fH/goO9ZbzjWFXMzlExiz/NNRcb/LfeoseTEn2xAWE4MHJ1U5qQz8/wRSuVRnre0b6s7SuHRa9MNSFT7hsu5aWtcVIi6gEKnxMQ+c2unQXu6Y5a0RZBy9TXFH/DT1MYlZL3TepFdu5L0hS+iwTT6EBqWPUjBpl49qC5p2pC0HCj7DFievb0G0DyOsQ6y3vQVHoXOlL5gqs3jX8VY23m+j7/Fwwb89ApAavIcMqbmIV+cDtcXRlSzQFAY7j2T/ZNAuORYOp4fNx/snz0q/Qw9lVs4dMoUYBHFXus5P0b2S5pww/HyhIGCszw/omc8opDYyEweSaEV7zh4hwPifBd+QDCsNvVD6HA8QCNTJqBnT7rZNyZiKzTmSzW 2025-08-11 23:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-11 23:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 23:50:03 [INFO]: inside itemsold and closed 14409 2025-08-11 23:50:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 23:50:04 [INFO]: autolink for user_id 14409 is 1 2025-08-11 23:50:04 [INFO]: Ebay item id :: 256921283856 exists in Database 2025-08-11 23:50:04 [INFO]: Item is reliested :: exists in Database 2025-08-11 23:50:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 23:50:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 23:50:04 [INFO]: in processold action queue is array for {"44855911":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44855911","ebayitemid":"256921283856","shopifyproductid":"8927151096030","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8927151096030","shopifyvariantid":"46846075404510","shopifyinventoryid":"48956633743582","shopifylocationid":"58450641063","product_id":"44855911","variant_id":"77766870","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 23:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 23:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 23:50:05 [INFO]: Shopify Inventory id 48956633743582 2025-08-11 23:50:05 [INFO]: Shopify Location id 58450641063 2025-08-11 23:50:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 23:50:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T23:50: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-11 23:50:05 [INFO]: Change: available | Delta: -1 2025-08-11 23:50:05 [INFO]: Change: on_hand | Delta: -1 2025-08-11 23:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 23:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44855911 and user_id = 14409 2025-08-11 23:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77766870 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 23:50:05 [INFO]: updateIdsQuantity -> ["77766870"] 2025-08-11 23:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 23:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77766870 THEN 0 END, quantityflag = CASE WHEN id = 77766870 THEN 0 END WHERE user_id = 14409 AND id IN (77766870) 2025-08-11 23:50:05 [INFO]: QUANTITY Updated IDs: 77766870 2025-08-11 23:50:05 [INFO]: Successfully processed data for user 14409 2025-08-11 23:50:05 [INFO]: Execution Started 2025-08-11 23:50:05 [INFO]: Execution Finished