2025-08-06 19:00:01 [INFO]: Execution Started
2025-08-06 19:00:01 [INFO]: old server sucessfully connected
2025-08-06 19:00:01 [INFO]: sqs client sucess created
2025-08-06 19:00:02 [INFO]: Number of messages in the queue: 7
2025-08-06 19:00:03 [INFO]: item found in queue is if condition  14409
2025-08-06 19:00:03 [INFO]: item found in queue is  14409
2025-08-06 19:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBE8EN/ku91Vd7UwuNeHH70Nbu2sT0nl+tcON1VQVnI6odvfKXQH20iNQDuAoX9qmDonvFeXkmNZCzMOVexuRFzGjuROMDLYqNO1jQSh360qagg979bRi5wt3t3M9c1Q9Kq3eXuRQ5IZS7R+rKmAP+J7ZW0+VeVkxIRauKuWjLpZGr8vDUcOBbLP753F8QCcB+5E8bBvrUmdoJYNGhSq2ctngF+T454tT635fkOXJBi7N8FQsO1O0ii5SFZ6sGhh6VH2wpvBmUoJXoRX5VsvT9xmitpRojbcNgHG9QfUGNBjCE7BE1iqli7Yc2tp9KwwN0QArpCx53HnI4J2s+ZQLmOIy3QbZ2vy7i5p0QxbG7E2oXH/5LyKChC8cHWCwQVkiWwphVxu+UZMvWSU5GB0eWyvRSqYnwQYUxOmoKmyGfq82gMHo22Z6pef9yisKZrRgj
2025-08-06 19:00:03 [INFO]: item found in queue is if condition  14409
2025-08-06 19:00:03 [INFO]: item found in queue is  14409
2025-08-06 19:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBYi4eAGcs/jyZ1TVeWobsikVEGhvF9BvMmIuiS2QTXIH10nQMJdmL5XK225C8jPl+vfqZ9rvVT//A3IEd2pjXpPuIFIdbTJ7OxbsWVOPKeGu8f+CLBtJ79xa3k/1drhPSAunJGvYe5KqnkSJZnSc79gB6XOg0oAgWdSM5EfuAS8SWMcmYZBEPHjHmCqTN35PqMI/gUr8PJ6rm/yzNPU/dcwuiNobCyC4xoYDeEqYc08/M0/mW9KiI9OmfjgmYNtwBORKGa4W9X8Zu8Kf0eLeE3Sr2kFH95DAb0dkbSb0UIzsbJga661Oy7DIYQ8Zt0ZE/ig5GX0X7lzL49SoHqFHgBOR28cg3URetevWXfbmqa8a/rqKXburD2iCXPUYnCb786IHXZyUtjgxRWsFh0Yn8RpApnJ/o4K6wIiBuxP6roimdLtuWkBHfFit9mm7ihIfY
2025-08-06 19:00:04 [INFO]: item found in queue is if condition  14409
2025-08-06 19:00:04 [INFO]: item found in queue is  14409
2025-08-06 19:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBOU9gmTHkiJgGeoLf5e6+IwDC4DjhMvl8kzBO1LDWe7Qcey0eLWg45111jhgtEcU2uaiOoOVpD+WM6d3Znb+5ZUw/ctbkf53E8OzVvyferA3tRKIXYCKOQVTBZ3r2g02fnfOEhomGcAhs/Ynz4oMQ1QOD68h2CPtEP5p9e1sdK0lcuE8rseWt8F3ZP6N77ql4eXnmhlm2m6DLvDq6UokxxpUFE93FKrt8JPC0G3fyhZxsHETkKYx0kR8B5E8iNhAP0c3KhW4GGQQ17XPRfE1SjLaTIIxy67UWqn8eHt/JDrLXeO7LjjLZfSmJ5gQTJxGMiXBE+6yI9RQFDQL/nJyozRiTeK2SkHR5IccTdKvsvcUSsf5R5KxKWlnM220SunPWrh2CxmnYXiRQ2jgmzSepUXtNVToho3AsKhY9rslH4Bdl8qNNr9n8niykZCwz7+ll
2025-08-06 19:00:04 [INFO]: item found in queue is if condition  14409
2025-08-06 19:00:04 [INFO]: item found in queue is  14409
2025-08-06 19:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBbE1XUW6SrmGSwXF32MHPcOzy3KyNvOB+bNMPbZObftWmgOYiaAheQMotuccIznHkCZB6Jra6T3osc3t00fchgykkZyZaG3WWJMfZA9X6P89TuV4lBueh1doS7nmBcmZjqO/Yh3TEwfnuHBCwavG0AsfAF5hpfegPLqo/A0nZhC5l77rZWa/Rey01tAf1jtRrMalfuAUcZlfcBu8+EZ311sdSPqQFM0FwWz+XB0PYPqYo5S4cBcwXDWsE4OTzc+ddwUwogHzrb4mOX75USQjqln9RrxYyVi8qba1OWXTZjgns0O6eRbG03fzXrg7+wmnZaPSjGIK8zcb8oqEEkPZKHiBW09nzey/Hhw76gwzn/Kzq8bAueN94sTgdQBr1BIjodQI5+YsoPToRQQtQVSJ0N97u6t9HRjYVGBHw61G/xyEQ9Oz8Wgx/x+uKfUM3cKXg
2025-08-06 19:00:04 [INFO]: item found in queue is if condition  14409
2025-08-06 19:00:04 [INFO]: item found in queue is  14409
2025-08-06 19:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBMfjUB803vvxhbfVem2iWiPZlLlVPhpO2wkfn1AKQw1JF+iGyWJvLn6Zcr23VyhuKsDHylNyq5NNMZRwzRAzhpQBHtbf/Fo0Yz0Wfm1DCMGMiUbUDrLadObUueG30949lzT1wndLiPYWGlrt+619joKGx48VDoHBfBQuPx4RrUXyBc0AW8F71CI2oa/A5lD/nvv2D52hTfijOLeAHWA23WJCLux3cW6yM27yNgBzxY51QmawHw/w1q8tzzh3Y6G99Nt+OhzaYdwNogrYCsYPubyrrao/VWNpPRoBhjIzsYOl/+23lFikzk7ganR6jzgqcohXuCVMHMWjEHbbT3VDFlqBUKf9EWFk9O/GMXkNTbRzhd42XOV63sG1tXdjmZaw/V6xJoTTeBbIaji0+Qkq+7shf4upQ9fpeL4J3Wyg66IooFioCg5myjkQdhp7HEZe9
2025-08-06 19:00:05 [INFO]: item found in queue is if condition  14409
2025-08-06 19:00:05 [INFO]: item found in queue is  14409
2025-08-06 19:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEB6ReR0JHdFJ4cya7ckPN6FFNCkFeTM+nK1r5/k8/qhIlRVP28lRDmbSvGzJZq34FAST64hIlX02gYfjs+v09COQOPgalrgQdCB+XvOw+GHQ9zP6SWLlJyScB4lxC5cRWmMHvsUHyII5k4yZ0NfE3PVP4lKwO+Y/VL9SistQIgL7rA6gc0Y7aHrbQbmSSQHw6+vGbXODfqi1JXTtmVhfwEPLFX1SzE8TfOvEieiluEVj7al6/LYSbPMp/k4bpEreg0JehDFKpQAXw1Ko9cmi4stn95sR6OmgeoJAqWtO/TX4cx8xjBGweZHhyV1VAA9TmffFMmWiM5r1Ge+fSgoclBP5+5gvOb0TgJKYdhCbARfd/NMWueEnZhebjC99qbt4yPkEco9+A58g4183ZdFFfj0gfO1yGrlf04p48n8VX3EwL6dLueuC5RQBjlVEaa5aGY
2025-08-06 19:00:05 [INFO]: item found in queue is if condition  14409
2025-08-06 19:00:05 [INFO]: item found in queue is  14409
2025-08-06 19:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBlZBnqHsow7UHpkkwmKX7w9DbPfR3v4FLeZJ/qg9PsuKAiNbjUzm0GNf3oGKZpCCpZaacLEiyssSz3fYlJ89yNQ9fMEvCjOF7Bus+lY8BOOX2lKPqD9Ebow/Wo2/uWDhdN/njrCQ3RMFNWJefCoq1EAVZXWwy6165o/Tn0AN/QboewGPz7OhKOXWfyTWZZqnHpxqr1ITk+XWLJd6t6lRVlGoDGFhHrCygSF9nJIft4iNyUAd8PHgrehIt33LYaTZAuLaL7jvlMGFjndNWLeMWyraTrOXTIJ9+TUYq2B+pz6I1lh3QP3k3aJx5CV4dxON7+zQ1b4EeRm89J4vNBcU0e1uou9JpLiqAChhMd2HceZYYiB0zAsN53zwpyWqkPNxlAF1kPSH06TiEwfAt4KMLU/j75x1z1zDbtOFpbIKbGNIZkf4m5DYuXbmt2fKCrcuj
2025-08-06 19:00:05 [INFO]: Processed 7 messages, reached the limit of 7.
2025-08-06 19:00:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 19:00:05 [INFO]: inside itemsold and closed 14409
2025-08-06 19:00:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 19:00:07 [INFO]: autolink for user_id 14409 is 1
2025-08-06 19:00:07 [INFO]: Ebay item id :: 334991212167 exists in Database
2025-08-06 19:00:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 19:00:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 19:00:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 19:00:07 [INFO]: inside itemsold and closed 14409
2025-08-06 19:00:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 19:00:09 [INFO]: autolink for user_id 14409 is 1
2025-08-06 19:00:09 [INFO]: Ebay item id :: 334991184005 exists in Database
2025-08-06 19:00:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 19:00:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 19:00:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 19:00:09 [INFO]: inside itemsold and closed 14409
2025-08-06 19:00:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 19:00:10 [INFO]: autolink for user_id 14409 is 1
2025-08-06 19:00:10 [INFO]: Ebay item id :: 324987230662 exists in Database
2025-08-06 19:00:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 19:00:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 19:00:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 19:00:10 [INFO]: inside itemsold and closed 14409
2025-08-06 19:00:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 19:00:12 [INFO]: autolink for user_id 14409 is 1
2025-08-06 19:00:12 [INFO]: Ebay item id :: 334991184005 exists in Database
2025-08-06 19:00:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 19:00:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 19:00:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 19:00:12 [INFO]: inside itemsold and closed 14409
2025-08-06 19:00:13 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 19:00:13 [INFO]: autolink for user_id 14409 is 1
2025-08-06 19:00:13 [INFO]: Ebay item id :: 334991106463 exists in Database
2025-08-06 19:00:13 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 19:00:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 19:00:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 19:00:13 [INFO]: inside itemsold and closed 14409
2025-08-06 19:00:15 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 19:00:15 [INFO]: autolink for user_id 14409 is 1
2025-08-06 19:00:15 [INFO]: Ebay item id :: 334991212167 exists in Database
2025-08-06 19:00:15 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 19:00:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 19:00:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 19:00:15 [INFO]: inside itemsold and closed 14409
2025-08-06 19:00:17 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 19:00:17 [INFO]: autolink for user_id 14409 is 1
2025-08-06 19:00:17 [INFO]: Ebay item id :: 286444183825 exists in Database
2025-08-06 19:00:17 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 19:00:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 19:00:17 [INFO]: in processold action queue is array    for {"44575877":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44575877","ebayitemid":"334991212167","shopifyproductid":"8111344779486","variants":[{"price":"34.99","quantity":0,"weight":"0.75","shopifyproductid":"8111344779486","shopifyvariantid":"44313464373470","shopifyinventoryid":"46410970890462","shopifylocationid":"","product_id":"44575877","variant_id":"77468584","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44575832":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44575832","ebayitemid":"334991184005","shopifyproductid":"8111344681182","variants":[{"price":"34.99","quantity":0,"weight":"0.75","shopifyproductid":"8111344681182","shopifyvariantid":"44313464275166","shopifyinventoryid":"46410970792158","shopifylocationid":"","product_id":"44575832","variant_id":"77468539","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44731073":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44731073","ebayitemid":"324987230662","shopifyproductid":"8925362061534","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8925362061534","shopifyvariantid":"46835374817502","shopifyinventoryid":"48933862670558","shopifylocationid":"58450641063","product_id":"44731073","variant_id":"77638958","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44636950":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44636950","ebayitemid":"334991106463","shopifyproductid":"7649203421406","variants":[{"price":"34.99","quantity":0,"weight":"0.75","shopifyproductid":"7649203421406","shopifyvariantid":"42785693597918","shopifyinventoryid":"44880248275166","shopifylocationid":"","product_id":"44636950","variant_id":"77542139","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 19:00:17 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 19:00:17 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 19:00:17 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 19:00:17 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 19:00:17 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 19:00:17 [INFO]: Shopify Inventory id 46410970890462
2025-08-06 19:00:17 [INFO]: Shopify Location id 58450641063
2025-08-06 19:00:17 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 19:00:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T19:00:17Z","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-06 19:00:17 [INFO]: Change: available | Delta: -3
2025-08-06 19:00:17 [INFO]: Change: on_hand | Delta: -3
2025-08-06 19:00:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 19:00:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44575877 and user_id = 14409 
2025-08-06 19:00:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77468584 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 19:00:17 [INFO]: Shopify Inventory id 46410970792158
2025-08-06 19:00:17 [INFO]: Shopify Location id 58450641063
2025-08-06 19:00:17 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 19:00:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T19:00: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-06 19:00:18 [INFO]: Change: available | Delta: -2
2025-08-06 19:00:18 [INFO]: Change: on_hand | Delta: -2
2025-08-06 19:00:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 19:00:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44575832 and user_id = 14409 
2025-08-06 19:00:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77468539 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 19:00:18 [INFO]: Shopify Inventory id 48933862670558
2025-08-06 19:00:18 [INFO]: Shopify Location id 58450641063
2025-08-06 19:00:18 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 19:00:18 [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-06 19:00:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 19:00:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44731073 and user_id = 14409 
2025-08-06 19:00:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77638958 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 19:00:18 [INFO]: Shopify Inventory id 44880248275166
2025-08-06 19:00:18 [INFO]: Shopify Location id 58450641063
2025-08-06 19:00:18 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 19:00:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T19:00: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-06 19:00:18 [INFO]: Change: available | Delta: -1
2025-08-06 19:00:18 [INFO]: Change: on_hand | Delta: -1
2025-08-06 19:00:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 19:00:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44636950 and user_id = 14409 
2025-08-06 19:00:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77542139 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 19:00:18 [INFO]: updateIdsQuantity -> ["77468584","77468539","77638958","77542139"]
2025-08-06 19:00:18 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 3
2025-08-06 19:00:18 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77468584 THEN 0 WHEN id = 77468539 THEN 0 WHEN id = 77638958 THEN 0 WHEN id = 77542139 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77468584 THEN 0 WHEN id = 77468539 THEN 0 WHEN id = 77638958 THEN 0 WHEN id = 77542139 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77468584,77468539,77638958,77542139)
2025-08-06 19:00:18 [INFO]: QUANTITY Updated IDs: 77468584, 77468539, 77638958, 77542139
2025-08-06 19:00:18 [INFO]: Successfully processed data for user 14409
2025-08-06 19:00:18 [INFO]: Execution Started
2025-08-06 19:00:18 [INFO]: Execution Finished
2025-08-06 19:10:01 [INFO]: Execution Started
2025-08-06 19:10:01 [INFO]: old server sucessfully connected
2025-08-06 19:10:01 [INFO]: sqs client sucess created
2025-08-06 19:10:02 [INFO]: Number of messages in the queue: 3
2025-08-06 19:10:03 [INFO]: item found in queue is if condition  14409
2025-08-06 19:10:03 [INFO]: item found in queue is  14409
2025-08-06 19:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBMc8EZyPyXgucECuhmxhiKaqZ7/KiK9dJ+Z/KTH+GcK3O39zSpBqia5gvBeVy78RMqNZsrkAAUtJWzWlqT2chaSd7J02fdUN8GlC2PKBQd0C4XBdTsIvpHVO4eVQoCLC80BH/PuOhtyimtTKR+46kHWQRDfyguYTdJeGNJLMicu7hKFK6V2lW4ljbkmKzg5QPt4s/hT+yQtSvP7IttXQxas+ve9KOX5NscBISW6H32qFboxEJLdcENAGekklRIogp68jCViO+Jq1i+N4PR+BdwdbxAw+lDbVhCm97B/YWMSwd1oVflhFqTU+VZLRQun3bd6FQeC3YiZkZBdLHR4dTPUYEmdtXNmPhS2f6fhywwIEmkbOw7WNJQEdAO21Bfv3QTYvfOYbln4tKTqeAQ5WSaX5gT2H4wTrdTcgqKCe05qSNn3z7FgVV4qb2GlXXkIP9
2025-08-06 19:10:03 [INFO]: item found in queue is if condition  14409
2025-08-06 19:10:03 [INFO]: item found in queue is  14409
2025-08-06 19:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBBCGduc+uFVN11XBfnarPgGkFVJRpqwtO48WBkP0Ds1Bp7ndkhlVj9Oy9lLB1lRlHstfS8HbwL1/Yb1ZN66A4JFteWtVrCLg+NX4nvI9g1vuI1luURREHaj09EMjb317qg6+syvEot4DwbHjmi8JtDAKGaD0HU9fklzDv8O57zHDKzSH+dC7uZRMgZzEaslnvNy5ylAHlirmGlgpimFzzW/cNuLYngUL8JSUJSqGc+VFTNP/G9SkNHQcKX+yxMsbUl+MUiJ2jEl8pgM/miGgumGgbjWLrV1yA6jGjOpIeo8XGPOS8k5ygQVnpU+OV8n0Qdw74ruYttoGqZtzUbmiW02jJtAO0/SxzAgz4hBmd7WDRdXyPEnwPTJ1Evw92x+EriyrjDFyLMSrKC/7guLDWSHdNM+55upbhsTmgWtz7RUIt31H76PQhyAJo//3pX6Sb
2025-08-06 19:10:04 [INFO]: item found in queue is if condition  14409
2025-08-06 19:10:04 [INFO]: item found in queue is  14409
2025-08-06 19:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBwfY2OI7nkBWr3qJZzZ/0mmMlQHHmKe1K3tjPEhnZ0WHLaAz3ggvoL+6Xb+ASx7FHgSvqTZ3qEE+BMFpnVige07IrA7QW26FUzGV/GIPYCEY2PA0qbq0pr8+7+QayTArEev9AhdsVmuoKT8mkUc3XtAsq5nvZgJKkTI3LhhPfZx7zbDrVmSRl2oQCBgYEvc5RD6G92ZabjkEDUSxnJ6C+Ka2bnNffTYOtJljMjWJCnQ36cd3kQkNmIF308eiaIdSNf1DnqBUhdB9p321L77yx3kKICdn4MEwdPgJ39yEx9ESACx/7JUlr3ELo7H3ruoIYuwQbZ4SgEo3NLtd2l58Lq3brx4SM0EsQyBhfj7XCl7ee0InpQygF9oM/AWdgqPGt1Po5dkrqNcy/Sn1SV2UWrp6LfHIzYsVldaQBO5FdD4MIIfAHve81hr3D+PIgu9O+
2025-08-06 19:10:04 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-06 19:10:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 19:10:04 [INFO]: inside itemsold and closed 14409
2025-08-06 19:10:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 19:10:06 [INFO]: autolink for user_id 14409 is 1
2025-08-06 19:10:06 [INFO]: Ebay item id :: 304973060100 exists in Database
2025-08-06 19:10:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 19:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 19:10:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 19:10:06 [INFO]: inside itemsold and closed 14409
2025-08-06 19:10:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 19:10:08 [INFO]: autolink for user_id 14409 is 1
2025-08-06 19:10:08 [INFO]: Ebay item id :: 226384172182 exists in Database
2025-08-06 19:10:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 19:10:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 19:10:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 19:10:08 [INFO]: inside itemsold and closed 14409
2025-08-06 19:10:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 19:10:10 [INFO]: autolink for user_id 14409 is 1
2025-08-06 19:10:10 [INFO]: Ebay item id :: 286658552555 exists in Database
2025-08-06 19:10:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 19:10:10 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-06 19:10:10 [INFO]: in processold action queue is array    for {"44563151":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44563151","ebayitemid":"304973060100","shopifyproductid":"7679349883102","variants":[{"price":"34.99","quantity":0,"weight":"0.75","shopifyproductid":"7679349883102","shopifyvariantid":"42918345670878","shopifyinventoryid":"45013313355998","shopifylocationid":"","product_id":"44563151","variant_id":"77455831","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44735682":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44735682","ebayitemid":"226384172182","shopifyproductid":"8702060200158","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8702060200158","shopifyvariantid":"45950675124446","shopifyinventoryid":"48049252892894","shopifylocationid":"","product_id":"44735682","variant_id":"77643589","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45115738":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45115738","ebayitemid":"286658552555","deleted":1}}}
2025-08-06 19:10:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 19:10:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 19:10:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 19:10:10 [INFO]: productIds WHich are having null productid -> [45115738]
2025-08-06 19:10:10 [INFO]: ebayItemIds WHich are not imported-> ["286658552555"]
2025-08-06 19:10:10 [INFO]: Entered in bulkUpdateProducts function
2025-08-06 19:10:10 [INFO]: Transaction started for bulkUpdateProducts
2025-08-06 19:10:10 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45115738)
2025-08-06 19:10:10 [INFO]: Query executed successfully. Affected rows: 0
2025-08-06 19:10:10 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-06 19:10:10 [INFO]: Transaction committed successfully.
2025-08-06 19:10:10 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-06 19:10:10 [INFO]: Shopify Inventory id 45013313355998
2025-08-06 19:10:10 [INFO]: Shopify Location id 58450641063
2025-08-06 19:10:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 19:10:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T19:10:10Z","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-06 19:10:10 [INFO]: Change: available | Delta: -1
2025-08-06 19:10:10 [INFO]: Change: on_hand | Delta: -1
2025-08-06 19:10:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 19:10:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44563151 and user_id = 14409 
2025-08-06 19:10:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77455831 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 19:10:10 [INFO]: Shopify Inventory id 48049252892894
2025-08-06 19:10:10 [INFO]: Shopify Location id 58450641063
2025-08-06 19:10:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 19:10:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T19:10:10Z","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-06 19:10:11 [INFO]: Change: available | Delta: -1
2025-08-06 19:10:11 [INFO]: Change: on_hand | Delta: -1
2025-08-06 19:10:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 19:10:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44735682 and user_id = 14409 
2025-08-06 19:10:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77643589 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 19:10:11 [INFO]: updateIdsQuantity -> ["77455831","77643589"]
2025-08-06 19:10:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-06 19:10:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77455831 THEN 0 WHEN id = 77643589 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77455831 THEN 0 WHEN id = 77643589 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77455831,77643589)
2025-08-06 19:10:11 [INFO]: QUANTITY Updated IDs: 77455831, 77643589
2025-08-06 19:10:11 [INFO]: Successfully processed data for user 14409
2025-08-06 19:10:11 [INFO]: Execution Started
2025-08-06 19:10:11 [INFO]: Execution Finished
2025-08-06 19:20:01 [INFO]: Execution Started
2025-08-06 19:20:01 [INFO]: old server sucessfully connected
2025-08-06 19:20:01 [INFO]: sqs client sucess created
2025-08-06 19:20:02 [INFO]: Number of messages in the queue: 0
2025-08-06 19:20:23 [INFO]: Execution Started
2025-08-06 19:20:23 [INFO]: Execution Finished
2025-08-06 19:30:01 [INFO]: Execution Started
2025-08-06 19:30:01 [INFO]: old server sucessfully connected
2025-08-06 19:30:01 [INFO]: sqs client sucess created
2025-08-06 19:30:02 [INFO]: Number of messages in the queue: 2
2025-08-06 19:30:03 [INFO]: item found in queue is if condition  14409
2025-08-06 19:30:03 [INFO]: item found in queue is  14409
2025-08-06 19:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBlvtXu4Eir9+pMOSunie/ARVgDiwP0QVnk2ESC6Nlekq98NdAQ5bykbbOX/bAXyhYqTsS5R1GZx+FZg/ygrmQ/SRYdd9TzuwMFXC4evh4xEcaW40Ypksc8EuqXS6LK7qDtVO+71zMfEbIL9Tqj/G+IBtLVAuCxxZFZZSmcUrLkFBWIF3ckYUjwlFqYrT/hCadbtHjGkRju+ffp2qEodn4h4RPb696ykvtZguTDpcCSoF7UqmtiIx53/N1ZYu4ia4Y9kr+uMVriKNb4XSkyAVr4ttPQdwdEcrNldfo2C2AbSV4djXhPHqV2kQg53MG0bYQ0nZKnmd3Mf3l90TV+wW4lk7fW5SvMQsmpPxjUnWBNN2qDtwrTa6CrriK32sCR4kSEc1MKDSpD15AWWY9MNU/FcanLG6CdFGNuZqXBhLUuGlFrRcLZDwciI6OFB+M6R9j
2025-08-06 19:30:03 [INFO]: item found in queue is if condition  14409
2025-08-06 19:30:03 [INFO]: item found in queue is  14409
2025-08-06 19:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEB2pOtjVO2LAawohsuhKCX9HQT+tRHLeiOqhsgbSnoS0yO0K6q1LdI6xhVi00c8Y0TuZCNBxn0gCqMi6iFSM4hUDJVxi21m+GwXFtBbB7ALGk3zNeAP1hQDOX+LMheLu4C/sd22yNOelUN4S86p+m5ha2T+MttfpNR4iz5juvOeTsgsdRBoRSylq7H2IZ614h1j5B1Yd39Ql1a36wOzAuCMbCfhZdAK3c4C8vaUWw3BsaIak1Y979BEXVDWowhN6qB/rrHS+VpTFR5sTNLh9xIP0Pnbp3xOhpD+CvRXYx1xRbU+zm+QYeEXqzhLHqFBB5W1EnPdi886ADo3wB6WrfS0noPovcbq/2ju7Sojmm00g7MYOCG1NKkKPTYeu3LEKzklh7o+MbIrYrPrjbA+N8wsmEouyka32hrwy8xpMuq7BTuXy+vH2B4FjVJfwKo1A8r
2025-08-06 19:30:03 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-06 19:30:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 19:30:03 [INFO]: inside itemsold and closed 14409
2025-08-06 19:30:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 19:30:05 [INFO]: autolink for user_id 14409 is 1
2025-08-06 19:30:05 [INFO]: Ebay item id :: 335395755640 exists in Database
2025-08-06 19:30:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 19:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 19:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 19:30:05 [INFO]: inside itemsold and closed 14409
2025-08-06 19:30:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 19:30:07 [INFO]: autolink for user_id 14409 is 1
2025-08-06 19:30:07 [INFO]: Ebay item id :: 404418586471 exists in Database
2025-08-06 19:30:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 19:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 19:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 19:30:07 [INFO]: in processold action queue is array    for {"44575358":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44575358","ebayitemid":"335395755640","shopifyproductid":"8487573061854","variants":[{"price":"39.99","quantity":0,"weight":"2","shopifyproductid":"8487573061854","shopifyvariantid":"45378596274398","shopifyinventoryid":"47476563280094","shopifylocationid":"","product_id":"44575358","variant_id":"77468065","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44764757":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44764757","ebayitemid":"404418586471","shopifyproductid":"8102159646942","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8102159646942","shopifyvariantid":"44295251984606","shopifyinventoryid":"46392511856862","shopifylocationid":"","product_id":"44764757","variant_id":"77673299","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 19:30:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 19:30:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 19:30:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 19:30:07 [INFO]: Shopify Inventory id 47476563280094
2025-08-06 19:30:07 [INFO]: Shopify Location id 58450641063
2025-08-06 19:30:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 19:30:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T19:30: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-06 19:30:08 [INFO]: Change: available | Delta: -1
2025-08-06 19:30:08 [INFO]: Change: on_hand | Delta: -1
2025-08-06 19:30:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 19:30:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44575358 and user_id = 14409 
2025-08-06 19:30:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77468065 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 19:30:08 [INFO]: Shopify Inventory id 46392511856862
2025-08-06 19:30:08 [INFO]: Shopify Location id 58450641063
2025-08-06 19:30:08 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 19:30:08 [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-06 19:30:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 19:30:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44764757 and user_id = 14409 
2025-08-06 19:30:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77673299 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 19:30:08 [INFO]: updateIdsQuantity -> ["77468065","77673299"]
2025-08-06 19:30:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-06 19:30:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77468065 THEN 0 WHEN id = 77673299 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77468065 THEN 0 WHEN id = 77673299 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77468065,77673299)
2025-08-06 19:30:08 [INFO]: QUANTITY Updated IDs: 77468065, 77673299
2025-08-06 19:30:08 [INFO]: Successfully processed data for user 14409
2025-08-06 19:30:08 [INFO]: Execution Started
2025-08-06 19:30:08 [INFO]: Execution Finished
2025-08-06 19:40:02 [INFO]: Execution Started
2025-08-06 19:40:02 [INFO]: old server sucessfully connected
2025-08-06 19:40:02 [INFO]: sqs client sucess created
2025-08-06 19:40:03 [INFO]: Number of messages in the queue: 2
2025-08-06 19:40:03 [INFO]: item found in queue is if condition  14409
2025-08-06 19:40:03 [INFO]: item found in queue is  14409
2025-08-06 19:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBPs21DhkWsM5QQR0yvo2jeZgczokVmZRojCMi7HZx3p4zVV0YLyR0I7Q0iu05R1sOccQwOYUMz7mXkSL1IITfgvmYFlo7e8zBmBIto4zkDZG9WCJ0CKmHuJkKnHL/s5N6/yCG/as/DCTsT4qCpkLK62dUihg78UnE9S8PdGFcK1+45T705Ii6eT8mDCekjk0PZvRJlwHk8a7tW+gZA7MtQopif/LS4jz+JhApcO+jqPJM+97/YS4uY6FXp39jfO7l5T9Z+qrNXNNQ+SeiMt4DrveFknb+IW+rXdL+vQXU1MPJUlEk7PERgPi0jD+5FcpjNanTqD2gz8H4FFhfG1V5I6snKiAJp9vF9HmioS+zLbu6728I/qXkBNGp/JJLSfIfpxbOSeoB0TzG67Er7yE+NKyWD0NeRlIGjUQBlS/QwNXVtPc5BHUsAObGLsC4mcJT
2025-08-06 19:40:03 [INFO]: item found in queue is if condition  14409
2025-08-06 19:40:03 [INFO]: item found in queue is  14409
2025-08-06 19:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEB9d8Ip5JVXGMIlYxsZcMdW/O7Vm0Y5ACvWb08enVCPkADz/fR5563GSwLeYD0ok8nb1Ep6COd/lPPS4TWsV2qaaeTdZhw3uYxsBS5kVKOwLTGinj9B2dEIq/ndeSxylW/1uR2BqwRdSIgZ4Ll5EUsdVRQPeaZzNaukMdJMF0glrGDELVjeehwDNRdQIu5Ghcr7GgZ90JsIaLXfoCGrKFKlX1XeW4LZaOe0EELRACXATqLV574EKVrgtfsMD/wBGwrzUD1xxxcZ9nW3DtQENtIKGBODuZnzJC4L8YxLAtNLhzd/oslZdM4B30/2lCnaoVVRToddm3UgtO8jJmsBwsKn0s5JpZ53fRNHZBC8dDm9sPRIuMHDfNyheU91MS04lD/hhEnCqI0ruNRdBX4YnQeebslpftMPnUaPQhQf2i//Y7r2EEjIsbK56sOJiIJz+y1
2025-08-06 19:40:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-06 19:40:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 19:40:04 [INFO]: inside itemsold and closed 14409
2025-08-06 19:40:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 19:40:05 [INFO]: autolink for user_id 14409 is 1
2025-08-06 19:40:05 [INFO]: Ebay item id :: 256865361694 exists in Database
2025-08-06 19:40:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 19:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 19:40:05 [INFO]: inside itemsold and closed 14409
2025-08-06 19:40:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 19:40:07 [INFO]: autolink for user_id 14409 is 1
2025-08-06 19:40:07 [INFO]: Ebay item id :: 335404507494 exists in Database
2025-08-06 19:40:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 19:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 19:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 19:40:07 [INFO]: in processold action queue is array    for {"44586060":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44586060","ebayitemid":"335404507494","shopifyproductid":"8498588451038","variants":[{"price":"24.99","quantity":0,"weight":"2","shopifyproductid":"8498588451038","shopifyvariantid":"45407144345822","shopifyinventoryid":"47505122885854","shopifylocationid":"","product_id":"44586060","variant_id":"77478769","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 19:40:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 19:40:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 19:40:07 [INFO]: Shopify Inventory id 47505122885854
2025-08-06 19:40:07 [INFO]: Shopify Location id 58450641063
2025-08-06 19:40:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 19:40:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T19:40:07Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-06 19:40:08 [INFO]: Change: available | Delta: -1
2025-08-06 19:40:08 [INFO]: Change: on_hand | Delta: -1
2025-08-06 19:40:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 19:40:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44586060 and user_id = 14409 
2025-08-06 19:40:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77478769 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 19:40:08 [INFO]: updateIdsQuantity -> ["77478769"]
2025-08-06 19:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-06 19:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77478769 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77478769 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77478769)
2025-08-06 19:40:08 [INFO]: QUANTITY Updated IDs: 77478769
2025-08-06 19:40:08 [INFO]: Successfully processed data for user 14409
2025-08-06 19:40:08 [INFO]: Execution Started
2025-08-06 19:40:08 [INFO]: Execution Finished
2025-08-06 19:50:01 [INFO]: Execution Started
2025-08-06 19:50:01 [INFO]: old server sucessfully connected
2025-08-06 19:50:01 [INFO]: sqs client sucess created
2025-08-06 19:50:03 [INFO]: Number of messages in the queue: 1
2025-08-06 19:50:03 [INFO]: item found in queue is if condition  14409
2025-08-06 19:50:03 [INFO]: item found in queue is  14409
2025-08-06 19:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBpCi9GJ5Fn3CqKP8PujB961wt2WmgwuQYya2QQFVicG38zT+wh9/WZxbZkyLHtrStdNoiUewdmMQq4aWovoWYpC+VrDrs4OBpndVNmf4zG145T3icg8y7IW9qdhFtMgD+QUbhqoGr7im4njj5NfiTnU4Ocn9vor9q8d9wI5jdMlnZsF+v6uDAIYZJpfLXN0U9Gb8j8gGM8TcjR0WkhNR1wF7oxsLgLkP6bX6/vmRIRnqbbtKMMzS0M4tHWd/fiKsRuDYq4bQq1xSX2xECw45FNuIiGcGtbga0PP2/1wRe/95GaD00tZWK+RQedLDehQ+qIdR9qhS34hXg+s6WmvrBeQQM9G0fp+/TvvBRIORS32n5UIQLpi2sbyfTLA6NSqAJjXNm6kmJdHb0lwU/7KmbaRHccB5ppgxHFRQI0mg2VSwV5HMcPFOYB7RzbT3t2M7y
2025-08-06 19:50:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-06 19:50:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 19:50:03 [INFO]: inside itemsold and closed 14409
2025-08-06 19:50:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 19:50:05 [INFO]: autolink for user_id 14409 is 1
2025-08-06 19:50:05 [INFO]: Ebay item id :: 335425462850 exists in Database
2025-08-06 19:50:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 19:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 19:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 19:50:05 [INFO]: in processold action queue is array    for {"44557380":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44557380","ebayitemid":"335425462850","shopifyproductid":"8696084922590","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"8696084922590","shopifyvariantid":"45936147103966","shopifyinventoryid":"48034596061406","shopifylocationid":"","product_id":"44557380","variant_id":"77450060","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 19:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 19:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 19:50:05 [INFO]: Shopify Inventory id 48034596061406
2025-08-06 19:50:05 [INFO]: Shopify Location id 58450641063
2025-08-06 19:50:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 19:50:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T19:50:05Z","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-06 19:50:05 [INFO]: Change: available | Delta: -2
2025-08-06 19:50:05 [INFO]: Change: on_hand | Delta: -2
2025-08-06 19:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 19:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44557380 and user_id = 14409 
2025-08-06 19:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77450060 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 19:50:05 [INFO]: updateIdsQuantity -> ["77450060"]
2025-08-06 19:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-06 19:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77450060 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77450060 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77450060)
2025-08-06 19:50:05 [INFO]: QUANTITY Updated IDs: 77450060
2025-08-06 19:50:05 [INFO]: Successfully processed data for user 14409
2025-08-06 19:50:05 [INFO]: Execution Started
2025-08-06 19:50:05 [INFO]: Execution Finished