2025-07-31 13:00:01 [INFO]: Execution Started
2025-07-31 13:00:01 [INFO]: old server sucessfully connected
2025-07-31 13:00:02 [INFO]: sqs client sucess created
2025-07-31 13:00:03 [INFO]: Number of messages in the queue: 1
2025-07-31 13:00:03 [INFO]: item found in queue is if condition  14409
2025-07-31 13:00:03 [INFO]: item found in queue is  14409
2025-07-31 13:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBPto1gD+4Z+A7jjalyDtirGN2YAD/jWeNQ/l95AVvL91FEEArnD02aWfzPqHNcCnasI/aKTL7aCmYCsPTqf4HmgKXVXR2DoWxLdOswWfKjn556q4IJW1YgcYCOibE24/h6IwUxWhh8uY1BaGfXGhehRPw20+jnr/2qLo/jj3tNxUy6eByaByXqe9R1NKuE8ib1H4t0RyI0U6SS+TU8qdySHH6jEFzErv+OHU5dMpEp4xkHa+c9iYyU5B7tSJSowz7bANHxzRqDBMk7nPFc3cHQA8uBXIrKMkFF7vP5GkUzCgeG0oYVaJdTEWB4LH8bvryKO9VgmZU+72OmU+Qko4rz/TDwhhlQrlYN5e82RdtAJ4x4EJN5t+bvikDG0eOO0rGPDVG9MxymwEyyMBvVhgOOGAnIwkN8lMS3uadiRy+Imu4Oh4RYH5brREHzku68eG6
2025-07-31 13:00:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-07-31 13:00:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 13:00:03 [INFO]: inside itemsold and closed 14409
2025-07-31 13:00:05 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 13:00:05 [INFO]: autolink for user_id 14409 is 1
2025-07-31 13:00:05 [INFO]: Ebay item id :: 404789487970 exists in Database
2025-07-31 13:00:05 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 13:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 13:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 13:00:05 [INFO]: in processold action queue is array    for {"44771602":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44771602","ebayitemid":"404789487970","shopifyproductid":"8697478349022","variants":[{"price":"23.99","quantity":0,"weight":"3","shopifyproductid":"8697478349022","shopifyvariantid":"45939266060510","shopifyinventoryid":"48037722521822","shopifylocationid":"","product_id":"44771602","variant_id":"77680144","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 13:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 13:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 13:00:05 [INFO]: Shopify Inventory id 48037722521822
2025-07-31 13:00:05 [INFO]: Shopify Location id 58450641063
2025-07-31 13:00:05 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 13:00:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T13: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-07-31 13:00:05 [INFO]: Change: available | Delta: -1
2025-07-31 13:00:05 [INFO]: Change: on_hand | Delta: -1
2025-07-31 13:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 13:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44771602 and user_id = 14409 
2025-07-31 13:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680144 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 13:00:05 [INFO]: updateIdsQuantity -> ["77680144"]
2025-07-31 13:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-07-31 13:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77680144 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77680144 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77680144)
2025-07-31 13:00:05 [INFO]: QUANTITY Updated IDs: 77680144
2025-07-31 13:00:05 [INFO]: Successfully processed data for user 14409
2025-07-31 13:00:05 [INFO]: Execution Started
2025-07-31 13:00:05 [INFO]: Execution Finished
2025-07-31 13:10:01 [INFO]: Execution Started
2025-07-31 13:10:01 [INFO]: old server sucessfully connected
2025-07-31 13:10:01 [INFO]: sqs client sucess created
2025-07-31 13:10:02 [INFO]: Number of messages in the queue: 2
2025-07-31 13:10:03 [INFO]: item found in queue is if condition  14409
2025-07-31 13:10:03 [INFO]: item found in queue is  14409
2025-07-31 13:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEB1Nv9+5QpZ9Eq1Uk0Zn9Nn+oII5fErX+ahM2sgaZmKTmk9w5m+0ZCwcinDIZvc2HDr4CJd8XktFDwrhRNBSnLskqxhGXchk4gaF4lCQ7WdQ2H13QNI213G+g9J5ivP0Z0yaDrvL6dV9/e1/7XZGbgvAZRO9oTBvxeNX9pngOccF8a53NJgeiUs0k7Jjws4eLrbzzagB4LtV7ktkQ7QvGP4Z5yzK/94Wfz4cvKeIon7YTRxpPbQZDKjFBN5YXcJM1YnnHmZPtfrQ83TPFrRqPmj5pTkBxlmPUd14EiBkWWduvbB5k0cnIG+vtZZ9VUPkgJ/XatEEIm5IPkyGY8Jnk8Jvh1tZUhFpOBwUnM+FF/2eaR7EA6tegC5MCoNYT1pYfpjpQj1HQjQm7l9tDM8J0ynEHos4YvUn6ic56nVjjlSbXB3Lm1hrV1e9Zz+5ywUkug
2025-07-31 13:10:03 [INFO]: item found in queue is if condition  14409
2025-07-31 13:10:03 [INFO]: item found in queue is  14409
2025-07-31 13:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBFIeJ8Ektgj5O+l1P7Yb0EKasUTnl8aItKtn3fxJ82Lp8o81g+sh/G05z4z2DQrbO6ULYC9O9A6rZIp64DVvw+1xSFKsaWte1w6erhFKHUXWZEI4o3ISYIzx/JXRWPlB5PSbW05bUVsXxmBLRx7LEgRz0aoRUiGPUz3cAxou53moSWrILV/TOYzXoH94V0yvJrK+6itcPa7qncLMzQJNhE89m4VmOrxX76tjb1yr1Am9hLJKOpMGevWuCoNDvrIbYTrJRrqSFrGkn1YhrVx8/kyhTV3vyehz2WXwRnYPG2t9PIO2yxaOi+N2/m3KgdkghmyaKl2wUIM/TeiDoxVCGUtaiKjvqSGl2RWYiq9/s9XczGLgdd48HBop5JMxtRj5GAlFrLrOL+Eto6eajc6olSa7ZyqwU1j89CCT67JBEyUbZEzPrpoxOlaMXOmGlpShK
2025-07-31 13:10:03 [INFO]: Processed 2 messages, reached the limit of 2.
2025-07-31 13:10:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 13:10:03 [INFO]: inside itemsold and closed 14409
2025-07-31 13:10:05 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 13:10:05 [INFO]: autolink for user_id 14409 is 1
2025-07-31 13:10:05 [INFO]: Ebay item id :: 285656892826 exists in Database
2025-07-31 13:10:05 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 13:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 13:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 13:10:05 [INFO]: inside itemsold and closed 14409
2025-07-31 13:10:07 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 13:10:07 [INFO]: autolink for user_id 14409 is 1
2025-07-31 13:10:07 [INFO]: Ebay item id :: 404794886909 exists in Database
2025-07-31 13:10:07 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 13:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 13:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 13:10:07 [INFO]: in processold action queue is array    for {"44649848":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44649848","ebayitemid":"285656892826","shopifyproductid":"8255171887326","variants":[{"price":"31.99","quantity":0,"weight":"3","shopifyproductid":"8255171887326","shopifyvariantid":"44678220546270","shopifyinventoryid":"46776179261662","shopifylocationid":"","product_id":"44649848","variant_id":"77555037","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44771687":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44771687","ebayitemid":"404794886909","shopifyproductid":"8696101404894","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"8696101404894","shopifyvariantid":"45936207691998","shopifyinventoryid":"48034656649438","shopifylocationid":"","product_id":"44771687","variant_id":"77680229","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 13:10:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 13:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 13:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 13:10:07 [INFO]: Shopify Inventory id 46776179261662
2025-07-31 13:10:07 [INFO]: Shopify Location id 58450641063
2025-07-31 13:10:07 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 13:10:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T13:10:07Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-07-31 13:10:07 [INFO]: Change: available | Delta: -1
2025-07-31 13:10:07 [INFO]: Change: on_hand | Delta: -1
2025-07-31 13:10:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 13:10:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44649848 and user_id = 14409 
2025-07-31 13:10:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77555037 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 13:10:07 [INFO]: Shopify Inventory id 48034656649438
2025-07-31 13:10:07 [INFO]: Shopify Location id 58450641063
2025-07-31 13:10:07 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 13:10:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T13:10:07Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-07-31 13:10:07 [INFO]: Change: available | Delta: -1
2025-07-31 13:10:07 [INFO]: Change: on_hand | Delta: -1
2025-07-31 13:10:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 13:10:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44771687 and user_id = 14409 
2025-07-31 13:10:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680229 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 13:10:07 [INFO]: updateIdsQuantity -> ["77555037","77680229"]
2025-07-31 13:10:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-07-31 13:10:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77555037 THEN 0 WHEN id = 77680229 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77555037 THEN 0 WHEN id = 77680229 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77555037,77680229)
2025-07-31 13:10:07 [INFO]: QUANTITY Updated IDs: 77555037, 77680229
2025-07-31 13:10:07 [INFO]: Successfully processed data for user 14409
2025-07-31 13:10:07 [INFO]: Execution Started
2025-07-31 13:10:07 [INFO]: Execution Finished
2025-07-31 13:20:01 [INFO]: Execution Started
2025-07-31 13:20:01 [INFO]: old server sucessfully connected
2025-07-31 13:20:01 [INFO]: sqs client sucess created
2025-07-31 13:20:03 [INFO]: Number of messages in the queue: 3
2025-07-31 13:20:04 [INFO]: item found in queue is if condition  14409
2025-07-31 13:20:04 [INFO]: item found in queue is  14409
2025-07-31 13:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBb8i22IEwDpUMOPuOR0LBUVs2/qPqCSIRcfToVeDyx6ro8B2OiGb1yCLUT5RRJqtuTasXBNbg2kK01lU2c3zp01kUpe57afyvGdAyQBCX0e/P7CCtqUccxUt7RGW7UXw/xmJz1tMmSVCa2ZiJaQGygnHqJKHB+kBejJ+ktJQ4LhC7qcOWdVycQk+H0IU+IfXq3YU7J/fodaqClQL0JVOydthkY0c2HVQ1lPCSkLEPwopZKEzT9XPOjSCWsWLW1CwRuA95LOIqq+H1uCtIltTIaRLm+uVa5hbDD98j1q+DYOJb6qU9qEjhyGgUsNbDCg1eoFzoAIM1BI7AjosagwgYNWztgThfQ05Aux4Vz/J72dxa1/nMs3dXALeTyJujFAW80IGqCMwuAtVZlx2KiD+E18YhlMj0LfZbB49UzR/yrpXmXDVWEWLlsXm9UK3Np+bM
2025-07-31 13:20:05 [INFO]: item found in queue is if condition  14409
2025-07-31 13:20:05 [INFO]: item found in queue is  14409
2025-07-31 13:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBhgsDpCEw5ApbSFWSdakDYNYTOCeFB1hF2c1y/h4SkEE8OqJbrBhWi3WeXNn5ThwX3XtWBQqsdmxL5luqi1wR03VgKKZ6YohhlqvbQcgP58hRWbrmgDnZpirz3KDAnVaqJ9fcLsLDmXps6CT/66+58TaadKGVnE8fnJIKmGMq5hmrrUAqBeEoEgDETDHaVc74xA/BG48etROrzE1Q0rt1q31mgOVFjQAbD50iSRdjkSRsJ6/pzMDnaEwjT95XXIBGqj6RRk6zd08da8b3zZvUblwqTLWGySsR1GYJRwmhgp9NC5OtlgbVVYOqCz4KdyKwIpivVeBZ9v8zY8Fv3kTzpQzKrgJ8//WyR5FW5uS8Ud3OlkNRUzXYFBeFNsTlkBJdy0d7L5q2XlcM44pTDBrfom0gW8VlS/Q7T8Hp3txB3UkGr418uC4TSj05i4+Elxag
2025-07-31 13:20:05 [INFO]: item found in queue is if condition  14409
2025-07-31 13:20:05 [INFO]: item found in queue is  14409
2025-07-31 13:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBAc568HVjDEkQHiwOfMf5moA4vldtgxtLEdOgmikfn8a+UdQV596ILoIceft8qQkLoHFaDH9avjAEy7Fx7ectXE1fnmXDwRN1+eCGeDHYiz6deL8AG9xrnoOl426A5Ozyyyd/pbqOCxWdHbBasIavLlH4tLmwVNsgum8Uj04bnTDSY5yugfPIYEHA0lTLd57nG1mkOfKI7j2aRcGKmJ2C11wEVY3G7y5bPSCwQdojhnC0DhQwoMnRcXx4PaLFyV7RODDXmONBv0ApchMcHSwBOeVz73KDWsZkGhAmSxUDtoVl0PxQCpV+JS+XcvnM1QgtB0tsHB3Z4SbQfW/iOCnRBo/osNEND6yzB9DYC553Fk/Di8hBFFw14cZSCoc6mtWUtvalkcbPrJuEty4Lnx3f8rZpIKr4zjkfAKArSqBoyMTwEZj9w4NrDEwhIvJJMvFG
2025-07-31 13:20:05 [INFO]: Processed 3 messages, reached the limit of 3.
2025-07-31 13:20:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 13:20:05 [INFO]: inside itemsold and closed 14409
2025-07-31 13:20:07 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 13:20:07 [INFO]: autolink for user_id 14409 is 1
2025-07-31 13:20:07 [INFO]: Ebay item id :: 285697988894 exists in Database
2025-07-31 13:20:07 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 13:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 13:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 13:20:07 [INFO]: inside itemsold and closed 14409
2025-07-31 13:20:09 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 13:20:09 [INFO]: autolink for user_id 14409 is 1
2025-07-31 13:20:09 [INFO]: Ebay item id :: 404796882775 exists in Database
2025-07-31 13:20:09 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 13:20:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 13:20:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 13:20:09 [INFO]: inside itemsold and closed 14409
2025-07-31 13:20:10 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 13:20:10 [INFO]: autolink for user_id 14409 is 1
2025-07-31 13:20:10 [INFO]: Ebay item id :: 404991351742 exists in Database
2025-07-31 13:20:10 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 13:20:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 13:20:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 13:20:10 [INFO]: in processold action queue is array    for {"44771689":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44771689","ebayitemid":"285697988894","shopifyproductid":"8694969925854","variants":[{"price":"288.99","quantity":0,"weight":"4","shopifyproductid":"8694969925854","shopifyvariantid":"45933671973086","shopifyinventoryid":"48032123158750","shopifylocationid":"","product_id":"44771689","variant_id":"77680231","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44638824":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44638824","ebayitemid":"404796882775","shopifyproductid":"8694960619742","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"8694960619742","shopifyvariantid":"45933650247902","shopifyinventoryid":"48032101433566","shopifylocationid":"","product_id":"44638824","variant_id":"77544013","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44667501":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44667501","ebayitemid":"404991351742","shopifyproductid":"8497695097054","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"8497695097054","shopifyvariantid":"45406206329054","shopifyinventoryid":"47504184934622","shopifylocationid":"","product_id":"44667501","variant_id":"77572721","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 13:20:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 13:20:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 13:20:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 13:20:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 13:20:10 [INFO]: Shopify Inventory id 48032123158750
2025-07-31 13:20:10 [INFO]: Shopify Location id 58450641063
2025-07-31 13:20:10 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 13:20:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T13:20: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-07-31 13:20:11 [INFO]: Change: available | Delta: -1
2025-07-31 13:20:11 [INFO]: Change: on_hand | Delta: -1
2025-07-31 13:20:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 13:20:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44771689 and user_id = 14409 
2025-07-31 13:20:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680231 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 13:20:11 [INFO]: Shopify Inventory id 48032101433566
2025-07-31 13:20:11 [INFO]: Shopify Location id 58450641063
2025-07-31 13:20:11 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 13:20:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T13:20: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-07-31 13:20:11 [INFO]: Change: available | Delta: -1
2025-07-31 13:20:11 [INFO]: Change: on_hand | Delta: -1
2025-07-31 13:20:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 13:20:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44638824 and user_id = 14409 
2025-07-31 13:20:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77544013 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 13:20:11 [INFO]: Shopify Inventory id 47504184934622
2025-07-31 13:20:11 [INFO]: Shopify Location id 58450641063
2025-07-31 13:20:11 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 13:20:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T13:20: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-07-31 13:20:11 [INFO]: Change: available | Delta: -1
2025-07-31 13:20:11 [INFO]: Change: on_hand | Delta: -1
2025-07-31 13:20:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 13:20:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44667501 and user_id = 14409 
2025-07-31 13:20:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77572721 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 13:20:11 [INFO]: updateIdsQuantity -> ["77680231","77544013","77572721"]
2025-07-31 13:20:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-07-31 13:20:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77680231 THEN 0 WHEN id = 77544013 THEN 0 WHEN id = 77572721 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77680231 THEN 0 WHEN id = 77544013 THEN 0 WHEN id = 77572721 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77680231,77544013,77572721)
2025-07-31 13:20:11 [INFO]: QUANTITY Updated IDs: 77680231, 77544013, 77572721
2025-07-31 13:20:11 [INFO]: Successfully processed data for user 14409
2025-07-31 13:20:11 [INFO]: Execution Started
2025-07-31 13:20:11 [INFO]: Execution Finished
2025-07-31 13:30:01 [INFO]: Execution Started
2025-07-31 13:30:01 [INFO]: old server sucessfully connected
2025-07-31 13:30:01 [INFO]: sqs client sucess created
2025-07-31 13:30:02 [INFO]: Number of messages in the queue: 3
2025-07-31 13:30:02 [INFO]: item found in queue is if condition  14409
2025-07-31 13:30:02 [INFO]: item found in queue is  14409
2025-07-31 13:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBhRm+2pXDbcUn9ZBQnngFcSRP3VtFC2Mz+MuNM2xenkMVrqFSqZhfygmsSlEyvwfgARTV6m+nq3Q/Vy3HnzBe3kHXmcOW9sxY5xYiGNyfF6u9P1dA8zK87KEruZhDIRF7qkUznJhCOoUrx7ye2e8fN5oI66qX3EYV+0XEw9TqSJEOg3GRA2m5Co+T+Tv0aj2eClCablEuYl0XkidnUuSrcCTjIDLbtQjod022emWzw9zqjba8dbphrWIN+EwJ06gGx9QRaQwH4VJvwrHerEsbbRJUaIhtPnT8VTvappJ4A3bvysJVxEELDzb78RPJaRpfo/mgjpKmKnKXhhRpfIkEG8m2Hfu0kSOOf+a7GupT8MRFfQgw8tD58Gko3DlzuXg+pvCy6chy2524dsCT8ryq/Z4z2OtSU/l37CMFospK1jyiqh8Up5t90owVKV4OiEWS
2025-07-31 13:30:03 [INFO]: item found in queue is if condition  14409
2025-07-31 13:30:03 [INFO]: item found in queue is  14409
2025-07-31 13:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBO9OhFV6xPp90OYUyyf4tmXl41+s8PrwI+Zp5bZj+u6TrHWVM60TIUMegsCPLAEcrwdPv4YJ0e0OLjquILi/Lt9IWOli47uBCUvumA45+Mf74N8LP1WD/mhsefumIXVKqkYAe57S9ZYcKNSr5TqzVTcBGjMGlmXaMwNy1LkG5Z9P51SP/TKLOUl/i+7JtbIIzwHKBOTEQueZWMYsEf1T9qt9xRo2Syp5h2zIZTg1DMPzic5uMnJOh9TRu+bOwNG1fNkaNeHMyslzeAoyrblp+Yg9joZWhfxERaAz5Ja9SLFOtcmjPAqlSBNGA/Xy74QhW/1CF63Or75oXZe9lke/1wuvfUnheZFQZHykELZ0BX5RqtfYMgVRBUFEkFsx8ZFnpY34RBAG66C+gi6yNS11+8zQ093Ld9mV48AErZzUQ/38vyfNEyOUpKCNaHXmro9de
2025-07-31 13:30:03 [INFO]: item found in queue is if condition  14409
2025-07-31 13:30:03 [INFO]: item found in queue is  14409
2025-07-31 13:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBb6N5z9i1ko/1N7gd0jFzCsStIJu+59PfGbG45K+kA5qZ0oNXLpglkM/V7FBGCmdjVk6x7jgbOlijIfwSwrPFvhtHuPG5nL1BklwbokX23v/ZKmdbvVfARfiu0TkH5IDDJtVnQ2YkUgfAZmCF4uRJZ/IMZ0+sO1z8D7P7JTSGBPSfQE3vTYTVVXAQDikNdwyAusG78BN48oY0c7VpLbQ/G7NWj8WHPSpSyf7cCN/b+DM1zgK2N/5Xp2tCnanABSwWSek3PZrv0UV3S48hJ7PqwehdDkPB+iE8Iw5QkYmk/6HKUMDfuU4XvEiyN+kaw+i9zk2iezEhnJRQgq0kZ1GlBfyIyNTl5Rnddmz31Rn0i62fsMF5t4H5FbLlTg+RKBF9I6a7j5b6urazcUozZ7JsLEX7s9wkBHTDhFD948u4SvqbPxbEpDaXdHG7TpCImkl+
2025-07-31 13:30:04 [INFO]: Processed 3 messages, reached the limit of 3.
2025-07-31 13:30:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 13:30:04 [INFO]: inside itemsold and closed 14409
2025-07-31 13:30:05 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 13:30:05 [INFO]: autolink for user_id 14409 is 1
2025-07-31 13:30:05 [INFO]: Ebay item id :: 256737880500 exists in Database
2025-07-31 13:30:05 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 13:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 13:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 13:30:05 [INFO]: inside itemsold and closed 14409
2025-07-31 13:30:07 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 13:30:07 [INFO]: autolink for user_id 14409 is 1
2025-07-31 13:30:07 [INFO]: Ebay item id :: 405215128413 exists in Database
2025-07-31 13:30:07 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 13:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 13:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 13:30:07 [INFO]: inside itemsold and closed 14409
2025-07-31 13:30:09 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 13:30:09 [INFO]: autolink for user_id 14409 is 1
2025-07-31 13:30:09 [INFO]: Ebay item id :: 256745958652 exists in Database
2025-07-31 13:30:09 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 13:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 13:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 13:30:09 [INFO]: in processold action queue is array    for {"44777068":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44777068","ebayitemid":"256737880500","shopifyproductid":"7671814062302","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"7671814062302","shopifyvariantid":"42880941523166","shopifyinventoryid":"44975718498526","shopifylocationid":"","product_id":"44777068","variant_id":"77685610","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44775371":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44775371","ebayitemid":"405215128413","shopifyproductid":"8695086317790","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"8695086317790","shopifyvariantid":"45933931233502","shopifyinventoryid":"48032382615774","shopifylocationid":"","product_id":"44775371","variant_id":"77683913","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44777348":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44777348","ebayitemid":"256745958652","shopifyproductid":"8046936064222","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"8046936064222","shopifyvariantid":"44199246856414","shopifyinventoryid":"46296324014302","shopifylocationid":"","product_id":"44777348","variant_id":"77685890","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 13:30:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 13:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 13:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 13:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 13:30:09 [INFO]: Shopify Inventory id 44975718498526
2025-07-31 13:30:09 [INFO]: Shopify Location id 58450641063
2025-07-31 13:30:09 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 13:30:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T13:30:09Z","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-07-31 13:30:09 [INFO]: Change: available | Delta: -1
2025-07-31 13:30:09 [INFO]: Change: on_hand | Delta: -1
2025-07-31 13:30:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 13:30:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44777068 and user_id = 14409 
2025-07-31 13:30:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685610 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 13:30:09 [INFO]: Shopify Inventory id 48032382615774
2025-07-31 13:30:09 [INFO]: Shopify Location id 58450641063
2025-07-31 13:30:09 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 13:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T13:30:09Z","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-07-31 13:30:10 [INFO]: Change: available | Delta: -1
2025-07-31 13:30:10 [INFO]: Change: on_hand | Delta: -1
2025-07-31 13:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 13:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44775371 and user_id = 14409 
2025-07-31 13:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77683913 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 13:30:10 [INFO]: Shopify Inventory id 46296324014302
2025-07-31 13:30:10 [INFO]: Shopify Location id 58450641063
2025-07-31 13:30:10 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 13:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T13: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-07-31 13:30:10 [INFO]: Change: available | Delta: -1
2025-07-31 13:30:10 [INFO]: Change: on_hand | Delta: -1
2025-07-31 13:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 13:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44777348 and user_id = 14409 
2025-07-31 13:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685890 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 13:30:10 [INFO]: updateIdsQuantity -> ["77685610","77683913","77685890"]
2025-07-31 13:30:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-07-31 13:30:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77685610 THEN 0 WHEN id = 77683913 THEN 0 WHEN id = 77685890 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77685610 THEN 0 WHEN id = 77683913 THEN 0 WHEN id = 77685890 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77685610,77683913,77685890)
2025-07-31 13:30:10 [INFO]: QUANTITY Updated IDs: 77685610, 77683913, 77685890
2025-07-31 13:30:10 [INFO]: Successfully processed data for user 14409
2025-07-31 13:30:10 [INFO]: Execution Started
2025-07-31 13:30:10 [INFO]: Execution Finished
2025-07-31 13:40:01 [INFO]: Execution Started
2025-07-31 13:40:01 [INFO]: old server sucessfully connected
2025-07-31 13:40:01 [INFO]: sqs client sucess created
2025-07-31 13:40:03 [INFO]: Number of messages in the queue: 4
2025-07-31 13:40:04 [INFO]: item found in queue is if condition  14409
2025-07-31 13:40:04 [INFO]: item found in queue is  14409
2025-07-31 13:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBGEAsX22pMNykOYwsgbrXC3qR59QeWY8/6rFOs8vbJkvra3jOkzr0BKtbbcxPaI9PjqGTcn3LUDZ0/9T+zOPi8PmWdmr5cJtFYWhFmCZt5S8Ua79k5iYtDvweYKms6SKDsquXfyI4XqGHzHuJFxQCyPs4GE8ydtvTAbDTb/74fSBxWx5/kVlJosb0tU/IubKUs0NSQwZZ7SJGltjCqsg28d8qHh+0r0o8SLlGPXNjx4zwa+CgWdKa7pt5L2Nj5sV1lWAToKFIMmPSDCY6N9JPILXLBYN+JZLxHfzEHt1l1iC/rUJAqHric/QILuadFfYoh/RtZZSxaBVbQCk3MNbfH829u3nXGBbGMKB5XSEl45b23f5kyN3ueht1s6mBWr4Z2OnLiedLGDWiasrMYGD2jILPpHD+nvpIMGcxKAoTFs8QQY2ZtW4c6bAm9oCAPt4x
2025-07-31 13:40:04 [INFO]: item found in queue is if condition  14409
2025-07-31 13:40:04 [INFO]: item found in queue is  14409
2025-07-31 13:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBEwSUi2d9o7rlP5WM86h2nAL0q/gdf9Jei+a2Eip9ZOM0ICmRvO9w5caMu7FPYVwdZacqFA4BMn9Vf5njcZN/+vHB4+xKnYToEz4CfY5XkOFbNlbAFo+ajXjoIsxN+VeuzSTp951XN7GMPcGnTaDpHo5rjyPbTwloM26eZRVAUJ3teuj4LXnaCFRBzLZVg+KxCxibc0fEVJxrKmC702OF3TUnXQvbNJrQECW/FQZ2KkydEBDzUUzzRY3mzLk4gmnEU3jGJclhnxEg68rJbZa/l4honmhe2+P16CkUQswS/buxoyIDSZOZgcvSlgVG4lXPhJaxcKCE+ClTpc1Y+sbbTns/t6pEO7stGuRJ8QJhH3Ska6BgJXdGzkRw7qTqpbvqvI8vpXG/MMQPz0Is5lzDxNRBWY6qRUUmyhTycEMo86ji+6q6jk1vvAtpLKpJ2t4B
2025-07-31 13:40:05 [INFO]: item found in queue is if condition  14409
2025-07-31 13:40:05 [INFO]: item found in queue is  14409
2025-07-31 13:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEB+4+/wyc7juogFXGv1nJ/q0REpr0hlqeHKEuHhfLAgulMe4ZemrPaJ0d+Ki3fE6r8bziaGfNBdTXc3qfz6ULbBwYvkLg/LPh6WQ8EuWmN9vTwU8ukQciQnqOmZxLX4zbbVoB7NHJdiiKW096EjQ/ilYENOYwKsCY9pWJ9uB4hfXGavb+LY8dt+R2R7qE4cpAn7MYN5uZcn9DIxC33ojVbWVl6/D23H75eml+sT+y+5i/k6A62gWMiEsjLg0gQFPdLTUKwaofHr5MHS1AujbUDvKiJ/uj1t1O7B4gJ84CGlVNVpMBKT1pbptfBsj3ToB9PCvLDvkeK9gurXYsjMwgGKDPJynhcoVRDPDpHUG332QnHTdBTzPrMRlOSp44A2N+2nDFv2xuwwbwwazbLzm5qT93OQlE8jNjaunHBIu6FzXz/QuWe9lG5kogOrRmadW/d
2025-07-31 13:40:06 [INFO]: item found in queue is if condition  14409
2025-07-31 13:40:06 [INFO]: item found in queue is  14409
2025-07-31 13:40:07 [INFO]: Message deleted from the queue for receipt handle: AQEBBf4gA4JNXZi81zIrzWhHoKdIJugN9158DX9VkRKOj8fZCwuewCLwldlT9nAAhEwouk1lhstAB8u48j4HBTfWvlfBV/EcxJGcxPszO9nLWfpL+ZdED64hJCv1w7rxRlaoA2Vva6zM22/Q7V19fdWPWL0Rp4jBLjIXnd+dQA71maYXVT4W5sKKuUNFm8rk7RtKx2REMWge4tDeM0oclnthc79wlriRVGnIxy+r4zzPUE+7lkG30rjS3zPBbXnXICXjY3fuE7FqPLH2ivRLW2pg7/gIxh/8h03uu82/obHH7W0sE8ZlUXgpQ9vqcrTXT3lHy/I4p3PRP6gzaJxD8y/aIC+B0eONAKNUNpzZ2szItJQrRqlp4hiJxR8IFsUeD9QRvfuzMjw4FuA/dyLsz5QOtWFdb853khKTL7hrtH7JNQglp+4YlYNm1Fht16HyDARW
2025-07-31 13:40:07 [INFO]: Processed 4 messages, reached the limit of 4.
2025-07-31 13:40:07 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 13:40:07 [INFO]: inside itemsold and closed 14409
2025-07-31 13:40:09 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 13:40:09 [INFO]: autolink for user_id 14409 is 1
2025-07-31 13:40:09 [INFO]: Ebay item id :: 256745973639 exists in Database
2025-07-31 13:40:09 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 13:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 13:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 13:40:09 [INFO]: inside itemsold and closed 14409
2025-07-31 13:40:10 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 13:40:10 [INFO]: autolink for user_id 14409 is 1
2025-07-31 13:40:10 [INFO]: Ebay item id :: 256745975250 exists in Database
2025-07-31 13:40:10 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 13:40:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 13:40:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 13:40:10 [INFO]: inside itemsold and closed 14409
2025-07-31 13:40:12 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 13:40:12 [INFO]: autolink for user_id 14409 is 1
2025-07-31 13:40:12 [INFO]: Ebay item id :: 256745971744 exists in Database
2025-07-31 13:40:12 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 13:40:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 13:40:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 13:40:12 [INFO]: inside itemsold and closed 14409
2025-07-31 13:40:14 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 13:40:14 [INFO]: autolink for user_id 14409 is 1
2025-07-31 13:40:14 [INFO]: Ebay item id :: 286208336550 exists in Database
2025-07-31 13:40:14 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 13:40:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 13:40:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 13:40:14 [INFO]: in processold action queue is array    for {"44777353":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44777353","ebayitemid":"256745973639","shopifyproductid":"8091582890206","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"8091582890206","shopifyvariantid":"44276091519198","shopifyinventoryid":"46373258232030","shopifylocationid":"","product_id":"44777353","variant_id":"77685895","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44777354":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44777354","ebayitemid":"256745975250","shopifyproductid":"8106153246942","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"8106153246942","shopifyvariantid":"44302791540958","shopifyinventoryid":"46400205029598","shopifylocationid":"","product_id":"44777354","variant_id":"77685896","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44777351":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44777351","ebayitemid":"256745971744","shopifyproductid":"7672358174942","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"7672358174942","shopifyvariantid":"42883254190302","shopifyinventoryid":"44978056102110","shopifylocationid":"","product_id":"44777351","variant_id":"77685893","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44777356":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44777356","ebayitemid":"286208336550","shopifyproductid":"8118838362334","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"8118838362334","shopifyvariantid":"44326974554334","shopifyinventoryid":"46424604410078","shopifylocationid":"","product_id":"44777356","variant_id":"77685898","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 13:40:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 13:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 13:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 13:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 13:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 13:40:14 [INFO]: Shopify Inventory id 46373258232030
2025-07-31 13:40:14 [INFO]: Shopify Location id 58450641063
2025-07-31 13:40:14 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 13:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T13:40:14Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-07-31 13:40:14 [INFO]: Change: available | Delta: -1
2025-07-31 13:40:14 [INFO]: Change: on_hand | Delta: -1
2025-07-31 13:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 13:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44777353 and user_id = 14409 
2025-07-31 13:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685895 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 13:40:14 [INFO]: Shopify Inventory id 46400205029598
2025-07-31 13:40:14 [INFO]: Shopify Location id 58450641063
2025-07-31 13:40:14 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 13:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T13:40:14Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-07-31 13:40:14 [INFO]: Change: available | Delta: -1
2025-07-31 13:40:14 [INFO]: Change: on_hand | Delta: -1
2025-07-31 13:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 13:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44777354 and user_id = 14409 
2025-07-31 13:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685896 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 13:40:14 [INFO]: Shopify Inventory id 44978056102110
2025-07-31 13:40:14 [INFO]: Shopify Location id 58450641063
2025-07-31 13:40:14 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 13:40:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T13:40:15Z","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-07-31 13:40:15 [INFO]: Change: available | Delta: -1
2025-07-31 13:40:15 [INFO]: Change: on_hand | Delta: -1
2025-07-31 13:40:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 13:40:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44777351 and user_id = 14409 
2025-07-31 13:40:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685893 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 13:40:15 [INFO]: Shopify Inventory id 46424604410078
2025-07-31 13:40:15 [INFO]: Shopify Location id 58450641063
2025-07-31 13:40:15 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 13:40:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T13:40:15Z","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-07-31 13:40:15 [INFO]: Change: available | Delta: -1
2025-07-31 13:40:15 [INFO]: Change: on_hand | Delta: -1
2025-07-31 13:40:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 13:40:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44777356 and user_id = 14409 
2025-07-31 13:40:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685898 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 13:40:15 [INFO]: updateIdsQuantity -> ["77685895","77685896","77685893","77685898"]
2025-07-31 13:40:15 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4
2025-07-31 13:40:15 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77685895 THEN 0 WHEN id = 77685896 THEN 0 WHEN id = 77685893 THEN 0 WHEN id = 77685898 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77685895 THEN 0 WHEN id = 77685896 THEN 0 WHEN id = 77685893 THEN 0 WHEN id = 77685898 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77685895,77685896,77685893,77685898)
2025-07-31 13:40:15 [INFO]: QUANTITY Updated IDs: 77685895, 77685896, 77685893, 77685898
2025-07-31 13:40:15 [INFO]: Successfully processed data for user 14409
2025-07-31 13:40:15 [INFO]: Execution Started
2025-07-31 13:40:15 [INFO]: Execution Finished
2025-07-31 13:50:01 [INFO]: Execution Started
2025-07-31 13:50:01 [INFO]: old server sucessfully connected
2025-07-31 13:50:01 [INFO]: sqs client sucess created
2025-07-31 13:50:05 [INFO]: Number of messages in the queue: 2
2025-07-31 13:50:06 [INFO]: item found in queue is if condition  14409
2025-07-31 13:50:06 [INFO]: item found in queue is  14409
2025-07-31 13:50:06 [INFO]: Message deleted from the queue for receipt handle: AQEB7ZjvFwK4UrZ5UBuNkyOhs9QkQZyTXFSpEbf1jt2wyfT4V+7awJTnMkmcnCday/uxvlQcQCg7P2DfOvf0SCzpRd9m0MwDFweyMjdOHSmQi46y0/Cc2C2skCcwEMa2pQdimQpyYOthPMg50+J8CoGtYihtRgK/LSx2C71UlTYiQsTxttCkdGY7GeN3kmQZ05/pW6945oDC/muE/PvCW4YvhWjRrrqXNxgFNK50/gIN7kRIzXBo1PCMXe73swHOOW4vfWv99o9FGrM2GCA07XSsxhkCh1peaC161AcfnR2LcxRC2HKfh7a9uhYBn9T9koeMyVrN/+9PeMQcNFkBklmAVSRRqAtlo3b5a4ZfvrJtWOi1E5lgxR6CHAjlczrdUTCEZYe+F5dMixzoY2Z+RMYPzqKfRSyJ9CyZd+LRVTxolMmiabUFch2yq3mSTAL2nSwe
2025-07-31 13:50:07 [INFO]: item found in queue is if condition  14409
2025-07-31 13:50:07 [INFO]: item found in queue is  14409
2025-07-31 13:50:07 [INFO]: Message deleted from the queue for receipt handle: AQEBMySuQ/ou6IbtsIgOrxljnUhmz7LH7xxVUPXT3yO0EgZD1S6RfNOxR52MD+yRZkvo8sRhMxb/MkHXtZjM3YNSfCboxikyedWajjYyvw10nqnvgtfLGZWEfCn9fKqvYTx70ipoMK9G35dRdPVQ7SefECBJJNB/QrypZfecG7aVbvQmZIyPD/4oxApVyoUVbcUjE2I91dxSKjO00qQ3yVPAI6N5cWjaXBBB8C3WelMzMvGCC5V/DyCnNOV6a7LqopoaT9DTb5sVqgFSag4ofWChbaB+xkztvS54oSULFLYnv2/8EE+7dsYHTgpn9HTs4J1Ud9M3qxVb9n2FVhdTJPI/uDEADIZnK6M/Fl+nzZrx+C9WaHHw6SREkY/vtmuxoERMJWe3dyWD1aMCsZwQLdOPlS4s/3MuEfEeb10kh7LhIVIsmvAiW1a9iH1zWglDK6AJ
2025-07-31 13:50:07 [INFO]: Processed 2 messages, reached the limit of 2.
2025-07-31 13:50:07 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 13:50:07 [INFO]: inside itemsold and closed 14409
2025-07-31 13:50:09 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 13:50:09 [INFO]: autolink for user_id 14409 is 1
2025-07-31 13:50:09 [INFO]: Ebay item id :: 256745980378 exists in Database
2025-07-31 13:50:09 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 13:50:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 13:50:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 13:50:09 [INFO]: inside itemsold and closed 14409
2025-07-31 13:50:11 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 13:50:11 [INFO]: autolink for user_id 14409 is 1
2025-07-31 13:50:11 [INFO]: Ebay item id :: 286533467207 exists in Database
2025-07-31 13:50:11 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 13:50:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 13:50:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 13:50:11 [INFO]: in processold action queue is array    for {"44777358":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44777358","ebayitemid":"256745980378","shopifyproductid":"8118841016542","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"8118841016542","shopifyvariantid":"44326977962206","shopifyinventoryid":"46424607817950","shopifylocationid":"","product_id":"44777358","variant_id":"77685900","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44597766":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44597766","ebayitemid":"286533467207","shopifyproductid":"8200521416926","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"8200521416926","shopifyvariantid":"44511062687966","shopifyinventoryid":"46609001283806","shopifylocationid":"","product_id":"44597766","variant_id":"77490475","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 13:50:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 13:50:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 13:50:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 13:50:11 [INFO]: Shopify Inventory id 46424607817950
2025-07-31 13:50:11 [INFO]: Shopify Location id 58450641063
2025-07-31 13:50:11 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 13:50:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T13:50: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-07-31 13:50:11 [INFO]: Change: available | Delta: -1
2025-07-31 13:50:11 [INFO]: Change: on_hand | Delta: -1
2025-07-31 13:50:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 13:50:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44777358 and user_id = 14409 
2025-07-31 13:50:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685900 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 13:50:11 [INFO]: Shopify Inventory id 46609001283806
2025-07-31 13:50:11 [INFO]: Shopify Location id 58450641063
2025-07-31 13:50:11 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 13:50:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T13:50: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-07-31 13:50:11 [INFO]: Change: available | Delta: 1
2025-07-31 13:50:11 [INFO]: Change: on_hand | Delta: 1
2025-07-31 13:50:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 13:50:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44597766 and user_id = 14409 
2025-07-31 13:50:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77490475 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 13:50:11 [INFO]: updateIdsQuantity -> ["77685900","77490475"]
2025-07-31 13:50:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-07-31 13:50:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77685900 THEN 0 WHEN id = 77490475 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77685900 THEN 0 WHEN id = 77490475 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77685900,77490475)
2025-07-31 13:50:11 [INFO]: QUANTITY Updated IDs: 77685900, 77490475
2025-07-31 13:50:11 [INFO]: Successfully processed data for user 14409
2025-07-31 13:50:11 [INFO]: Execution Started
2025-07-31 13:50:11 [INFO]: Execution Finished