2025-08-05 21:00:01 [INFO]: Execution Started
2025-08-05 21:00:01 [INFO]: old server sucessfully connected
2025-08-05 21:00:01 [INFO]: sqs client sucess created
2025-08-05 21:00:02 [INFO]: Number of messages in the queue: 1
2025-08-05 21:00:02 [INFO]: item found in queue is if condition  14409
2025-08-05 21:00:02 [INFO]: item found in queue is  14409
2025-08-05 21:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEB4sh3h2sbEfkZKtBnDTlVlhewgs8h3GD/AhGMkhe/ZF4vNM7K7DdW7UCixnqga0i4YSou7DrrzCTbFVwyQlvHwZIGTPkJc8cBRzTS4qfPCsl70HtZN3TTskbtF5oE/ijdS3wfLTlOeSY4YSMXJsIT7e52H6K7/HR0g+uZzQZS4BzABWy9CKk0w/baGrkyjCWwXLaZNRVPArzcCk2PFJ2DeiV4G4Cz9o/mKtSp6KLyecs69EDcwIRl7uXrlwDqBUmKhns8LfPbB91JCOrzWqTmQtjlyqOqHHCIoy2qMp9DmELZtqYW7oxmf1kXCI4XHcPaXWrGGI0e/s7s6S0X0Yyf0JJl4irJTotX/I/grL79kdrzI0FeFnHqr4uoAXBfPEU3npTOHlC9bE/wZMPU6jYHer7LmYH/Q1bJh3MlguuqQwGDVg9IM11f6ghLX4iv1EN1
2025-08-05 21:00:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-05 21:00:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 21:00:03 [INFO]: inside itemsold and closed 14409
2025-08-05 21:00:04 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 21:00:04 [INFO]: autolink for user_id 14409 is 1
2025-08-05 21:00:04 [INFO]: Ebay item id :: 306343527599 exists in Database
2025-08-05 21:00:04 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 21:00:04 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-05 21:00:04 [INFO]: in processold action queue is array    for {"45113532":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45113532","ebayitemid":"306343527599","deleted":1}}}
2025-08-05 21:00:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 21:00:04 [INFO]: productIds WHich are having null productid -> [45113532]
2025-08-05 21:00:04 [INFO]: ebayItemIds WHich are not imported-> ["306343527599"]
2025-08-05 21:00:04 [INFO]: Entered in bulkUpdateProducts function
2025-08-05 21:00:04 [INFO]: Transaction started for bulkUpdateProducts
2025-08-05 21:00:04 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45113532)
2025-08-05 21:00:04 [INFO]: Query executed successfully. Affected rows: 0
2025-08-05 21:00:04 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-05 21:00:04 [INFO]: Transaction committed successfully.
2025-08-05 21:00:04 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-05 21:00:04 [INFO]: Successfully processed data for user 14409
2025-08-05 21:00:04 [INFO]: Execution Started
2025-08-05 21:00:04 [INFO]: Execution Finished
2025-08-05 21:10:02 [INFO]: Execution Started
2025-08-05 21:10:02 [INFO]: old server sucessfully connected
2025-08-05 21:10:02 [INFO]: sqs client sucess created
2025-08-05 21:10:03 [INFO]: Number of messages in the queue: 1
2025-08-05 21:10:03 [INFO]: item found in queue is if condition  14409
2025-08-05 21:10:03 [INFO]: item found in queue is  14409
2025-08-05 21:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEB8kfdSJSyA1ydTPJZIvE6ZE3Nk1W5ra0gJ278GVr1o8IZyc3/OzPUMN6tFFiqqZK1WdIfNCrSUB1+fEIkOrlF8cyLzUnCnaeou59m2QF8nBGkKuB5ShiRl5w/5BeyGY0V86Gi67DxfUWmrvqxXF6RuC4onR30/yMNSe3cCloumdWk5H3IjM76sQPCAGBKBnK2hwS8JkKzFxeLOzkLbqxRjQEqWQe5t8JlsVI6U0BpVGtXeSs4yecztgcbUQz8PuKeFUmsqMZ+aXX013kgq+imuan+KRc3vRAyq2d1Pefn8aaypv7hcITIgzlNWh31bW4fmf5P6n9uAEvqsyxDXBEteDj+aCrjpnYmwJVWeUoMdGZIIu9N8UF3Axg7WFkB9G4CzR7J1hEb0pHLxFApU2hfuNxm0LNBFIt37yhpZ8kQcLA58iaars/j43PfSEN64zTj
2025-08-05 21:10:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-05 21:10:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 21:10:03 [INFO]: inside itemsold and closed 14409
2025-08-05 21:10:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 21:10:05 [INFO]: autolink for user_id 14409 is 1
2025-08-05 21:10:05 [INFO]: Ebay item id :: 226898564354 exists in Database
2025-08-05 21:10:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 21:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 21:10:05 [INFO]: in processold action queue is array    for []
2025-08-05 21:10:05 [INFO]: Successfully processed data for user 14409
2025-08-05 21:10:05 [INFO]: Execution Started
2025-08-05 21:10:05 [INFO]: Execution Finished
2025-08-05 21:20:01 [INFO]: Execution Started
2025-08-05 21:20:01 [INFO]: old server sucessfully connected
2025-08-05 21:20:01 [INFO]: sqs client sucess created
2025-08-05 21:20:02 [INFO]: Number of messages in the queue: 0
2025-08-05 21:20:23 [INFO]: Execution Started
2025-08-05 21:20:23 [INFO]: Execution Finished
2025-08-05 21:30:02 [INFO]: Execution Started
2025-08-05 21:30:02 [INFO]: old server sucessfully connected
2025-08-05 21:30:02 [INFO]: sqs client sucess created
2025-08-05 21:30:03 [INFO]: Number of messages in the queue: 3
2025-08-05 21:30:03 [INFO]: item found in queue is if condition  14409
2025-08-05 21:30:03 [INFO]: item found in queue is  14409
2025-08-05 21:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBlcPU8DD+kLLpkAk2jRlc7L1Tk9l8SYwcY56vMaJBm+NI37KF2mO9GkHnuVUaFwIPPWWEGVvNqyZ16kWpnr5/+V1Qe8i+EYNtlj7Gr445vm9cfg+q0P06x2PCEP8lMhc9qb4plKgX+B+A8mi/ChKNI5J0oQgMnhXLtSYLPZwpPtCAhlpDuvbrI1Je0C0OP9VFcieIqzs9DzyYq6C+ze7cbuBYlzGHMqluraQmdGdWqdxqzW/B20FKkNxIeviRL41qW3iBf4ISK7LaBo2db7VuOTPyM1WW1cFD/s5ZfltqELTGLuFNCqnsDqdwnjoKw1s/4klP5anC/q3SvOePsyBLvobcNOW85YSzGDWGemjHlnrVZu3yA3LrurkJzo8po9lYqa+j3syyn7xhPGf/mx8nJcZWB5QWDkY+Dd1JRbie2bd2K+3rjHM2cozGIvEWOkg3
2025-08-05 21:30:03 [INFO]: item found in queue is if condition  14409
2025-08-05 21:30:03 [INFO]: item found in queue is  14409
2025-08-05 21:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBmYO/typOstAtDs7TYuEEQoKEhCGkQyv+cC0Nysk6Hpvi0SgtYeAlIwcI9rT9F+jyz18ysvQTSheQv3yq01TGEEK5ZhUAIrpmL8nRY5jZpqKlV7bR7s5r7Q1beUeM/RrLudOfpx4zRTJuPiuHG6Mdjf4sLR40EQ2yLAylGc6RuBI4zbRpUpVPmTbW/qkwXXxsxmgi3/OzYMJNVArXeAO4k643BRO2RO0BU4WOoi86kI4S+32KsiSAio4zLOsH7SeU8UnBv1saaLokAdYSm9Uxjg1vPT1xR2HoDV3+s6ht/0umjuaL/Y9IaoGot7HRyepOv1XUYoNKzBivzPGTxm7yoE7UnRo2Lp0QQQKkOL8HogdSTkM/o2NbdJKums2eqxN0X1Llt8BS3Cz8+fX20BM3gqTcBE1kS6gJe0zJ+8G9NsoVlLAj5+wjV2Rwp/Fthbco
2025-08-05 21:30:04 [INFO]: item found in queue is if condition  14409
2025-08-05 21:30:04 [INFO]: item found in queue is  14409
2025-08-05 21:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBC3DRFOCDCvHibvl05JYvWkthwQeX9IeTlts+BDFCBaLOEVqDXUB9zvYbQbXJss+e/Fijl6bBMDUdIbvzHfsSN4takGQQGifxW3jUdaKfnAB0pYe9GfJJ10k2IHsNStPbhxYVj7lNGjsYxU5m0SjegG8QI/ujfxbGHxoRzYAu7yGzcnvJi8Mf6/OLak1NjgXSIh/2QCcMuFoyDCDqfV1HZQ5JmdPzX3r+Oq0Vf6OFR2j+MwfIiOJA5ixK62sdw1/0yffCpKYau/ggRMwVVaZ+zVxPX0wX/jfLzeOCXKmbLZnUiD90W9qGkx6+wdiIxADFRWGAFRA84mIrbWvSrGqHX62LbLFsTymnKYsh+eAdJAvBZZhVBZKBX201ZGQJSnxe8YZEwR+UP4kHASGfqrjVNazHxY1Fx3+HEekXqRPFqlL3eUu4mLY61o9Kv/NSh21D
2025-08-05 21:30:04 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-05 21:30:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 21:30:04 [INFO]: inside itemsold and closed 14409
2025-08-05 21:30:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 21:30:06 [INFO]: autolink for user_id 14409 is 1
2025-08-05 21:30:06 [INFO]: Ebay item id :: 286747422736 exists in Database
2025-08-05 21:30:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 21:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 21:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 21:30:06 [INFO]: inside itemsold and closed 14409
2025-08-05 21:30:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 21:30:08 [INFO]: autolink for user_id 14409 is 1
2025-08-05 21:30:08 [INFO]: Ebay item id :: 256937959227 exists in Database
2025-08-05 21:30:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 21:30:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 21:30:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 21:30:08 [INFO]: inside itemsold and closed 14409
2025-08-05 21:30:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 21:30:10 [INFO]: autolink for user_id 14409 is 1
2025-08-05 21:30:10 [INFO]: Ebay item id :: 286416788138 exists in Database
2025-08-05 21:30:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 21:30:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 21:30:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 21:30:10 [INFO]: in processold action queue is array    for {"45313111":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313111","ebayitemid":"286747422736","shopifyproductid":"8979657162974","variants":[{"price":"17.99","quantity":0,"weight":"0.75","shopifyproductid":"8979657162974","shopifyvariantid":"47292288008414","shopifyinventoryid":"49404107587806","shopifylocationid":"58450641063","product_id":"45313111","variant_id":"78265624","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44790304":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44790304","ebayitemid":"256937959227","shopifyproductid":"8926351327454","variants":[{"price":"139.99","quantity":0,"weight":"2","shopifyproductid":"8926351327454","shopifyvariantid":"46838045901022","shopifyinventoryid":"48936533950686","shopifylocationid":"58450641063","product_id":"44790304","variant_id":"77700473","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44577598":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44577598","ebayitemid":"286416788138","shopifyproductid":"7889405739230","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"7889405739230","shopifyvariantid":"43707874640094","shopifyinventoryid":"45803711201502","shopifylocationid":"","product_id":"44577598","variant_id":"77470305","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-05 21:30:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 21:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 21:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 21:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 21:30:10 [INFO]: Shopify Inventory id 49404107587806
2025-08-05 21:30:10 [INFO]: Shopify Location id 58450641063
2025-08-05 21:30:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 21:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T21:30: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-05 21:30:10 [INFO]: Change: available | Delta: -1
2025-08-05 21:30:10 [INFO]: Change: on_hand | Delta: -1
2025-08-05 21:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 21:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313111 and user_id = 14409 
2025-08-05 21:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265624 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 21:30:10 [INFO]: Shopify Inventory id 48936533950686
2025-08-05 21:30:10 [INFO]: Shopify Location id 58450641063
2025-08-05 21:30:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 21:30:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}}
2025-08-05 21:30:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 21:30:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44790304 and user_id = 14409 
2025-08-05 21:30:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77700473 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 21:30:11 [INFO]: Shopify Inventory id 45803711201502
2025-08-05 21:30:11 [INFO]: Shopify Location id 58450641063
2025-08-05 21:30:11 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 21:30:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T21:30:11Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-05 21:30:11 [INFO]: Change: available | Delta: -1
2025-08-05 21:30:11 [INFO]: Change: on_hand | Delta: -1
2025-08-05 21:30:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 21:30:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44577598 and user_id = 14409 
2025-08-05 21:30:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77470305 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 21:30:11 [INFO]: updateIdsQuantity -> ["78265624","77700473","77470305"]
2025-08-05 21:30:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-05 21:30:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 78265624 THEN 0 WHEN id = 77700473 THEN 0 WHEN id = 77470305 THEN 0  END, 
					  quantityflag = CASE WHEN id = 78265624 THEN 0 WHEN id = 77700473 THEN 0 WHEN id = 77470305 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (78265624,77700473,77470305)
2025-08-05 21:30:11 [INFO]: QUANTITY Updated IDs: 78265624, 77700473, 77470305
2025-08-05 21:30:11 [INFO]: Successfully processed data for user 14409
2025-08-05 21:30:11 [INFO]: Execution Started
2025-08-05 21:30:11 [INFO]: Execution Finished
2025-08-05 21:40:01 [INFO]: Execution Started
2025-08-05 21:40:01 [INFO]: old server sucessfully connected
2025-08-05 21:40:01 [INFO]: sqs client sucess created
2025-08-05 21:40:02 [INFO]: Number of messages in the queue: 2
2025-08-05 21:40:03 [INFO]: item found in queue is if condition  14409
2025-08-05 21:40:03 [INFO]: item found in queue is  14409
2025-08-05 21:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBJ+JRa7ts41zMYY8f+M6MzJH9xPOfspI5yMyMFELOBP21n5UgpfDh+NzyOZvDX6XmeEVPJM/CWTaQwo6pDE+JQTRCob6qMmSb1yDcvJ7FMeOtyA8S922SZDYLbBDdhyQgTBrbBU/zD5GkO6geC1HgN+jl0lPkEOrTO8EOxrTIOisE1e77fiO+rMhMqlxZunRxGrleBZ2jF359H2qe4GbkxUaMiiFDd8ONhw13We1+5s/dKsWJVRcvCjRnH/RSkdKpVfUfjyF4wOSpU3uR/aKMzurNIKiuQsQbcso3E4qZ9Mn1HPo4OuC444V5ts1VrJLKvE8RdN6x7+/s66aD6fN7ZYl5VPEZDTiHqOl4rGBlRV+CV5kivKSoFSlx3xx1mNTPSkT/sWl9HCrKQZ6IrhkzARn6+2hvQAQmbU57UIPs9a2jO89d/kudZ8Wp3xCJ8S2O
2025-08-05 21:40:03 [INFO]: item found in queue is if condition  14409
2025-08-05 21:40:03 [INFO]: item found in queue is  14409
2025-08-05 21:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBu9Ozg9ZfEDJGIwAessgB2OSbCXEa6xNA60zpRepoeTOMhFWuKfD6m/r9tUDGwueXZ/B0JvcjX3gQOPvqLhENsHsFsz2upoXhrK9S4ox1DBlDBwMERFkH+KYf3G3CF3K7UUsXrI4astlWpyJvVDTBexdY072PGy15VaUkTMy1FHV2cbo8u+k2f/N5jM3mNFeyrUHVhjS7uugljhTeWCGk70YX33DNsfx2cTdUGG20pJ0W4aZ2N3bu1TnhVZFCm70loBS6XoUyy366I2aptNpc24rypOfA+2Y2Dmj8Y8RRsncYQ1Wq593h4pt7fHjG7h3Mw0/WDAy18wO5LiBh2AIRy9hqwj8LFku7FpFcb2rfY8vel8kazEJ+LgsntKW+IdBNRJ3wBDQqo+WeB9TJxOqhdwKsMWQdwPHV1p2ZWTGMa4HQ1KgcxBPs+WCSGE2b0oVX
2025-08-05 21:40:03 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-05 21:40:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 21:40:03 [INFO]: inside itemsold and closed 14409
2025-08-05 21:40:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 21:40:05 [INFO]: autolink for user_id 14409 is 1
2025-08-05 21:40:05 [INFO]: Ebay item id :: 255593177189 exists in Database
2025-08-05 21:40:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 21:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 21:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 21:40:05 [INFO]: inside itemsold and closed 14409
2025-08-05 21:40:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 21:40:07 [INFO]: autolink for user_id 14409 is 1
2025-08-05 21:40:07 [INFO]: Ebay item id :: 285405074960 exists in Database
2025-08-05 21:40:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 21:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 21:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 21:40:07 [INFO]: in processold action queue is array    for {"44665086":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44665086","ebayitemid":"255593177189","shopifyproductid":"7699356385502","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"7699356385502","shopifyvariantid":"42995367510238","shopifyinventoryid":"45090565259486","shopifylocationid":"","product_id":"44665086","variant_id":"77570306","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44594409":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44594409","ebayitemid":"285405074960","shopifyproductid":"8098026651870","variants":[{"price":"10.99","quantity":0,"weight":"0.5","shopifyproductid":"8098026651870","shopifyvariantid":"44287857164510","shopifyinventoryid":"46385035018462","shopifylocationid":"","product_id":"44594409","variant_id":"77487118","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-05 21:40:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 21:40:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 21:40:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 21:40:07 [INFO]: Shopify Inventory id 45090565259486
2025-08-05 21:40:07 [INFO]: Shopify Location id 58450641063
2025-08-05 21:40:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 21:40:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T21: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":1988,"restoreRate":100}}}}
2025-08-05 21:40:07 [INFO]: Change: available | Delta: -1
2025-08-05 21:40:07 [INFO]: Change: on_hand | Delta: -1
2025-08-05 21:40:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 21:40:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44665086 and user_id = 14409 
2025-08-05 21:40:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77570306 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 21:40:07 [INFO]: Shopify Inventory id 46385035018462
2025-08-05 21:40:07 [INFO]: Shopify Location id 58450641063
2025-08-05 21:40:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 21:40: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-05 21:40:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 21:40:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44594409 and user_id = 14409 
2025-08-05 21:40:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77487118 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 21:40:07 [INFO]: updateIdsQuantity -> ["77570306","77487118"]
2025-08-05 21:40:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-05 21:40:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77570306 THEN 0 WHEN id = 77487118 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77570306 THEN 0 WHEN id = 77487118 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77570306,77487118)
2025-08-05 21:40:07 [INFO]: QUANTITY Updated IDs: 77570306, 77487118
2025-08-05 21:40:07 [INFO]: Successfully processed data for user 14409
2025-08-05 21:40:07 [INFO]: Execution Started
2025-08-05 21:40:07 [INFO]: Execution Finished
2025-08-05 21:50:02 [INFO]: Execution Started
2025-08-05 21:50:02 [INFO]: old server sucessfully connected
2025-08-05 21:50:02 [INFO]: sqs client sucess created
2025-08-05 21:50:03 [INFO]: Number of messages in the queue: 0
2025-08-05 21:50:23 [INFO]: Execution Started
2025-08-05 21:50:23 [INFO]: Execution Finished