2025-08-04 18:00:02 [INFO]: Execution Started 2025-08-04 18:00:02 [INFO]: old server sucessfully connected 2025-08-04 18:00:02 [INFO]: sqs client sucess created 2025-08-04 18:00:03 [INFO]: Number of messages in the queue: 5 2025-08-04 18:00:03 [INFO]: item found in queue is if condition 14409 2025-08-04 18:00:03 [INFO]: item found in queue is 14409 2025-08-04 18:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEB6enDgbSOgatu3my5tbxZjGt36FBQlqJzJIfk9/WXQrZocmxKdM3gbnxLaTuIq8BXiwqZx6f7/PynjHtAu/iEZUHWI7SP55J/ZoyKUG3+Bny+8A2CH3Wn5ntFMXxvnkCRBsjs3Kn9ztMzT7ytGKnD2i9IPkZDsf2ZOHYqUN6p2HJcR6NljgjJWY1RIxJt0aQ7ql6i9fF96BbXZ3k7KGNsmGKY49qCnAmJAV8QCnxdc/ONMyerqB1bmzn0DBERZsh8HqmD77Oi/BxBckl+mxSM7cx3a9HDkC+7dyg9V3buMp+qtmpvE5xTrGsvj2BonTbru2y3EpvMTq1CL0ctEr0BV5zB9EGBRXZPfdditA+Fttvu2oKkceS5bPj8DF14CZWkaEIJQAjGm05ztLMMnE+1CR3hrUvoZFltL8v0Uaj/UnAe0055BU6Hozq2ddG5wy/7 2025-08-04 18:00:04 [INFO]: item found in queue is if condition 14409 2025-08-04 18:00:04 [INFO]: item found in queue is 14409 2025-08-04 18:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBngVaIm61v/XJJIhk7QQuxZWY3rcZiOkXI2mnzMRDvE1nSEVGxK0HGMLB5TbD2HbJI6Ak4je5HCxSfKz0Yi/Vem3YTU5muppYclDPfhT+5niMr9vim5VmFZGSQrl0jfF5vwTkIhLW3z2s+m5qPHeWtBqQIiB6c0Oc66Ybfvvf9zQEAxfLFdVCSQBclUlrDEL/SYbacJLNO8BDgs7JIzpg8DRx2iBvFySTvZT613M385blJ7wwxj/hz50Rlr8JwTx/FDmdUweaOfpBaAoy34pC9AMROY9PWI8JKVC0TKc7+GjooPNewjHF+Qo/hXTnFjfz7YtTtOrxCjhKfmdhHLciV4J42Upo93TWBNeBeCbw4iahsGj+YaPP7Wn8cK6/YUL52iHIatC4AUWQXq4O+ToGjjdB3P+DcePznAJ2+bZRed/iyWWpyvjU0hS7rshZp0uI 2025-08-04 18:00:04 [INFO]: item found in queue is if condition 14409 2025-08-04 18:00:04 [INFO]: item found in queue is 14409 2025-08-04 18:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBzjiivhuSisGfmrbW3o36Vrv9gzizXUAsKtW/xXdncFk7TKTVPMYXgwyfqW1fRNmL/0EPHHdXT43iiMx/fVp3YazB19Pgy5PZFvVBEyC3Rifp1KX5D6XWWShnLuX+QTuKuxFL1Ao/5lzoUPLdfDsrtqyaq5ME+7VFUAx0gdECzFZMaNJIqO7fg8aRPjhKxdHFNRxINUvn1MDbXQ/FKbaGwFIXRSzT44IijHL9KhWNCbhDoZcp1hyjcYoGOVHTFwyy2QEohdDvuH2966Qpp6qYzyG5lXdhvJ+lxr6AG9Y2Lkcc+YIVUmU0PIw24d84yHsOD7CC0Rkj08g1DF+h1BGwjrvhNjvVJx6j14g8Cj2e71eyVEE193MBiqLn+iKpyj8UBejTBzTUSh6kqjVwA6Z9R/6VPaxnkV1Jc1ApzmAyrUn82U9KTpMcoEkVqnlHaO6F 2025-08-04 18:00:04 [INFO]: item found in queue is if condition 14409 2025-08-04 18:00:04 [INFO]: item found in queue is 14409 2025-08-04 18:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBjhDMrV8OZRclAdWwZlT5gSTNFZQvYPJhTA/aA65GIjKp7MfFTjA16sm6axplJuanygMI6YgFm3rNX+cZChlxQh3RRIKyQcTGqQNVDkk+gBrsYP4yHpd+YPiBC2gsUG6raOqChvN1wmaSUxZURyeALYeXvKGJZXR9Taf6FfirzfqWtOcSeLXty93KYO2s8QJxgMDKt0/iLUP4I0+RoVI95k6MnkbOtygBQJ6Ck14mWvn091qPsguTdXCP26flZjt9gqEwrbhcyZDyj4rfl/vDc4xGS/A5B8OtCV8A34raBnym/12EKhaI1roQzvdOD6U8pjptBd5A+Nlm9r6KYTBnuArESigRHk4BfMJEg5YDvHDBu7eHu8TTVJKc+XdojyEo8f/UwOEfH0Vk8CH7mdu/w3uEwCVr0beIAnYkVP+MwvgGjs7d74HbKrDPN6bzuuIK 2025-08-04 18:00:05 [INFO]: item found in queue is if condition 14409 2025-08-04 18:00:05 [INFO]: item found in queue is 14409 2025-08-04 18:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBib48HAEIRUFaCMC0K0swu21cE3hu1/zKNjMW+cfYa8jKNQ/afWCLa8y1nAljcukFJPW19yd2zW0R4c0WPLpZfFc3aELGN4x4juo+lrbX3JiN2xXTBdDaVKkIUzAvsCdLtT1UKto2uXI2VhxFcwqvytAjT3O2n6tSTV31RUm7CAEPRWkxi78uZouPD5VgScrwhEDePDbdWa858HwsCLPLkPmp0fkPn+G3/bUSPXBdWLVQJOZnWIhqn/QqtwOx9yHOUJ4c9RBbzUby5H7qs8u+7ySVifUYLd2jYuXz3eAxkgNacsTu0p3hlwKgcDRvouHT85Pokm0FM0UAgOWtbpeQWWxw0o5oTA0FhjbVUja3ZitfAYuNdrr1nY88XnB8+XlYEggJsqztauuYsEtaF5ZPwzc5WE9hv/ZD5e8VbgHTem6K2+3YC1aKtO0GTdn0cC4z 2025-08-04 18:00:05 [INFO]: Processed 5 messages, reached the limit of 5. 2025-08-04 18:00:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 18:00:05 [INFO]: inside itemsold and closed 14409 2025-08-04 18:00:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 18:00:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 18:00:07 [INFO]: Ebay item id :: 335845864296 exists in Database 2025-08-04 18:00:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 18:00:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 18:00:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 18:00:07 [INFO]: inside itemsold and closed 14409 2025-08-04 18:00:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 18:00:09 [INFO]: autolink for user_id 14409 is 1 2025-08-04 18:00:09 [INFO]: Ebay item id :: 224806589814 exists in Database 2025-08-04 18:00:09 [INFO]: Item is reliested :: exists in Database 2025-08-04 18:00:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 18:00:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 18:00:09 [INFO]: inside itemsold and closed 14409 2025-08-04 18:00:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 18:00:11 [INFO]: autolink for user_id 14409 is 1 2025-08-04 18:00:11 [INFO]: Ebay item id :: 325231807721 exists in Database 2025-08-04 18:00:11 [INFO]: Item is reliested :: exists in Database 2025-08-04 18:00:11 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-04 18:00:11 [INFO]: inside itemsold and closed 14409 2025-08-04 18:00:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 18:00:12 [INFO]: autolink for user_id 14409 is 1 2025-08-04 18:00:12 [INFO]: Ebay item id :: 224806589814 exists in Database 2025-08-04 18:00:12 [INFO]: Item is reliested :: exists in Database 2025-08-04 18:00:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 18:00:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 18:00:12 [INFO]: inside itemsold and closed 14409 2025-08-04 18:00:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 18:00:14 [INFO]: autolink for user_id 14409 is 1 2025-08-04 18:00:14 [INFO]: Ebay item id :: 324893412815 exists in Database 2025-08-04 18:00:14 [INFO]: Item is reliested :: exists in Database 2025-08-04 18:00:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 18:00:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 18:00:14 [INFO]: in processold action queue is array for {"44558375":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44558375","ebayitemid":"335845864296","shopifyproductid":"8838241026270","variants":[{"price":"250.99","quantity":0,"weight":"2","shopifyproductid":"8838241026270","shopifyvariantid":"46352502063326","shopifyinventoryid":"48454225232094","shopifylocationid":"","product_id":"44558375","variant_id":"77451055","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44674329":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44674329","ebayitemid":"224806589814","shopifyproductid":"7531423236318","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"7531423236318","shopifyvariantid":"42388776648926","shopifyinventoryid":"44482835382494","shopifylocationid":"","product_id":"44674329","variant_id":"77579549","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45146291":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45146291","ebayitemid":"325231807721","deleted":1}},"44658744":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44658744","ebayitemid":"324893412815","shopifyproductid":"7455798853854","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"7455798853854","shopifyvariantid":"42082480652510","shopifyinventoryid":"44176504357086","shopifylocationid":"","product_id":"44658744","variant_id":"77563964","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 18:00:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 18:00:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 18:00:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 18:00:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 18:00:14 [INFO]: productIds WHich are having null productid -> [45146291] 2025-08-04 18:00:14 [INFO]: ebayItemIds WHich are not imported-> ["325231807721"] 2025-08-04 18:00:14 [INFO]: Entered in bulkUpdateProducts function 2025-08-04 18:00:14 [INFO]: Transaction started for bulkUpdateProducts 2025-08-04 18:00:14 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45146291) 2025-08-04 18:00:14 [INFO]: Query executed successfully. Affected rows: 0 2025-08-04 18:00:14 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-04 18:00:14 [INFO]: Transaction committed successfully. 2025-08-04 18:00:14 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-04 18:00:14 [INFO]: Shopify Inventory id 48454225232094 2025-08-04 18:00:14 [INFO]: Shopify Location id 58450641063 2025-08-04 18:00:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 18:00:15 [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-04 18:00:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 18:00:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44558375 and user_id = 14409 2025-08-04 18:00:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77451055 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 18:00:15 [INFO]: Shopify Inventory id 44482835382494 2025-08-04 18:00:15 [INFO]: Shopify Location id 58450641063 2025-08-04 18:00:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 18:00:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T18:00:15Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1982,"restoreRate":100}}}} 2025-08-04 18:00:15 [INFO]: Change: available | Delta: -1 2025-08-04 18:00:15 [INFO]: Change: on_hand | Delta: -1 2025-08-04 18:00:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 18:00:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44674329 and user_id = 14409 2025-08-04 18:00:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77579549 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 18:00:15 [INFO]: Shopify Inventory id 44176504357086 2025-08-04 18:00:15 [INFO]: Shopify Location id 58450641063 2025-08-04 18:00:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 18:00:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T18:00:15Z","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-04 18:00:15 [INFO]: Change: available | Delta: -3 2025-08-04 18:00:15 [INFO]: Change: on_hand | Delta: -3 2025-08-04 18:00:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 18:00:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44658744 and user_id = 14409 2025-08-04 18:00:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77563964 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 18:00:15 [INFO]: updateIdsQuantity -> ["77451055","77579549","77563964"] 2025-08-04 18:00:15 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 2 2025-08-04 18:00:15 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77451055 THEN 0 WHEN id = 77579549 THEN 0 WHEN id = 77563964 THEN 0 END, quantityflag = CASE WHEN id = 77451055 THEN 0 WHEN id = 77579549 THEN 0 WHEN id = 77563964 THEN 0 END WHERE user_id = 14409 AND id IN (77451055,77579549,77563964) 2025-08-04 18:00:15 [INFO]: QUANTITY Updated IDs: 77451055, 77579549, 77563964 2025-08-04 18:00:15 [INFO]: Successfully processed data for user 14409 2025-08-04 18:00:15 [INFO]: Execution Started 2025-08-04 18:00:15 [INFO]: Execution Finished 2025-08-04 18:10:02 [INFO]: Execution Started 2025-08-04 18:10:02 [INFO]: old server sucessfully connected 2025-08-04 18:10:02 [INFO]: sqs client sucess created 2025-08-04 18:10:03 [INFO]: Number of messages in the queue: 1 2025-08-04 18:10:03 [INFO]: item found in queue is if condition 14409 2025-08-04 18:10:03 [INFO]: item found in queue is 14409 2025-08-04 18:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBkL63fU5OUjerU9umgfzHhHTiZGUvf4iNZxwrmYu7JsBd/MnUxxaKTOrq5/DPXcOPLg/JHp7UJLXuhsz9We1ajorRGcBHKdaD4R8hCUUV+3mLeHa6QEfYkdAfw6Amkl6iqYVXGFhEzKeQsEnoxLyc0LLujleHvmoR3oHx1kCOzWATatGZ0G+RTqNfuQaY3m0VrI2R6E8n37WBhm5Ny+CPNUQcPMWAFMmaGLQFGs/f7ieNwOBGpuFTD4JAQzNIELIyjIeyVivq7VSikxtIKWczQbEveBv3bYi+DHM6IUMG6U7lr3FH5eoH40PUaBk3wo27drN3NfZk57N4kFCy1vC/SNiFEkXc0RVaFj1P0zKsIR1gT5Xvz6wuwGjTcvL3o+NQQiVE1R6SP2wTPh7Ijd0umqUF0Byzhbb947/Q0+4U0RpBRaciDRLbr2W++ZuYv05c 2025-08-04 18:10:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-04 18:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 18:10:03 [INFO]: inside itemsold and closed 14409 2025-08-04 18:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 18:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-04 18:10:05 [INFO]: Ebay item id :: 305122954137 exists in Database 2025-08-04 18:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-04 18:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 18:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 18:10:05 [INFO]: in processold action queue is array for {"44560659":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44560659","ebayitemid":"305122954137","shopifyproductid":"7644201222366","variants":[{"price":"10.99","quantity":0,"weight":"0.75","shopifyproductid":"7644201222366","shopifyvariantid":"42767371829470","shopifyinventoryid":"44861898555614","shopifylocationid":"","product_id":"44560659","variant_id":"77453339","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 18:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 18:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 18:10:05 [INFO]: Shopify Inventory id 44861898555614 2025-08-04 18:10:05 [INFO]: Shopify Location id 58450641063 2025-08-04 18:10:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 18: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-04 18:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 18:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44560659 and user_id = 14409 2025-08-04 18:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77453339 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 18:10:05 [INFO]: updateIdsQuantity -> ["77453339"] 2025-08-04 18:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-04 18:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77453339 THEN 0 END, quantityflag = CASE WHEN id = 77453339 THEN 0 END WHERE user_id = 14409 AND id IN (77453339) 2025-08-04 18:10:05 [INFO]: QUANTITY Updated IDs: 77453339 2025-08-04 18:10:05 [INFO]: Successfully processed data for user 14409 2025-08-04 18:10:05 [INFO]: Execution Started 2025-08-04 18:10:05 [INFO]: Execution Finished 2025-08-04 18:20:01 [INFO]: Execution Started 2025-08-04 18:20:01 [INFO]: old server sucessfully connected 2025-08-04 18:20:01 [INFO]: sqs client sucess created 2025-08-04 18:20:02 [INFO]: Number of messages in the queue: 2 2025-08-04 18:20:02 [INFO]: item found in queue is if condition 14409 2025-08-04 18:20:02 [INFO]: item found in queue is 14409 2025-08-04 18:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEB7cpIf/stwy96egs2l+DjYYHgssy41OvsdHfIrtrBxy6ke7h4b3ho+geRRg5gDXNV97fQi3qtZhbxTdYGBdsXyyTbW6H0ZVvI1aBv/ZIxxwXZ0qlZ5fcs0KFT/VPnSY7RzBZet+S3BXox0/CUIdsP/kTXyCio52GafF6ZpLecPhbKlQfUBIio9RBLybL61c5+faATIavzn77xgFscfHdtu5I1YCoX+GsdZ0XANFSB6BvzkLhza47NCPVv20CLZlgkp+dgJiB5K29wPTwBD1CEa8pXVX8maMsA5ShkzbMtX39zC2r3D4hgbJJZyh57p6t0GTJFgDPsrgv4vJBEhVmOr9h6XuKRoYlIhNumoFXwKjOqziAOT6Gbn3LsEukNUBX7UfsyWAi5HqTCEfay4RTxwajl5zX9D+T71zWqqHrV2ObDMGwsMSTZLlFJm7ZJYm38 2025-08-04 18:20:03 [INFO]: item found in queue is if condition 14409 2025-08-04 18:20:03 [INFO]: item found in queue is 14409 2025-08-04 18:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBILyG2Rz/3yBaf5liXclQG5jdg/CI03Pp4cCRd9A57zSMOsXvl7B7eE0b2AsGD67HmE+eBz4DLfvm9iHtM9AmLtjdijGbMC836ROX6nq6tMXzplIknOz0iCOUYCBqaUqidB2sS5tOQAshjxWJYkVnKd0AhnL8bXt5vprfo/sr9OvE1Dck292ixxYul7IobEEmGMpqt70W+WREAtsPZ+JrhNQ6dCfh4IvUNzg6GyF6VFC5xxVVN28uykx8ciBP3suVg66dISmfSadGKCfw8JPx4pBnfQSKQhg2UAbcH4QpwqiUvdpp46cs0yYUGq6SY1v5E96BGSdOp2a2Zj1iqIF0wfJnDLBGNs54uEagNGVHdmnVZ/R1CQO6K5aELNRXMVoUtb+GI0056yRGgNOaimIWKnPew1DaShV0z+PSWiUsS/d+6hBRt7xZLbFWnmEgsCo4 2025-08-04 18:20:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-04 18:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 18:20:03 [INFO]: inside itemsold and closed 14409 2025-08-04 18:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 18:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-04 18:20:05 [INFO]: Ebay item id :: 335084703713 exists in Database 2025-08-04 18:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-04 18:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 18:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 18:20:05 [INFO]: inside itemsold and closed 14409 2025-08-04 18:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 18:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 18:20:07 [INFO]: Ebay item id :: 305730459352 exists in Database 2025-08-04 18:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 18:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 18:20:07 [INFO]: in processold action queue is array for {"44587620":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44587620","ebayitemid":"335084703713","shopifyproductid":"8165619368158","variants":[{"price":"41.99","quantity":0,"weight":"2","shopifyproductid":"8165619368158","shopifyvariantid":"44441749160158","shopifyinventoryid":"46539679236318","shopifylocationid":"","product_id":"44587620","variant_id":"77480329","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 18:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 18:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 18:20:07 [INFO]: Shopify Inventory id 46539679236318 2025-08-04 18:20:07 [INFO]: Shopify Location id 58450641063 2025-08-04 18:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 18:20: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-04 18:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 18:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44587620 and user_id = 14409 2025-08-04 18:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77480329 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 18:20:07 [INFO]: updateIdsQuantity -> ["77480329"] 2025-08-04 18:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-04 18:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77480329 THEN 0 END, quantityflag = CASE WHEN id = 77480329 THEN 0 END WHERE user_id = 14409 AND id IN (77480329) 2025-08-04 18:20:07 [INFO]: QUANTITY Updated IDs: 77480329 2025-08-04 18:20:07 [INFO]: Successfully processed data for user 14409 2025-08-04 18:20:07 [INFO]: Execution Started 2025-08-04 18:20:07 [INFO]: Execution Finished 2025-08-04 18:30:01 [INFO]: Execution Started 2025-08-04 18:30:01 [INFO]: old server sucessfully connected 2025-08-04 18:30:01 [INFO]: sqs client sucess created 2025-08-04 18:30:03 [INFO]: Number of messages in the queue: 0 2025-08-04 18:30:23 [INFO]: Execution Started 2025-08-04 18:30:23 [INFO]: Execution Finished 2025-08-04 18:40:01 [INFO]: Execution Started 2025-08-04 18:40:01 [INFO]: old server sucessfully connected 2025-08-04 18:40:01 [INFO]: sqs client sucess created 2025-08-04 18:40:02 [INFO]: Number of messages in the queue: 2 2025-08-04 18:40:02 [INFO]: item found in queue is if condition 14409 2025-08-04 18:40:02 [INFO]: item found in queue is 14409 2025-08-04 18:40:02 [INFO]: Message deleted from the queue for receipt handle: AQEBIq2d7kUwKhpfYoBUrME0pBtXPJ9Ks8E6u8fAiFCptheclwHj7N0wmbNgvoeVPqtojlameb2hn38Ma+JUdVDOCPvOdCMiWZjvFUce6pYWTPA4CIKufzP3tXjdkAbkcCV+QitAIH3RQJXDYSux2N7HvvleMtVfFQrj2vX/5WrKWYDHHWBSsZS45Jr/kJWQIx/7h6kKoYq5YGw8zkXmKdmkFplWO7kbUX2peI37nLET11qGjn1rMFyizXkMZnYbmHtQKIYbeA9Kt8melmJ57kc52kOIHzYaU8QHphbv6ArbVJau2if3fz1UHyMcxl4KkBz2WfcLEtJgRbDd7FcLw5vbYvVNISHstIG+tzdllcZKZfryMi84kUgGQrct8AmE1RDFou5qKb0TrWyTjw72BzIsxZCnFD/awDd9F8RTH4g8TnZ+QWCmrAk1F35qZcYJXgtE 2025-08-04 18:40:03 [INFO]: item found in queue is if condition 14409 2025-08-04 18:40:03 [INFO]: item found in queue is 14409 2025-08-04 18:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBu1y+mw1/4Ts85DvO5v+GkYJJxB7evG3bG5DOsyYoveuAvPiH98TK2RzVTZYd0sXQ6RnQQKRX1xdJ0GemwRnOPbw6zLEXAUkBvlsxqAE9PvA3vKCEnAcIx1xoKcafU/5NSzxqHTD0jAVENmwbeza12pgwaKzn2jzU6ROnSN6RORZN67QYo803BX6fis6yJAwySsnV1nqrk8pFBJHSJ2jqySk7JzRshTaKMtJdl/MPlYzVXoAFkfFn2+B9luBGfzgODN6H5IiA/ozIJxOanPXoLM+DnIZUiI0+z0Crw/DhKa1C0kHqStCMQ+upRwRxvUebq+Lej8AlQke62dSOftdMu8dg4kovsSAjavKye3jU+TM/L2Ugb6MzjGFygzvaCHMyXiBmTFpo+1Vau/qYuI6tl+MNk1CKbh9Zme/q2Pd1mOt4NZ+M7EhliEADRgrtC34c 2025-08-04 18:40:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-04 18:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 18:40:03 [INFO]: inside itemsold and closed 14409 2025-08-04 18:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 18:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-04 18:40:05 [INFO]: Ebay item id :: 226833240737 exists in Database 2025-08-04 18:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-04 18:40:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-04 18:40:05 [INFO]: inside itemsold and closed 14409 2025-08-04 18:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 18:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 18:40:07 [INFO]: Ebay item id :: 334921657600 exists in Database 2025-08-04 18:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 18:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 18:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 18:40:07 [INFO]: in processold action queue is array for {"45163026":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45163026","ebayitemid":"226833240737","deleted":1}},"44586486":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44586486","ebayitemid":"334921657600","shopifyproductid":"7811515351262","variants":[{"price":"280.99","quantity":0,"weight":"4","shopifyproductid":"7811515351262","shopifyvariantid":"43444956922078","shopifyinventoryid":"45540373856478","shopifylocationid":"","product_id":"44586486","variant_id":"77479195","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 18:40:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 18:40:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 18:40:07 [INFO]: productIds WHich are having null productid -> [45163026] 2025-08-04 18:40:07 [INFO]: ebayItemIds WHich are not imported-> ["226833240737"] 2025-08-04 18:40:07 [INFO]: Entered in bulkUpdateProducts function 2025-08-04 18:40:07 [INFO]: Transaction started for bulkUpdateProducts 2025-08-04 18:40:07 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45163026) 2025-08-04 18:40:07 [INFO]: Query executed successfully. Affected rows: 0 2025-08-04 18:40:07 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-04 18:40:07 [INFO]: Transaction committed successfully. 2025-08-04 18:40:07 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-04 18:40:07 [INFO]: Shopify Inventory id 45540373856478 2025-08-04 18:40:07 [INFO]: Shopify Location id 58450641063 2025-08-04 18:40:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 18:40:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T18: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-04 18:40:07 [INFO]: Change: available | Delta: -1 2025-08-04 18:40:07 [INFO]: Change: on_hand | Delta: -1 2025-08-04 18:40:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 18:40:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44586486 and user_id = 14409 2025-08-04 18:40:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77479195 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 18:40:07 [INFO]: updateIdsQuantity -> ["77479195"] 2025-08-04 18:40:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-04 18:40:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77479195 THEN 0 END, quantityflag = CASE WHEN id = 77479195 THEN 0 END WHERE user_id = 14409 AND id IN (77479195) 2025-08-04 18:40:07 [INFO]: QUANTITY Updated IDs: 77479195 2025-08-04 18:40:07 [INFO]: Successfully processed data for user 14409 2025-08-04 18:40:07 [INFO]: Execution Started 2025-08-04 18:40:07 [INFO]: Execution Finished 2025-08-04 18:50:02 [INFO]: Execution Started 2025-08-04 18:50:02 [INFO]: old server sucessfully connected 2025-08-04 18:50:02 [INFO]: sqs client sucess created 2025-08-04 18:50:03 [INFO]: Number of messages in the queue: 2 2025-08-04 18:50:03 [INFO]: item found in queue is if condition 14409 2025-08-04 18:50:03 [INFO]: item found in queue is 14409 2025-08-04 18:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBnXxmnsSauoyQQpTZQ723GpZjW5A98IXhlbe1w8vxnimiBKS6FP2ZZLbEwDseo0DrRYThg89o9NFqxJnL9VGWlkKv7HeIP14rh9AyQ4cN9hq3iFsGqxpCp+pGKVBM3Pfhm3z/ZdnLCX302D5tr5jJz8E0/r2SCCQMfkb8oMoerrzqKhV/mdk1r3ZEowHR822WwKVB9HnwGfepl4RnRgCdMdQFVcwGVDbxLwQRnnzZWwvMyJYrQ4Sh3CVHmjk4YP3ArQh1lE5+6OYHYNS/YzROppRw5I2ePw55he3XQ7WGcEQZXuKHFkiKKpFm1/ZBto2YLW2N0oUtYJwDJwEoZZj++li7FVoPFJ09WfK0s+v3I/WyRk8SSyFM+Z5mzsa+C11Fu1Fcn71gWP6DLy0JgNdxmsA4NGKG+lbRp27UOUTpUxpS+jbpvNZc4yUCnpvWuNwF 2025-08-04 18:50:04 [INFO]: item found in queue is if condition 14409 2025-08-04 18:50:04 [INFO]: item found in queue is 14409 2025-08-04 18:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBH/mirVJlBiAyBDtpgkVB6yeTcE6M2myhcuiBAAuHBWj7D6Yo9vIK5aWELEnubBx9f3HbdhaZ3VDv4ybsBel4dcouvvLMc8DvWtbP6lp/DUcvXtpMHAnDV+7n3O8GN0ZBabZNGDv6REnHM5lUzCq6Ar9nM54/0gqvzCA4i2XmCIx100+yXmRLYM1GwS+bXSZAeXdLpyae6/fHOVZBif7X7rREeFRWZZhNKRIo3I9dkozqaN6y1s1LRG2XEB0EstueQwd118yt+xMfLNmwMlxUu8H0GFnYuZsKC/8Ei54P8hZlUdrJM7RtrrSuozTH+7Umpy6w66JdiMODM0g7VbHG0SCJWxRJ9NYCtunAAgFhXndwEFl95yPjcLk6Wk5TyHdTTsujNz2++k9ynwR7SmZ9RDdbfX5u1ghSOgK2sCpzIdKA9moQu4eGMGw5sXV9tV1Y 2025-08-04 18:50:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-04 18:50:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 18:50:04 [INFO]: inside itemsold and closed 14409 2025-08-04 18:50:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 18:50:06 [INFO]: autolink for user_id 14409 is 1 2025-08-04 18:50:06 [INFO]: Ebay item id :: 285782658623 exists in Database 2025-08-04 18:50:06 [INFO]: Item is reliested :: exists in Database 2025-08-04 18:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 18:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 18:50:06 [INFO]: inside itemsold and closed 14409 2025-08-04 18:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 18:50:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 18:50:07 [INFO]: Ebay item id :: 305086470386 exists in Database 2025-08-04 18:50:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 18:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 18:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 18:50:07 [INFO]: in processold action queue is array for {"44590187":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44590187","ebayitemid":"285782658623","shopifyproductid":"8338791727326","variants":[{"price":"79.99","quantity":0,"weight":"3","shopifyproductid":"8338791727326","shopifyvariantid":"44980158071006","shopifyinventoryid":"47077943804126","shopifylocationid":"","product_id":"44590187","variant_id":"77482896","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44586960":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44586960","ebayitemid":"305086470386","shopifyproductid":"7643740799198","variants":[{"price":"279.99","quantity":0,"weight":"3","shopifyproductid":"7643740799198","shopifyvariantid":"42765256196318","shopifyinventoryid":"44859778138334","shopifylocationid":"","product_id":"44586960","variant_id":"77479669","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 18:50:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 18:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 18:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 18:50:07 [INFO]: Shopify Inventory id 47077943804126 2025-08-04 18:50:07 [INFO]: Shopify Location id 58450641063 2025-08-04 18:50:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 18:50:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T18:50:08Z","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-04 18:50:08 [INFO]: Change: available | Delta: -1 2025-08-04 18:50:08 [INFO]: Change: on_hand | Delta: -1 2025-08-04 18:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 18:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44590187 and user_id = 14409 2025-08-04 18:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77482896 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 18:50:08 [INFO]: Shopify Inventory id 44859778138334 2025-08-04 18:50:08 [INFO]: Shopify Location id 58450641063 2025-08-04 18:50:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 18:50:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T18:50:08Z","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-04 18:50:08 [INFO]: Change: available | Delta: -1 2025-08-04 18:50:08 [INFO]: Change: on_hand | Delta: -1 2025-08-04 18:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 18:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44586960 and user_id = 14409 2025-08-04 18:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77479669 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 18:50:08 [INFO]: updateIdsQuantity -> ["77482896","77479669"] 2025-08-04 18:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-04 18:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77482896 THEN 0 WHEN id = 77479669 THEN 0 END, quantityflag = CASE WHEN id = 77482896 THEN 0 WHEN id = 77479669 THEN 0 END WHERE user_id = 14409 AND id IN (77482896,77479669) 2025-08-04 18:50:08 [INFO]: QUANTITY Updated IDs: 77482896, 77479669 2025-08-04 18:50:08 [INFO]: Successfully processed data for user 14409 2025-08-04 18:50:08 [INFO]: Execution Started 2025-08-04 18:50:08 [INFO]: Execution Finished