2025-08-05 11:00:01 [INFO]: Execution Started
2025-08-05 11:00:01 [INFO]: old server sucessfully connected
2025-08-05 11:00:01 [INFO]: sqs client sucess created
2025-08-05 11:00:03 [INFO]: Number of messages in the queue: 1
2025-08-05 11:00:03 [INFO]: item found in queue is if condition  14409
2025-08-05 11:00:03 [INFO]: item found in queue is  14409
2025-08-05 11:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEB79TKGNyBcy5Jv7DQ4W3pnU5ESWuc/1F3sAY8QIulsm7d3txBRIDZa4DnVLmlE/8I1GxEyRaTaMhaRgo0DDnGmGRemD85X3tX429If3nvZsHml19YwngJdyEwoU1SAIw2x3IcbY/Jtupjrweyz4q+ACqcdnXJDliVRaxXKd1UH6He0ge4t6K7XR8rwSIeuOc/W7P//enPeHdS6zKg0mDAXccDwTShaid0u9cKzAqv3myvv+KKTc7/cu+cJV8UkK5rEZyOeYfrhb2SlJklTCAu5AtRAGFFlKGfHnlL0DUq8VhnXwI9ibamYcwwmni0loPlMkDAxT9IQkS6fgPGd1nud/fLYnj3kCqqW4w0dIPV0+MSm1J9AO/gsM8xYb2Ex5tvvG5M3Yw7Rf9GQKtnDgycANWoSQpwIOaQ6961M+QTtosSGopxYpdQyaeH0lcSlYUU
2025-08-05 11:00:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-05 11:00:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 11:00:03 [INFO]: inside itemsold and closed 14409
2025-08-05 11:00:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 11:00:05 [INFO]: autolink for user_id 14409 is 1
2025-08-05 11:00:05 [INFO]: Ebay item id :: 304118573648 exists in Database
2025-08-05 11:00:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 11:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 11:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 11:00:05 [INFO]: in processold action queue is array    for {"44588687":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44588687","ebayitemid":"304118573648","shopifyproductid":"7054907441319","variants":[{"price":"20.00","quantity":0,"weight":"2","shopifyproductid":"7054907441319","shopifyvariantid":"41369030787239","shopifyinventoryid":"43465049604263","shopifylocationid":"","product_id":"44588687","variant_id":"77481396","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-05 11:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 11:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 11:00:05 [INFO]: Shopify Inventory id 43465049604263
2025-08-05 11:00:05 [INFO]: Shopify Location id 58450641063
2025-08-05 11:00:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 11:00:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T11:00: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-05 11:00:05 [INFO]: Change: available | Delta: -1
2025-08-05 11:00:05 [INFO]: Change: on_hand | Delta: -1
2025-08-05 11:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 11:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44588687 and user_id = 14409 
2025-08-05 11:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77481396 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 11:00:05 [INFO]: updateIdsQuantity -> ["77481396"]
2025-08-05 11:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-05 11:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77481396 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77481396 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77481396)
2025-08-05 11:00:05 [INFO]: QUANTITY Updated IDs: 77481396
2025-08-05 11:00:05 [INFO]: Successfully processed data for user 14409
2025-08-05 11:00:05 [INFO]: Execution Started
2025-08-05 11:00:05 [INFO]: Execution Finished
2025-08-05 11:10:01 [INFO]: Execution Started
2025-08-05 11:10:01 [INFO]: old server sucessfully connected
2025-08-05 11:10:01 [INFO]: sqs client sucess created
2025-08-05 11:10:03 [INFO]: Number of messages in the queue: 0
2025-08-05 11:10:23 [INFO]: Execution Started
2025-08-05 11:10:23 [INFO]: Execution Finished
2025-08-05 11:20:02 [INFO]: Execution Started
2025-08-05 11:20:02 [INFO]: old server sucessfully connected
2025-08-05 11:20:02 [INFO]: sqs client sucess created
2025-08-05 11:20:07 [INFO]: Number of messages in the queue: 3
2025-08-05 11:20:08 [INFO]: item found in queue is if condition  14409
2025-08-05 11:20:08 [INFO]: item found in queue is  14409
2025-08-05 11:20:08 [INFO]: Message deleted from the queue for receipt handle: AQEBArWoj8h+RIuLA+q1gNZmEiPQNrv2rF7Dazq9tB5elBOEae0nU7n0I4kgMAgTzFfgf7+QKWcUHcaaqmqEOYv2dhv4ZnQDZIDbEaAEiSupwJ5TxnxbgL1gyh9srHTai+SIbJd4IhhRFC2uhA4TCAUpa3d3ejlbRuMtUclQLJPdIOcKNe8YbWFC5arW7awLNVyDSW0BmYUkYQ+U5RRsmWOcZqidR2EE8CQrGUxI/S8AYzFdpYRo2Q0uFYNS/P++k/ZFbRTzJ4EUaO5yKNyWaCii+9HS8Iimd4Xty3D0zUweAqzZMkzJXy0tuhRRBv8RC6JnuugM896NR6J1CCurW3MFx50bkL2vInV4DI2UoxDNvT4ed26HKiFGd2xOMNnVCkNWBVrVUTdjpBfQE0vieMdBriGGsadt1PpwXsDu2JwYqFa824Xty2MsKjMLhcpawO6l
2025-08-05 11:20:09 [INFO]: item found in queue is if condition  14409
2025-08-05 11:20:09 [INFO]: item found in queue is  14409
2025-08-05 11:20:10 [INFO]: Message deleted from the queue for receipt handle: AQEBj44H931ex6rmNhF323eutZ2pmPEkwGBjbUv//I/UO7ltqG4/66I5dOoNxblcnhdy0gsKDHeNx4MN0ed6vRInJWaZTzSkNae4DVrChZ9Ij3kn38b0KP/smTqct7FqzmHJupwEFKADYPyjZwhbgVjxcKWrBbG6IiUlo8iQK1AKlRSp9y2XkUaHdXONc7xMkK3PB7iyOgZr2ip7WaXHGGB5xLj1ckR53yaE9/zLL0XMXdXTECFG7NRK6LEWGqPcFNvVvTqFZMubLjAc58XmelgnZ9Sls8hOjQgnRqp2OQVQbOge4SJ6P0A4jDPXucaaxJ/eaPjbBPnRID/8mhDZ/Zl2H83bGrxjKfURuYIxPTm982huw+x6cWQ6UHYlVT/B6ZX+iVt44/lDZNMXkjvzMJqwvYOIdiwk0fJX2eZfPNp7q76QGLpZ+Ba4FccK7pkbb096
2025-08-05 11:20:10 [INFO]: item found in queue is if condition  14409
2025-08-05 11:20:10 [INFO]: item found in queue is  14409
2025-08-05 11:20:10 [INFO]: Message deleted from the queue for receipt handle: AQEBHFP0iYXgs60b+NEizQex8cXw9gf0m5H4J60kRDB0Pd6L1+mFyNFQIWrTA7lqt4V7Kl36BhdM5KY7LOSBeCefHxJh7RNPBvA0Cm8C6deMMTPcW1Ki0Yt4QsX2fL3SbJgq55g4O8l4oBGPHgjYF/KGBHm05XBmFsdPRcdhzZEdWGGYOsapAHjgBQIFGqaaVurnECtGIRwiD+x9Z1RVSnIyEzx1mInDCpiAUmkAMvmtHX2gJCscm9jwf/vUeUwp0oOdu3xGr1bOKJNXF2P1FrreskPPehS6x+uo1ll0NXfkxHYJDwiodF98dMQPhdJ32u3cSBFZGyrWOmsesWZUUl+N+oKnY3+kx+MzZTfpC7xABw5FruntCl63yJ+a5tMNUWTZE5KGuqjkPNicKDsiQOpqDY3cPzj9EV5rEx2aRx7vAmwQWkCiUyUy4PiftPItTSDA
2025-08-05 11:20:10 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-05 11:20:10 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 11:20:10 [INFO]: inside itemsold and closed 14409
2025-08-05 11:20:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 11:20:12 [INFO]: autolink for user_id 14409 is 1
2025-08-05 11:20:12 [INFO]: Ebay item id :: 305947565024 exists in Database
2025-08-05 11:20:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 11:20:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 11:20:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 11:20:12 [INFO]: inside itemsold and closed 14409
2025-08-05 11:20:14 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 11:20:14 [INFO]: autolink for user_id 14409 is 1
2025-08-05 11:20:14 [INFO]: Ebay item id :: 305947577088 exists in Database
2025-08-05 11:20:14 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 11:20:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 11:20:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 11:20:14 [INFO]: inside itemsold and closed 14409
2025-08-05 11:20:15 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 11:20:15 [INFO]: autolink for user_id 14409 is 1
2025-08-05 11:20:15 [INFO]: Ebay item id :: 305947529659 exists in Database
2025-08-05 11:20:15 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 11:20:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 11:20:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 11:20:15 [INFO]: in processold action queue is array    for {"44600264":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44600264","ebayitemid":"305947565024","shopifyproductid":"7631169355998","variants":[{"price":"59.99","quantity":0,"weight":"2","shopifyproductid":"7631169355998","shopifyvariantid":"42724188061918","shopifyinventoryid":"44818660786398","shopifylocationid":"","product_id":"44600264","variant_id":"77492973","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44600270":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44600270","ebayitemid":"305947577088","shopifyproductid":"7659148017886","variants":[{"price":"59.99","quantity":0,"weight":"2","shopifyproductid":"7659148017886","shopifyvariantid":"42826604052702","shopifyinventoryid":"44921209356510","shopifylocationid":"","product_id":"44600270","variant_id":"77492979","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44600234":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44600234","ebayitemid":"305947529659","shopifyproductid":"7513805914334","variants":[{"price":"59.99","quantity":0,"weight":"2","shopifyproductid":"7513805914334","shopifyvariantid":"42324785529054","shopifyinventoryid":"44418768634078","shopifylocationid":"","product_id":"44600234","variant_id":"77492943","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-05 11:20:15 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 11:20:15 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 11:20:15 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 11:20:15 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 11:20:15 [INFO]: Shopify Inventory id 44818660786398
2025-08-05 11:20:15 [INFO]: Shopify Location id 58450641063
2025-08-05 11:20:15 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 11:20:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T11:20:16Z","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 11:20:16 [INFO]: Change: available | Delta: -1
2025-08-05 11:20:16 [INFO]: Change: on_hand | Delta: -1
2025-08-05 11:20:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 11:20:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44600264 and user_id = 14409 
2025-08-05 11:20:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77492973 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 11:20:16 [INFO]: Shopify Inventory id 44921209356510
2025-08-05 11:20:16 [INFO]: Shopify Location id 58450641063
2025-08-05 11:20:16 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 11:20:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T11:20:16Z","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 11:20:16 [INFO]: Change: available | Delta: -1
2025-08-05 11:20:16 [INFO]: Change: on_hand | Delta: -1
2025-08-05 11:20:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 11:20:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44600270 and user_id = 14409 
2025-08-05 11:20:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77492979 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 11:20:16 [INFO]: Shopify Inventory id 44418768634078
2025-08-05 11:20:16 [INFO]: Shopify Location id 58450641063
2025-08-05 11:20:16 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 11:20:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T11:20:16Z","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 11:20:16 [INFO]: Change: available | Delta: -1
2025-08-05 11:20:16 [INFO]: Change: on_hand | Delta: -1
2025-08-05 11:20:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 11:20:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44600234 and user_id = 14409 
2025-08-05 11:20:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77492943 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 11:20:16 [INFO]: updateIdsQuantity -> ["77492973","77492979","77492943"]
2025-08-05 11:20:16 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-05 11:20:16 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77492973 THEN 0 WHEN id = 77492979 THEN 0 WHEN id = 77492943 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77492973 THEN 0 WHEN id = 77492979 THEN 0 WHEN id = 77492943 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77492973,77492979,77492943)
2025-08-05 11:20:16 [INFO]: QUANTITY Updated IDs: 77492973, 77492979, 77492943
2025-08-05 11:20:16 [INFO]: Successfully processed data for user 14409
2025-08-05 11:20:16 [INFO]: Execution Started
2025-08-05 11:20:16 [INFO]: Execution Finished
2025-08-05 11:30:01 [INFO]: Execution Started
2025-08-05 11:30:01 [INFO]: old server sucessfully connected
2025-08-05 11:30:01 [INFO]: sqs client sucess created
2025-08-05 11:30:03 [INFO]: Number of messages in the queue: 3
2025-08-05 11:30:04 [INFO]: item found in queue is if condition  14409
2025-08-05 11:30:04 [INFO]: item found in queue is  14409
2025-08-05 11:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEB1PKtrWnXoDuaj6Kb+qLtHKBfRZAJzzGyZb+pnnz7uf/uAvqSvq3+i1AHWIfJZboQsE8Kbt2IxYpF5eigu4xZAJropc34cKN2EwzIBsq7tPrAFyFPqtXvvxGqSjRg+6V2oYw3q8AGWOiOU+0t5QDtw5apimg9g10o/+1K+T+QXOVV9HCmlZxHvTcRXXjYuDmemLb/EjhWB6H4xW/aCpgWVJP+N9SxtIEs6UYkimLB0IpQ1hl31Cqi5bPI7eFywXch2c7OI8BtOCdC1dJxok+ODBhAN8uGh7VGe+4cTdZCKVAtBiRrhg1UhWc/VZlmFw3/YtESqWJNMNYqDfJeXwKIIpvUw+Wx2RrjdvOCq9T6mDLC2J67rH+2mkDZwd8IbkIxLjYQDstKR8Nmu1xgdCsxqbT33eh3bVpEng6rv9lJM0ZIlUWgAHsxu/mH8d83TRWR
2025-08-05 11:30:05 [INFO]: item found in queue is if condition  14409
2025-08-05 11:30:05 [INFO]: item found in queue is  14409
2025-08-05 11:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBhRoEJ0AnTgqPN5M8i+VNX5wLSX1fOxWmEOC/ll4dWw3KxlCCkRQtwaQZJH8zSQ0pUosshU1x3GEed2anoQ7eBappJ+bKk6/3c3LUCVF5kzFHOQPvL8zXHOOkOWCUKZZgDDKgWvqCI6oO0T8jKIbQE/A1yASL1djVJOyKrcF5tWI9Wwtm3pNI6kQQkcQMz+b+YbQzHkX6qH3d0QrAzHh+eHk36jb3ctwt/TQQa99Mr/SQqDnb0cyZhn8wkM7vgSIhDvshelFXCxarPrDA0Py0ZrOE0HHCM2lVh0gIB2gRfV9sr1p0/eg1MFW7MwPZY4aphfxa+a+zTnSdP8KiGl7Dxml3vZewbKRVufE13QsxC2oUpBV9UwajU86RUQeQ2Rjw3GtsMm0IQgoC0us3qVe0jli8fJUAnzHAFOded9Cfeu80GH8vA4tku9biM0i6g+Wx
2025-08-05 11:30:06 [INFO]: item found in queue is if condition  14409
2025-08-05 11:30:06 [INFO]: item found in queue is  14409
2025-08-05 11:30:06 [INFO]: Message deleted from the queue for receipt handle: AQEBuIucuzG3NA24MN5+NVk3VjtSUzwrHCxdf88msPmf7fV0e0F6ZIxjgELb/OVu3vniV/CCcHKFg+Pm2IShuzedZZ6wOmjH5mAeoXkHKnK4hjnChq6Eltic9xczD09aZWgV6rPVTpgkji2kulFigp96jXoBj+82maaXaxmyBllP4+6Ipp4FSZHbTVVCI7CIzVT6hykyIE5MPetY26eSwLcPQxcoTvdyhTlUiOBxZ633qxRQ/3+M4mdlqpa53DfeqDByQ5C7O6Pxs4vRyvoJGUKA0qM8hjBsqNS4aCZ7buA8iFoR9gzlzzRK6SjwTM43VxvklMlPfQ3eC2t9PK6TTFtchtqcv7MLsG55fAjRTT3iDKY7DW4orR5OVkLWqXZOTmwJQErj48eaSmzOyjcnL/Wftr1/BTHqqGWjldHFaHcRMjnEwGI8aPVTh4Yyx3V4ltod
2025-08-05 11:30:06 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-05 11:30:06 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 11:30:06 [INFO]: inside itemsold and closed 14409
2025-08-05 11:30:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 11:30:08 [INFO]: autolink for user_id 14409 is 1
2025-08-05 11:30:08 [INFO]: Ebay item id :: 284791162698 exists in Database
2025-08-05 11:30:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 11:30:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 11:30:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 11:30:08 [INFO]: inside itemsold and closed 14409
2025-08-05 11:30:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 11:30:09 [INFO]: autolink for user_id 14409 is 1
2025-08-05 11:30:09 [INFO]: Ebay item id :: 305947516705 exists in Database
2025-08-05 11:30:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 11:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 11:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 11:30:09 [INFO]: inside itemsold and closed 14409
2025-08-05 11:30:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 11:30:11 [INFO]: autolink for user_id 14409 is 1
2025-08-05 11:30:11 [INFO]: Ebay item id :: 226378126160 exists in Database
2025-08-05 11:30:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 11:30:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 11:30:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 11:30:11 [INFO]: in processold action queue is array    for {"44595739":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44595739","ebayitemid":"284791162698","shopifyproductid":"7639655809246","variants":[{"price":"59.99","quantity":0,"weight":"2","shopifyproductid":"7639655809246","shopifyvariantid":"42754571108574","shopifyinventoryid":"44849060708574","shopifylocationid":"","product_id":"44595739","variant_id":"77488448","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44600229":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44600229","ebayitemid":"305947516705","shopifyproductid":"7508927054046","variants":[{"price":"59.99","quantity":0,"weight":"2","shopifyproductid":"7508927054046","shopifyvariantid":"42301942792414","shopifyinventoryid":"44395876679902","shopifylocationid":"","product_id":"44600229","variant_id":"77492938","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44688437":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44688437","ebayitemid":"226378126160","shopifyproductid":"8695552639198","variants":[{"price":"74.99","quantity":0,"weight":"0.5","shopifyproductid":"8695552639198","shopifyvariantid":"45934940750046","shopifyinventoryid":"48033396850910","shopifylocationid":"","product_id":"44688437","variant_id":"77593683","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-05 11:30:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 11:30:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 11:30:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 11:30:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 11:30:11 [INFO]: Shopify Inventory id 44849060708574
2025-08-05 11:30:11 [INFO]: Shopify Location id 58450641063
2025-08-05 11:30:11 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 11:30:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T11:30:11Z","reason":"correction","changes":[{"name":"available","delta":-5},{"name":"on_hand","delta":-5}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-05 11:30:11 [INFO]: Change: available | Delta: -5
2025-08-05 11:30:11 [INFO]: Change: on_hand | Delta: -5
2025-08-05 11:30:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 11:30:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44595739 and user_id = 14409 
2025-08-05 11:30:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77488448 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 11:30:11 [INFO]: Shopify Inventory id 44395876679902
2025-08-05 11:30:11 [INFO]: Shopify Location id 58450641063
2025-08-05 11:30:11 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 11:30:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T11:30:12Z","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 11:30:12 [INFO]: Change: available | Delta: -1
2025-08-05 11:30:12 [INFO]: Change: on_hand | Delta: -1
2025-08-05 11:30:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 11:30:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44600229 and user_id = 14409 
2025-08-05 11:30:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77492938 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 11:30:12 [INFO]: Shopify Inventory id 48033396850910
2025-08-05 11:30:12 [INFO]: Shopify Location id 58450641063
2025-08-05 11:30:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 11:30:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T11:30:12Z","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-05 11:30:12 [INFO]: Change: available | Delta: -2
2025-08-05 11:30:12 [INFO]: Change: on_hand | Delta: -2
2025-08-05 11:30:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 11:30:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44688437 and user_id = 14409 
2025-08-05 11:30:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77593683 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 11:30:12 [INFO]: updateIdsQuantity -> ["77488448","77492938","77593683"]
2025-08-05 11:30:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-05 11:30:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77488448 THEN 0 WHEN id = 77492938 THEN 0 WHEN id = 77593683 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77488448 THEN 0 WHEN id = 77492938 THEN 0 WHEN id = 77593683 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77488448,77492938,77593683)
2025-08-05 11:30:12 [INFO]: QUANTITY Updated IDs: 77488448, 77492938, 77593683
2025-08-05 11:30:12 [INFO]: Successfully processed data for user 14409
2025-08-05 11:30:12 [INFO]: Execution Started
2025-08-05 11:30:12 [INFO]: Execution Finished
2025-08-05 11:40:02 [INFO]: Execution Started
2025-08-05 11:40:02 [INFO]: old server sucessfully connected
2025-08-05 11:40:02 [INFO]: sqs client sucess created
2025-08-05 11:40:03 [INFO]: Number of messages in the queue: 1
2025-08-05 11:40:04 [INFO]: item found in queue is if condition  14409
2025-08-05 11:40:04 [INFO]: item found in queue is  14409
2025-08-05 11:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBfwOhntiz6JIW4RY0KqFQ4vUKUgkKgP9uiWfKgHlFF0jn44Hfhxk01oU+88YTxfJzv8KhHuYyie917HQtEUw887YSs2VwjrPmccnXPMOPACz0T/P9xpkLHnAFb3hoRccpnCfEPKa+sL6axgYTZhhJlZA4AiWv4SgO3YU1Rw6MJyfIgtyfQy/Eptx4DFwWaEwa9aY9ITMnegCQOepnYtMRixPLggsN7lYj7qo6d50Dtx/DhHUbohVsseX64aIxZz+okt9PFp6/Mj+tTPmOell+gPeSxRDZl7IDm4r/IeiH34hv2YcHPM4sC8HfFozsxkQH928SyzwjBRcQGKAUs5Yyp//OgIou9fvkOfhkobwrq25NsLSgrU5WGPFAgdDJJgUoG40AyitkZgcDPBdwvsj7lU+gcgvwrtoaK1TfWyuJWUPJpXiZfOw+2NK8A/PHsER9
2025-08-05 11:40:04 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-05 11:40:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 11:40:04 [INFO]: inside itemsold and closed 14409
2025-08-05 11:40:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 11:40:06 [INFO]: autolink for user_id 14409 is 1
2025-08-05 11:40:06 [INFO]: Ebay item id :: 285873971093 exists in Database
2025-08-05 11:40:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 11:40:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 11:40:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 11:40:06 [INFO]: in processold action queue is array    for {"44588316":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44588316","ebayitemid":"285873971093","shopifyproductid":"8504408375518","variants":[{"price":"71.99","quantity":0,"weight":"0.5","shopifyproductid":"8504408375518","shopifyvariantid":"45415886586078","shopifyinventoryid":"47513863815390","shopifylocationid":"","product_id":"44588316","variant_id":"77481025","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-05 11:40:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 11:40:06 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 11:40:06 [INFO]: Shopify Inventory id 47513863815390
2025-08-05 11:40:06 [INFO]: Shopify Location id 58450641063
2025-08-05 11:40:06 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 11:40:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T11:40:06Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-05 11:40:06 [INFO]: Change: available | Delta: -1
2025-08-05 11:40:06 [INFO]: Change: on_hand | Delta: -1
2025-08-05 11:40:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 11:40:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44588316 and user_id = 14409 
2025-08-05 11:40:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77481025 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 11:40:06 [INFO]: updateIdsQuantity -> ["77481025"]
2025-08-05 11:40:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-05 11:40:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77481025 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77481025 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77481025)
2025-08-05 11:40:06 [INFO]: QUANTITY Updated IDs: 77481025
2025-08-05 11:40:06 [INFO]: Successfully processed data for user 14409
2025-08-05 11:40:06 [INFO]: Execution Started
2025-08-05 11:40:06 [INFO]: Execution Finished
2025-08-05 11:50:02 [INFO]: Execution Started
2025-08-05 11:50:02 [INFO]: old server sucessfully connected
2025-08-05 11:50:02 [INFO]: sqs client sucess created
2025-08-05 11:50:03 [INFO]: Number of messages in the queue: 6
2025-08-05 11:50:04 [INFO]: item found in queue is if condition  14409
2025-08-05 11:50:04 [INFO]: item found in queue is  14409
2025-08-05 11:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBHAvWID2b9OBNYPK1zbPjeLPGTJiY/ZCqHVyKnBR3aFDd18JLaWUIc8lW3BtQ1mUBxXK65Fjuq/oWvsCXmw05Rpa4quhCuDWNORzDW5foLmf36gGKKFdOwyk4vnmLc6X+BWHLcY75kM/94GdBtnH4QSKzMMGxDQqSGb/63sfYgJMgrCKZZBHoBdInB3nmIqViDKsaJVnLUPTOOsK4+jZIhByHncF6wX2zgREkLXxMktJpcnDBxRr4jEytpMmAc/J5mGPQ/QrhyEIk9+id6ayKcxrLCvQz5hk4HFhynV+kbUl6iW9c13nx2abONFZMR3UD79oYZBGHi8VWiaHj5q3enur73OW5dtee8rJiPjqb0fzlA2C2xFkhg8TTMlvA6cF+NVTXxCeq3YoLZ5KTmtxuythe5lHAwXK7XDRy7dqDV5soFCal2NsaXCmXvE7aW51q
2025-08-05 11:50:05 [INFO]: item found in queue is if condition  14409
2025-08-05 11:50:05 [INFO]: item found in queue is  14409
2025-08-05 11:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEBTd07VkaV9Qqk/Vwb69vN/H9AoWMLKrVtEhJ4+mWD/Z14jCZJdjladgltjG75TuC5XLHyNP8draXkY6JLbfPC3epyxouDt2YA+ruQ7FOqI4cawBKH6NGCj7gars1UcT8lFl7So4W5al9JvCPi/qYZ8Qg2ARWkx+zbT6cZjQ+IXNuztOpD93LmhgCC2zei02idmJzA5Z2RgTB7SrqviD+QMKCZXSS/TwiNolrGvXDAbfgMkYefc08NSVczKdY06KAXlghZ6LhWIjoV0OamF2nknJGcal/0a+pKORMmd74C90hsim0kUEgI3EIkvc/7KGlLQ6oVwU9oVWApdet0EjP3Xkxt7BoXxZfqfZYZErd9WFivQbAAft/q8Z8pU1WnTseL9Q5/O77qZ9dx2/FlTu3UJnz/4pNLPxQ9nUSzhrfyvfi7oa3f5aYB83C+OjyQzKPK
2025-08-05 11:50:06 [INFO]: item found in queue is if condition  14409
2025-08-05 11:50:06 [INFO]: item found in queue is  14409
2025-08-05 11:50:06 [INFO]: Message deleted from the queue for receipt handle: AQEBedTKnrEFc43birgSU3TygHktoGJ761L/zUv84sfkRWu2hSJwm6u77FXp4a2QPDJPtUPYfEM2z9UjMh7zf0KkPXbqxokrx2f8KS1eayVos1ev/jHI9ckl2sIgTyONU550e9k5qLWRyvgNnIMRiS8WtklS9X66p+AF/FDwWr9xglgk2ofABw/1fmGC4mb02LZIoO/xD2se4Rvubj9muXjFx6Lkcu9P3ScyLRmVV47wEzbC2N3NVSXO7v5Dzp4vfVBvzUg2W+6zD/cT6mE4RLAubMsGthNc8KNFdn+ict8CgYYZpA+epG9W4N6F+vsof3w+GjcEMcQlg6BvMztuMSOQ4ndYcROAcpTGBuwuGlRb1KjAct/ax/qHiPs8U87PthjXc+9GeSKRqA4QIITAvSonIz3aWTUTNGcLVcA+sVLriqkXWVKxi7eW3S/lDLrwybcQ
2025-08-05 11:50:06 [INFO]: item found in queue is if condition  14409
2025-08-05 11:50:06 [INFO]: item found in queue is  14409
2025-08-05 11:50:07 [INFO]: Message deleted from the queue for receipt handle: AQEBR1WLGx8y4sofrXQObiZoF37Oa0NdX8BXAApowYseHifIb3xOgqxrhSDOaQa5xiNV7ETzoEYztA07NNzJOnEyOBFYAYm9uMLvx36rKqb/Osynqp0BKircG+I36rm8YWIrLqhCoBnY1RNL6GFOEshaIZ8K3lYwMtnDVZzkupjIiEgQ77EUqLyHlgkTQsxUQ0Y4SbulLpLZrYfSZKTnZe3aQZorVvDcE5BK2T7nHQn7sZrMdoA06xnQ7RmVnCuiWd7cxjmuWqoWTQMWpNbIaVLv10rYZpdQidks27ZkS3YN9Em0/HLJZZ/SIvFtYZtiUPLDq8PloPC7LTpIwChY2siDAbkJg+ApUuMgT0VR2TQAnLoXpgiPfbr3TQHiaSfzrlH2ksj/b6u/csSmm3o+J981/fjolhNfqMrM1ROjWCox8J3Qhx2kOEabNoUxFfQ+tFCS
2025-08-05 11:50:07 [INFO]: item found in queue is if condition  14409
2025-08-05 11:50:07 [INFO]: item found in queue is  14409
2025-08-05 11:50:07 [INFO]: Message deleted from the queue for receipt handle: AQEBlv9SiMBZCTtUeQPz6D8KtACaIiCLwGkXik2GRSjAnA2E4WmJjnQHPmMTCC9altiOlXsOj3TONRrIMo440/s107JPM5PWK7MO/2RCNgjgCX+0c+vr8h/PDbNv3JF0wZkotMXPQKyTxLT47B63JWgFVBUOV63vNS8ewT8yPAqqLvBxteYtdR0B53NtiPR2uGRotCoYqajeSMwJgTObzyWbQiKEI4+byUopCWkjJGtBIBJFHlsdwEXNTogu30t+VnPkDYCX4Set0ej5OPSYnFP5xWi2gOAUXpv60B+VhbK1LwJCbAo8kO2e8LrmTjdZkPmkn1UZM2Z+s93UpVRUp260RcfbM43uSI2KckAdz/T2Zyy1iQtx+ycbRexBRKTo7SThwIR7eie0Qu5RbdQaxnhMSwEpFsbDkcTXbz/49N4YcidDUKXfuvYvV56Idt3/gt5N
2025-08-05 11:50:08 [INFO]: item found in queue is if condition  14409
2025-08-05 11:50:08 [INFO]: item found in queue is  14409
2025-08-05 11:50:08 [INFO]: Message deleted from the queue for receipt handle: AQEBmeaYJlJOKgpI10Y4DDVBOR8uHpC2hqq1vcbKwm5DCHAvmaeJAY7FS/xy+Tm/2fL7pvMU6YrDZGfxaVycaWHfBPhd7LiM+FsHNWJQrtOfUW+tXhYSza0vb1sb+wm+FkID7i6V7od0UBVChuqOAM/luDBdyWrQ6LPL6ZHUA6Ga5sCWG8Vz98ZzReaAxI8aN5kFRktKFM+2M/QhAbgRcGXamO8muLDp5/Fy9n72+xKTQRJ61Y6376iPBanxFn0rLmZrL3N983BS2jNz8iWW3MKq+NwP+tWZtw4+tLN/IAX5XXCGo4Yc49fc00iup2paHUMYRPdp+Vo1KCTlyH0v4QXRLPWlgqGnPoQSUQHJrP+fJyquIrMmOXqcP8xjeGGBZOlaAJ4t2U3j3r1PSLqClKsgDN8eLrLMPngbCaOcxpcNRk1/nFsLVvQwdvyL7Dab89uR
2025-08-05 11:50:08 [INFO]: Processed 6 messages, reached the limit of 6.
2025-08-05 11:50:08 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 11:50:08 [INFO]: inside itemsold and closed 14409
2025-08-05 11:50:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 11:50:10 [INFO]: autolink for user_id 14409 is 1
2025-08-05 11:50:10 [INFO]: Ebay item id :: 224950421215 exists in Database
2025-08-05 11:50:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 11:50:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 11:50:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 11:50:10 [INFO]: inside itemsold and closed 14409
2025-08-05 11:50:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 11:50:12 [INFO]: autolink for user_id 14409 is 1
2025-08-05 11:50:12 [INFO]: Ebay item id :: 325158408031 exists in Database
2025-08-05 11:50:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 11:50:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 11:50:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 11:50:12 [INFO]: inside itemsold and closed 14409
2025-08-05 11:50:14 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 11:50:14 [INFO]: autolink for user_id 14409 is 1
2025-08-05 11:50:14 [INFO]: Ebay item id :: 226477840430 exists in Database
2025-08-05 11:50:14 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 11:50:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 11:50:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 11:50:14 [INFO]: inside itemsold and closed 14409
2025-08-05 11:50:15 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 11:50:15 [INFO]: autolink for user_id 14409 is 1
2025-08-05 11:50:15 [INFO]: Ebay item id :: 325077308851 exists in Database
2025-08-05 11:50:15 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 11:50:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 11:50:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 11:50:15 [INFO]: inside itemsold and closed 14409
2025-08-05 11:50:17 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 11:50:17 [INFO]: autolink for user_id 14409 is 1
2025-08-05 11:50:17 [INFO]: Ebay item id :: 325159099141 exists in Database
2025-08-05 11:50:17 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 11:50:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 11:50:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 11:50:17 [INFO]: inside itemsold and closed 14409
2025-08-05 11:50:18 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 11:50:18 [INFO]: autolink for user_id 14409 is 1
2025-08-05 11:50:18 [INFO]: Ebay item id :: 285837448661 exists in Database
2025-08-05 11:50:18 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 11:50:18 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 11:50:18 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 11:50:18 [INFO]: in processold action queue is array    for {"44666495":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44666495","ebayitemid":"224950421215","shopifyproductid":"7630982447326","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"7630982447326","shopifyvariantid":"42723469164766","shopifyinventoryid":"44817941233886","shopifylocationid":"","product_id":"44666495","variant_id":"77571715","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44666670":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44666670","ebayitemid":"325158408031","shopifyproductid":"7630992113886","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"7630992113886","shopifyvariantid":"42723545153758","shopifyinventoryid":"44818016960734","shopifylocationid":"","product_id":"44666670","variant_id":"77571890","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44711901":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44711901","ebayitemid":"226477840430","shopifyproductid":"8752768123102","variants":[{"price":"69.99","quantity":0,"weight":"2","shopifyproductid":"8752768123102","shopifyvariantid":"46121179873502","shopifyinventoryid":"48220269379806","shopifylocationid":"","product_id":"44711901","variant_id":"77619514","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44685180":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44685180","ebayitemid":"325077308851","shopifyproductid":"7573672198366","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"7573672198366","shopifyvariantid":"42522291011806","shopifyinventoryid":"44616281489630","shopifylocationid":"","product_id":"44685180","variant_id":"77590405","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44668718":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44668718","ebayitemid":"325159099141","shopifyproductid":"7631443493086","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"7631443493086","shopifyvariantid":"42725087936734","shopifyinventoryid":"44819561742558","shopifylocationid":"","product_id":"44668718","variant_id":"77573938","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772786":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772786","ebayitemid":"285837448661","shopifyproductid":"8458504044766","variants":[{"price":"55.99","quantity":0,"weight":"2","shopifyproductid":"8458504044766","shopifyvariantid":"45298113446110","shopifyinventoryid":"47396036509918","shopifylocationid":"","product_id":"44772786","variant_id":"77681328","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-05 11:50:19 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 11:50:19 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 11:50:19 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 11:50:19 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 11:50:19 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 11:50:19 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 11:50:19 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 11:50:19 [INFO]: Shopify Inventory id 44817941233886
2025-08-05 11:50:19 [INFO]: Shopify Location id 58450641063
2025-08-05 11:50:19 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 11:50:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T11:50: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 11:50:19 [INFO]: Change: available | Delta: -1
2025-08-05 11:50:19 [INFO]: Change: on_hand | Delta: -1
2025-08-05 11:50:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 11:50:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44666495 and user_id = 14409 
2025-08-05 11:50:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77571715 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 11:50:19 [INFO]: Shopify Inventory id 44818016960734
2025-08-05 11:50:19 [INFO]: Shopify Location id 58450641063
2025-08-05 11:50:19 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 11:50:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T11:50: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 11:50:19 [INFO]: Change: available | Delta: -1
2025-08-05 11:50:19 [INFO]: Change: on_hand | Delta: -1
2025-08-05 11:50:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 11:50:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44666670 and user_id = 14409 
2025-08-05 11:50:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77571890 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 11:50:19 [INFO]: Shopify Inventory id 48220269379806
2025-08-05 11:50:19 [INFO]: Shopify Location id 58450641063
2025-08-05 11:50:19 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 11:50:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T11:50:19Z","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-05 11:50:19 [INFO]: Change: available | Delta: -2
2025-08-05 11:50:19 [INFO]: Change: on_hand | Delta: -2
2025-08-05 11:50:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 11:50:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44711901 and user_id = 14409 
2025-08-05 11:50:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77619514 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 11:50:19 [INFO]: Shopify Inventory id 44616281489630
2025-08-05 11:50:19 [INFO]: Shopify Location id 58450641063
2025-08-05 11:50:19 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 11:50:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T11:50:20Z","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 11:50:20 [INFO]: Change: available | Delta: -1
2025-08-05 11:50:20 [INFO]: Change: on_hand | Delta: -1
2025-08-05 11:50:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 11:50:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44685180 and user_id = 14409 
2025-08-05 11:50:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77590405 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 11:50:20 [INFO]: Shopify Inventory id 44819561742558
2025-08-05 11:50:20 [INFO]: Shopify Location id 58450641063
2025-08-05 11:50:20 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 11:50:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T11:50:20Z","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 11:50:20 [INFO]: Change: available | Delta: -1
2025-08-05 11:50:20 [INFO]: Change: on_hand | Delta: -1
2025-08-05 11:50:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 11:50:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44668718 and user_id = 14409 
2025-08-05 11:50:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77573938 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 11:50:20 [INFO]: Shopify Inventory id 47396036509918
2025-08-05 11:50:20 [INFO]: Shopify Location id 58450641063
2025-08-05 11:50:20 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 11:50:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T11:50:20Z","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 11:50:20 [INFO]: Change: available | Delta: -1
2025-08-05 11:50:20 [INFO]: Change: on_hand | Delta: -1
2025-08-05 11:50:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 11:50:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772786 and user_id = 14409 
2025-08-05 11:50:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681328 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 11:50:20 [INFO]: updateIdsQuantity -> ["77571715","77571890","77619514","77590405","77573938","77681328"]
2025-08-05 11:50:20 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 6. Affected rows: 6
2025-08-05 11:50:20 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77571715 THEN 0 WHEN id = 77571890 THEN 0 WHEN id = 77619514 THEN 0 WHEN id = 77590405 THEN 0 WHEN id = 77573938 THEN 0 WHEN id = 77681328 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77571715 THEN 0 WHEN id = 77571890 THEN 0 WHEN id = 77619514 THEN 0 WHEN id = 77590405 THEN 0 WHEN id = 77573938 THEN 0 WHEN id = 77681328 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77571715,77571890,77619514,77590405,77573938,77681328)
2025-08-05 11:50:20 [INFO]: QUANTITY Updated IDs: 77571715, 77571890, 77619514, 77590405, 77573938, 77681328
2025-08-05 11:50:20 [INFO]: Successfully processed data for user 14409
2025-08-05 11:50:20 [INFO]: Execution Started
2025-08-05 11:50:20 [INFO]: Execution Finished