2025-08-07 04:00:01 [INFO]: Execution Started
2025-08-07 04:00:01 [INFO]: old server sucessfully connected
2025-08-07 04:00:01 [INFO]: sqs client sucess created
2025-08-07 04:00:02 [INFO]: Number of messages in the queue: 0
2025-08-07 04:00:23 [INFO]: Execution Started
2025-08-07 04:00:23 [INFO]: Execution Finished
2025-08-07 04:10:01 [INFO]: Execution Started
2025-08-07 04:10:01 [INFO]: old server sucessfully connected
2025-08-07 04:10:01 [INFO]: sqs client sucess created
2025-08-07 04:10:02 [INFO]: Number of messages in the queue: 1
2025-08-07 04:10:03 [INFO]: item found in queue is if condition  14409
2025-08-07 04:10:03 [INFO]: item found in queue is  14409
2025-08-07 04:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBgCz2JJ/IxiDEbhlDlgy0MYQ6TsWndMq2gWXuYbd4x3IADxhpkNZjs+asOZhwn42cmGmj40yKQgXj3dqTm0YHWlw2u/8Ui6LsMVxlclhPGcjjjQsecr8ou/OV7mPvCt0WAfAi6rEpMpEDsutg5rVpkWz/ewQDnbU1RMmJL31AOPD8AYdChGvRjI9zwlyAIF/r+l73/g2oPO9T56e/aMTUQxFl2uuCu+SLL6cTpOh4mlnlbCjYf6bvitsrWoLKtwZlGIHXS+4NwARp77JQuqmVlrnUfo971bn2M2aF9I3ifJCsZVud2guQFjPuNuIhjjwFF2trXDrNffCefez1S4RV71xVDk0ZSrIPCajHpvOoWY2q26lVjef7wlRbPVjE3Eg4Y/XJmWS+uYRqqWUvvw93yobQrN+JEHTIxDBFlqaHKKQPadj8sGfeivVd8FdIsRAO
2025-08-07 04:10:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-07 04:10:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-07 04:10:03 [INFO]: inside itemsold and closed 14409
2025-08-07 04:10:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 04:10:05 [INFO]: autolink for user_id 14409 is 1
2025-08-07 04:10:05 [INFO]: Ebay item id :: 226561188091 exists in Database
2025-08-07 04:10:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 04:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 04:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 04:10:05 [INFO]: in processold action queue is array    for {"44670167":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44670167","ebayitemid":"226561188091","shopifyproductid":"8797680435422","variants":[{"price":"10.99","quantity":0,"weight":"0.5","shopifyproductid":"8797680435422","shopifyvariantid":"46239943131358","shopifyinventoryid":"48340379205854","shopifylocationid":"","product_id":"44670167","variant_id":"77575387","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-07 04:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-07 04:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 04:10:05 [INFO]: Shopify Inventory id 48340379205854
2025-08-07 04:10:05 [INFO]: Shopify Location id 58450641063
2025-08-07 04:10:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 04:10:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T04:10: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-07 04:10:05 [INFO]: Change: available | Delta: -1
2025-08-07 04:10:05 [INFO]: Change: on_hand | Delta: -1
2025-08-07 04:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 04:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44670167 and user_id = 14409 
2025-08-07 04:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77575387 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 04:10:05 [INFO]: updateIdsQuantity -> ["77575387"]
2025-08-07 04:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-07 04:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77575387 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77575387 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77575387)
2025-08-07 04:10:05 [INFO]: QUANTITY Updated IDs: 77575387
2025-08-07 04:10:05 [INFO]: Successfully processed data for user 14409
2025-08-07 04:10:05 [INFO]: Execution Started
2025-08-07 04:10:05 [INFO]: Execution Finished
2025-08-07 04:20:01 [INFO]: Execution Started
2025-08-07 04:20:01 [INFO]: old server sucessfully connected
2025-08-07 04:20:01 [INFO]: sqs client sucess created
2025-08-07 04:20:03 [INFO]: Number of messages in the queue: 0
2025-08-07 04:20:23 [INFO]: Execution Started
2025-08-07 04:20:23 [INFO]: Execution Finished
2025-08-07 04:30:01 [INFO]: Execution Started
2025-08-07 04:30:01 [INFO]: old server sucessfully connected
2025-08-07 04:30:02 [INFO]: sqs client sucess created
2025-08-07 04:30:03 [INFO]: Number of messages in the queue: 0
2025-08-07 04:30:23 [INFO]: Execution Started
2025-08-07 04:30:23 [INFO]: Execution Finished
2025-08-07 04:40:01 [INFO]: Execution Started
2025-08-07 04:40:01 [INFO]: old server sucessfully connected
2025-08-07 04:40:01 [INFO]: sqs client sucess created
2025-08-07 04:40:02 [INFO]: Number of messages in the queue: 1
2025-08-07 04:40:03 [INFO]: item found in queue is if condition  14409
2025-08-07 04:40:03 [INFO]: item found in queue is  14409
2025-08-07 04:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBNhFbONrWYQextuOpgHzE+m/Xs5VNOKQM8VCthZ11k6vvPNS8V0aG8aA/3jAUkK03Hv3zPGYuA+NuB7CxP6mOmhPttZuEgtUIZLoioCBZRPM4xdtvhHLFzka9bJFN4fubUNJnzJx+O5TGOavictxzNmVIU8ZkwHSNjFWxpPwQFQ2s/t7H/E2OV3sOGcIe0VaKznz27XVZVMxU7ts1KyH+VlqkvEJcZomA5sdED7iqceQc7XkJu9tC4KBnQqQl+D+9RwFGC44x4o0myUWMe58ZBadzCLgujYF/29cUC8MX941tiviro5DdgyyI4KbKE0A0XlicYBZzQVpTAxm/6bl7FLjEXCa379OPh3p9HxN+MZkRuMR4eHSY+1y2c+HFKOunPaV/Ip7LEbNM4I+MWQGU8WG9jGAYbE53mPMslSW3DuWwO45xCmsfaEy4nKNwl1fN
2025-08-07 04:40:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-07 04:40:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-07 04:40:03 [INFO]: inside itemsold and closed 14409
2025-08-07 04:40:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 04:40:05 [INFO]: autolink for user_id 14409 is 1
2025-08-07 04:40:05 [INFO]: Ebay item id :: 286036556954 exists in Database
2025-08-07 04:40:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 04:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 04:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 04:40:05 [INFO]: in processold action queue is array    for {"44774959":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44774959","ebayitemid":"286036556954","shopifyproductid":"8705792671966","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8705792671966","shopifyvariantid":"45960728936670","shopifyinventoryid":"48059399438558","shopifylocationid":"","product_id":"44774959","variant_id":"77683501","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-07 04:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-07 04:40:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 04:40:05 [INFO]: Shopify Inventory id 48059399438558
2025-08-07 04:40:05 [INFO]: Shopify Location id 58450641063
2025-08-07 04:40:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 04:40:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}}
2025-08-07 04:40:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 04:40:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44774959 and user_id = 14409 
2025-08-07 04:40:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77683501 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 04:40:05 [INFO]: updateIdsQuantity -> ["77683501"]
2025-08-07 04:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-07 04:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77683501 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77683501 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77683501)
2025-08-07 04:40:05 [INFO]: QUANTITY Updated IDs: 77683501
2025-08-07 04:40:05 [INFO]: Successfully processed data for user 14409
2025-08-07 04:40:05 [INFO]: Execution Started
2025-08-07 04:40:05 [INFO]: Execution Finished
2025-08-07 04:50:01 [INFO]: Execution Started
2025-08-07 04:50:01 [INFO]: old server sucessfully connected
2025-08-07 04:50:01 [INFO]: sqs client sucess created
2025-08-07 04:50:02 [INFO]: Number of messages in the queue: 1
2025-08-07 04:50:02 [INFO]: item found in queue is if condition  14409
2025-08-07 04:50:02 [INFO]: item found in queue is  14409
2025-08-07 04:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBW+oouhW1lWVfOcu/EjvtYXvEcz3c/b47i3WSnY6f3b1a9gutzTLe2HJu++yadBC6baJHByalFxXFWN2XzOBSBWKtoZjdC9CUiZe6ZfQNtBa8XOCu/lnxddJXEpnV4RIjXnHaOLWNGZTKz9UMhfBjiMAmu64v+8lOPA27WhqpSROK5kwa6eKTRfdog2LUVpBnR1LBqm9lpohDh+Brk6j91lyu5DiYM3JeXzCQEWnWhnLEJzOorozsSpBmS+9vJ3SWT/UtvEdKX7uxRgmJj5B0RGzPzAGgEQM0DxjXoI49wPwfW1pQQtwXiVzTauXVmb13tWa6cBUO8dZhEfexfZv+kMQAhAkaTOlJaVlZAHkHQV5OAgDCA4qXhLJIguxXFHLyg2vZy74nf5CferiAT8UZ5JkT8q9lksiCUVkOrouPm0gD92ACU//F+B8djSAVWyo8
2025-08-07 04:50:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-07 04:50:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-07 04:50:03 [INFO]: inside itemsold and closed 14409
2025-08-07 04:50:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 04:50:05 [INFO]: autolink for user_id 14409 is 1
2025-08-07 04:50:05 [INFO]: Ebay item id :: 286546347383 exists in Database
2025-08-07 04:50:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 04:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 04:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 04:50:05 [INFO]: in processold action queue is array    for {"44554757":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44554757","ebayitemid":"286546347383","shopifyproductid":"7066808320167","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"7066808320167","shopifyvariantid":"41427789709479","shopifyinventoryid":"43523984752807","shopifylocationid":"","product_id":"44554757","variant_id":"77447437","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-07 04:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-07 04:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 04:50:05 [INFO]: Shopify Inventory id 43523984752807
2025-08-07 04:50:05 [INFO]: Shopify Location id 58450641063
2025-08-07 04:50:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 04:50:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T04:50:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-07 04:50:05 [INFO]: Change: available | Delta: -1
2025-08-07 04:50:05 [INFO]: Change: on_hand | Delta: -1
2025-08-07 04:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 04:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44554757 and user_id = 14409 
2025-08-07 04:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77447437 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 04:50:05 [INFO]: updateIdsQuantity -> ["77447437"]
2025-08-07 04:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-07 04:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77447437 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77447437 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77447437)
2025-08-07 04:50:05 [INFO]: QUANTITY Updated IDs: 77447437
2025-08-07 04:50:05 [INFO]: Successfully processed data for user 14409
2025-08-07 04:50:05 [INFO]: Execution Started
2025-08-07 04:50:05 [INFO]: Execution Finished