2025-08-05 12:00:02 [INFO]: Execution Started 2025-08-05 12:00:02 [INFO]: old server sucessfully connected 2025-08-05 12:00:02 [INFO]: sqs client sucess created 2025-08-05 12:00:03 [INFO]: Number of messages in the queue: 7 2025-08-05 12:00:04 [INFO]: item found in queue is if condition 14409 2025-08-05 12:00:04 [INFO]: item found in queue is 14409 2025-08-05 12:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBTr1excC/NbcKn5yjDRjpjpC6e1JFE0SXA1RfKkghevJIxnwL2U0K5oXvRMec5IZz4FP5bdHWA9+8ug/KyowchRJPR8jPocEIp3Eua0+iipIRMigFuB2BUDVM8rnWPI5iUrALj6M5AW7IRLHjZtQLg8Ec+rS0kYDuFcAFlDAPNdXRpkqX7BcBDHgOWmy6eD5C7alX4riDsGt9aOPbqTPdONAVGZRs4FpVH12gmMEDgymqDeTJ92mJ6oeC3Ot4q4gFxtYet6U1sBnPFL0V97exyUssktkVYf6jF7w+YVr5qP1zVq1z1Vg7cy85ac5Ij3baY1ME8j95qcVj5T2QQJVlK6TDwtaLURtUh6QPG9D9/yCyyVNVJuO4XxBo9xPW1maKTnW1NI1/nY2qjXAjfRA3LaLQ4OENpU+1sBQjZn/SN6AEqTZCRl56N7cMlYOaKtC/ 2025-08-05 12:00:05 [INFO]: item found in queue is if condition 14409 2025-08-05 12:00:05 [INFO]: item found in queue is 14409 2025-08-05 12:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEB+8j58yO46R9oGEkSeSIFYVLxOZObxC+qGjdOOSzVSsiDtwrs8LbuYcPOYp67h4yEFCcQA1FVX/yf+/fFVyLRkeCsTQuh8pceuR3hgF/sSiUeZGwElg0z8fQGNUempdohHH9SGiSv//aPyjZEjClQe5muhZZE1fWMi2UZBh64lxW/CEfBnkiGuNxIzfb8bSpE4eUU6F60+0PaTp4R70+qliG5MTIkmLAoIID56TCHjpGH/LUV9z+9RdWLEVKUU+QRn3OBO3rVMGCsQ6ZCtWsa8riOf3YcxhVgmncU4uyJITy+Nay2qyddORQOTX67Qkxn8So0x+PUIIGQb8k3t8/1qQx0n+QOcVMvTT8XPDueb43XoQiJfJ+W6mPwuo6DIUO840leqF3IFE5nB70oqDTSlx7NvdUJPuujkw6CcFqRPQ+0Wtp0IMLdC0IXq/QUjaqC 2025-08-05 12:00:05 [INFO]: item found in queue is if condition 14409 2025-08-05 12:00:05 [INFO]: item found in queue is 14409 2025-08-05 12:00:06 [INFO]: Message deleted from the queue for receipt handle: AQEBjHbs7dIDKcZQxMeHhwxoD4mEcJQtOYn1BH8jE+p30JM0E6CV/XhsFM7U26qGqhVZN4ir17sOh+1XPCxfKhtDG/sqHUNe28vHn6TD3pdkSdqK4CEfc+ND6f4CMBoDvbFVQ9OXXoNxXsJaanNDJ/z2iHwGP7Xib/OV8n+R5E7u9HFfaibiU6z5qUkJiftq+uo5DVjKAIGT2cFBYHxLleu18jj6l/3RQ+yqfYHsM/TThFRsZB6pt+irsIRuHdePe0zusPY5RctLD9PPQJiowTNqGafMp1yDByjqjQQXUQzCaeqG/iOClOYDLDQyYG3v+IIFliypFxo2tvXcRJKUpeoQXw0JOTu7LqMrP85DFVu4QypdU6hKh3Igne23hEicBtwEpmauYaz0cQ2OIDUpq33Hwkj2+TfCdDO2FYiQnVcF0S2Gy40Aft/hb+lkojt+f7PU 2025-08-05 12:00:06 [INFO]: item found in queue is if condition 14409 2025-08-05 12:00:06 [INFO]: item found in queue is 14409 2025-08-05 12:00:07 [INFO]: Message deleted from the queue for receipt handle: AQEButc3E/yFe5Rh7jLp2mVsCcsBzxsjzSmQe9G610S87AY+ry5epq4eYcf/5MYOdkurZeKlzh5W8UodwRqjB28yF1HwdHp/rx7Xi7wJdNojB2uKyyAXxLmEh7HqazexxF9Jjm1IHNCasFqnYTFPba/n9PgVjZSDGhBzblohTl1K1fn3BJeQYI8WXczftWoGPu95vMezHqQcHXsv3O7a/wgf1gXaoAXDbg2NZI8OyRAzcXOP8NZgs8ZqA29tzqSTvJNW2TvceMHvk1hhdiwa3m0imbrxUvQQFqdcAd5CypNFv68znWtTYBn9KP1mUyNak4pWEbsiCQOhMM4W4TivOqj1wtCvK7h3mrXI5KuVfueo68jhjmFKK13SL2maLCZMxGea1/VnnfUdkg/iRw/FfqvZs3cMrMvB/k21M0/Ydm8cLzvMEenxYnpYgmc2MxVucyev 2025-08-05 12:00:07 [INFO]: item found in queue is if condition 14409 2025-08-05 12:00:07 [INFO]: item found in queue is 14409 2025-08-05 12:00:07 [INFO]: Message deleted from the queue for receipt handle: AQEBvgehCrKIUupdy2B6ywBmZwWCS7bvLOSepwkvXrBDm7RfcLozcyXqGn5qyw79VKYXFmvt78RTh6KQA4WNb5VYCIz3s4123DN+owclvGq+qU8ctMd7eEsk0mvB/QYO/RfIk+HB7fe5Dzv/PvQc90+c/RbwLlSb90LG72ue1HmddOuZtH6oacesisPd0O/d7DEl41gZSL0FiGTT37LVhOGtXYNcLj9xowBSBr9Um6ZS8/SZKQfpv1yRX1ZVkFKPQtxvRS19eKMDdv7n0Fdyw7S7K+jGW/wii/p/Ii1ZqKsyvbn0zjflhYIHTHU6q+F4ESiHj6hucTm9pF42D4zX+G/S5P0B0nAlYPqP5FkDpWn7JIJKKAuuF+aZZ37hwgwtUcMwsh7CbEDMQTdGEnTDLZdcwXOuL5AJgPyDaP5X+dyVmua6vto8y4KHCFlxB7kRN5ia 2025-08-05 12:00:08 [INFO]: item found in queue is if condition 14409 2025-08-05 12:00:08 [INFO]: item found in queue is 14409 2025-08-05 12:00:08 [INFO]: Message deleted from the queue for receipt handle: AQEBYL8lWjUqAbdc7ml2PY+WfALWg9zo9jjcEw2JdiS+5Dp2tQ3S2NwBthZLmSU/Ts5fgP+gBOYGsnUqANJUVsxrK2LyBJ6yiaMGmREMH/pJ9DoS7yrasOzO6aekHab5x4dvay+LMMf/UoISChGetun527WP81zYeiE6ac6hID1J7V2RyNJUxhgQjxtQFKjXs74mT55XlyDPC1+DIwJWBJg4I1Wgg4Tnhqp7sab69Gx/rHoAUqiY/QRIPDIr1VKdjROzrL3Os4Iv2iDdleY3pmFEmncL60QavLiIg5I7z3aYXV8k0rdeQSU01tnK7zkqK154RVtgwV8xlYbfpC7mZJ/IX0EtoAoGXJuMbJkLClpaPlSyjBufu4U1i+Ogn2uQHR0FPhp4VjcINHsbwNQ2iUW9vK3kL1nDAxMtQaqQm0UNbxfre3GZWhw0H7oNw6CPqUA4 2025-08-05 12:00:08 [INFO]: item found in queue is if condition 14409 2025-08-05 12:00:08 [INFO]: item found in queue is 14409 2025-08-05 12:00:08 [INFO]: Message deleted from the queue for receipt handle: AQEBs2LTp9WCmqhNCwd6Cx2vjuHYyD3jCSCnKzRo639QiEJt13t7nMLUvSutbx62Aj6xklmQNvmE6/KxTq4KInvMqCsFCcTtox4xb2sGj5h+fH89iSkAQFwaUIxR/0nOwq73EZOPxWxFXYEc7sW4MnnhwlW0oP3WT3clO5RV6Yte+kaFqeKWQSFYS/SWQTlRF/m0Rnh2Ydvg/ppaxVkqIfQswJ3yw2FJKbiuLB+RDZtT1/79Y3SHQbT4n6iCyf89G3HCvo0njWQ8HaN9834T3ypEy85T+lq4VnCRb7itiXrWLuxBfdChyQP8fex0iR/Xspfin3cjCRSxfxAvvJ+H5KBX3e4RTT1rOy+MD8UxQl4M0Ji8WS0OjV54fUWtaWhVD2hwm1n4/CddDJo9By2tlmuHK+ZAx9U7L+1SFr/M/90xCSsH4hsIoykKzplf4AOtImmg 2025-08-05 12:00:08 [INFO]: Processed 7 messages, reached the limit of 7. 2025-08-05 12:00:08 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 12:00:08 [INFO]: inside itemsold and closed 14409 2025-08-05 12:00:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:00:11 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:00:11 [INFO]: Ebay item id :: 325203930525 exists in Database 2025-08-05 12:00:11 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:00:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:00:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:00:11 [INFO]: inside itemsold and closed 14409 2025-08-05 12:00:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:00:12 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:00:12 [INFO]: Ebay item id :: 224991759356 exists in Database 2025-08-05 12:00:12 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:00:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:00:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:00:12 [INFO]: inside itemsold and closed 14409 2025-08-05 12:00:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:00:14 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:00:14 [INFO]: Ebay item id :: 224963100459 exists in Database 2025-08-05 12:00:14 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:00:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:00:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:00:14 [INFO]: inside itemsold and closed 14409 2025-08-05 12:00:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:00:15 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:00:15 [INFO]: Ebay item id :: 404952473231 exists in Database 2025-08-05 12:00:15 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:00:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:00:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:00:15 [INFO]: inside itemsold and closed 14409 2025-08-05 12:00:17 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:00:17 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:00:17 [INFO]: Ebay item id :: 325221042668 exists in Database 2025-08-05 12:00:17 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:00:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:00:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:00:17 [INFO]: inside itemsold and closed 14409 2025-08-05 12:00:19 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:00:19 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:00:19 [INFO]: Ebay item id :: 325203645596 exists in Database 2025-08-05 12:00:19 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:00:19 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:00:19 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:00:19 [INFO]: inside itemsold and closed 14409 2025-08-05 12:00:21 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:00:21 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:00:21 [INFO]: Ebay item id :: 256736423745 exists in Database 2025-08-05 12:00:21 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:00:21 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:00:21 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:00:21 [INFO]: in processold action queue is array for {"44676135":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44676135","ebayitemid":"325203930525","shopifyproductid":"7667033243870","variants":[{"price":"18.99","quantity":0,"weight":"2","shopifyproductid":"7667033243870","shopifyvariantid":"42866543067358","shopifyinventoryid":"44961207779550","shopifylocationid":"","product_id":"44676135","variant_id":"77581355","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44655370":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44655370","ebayitemid":"224991759356","shopifyproductid":"7659075305694","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"7659075305694","shopifyvariantid":"42826100408542","shopifyinventoryid":"44920705253598","shopifylocationid":"","product_id":"44655370","variant_id":"77560559","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44687151":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44687151","ebayitemid":"224963100459","shopifyproductid":"7639895441630","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"7639895441630","shopifyvariantid":"42755246588126","shopifyinventoryid":"44849738580190","shopifylocationid":"","product_id":"44687151","variant_id":"77592376","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772852":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772852","ebayitemid":"404952473231","shopifyproductid":"8461638140126","variants":[{"price":"209.99","quantity":0,"weight":"2","shopifyproductid":"8461638140126","shopifyvariantid":"45305977438430","shopifyinventoryid":"47403902173406","shopifylocationid":"","product_id":"44772852","variant_id":"77681394","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44731709":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44731709","ebayitemid":"325221042668","shopifyproductid":"7678861803742","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"7678861803742","shopifyvariantid":"42916067442910","shopifyinventoryid":"45011018481886","shopifylocationid":"","product_id":"44731709","variant_id":"77639594","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44675458":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44675458","ebayitemid":"325203645596","shopifyproductid":"7666760909022","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"7666760909022","shopifyvariantid":"42866008490206","shopifyinventoryid":"44960672841950","shopifylocationid":"","product_id":"44675458","variant_id":"77580678","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44776962":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44776962","ebayitemid":"256736423745","shopifyproductid":"8752359014622","variants":[{"price":"209.99","quantity":0,"weight":"2","shopifyproductid":"8752359014622","shopifyvariantid":"46120400519390","shopifyinventoryid":"48219475869918","shopifylocationid":"","product_id":"44776962","variant_id":"77685504","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 12:00:21 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 12:00:21 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:00:21 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:00:21 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:00:21 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:00:21 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:00:21 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:00:21 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:00:21 [INFO]: Shopify Inventory id 44961207779550 2025-08-05 12:00:21 [INFO]: Shopify Location id 58450641063 2025-08-05 12:00:21 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:00:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:00:21Z","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 12:00:21 [INFO]: Change: available | Delta: -1 2025-08-05 12:00:21 [INFO]: Change: on_hand | Delta: -1 2025-08-05 12:00:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:00:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44676135 and user_id = 14409 2025-08-05 12:00:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77581355 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:00:21 [INFO]: Shopify Inventory id 44920705253598 2025-08-05 12:00:21 [INFO]: Shopify Location id 58450641063 2025-08-05 12:00:21 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:00:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:00:21Z","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 12:00:21 [INFO]: Change: available | Delta: -1 2025-08-05 12:00:21 [INFO]: Change: on_hand | Delta: -1 2025-08-05 12:00:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:00:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44655370 and user_id = 14409 2025-08-05 12:00:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77560559 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:00:21 [INFO]: Shopify Inventory id 44849738580190 2025-08-05 12:00:21 [INFO]: Shopify Location id 58450641063 2025-08-05 12:00:21 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:00:22 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:00:22Z","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 12:00:22 [INFO]: Change: available | Delta: -1 2025-08-05 12:00:22 [INFO]: Change: on_hand | Delta: -1 2025-08-05 12:00:22 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:00:22 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44687151 and user_id = 14409 2025-08-05 12:00:22 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77592376 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:00:22 [INFO]: Shopify Inventory id 47403902173406 2025-08-05 12:00:22 [INFO]: Shopify Location id 58450641063 2025-08-05 12:00:22 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:00:22 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:00:22Z","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 12:00:22 [INFO]: Change: available | Delta: -2 2025-08-05 12:00:22 [INFO]: Change: on_hand | Delta: -2 2025-08-05 12:00:22 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:00:22 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772852 and user_id = 14409 2025-08-05 12:00:22 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681394 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:00:22 [INFO]: Shopify Inventory id 45011018481886 2025-08-05 12:00:22 [INFO]: Shopify Location id 58450641063 2025-08-05 12:00:22 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:00:22 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:00:22Z","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 12:00:22 [INFO]: Change: available | Delta: -1 2025-08-05 12:00:22 [INFO]: Change: on_hand | Delta: -1 2025-08-05 12:00:22 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:00:22 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44731709 and user_id = 14409 2025-08-05 12:00:22 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77639594 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:00:22 [INFO]: Shopify Inventory id 44960672841950 2025-08-05 12:00:22 [INFO]: Shopify Location id 58450641063 2025-08-05 12:00:22 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:00:23 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:00:23Z","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 12:00:23 [INFO]: Change: available | Delta: -1 2025-08-05 12:00:23 [INFO]: Change: on_hand | Delta: -1 2025-08-05 12:00:23 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:00:23 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44675458 and user_id = 14409 2025-08-05 12:00:23 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77580678 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:00:23 [INFO]: Shopify Inventory id 48219475869918 2025-08-05 12:00:23 [INFO]: Shopify Location id 58450641063 2025-08-05 12:00:23 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:00:23 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:00:23Z","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 12:00:23 [INFO]: Change: available | Delta: -2 2025-08-05 12:00:23 [INFO]: Change: on_hand | Delta: -2 2025-08-05 12:00:23 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:00:23 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44776962 and user_id = 14409 2025-08-05 12:00:23 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685504 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:00:23 [INFO]: updateIdsQuantity -> ["77581355","77560559","77592376","77681394","77639594","77580678","77685504"] 2025-08-05 12:00:23 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 7. Affected rows: 7 2025-08-05 12:00:23 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77581355 THEN 0 WHEN id = 77560559 THEN 0 WHEN id = 77592376 THEN 0 WHEN id = 77681394 THEN 0 WHEN id = 77639594 THEN 0 WHEN id = 77580678 THEN 0 WHEN id = 77685504 THEN 0 END, quantityflag = CASE WHEN id = 77581355 THEN 0 WHEN id = 77560559 THEN 0 WHEN id = 77592376 THEN 0 WHEN id = 77681394 THEN 0 WHEN id = 77639594 THEN 0 WHEN id = 77580678 THEN 0 WHEN id = 77685504 THEN 0 END WHERE user_id = 14409 AND id IN (77581355,77560559,77592376,77681394,77639594,77580678,77685504) 2025-08-05 12:00:23 [INFO]: QUANTITY Updated IDs: 77581355, 77560559, 77592376, 77681394, 77639594, 77580678, 77685504 2025-08-05 12:00:23 [INFO]: Successfully processed data for user 14409 2025-08-05 12:00:23 [INFO]: Execution Started 2025-08-05 12:00:23 [INFO]: Execution Finished 2025-08-05 12:10:01 [INFO]: Execution Started 2025-08-05 12:10:01 [INFO]: old server sucessfully connected 2025-08-05 12:10:01 [INFO]: sqs client sucess created 2025-08-05 12:10:03 [INFO]: Number of messages in the queue: 4 2025-08-05 12:10:04 [INFO]: item found in queue is if condition 14409 2025-08-05 12:10:04 [INFO]: item found in queue is 14409 2025-08-05 12:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBTMjsYy+0yq4wiexAk5Sl8C8PnUThpYQEkCcLuztAqIdOFrSN/GQvbdwT9+nxQowtFE+It3QyaIbTVJvTSE18022hxHiwxAM7nnZUAbzAvCJAST0SohLpLTo89ewWIJWeweo4nTGbb4ExymkUmxCGKugAEh8HwXFlbwOGfiegN2yHSIZ2Krnlgxafe4FPMtydGsUQOCs7hQz3Wl5T5hivWa9OBZrPd6GAG9aAOQxIqAYJlryi9VNCVezKF7V6fy+CmEa6QAgAUhQ1MIaOHZZUsm638c9I8jv2v/wAGz2282rbVG660LwWZwBWOaoKw5AJ6VcOwH8UIQKFRf5zr/6IsOz88Q5jWzPm4tNx148TRqsZKgtW0YRXmjwYG6bxxmrylpm7bauVaxHKHxILAtLyWeXkndPnU+tP9oPX5VI79GDSKUf/DGyyV6KbX5pQUhaH 2025-08-05 12:10:04 [INFO]: item found in queue is if condition 14409 2025-08-05 12:10:04 [INFO]: item found in queue is 14409 2025-08-05 12:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBHt6eWiP7PRJzBRdr/HPp0aIr/T10DZwt9ZueWDE2VYxRT61JBHfUwbKiMKJq3i6ZpblU2xhKlHDH46QYEEqU23blWxRq0wSmLSJ0FY+bzmGiCjKPwIK0terX5S6+iifzgJcwK3b2HlWbf80jAZtfImlCnfa1B2nFeSApQXLz77Hss9lTUuIreV4BVp+zzs7dT7cJoqs7QS36ZeDGiVhU+jNIFhjpxGwOyZMllirU1COd7NURTS7lF/ZPR1Y687viL7iZ/JZ5WRxNmfHMfL3Vugg5czDh9ecZ30PedvnAyM4UCQBH19D2mkTYIoJ19JIai0HwUeD5fzWPHR2FnsXwx8MDH1sSWzoq7g6wQeMTFL/1gmxR8pK/66EQzzm4xlZVSZk8Bo2fIdrSp2isHCw8/BzBA5X8FTTlOhS3OYKMfe+aAd39A1WZ5cX2l8055uxM 2025-08-05 12:10:05 [INFO]: item found in queue is if condition 14409 2025-08-05 12:10:05 [INFO]: item found in queue is 14409 2025-08-05 12:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBzH2nrn8gcws5fxQRetEvMpxSUPljI0z5DJyOCUSvBILqiw7v3+8ojIPUCEbxlfAk3BUCpRHHS16QPTO6Up+UQgJ7G7zIOTOcySoZ6lT9n/8lDo/M/jBdXIMoXlfkI3ZmfXF63f097MyYr+mxQPWjjGNsZgFTt9e4hPf0qA2iiFmVdqLjsy9yIj2QNa3wB5rsf8CiYNPUxNRWPybegPRSC52UPQ7/ETKu7bp2qk7YXrlKeShvxT3a20CyvjrOjFXXQvP0+a5LK/wEO1Oj7QrRbbEJ8NY6PuJZYo9GhM/0IgzYvaGO7zlFOkJbLhx4aRa0Q5NCkUKP9PB0g6o/N5XXv62vyGD3sca8d96LFKJG3gBGEFVv8XwEU4yD+0r5eZ4S2VTp769NxaCrXJ3QKl6pkg5QUmB7pC+D562GnGp3ZmTuWsb7bvfM+PD2M4SpeM1D 2025-08-05 12:10:05 [INFO]: item found in queue is if condition 14409 2025-08-05 12:10:05 [INFO]: item found in queue is 14409 2025-08-05 12:10:06 [INFO]: Message deleted from the queue for receipt handle: AQEBPEbZcFRAp6ZnDjXROwTyDv2gNZ7ThhnWifc/1sfcAt9xuvrEB0S4ybTpboEIGfh7y5RHG1hMVlhNI9L8w6wHgNm6l7yKxjwOGZ8M1tkdDk1iH2kzzx8K8jwOY7BRIQJKIzdiR8NFMLZfwKE+rMkFtaO/Gr+xiqbys+nNosc2Rjj8y4GdwBoBU9OnF3iZFxuYAK6PYN8Jevq8vCDb4mclOtTcagKtVR+N9q8L3jCgXAgLKi+FQN+tFlQRsk2Lo01pSc64yAmGOjl6/0/INEiHwkdW1x3ARsQGYyjCMfdlxcMjDzB5pQVpo/oDc7NZjuXsXj4vPnxKmap+tEWMyiataLn2GFOlWUEoVQBDS521LqtzOXPuk5NDYWpfvCUQbKXz/o0AIkakc734p2kMTqaOQJoMh5tnYyOyaHYoY3LSO5hmX6XUheFrQj50Eb8MTA+D 2025-08-05 12:10:06 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-05 12:10:06 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 12:10:06 [INFO]: inside itemsold and closed 14409 2025-08-05 12:10:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:10:08 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:10:08 [INFO]: Ebay item id :: 325521956692 exists in Database 2025-08-05 12:10:08 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:10:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:10:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:10:08 [INFO]: inside itemsold and closed 14409 2025-08-05 12:10:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:10:09 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:10:09 [INFO]: Ebay item id :: 325521956692 exists in Database 2025-08-05 12:10:09 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:10:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:10:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:10:09 [INFO]: inside itemsold and closed 14409 2025-08-05 12:10:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:10:11 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:10:11 [INFO]: Ebay item id :: 286189785757 exists in Database 2025-08-05 12:10:11 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:10:11 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-05 12:10:11 [INFO]: inside itemsold and closed 14409 2025-08-05 12:10:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:10:13 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:10:13 [INFO]: Ebay item id :: 286189792720 exists in Database 2025-08-05 12:10:13 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:10:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:10:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:10:13 [INFO]: in processold action queue is array for {"44732700":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44732700","ebayitemid":"325521956692","shopifyproductid":"8021541716190","variants":[{"price":"9.99","quantity":0,"weight":"0.9375","shopifyproductid":"8021541716190","shopifyvariantid":"44152659443934","shopifyinventoryid":"46249627222238","shopifylocationid":"","product_id":"44732700","variant_id":"77640585","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45149162":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45149162","ebayitemid":"286189785757","deleted":1}},"44776914":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44776914","ebayitemid":"286189792720","shopifyproductid":"8059998929118","variants":[{"price":"59.99","quantity":0,"weight":"2","shopifyproductid":"8059998929118","shopifyvariantid":"44222832312542","shopifyinventoryid":"46319937650910","shopifylocationid":"","product_id":"44776914","variant_id":"77685456","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 12:10:13 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 12:10:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:10:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:10:13 [INFO]: productIds WHich are having null productid -> [45149162] 2025-08-05 12:10:13 [INFO]: ebayItemIds WHich are not imported-> ["286189785757"] 2025-08-05 12:10:13 [INFO]: Entered in bulkUpdateProducts function 2025-08-05 12:10:13 [INFO]: Transaction started for bulkUpdateProducts 2025-08-05 12:10:13 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45149162) 2025-08-05 12:10:13 [INFO]: Query executed successfully. Affected rows: 0 2025-08-05 12:10:13 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-05 12:10:13 [INFO]: Transaction committed successfully. 2025-08-05 12:10:13 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-05 12:10:13 [INFO]: Shopify Inventory id 46249627222238 2025-08-05 12:10:13 [INFO]: Shopify Location id 58450641063 2025-08-05 12:10:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:10:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:10:13Z","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-05 12:10:13 [INFO]: Change: available | Delta: -3 2025-08-05 12:10:13 [INFO]: Change: on_hand | Delta: -3 2025-08-05 12:10:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:10:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44732700 and user_id = 14409 2025-08-05 12:10:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77640585 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:10:13 [INFO]: Shopify Inventory id 46319937650910 2025-08-05 12:10:13 [INFO]: Shopify Location id 58450641063 2025-08-05 12:10:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:10:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:10:13Z","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 12:10:13 [INFO]: Change: available | Delta: -2 2025-08-05 12:10:13 [INFO]: Change: on_hand | Delta: -2 2025-08-05 12:10:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:10:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44776914 and user_id = 14409 2025-08-05 12:10:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685456 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:10:13 [INFO]: updateIdsQuantity -> ["77640585","77685456"] 2025-08-05 12:10:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-05 12:10:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77640585 THEN 0 WHEN id = 77685456 THEN 0 END, quantityflag = CASE WHEN id = 77640585 THEN 0 WHEN id = 77685456 THEN 0 END WHERE user_id = 14409 AND id IN (77640585,77685456) 2025-08-05 12:10:13 [INFO]: QUANTITY Updated IDs: 77640585, 77685456 2025-08-05 12:10:13 [INFO]: Successfully processed data for user 14409 2025-08-05 12:10:13 [INFO]: Execution Started 2025-08-05 12:10:13 [INFO]: Execution Finished 2025-08-05 12:20:01 [INFO]: Execution Started 2025-08-05 12:20:01 [INFO]: old server sucessfully connected 2025-08-05 12:20:01 [INFO]: sqs client sucess created 2025-08-05 12:20:03 [INFO]: Number of messages in the queue: 6 2025-08-05 12:20:03 [INFO]: item found in queue is if condition 14409 2025-08-05 12:20:03 [INFO]: item found in queue is 14409 2025-08-05 12:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBdVvQnwCdz9Gz6xznjt/0qlgo9Xp1hf1acRlJnu4JYiCepznMsAHXbMZowANJVHRvySiCgqd+LPMK3kHWL4tHlR/srFsZ0MWhRGtbHP8yMt7MmEA+mDtnCGdVsOniAnPDyd2N7gZevPA3uAPTDXRKW6MdZa/nSIJbD1nQ6Vr8FyC2NfGGKTsmwz9jrJhDRTq3H8xX74qmnZ01+Ed9DQTzuS8unqVcyLqx8VHPzDs0UesO0571taJKRzrotEn632s9vGbfQstRVJSxsRfCnMyZg3tHTtlb8eTs0N4XOFiXR1JsXoVk2AvXU9RlHIfP4zekxYKqIqVGYjj0zixY9jVtOpSRF0Zm7LpJR6ipCOebnsnWwirGYVSv55/DtSAFT4SJ0NJHPiDNZ+zecB4ZweagG5mwpWRCWRNSCBpjRiE617Nrys95uciAwfjmTndsA3Y7 2025-08-05 12:20:04 [INFO]: item found in queue is if condition 14409 2025-08-05 12:20:04 [INFO]: item found in queue is 14409 2025-08-05 12:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBJmrqK75Ec3ofg/oBKs3A8Noe2bSzdACwISny03yzRe9WYanZHJOODL4hSRz3k6vKAHiUPwIEMWM5YE45e+t7+zHtQceYMPtgTp0ahZJILIlSxB5ZoonpwrVDD98VXsZ7IG+hdI3tLliA07YN33ePBg0Ljp0Do3J34CIVzQ2gB7djuGQAnbTrZTfo7y5f4W0Fs3oEfOeZRKpCbZDZPXvweWbqmJ23mRTtJZ2Ll4YDekwVzwEEJTkfrJJyrxzKcBXDP/LmbGz7e1aiczOxVIP0aeqNZMlHRVrMAk6OX9Zd87/4j72XC9BIlKNva+9w2n4RZMyZ90P/khh3+GjoOMjODXZo2XGtT5to2XswAf5Pr/Gh0trQqNUQAte0+g+pyKrQCYbSYMIX1y+RFc+n3fY5OYAF/crFXOGK46/DjCBMYHpjHslQmy4IcpYD1grbQOh8 2025-08-05 12:20:05 [INFO]: item found in queue is if condition 14409 2025-08-05 12:20:05 [INFO]: item found in queue is 14409 2025-08-05 12:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBnU1Obr4bKJpM+HQteSDoJyoYSDmqdM/RJIkLj7+BbfTZbGEj+M+otcObaUCYZPD6USqmrbewzv9BS2kBy1KFmG/sV/NTND/O02QWBZNQOgFRgjRyCp5nzEIq8srfRSjfGPTYnv01P66fNy2JkhGiqSRZqi5at4O3Xle6sAb6aUgtsjrRQcsdAapGRv4aWNtTgCoHqIZ/qPimNaBPcCiApMfa3oTA5uKdfizk0BQWgG3Yg/klsBfmbKqm/iy5EeeTl4e9vrXEJOSxaV4T2D17y3mNWwCHn5IELgCceRMkdb22tOdg6APqUGHBzETUkCD0OXe77dKB/mp287wqbnG+aOI9lQ+DOhQhmArT2ja/UZGyu9WHV7fEl3vdabo8ey/jStZfnLcYlcwiQunhAkBTbCsEp3yGupSvE3DerpnjQ1WArpvlKZl5+m+dRIY3OB+p 2025-08-05 12:20:05 [INFO]: item found in queue is if condition 14409 2025-08-05 12:20:05 [INFO]: item found in queue is 14409 2025-08-05 12:20:06 [INFO]: Message deleted from the queue for receipt handle: AQEBfSrje83ql0itza761kyMfQROOKRFagMu854YflGgT72/z8qiSaePWYgW+MB00mSXlWRdAnimYMg4omSlzxXWNCWX2yqYP8n4X4pBcxfW17ljzas5P9OkT3WaZRQgppabcCY8ogYX7AzBhdhWoFsm1yKF97MNSnPBTBr74317IhiZKfo+vqI+LRGKL1WLWU4FZfVnWaqjSz5z3xKaGIA4N7Dee+qIfkfkNFl5v6vtuB2jMj75gEWPFBhk3105tZow9lbzcrRtzFUaDB3kJyDQqd8dUBZmepdk9LjEv2mCxx62bL1ioMghq/H7Twu2CCES7Ay7hTm1/xFHE7VKdpzrvlO551bziqODA3/rDoqXWVtXdgCVDOiKC+WIYBnV/dpvE/OQ8D59m80yIfjgzW9C9JSzNez60rXBNryYdAIsJFkMT7vl1nev0sPCXIitWS4z 2025-08-05 12:20:06 [INFO]: item found in queue is if condition 14409 2025-08-05 12:20:06 [INFO]: item found in queue is 14409 2025-08-05 12:20:07 [INFO]: Message deleted from the queue for receipt handle: AQEB84H8w2rusr8gB1Wf/Y7iu0IfiK70jyzFarXnQjCyIxnLRI+lA2iQc8b2gM+x3/ObnSMnITiUV6XqLefgtOOjAfqD3EMKHMWOtR3hH5Yv5yHFq1OAjRJ86Zj5cUfzYlYbXGsErTDzVzWHaljQAz3Jek/CQGOsxZLKxtl5nO+fcSqXmi0E+L1AFiXSERfjjoxZrQUmVJlMTfAL3B4of9HhVZPqD1hgQDNEdUssHRiI8MblPbzYYxFdHneIAAcbGwkIDYLIAmXAY4WxPQQPYah84Dzl8MZhZdY1j8RLJkfU87JgGm5jYq4qowBIEUx6Y4cKpX0VSvrwDGQXdp2fthwCsUs3Ktu4zF1N93MQAWl4793ZVrXFx0CK/yAbgvT117WVfGlRTUMDcQTa73keL5zs8JfdxJT5WXLRL3zq2OiYenVXVhPeKwRNKEBdHiTuBNXD 2025-08-05 12:20:07 [INFO]: item found in queue is if condition 14409 2025-08-05 12:20:07 [INFO]: item found in queue is 14409 2025-08-05 12:20:07 [INFO]: Message deleted from the queue for receipt handle: AQEB7cU472Tx3TUIc/VHHWcrXgXk9G15e83DxdLTTnemz/rDKRdysSamXOGQ0743/1iMvS+//+IzEMCaAoYYKtoIh7cVd2pnH24GIxNQZ0LMqOAclbeocLCbGcd80LCmFlTh1J+TMCQvnLNW5EYm6tZouYNTNNTWqrFxl+uORtCL8ET3IWoqbds6f0gEWo4XhlLjkCadp7huUQu9LcdkgE3cW93Icwn3hsFFBB1JwVIbz4MKpQunXrqbMOGLccA9HJmCTvBdgbIWhHzo8REO8tGBxftAJEvucyrgqMl7qboFNMb9/c2yOs+3HMTWHPJgX0Rn6hpt7Kh4860ZMQJVo0UzHCUBZqH7mvaXWPSCLBLlMqrfpPAwjbkurjvmQ8bUkeOZC7s85J7gnqCuzTJtfYeWue26Iqhxey3L2+tDU7A7sfPSlm4V6aJEudmXOt8FmEdn 2025-08-05 12:20:07 [INFO]: Processed 6 messages, reached the limit of 6. 2025-08-05 12:20:07 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 12:20:07 [INFO]: inside itemsold and closed 14409 2025-08-05 12:20:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:20:09 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:20:09 [INFO]: Ebay item id :: 225694060247 exists in Database 2025-08-05 12:20:09 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:20:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:20:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:20:09 [INFO]: inside itemsold and closed 14409 2025-08-05 12:20:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:20:10 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:20:10 [INFO]: Ebay item id :: 256733019358 exists in Database 2025-08-05 12:20:10 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:20:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:20:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:20:10 [INFO]: inside itemsold and closed 14409 2025-08-05 12:20:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:20:12 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:20:12 [INFO]: Ebay item id :: 225680055823 exists in Database 2025-08-05 12:20:12 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:20:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:20:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:20:12 [INFO]: inside itemsold and closed 14409 2025-08-05 12:20:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:20:14 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:20:14 [INFO]: Ebay item id :: 325987087223 exists in Database 2025-08-05 12:20:14 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:20:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:20:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:20:14 [INFO]: inside itemsold and closed 14409 2025-08-05 12:20:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:20:15 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:20:15 [INFO]: Ebay item id :: 225680055823 exists in Database 2025-08-05 12:20:15 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:20:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:20:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:20:15 [INFO]: inside itemsold and closed 14409 2025-08-05 12:20:17 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:20:17 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:20:17 [INFO]: Ebay item id :: 256733025941 exists in Database 2025-08-05 12:20:17 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:20:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:20:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:20:17 [INFO]: in processold action queue is array for {"44680635":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44680635","ebayitemid":"225694060247","shopifyproductid":"8097168261342","variants":[{"price":"9.99","quantity":0,"weight":"0.9375","shopifyproductid":"8097168261342","shopifyvariantid":"44286151262430","shopifyinventoryid":"46383339864286","shopifylocationid":"","product_id":"44680635","variant_id":"77585855","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44776915":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44776915","ebayitemid":"256733019358","shopifyproductid":"7575688642782","variants":[{"price":"59.99","quantity":0,"weight":"2","shopifyproductid":"7575688642782","shopifyvariantid":"42527931924702","shopifyinventoryid":"44621924729054","shopifylocationid":"","product_id":"44776915","variant_id":"77685457","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44659532":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44659532","ebayitemid":"225680055823","shopifyproductid":"7850500128990","variants":[{"price":"9.99","quantity":0,"weight":"0.9375","shopifyproductid":"7850500128990","shopifyvariantid":"43570642714846","shopifyinventoryid":"45666288238814","shopifylocationid":"","product_id":"44659532","variant_id":"77564752","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44687409":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44687409","ebayitemid":"325987087223","shopifyproductid":"7951728279774","variants":[{"price":"11.99","quantity":0,"weight":"0.9375","shopifyproductid":"7951728279774","shopifyvariantid":"43982408483038","shopifyinventoryid":"46078888345822","shopifylocationid":"","product_id":"44687409","variant_id":"77592634","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44776917":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44776917","ebayitemid":"256733025941","shopifyproductid":"8051763642590","variants":[{"price":"59.99","quantity":0,"weight":"2","shopifyproductid":"8051763642590","shopifyvariantid":"44209418141918","shopifyinventoryid":"46306505064670","shopifylocationid":"","product_id":"44776917","variant_id":"77685459","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 12:20:17 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 12:20:17 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:20:17 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:20:17 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:20:17 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:20:17 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:20:17 [INFO]: Shopify Inventory id 46383339864286 2025-08-05 12:20:17 [INFO]: Shopify Location id 58450641063 2025-08-05 12:20:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:20:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:20:17Z","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 12:20:18 [INFO]: Change: available | Delta: -1 2025-08-05 12:20:18 [INFO]: Change: on_hand | Delta: -1 2025-08-05 12:20:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:20:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44680635 and user_id = 14409 2025-08-05 12:20:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77585855 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:20:18 [INFO]: Shopify Inventory id 44621924729054 2025-08-05 12:20:18 [INFO]: Shopify Location id 58450641063 2025-08-05 12:20:18 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:20:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:20:18Z","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-05 12:20:18 [INFO]: Change: available | Delta: -3 2025-08-05 12:20:18 [INFO]: Change: on_hand | Delta: -3 2025-08-05 12:20:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:20:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44776915 and user_id = 14409 2025-08-05 12:20:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685457 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:20:18 [INFO]: Shopify Inventory id 45666288238814 2025-08-05 12:20:18 [INFO]: Shopify Location id 58450641063 2025-08-05 12:20:18 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:20:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:20:18Z","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 12:20:18 [INFO]: Change: available | Delta: -1 2025-08-05 12:20:18 [INFO]: Change: on_hand | Delta: -1 2025-08-05 12:20:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:20:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44659532 and user_id = 14409 2025-08-05 12:20:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77564752 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:20:18 [INFO]: Shopify Inventory id 46078888345822 2025-08-05 12:20:18 [INFO]: Shopify Location id 58450641063 2025-08-05 12:20:18 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:20:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:20:18Z","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 12:20:18 [INFO]: Change: available | Delta: -2 2025-08-05 12:20:18 [INFO]: Change: on_hand | Delta: -2 2025-08-05 12:20:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:20:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44687409 and user_id = 14409 2025-08-05 12:20:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77592634 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:20:18 [INFO]: Shopify Inventory id 46306505064670 2025-08-05 12:20:18 [INFO]: Shopify Location id 58450641063 2025-08-05 12:20:18 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:20:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:20:19Z","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-05 12:20:19 [INFO]: Change: available | Delta: -3 2025-08-05 12:20:19 [INFO]: Change: on_hand | Delta: -3 2025-08-05 12:20:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:20:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44776917 and user_id = 14409 2025-08-05 12:20:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685459 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:20:19 [INFO]: updateIdsQuantity -> ["77585855","77685457","77564752","77592634","77685459"] 2025-08-05 12:20:19 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 5. Affected rows: 5 2025-08-05 12:20:19 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77585855 THEN 0 WHEN id = 77685457 THEN 0 WHEN id = 77564752 THEN 0 WHEN id = 77592634 THEN 0 WHEN id = 77685459 THEN 0 END, quantityflag = CASE WHEN id = 77585855 THEN 0 WHEN id = 77685457 THEN 0 WHEN id = 77564752 THEN 0 WHEN id = 77592634 THEN 0 WHEN id = 77685459 THEN 0 END WHERE user_id = 14409 AND id IN (77585855,77685457,77564752,77592634,77685459) 2025-08-05 12:20:19 [INFO]: QUANTITY Updated IDs: 77585855, 77685457, 77564752, 77592634, 77685459 2025-08-05 12:20:19 [INFO]: Successfully processed data for user 14409 2025-08-05 12:20:19 [INFO]: Execution Started 2025-08-05 12:20:19 [INFO]: Execution Finished 2025-08-05 12:30:01 [INFO]: Execution Started 2025-08-05 12:30:01 [INFO]: old server sucessfully connected 2025-08-05 12:30:01 [INFO]: sqs client sucess created 2025-08-05 12:30:04 [INFO]: Number of messages in the queue: 6 2025-08-05 12:30:05 [INFO]: item found in queue is if condition 14409 2025-08-05 12:30:05 [INFO]: item found in queue is 14409 2025-08-05 12:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBEZr1H0RO5KRzN/O+mNG1J+Bh0g2FKbwZhXkxumyZatzyWTnN3GQ8B/+SgJXzlnRWycqFfg62ChBuhPeVa+S4vcT6R4ppYH7fctiRXssD7kfZ6/cQlv7CWv7+lLUo/bJMPCGt/C8oGehbftvDhRvrY9zIPrvOKESkVPe86lHbCDdsHpmMKcLsZl/tdBnTI7D7BJD9xtHlAjwTRJUpPc42+uxeSFmY8/W/Zm9A8oYbV0AWh64cnC6EUIvx8faeeMxN0tRGAPc45Niuw0c5NoYWeyvZQchlhI3xbv3EZQPv1BzmobO6ODPUDxZ0p3vbBDtZL+9jhkpDYq8I9wvJPkoc1XHi7UBe6OUL6HH/5afXlLOnfRyaRBaW/YDGkMM16Zr/bhGLiY9qArznKN1NlSHajyiRzpfzU6xx0/g7HLmNv3a1imKUxMDgyEvCX45yUYrE 2025-08-05 12:30:05 [INFO]: item found in queue is if condition 14409 2025-08-05 12:30:05 [INFO]: item found in queue is 14409 2025-08-05 12:30:06 [INFO]: Message deleted from the queue for receipt handle: AQEBE7aQZD4neb3cctJtzybtYBc/iL4VfPIQqk3kIrHzfm+QsVEhaI7fp76FHm4ZQtCbSa00M1BR7FbCiABfAAJOoKGEhuTkpWLkgWGiPiQhHmQKlRVOGPj41hGX0S/IpGWwc3B6xx0gIUIFjaxjGXX2OSd7L3itrqXG7+5QppYkv8AC5Lns311+ZXxlRQVsvOvvZ5Fo2U9hKXUu8B82ZeC2+ajE9HEwQenDat3EPJy59LMF8bdOZ1irZWcIFyYXkuOgQh0KtYLaC+50p17a78Kemub0LGTKubJ3uU+5BxCygPuFO7VniKuT64SvtNK+nmOPhPApT0eQGavMpV8mAeLo/EBIu82auc1xRNFsXKY0A1hdIRe3fCWePWcxDavL+cfSbSJ2R+XDxUFinX02X2N17WUUgYj8p+9nk8FaFo852BibaSWdwsqJvGttfRPVJmbb 2025-08-05 12:30:06 [INFO]: item found in queue is if condition 14409 2025-08-05 12:30:06 [INFO]: item found in queue is 14409 2025-08-05 12:30:11 [INFO]: Message deleted from the queue for receipt handle: AQEBOZE6VQhKxPKCx+HbHFj0D9KSz6cX80ejWu0ACKunC6o4jSNsJjjuoxasCZjqmDMg7D7wx0F2j1mQyYjV1ktP9DaPckGvcHgarQLHkZZT8hARn9aWhchscS1dn4iScGV8D8zhl2g6t68F300NNU6UOOzNf41HYeJVhZ+hFXLCUsQPJCTYWDnb3P7VsycDZrxXONloLJktAcLHAys4LTkafYPIAs/F/SQFLLfEl8KerHdTewZMQxY+gishY1HpHybKFWjaZVl2GvmX1BvDiWPu5ixyRHJus25jJTJHqN1e6YB12jzzY0DP17wf0WHSsScrXgmdNplquaEXL7CI9g5qukTaL9MVDAO6fOAcKPOttGNsX3bwdMqBgQFAYQUVL/Q8XhM0WldX6x2v91/QMjvNLRqyFpIWh5aXAfCdVTlyH5iHIMBGUY6kigvfevlMqA0/ 2025-08-05 12:30:13 [INFO]: item found in queue is if condition 14409 2025-08-05 12:30:13 [INFO]: item found in queue is 14409 2025-08-05 12:30:13 [INFO]: Message deleted from the queue for receipt handle: AQEBrk1qYzfPoPZ/Ax+5Up1AL4YBo1WfPndLoJErbUCsqW0TXlq8XJ9Izro2R3m5//7HsuKsbkbv5TKToB65VVTbEDyCJIp2N3g039aWs/Xg8sGaa0q3wEqqBc/E67vn6dBKKw/jSUsT4THat6JcO+5BQJ2dLXrscbowwXWQkIK75TVNvX35Su0JU4v93odvpvlND5G3TMbAz0vV98DYcbAYZCIcBld6wBTP+IyyFKB17AbvJgfgC8BTiNdUlg0p8GunflnEMjeuc3kiyNDA1+wv2pCWknihwmq85QKQcol66qBlKAGy3XA7BidZ8sxVo3AmEGZRShfZvlkC1+8cOrfj3ZEmR+2JbTnpF96lWSA16kgyuuWB0V6aqTpLI2wglbYZAk3cKSSxhogbjf1QJzcFalFieJTFQNQZbr5h5vJsNzH8cfqoLA6dF3JaU7Va5s0t 2025-08-05 12:30:14 [INFO]: item found in queue is if condition 14409 2025-08-05 12:30:14 [INFO]: item found in queue is 14409 2025-08-05 12:30:14 [INFO]: Message deleted from the queue for receipt handle: AQEBnZZ14Cn+w1MGtrwIstVM/obWFad3Q4HSPATZNYdsb4sBmBtl+ih5MKya2P1YcMs8Dy7bJgu2twV3nwrK5QI956BqrqRX5saZNlgM8A9pgcG4zJ8lQlyoy7tCXjVLFm0XsvXbVJ4WvvNDCsh01h6FK2EfLjgpTop9XWZmdnLGaH1X5zXiEzRJNreb0ztmO3uJsmxNwafkhqZzGTemeRKlViubvn5bCi7f7P7viahnwciBa1tf6zQorPde1HSMlWbHrpWQWr+1XiFZhkeUoJD4INhygu4JN+SvwsbL/YuLsVJjWbcrWDK6sHnoSVTOt2Re6GS+HYyty9dD5id+lCp6BbHkPZe4NkTSFVk882grMqSBjsldEKb+x318SoCC9VK5GdNoF+GQQx6owFrIqHKwmlMu3qjd5Iq4aeskEmUelREDGj8SH/cAtHHlLLNw10ix 2025-08-05 12:30:14 [INFO]: item found in queue is if condition 14409 2025-08-05 12:30:14 [INFO]: item found in queue is 14409 2025-08-05 12:30:15 [INFO]: Message deleted from the queue for receipt handle: AQEB5j/zJodlvGmiYWoGROBC5Cqu8ukW9NM6qPVx7/ktyZe1uiaGCCPZfpPXV1z54hJybt+JFUC/ibTipUV8aG86FF0vIc2N/qZqTg9ifKqCsb2WjdBM8nz1y4pyGDqUkaFqxTiPytO5k9XOgb2ZzQCq/OgY5cvIf31qbHDVwU1XTgqUu88X9uU0/WxPt790NDXj+6yEP3aFoQno/J82fZZDjDkqfSm+/RTAj5whqoxi7YrH4jhvWuQedMEV/rS4i3C9c0Kefy7TGf44n2PcEyz2LXslvl3dzgdWovLC6k9BXOSFVIHSlZb3fRYyAWVfyzmAvWny1Mmw2IrmtVPY3BVgZ7KEQ5t8VuCnJuraO9DngNMHp17NZWR0AuwsZbTAC46mB70Ne6ic141P4t3q4tsTXhuPrz8zvTlzdrbToYMp2osYzjhTsDMxxCJUkvf4XMM6 2025-08-05 12:30:15 [INFO]: Processed 6 messages, reached the limit of 6. 2025-08-05 12:30:15 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 12:30:15 [INFO]: inside itemsold and closed 14409 2025-08-05 12:30:17 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:30:17 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:30:17 [INFO]: Ebay item id :: 226170073344 exists in Database 2025-08-05 12:30:17 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:30:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:30:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:30:17 [INFO]: inside itemsold and closed 14409 2025-08-05 12:30:18 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:30:18 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:30:18 [INFO]: Ebay item id :: 326186032685 exists in Database 2025-08-05 12:30:18 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:30:18 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:30:18 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:30:18 [INFO]: inside itemsold and closed 14409 2025-08-05 12:30:20 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:30:20 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:30:20 [INFO]: Ebay item id :: 326157605971 exists in Database 2025-08-05 12:30:20 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:30:20 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:30:20 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:30:20 [INFO]: inside itemsold and closed 14409 2025-08-05 12:30:22 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:30:22 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:30:22 [INFO]: Ebay item id :: 226145683977 exists in Database 2025-08-05 12:30:22 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:30:22 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:30:22 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:30:22 [INFO]: inside itemsold and closed 14409 2025-08-05 12:30:23 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:30:23 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:30:23 [INFO]: Ebay item id :: 326151222493 exists in Database 2025-08-05 12:30:23 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:30:23 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:30:23 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:30:23 [INFO]: inside itemsold and closed 14409 2025-08-05 12:30:25 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:30:25 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:30:25 [INFO]: Ebay item id :: 226228215153 exists in Database 2025-08-05 12:30:25 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:30:25 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:30:25 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:30:25 [INFO]: in processold action queue is array for {"44688564":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44688564","ebayitemid":"226170073344","shopifyproductid":"8524245172446","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8524245172446","shopifyvariantid":"45465192595678","shopifyinventoryid":"47563177066718","shopifylocationid":"","product_id":"44688564","variant_id":"77593810","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44735172":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44735172","ebayitemid":"326186032685","shopifyproductid":"8106211115230","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8106211115230","shopifyvariantid":"44302885355742","shopifyinventoryid":"46400301170910","shopifylocationid":"","product_id":"44735172","variant_id":"77643079","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44735037":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44735037","ebayitemid":"326157605971","shopifyproductid":"8705151238366","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8705151238366","shopifyvariantid":"45959084409054","shopifyinventoryid":"48057716998366","shopifylocationid":"","product_id":"44735037","variant_id":"77642930","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44646539":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44646539","ebayitemid":"226145683977","shopifyproductid":"8484639736030","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8484639736030","shopifyvariantid":"45367357505758","shopifyinventoryid":"47465322315998","shopifylocationid":"","product_id":"44646539","variant_id":"77551728","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44734946":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44734946","ebayitemid":"326151222493","shopifyproductid":"8707751379166","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8707751379166","shopifyvariantid":"45965163135198","shopifyinventoryid":"48063900319966","shopifylocationid":"","product_id":"44734946","variant_id":"77642839","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44735219":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44735219","ebayitemid":"226228215153","shopifyproductid":"8124168831198","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8124168831198","shopifyvariantid":"44338280497374","shopifyinventoryid":"46435967566046","shopifylocationid":"","product_id":"44735219","variant_id":"77643126","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 12:30:25 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 12:30:25 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:30:25 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:30:25 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:30:25 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:30:25 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:30:25 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:30:25 [INFO]: Shopify Inventory id 47563177066718 2025-08-05 12:30:25 [INFO]: Shopify Location id 58450641063 2025-08-05 12:30:25 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:30:26 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:30:26Z","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 12:30:26 [INFO]: Change: available | Delta: -1 2025-08-05 12:30:26 [INFO]: Change: on_hand | Delta: -1 2025-08-05 12:30:26 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:30:26 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44688564 and user_id = 14409 2025-08-05 12:30:26 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77593810 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:30:26 [INFO]: Shopify Inventory id 46400301170910 2025-08-05 12:30:26 [INFO]: Shopify Location id 58450641063 2025-08-05 12:30:26 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:30:26 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:30:26Z","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 12:30:26 [INFO]: Change: available | Delta: -2 2025-08-05 12:30:26 [INFO]: Change: on_hand | Delta: -2 2025-08-05 12:30:26 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:30:26 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44735172 and user_id = 14409 2025-08-05 12:30:26 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77643079 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:30:26 [INFO]: Shopify Inventory id 48057716998366 2025-08-05 12:30:26 [INFO]: Shopify Location id 58450641063 2025-08-05 12:30:26 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:30:26 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:30:26Z","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 12:30:26 [INFO]: Change: available | Delta: -1 2025-08-05 12:30:26 [INFO]: Change: on_hand | Delta: -1 2025-08-05 12:30:26 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:30:26 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44735037 and user_id = 14409 2025-08-05 12:30:26 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77642930 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:30:26 [INFO]: Shopify Inventory id 47465322315998 2025-08-05 12:30:26 [INFO]: Shopify Location id 58450641063 2025-08-05 12:30:26 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:30:27 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:30:26Z","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 12:30:27 [INFO]: Change: available | Delta: -1 2025-08-05 12:30:27 [INFO]: Change: on_hand | Delta: -1 2025-08-05 12:30:27 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:30:27 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44646539 and user_id = 14409 2025-08-05 12:30:27 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77551728 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:30:27 [INFO]: Shopify Inventory id 48063900319966 2025-08-05 12:30:27 [INFO]: Shopify Location id 58450641063 2025-08-05 12:30:27 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:30:27 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:30:27Z","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 12:30:27 [INFO]: Change: available | Delta: -1 2025-08-05 12:30:27 [INFO]: Change: on_hand | Delta: -1 2025-08-05 12:30:27 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:30:27 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44734946 and user_id = 14409 2025-08-05 12:30:27 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77642839 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:30:27 [INFO]: Shopify Inventory id 46435967566046 2025-08-05 12:30:27 [INFO]: Shopify Location id 58450641063 2025-08-05 12:30:27 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:30:27 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:30:27Z","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 12:30:27 [INFO]: Change: available | Delta: -2 2025-08-05 12:30:27 [INFO]: Change: on_hand | Delta: -2 2025-08-05 12:30:27 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:30:27 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44735219 and user_id = 14409 2025-08-05 12:30:27 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77643126 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:30:27 [INFO]: updateIdsQuantity -> ["77593810","77643079","77642930","77551728","77642839","77643126"] 2025-08-05 12:30:27 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 6. Affected rows: 6 2025-08-05 12:30:27 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77593810 THEN 0 WHEN id = 77643079 THEN 0 WHEN id = 77642930 THEN 0 WHEN id = 77551728 THEN 0 WHEN id = 77642839 THEN 0 WHEN id = 77643126 THEN 0 END, quantityflag = CASE WHEN id = 77593810 THEN 0 WHEN id = 77643079 THEN 0 WHEN id = 77642930 THEN 0 WHEN id = 77551728 THEN 0 WHEN id = 77642839 THEN 0 WHEN id = 77643126 THEN 0 END WHERE user_id = 14409 AND id IN (77593810,77643079,77642930,77551728,77642839,77643126) 2025-08-05 12:30:27 [INFO]: QUANTITY Updated IDs: 77593810, 77643079, 77642930, 77551728, 77642839, 77643126 2025-08-05 12:30:27 [INFO]: Successfully processed data for user 14409 2025-08-05 12:30:27 [INFO]: Execution Started 2025-08-05 12:30:27 [INFO]: Execution Finished 2025-08-05 12:40:01 [INFO]: Execution Started 2025-08-05 12:40:01 [INFO]: old server sucessfully connected 2025-08-05 12:40:01 [INFO]: sqs client sucess created 2025-08-05 12:40:03 [INFO]: Number of messages in the queue: 2 2025-08-05 12:40:04 [INFO]: item found in queue is if condition 14409 2025-08-05 12:40:04 [INFO]: item found in queue is 14409 2025-08-05 12:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBryA85oOQfWeBCWVfj4JpsPlf8+3GikmmVvN+3riS7MhNrH+U9KIzkqLM9Mn8Jyw7d93JPxjSHUegG8rWnjoq+QJo6e6W8N8DpZhotD3qXLPsZ1iBLt76bRUxOinsh7Xd3KlZBJvjBVelqYqRD9JB8lq0wCokFn31FDv+bb7CWlroIGtiYkVOR8VaqfaHmBItE9NPcObmSQPCLhCjhAwrMp0vkt9uuvuFDA5PtRDCXbqBY5fEst3oJy1/SEBdPi1BD4T6uw9cBCTk1n5zLnx+x5cu011uME3Uh2hL1IVKuBN7ReAnURhdOStShrjP9nBN9b0H92jOTpm6YKOOp6Yf5hzVMV4gyebQ1+PsnnMQ+Wrt2K5sX90xZVvWLMdvxJJWAvgMBbfBgx953TPBjXgqkbDAAKPNH6LekcjgJxy45m8c2mrHmaMXDFUB6EgN5uvU 2025-08-05 12:40:05 [INFO]: item found in queue is if condition 14409 2025-08-05 12:40:05 [INFO]: item found in queue is 14409 2025-08-05 12:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEBZkPiO44bd80FTushEBYVT9Frbu4S/NAhncHNf/5D4ORq0SLST5wiaQoTTGsOGjlNULevOrNFkg8GcyV5fPhS492TF7lFfWCmLcYn50Xocb61Itd5tvYOwYhChn5NdZeS3A88oYSWdai513SFbgumOn0J4M2S/lzHyKsc8BOsr8GVBVo85+tcu2hGn7XbejxvdKHIFpfvg+w2zRaj+USD6iTrFJlfgdHar2UJAUQwlfmJnYab4P4BpOE7pKHXy82w3Ux+1F97zDIdfO33jxonJHGYRVdmZEI11R0idlopx9kS7I8YfD+IbmhAGUjHX29wH8hv3s0+0eQFS80fX+nmXiNiUsMkwvTxv6d/4/JhabuuHJpe2I3JygLnyXbYTMv+z8oSp8nL8SL8yJ3+Ry37Koe1Kgo9hzNMF/rdSPgJSeRMX99tRS0c53FEB2XEak/g 2025-08-05 12:40:05 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-05 12:40:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 12:40:05 [INFO]: inside itemsold and closed 14409 2025-08-05 12:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:40:07 [INFO]: Ebay item id :: 326359282485 exists in Database 2025-08-05 12:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:40:07 [INFO]: inside itemsold and closed 14409 2025-08-05 12:40:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:40:09 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:40:09 [INFO]: Ebay item id :: 326161283857 exists in Database 2025-08-05 12:40:09 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:40:09 [INFO]: in processold action queue is array for {"44711801":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44711801","ebayitemid":"326359282485","shopifyproductid":"8752701407454","variants":[{"price":"209.99","quantity":0,"weight":"2","shopifyproductid":"8752701407454","shopifyvariantid":"46120994570462","shopifyinventoryid":"48220081389790","shopifylocationid":"","product_id":"44711801","variant_id":"77619414","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44642004":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44642004","ebayitemid":"326161283857","shopifyproductid":"8695096148190","variants":[{"price":"209.99","quantity":0,"weight":"2","shopifyproductid":"8695096148190","shopifyvariantid":"45933949911262","shopifyinventoryid":"48032401293534","shopifylocationid":"","product_id":"44642004","variant_id":"77547193","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 12:40:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 12:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:40:09 [INFO]: Shopify Inventory id 48220081389790 2025-08-05 12:40:09 [INFO]: Shopify Location id 58450641063 2025-08-05 12:40:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:40:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:40:09Z","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 12:40:09 [INFO]: Change: available | Delta: -2 2025-08-05 12:40:09 [INFO]: Change: on_hand | Delta: -2 2025-08-05 12:40:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:40:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44711801 and user_id = 14409 2025-08-05 12:40:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77619414 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:40:09 [INFO]: Shopify Inventory id 48032401293534 2025-08-05 12:40:09 [INFO]: Shopify Location id 58450641063 2025-08-05 12:40:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:40:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:40:10Z","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 12:40:10 [INFO]: Change: available | Delta: -2 2025-08-05 12:40:10 [INFO]: Change: on_hand | Delta: -2 2025-08-05 12:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44642004 and user_id = 14409 2025-08-05 12:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77547193 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:40:10 [INFO]: updateIdsQuantity -> ["77619414","77547193"] 2025-08-05 12:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-05 12:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77619414 THEN 0 WHEN id = 77547193 THEN 0 END, quantityflag = CASE WHEN id = 77619414 THEN 0 WHEN id = 77547193 THEN 0 END WHERE user_id = 14409 AND id IN (77619414,77547193) 2025-08-05 12:40:10 [INFO]: QUANTITY Updated IDs: 77619414, 77547193 2025-08-05 12:40:10 [INFO]: Successfully processed data for user 14409 2025-08-05 12:40:10 [INFO]: Execution Started 2025-08-05 12:40:10 [INFO]: Execution Finished 2025-08-05 12:50:02 [INFO]: Execution Started 2025-08-05 12:50:02 [INFO]: old server sucessfully connected 2025-08-05 12:50:02 [INFO]: sqs client sucess created 2025-08-05 12:50:05 [INFO]: Number of messages in the queue: 4 2025-08-05 12:50:06 [INFO]: item found in queue is if condition 14409 2025-08-05 12:50:06 [INFO]: item found in queue is 14409 2025-08-05 12:50:06 [INFO]: Message deleted from the queue for receipt handle: AQEBXU7d4VW/wHQrYT8do5uXNbBdhrBSmkbYUAJmH1AN2Zi2MgP2E+iVYOpsYWfPX4nKlhxTKZPO5nWc0EkscF70tlL39q0oeCrOJdac7c0Kp1g9NfydZ1lPHZfjlleUId+uXAtzGWQGlwuEviqq/6caru+MYAkjwFFe+zepVze2wTInW42i3WJc7gZRbxIZ+HKOMU3nYhls3UPDLPD625U3jO/9yzeYsDLcoQQ6mwvB1eLLsoNJHQg6fOoVZm8vbly/X1Godibn2avJJhg3JM5Xht6f9xjVw2EQGvFTQ7n3a5jQ3AVVEXVBkPAIAr0HJGg0gVfcGck+bIkwoKKbBuMj7nl6Fgk0Zxi+SRQJhY7HmKbGQiBiEFxoby0BLYdF+EoA7NSnzQVP1uZLKnSB9dYEi9heu9RHCl8XCGioZ3RWbI556ZrgVFNp3OzC8HZiqz5W 2025-08-05 12:50:08 [INFO]: item found in queue is if condition 14409 2025-08-05 12:50:08 [INFO]: item found in queue is 14409 2025-08-05 12:50:09 [INFO]: Message deleted from the queue for receipt handle: AQEB81nyCubRU7QOPLDgA0YFrr4aBM3JvXkJOJUjOG7hf6IeOodFq5Eyu9jX/qhjpHGXjxBkE8Ja6/NgFllgviWkzyUgVUP+6YPTnb68UX4qjdDVpUa/6qpv0gwyjqejf4kiulzqgx0hd+T6wH8k5s1+ufN/wtyU87KPmpPLjeSeRWR654wTljBl7J0leOt+JXcrboiZvcPxPyUhh/xrEZSjt5dby35GTGMk1Qo60ehjxaiZiEKM3v2vhrzCfUOjgn4kdOuOXyds+H3jXqKBHwWRIQVuC9Toq+cII9kYvBsLESr6FIem6/Aw9MLm7n/vLYsGytndzjOC+SZ5cfJWQfroKPkIKSxRr013l0TE8kHFsfAA6NygDz5q0EFAYnND0IzPaA2OCbiHIOqdhzQWzV2SCYI3xpIXF3QSmMVZ0/SPrQuOd2soHfa7fqSNtP58Yzmm 2025-08-05 12:50:09 [INFO]: item found in queue is if condition 14409 2025-08-05 12:50:09 [INFO]: item found in queue is 14409 2025-08-05 12:50:10 [INFO]: Message deleted from the queue for receipt handle: AQEBN22CNgdEOCQq1ihYJQboDFZwoVqduurZPO9+pPp8RSzMSt/sCa4vlb5o5Iy8bTFjnAZj39O4wHOQGJerM1RDF9JJKMkTbRHEybZT/Aw6NTPBozTEiOwMs5nNQVR2gCLXVRSn/1JwpfbueSCeSERLoguKP+TG/k1wGDb35/aJ4xMAx3gix4kDtHtLx+LXbiaLKT6DPJ1xKfPw64SyXYkpJHCHBE0y8Bi1gJIp+Bn+E3ZPi5aEdqL7mk5zAaUfxw5MsCnn7XpTlTqgFREtOd+vOHpVhMK7UASn3fznYrSWF3O2leuYfqpkUWGIm+U4JTn5i40SGfsdPQgawX2ki98TAei+dlxKLYz/Fxmc3yEKTvMPGaVCUPC/C/SelB3fNixqzn/IgvAwxwZa8dN0IGuURAHHDvRtXftKaol1F5ecLi8lH7xzAvM9rjTRzyaj8AAV 2025-08-05 12:50:10 [INFO]: item found in queue is if condition 14409 2025-08-05 12:50:10 [INFO]: item found in queue is 14409 2025-08-05 12:50:11 [INFO]: Message deleted from the queue for receipt handle: AQEBgDM4Lu83ezEjCTemCpW4KqGGvymYpgPsOfyuHtRTYlRuUoaf/uXS0hCOOL9B4PGrWvsqT1fsd7X80lEBVaCNbW9obkmC+jNMR7P3IO5REkQOMtkq5gPQn1ZcuV9bRyB1kBh0vTJnPRmDsk/aBfCJjMMA1I3iQUizRiJhOS3X+OBQ0i77A8oaBI93EBURn/Qi5/xn9slMWHb9Z9ULpqKyBNEtdOCFWVD3ca4/LyLk2WHsjIZWmD43HEucKWiQKViYvvgkscWW7FIN/kSpU4J5GJtfBjl8D8pYbMRIZRGgGgoEtkHcp1iJhEXd7torBs1i6vf4QDPyP53EJ3jlejlCGONUotpyM2MKGcRVSj+Y0UsSyVMCmsJMhtrxSf2pvzRgWsqK9Hff66BKyOlYUbypNfA+in/4vJiWARogYK4tbyeM98Qa4cm2FfrvnV+x9J3t 2025-08-05 12:50:11 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-05 12:50:11 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 12:50:11 [INFO]: inside itemsold and closed 14409 2025-08-05 12:50:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:50:13 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:50:13 [INFO]: Ebay item id :: 324738420197 exists in Database 2025-08-05 12:50:13 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:50:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:50:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:50:13 [INFO]: inside itemsold and closed 14409 2025-08-05 12:50:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:50:15 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:50:15 [INFO]: Ebay item id :: 304613648363 exists in Database 2025-08-05 12:50:15 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:50:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:50:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:50:15 [INFO]: inside itemsold and closed 14409 2025-08-05 12:50:16 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:50:16 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:50:16 [INFO]: Ebay item id :: 304613648363 exists in Database 2025-08-05 12:50:16 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:50:16 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:50:16 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:50:16 [INFO]: inside itemsold and closed 14409 2025-08-05 12:50:18 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 12:50:18 [INFO]: autolink for user_id 14409 is 1 2025-08-05 12:50:18 [INFO]: Ebay item id :: 326389406005 exists in Database 2025-08-05 12:50:18 [INFO]: Item is reliested :: exists in Database 2025-08-05 12:50:18 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 12:50:18 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 12:50:18 [INFO]: in processold action queue is array for {"44729988":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44729988","ebayitemid":"324738420197","shopifyproductid":"7105818099879","variants":[{"price":"10.99","quantity":0,"weight":"0.5","shopifyproductid":"7105818099879","shopifyvariantid":"41561748996263","shopifyinventoryid":"43658250453159","shopifylocationid":"","product_id":"44729988","variant_id":"77637873","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44709843":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44709843","ebayitemid":"304613648363","shopifyproductid":"7078954172583","variants":[{"price":"12.99","quantity":0,"weight":"2","shopifyproductid":"7078954172583","shopifyvariantid":"41464285200551","shopifyinventoryid":"43560740257959","shopifylocationid":"","product_id":"44709843","variant_id":"77617449","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44689082":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44689082","ebayitemid":"326389406005","shopifyproductid":"8784495182046","variants":[{"price":"69.99","quantity":0,"weight":"2","shopifyproductid":"8784495182046","shopifyvariantid":"46205895737566","shopifyinventoryid":"48305716068574","shopifylocationid":"","product_id":"44689082","variant_id":"77594334","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 12:50:18 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 12:50:18 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:50:18 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:50:18 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 12:50:18 [INFO]: Shopify Inventory id 43658250453159 2025-08-05 12:50:18 [INFO]: Shopify Location id 58450641063 2025-08-05 12:50:18 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:50:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:50:18Z","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-05 12:50:18 [INFO]: Change: available | Delta: -3 2025-08-05 12:50:18 [INFO]: Change: on_hand | Delta: -3 2025-08-05 12:50:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:50:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44729988 and user_id = 14409 2025-08-05 12:50:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77637873 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:50:18 [INFO]: Shopify Inventory id 43560740257959 2025-08-05 12:50:18 [INFO]: Shopify Location id 58450641063 2025-08-05 12:50:18 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:50:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:50:18Z","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 12:50:19 [INFO]: Change: available | Delta: -2 2025-08-05 12:50:19 [INFO]: Change: on_hand | Delta: -2 2025-08-05 12:50:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:50:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44709843 and user_id = 14409 2025-08-05 12:50:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77617449 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:50:19 [INFO]: Shopify Inventory id 48305716068574 2025-08-05 12:50:19 [INFO]: Shopify Location id 58450641063 2025-08-05 12:50:19 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 12:50:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T12:50:19Z","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 12:50:19 [INFO]: Change: available | Delta: -1 2025-08-05 12:50:19 [INFO]: Change: on_hand | Delta: -1 2025-08-05 12:50:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 12:50:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44689082 and user_id = 14409 2025-08-05 12:50:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77594334 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 12:50:19 [INFO]: updateIdsQuantity -> ["77637873","77617449","77594334"] 2025-08-05 12:50:19 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-05 12:50:19 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77637873 THEN 0 WHEN id = 77617449 THEN 0 WHEN id = 77594334 THEN 0 END, quantityflag = CASE WHEN id = 77637873 THEN 0 WHEN id = 77617449 THEN 0 WHEN id = 77594334 THEN 0 END WHERE user_id = 14409 AND id IN (77637873,77617449,77594334) 2025-08-05 12:50:19 [INFO]: QUANTITY Updated IDs: 77637873, 77617449, 77594334 2025-08-05 12:50:19 [INFO]: Successfully processed data for user 14409 2025-08-05 12:50:19 [INFO]: Execution Started 2025-08-05 12:50:19 [INFO]: Execution Finished