2025-08-13 20:00:01 [INFO]: Execution Started 2025-08-13 20:00:01 [INFO]: old server sucessfully connected 2025-08-13 20:00:01 [INFO]: sqs client sucess created 2025-08-13 20:00:02 [INFO]: Number of messages in the queue: 0 2025-08-13 20:00:23 [INFO]: Execution Started 2025-08-13 20:00:23 [INFO]: Execution Finished 2025-08-13 20:10:01 [INFO]: Execution Started 2025-08-13 20:10:01 [INFO]: old server sucessfully connected 2025-08-13 20:10:01 [INFO]: sqs client sucess created 2025-08-13 20:10:02 [INFO]: Number of messages in the queue: 2 2025-08-13 20:10:02 [INFO]: item found in queue is if condition 14409 2025-08-13 20:10:02 [INFO]: item found in queue is 14409 2025-08-13 20:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBmDFrVxlFFB6S0NxCG54e+jWBzEQVxRnTzGl2GYQUha3J4JaZYpnPm3ahaib0/SIIt7udA0arRuzcw6WtIAx6vFX/vdq9i3XL2t9NLXmX4svZ3jfEXTbrUYyt1pVIGR3PsSXH/IF0z9tS0OPNRnS5hEktaMArJtPH3HWvgwPionON2jLKJokyXxXaRsi3LHJihDn0l9/j/5tkgZf/0rUH9FWJyEIGvS1IcVbkeDkcPOsA+PVxGZPnPRqPbno2ZgEiZDHn8VUAMZWMUuP+vLYOcAu/LVZEhcUFt5FLfE//q3eSD9UjSQProDTCPib1QTnXoAYStBGZVTAoPTIaH+KhmzoZZHiOVTka3WzVarg4XXw2uNf9gxKB8SXyz5cbKxL35FqFRHyC5VT1LpFY9gqxBFJsBRDrZaNg3rJi2yj+fp3SEn8E13A4C+XlwOO+AReO 2025-08-13 20:10:03 [INFO]: item found in queue is if condition 14409 2025-08-13 20:10:03 [INFO]: item found in queue is 14409 2025-08-13 20:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEB04XkjaNNNiEBdFy9mkiHul9y5IvEumkaszb1X61dQVMXT+JmdFYLEF2+PpWzEnUsTjkYShPJTF238EvmxjMetThUdtNmZzFKgCTpj8N+i61HXbsM1EROAsqQRq9YTgou8rA4SZAcIkhFqIdtEtiVvuAPyNxoLzxdROz39NPJD1vbFg2H3IwB14og7EAGr60eJj7WNOQNdD2D45qZB0Aw2zWe9mN1wIYJOw0QbAURvAj7l0j1CcndLdT0P5dr72ZKmt9X6JtkVPKzq867i2pnu6raW5kk0e7+mlIeSGtsud8ABr9Fx5B4HZFA+VVXSNV5BhzTEYhnDmm38yWw1+skovPQmRx6Dk2ms0KLi0a2spA6aeMM+zjbzYGu4L+sLlSiLShYhQsZkgBZQnuxWe2+jlTV0c19mTM1yqkVvtM34Ul7BS8QNWjHkPR++pSrrZI1 2025-08-13 20:10:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-13 20:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 20:10:03 [INFO]: inside itemsold and closed 14409 2025-08-13 20:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 20:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-13 20:10:05 [INFO]: Ebay item id :: 286052345690 exists in Database 2025-08-13 20:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-13 20:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 20:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 20:10:05 [INFO]: inside itemsold and closed 14409 2025-08-13 20:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 20:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-13 20:10:07 [INFO]: Ebay item id :: 286458447506 exists in Database 2025-08-13 20:10:07 [INFO]: Item is reliested :: exists in Database 2025-08-13 20:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 20:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 20:10:07 [INFO]: in processold action queue is array for {"44564121":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44564121","ebayitemid":"286052345690","shopifyproductid":"8697502335198","variants":[{"price":"14.99","quantity":0,"weight":"1","shopifyproductid":"8697502335198","shopifyvariantid":"45939303481566","shopifyinventoryid":"48037763186910","shopifylocationid":"","product_id":"44564121","variant_id":"77456801","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44790574":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44790574","ebayitemid":"286458447506","shopifyproductid":"8926354931934","variants":[{"price":"79.99","quantity":0,"weight":"2","shopifyproductid":"8926354931934","shopifyvariantid":"46838059401438","shopifyinventoryid":"48936547516638","shopifylocationid":"58450641063","product_id":"44790574","variant_id":"77700807","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 20:10:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 20:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 20:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 20:10:07 [INFO]: Shopify Inventory id 48037763186910 2025-08-13 20:10:07 [INFO]: Shopify Location id 58450641063 2025-08-13 20:10:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 20:10:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-13 20:10:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 20:10:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44564121 and user_id = 14409 2025-08-13 20:10:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77456801 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 20:10:07 [INFO]: Shopify Inventory id 48936547516638 2025-08-13 20:10:07 [INFO]: Shopify Location id 58450641063 2025-08-13 20:10:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 20:10:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T20:10: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-13 20:10:07 [INFO]: Change: available | Delta: -1 2025-08-13 20:10:07 [INFO]: Change: on_hand | Delta: -1 2025-08-13 20:10:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 20:10:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44790574 and user_id = 14409 2025-08-13 20:10:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77700807 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 20:10:07 [INFO]: updateIdsQuantity -> ["77456801","77700807"] 2025-08-13 20:10:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 1 2025-08-13 20:10:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77456801 THEN 0 WHEN id = 77700807 THEN 0 END, quantityflag = CASE WHEN id = 77456801 THEN 0 WHEN id = 77700807 THEN 0 END WHERE user_id = 14409 AND id IN (77456801,77700807) 2025-08-13 20:10:07 [INFO]: QUANTITY Updated IDs: 77456801, 77700807 2025-08-13 20:10:07 [INFO]: Successfully processed data for user 14409 2025-08-13 20:10:07 [INFO]: Execution Started 2025-08-13 20:10:07 [INFO]: Execution Finished 2025-08-13 20:20:01 [INFO]: Execution Started 2025-08-13 20:20:01 [INFO]: old server sucessfully connected 2025-08-13 20:20:01 [INFO]: sqs client sucess created 2025-08-13 20:20:02 [INFO]: Number of messages in the queue: 1 2025-08-13 20:20:02 [INFO]: item found in queue is if condition 14409 2025-08-13 20:20:02 [INFO]: item found in queue is 14409 2025-08-13 20:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEB8Lc+cFYd6yESHrMa1LId6UXFfMqxIH4E/QtuuW0gWN8gVhWkGiGBXtlWAtsxq0SRQcpUJ3p1R9NsLpwEYLMASQtiOAWRUqiGNx2UfJEnGj60mMwSXV4bhIV81ANi5z5Egwe/phd87t1yBU69KJhSZbzLYjXFv8DC260mz7obpHEoyiECU774hCnoNpG/yHeaUX61JgNi2bkzMiewUBQNz3siD7GklPVbpR5w/tTuUAe4O3/nYA+JE57tjjxHsw4ijp/6NCNy76WEp/rHVafLZoHpmL6kRgCZKICNZMniWe7CEEvtBN4IrcQz+gpRNFTOT+R71ysiwWWi7aUIuGTQ+IF8uj9KBgLxDv6+egm3tMqu1oQr9r6VeW5ZMMDYpNP+f8DrOaq6Yp5pUlzw0kWW/sGqZXNpBcAiZPixfWzsjFLr463gFSG5n7GJ4Ir2lWXA 2025-08-13 20:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-13 20:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 20:20:03 [INFO]: inside itemsold and closed 14409 2025-08-13 20:20:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 20:20:04 [INFO]: autolink for user_id 14409 is 1 2025-08-13 20:20:04 [INFO]: Ebay item id :: 257018192409 exists in Database 2025-08-13 20:20:04 [INFO]: Item is reliested :: exists in Database 2025-08-13 20:20:04 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-13 20:20:04 [INFO]: in processold action queue is array for {"45234626":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45234626","ebayitemid":"257018192409","deleted":1}}} 2025-08-13 20:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 20:20:05 [INFO]: productIds WHich are having null productid -> [45234626] 2025-08-13 20:20:05 [INFO]: ebayItemIds WHich are not imported-> ["257018192409"] 2025-08-13 20:20:05 [INFO]: Entered in bulkUpdateProducts function 2025-08-13 20:20:05 [INFO]: Transaction started for bulkUpdateProducts 2025-08-13 20:20:05 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45234626) 2025-08-13 20:20:05 [INFO]: Query executed successfully. Affected rows: 0 2025-08-13 20:20:05 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-13 20:20:05 [INFO]: Transaction committed successfully. 2025-08-13 20:20:05 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-13 20:20:05 [INFO]: Successfully processed data for user 14409 2025-08-13 20:20:05 [INFO]: Execution Started 2025-08-13 20:20:05 [INFO]: Execution Finished 2025-08-13 20:30:01 [INFO]: Execution Started 2025-08-13 20:30:01 [INFO]: old server sucessfully connected 2025-08-13 20:30:01 [INFO]: sqs client sucess created 2025-08-13 20:30:02 [INFO]: Number of messages in the queue: 0 2025-08-13 20:30:21 [INFO]: item found in queue is if condition 14409 2025-08-13 20:30:21 [INFO]: item found in queue is 14409 2025-08-13 20:30:21 [INFO]: Message deleted from the queue for receipt handle: AQEBjvXq1sJ3z+3RfN8/uUHM2+6lJkdqlJClsIVCKYHp2gYN0ododWJpFENblv5takHNUVVptRdkNgZ/kPEFExg79jInxM8Vuk1irNbmUPLx3ElSTYfNPFRnNShuj9mBE+KTH69jy4MeEvt5s8c6PPGPlYnqekpcBqBestp+6hBfR9s+ooyn2UQ2B9Xk2X709q5DnYTz3xq3PJkrQ33av4ItIPSpBnRJHqbNd7QoCOTL4HHoyltSjG3M3oLAkei5yUmY2t15a5jOTKHZKaiTy9dW21KE8Z5mp0WKF03jndm7ZE8wdMY33IE4F1Cm/qDMYHHfvMADFCBiqkags6Od+0oN3uVYu+qduT1rWR0YK7LwxbEnGcIG01sIrQMiFQlQEiXtxG0wAyh0m2p4jMGNxCoW/52EyteYNbjeeRxBOSMLqHHVZtAmFlCR8UfCTLddpX6N 2025-08-13 20:30:21 [INFO]: Processed 1 messages, reached the limit of 0. 2025-08-13 20:30:21 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 20:30:21 [INFO]: inside itemsold and closed 14409 2025-08-13 20:30:23 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 20:30:23 [INFO]: autolink for user_id 14409 is 1 2025-08-13 20:30:23 [INFO]: Ebay item id :: 256896264265 exists in Database 2025-08-13 20:30:23 [INFO]: Item is reliested :: exists in Database 2025-08-13 20:30:23 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 20:30:23 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 20:30:23 [INFO]: in processold action queue is array for {"44650565":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44650565","ebayitemid":"256896264265","shopifyproductid":"8878307410142","variants":[{"price":"171.99","quantity":0,"weight":"2","shopifyproductid":"8878307410142","shopifyvariantid":"46620016083166","shopifyinventoryid":"48722910839006","shopifylocationid":"","product_id":"44650565","variant_id":"77555754","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 20:30:23 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 20:30:23 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 20:30:23 [INFO]: Shopify Inventory id 48722910839006 2025-08-13 20:30:23 [INFO]: Shopify Location id 58450641063 2025-08-13 20:30:23 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 20:30:23 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T20:30: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-13 20:30:23 [INFO]: Change: available | Delta: -1 2025-08-13 20:30:23 [INFO]: Change: on_hand | Delta: -1 2025-08-13 20:30:23 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 20:30:23 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44650565 and user_id = 14409 2025-08-13 20:30:23 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77555754 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 20:30:23 [INFO]: updateIdsQuantity -> ["77555754"] 2025-08-13 20:30:23 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 20:30:23 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77555754 THEN 0 END, quantityflag = CASE WHEN id = 77555754 THEN 0 END WHERE user_id = 14409 AND id IN (77555754) 2025-08-13 20:30:23 [INFO]: QUANTITY Updated IDs: 77555754 2025-08-13 20:30:23 [INFO]: Successfully processed data for user 14409 2025-08-13 20:30:23 [INFO]: Execution Started 2025-08-13 20:30:23 [INFO]: Execution Finished 2025-08-13 20:40:01 [INFO]: Execution Started 2025-08-13 20:40:01 [INFO]: old server sucessfully connected 2025-08-13 20:40:01 [INFO]: sqs client sucess created 2025-08-13 20:40:03 [INFO]: Number of messages in the queue: 1 2025-08-13 20:40:03 [INFO]: item found in queue is if condition 14409 2025-08-13 20:40:03 [INFO]: item found in queue is 14409 2025-08-13 20:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBBhVG9AYuQ63nY59dwhibGUM0YUfepDCkkfE0owG0TFgMxsxbXgGmzNpsUsezPYvqL9xQJ252eQCoQ40Fo95pbRbyJM0bmnNLjHFBqIwKk1FBk1Tj4jKwYMsIeirThPnxmmajM5SFMqoEzn+5WJLu5CKwFKmNDe8MIVn2j6eoL2YpRneS4wtanPxc1HBJo37oB4OkJdb5gp/44w4DLdRGP/0h/aOC8Uvq6xO2zLugb4fpGE8PpMsU8+uNhuu2vLz72Fz4YvUOPRCyOgnaAxd48fctLPw/Ns9jgat2LCb42CUgcBAzBNS9ouaBBUMiYT+2Dcxs4u/KItsHSA5VJJlYnCOPmXGwzsIMdUP0Uxi/K+vaNt1RS74kYln1coA9LjG/yrzV+RAS2ZLlwkcp9NwbbVsuRo6TmaaWU0bFHmhA2f0x6WZ0bW6ayvA00wss5rYH 2025-08-13 20:40:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-13 20:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 20:40:03 [INFO]: inside itemsold and closed 14409 2025-08-13 20:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 20:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-13 20:40:05 [INFO]: Ebay item id :: 286322678567 exists in Database 2025-08-13 20:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-13 20:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 20:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 20:40:05 [INFO]: in processold action queue is array for {"44893552":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44893552","ebayitemid":"286322678567","shopifyproductid":"8929170817246","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8929170817246","shopifyvariantid":"46853227872478","shopifyinventoryid":"48964665344222","shopifylocationid":"58450641063","product_id":"44893552","variant_id":"77809246","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 20:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 20:40:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 20:40:05 [INFO]: Shopify Inventory id 48964665344222 2025-08-13 20:40:05 [INFO]: Shopify Location id 58450641063 2025-08-13 20:40:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 20:40:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-13 20:40:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 20:40:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44893552 and user_id = 14409 2025-08-13 20:40:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77809246 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 20:40:05 [INFO]: updateIdsQuantity -> ["77809246"] 2025-08-13 20:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 20:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77809246 THEN 0 END, quantityflag = CASE WHEN id = 77809246 THEN 0 END WHERE user_id = 14409 AND id IN (77809246) 2025-08-13 20:40:05 [INFO]: QUANTITY Updated IDs: 77809246 2025-08-13 20:40:05 [INFO]: Successfully processed data for user 14409 2025-08-13 20:40:05 [INFO]: Execution Started 2025-08-13 20:40:05 [INFO]: Execution Finished 2025-08-13 20:50:02 [INFO]: Execution Started 2025-08-13 20:50:02 [INFO]: old server sucessfully connected 2025-08-13 20:50:02 [INFO]: sqs client sucess created 2025-08-13 20:50:03 [INFO]: Number of messages in the queue: 1 2025-08-13 20:50:03 [INFO]: item found in queue is if condition 14409 2025-08-13 20:50:03 [INFO]: item found in queue is 14409 2025-08-13 20:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBeHPSFghUHdMqBcmcgX/xKjZm/Z5Go7HKuEG4lKWDIUnqLMFCSvwLujuvEhCBY3p9mG7GGBdc+1IRtRwc3xrwJjHPh5JLfbjgGIjIhbbfZ3jV8kNajUQVyAWcb+2cnJHRjYraIM9lJl10zPtFSZjb8lTRQgG1dcy/eYQ3qzDqS48qUlKv9WmN80mN3U3csnmiX7FfYnACSPTrjwZGHOx61b28+ChiQi38sptMJ8+DluYXcbZ84gbg2HHyvZQRrIgoq5uLskarItL17R3qaKGYhTRT0aQ9fH+qkpCLRr9tdNmRQr76BgJSzFjzy3yuQ26xYPznA4KiDgQddqZYPNcKpZFZOFQqvGGnj7HmVM9dqQlXuxr0DK65g5BNEaKVdWCsUAa0LHfQ9kmEafCimWGHUnNCqfn3JmhLDvqnF5IGevEbKhm59xJWIC20qjeQIh1G 2025-08-13 20:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-13 20:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 20:50:03 [INFO]: inside itemsold and closed 14409 2025-08-13 20:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 20:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-13 20:50:05 [INFO]: Ebay item id :: 326721326032 exists in Database 2025-08-13 20:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-13 20:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 20:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 20:50:05 [INFO]: in processold action queue is array for {"45313654":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313654","ebayitemid":"326721326032","shopifyproductid":"8982496772318","variants":[{"price":"10.99","quantity":0,"weight":"3","shopifyproductid":"8982496772318","shopifyvariantid":"47397361058014","shopifyinventoryid":"49509185061086","shopifylocationid":"58450641063","product_id":"45313654","variant_id":"78266167","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 20:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 20:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 20:50:05 [INFO]: Shopify Inventory id 49509185061086 2025-08-13 20:50:05 [INFO]: Shopify Location id 58450641063 2025-08-13 20:50:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 20:50:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T20:50:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-13 20:50:05 [INFO]: Change: available | Delta: -1 2025-08-13 20:50:05 [INFO]: Change: on_hand | Delta: -1 2025-08-13 20:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 20:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313654 and user_id = 14409 2025-08-13 20:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266167 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 20:50:05 [INFO]: updateIdsQuantity -> ["78266167"] 2025-08-13 20:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 20:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78266167 THEN 0 END, quantityflag = CASE WHEN id = 78266167 THEN 0 END WHERE user_id = 14409 AND id IN (78266167) 2025-08-13 20:50:05 [INFO]: QUANTITY Updated IDs: 78266167 2025-08-13 20:50:05 [INFO]: Successfully processed data for user 14409 2025-08-13 20:50:05 [INFO]: Execution Started 2025-08-13 20:50:05 [INFO]: Execution Finished