2025-08-10 23:00:01 [INFO]: Execution Started 2025-08-10 23:00:01 [INFO]: old server sucessfully connected 2025-08-10 23:00:01 [INFO]: sqs client sucess created 2025-08-10 23:00:02 [INFO]: Number of messages in the queue: 1 2025-08-10 23:00:03 [INFO]: item found in queue is if condition 14409 2025-08-10 23:00:03 [INFO]: item found in queue is 14409 2025-08-10 23:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBLj4GG+pvyG++YLolkLpbCumB2sJbhwrfWIg7ilxsnk7MG+KZmkqCxOfHP2zvmBsi0pxOa4J5dV3e0+leR521C/8VpI2xdkDLmqEBBpdnj8BqrPtncPnEewcV5Zm/DNctL0g/3nVDKtPkbdCsBhkl9fherbso9uBUtzIUrSudWOCqNmHFIleo3h/RU0eFPuM8Emf0CnlBpya5NVxPhsxDb14jPgfWW7k7/JSdaimiar6r3IHTNVihGiLFBCylcVRlQo4SKaYm/K8PD/uiDr02lhiDojiIQwLCwQx7Z3osYL7N/Wu64V15BNUjzcOnKJI97od78Zu7gdu2Io3D0ZT5sKt6/VJTrEQ5/YLT3f39rY6ZxCT2MvPxgKZKdBhyHfw4svKH7alKpNY3+2j5VyNRDWM0yjQBg45uOLIGDedlWzXJXCvLFNDX0vhQLSHxTa02 2025-08-10 23:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-10 23:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-10 23:00:03 [INFO]: inside itemsold and closed 14409 2025-08-10 23:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-10 23:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-10 23:00:05 [INFO]: Ebay item id :: 306413752139 exists in Database 2025-08-10 23:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-10 23:00:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-10 23:00:05 [INFO]: in processold action queue is array for {"45293090":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45293090","ebayitemid":"306413752139","deleted":1}}} 2025-08-10 23:00:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-10 23:00:06 [INFO]: productIds WHich are having null productid -> [45293090] 2025-08-10 23:00:06 [INFO]: ebayItemIds WHich are not imported-> ["306413752139"] 2025-08-10 23:00:06 [INFO]: Entered in bulkUpdateProducts function 2025-08-10 23:00:06 [INFO]: Transaction started for bulkUpdateProducts 2025-08-10 23:00:06 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45293090) 2025-08-10 23:00:06 [INFO]: Query executed successfully. Affected rows: 0 2025-08-10 23:00:06 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-10 23:00:06 [INFO]: Transaction committed successfully. 2025-08-10 23:00:06 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-10 23:00:06 [INFO]: Successfully processed data for user 14409 2025-08-10 23:00:06 [INFO]: Execution Started 2025-08-10 23:00:06 [INFO]: Execution Finished 2025-08-10 23:10:02 [INFO]: Execution Started 2025-08-10 23:10:02 [INFO]: old server sucessfully connected 2025-08-10 23:10:02 [INFO]: sqs client sucess created 2025-08-10 23:10:03 [INFO]: Number of messages in the queue: 0 2025-08-10 23:10:23 [INFO]: Execution Started 2025-08-10 23:10:23 [INFO]: Execution Finished 2025-08-10 23:20:01 [INFO]: Execution Started 2025-08-10 23:20:01 [INFO]: old server sucessfully connected 2025-08-10 23:20:01 [INFO]: sqs client sucess created 2025-08-10 23:20:02 [INFO]: Number of messages in the queue: 0 2025-08-10 23:20:22 [INFO]: Execution Started 2025-08-10 23:20:22 [INFO]: Execution Finished 2025-08-10 23:30:02 [INFO]: Execution Started 2025-08-10 23:30:02 [INFO]: old server sucessfully connected 2025-08-10 23:30:02 [INFO]: sqs client sucess created 2025-08-10 23:30:03 [INFO]: Number of messages in the queue: 1 2025-08-10 23:30:03 [INFO]: item found in queue is if condition 14409 2025-08-10 23:30:03 [INFO]: item found in queue is 14409 2025-08-10 23:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBP9DbqfIar8nrlCAhclGTosJV2wshu+jLId8rQFVka9/P8gp8CJAvqWotn0cs0e2ZyH72WS96tDwewWRHWfqDyNv/C+g+f3n4r4Ivhx8DNCy+8cpsZuO9h0KkyXt2kgQ2lCBQsbOiRv8nKC39zyHCqNF8D9lBm9q9eAU7UzI6JgWIe1wWsxFWZZdvO8CTqj9g1CTJFC6tP0TNLawxekhYlZGtMZmxMQN0ZiiJ8YkRPWsCxJsE+ypeWEfR01dG8e/0GG7QXbKT7LkjB5eu7Ijz0vu4m04YfBFmjz2VJFmToxVvhIUudjvRxO6p1aUnD3RRChHOksgW6UFegXP8CFj8ftXMeaiw/V0DDO0B88/K70a94g7hD/MwTYWa2uAMPVyxtdu6TxfrVThOq+sDtRZYi5e3YLAEp5TvLM7Gr7ncL8hBZMWRk49Bcv2S/eHusl3e 2025-08-10 23:30:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-10 23:30:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-10 23:30:03 [INFO]: inside itemsold and closed 14409 2025-08-10 23:30:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-10 23:30:05 [INFO]: autolink for user_id 14409 is 1 2025-08-10 23:30:05 [INFO]: Ebay item id :: 406107116239 exists in Database 2025-08-10 23:30:05 [INFO]: Item is reliested :: exists in Database 2025-08-10 23:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-10 23:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-10 23:30:05 [INFO]: in processold action queue is array for {"45313435":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313435","ebayitemid":"406107116239","shopifyproductid":"8981088534750","variants":[{"price":"34.99","quantity":0,"weight":"0.5","shopifyproductid":"8981088534750","shopifyvariantid":"47332687446238","shopifyinventoryid":"49444492181726","shopifylocationid":"58450641063","product_id":"45313435","variant_id":"78265948","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-10 23:30:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-10 23:30:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-10 23:30:05 [INFO]: Shopify Inventory id 49444492181726 2025-08-10 23:30:05 [INFO]: Shopify Location id 58450641063 2025-08-10 23:30:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-10 23:30:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-10T23:30: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-10 23:30:05 [INFO]: Change: available | Delta: -1 2025-08-10 23:30:05 [INFO]: Change: on_hand | Delta: -1 2025-08-10 23:30:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-10 23:30:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313435 and user_id = 14409 2025-08-10 23:30:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265948 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-10 23:30:05 [INFO]: updateIdsQuantity -> ["78265948"] 2025-08-10 23:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-10 23:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78265948 THEN 0 END, quantityflag = CASE WHEN id = 78265948 THEN 0 END WHERE user_id = 14409 AND id IN (78265948) 2025-08-10 23:30:05 [INFO]: QUANTITY Updated IDs: 78265948 2025-08-10 23:30:05 [INFO]: Successfully processed data for user 14409 2025-08-10 23:30:05 [INFO]: Execution Started 2025-08-10 23:30:05 [INFO]: Execution Finished 2025-08-10 23:40:01 [INFO]: Execution Started 2025-08-10 23:40:01 [INFO]: old server sucessfully connected 2025-08-10 23:40:01 [INFO]: sqs client sucess created 2025-08-10 23:40:02 [INFO]: Number of messages in the queue: 2 2025-08-10 23:40:03 [INFO]: item found in queue is if condition 14409 2025-08-10 23:40:03 [INFO]: item found in queue is 14409 2025-08-10 23:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBZuc8qlkuvJQ2KNZyREJLoUg7J/lon2m7z4JVor3mQ+J3KKaptfAPa0ylaQoJIQa8f1ojPmekItKflnYfCViU8SaLlt+jGVA4H9cmcUV6yzBB0aTihHGskMrMvig9c5riwKoPTdqP9ZHbICrsQ+tjQMYXOFMaZhQhypf3/bXeT1FRAhDt7YJzUGLpi3OdYiHLtn+OOoEUs2k9SyXagSIytEF1QgyOqJyOh59FtmiBxkNqbfzL34yAVc7N1Ep9yWGv/cfuxJParwGe9bOfgZJx0C3klNsxiZ1L+R2ebnosn7FEPjZl4eNRJwP1PLVBTFxIsl9mWgj8ESVnianlvftIY1nXTvrxHuR3kTxRrtBgHKe+OtjcyX5r52fog6LkbXzxeViMtpApS8appB8io9a49nqBnQIMVvPT5xUDmeh3+lvWxhiHlxvXitOVlNs1qCUw 2025-08-10 23:40:03 [INFO]: item found in queue is if condition 14409 2025-08-10 23:40:03 [INFO]: item found in queue is 14409 2025-08-10 23:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEB9bF899BGa5GLurN8c7/P8cU8MFCcWGK8XGJEZmHOVB1RbgR+ApCWMsoJ771ZOGQmejrc1GMQbMDxfy/csNpsdrwNyt6dw1Uc1S//MGTa2upGGY55Rv824Ry0NMVnOGVRzFSHAbRm2UttbRsmgVIKuW+/llOdDEu7lHbGVv10M2XLCjG633ZsXeVEIGe6fWOiO3/ePETi2LxKHhwfhqS5ivLp3XX3rSfeO0DZNTuMVTOWnkHb+vPuOUJ7FW/oG13tDZg8Rb8IgE9tkKbH9WcIij+/kV419GBIgjPK58MJcHAggZ8XkU6U19D1Dkh1pAT7IuT9J+JSUGMMje2OdCUMd5WsjumMwIF2szGts8zKiBrV2CQtcFn8zy/U2WSJz2T0x/Q0u+PG7kIEcbmw7A0z+YpxaeEv4L1Zln5vB2QB1yzdHVjRYaZG9t/ImXIRwLX1 2025-08-10 23:40:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-10 23:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-10 23:40:03 [INFO]: inside itemsold and closed 14409 2025-08-10 23:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-10 23:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-10 23:40:05 [INFO]: Ebay item id :: 226907634987 exists in Database 2025-08-10 23:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-10 23:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-10 23:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-10 23:40:05 [INFO]: inside itemsold and closed 14409 2025-08-10 23:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-10 23:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-10 23:40:07 [INFO]: Ebay item id :: 286548692510 exists in Database 2025-08-10 23:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-10 23:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-10 23:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-10 23:40:07 [INFO]: in processold action queue is array for {"45313644":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313644","ebayitemid":"226907634987","shopifyproductid":"8982489202910","variants":[{"price":"84.99","quantity":0,"weight":"4","shopifyproductid":"8982489202910","shopifyvariantid":"47397152227550","shopifyinventoryid":"49508976689374","shopifylocationid":"58450641063","product_id":"45313644","variant_id":"78266157","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44575501":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44575501","ebayitemid":"286548692510","shopifyproductid":"8156896952542","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8156896952542","shopifyvariantid":"44416491880670","shopifyinventoryid":"46514246222046","shopifylocationid":"","product_id":"44575501","variant_id":"77468208","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-10 23:40:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-10 23:40:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-10 23:40:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-10 23:40:07 [INFO]: Shopify Inventory id 49508976689374 2025-08-10 23:40:07 [INFO]: Shopify Location id 58450641063 2025-08-10 23:40:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-10 23:40:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-10T23:40: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-10 23:40:07 [INFO]: Change: available | Delta: -1 2025-08-10 23:40:07 [INFO]: Change: on_hand | Delta: -1 2025-08-10 23:40:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-10 23:40:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313644 and user_id = 14409 2025-08-10 23:40:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266157 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-10 23:40:07 [INFO]: Shopify Inventory id 46514246222046 2025-08-10 23:40:07 [INFO]: Shopify Location id 58450641063 2025-08-10 23:40:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-10 23:40:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-10 23:40:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-10 23:40:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44575501 and user_id = 14409 2025-08-10 23:40:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77468208 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-10 23:40:07 [INFO]: updateIdsQuantity -> ["78266157","77468208"] 2025-08-10 23:40:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-10 23:40:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78266157 THEN 0 WHEN id = 77468208 THEN 0 END, quantityflag = CASE WHEN id = 78266157 THEN 0 WHEN id = 77468208 THEN 0 END WHERE user_id = 14409 AND id IN (78266157,77468208) 2025-08-10 23:40:07 [INFO]: QUANTITY Updated IDs: 78266157, 77468208 2025-08-10 23:40:07 [INFO]: Successfully processed data for user 14409 2025-08-10 23:40:07 [INFO]: Execution Started 2025-08-10 23:40:07 [INFO]: Execution Finished 2025-08-10 23:50:01 [INFO]: Execution Started 2025-08-10 23:50:01 [INFO]: old server sucessfully connected 2025-08-10 23:50:01 [INFO]: sqs client sucess created 2025-08-10 23:50:03 [INFO]: Number of messages in the queue: 1 2025-08-10 23:50:03 [INFO]: item found in queue is if condition 14409 2025-08-10 23:50:03 [INFO]: item found in queue is 14409 2025-08-10 23:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBFeBGkNNvoTNpuZqC9MCJXXCf9G+jGqfMLoWO6nTDgsm4ZIhfHNR5ZxND8ZHxtBIgkKsJbfS3HDohiVKwYCh1dNKhAwsHirFY7NkOYgTZb/HLqY2hrPlHbfKxk1Kb8M7Wko/o5ThvePuepwucIhUf36memc5AK4xiidsO+6PCosPK+nny9chRhQgICUxKglLCsTa8hh5Rk07dCKd30jf0hRzqNr544bmP/wcqbueRCifp9EGfMSP+O2mDDWZvjTuSlFj7kUNF/FiuP2m+0qMstjFL2E1g/LdwUVKq85Z8P8ZMuN0qQC7OvJrzyuJoR+SvBTv6SjKSJYsZ3bMKnvrMJh/GbDmo+2U0txfPZ4MqYMWIghAvXVIomwb7V9h3JhfjOtMubeAHH0Iz1EgpLJzlCWN5ZPzulb0FYzDURZ4v9KQmbgJTLsX1fwfzL/uBnjE3 2025-08-10 23:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-10 23:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-10 23:50:03 [INFO]: inside itemsold and closed 14409 2025-08-10 23:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-10 23:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-10 23:50:05 [INFO]: Ebay item id :: 326428787149 exists in Database 2025-08-10 23:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-10 23:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-10 23:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-10 23:50:05 [INFO]: in processold action queue is array for {"44736782":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44736782","ebayitemid":"326428787149","shopifyproductid":"8811504533726","variants":[{"price":"34.99","quantity":0,"weight":"0.75","shopifyproductid":"8811504533726","shopifyvariantid":"46274763915486","shopifyinventoryid":"48375545037022","shopifylocationid":"","product_id":"44736782","variant_id":"77644719","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-10 23:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-10 23:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-10 23:50:05 [INFO]: Shopify Inventory id 48375545037022 2025-08-10 23:50:05 [INFO]: Shopify Location id 58450641063 2025-08-10 23:50:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-10 23:50: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-10 23:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-10 23:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44736782 and user_id = 14409 2025-08-10 23:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77644719 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-10 23:50:05 [INFO]: updateIdsQuantity -> ["77644719"] 2025-08-10 23:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-10 23:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77644719 THEN 0 END, quantityflag = CASE WHEN id = 77644719 THEN 0 END WHERE user_id = 14409 AND id IN (77644719) 2025-08-10 23:50:05 [INFO]: QUANTITY Updated IDs: 77644719 2025-08-10 23:50:05 [INFO]: Successfully processed data for user 14409 2025-08-10 23:50:05 [INFO]: Execution Started 2025-08-10 23:50:05 [INFO]: Execution Finished