2025-08-05 16:00:01 [INFO]: Execution Started
2025-08-05 16:00:01 [INFO]: old server sucessfully connected
2025-08-05 16:00:01 [INFO]: sqs client sucess created
2025-08-05 16:00:05 [INFO]: Number of messages in the queue: 5
2025-08-05 16:00:06 [INFO]: item found in queue is if condition  14409
2025-08-05 16:00:06 [INFO]: item found in queue is  14409
2025-08-05 16:00:08 [INFO]: Message deleted from the queue for receipt handle: AQEB74GoY3c34zj3pAnSZTUZfJ0kUcnFo2NAWPkNTZuXQqYsriwmf0YbmForh1tOLQsp6q3ha6yRNNSv/cSLL7r3LkSuD2u1jRNafKpGqYnQGAQeuy8IX5vXOyha/fjYppAOc8pUhMTVAgVPMeR7yv5e5f557kRGVTQ34oQjjEPVm5OX2cJiDDButwNbSEhjfrt4vI/OUb9CMy/wDJTU5sLfupOotI7ifGtfdBlgNT4A63XFpqWg9JF3GBpX8iFaAL8+jn63t6drEXN4FBkXAZtWzt7tsbyQHzWwmI21TdzVSpzDNVW71bStkP3OWMTqdoB4Sz6G+OJQjVt0c8ZMB7zjHAVcGM+QXyDc1GwZsmKEPCWRT9wo2ARmr3g02aDagH44Jw7jhsZRC4ESh+J4gjJ00qik7H3LYPNx2YrkjPlKFPIn+Icqr0wHp18iEBTzZUV4
2025-08-05 16:00:08 [INFO]: item found in queue is if condition  14409
2025-08-05 16:00:08 [INFO]: item found in queue is  14409
2025-08-05 16:00:08 [INFO]: Message deleted from the queue for receipt handle: AQEB/UcqlCI5nreT6B/HnWG7vWdpGYfCp7tgWStw1q+RuhlE3iYhkmwtHOVQgd349+nURNHN+KB4ASU6+vPO2gytuThZ2uiG6lwpMhxvvX+2b7VspOTilXBpgwZaOOLe0rvrcKdElf4/Ozh0R6p+SaMrMFw8I2oGLkqKQS/c9zvMS4o5vWm/vQrJgTRzusCwIf6mR2jgdIyn4HilDDeaNmZ6WZwVEYF2zk3B4wUNEONw4oEUu9xgyauW1AUa/yavVT96Ic+Dej/6ZEPWRUEBZPuKx3D/FaXP3z0z0rLNv9bzKdPYoJfaCtKmVxogDT3HU/z16HLpnsS5UwleeEgdl2jvZ4YkDh9B548SpPJgsniAFqnTl4MdXBTlCnyRqM4GYECYukHuopUL5arXiA/TroCnNFv19vRmO/XGlPZFbkBCMcasL6QI7x9vMY5n/zZj4s+i
2025-08-05 16:00:10 [INFO]: item found in queue is if condition  14409
2025-08-05 16:00:10 [INFO]: item found in queue is  14409
2025-08-05 16:00:11 [INFO]: Message deleted from the queue for receipt handle: AQEB+a6YQe/eZjGbSbP8z3wpi69l/rOQN57GY2+n6fz7ajRW2fqm8TogU1yf8SfKXPPqFP7aX0gM84v46jU82Mj8tIfwwcTNJBuZLDdvPh/DdcTqDMiKE+ir5tjKFBAm0bVnwlYw185FIvenMly2QE3wsTF8dDySCWYwiXKEd+SArOsDbjz0Bx+49QJmP/UFVjsHs9F7m6TkmuPnqJNRiC9Vmwg5gV3NrYYjtzpMaffzoKmId+wWIrxctIyHQB4tn/0ez8tz6bJ745iyDHZLKdg2qFso19bsyEIO6rrCerVT2ShfFd40hapJn644F027mfEUwEf+XVK93bnJVLHt9QtZSlNlRds3CJJw3uSuw9LUCl2BuuphyQ9UJKQxCcqaobOS3BcBDisZeOvMp2yaHZY56TLC+qGmQpIOH1YiMLnyw6eEZR3zxRwnrZIacru0u55m
2025-08-05 16:00:11 [INFO]: item found in queue is if condition  14409
2025-08-05 16:00:11 [INFO]: item found in queue is  14409
2025-08-05 16:00:12 [INFO]: Message deleted from the queue for receipt handle: AQEB5TStAm9rI9QV2Q6jAEOIxnZeVWhM5okhDx37jN6Qbt6zEWnoRo7GSZq11lDG1QYQlCR6FoQ0izdHLI9fB45uNF1mVq38DSSSRxXAynCUqHXgtuSF4adCUs8Bzh0pRwAQVT14N60CPq23tcxitsXM4JzQXBE1YP/sSca2iJ5qTeNXum6vWDXT+bgQpaG/Ip3Kc9syJoBRw0AP9o7LIo6KXDTxSmL/aJV7cSBNqy5649DJsCv9geg8d+cNeKJkZCIB69Tmo3udg53PRcwx+q4mSHfjlmV2+hepokkByxVIdxYR1K34yk3BjB79RJnwXLBP8Vw9T3/jCscM441Zdr7S1UE17TTSp/Avp9RMFw7jMAHPJjIUy2IMMCFpg6rM+XccfgTFpKIfAZjqCIbm87nCBsHB8z/nEqi43Q0tuEUms5SJUKLBprOkJZFhzqNyw+v1
2025-08-05 16:00:12 [INFO]: item found in queue is if condition  14409
2025-08-05 16:00:12 [INFO]: item found in queue is  14409
2025-08-05 16:00:12 [INFO]: Message deleted from the queue for receipt handle: AQEBGpisaJbaQMHtj/bEu6sfOwU8Pe3tA2NhUEWytvhk6eL6L+PFeDJi5A6d/9+P6aFptdsHblYNQZLGVyO1eVvbwEsGGS01J0kAfPhPpsWCCIEXwD74CBos1h8KW2RDbOrum4uojDxcJ2LqSIE0Ebv5r2Z3XP0UwtJ+GSZqaDnqz9QzBpfU9Mv62AdFSUxFqS4M/ALyePYuyol3P7FjHC1CbaIqrrUYu9IXIZ/BSERuy7QmumYJSE9zrc/ZfePprFu86SRSVCr6RtcU4jTKm/S6BRzGbi08gcEYr0Z4fjOZXzTIqxCZSTNlh2YG3+O17mc5AMsdtgW6qyTHr0eGzwzry8QoL+QqtOMwri7R3MQAUULX2XEIObBCysAbqTsaoQAbt6+3hYDgj/QmTgkIgQ1XT92+emk6olcZKKUoq2Qze7RQ/MGaPtGAKkjnBweRpx9s
2025-08-05 16:00:12 [INFO]: Processed 5 messages, reached the limit of 5.
2025-08-05 16:00:12 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 16:00:12 [INFO]: inside itemsold and closed 14409
2025-08-05 16:00:14 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 16:00:14 [INFO]: autolink for user_id 14409 is 1
2025-08-05 16:00:14 [INFO]: Ebay item id :: 305406646468 exists in Database
2025-08-05 16:00:14 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 16:00:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 16:00:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 16:00:14 [INFO]: inside itemsold and closed 14409
2025-08-05 16:00:16 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 16:00:16 [INFO]: autolink for user_id 14409 is 1
2025-08-05 16:00:16 [INFO]: Ebay item id :: 285842238967 exists in Database
2025-08-05 16:00:16 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 16:00:16 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 16:00:16 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 16:00:16 [INFO]: inside itemsold and closed 14409
2025-08-05 16:00:18 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 16:00:18 [INFO]: autolink for user_id 14409 is 1
2025-08-05 16:00:18 [INFO]: Ebay item id :: 285844316528 exists in Database
2025-08-05 16:00:18 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 16:00:18 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 16:00:18 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 16:00:18 [INFO]: inside itemsold and closed 14409
2025-08-05 16:00:19 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 16:00:19 [INFO]: autolink for user_id 14409 is 1
2025-08-05 16:00:19 [INFO]: Ebay item id :: 256498572502 exists in Database
2025-08-05 16:00:19 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 16:00:19 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 16:00:19 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 16:00:19 [INFO]: inside itemsold and closed 14409
2025-08-05 16:00:21 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 16:00:21 [INFO]: autolink for user_id 14409 is 1
2025-08-05 16:00:21 [INFO]: Ebay item id :: 305413000657 exists in Database
2025-08-05 16:00:21 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 16:00:21 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 16:00:21 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 16:00:21 [INFO]: in processold action queue is array    for {"44584372":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44584372","ebayitemid":"305406646468","shopifyproductid":"7750293586142","variants":[{"price":"39.99","quantity":0,"weight":"2","shopifyproductid":"7750293586142","shopifyvariantid":"43229713531102","shopifyinventoryid":"45324842926302","shopifylocationid":"","product_id":"44584372","variant_id":"77477081","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772955":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772955","ebayitemid":"285842238967","shopifyproductid":"8465185898718","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8465185898718","shopifyvariantid":"45312457998558","shopifyinventoryid":"47410388730078","shopifylocationid":"","product_id":"44772955","variant_id":"77681497","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772998":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772998","ebayitemid":"285844316528","shopifyproductid":"8468301480158","variants":[{"price":"59.99","quantity":0,"weight":"0.5","shopifyproductid":"8468301480158","shopifyvariantid":"45317939298526","shopifyinventoryid":"47415870587102","shopifylocationid":"","product_id":"44772998","variant_id":"77681539","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772931":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772931","ebayitemid":"256498572502","shopifyproductid":"8463280373982","variants":[{"price":"46.99","quantity":0,"weight":"2","shopifyproductid":"8463280373982","shopifyvariantid":"45308225519838","shopifyinventoryid":"47406150418654","shopifylocationid":"","product_id":"44772931","variant_id":"77681473","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44588847":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44588847","ebayitemid":"305413000657","shopifyproductid":"7755134632158","variants":[{"price":"84.99","quantity":0,"weight":"2","shopifyproductid":"7755134632158","shopifyvariantid":"43244212191454","shopifyinventoryid":"45339349287134","shopifylocationid":"","product_id":"44588847","variant_id":"77481556","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-05 16:00:21 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 16:00:21 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 16:00:21 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 16:00:21 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 16:00:21 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 16:00:21 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 16:00:21 [INFO]: Shopify Inventory id 45324842926302
2025-08-05 16:00:21 [INFO]: Shopify Location id 58450641063
2025-08-05 16:00:21 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 16:00:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T16:00:21Z","reason":"correction","changes":[{"name":"available","delta":-4},{"name":"on_hand","delta":-4}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-05 16:00:21 [INFO]: Change: available | Delta: -4
2025-08-05 16:00:21 [INFO]: Change: on_hand | Delta: -4
2025-08-05 16:00:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 16:00:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44584372 and user_id = 14409 
2025-08-05 16:00:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77477081 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 16:00:21 [INFO]: Shopify Inventory id 47410388730078
2025-08-05 16:00:21 [INFO]: Shopify Location id 58450641063
2025-08-05 16:00:21 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 16:00:22 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T16: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 16:00:22 [INFO]: Change: available | Delta: -1
2025-08-05 16:00:22 [INFO]: Change: on_hand | Delta: -1
2025-08-05 16:00:22 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 16:00:22 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772955 and user_id = 14409 
2025-08-05 16:00:22 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681497 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 16:00:22 [INFO]: Shopify Inventory id 47415870587102
2025-08-05 16:00:22 [INFO]: Shopify Location id 58450641063
2025-08-05 16:00:22 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 16:00:22 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T16: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 16:00:22 [INFO]: Change: available | Delta: -1
2025-08-05 16:00:22 [INFO]: Change: on_hand | Delta: -1
2025-08-05 16:00:22 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 16:00:22 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772998 and user_id = 14409 
2025-08-05 16:00:22 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681539 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 16:00:22 [INFO]: Shopify Inventory id 47406150418654
2025-08-05 16:00:22 [INFO]: Shopify Location id 58450641063
2025-08-05 16:00:22 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 16:00:22 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T16: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 16:00:22 [INFO]: Change: available | Delta: -1
2025-08-05 16:00:22 [INFO]: Change: on_hand | Delta: -1
2025-08-05 16:00:22 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 16:00:22 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772931 and user_id = 14409 
2025-08-05 16:00:22 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681473 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 16:00:22 [INFO]: Shopify Inventory id 45339349287134
2025-08-05 16:00:22 [INFO]: Shopify Location id 58450641063
2025-08-05 16:00:22 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 16:00:23 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T16:00:23Z","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 16:00:23 [INFO]: Change: available | Delta: -3
2025-08-05 16:00:23 [INFO]: Change: on_hand | Delta: -3
2025-08-05 16:00:23 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 16:00:23 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44588847 and user_id = 14409 
2025-08-05 16:00:23 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77481556 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 16:00:23 [INFO]: updateIdsQuantity -> ["77477081","77681497","77681539","77681473","77481556"]
2025-08-05 16:00:23 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 5. Affected rows: 5
2025-08-05 16:00:23 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77477081 THEN 0 WHEN id = 77681497 THEN 0 WHEN id = 77681539 THEN 0 WHEN id = 77681473 THEN 0 WHEN id = 77481556 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77477081 THEN 0 WHEN id = 77681497 THEN 0 WHEN id = 77681539 THEN 0 WHEN id = 77681473 THEN 0 WHEN id = 77481556 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77477081,77681497,77681539,77681473,77481556)
2025-08-05 16:00:23 [INFO]: QUANTITY Updated IDs: 77477081, 77681497, 77681539, 77681473, 77481556
2025-08-05 16:00:23 [INFO]: Successfully processed data for user 14409
2025-08-05 16:00:23 [INFO]: Execution Started
2025-08-05 16:00:23 [INFO]: Execution Finished
2025-08-05 16:10:01 [INFO]: Execution Started
2025-08-05 16:10:01 [INFO]: old server sucessfully connected
2025-08-05 16:10:01 [INFO]: sqs client sucess created
2025-08-05 16:10:04 [INFO]: Number of messages in the queue: 5
2025-08-05 16:10:05 [INFO]: item found in queue is if condition  14409
2025-08-05 16:10:05 [INFO]: item found in queue is  14409
2025-08-05 16:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEB43taQKezuRirPmJytBjQH+NMzfr5zTz+/B5DugkuYIF8V1LyEprmuGQo9Nzj1IK9OoXWMcS029aKEWkkjoSyz6BRVO6KzL2oVeJgtkIfDfUqAm3UUyFvldb2DUYlAYqSRRH8MrkD4d2WZZzaHEHEBlPUQ+4tokACAW64x4nhzpGtKjxp8Wtle+Lm/Dc/fDXbVUOiN042WsCGA7IjIgnoMmmwlAGtNLiBM56iU1L2hRrrfuLdS/i5U0F1kgIReg4/LGJ0XKBUIwSp9CaGODoj3gPcX0rIjU5nhnb156wajQShgWgcLqmGDKn9pERqkPUP/pKEP4373eufOCuhZ9XuhNbRk0jW15OAnQ9nNp77RKlLKECwH6kI/zFVEUyZ2uQj5i10Klp0vW7ZaKU6qwksgdKDKEiiC5Sxz8e0Lj3rfKIBR9AnTWbYD3Zx6S4EE9kC
2025-08-05 16:10:05 [INFO]: item found in queue is if condition  14409
2025-08-05 16:10:05 [INFO]: item found in queue is  14409
2025-08-05 16:10:06 [INFO]: Message deleted from the queue for receipt handle: AQEBrYnONXGIz942Kw2KTJw8MZAZifgRW2DsmemdflxhgsMZVrKu1vbymHNHUC7mScAqQVLFCWl9sa/ONR54X2xi8vS6dxXIBnsuhMfCQ9aqfuLQb/bmGJmCfAKaLRp6p4688fDJSbtsvswOYvFcve2vNladblfQlzrbO0GDQHG7DEt5sFIFBvM6McJtjatMTCzIb/EYB75qRDe/RzWctkSYm4AV/gkmnNo8AeauVXmSc1yU8tlazuvldibP6YQYKMuQxQ8DOo90otTZn63Eouazk6I2Yt24dOORE6ZOTc15Ninv62xr0GE4AqR8P7PBiQF6ZPAoYioSodB0/tCVhEJFeyK7DYXTirIld4jVHXHKHpthPcqSFWzD06q1K0NohGV8Z4zNdsWzFgnVe8eLuztHwCwaWRyLV7lPvHxciHrPCQSgsDShZNdJuu+upZGYbOJT
2025-08-05 16:10:06 [INFO]: item found in queue is if condition  14409
2025-08-05 16:10:06 [INFO]: item found in queue is  14409
2025-08-05 16:10:07 [INFO]: Message deleted from the queue for receipt handle: AQEBbtUXcqunaV2dH8i6gHg7gz3+EZAPBtSSHzqGDBDYJOatSlwR7u5bWQOHf6KTdzv6QtLS2Ibj8CiNvT8mBOgejr3m60IgH0l35kwmMofdU0RPNNljDB4O540iOQSb8C9LF8QOts8h4hWq2mq4TJpyCto7TinRm5EjvvbQxn3K2Kmyt5xzU6XybGLgzwVCr/1yFzNbiWqhQBDHYzcKmXAIa7uZ4GEy977yUSg7WNtGL+Tt1fhtNwWNN9Pjo3U4lRCUMDdSw6sUvJgNT2KTtGnQoJb/zB3ZRn3JtMdsfBICPZrz/W+ZMzQfZEEBhtEzyDU0gPgbdcnpHBQij4/aEcYyk0dWtATpz6RR7DmZQ/GqG1ZVYub4y1szFKc+9vy6eEKZBJsUUBzR8xMDTnknTybUjeqt43W2W7WanYQ0Xt5upxZcuoDkbgyqBu/UjJWZ+IF5
2025-08-05 16:10:07 [INFO]: item found in queue is if condition  14409
2025-08-05 16:10:07 [INFO]: item found in queue is  14409
2025-08-05 16:10:08 [INFO]: Message deleted from the queue for receipt handle: AQEBLwh/Vdnsi5nZxE0whHwauTKIdkcck/zxShT2xdTBcmR7EuZXLNebQWR60JP3+dmHhBw3s8gST/qb4W9aFrwGaq16vgqVjpeSjqtp0IbDR/gWYngjjKIALiBj1ovyjl6Z/UZOyruPD4hog1sjWnfHXFDd71SGy0nh/9J1tMYYD3Xaw/kBm+OdCkXWlFDxjHWYhEuZznEn4Yek08DkLKd7UwhAOYVXHHX55rO8W36qH1Pk8kt+yMIBiWDlAzzcDoHWrQIahmn+K9FGLD5oPBp7ggjD0A+NBjSGQScR5nweUG2BCMTRt302+D0cpe1n6ggP4sC9dDX4mMiyHOJt2f1Y5QYFf2fj+AFc5KCsq2rmanQBVlnEwrfiZZ3ja3KI637++rTEnsllGRUraDL4RDSPJPgfcM7yakkqr0oaG8HN6dRHCrRUWHDTfoqIyBgoLpCc
2025-08-05 16:10:08 [INFO]: item found in queue is if condition  14409
2025-08-05 16:10:08 [INFO]: item found in queue is  14409
2025-08-05 16:10:09 [INFO]: Message deleted from the queue for receipt handle: AQEB5MvqnyWasf791R7rQzatst2PpbBQyOUF8TuaDio+MqOqy8skpj4rvAm64Z5OjEwu803re/qMQELicoAle9cbxHcjQFgJ8EZqZf8iDFVD9u2o1lCEW5/Uu40/dBhqrHqtkWOuPqaZGt9yTG+sjVaL9yUL0C8bjLBu6VpOhZnRENpzZGwdqIAOr+2MpOYgupSfbqc9iLHXFF/G+UUpoI1zB5XndIAr/PTOteWdPt7NMQ2O+7TQOEE/UiMjsXmtHZEpkON7tfpM+zd+L3gui9XV0fv8ZHimsGDoNC2H0hx6rf/8PutarznL9DeTX7fW8yUabt6ny4oyAgrHRJzPIybaWJLufecs27YOV/cBNCdiDGcuE4bQoozs8VtY2LxabWx2DdUkhrJa+omUooyOkk7r7RcfXQJb8VKAhjXRCu6SIR+nIjhgCP//88XzbiDrjBmC
2025-08-05 16:10:09 [INFO]: Processed 5 messages, reached the limit of 5.
2025-08-05 16:10:09 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 16:10:09 [INFO]: inside itemsold and closed 14409
2025-08-05 16:10:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 16:10:11 [INFO]: autolink for user_id 14409 is 1
2025-08-05 16:10:11 [INFO]: Ebay item id :: 326659359149 exists in Database
2025-08-05 16:10:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 16:10:11 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-05 16:10:11 [INFO]: inside itemsold and closed 14409
2025-08-05 16:10:13 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 16:10:13 [INFO]: autolink for user_id 14409 is 1
2025-08-05 16:10:13 [INFO]: Ebay item id :: 305419262456 exists in Database
2025-08-05 16:10:13 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 16:10:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 16:10:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 16:10:13 [INFO]: inside itemsold and closed 14409
2025-08-05 16:10:14 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 16:10:14 [INFO]: autolink for user_id 14409 is 1
2025-08-05 16:10:14 [INFO]: Ebay item id :: 285851239707 exists in Database
2025-08-05 16:10:14 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 16:10:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 16:10:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 16:10:14 [INFO]: inside itemsold and closed 14409
2025-08-05 16:10:16 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 16:10:16 [INFO]: autolink for user_id 14409 is 1
2025-08-05 16:10:16 [INFO]: Ebay item id :: 404970291755 exists in Database
2025-08-05 16:10:16 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 16:10:16 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 16:10:16 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 16:10:16 [INFO]: inside itemsold and closed 14409
2025-08-05 16:10:18 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 16:10:18 [INFO]: autolink for user_id 14409 is 1
2025-08-05 16:10:18 [INFO]: Ebay item id :: 226525139956 exists in Database
2025-08-05 16:10:18 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 16:10:18 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 16:10:18 [INFO]: in processold action queue is array    for {"45167347":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45167347","ebayitemid":"326659359149","deleted":1}},"44592986":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44592986","ebayitemid":"305419262456","shopifyproductid":"8303336095966","variants":[{"price":"42.99","quantity":0,"weight":"2","shopifyproductid":"8303336095966","shopifyvariantid":"44851895828702","shopifyinventoryid":"46949940101342","shopifylocationid":"","product_id":"44592986","variant_id":"77485695","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44773131":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44773131","ebayitemid":"285851239707","shopifyproductid":"8476829581534","variants":[{"price":"169.99","quantity":0,"weight":"2","shopifyproductid":"8476829581534","shopifyvariantid":"45345346388190","shopifyinventoryid":"47443296092382","shopifylocationid":"","product_id":"44773131","variant_id":"77681673","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44773186":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44773186","ebayitemid":"404970291755","shopifyproductid":"8478830493918","variants":[{"price":"133.99","quantity":0,"weight":"2","shopifyproductid":"8478830493918","shopifyvariantid":"45351474200798","shopifyinventoryid":"47449426165982","shopifylocationid":"","product_id":"44773186","variant_id":"77681728","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-05 16:10:18 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 16:10:18 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 16:10:18 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 16:10:18 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 16:10:18 [INFO]: productIds WHich are having null productid -> [45167347]
2025-08-05 16:10:18 [INFO]: ebayItemIds WHich are not imported-> ["326659359149"]
2025-08-05 16:10:18 [INFO]: Entered in bulkUpdateProducts function
2025-08-05 16:10:18 [INFO]: Transaction started for bulkUpdateProducts
2025-08-05 16:10:18 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45167347)
2025-08-05 16:10:18 [INFO]: Query executed successfully. Affected rows: 0
2025-08-05 16:10:18 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-05 16:10:18 [INFO]: Transaction committed successfully.
2025-08-05 16:10:18 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-05 16:10:18 [INFO]: Shopify Inventory id 46949940101342
2025-08-05 16:10:18 [INFO]: Shopify Location id 58450641063
2025-08-05 16:10:18 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 16:10:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T16:10: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 16:10:18 [INFO]: Change: available | Delta: -1
2025-08-05 16:10:18 [INFO]: Change: on_hand | Delta: -1
2025-08-05 16:10:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 16:10:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44592986 and user_id = 14409 
2025-08-05 16:10:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77485695 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 16:10:18 [INFO]: Shopify Inventory id 47443296092382
2025-08-05 16:10:18 [INFO]: Shopify Location id 58450641063
2025-08-05 16:10:18 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 16:10:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T16:10: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 16:10:18 [INFO]: Change: available | Delta: -1
2025-08-05 16:10:18 [INFO]: Change: on_hand | Delta: -1
2025-08-05 16:10:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 16:10:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44773131 and user_id = 14409 
2025-08-05 16:10:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681673 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 16:10:18 [INFO]: Shopify Inventory id 47449426165982
2025-08-05 16:10:18 [INFO]: Shopify Location id 58450641063
2025-08-05 16:10:18 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 16:10:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T16:10: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 16:10:19 [INFO]: Change: available | Delta: -1
2025-08-05 16:10:19 [INFO]: Change: on_hand | Delta: -1
2025-08-05 16:10:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 16:10:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44773186 and user_id = 14409 
2025-08-05 16:10:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681728 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 16:10:19 [INFO]: updateIdsQuantity -> ["77485695","77681673","77681728"]
2025-08-05 16:10:19 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-05 16:10:19 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77485695 THEN 0 WHEN id = 77681673 THEN 0 WHEN id = 77681728 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77485695 THEN 0 WHEN id = 77681673 THEN 0 WHEN id = 77681728 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77485695,77681673,77681728)
2025-08-05 16:10:19 [INFO]: QUANTITY Updated IDs: 77485695, 77681673, 77681728
2025-08-05 16:10:19 [INFO]: Successfully processed data for user 14409
2025-08-05 16:10:19 [INFO]: Execution Started
2025-08-05 16:10:19 [INFO]: Execution Finished
2025-08-05 16:20:01 [INFO]: Execution Started
2025-08-05 16:20:01 [INFO]: old server sucessfully connected
2025-08-05 16:20:01 [INFO]: sqs client sucess created
2025-08-05 16:20:04 [INFO]: Number of messages in the queue: 1
2025-08-05 16:20:05 [INFO]: item found in queue is if condition  14409
2025-08-05 16:20:05 [INFO]: item found in queue is  14409
2025-08-05 16:20:07 [INFO]: Message deleted from the queue for receipt handle: AQEBu7ZJv36bi9/DxoxQpPt+pR9rXiRHmFVV7EB8aNC0Yl/mbawsQ+cjJ/kuQr0aQMp3wEDWcGriuk9Np0mxCQ1T5Cw0fNdL2g9UjYIygEgfAOQ9Tr7U+W+0APGgZlwoOyXljWGp9/UICbkQjb2Y9tCHCT59SUnX9E5+PclbM0cuqiriWK5Gumy3Z62cDumk6E9uN57SuKx40uC/eZ7wkeLyQAK4V/U9SjW6AoEntsr9MXRWtZ+ptJYDtoo9hkqDOVv0KRYt3XevqLiBPHr3o27DMixh5EcOAjPcwOrZFRqHAMZz6wf78yVqgMDkZw7RcTQ5W+R6ECLSjER8LSQ1rQF86sFa2ykzRIqsa3Paq2nrEmO+T+p3nvPTF5m9oOJaFBkkiBIeDf8vNmBMm9FvSoqqEumIP0uHdfGjpStoXEnfjr/rcVmyz24PUJbRC6Wnlfeb
2025-08-05 16:20:07 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-05 16:20:07 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 16:20:07 [INFO]: inside itemsold and closed 14409
2025-08-05 16:20:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 16:20:08 [INFO]: autolink for user_id 14409 is 1
2025-08-05 16:20:08 [INFO]: Ebay item id :: 336059882332 exists in Database
2025-08-05 16:20:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 16:20:08 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-05 16:20:08 [INFO]: in processold action queue is array    for {"45213327":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45213327","ebayitemid":"336059882332","deleted":1}}}
2025-08-05 16:20:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 16:20:08 [INFO]: productIds WHich are having null productid -> [45213327]
2025-08-05 16:20:08 [INFO]: ebayItemIds WHich are not imported-> ["336059882332"]
2025-08-05 16:20:08 [INFO]: Entered in bulkUpdateProducts function
2025-08-05 16:20:08 [INFO]: Transaction started for bulkUpdateProducts
2025-08-05 16:20:08 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45213327)
2025-08-05 16:20:08 [INFO]: Query executed successfully. Affected rows: 0
2025-08-05 16:20:08 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-05 16:20:08 [INFO]: Transaction committed successfully.
2025-08-05 16:20:08 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-05 16:20:08 [INFO]: Successfully processed data for user 14409
2025-08-05 16:20:08 [INFO]: Execution Started
2025-08-05 16:20:08 [INFO]: Execution Finished
2025-08-05 16:30:01 [INFO]: Execution Started
2025-08-05 16:30:01 [INFO]: old server sucessfully connected
2025-08-05 16:30:01 [INFO]: sqs client sucess created
2025-08-05 16:30:04 [INFO]: Number of messages in the queue: 2
2025-08-05 16:30:05 [INFO]: item found in queue is if condition  14409
2025-08-05 16:30:05 [INFO]: item found in queue is  14409
2025-08-05 16:30:06 [INFO]: Message deleted from the queue for receipt handle: AQEBclD6+oiTPt0DOI8zISR1SN/n0CpsZdmeAzjMev2QwZ5g2Z6ZAUgvLpejA9JYIQgpArQfhFcvZsHSR/ftNXK6KeqAr8ZHyXh6tv25D84KNxi45QcdPTB0TbO1Lnu0ckT12ZO4U9ca7UofkVjJ7ALvWvhovLxcF555K3SDXx5COALzjWfPtfRMeH6WhujfW/mAZ8KC1X45D0BaZXHzUE9K3FYWELOl4TSIKqwVZitK5I1DEliIP4MkK1vU7+XfS9jKpWBQk6yJ5SRlYIMBAP4xWFzGMbm6tgh09sp7/dR0NXuyu4AryWFA4Pw8M3aJDizlCe6Kq9CBL8l0lqTqHT8wytvlRhhbrlKQU6YgOAkZ+T7D9L1A+T5vTMvA4KMVzIAx0DTcurbN4GjidhKfjXPt13Tgf0mAJmNsu8lTVr0uZYiCuPsDajzeqsKmzBxyzP2t
2025-08-05 16:30:06 [INFO]: item found in queue is if condition  14409
2025-08-05 16:30:06 [INFO]: item found in queue is  14409
2025-08-05 16:30:10 [INFO]: Message deleted from the queue for receipt handle: AQEBUc/48xBjmBZiSt9AeW0bsL10WgHibXGjkGQS0aZJ2yBuVh2WbYBC8jiyrusdJTwOdHQsR91kY1pBsnX/Uavc+FTqKBqa31Bghz9msruZQmXX3XGEZfhpPeyu7tK0JV9wxXwD1XMIFSjoF8zFfz/SaqKhuV/M4sBpUJfOBiHk/+XOqY9Z4BANny+SNvyVsdoz+Pe6b3NNWwNJ5zJU7m5GmwFeBDKe+rXc+Y1R/G7nujkSmDwgef3h0N8jOLwrBOlI0Ze7wTDvQvbitFBNSzd3G1Thq82eZ5vKT5GTLU/NOVHuPJs1kPx1NL3rotTHgmGtfEEjsb7q2iiY16iVG8Z+z68ui70z9YFzA59IGCTCbonwLl89W0GEEHtFGhQTfQ9Zb4moIaLilWgvRiW0masSPzLP0SIRb9qLpzaONX1nHLm0663J6cOiY74Tqylo2aAC
2025-08-05 16:30:10 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-05 16:30:10 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 16:30:10 [INFO]: inside itemsold and closed 14409
2025-08-05 16:30:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 16:30:12 [INFO]: autolink for user_id 14409 is 1
2025-08-05 16:30:12 [INFO]: Ebay item id :: 305455500482 exists in Database
2025-08-05 16:30:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 16:30:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 16:30:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 16:30:12 [INFO]: inside itemsold and closed 14409
2025-08-05 16:30:13 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 16:30:13 [INFO]: autolink for user_id 14409 is 1
2025-08-05 16:30:13 [INFO]: Ebay item id :: 335618524550 exists in Database
2025-08-05 16:30:13 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 16:30:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 16:30:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 16:30:13 [INFO]: in processold action queue is array    for {"44574686":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44574686","ebayitemid":"305455500482","shopifyproductid":"7666088902878","variants":[{"price":"34.99","quantity":0,"weight":"2","shopifyproductid":"7666088902878","shopifyvariantid":"42863176057054","shopifyinventoryid":"44957833363678","shopifylocationid":"","product_id":"44574686","variant_id":"77467393","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44571833":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44571833","ebayitemid":"335618524550","shopifyproductid":"8705764098270","variants":[{"price":"34.99","quantity":0,"weight":"2","shopifyproductid":"8705764098270","shopifyvariantid":"45960629682398","shopifyinventoryid":"48059300217054","shopifylocationid":"","product_id":"44571833","variant_id":"77464517","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-05 16:30:13 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 16:30:13 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 16:30:13 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 16:30:13 [INFO]: Shopify Inventory id 44957833363678
2025-08-05 16:30:13 [INFO]: Shopify Location id 58450641063
2025-08-05 16:30:13 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 16:30:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T16:30:14Z","reason":"correction","changes":[{"name":"available","delta":-4},{"name":"on_hand","delta":-4}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-05 16:30:14 [INFO]: Change: available | Delta: -4
2025-08-05 16:30:14 [INFO]: Change: on_hand | Delta: -4
2025-08-05 16:30:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 16:30:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44574686 and user_id = 14409 
2025-08-05 16:30:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77467393 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 16:30:14 [INFO]: Shopify Inventory id 48059300217054
2025-08-05 16:30:14 [INFO]: Shopify Location id 58450641063
2025-08-05 16:30:14 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 16:30:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T16:30: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-05 16:30:14 [INFO]: Change: available | Delta: -1
2025-08-05 16:30:14 [INFO]: Change: on_hand | Delta: -1
2025-08-05 16:30:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 16:30:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44571833 and user_id = 14409 
2025-08-05 16:30:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77464517 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 16:30:14 [INFO]: updateIdsQuantity -> ["77467393","77464517"]
2025-08-05 16:30:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-05 16:30:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77467393 THEN 0 WHEN id = 77464517 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77467393 THEN 0 WHEN id = 77464517 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77467393,77464517)
2025-08-05 16:30:14 [INFO]: QUANTITY Updated IDs: 77467393, 77464517
2025-08-05 16:30:14 [INFO]: Successfully processed data for user 14409
2025-08-05 16:30:14 [INFO]: Execution Started
2025-08-05 16:30:14 [INFO]: Execution Finished
2025-08-05 16:40:02 [INFO]: Execution Started
2025-08-05 16:40:02 [INFO]: old server sucessfully connected
2025-08-05 16:40:02 [INFO]: sqs client sucess created
2025-08-05 16:40:03 [INFO]: Number of messages in the queue: 1
2025-08-05 16:40:03 [INFO]: item found in queue is if condition  14409
2025-08-05 16:40:03 [INFO]: item found in queue is  14409
2025-08-05 16:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEB+b3S9Pk8BRhkEbrD5TAKEG+4Oq3H0QVqVkXLmKpcFggTjoMu+ntAyBwAwwEegp2uFKKyQUgbuuzSv0YN65S32gOWlZbRbLgGcxyQtG4aq6ALMkdZR6gRoeiqa79rDvljgyMDD+yC1TTmKbLApwZK5Vd8E9+I1PIR6VnM/aw/gwuKaZGx+do/yKsMsVOjwIiHEim+W1g1GqB/2B/QPBylL3wlEHuS2uyfiowDVae0qFy+EHDRwX3N+uifK0mb9uBNUCggHNNLO02NwgRd23nfViCCZV7d743GXlSISqAFbJcDWB9jSTDB7zxCoUg0Cpx56YUdjg3Fz4istcIljNq2Py4ik08wPc9TDkcomg5tSoNSDj23nb/Za9UGlHpXxUus2HmG1PwDwqBZ/cX8BzKAxLQtAVigtyub0D1amsLkee+bPoAC6ZPTPJEF/baMSQLp
2025-08-05 16:40:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-05 16:40:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 16:40:03 [INFO]: inside itemsold and closed 14409
2025-08-05 16:40:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 16:40:05 [INFO]: autolink for user_id 14409 is 1
2025-08-05 16:40:05 [INFO]: Ebay item id :: 406055669127 exists in Database
2025-08-05 16:40:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 16:40:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-05 16:40:05 [INFO]: in processold action queue is array    for {"45243784":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45243784","ebayitemid":"406055669127","deleted":1}}}
2025-08-05 16:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 16:40:05 [INFO]: productIds WHich are having null productid -> [45243784]
2025-08-05 16:40:05 [INFO]: ebayItemIds WHich are not imported-> ["406055669127"]
2025-08-05 16:40:05 [INFO]: Entered in bulkUpdateProducts function
2025-08-05 16:40:05 [INFO]: Transaction started for bulkUpdateProducts
2025-08-05 16:40:05 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45243784)
2025-08-05 16:40:05 [INFO]: Query executed successfully. Affected rows: 0
2025-08-05 16:40:05 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-05 16:40:05 [INFO]: Transaction committed successfully.
2025-08-05 16:40:05 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-05 16:40:05 [INFO]: Successfully processed data for user 14409
2025-08-05 16:40:05 [INFO]: Execution Started
2025-08-05 16:40:05 [INFO]: Execution Finished
2025-08-05 16:50:01 [INFO]: Execution Started
2025-08-05 16:50:01 [INFO]: old server sucessfully connected
2025-08-05 16:50:01 [INFO]: sqs client sucess created
2025-08-05 16:50:03 [INFO]: Number of messages in the queue: 1
2025-08-05 16:50:04 [INFO]: item found in queue is if condition  14409
2025-08-05 16:50:04 [INFO]: item found in queue is  14409
2025-08-05 16:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBJQSUTGOgHNPzNEqhm1ZlfTV82s6d8Gx2TmX5ETxMHh3swpv5DTe5wIRKF7Zi/5bI71ZHjWeysQkPFXeXoiBCNkzpwhB+fFLRGMIQKCxsT8hGUkIYVLnMUzgUfqftps9mbofkQVaFZC4qQ2bDsOxMsnl68Ks2yhPNGvVKWWRrdUCGRQG1bIWmznRw+1fBHYlcTIEONqi+SmDowHucjDVPeAVbSrteFTT9Dl4BkISQ79cpmmaxD5AiBTAx2VogvdBO0fDMt+5jfkcRX1d/56oGXnJFOduD2ih/4bwy1/fGOx7gTqkEdILIoD0qsS1/vgOzWoEX0cJenaRDvOwoiB8r2hcWkFI1KTafQ4IegBlvKJ8TXYqtE6U1H8del+2pP9p+CsnIC4uWPykYhRqDvpjoyB4Pfun9n/O1yU2mgaQoydDdwP39jdhH+zrAdb4Gh+Rs
2025-08-05 16:50:04 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-05 16:50:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 16:50:04 [INFO]: inside itemsold and closed 14409
2025-08-05 16:50:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 16:50:06 [INFO]: autolink for user_id 14409 is 1
2025-08-05 16:50:06 [INFO]: Ebay item id :: 226483501836 exists in Database
2025-08-05 16:50:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 16:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 16:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 16:50:06 [INFO]: in processold action queue is array    for {"44736241":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44736241","ebayitemid":"226483501836","shopifyproductid":"8755898745054","variants":[{"price":"13.99","quantity":0,"weight":"2","shopifyproductid":"8755898745054","shopifyvariantid":"46129043636446","shopifyinventoryid":"48228187603166","shopifylocationid":"","product_id":"44736241","variant_id":"77644178","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-05 16:50:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 16:50:06 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 16:50:06 [INFO]: Shopify Inventory id 48228187603166
2025-08-05 16:50:06 [INFO]: Shopify Location id 58450641063
2025-08-05 16:50:06 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 16:50:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T16:50:07Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-05 16:50:06 [INFO]: Change: available | Delta: -1
2025-08-05 16:50:06 [INFO]: Change: on_hand | Delta: -1
2025-08-05 16:50:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 16:50:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44736241 and user_id = 14409 
2025-08-05 16:50:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77644178 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 16:50:06 [INFO]: updateIdsQuantity -> ["77644178"]
2025-08-05 16:50:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-05 16:50:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77644178 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77644178 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77644178)
2025-08-05 16:50:06 [INFO]: QUANTITY Updated IDs: 77644178
2025-08-05 16:50:06 [INFO]: Successfully processed data for user 14409
2025-08-05 16:50:06 [INFO]: Execution Started
2025-08-05 16:50:06 [INFO]: Execution Finished