2025-08-08 16:00:01 [INFO]: Execution Started 2025-08-08 16:00:01 [INFO]: old server sucessfully connected 2025-08-08 16:00:01 [INFO]: sqs client sucess created 2025-08-08 16:00:03 [INFO]: Number of messages in the queue: 0 2025-08-08 16:00:24 [INFO]: Execution Started 2025-08-08 16:00:24 [INFO]: Execution Finished 2025-08-08 16:10:01 [INFO]: Execution Started 2025-08-08 16:10:01 [INFO]: old server sucessfully connected 2025-08-08 16:10:02 [INFO]: sqs client sucess created 2025-08-08 16:10:04 [INFO]: Number of messages in the queue: 2 2025-08-08 16:10:04 [INFO]: item found in queue is if condition 14409 2025-08-08 16:10:04 [INFO]: item found in queue is 14409 2025-08-08 16:10:06 [INFO]: Message deleted from the queue for receipt handle: AQEBbobE/Rnr4Odz4aoRBAsVu0U0296EHEhXK+Pj37qBfbJVA9BXnJCO7tWEP0rA2OT0bKTbboO/GyzpyARg03F0zTe0Gf25n69i2PQmKRebNx9wW1oyftPHzrK43BUlzdxgVSMojKavuvhLpf24NFfLGF8HceKoVw5sCpSqrklyfePNMWntUXjlKT4UG4AzvFemc/WqjLWWzUjKLmI3D7YZ73RQOWrkd9t5OqzonMWJMn4K1xCPF3JPJkPbS2EOLGi2xDi3P5Pw2kTpmMYaFc0mRD/YIW9hMBoBm0DHmIB5XVJmq3mnuJZZR3hrwg9Yel5zlXiGW5NpDuR8+s7uXhNMpkH7CB21Mr3FbcXJuuuYFYkCmn8ZA61cB761d6xqcSbC1iXEepT4ONHVuF1zKfRLFa+1qd68HBTktOoIGMO8RhHmYgABj0UcNNEdeisECPb6 2025-08-08 16:10:06 [INFO]: item found in queue is if condition 14409 2025-08-08 16:10:06 [INFO]: item found in queue is 14409 2025-08-08 16:10:07 [INFO]: Message deleted from the queue for receipt handle: AQEBX4PuaCbBtMFpk7uS7dukx9nmyW/q1x+WskA1QRXr/stJ3Q8GCz0U+2K6959Ai0x7rR/VcHd1Qbzxeb6k4PKsm+mrtt2943ts3aKX7cu6o1/74Eq1SUVN4zdV2DloukwylZws9H00oqTOpF1OiuK51NVFSFVHWVa+eH6XlbumZyiZzb6n6CcCU1l7j8IeKBv6IMCWKtFnKMvGF+wkb+97g3AqlK6fyfh3BM/rZjQQNKIqTVLInGDqFalkwi1T2jXmGPc2dDY8tINdkLH4fM2sm2A/EQapewfvbBsfTaGdGzUbF7kN1gYxc0r+qdCjH9mJEJX8dUbGiH8Fyvxl5Fg3uLxHwDLfsxkdrJ5g3E2omkABK4izPeMR5ghdPkjwgBEwf7tBbgSNJH1HvuPxW+jiWPZucM4ZwTlxMaIi15/SIUjSePTjCapR1TSOMgeluGTB 2025-08-08 16:10:07 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-08 16:10:07 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 16:10:07 [INFO]: inside itemsold and closed 14409 2025-08-08 16:10:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 16:10:08 [INFO]: autolink for user_id 14409 is 1 2025-08-08 16:10:08 [INFO]: Ebay item id :: 256168779018 exists in Database 2025-08-08 16:10:08 [INFO]: Item is reliested :: exists in Database 2025-08-08 16:10:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 16:10:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 16:10:08 [INFO]: inside itemsold and closed 14409 2025-08-08 16:10:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 16:10:10 [INFO]: autolink for user_id 14409 is 1 2025-08-08 16:10:10 [INFO]: Ebay item id :: 335925883674 exists in Database 2025-08-08 16:10:10 [INFO]: Item is reliested :: exists in Database 2025-08-08 16:10:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 16:10:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 16:10:10 [INFO]: in processold action queue is array for {"44764812":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44764812","ebayitemid":"256168779018","shopifyproductid":"8104829780190","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8104829780190","shopifyvariantid":"44299807916254","shopifyinventoryid":"46397141876958","shopifylocationid":"","product_id":"44764812","variant_id":"77673354","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44587176":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44587176","ebayitemid":"335925883674","shopifyproductid":"8016313254110","variants":[{"price":"89.99","quantity":0,"weight":"2","shopifyproductid":"8016313254110","shopifyvariantid":"44144678404318","shopifyinventoryid":"46241582416094","shopifylocationid":"","product_id":"44587176","variant_id":"77479885","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 16:10:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 16:10:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 16:10:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 16:10:10 [INFO]: Shopify Inventory id 46397141876958 2025-08-08 16:10:10 [INFO]: Shopify Location id 58450641063 2025-08-08 16:10:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 16:10:11 [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-08 16:10:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 16:10:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44764812 and user_id = 14409 2025-08-08 16:10:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77673354 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 16:10:11 [INFO]: Shopify Inventory id 46241582416094 2025-08-08 16:10:11 [INFO]: Shopify Location id 58450641063 2025-08-08 16:10:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 16:10:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T16:10:11Z","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-08 16:10:11 [INFO]: Change: available | Delta: -1 2025-08-08 16:10:11 [INFO]: Change: on_hand | Delta: -1 2025-08-08 16:10:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 16:10:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44587176 and user_id = 14409 2025-08-08 16:10:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77479885 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 16:10:11 [INFO]: updateIdsQuantity -> ["77673354","77479885"] 2025-08-08 16:10:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-08 16:10:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77673354 THEN 0 WHEN id = 77479885 THEN 0 END, quantityflag = CASE WHEN id = 77673354 THEN 0 WHEN id = 77479885 THEN 0 END WHERE user_id = 14409 AND id IN (77673354,77479885) 2025-08-08 16:10:11 [INFO]: QUANTITY Updated IDs: 77673354, 77479885 2025-08-08 16:10:11 [INFO]: Successfully processed data for user 14409 2025-08-08 16:10:11 [INFO]: Execution Started 2025-08-08 16:10:11 [INFO]: Execution Finished 2025-08-08 16:20:02 [INFO]: Execution Started 2025-08-08 16:20:02 [INFO]: old server sucessfully connected 2025-08-08 16:20:02 [INFO]: sqs client sucess created 2025-08-08 16:20:05 [INFO]: Number of messages in the queue: 3 2025-08-08 16:20:05 [INFO]: item found in queue is if condition 14409 2025-08-08 16:20:05 [INFO]: item found in queue is 14409 2025-08-08 16:20:06 [INFO]: Message deleted from the queue for receipt handle: AQEBhidpn5nqYP5ICCMbr5elXPzsnOzoWq8dro3joFSh5NsTuh6LDhWWOjqQvbDibkWUnXxsj3Y+3Lg5ubB8hA32W8nNHhDR9mnscXr+pLtvtR+OZ0LnXIOEb9cYpFXwQvpPE/55y8THYHTE7tPxzhcefbRXpUzv2pcS3/Mv8wNFXZ+Fvo9TEF2f+Lu6moub0hh230m3CdyeclNjvcigLYJl4++E4cxxk+CJon/TRik2hCoZVgq2h3pxftu0+SEb/2biUci4YdKaH8ir/FMUqCKutFYYFCAizjPPcCKcwMr1pyzFa7VCaFcGshStw4rzMTmofU5u3Od7l3V6LV3v3HY5TaLlvuQu12bM/UWmTIzjRk1i+ZVuQlfJQzXtJJE53JkxbwPPMMS1BHPsn0+ggxsvsbUEU1mHKKoOdO/XXpFjsa1cjjbUQGN3LtTUUPueoOSf 2025-08-08 16:20:06 [INFO]: item found in queue is if condition 14409 2025-08-08 16:20:06 [INFO]: item found in queue is 14409 2025-08-08 16:20:07 [INFO]: Message deleted from the queue for receipt handle: AQEBqEmZbUFDFZefHHgJ39uqX2dEdZNrufknu4iRYuAeIU35qTpUYi6p5//LGjB+bluergc/TUmGi60TsPZgTRtMccouU10JBTIjzaFTc81oLW4PZYxdS3rZOxPyKf7EwdX85RNE/uvC6FWuNkoexo9XJ1XMwMQl4OS01nN02G0b5HXnh0JnJJYxRS2JJNVvkpRiy9OgNeCpvBowFpGp7SXZo+sRCY16FQ+h9F5vraIlFaVSY88TrA8M1ImbQ5FLwpdWcWzLaK4rlQI0/apAXlkXe617sS+x9Ds5R0O5baeyUVB31d5xe+nJ0WlFva7rbbIFrwOh+vWjW94iUrQadTsB2tRLUnRvLofB5wAuYxJDex/42YWTmVKSWBNQFlgNbarE030FZ6J07s/j/nwoJ3lQ1dyAgF8by706NdQMuJt3GAnpl/LmoNhk40itoBANlsan 2025-08-08 16:20:07 [INFO]: item found in queue is if condition 14409 2025-08-08 16:20:07 [INFO]: item found in queue is 14409 2025-08-08 16:20:09 [INFO]: Message deleted from the queue for receipt handle: AQEBXOCXt8tHLWiSQYtcvsELU45NfJNpYr5fEAlv6oMNSdVsqgux68cQ8UnJDx2+dGXpGPbjP3QqI/FyHOk8vZiqvzeMyre3CgdJe+y5bqBN5E6esLm2TtvLszRefrd0tVUAZOPJxfXX2UXckjHyQRBeNF0eaa3HsM63pHxqvXLDwQnCiGi4hq30w5FzPlu/tSd23WVCvUllO7Pwuk99RaUNlxkqYgZCWs62kjXdjxNK5ToxPIPwVbp2kPSw7RrsUWw5tqpPpWVhyorcwNUcUq0LGcJ97vuN1oZNsPnR6/5pFp9gQhwrUJygzx2MYodvG/SsA5Caxk4f8KRDwKwT2XNNF/dMzKuwA6dE7y3tp1WROhEYg0j+V1QAE5jA8n0/coCQW96w20j7N96S1JuV+dfV23ZKzfPFyVDQedbwZdCh8KblJqC7uVqz7clBIsMOojGM 2025-08-08 16:20:09 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-08 16:20:09 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 16:20:09 [INFO]: inside itemsold and closed 14409 2025-08-08 16:20:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 16:20:11 [INFO]: autolink for user_id 14409 is 1 2025-08-08 16:20:11 [INFO]: Ebay item id :: 283643089460 exists in Database 2025-08-08 16:20:11 [INFO]: Item is reliested :: exists in Database 2025-08-08 16:20:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 16:20:11 [INFO]: inside itemsold and closed 14409 2025-08-08 16:20:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 16:20:12 [INFO]: autolink for user_id 14409 is 1 2025-08-08 16:20:12 [INFO]: Ebay item id :: 326538998455 exists in Database 2025-08-08 16:20:12 [INFO]: Item is reliested :: exists in Database 2025-08-08 16:20:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 16:20:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 16:20:12 [INFO]: inside itemsold and closed 14409 2025-08-08 16:20:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 16:20:14 [INFO]: autolink for user_id 14409 is 1 2025-08-08 16:20:14 [INFO]: Ebay item id :: 283643089460 exists in Database 2025-08-08 16:20:14 [INFO]: Item is reliested :: exists in Database 2025-08-08 16:20:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 16:20:14 [INFO]: in processold action queue is array for {"44657651":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44657651","ebayitemid":"326538998455","shopifyproductid":"7846242451678","variants":[{"price":"89.99","quantity":0,"weight":"2","shopifyproductid":"7846242451678","shopifyvariantid":"43549924622558","shopifyinventoryid":"45645560086750","shopifylocationid":"","product_id":"44657651","variant_id":"77562871","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 16:20:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 16:20:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 16:20:14 [INFO]: Shopify Inventory id 45645560086750 2025-08-08 16:20:14 [INFO]: Shopify Location id 58450641063 2025-08-08 16:20:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 16:20:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T16:20:14Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-08 16:20:14 [INFO]: Change: available | Delta: -1 2025-08-08 16:20:14 [INFO]: Change: on_hand | Delta: -1 2025-08-08 16:20:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 16:20:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44657651 and user_id = 14409 2025-08-08 16:20:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77562871 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 16:20:14 [INFO]: updateIdsQuantity -> ["77562871"] 2025-08-08 16:20:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-08 16:20:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77562871 THEN 0 END, quantityflag = CASE WHEN id = 77562871 THEN 0 END WHERE user_id = 14409 AND id IN (77562871) 2025-08-08 16:20:14 [INFO]: QUANTITY Updated IDs: 77562871 2025-08-08 16:20:14 [INFO]: Successfully processed data for user 14409 2025-08-08 16:20:14 [INFO]: Execution Started 2025-08-08 16:20:14 [INFO]: Execution Finished 2025-08-08 16:30:01 [INFO]: Execution Started 2025-08-08 16:30:01 [INFO]: old server sucessfully connected 2025-08-08 16:30:01 [INFO]: sqs client sucess created 2025-08-08 16:30:04 [INFO]: Number of messages in the queue: 0 2025-08-08 16:30:24 [INFO]: Execution Started 2025-08-08 16:30:24 [INFO]: Execution Finished 2025-08-08 16:40:02 [INFO]: Execution Started 2025-08-08 16:40:02 [INFO]: old server sucessfully connected 2025-08-08 16:40:02 [INFO]: sqs client sucess created 2025-08-08 16:40:03 [INFO]: Number of messages in the queue: 1 2025-08-08 16:40:03 [INFO]: item found in queue is if condition 14409 2025-08-08 16:40:03 [INFO]: item found in queue is 14409 2025-08-08 16:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEByiQ+MECadtvAkfPPj0AvAjgyzkMR52EgpMayDE6dxjozjVT75mXZR+BLAolrzgQchTwJa3UbFkw1FbgkDQJ/gAloT9GyKtOV3b0ZZV/M4IJnm4VSnX3BHxvfG6rKyN/xKzwuZ10MqXVegQ4vbiiWonpz24LfiO8Ei4qbcsJuhzW4F3KE02Tr9p7jQDRNZP3rGS6oC9NgoBD4CRIo0AZsxoiK5P23LP6wtVLzPknbBWn8a8SJo1RtQoWR+idTDHqANqASFe+Htx4lr7NeT8gghTPmDnStxQCUCIju3zYLzGqti14PBLPMCw8SFAapIPKsT+Anvd7RgvKLkytG8rIx3KDeNcwRloUaiaFSEiwDyZ2s7aHF/P2eIIUA63CYpna0nZuzGXjGJEb0g17pjeFvY6fZf6LLppoR7n/KCVjabXssOxgsFBrrYaGVYP+92skQ 2025-08-08 16:40:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-08 16:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 16:40:03 [INFO]: inside itemsold and closed 14409 2025-08-08 16:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 16:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-08 16:40:05 [INFO]: Ebay item id :: 335982130804 exists in Database 2025-08-08 16:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-08 16:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 16:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 16:40:05 [INFO]: in processold action queue is array for {"44888315":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44888315","ebayitemid":"335982130804","shopifyproductid":"8940727009502","variants":[{"price":"129.99","quantity":0,"weight":"2","shopifyproductid":"8940727009502","shopifyvariantid":"47001419284702","shopifyinventoryid":"49112619385054","shopifylocationid":"58450641063","product_id":"44888315","variant_id":"77800470","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 16:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 16:40:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 16:40:05 [INFO]: Shopify Inventory id 49112619385054 2025-08-08 16:40:05 [INFO]: Shopify Location id 58450641063 2025-08-08 16:40:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 16:40:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T16:40:06Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-08 16:40:06 [INFO]: Change: available | Delta: -1 2025-08-08 16:40:06 [INFO]: Change: on_hand | Delta: -1 2025-08-08 16:40:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 16:40:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44888315 and user_id = 14409 2025-08-08 16:40:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77800470 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 16:40:06 [INFO]: updateIdsQuantity -> ["77800470"] 2025-08-08 16:40:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-08 16:40:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77800470 THEN 0 END, quantityflag = CASE WHEN id = 77800470 THEN 0 END WHERE user_id = 14409 AND id IN (77800470) 2025-08-08 16:40:06 [INFO]: QUANTITY Updated IDs: 77800470 2025-08-08 16:40:06 [INFO]: Successfully processed data for user 14409 2025-08-08 16:40:06 [INFO]: Execution Started 2025-08-08 16:40:06 [INFO]: Execution Finished 2025-08-08 16:50:02 [INFO]: Execution Started 2025-08-08 16:50:02 [INFO]: old server sucessfully connected 2025-08-08 16:50:02 [INFO]: sqs client sucess created 2025-08-08 16:50:05 [INFO]: Number of messages in the queue: 0 2025-08-08 16:50:25 [INFO]: Execution Started 2025-08-08 16:50:25 [INFO]: Execution Finished