2025-07-31 18:00:01 [INFO]: Execution Started
2025-07-31 18:00:01 [INFO]: old server sucessfully connected
2025-07-31 18:00:01 [INFO]: sqs client sucess created
2025-07-31 18:00:02 [INFO]: Number of messages in the queue: 4
2025-07-31 18:00:03 [INFO]: item found in queue is if condition  14409
2025-07-31 18:00:03 [INFO]: item found in queue is  14409
2025-07-31 18:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBqe2+1hKf2cca9cY2BDOTD0Di5jatgrf9oViHaXbliDsB5dv880PWIrkLbb31xJ+zZ80oOKoUjr8V8cuUafyg/nohtmuc4quVpNXes2ScMJ9fqm7YrFnv4v9DZBCLQTPQdC6IQSQcQyRPocRuAVQyDma1NDIFU2a2Us2wJEJrHWIygx1HoeJ9MdGNSKwPWJTMaqNvIGwpPDK3GVmuAzoGvv+YaBCqWPjPWrHmqwoDmelRbLkY9RgY9BA988FI3GnOgaKU29oHiLCUxgibX/NpPIehnOIwjEYH+O38uY+fdfvvXoZNb1hJCx3vX6RN/vtd+9IFHlQZoVuSKLn++8x63jreo/G0KHlQcYWB64u4nYDoZXGLmFbf5JizFkdKpjefJmhJZR9YjbvDJOcJPG2Jg6yv7DwABtMP1+LN3AAVCZwnOJUt6MBBfoKhvokn9Wqd
2025-07-31 18:00:03 [INFO]: item found in queue is if condition  14409
2025-07-31 18:00:03 [INFO]: item found in queue is  14409
2025-07-31 18:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEB/cmW91/r/u5F7tmmc6Hjybelr//3FkzgMrTutJlpc71bgTaDreAl5tKgUpIbr5leMQd3D6bSQOFZD7L/8cuIzAmSg59Z2gHG2sfRXRLl78SEKp3abz/TdLEhtTu9J2pSd0X8knMt1nmrkXjUWp3SOkKRFxvcQWanS1xZpt0gpygbObZXwZfewIU2PN2uRFcUGJ6Wwk/sV26ObwVpUvEH+IDA203eGD+FOJ7fHT48w2ARpBwa6PTMhqAuxsEHMYAAsj6TCxkCE4TnvYCsdUIH0XkwvGjaw8QH6NlJCYCCRJEyxF0g3moos0N2nyCLIJJa2gdnm7KYv/1+jM7MPi3G8wcVj+BM0lNse8hDQOYjWPLrWkC0BCyNL1WR8KucYvl8Cl+Vgij6wyy/nqAQzO05PsWY6Ao5uWSzLldkPmeafU0JuApPOSoTdEYZ6HUN7uoK
2025-07-31 18:00:04 [INFO]: item found in queue is if condition  14409
2025-07-31 18:00:04 [INFO]: item found in queue is  14409
2025-07-31 18:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBetgbWY2bEyEE2I0S9YUAsKWng14BMboHD6HOBP23gXRcme1GG7D/r6pAHSP09Sr7Z3R7YSKLjPN67QqHJKlMkex2mYdQUspKvwAMDj3I1fS43lTIAciGgHp2DIhgNkYyHbkgDB9PhILEeHTS6qjwleu/JLK5XxGJ1QDCTo+WI0JW9EGxdwPm24nurjGdz6HvVwF78UgLOy+NJ4uawTN0Ezj3IlGnkUCaA6La1tL6aJ+tfjHBmRfKZrko06JT9I2au4envZz3l3a4ux3t068zqQKYMqiqaMmQer/fjslRO04+lIUKYajZxaec/Btg785nFNxSYu1V8D6ELy+NwtNqygJC1kLvwG3Khd/PQq23duXJ8NH6oLsx8QXW5dZEPjTHUK0nIDQClmuarhbF5YyBHlM43t7HOG30fvQgGVItfFSiXNKS4vpxKW2mSP6jtF39
2025-07-31 18:00:04 [INFO]: item found in queue is if condition  14409
2025-07-31 18:00:04 [INFO]: item found in queue is  14409
2025-07-31 18:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBQx1tCiZ0hFOHHMw5cwKf6PvLW8Gp1dGzOMUigRj1Uen9sGyJZpq4FpeJlZmp4gvDF+7jvOCOBL2tPM2tOTz867+vnLdp30HEa89HYAjj8CxfihU7GSmqAG5T2HG84523aCEOw/K0WPFPUJX4oTDTBYv9Oq/chU19dTBrc4/TY4tRTHNSyh4SrWK7dFq3IYWZ9IFYZhJupPal28PmihM+s1wGydunwgNUWe0c9B6c1mnXpbBkdUwhQbhud5Qfm6EvLKDVW4XKZd9D2oXip6bX3Nv3Mm7WlzD4dzC10Shrfi5JMkzNyE32GTLd/YfZ65FliBwHeHdJjLUtYr5v4wAuZlvamUQLGaLNau5BFmR9FvDK08FbcUKMBTM4Ey96lBpMGApjJTE9YCuwH8Z5jPCXZT86jYP4jAjwfQ9DXfbNzEBi3ruiMhjFvPAWjz8j+WOS
2025-07-31 18:00:05 [INFO]: Processed 4 messages, reached the limit of 4.
2025-07-31 18:00:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 18:00:05 [INFO]: inside itemsold and closed 14409
2025-07-31 18:00:06 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 18:00:06 [INFO]: autolink for user_id 14409 is 1
2025-07-31 18:00:06 [INFO]: not in db for user_id 14409 and the ebayitemid306421649441
2025-07-31 18:00:06 [INFO]: inside itemsold and closed 14409
2025-07-31 18:00:08 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 18:00:08 [INFO]: autolink for user_id 14409 is 1
2025-07-31 18:00:08 [INFO]: Ebay item id :: 286187064217 exists in Database
2025-07-31 18:00:08 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 18:00:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 18:00:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 18:00:08 [INFO]: inside itemsold and closed 14409
2025-07-31 18:00:10 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 18:00:10 [INFO]: autolink for user_id 14409 is 1
2025-07-31 18:00:10 [INFO]: Ebay item id :: 324567697128 exists in Database
2025-07-31 18:00:10 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 18:00:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 18:00:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 18:00:10 [INFO]: inside itemsold and closed 14409
2025-07-31 18:00:11 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 18:00:11 [INFO]: autolink for user_id 14409 is 1
2025-07-31 18:00:11 [INFO]: Ebay item id :: 286210362598 exists in Database
2025-07-31 18:00:11 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 18:00:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 18:00:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 18:00:11 [INFO]: in processold action queue is array    for {"44594537":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44594537","ebayitemid":"286187064217","shopifyproductid":"8749086408926","variants":[{"price":"46.99","quantity":0,"weight":"2","shopifyproductid":"8749086408926","shopifyvariantid":"46112630178014","shopifyinventoryid":"48211618758878","shopifylocationid":"","product_id":"44594537","variant_id":"77487246","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44729440":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44729440","ebayitemid":"324567697128","shopifyproductid":"6646151512231","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"6646151512231","shopifyvariantid":"39695615885479","shopifyinventoryid":"41790330503335","shopifylocationid":"","product_id":"44729440","variant_id":"77637325","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44568488":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44568488","ebayitemid":"286210362598","shopifyproductid":"7938401108190","variants":[{"price":"59.99","quantity":0,"weight":"2","shopifyproductid":"7938401108190","shopifyvariantid":"43927263772894","shopifyinventoryid":"46023465894110","shopifylocationid":"","product_id":"44568488","variant_id":"77461172","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 18:00:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 18:00:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 18:00:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 18:00:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 18:00:11 [INFO]: Shopify Inventory id 48211618758878
2025-07-31 18:00:11 [INFO]: Shopify Location id 58450641063
2025-07-31 18:00:11 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 18:00:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T18:00: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-07-31 18:00:12 [INFO]: Change: available | Delta: -1
2025-07-31 18:00:12 [INFO]: Change: on_hand | Delta: -1
2025-07-31 18:00:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 18:00:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44594537 and user_id = 14409 
2025-07-31 18:00:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77487246 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 18:00:12 [INFO]: Shopify Inventory id 41790330503335
2025-07-31 18:00:12 [INFO]: Shopify Location id 58450641063
2025-07-31 18:00:12 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 18:00:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T18:00: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-07-31 18:00:12 [INFO]: Change: available | Delta: 1
2025-07-31 18:00:12 [INFO]: Change: on_hand | Delta: 1
2025-07-31 18:00:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 18:00:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44729440 and user_id = 14409 
2025-07-31 18:00:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77637325 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 18:00:12 [INFO]: Shopify Inventory id 46023465894110
2025-07-31 18:00:12 [INFO]: Shopify Location id 58450641063
2025-07-31 18:00:12 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 18:00:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T18:00: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-07-31 18:00:12 [INFO]: Change: available | Delta: -1
2025-07-31 18:00:12 [INFO]: Change: on_hand | Delta: -1
2025-07-31 18:00:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 18:00:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44568488 and user_id = 14409 
2025-07-31 18:00:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77461172 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 18:00:12 [INFO]: updateIdsQuantity -> ["77487246","77637325","77461172"]
2025-07-31 18:00:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-07-31 18:00:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77487246 THEN 0 WHEN id = 77637325 THEN 0 WHEN id = 77461172 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77487246 THEN 0 WHEN id = 77637325 THEN 0 WHEN id = 77461172 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77487246,77637325,77461172)
2025-07-31 18:00:12 [INFO]: QUANTITY Updated IDs: 77487246, 77637325, 77461172
2025-07-31 18:00:12 [INFO]: Successfully processed data for user 14409
2025-07-31 18:00:12 [INFO]: Execution Started
2025-07-31 18:00:12 [INFO]: Execution Finished
2025-07-31 18:10:01 [INFO]: Execution Started
2025-07-31 18:10:01 [INFO]: old server sucessfully connected
2025-07-31 18:10:01 [INFO]: sqs client sucess created
2025-07-31 18:10:02 [INFO]: Number of messages in the queue: 1
2025-07-31 18:10:03 [INFO]: item found in queue is if condition  14409
2025-07-31 18:10:03 [INFO]: item found in queue is  14409
2025-07-31 18:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBjFlvntl/fS00E2F7aSgOioRYsD3FgMZBuuGVXACiIlsEvOU06fMDPtaI5KnVisZtXTfCgbeJ4LwZq1viciIQB7VnujwrzNAX/NhH4tBFLyOAxr+cZ8V9HgBbh2dGSQUEF2olU3cZQCWUHmb9yNypjQiBLWsk0n6nVdPG7pan5D6GObf2rlk0K1WaTdn4GbCPe14goMdFqBW5G43lxD3g/nCspmoV/tGXokViV3GEM9P9Izl3NHBVQS7PNYDQeRAoQzQD8Cbj61u5aPLs9KJFUVHrB8ulxFFzznH/RfD/CEQoO9LhVJzto811icH27DU+JRSPyfnEthZ6J5GAfk6qNk2KBCHx9Wl4ttPFZ7tFKVGdGiJy6OBAYazpmDY74gsCPpbbvHx5YKVhvKLjTDH7pBkoU741kjpQRKeO9YIC7h5sQbEfIydVDK/ibwr/7tN2
2025-07-31 18:10:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-07-31 18:10:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 18:10:03 [INFO]: inside itemsold and closed 14409
2025-07-31 18:10:05 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 18:10:05 [INFO]: autolink for user_id 14409 is 1
2025-07-31 18:10:05 [INFO]: Ebay item id :: 305935389604 exists in Database
2025-07-31 18:10:05 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 18:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 18:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 18:10:05 [INFO]: in processold action queue is array    for {"44591830":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44591830","ebayitemid":"305935389604","shopifyproductid":"8747677286622","variants":[{"price":"69.99","quantity":0,"weight":"2","shopifyproductid":"8747677286622","shopifyvariantid":"46108512059614","shopifyinventoryid":"48207452963038","shopifylocationid":"","product_id":"44591830","variant_id":"77484539","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 18:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 18:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 18:10:05 [INFO]: Shopify Inventory id 48207452963038
2025-07-31 18:10:05 [INFO]: Shopify Location id 58450641063
2025-07-31 18:10:05 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 18:10:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T18: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-07-31 18:10:05 [INFO]: Change: available | Delta: -1
2025-07-31 18:10:05 [INFO]: Change: on_hand | Delta: -1
2025-07-31 18:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 18:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44591830 and user_id = 14409 
2025-07-31 18:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77484539 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 18:10:05 [INFO]: updateIdsQuantity -> ["77484539"]
2025-07-31 18:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-07-31 18:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77484539 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77484539 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77484539)
2025-07-31 18:10:05 [INFO]: QUANTITY Updated IDs: 77484539
2025-07-31 18:10:05 [INFO]: Successfully processed data for user 14409
2025-07-31 18:10:05 [INFO]: Execution Started
2025-07-31 18:10:05 [INFO]: Execution Finished
2025-07-31 18:20:01 [INFO]: Execution Started
2025-07-31 18:20:01 [INFO]: old server sucessfully connected
2025-07-31 18:20:01 [INFO]: sqs client sucess created
2025-07-31 18:20:03 [INFO]: Number of messages in the queue: 2
2025-07-31 18:20:03 [INFO]: item found in queue is if condition  14409
2025-07-31 18:20:03 [INFO]: item found in queue is  14409
2025-07-31 18:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBawiPrzTFBqUxgCf6B2bCyStVw+Ho3WGvrBHE2v2vsllDkBxWYjD4vWfan56ZAW7XjlUxBHhtqYT638pHSs9MwUH7I4Fr3QOh9v4SKluOTriWZKBsmh8R/QdaJxzfayB9soTfJclM7ac7o8ASBXFJM0ioYF/X9JqWui8pPj0ZBQqK+NOz8o+xfhcwQrqOx8JIVpm1BG3RxYya38JivOmtq67iqEbJssRZF6M/s/EGtQbX4aQG/4DOoO0iizbIfd2TYXwwHh9VGYkjnb/zdsNf3ot+8lR4AGC/QkzUR0sEq0WMgkqW89fhc3oajbpY7De7c/7WuFyKT7ogtMah8omawCfwypa6Vwu5iRn9U5iSrqis1jJaeEC5fNZsMNuxbRWdFOBKD+bH0l/bLeq1v1igzzQ5r/hk6NdJO7jim0vUsvTRIrjGcogjCOGc8ckrx0s3
2025-07-31 18:20:03 [INFO]: item found in queue is if condition  14409
2025-07-31 18:20:03 [INFO]: item found in queue is  14409
2025-07-31 18:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBQ2hgmqM/qkDoNRrtBZ0SKmUvDjr9lX6Y3ncNICQi+4JSz6n0dO021bP7oTjOs3KuTbZeb9omrW2Jwhl5ECDsRy8ScCl6O88wrMmCHAquD1ZrH0bwnKWCEDajlAEMvPxkbONS2/KOcNnTvtw2GVMMjJA77P+MSU46PZvEvU6zjfkOVAMmDVVUwBAssMOil5Fnp3LvkkoVNBe9kP4JatIc3+J1L7EcqOvBueTdEvD/UaXlpQJ5xoymCfM6091g2au515eW0p/K98NWfpv2UGqzm2/aZ8gMGDtSVwUtbaoxZTpH1q5PwW3Kd3LLwcTHRESq2ynvcJ7dt6QJAyZxWhhZVC32LENvtKQvwwaVlKsvWEdpTX8LdwCHH6TC7muAxKJfMWBsh9xqVevkSyKXhlSiV6mQo58+hSmswr9ijsLiZRiDRwZfVhhGBrvwx8WHBBtJ
2025-07-31 18:20:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-07-31 18:20:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 18:20:04 [INFO]: inside itemsold and closed 14409
2025-07-31 18:20:05 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 18:20:05 [INFO]: autolink for user_id 14409 is 1
2025-07-31 18:20:05 [INFO]: Ebay item id :: 286164688752 exists in Database
2025-07-31 18:20:05 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 18:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 18:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 18:20:05 [INFO]: inside itemsold and closed 14409
2025-07-31 18:20:07 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 18:20:07 [INFO]: autolink for user_id 14409 is 1
2025-07-31 18:20:07 [INFO]: Ebay item id :: 305884619299 exists in Database
2025-07-31 18:20:07 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 18:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 18:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 18:20:07 [INFO]: in processold action queue is array    for {"44573776":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44573776","ebayitemid":"286164688752","shopifyproductid":"8736601112798","variants":[{"price":"59.99","quantity":0,"weight":"2","shopifyproductid":"8736601112798","shopifyvariantid":"46055600292062","shopifyinventoryid":"48154329743582","shopifylocationid":"","product_id":"44573776","variant_id":"77466483","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44556896":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44556896","ebayitemid":"305884619299","shopifyproductid":"8724599341278","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"8724599341278","shopifyvariantid":"46008499175646","shopifyinventoryid":"48106937450718","shopifylocationid":"","product_id":"44556896","variant_id":"77449576","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 18:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 18:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 18:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 18:20:07 [INFO]: Shopify Inventory id 48154329743582
2025-07-31 18:20:07 [INFO]: Shopify Location id 58450641063
2025-07-31 18:20:07 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 18:20:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T18:20: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 18:20:08 [INFO]: Change: available | Delta: -1
2025-07-31 18:20:08 [INFO]: Change: on_hand | Delta: -1
2025-07-31 18:20:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 18:20:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44573776 and user_id = 14409 
2025-07-31 18:20:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77466483 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 18:20:08 [INFO]: Shopify Inventory id 48106937450718
2025-07-31 18:20:08 [INFO]: Shopify Location id 58450641063
2025-07-31 18:20:08 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 18:20:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T18:20:08Z","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 18:20:08 [INFO]: Change: available | Delta: -1
2025-07-31 18:20:08 [INFO]: Change: on_hand | Delta: -1
2025-07-31 18:20:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 18:20:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44556896 and user_id = 14409 
2025-07-31 18:20:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77449576 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 18:20:08 [INFO]: updateIdsQuantity -> ["77466483","77449576"]
2025-07-31 18:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-07-31 18:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77466483 THEN 0 WHEN id = 77449576 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77466483 THEN 0 WHEN id = 77449576 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77466483,77449576)
2025-07-31 18:20:08 [INFO]: QUANTITY Updated IDs: 77466483, 77449576
2025-07-31 18:20:08 [INFO]: Successfully processed data for user 14409
2025-07-31 18:20:08 [INFO]: Execution Started
2025-07-31 18:20:08 [INFO]: Execution Finished
2025-07-31 18:30:02 [INFO]: Execution Started
2025-07-31 18:30:02 [INFO]: old server sucessfully connected
2025-07-31 18:30:02 [INFO]: sqs client sucess created
2025-07-31 18:30:03 [INFO]: Number of messages in the queue: 4
2025-07-31 18:30:03 [INFO]: item found in queue is if condition  14409
2025-07-31 18:30:03 [INFO]: item found in queue is  14409
2025-07-31 18:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBQlcBZnl5yM8bDUVQThmAuVXMVlFEXhKon/0dVU9k7B0+63BPNwZsZkAXV1MYJ15tflKnkAnavXaHuKd5etzBMZMhDXMx/dWL137qUOn6v149RH14Z4KCtQ4WhPDft85+qun5S+UNO6zG0hYMHkrtox7VE4Med2ieutjD8fdX2rNBylxCciTju+s1U1UHODMwJXezFJzbntfJb/XbRmU4wfyHH8pH7zF9vkcBbm04AqfAT4GKkfEaUiDABFnfPTPZiZ0vHlviERDVxKYyNQIatfYGRYbK9rVNMbCOmvxZoDpLJ6VDCUlhGTzYGEM9tySDcOyFLzAyH5fheZN8a4PXdSM/zVJ959iWYoX/zoxuGiBDxYDJ+miHBEYJZXexcNSwyqpYm24sjGv2nHy1i009Zl9YWQapMnMLEYfomC0jvxOxsxi/NDjnLfrrSVA47uAj
2025-07-31 18:30:04 [INFO]: item found in queue is if condition  14409
2025-07-31 18:30:04 [INFO]: item found in queue is  14409
2025-07-31 18:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBpq6TU7UYbUdHzkoRWNAHzwPrGGJZWqS+Q1NwU0o0j3CCf+M/+YFoOkToiseSMCa6UaiQlXAzEtCSt3orfm8xv5qeMTsnQE+AbtAup9mSmAAwKfDbSq/Bk/hQbFBaNG83DUHoH0SFoAAl6lwKk6WQMMtkowELpIf/mPzCj/k359gHgP+qZzc7RF1/ht0MPuLpRifwBg7sjKVAmGTZ2yjRAeQkgeTShoYIhq2RxvNUzwlNBxQffiKFZ5qRPagsDh5xnhuhFI6xpxZP8YYK0CmCn7Z52FFxHvU5bsx4zbocXK7qdXbIX00xgSOy+24gZbTFkdmoV2fTNvr8aE3LEe5CmsRDVFP/LJWdKf9NbXJtMl3OoLAXi9Fbmg3/Du973rfqy6JycI+4Mb6V0kZOVoMBDua20CKXfnABZJfIvr8rfxptPLJZcSOWIWAz+MinQKBI
2025-07-31 18:30:04 [INFO]: item found in queue is if condition  14409
2025-07-31 18:30:04 [INFO]: item found in queue is  14409
2025-07-31 18:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBg8ocpur7dtB9QDPvaw30wwc9VE6x7Z260RKPsXqELPPfU3C5Z69B5CbUiumUkCPa9UCd8Ixp4rjnvporvSqo3eSMMNaG0qasKlUfFIJwUG6zj2DX7jNhzVLQxn8V7xcUAjMneZb75DlYhQCKiuGwbFMalqLrhwXJwaYM28FmAdMv/8rJ/ze2+w6W/qOmdUqwWF3vk1ROqQgolqsU1J+p0akoGVUxHsRX6B1WgIogbTfHTlgfHGBG/+YzZiyyiaQOViiKwbt4rCrIMlzDNz5uWevopj+lqLrILS6KmHOkmpnw5ESlSIREIsHcBOP+4jTl3vDNAr4i6oSiQ1OCp7UO/A3KxRZnBmS3uzP3RFGeSPqO1Ymtb3d4sG6mkqxzEn3HK7Z61yOGpyw+KlKu7w4NHolu7J9s04nUFBOEPIflZUjstxKwcH8aN7N/AS2yfVBk
2025-07-31 18:30:05 [INFO]: item found in queue is if condition  14409
2025-07-31 18:30:05 [INFO]: item found in queue is  14409
2025-07-31 18:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBFGCTBvtTcU4Lm24p/BGgW0R+WAJ3ceVnm9hfG/mq9vBVL5hXVJKIZyp3U2oOQFZZgBq3zXMrEBFn3hqGjLwjyAqbdsVn60gn0+EAqrYTopNyIa2BzvtCU/A4pStkvad+EQIZnQgo2O1bURUP2vc/jUVdGW5WYjvELZmjvvScXE8WQtu85Fao1j1cCPLYnBGf9NGbYHNZ2W5nCUH9xyvzvNirULKMksjWUfP2owJ30uDxTuzlFIDyVZy12DhJaI9R73aMW8h88186fsWAimuiXGffQymnPOcNcoe0jIBMyrXaL/uoSA37XcHEK3/bXc9V5hfOde+hTVb8ui87r2Ymp6QtmJJJ/xIUEgaTOfENawMLA+ZZJNSaqqHSVk00qJDO65E6+fiv6TUWO9OGcxoKhZUScTIJTvsjNtjPr5OnSAff8lUQJyVcxuxmQ+pIMv8H
2025-07-31 18:30:05 [INFO]: Processed 4 messages, reached the limit of 4.
2025-07-31 18:30:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 18:30:05 [INFO]: inside itemsold and closed 14409
2025-07-31 18:30:07 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 18:30:07 [INFO]: autolink for user_id 14409 is 1
2025-07-31 18:30:07 [INFO]: Ebay item id :: 305840327377 exists in Database
2025-07-31 18:30:07 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 18:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 18:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 18:30:07 [INFO]: inside itemsold and closed 14409
2025-07-31 18:30:09 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 18:30:09 [INFO]: autolink for user_id 14409 is 1
2025-07-31 18:30:09 [INFO]: Ebay item id :: 326388176664 exists in Database
2025-07-31 18:30:09 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 18:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 18:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 18:30:09 [INFO]: inside itemsold and closed 14409
2025-07-31 18:30:10 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 18:30:10 [INFO]: autolink for user_id 14409 is 1
2025-07-31 18:30:10 [INFO]: Ebay item id :: 305858634669 exists in Database
2025-07-31 18:30:10 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 18:30:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 18:30:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 18:30:10 [INFO]: inside itemsold and closed 14409
2025-07-31 18:30:12 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 18:30:12 [INFO]: autolink for user_id 14409 is 1
2025-07-31 18:30:12 [INFO]: Ebay item id :: 286639741716 exists in Database
2025-07-31 18:30:12 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 18:30:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 18:30:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 18:30:12 [INFO]: in processold action queue is array    for {"44573819":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44573819","ebayitemid":"305840327377","shopifyproductid":"8706634645726","variants":[{"price":"55.99","quantity":0,"weight":"2","shopifyproductid":"8706634645726","shopifyvariantid":"45962869145822","shopifyinventoryid":"48061558718686","shopifylocationid":"","product_id":"44573819","variant_id":"77466526","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44687354":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44687354","ebayitemid":"326388176664","shopifyproductid":"8923177025758","variants":[{"price":"14.99","quantity":0,"weight":"0.5","shopifyproductid":"8923177025758","shopifyvariantid":"46827987501278","shopifyinventoryid":"48926449533150","shopifylocationid":"58450641063","product_id":"44687354","variant_id":"77592579","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44588994":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44588994","ebayitemid":"305858634669","shopifyproductid":"8714379362526","variants":[{"price":"139.99","quantity":0,"weight":"2","shopifyproductid":"8714379362526","shopifyvariantid":"45980641853662","shopifyinventoryid":"48079414231262","shopifylocationid":"","product_id":"44588994","variant_id":"77481703","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44562256":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44562256","ebayitemid":"286639741716","shopifyproductid":"8286078009566","variants":[{"price":"31.99","quantity":0,"weight":"2","shopifyproductid":"8286078009566","shopifyvariantid":"44806739787998","shopifyinventoryid":"46904767217886","shopifylocationid":"","product_id":"44562256","variant_id":"77454936","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 18:30:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 18:30:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 18:30:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 18:30:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 18:30:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 18:30:12 [INFO]: Shopify Inventory id 48061558718686
2025-07-31 18:30:12 [INFO]: Shopify Location id 58450641063
2025-07-31 18:30:12 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 18:30:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T18: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-07-31 18:30:12 [INFO]: Change: available | Delta: -1
2025-07-31 18:30:12 [INFO]: Change: on_hand | Delta: -1
2025-07-31 18:30:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 18:30:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44573819 and user_id = 14409 
2025-07-31 18:30:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77466526 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 18:30:12 [INFO]: Shopify Inventory id 48926449533150
2025-07-31 18:30:12 [INFO]: Shopify Location id 58450641063
2025-07-31 18:30:12 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 18:30:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T18: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-07-31 18:30:12 [INFO]: Change: available | Delta: -1
2025-07-31 18:30:12 [INFO]: Change: on_hand | Delta: -1
2025-07-31 18:30:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 18:30:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44687354 and user_id = 14409 
2025-07-31 18:30:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77592579 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 18:30:12 [INFO]: Shopify Inventory id 48079414231262
2025-07-31 18:30:12 [INFO]: Shopify Location id 58450641063
2025-07-31 18:30:12 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 18:30:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T18:30:13Z","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 18:30:13 [INFO]: Change: available | Delta: -1
2025-07-31 18:30:13 [INFO]: Change: on_hand | Delta: -1
2025-07-31 18:30:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 18:30:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44588994 and user_id = 14409 
2025-07-31 18:30:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77481703 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 18:30:13 [INFO]: Shopify Inventory id 46904767217886
2025-07-31 18:30:13 [INFO]: Shopify Location id 58450641063
2025-07-31 18:30:13 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 18:30:13 [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-07-31 18:30:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 18:30:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44562256 and user_id = 14409 
2025-07-31 18:30:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77454936 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 18:30:13 [INFO]: updateIdsQuantity -> ["77466526","77592579","77481703","77454936"]
2025-07-31 18:30:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4
2025-07-31 18:30:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77466526 THEN 0 WHEN id = 77592579 THEN 0 WHEN id = 77481703 THEN 0 WHEN id = 77454936 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77466526 THEN 0 WHEN id = 77592579 THEN 0 WHEN id = 77481703 THEN 0 WHEN id = 77454936 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77466526,77592579,77481703,77454936)
2025-07-31 18:30:13 [INFO]: QUANTITY Updated IDs: 77466526, 77592579, 77481703, 77454936
2025-07-31 18:30:13 [INFO]: Successfully processed data for user 14409
2025-07-31 18:30:13 [INFO]: Execution Started
2025-07-31 18:30:13 [INFO]: Execution Finished
2025-07-31 18:40:01 [INFO]: Execution Started
2025-07-31 18:40:01 [INFO]: old server sucessfully connected
2025-07-31 18:40:01 [INFO]: sqs client sucess created
2025-07-31 18:40:03 [INFO]: Number of messages in the queue: 0
2025-07-31 18:40:12 [INFO]: item found in queue is if condition  14409
2025-07-31 18:40:12 [INFO]: item found in queue is  14409
2025-07-31 18:40:12 [INFO]: Message deleted from the queue for receipt handle: AQEBPNCwj+6adafnykn1pOGSGWi6aJWUT7MqAPzG1AqCoTRoYGzUcYh4AFZikog0IvVKWA/8QL5ofS7lsJ5jXAS5xn8dNU2TmqRhLY+dXtaWMtCCk5xWhRMk8tgZS93sVyT90EFjGc3VBoDAvKH8eX9ylfOBtnEaSctK9tIbKHJ4h/zbBXP2EeWilffUR4jtbjECd2xPuyhKmpKd+5ZXjwovSLQmmyBW311CV4PKNVJDYdZcevT3mt8QdKQsldcb0t01IZndsMUH6d1PbDN+ZcG3qdZERabyGOHtkqBZT8G69KyheG2NwvfMoGL/k7izYdYJDM+J9dOhWn8I+1vxOlrVtHoeSWWALbbHZD7DVrnBkILge1zbuhbY+4ox76BgCDG1UAka0QBankTnGHbTWLNFRRf8Kkmz+53Kx4RriSo3EMs8h4B5Ii5+Iuz+GUBnNp5d
2025-07-31 18:40:12 [INFO]: Processed 1 messages, reached the limit of 0.
2025-07-31 18:40:12 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 18:40:12 [INFO]: inside itemsold and closed 14409
2025-07-31 18:40:14 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 18:40:14 [INFO]: autolink for user_id 14409 is 1
2025-07-31 18:40:14 [INFO]: Ebay item id :: 326249604477 exists in Database
2025-07-31 18:40:14 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 18:40:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 18:40:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 18:40:14 [INFO]: in processold action queue is array    for {"44684025":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44684025","ebayitemid":"326249604477","shopifyproductid":"8697517113566","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"8697517113566","shopifyvariantid":"45939333693662","shopifyinventoryid":"48037793399006","shopifylocationid":"","product_id":"44684025","variant_id":"77589249","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 18:40:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 18:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 18:40:14 [INFO]: Shopify Inventory id 48037793399006
2025-07-31 18:40:14 [INFO]: Shopify Location id 58450641063
2025-07-31 18:40:14 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 18:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T18: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 18:40:14 [INFO]: Change: available | Delta: -1
2025-07-31 18:40:14 [INFO]: Change: on_hand | Delta: -1
2025-07-31 18:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 18:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44684025 and user_id = 14409 
2025-07-31 18:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77589249 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 18:40:14 [INFO]: updateIdsQuantity -> ["77589249"]
2025-07-31 18:40:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-07-31 18:40:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77589249 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77589249 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77589249)
2025-07-31 18:40:14 [INFO]: QUANTITY Updated IDs: 77589249
2025-07-31 18:40:14 [INFO]: Successfully processed data for user 14409
2025-07-31 18:40:14 [INFO]: Execution Started
2025-07-31 18:40:14 [INFO]: Execution Finished
2025-07-31 18:50:01 [INFO]: Execution Started
2025-07-31 18:50:01 [INFO]: old server sucessfully connected
2025-07-31 18:50:01 [INFO]: sqs client sucess created
2025-07-31 18:50:02 [INFO]: Number of messages in the queue: 0
2025-07-31 18:50:22 [INFO]: Execution Started
2025-07-31 18:50:22 [INFO]: Execution Finished