2025-08-05 13:00:02 [INFO]: Execution Started 2025-08-05 13:00:02 [INFO]: old server sucessfully connected 2025-08-05 13:00:02 [INFO]: sqs client sucess created 2025-08-05 13:00:08 [INFO]: Number of messages in the queue: 4 2025-08-05 13:00:10 [INFO]: item found in queue is if condition 14409 2025-08-05 13:00:10 [INFO]: item found in queue is 14409 2025-08-05 13:00:10 [INFO]: Message deleted from the queue for receipt handle: AQEBs/c+jDpS9BBNm8bJ35LafZZC1Es2s+hvkAvU4VT89/V2B3l8fbKcV8f+0aKP2m0BjNgQMAyw6cWaAl2hMvAxkl71Z+4GeawgT0MllHbfZimIFKreBJHycH6UscLyxq/aedISWGnDg4D6me8qv7IpSb7m+xxklPLVssIgKQsbVZ54U+2+oihaWi1FuETTc6bpHS+99WsIJJJ7rXhf2+ObN8vR6/1RHWTmZXdz0Hd9KEGrYEe0tcN8tfUM+Rp+SHmdIQiSAgHqZKgXswd77dRXyyBWCpXI/r0D6ede7HPKY23Zv/sPy6NwXZl2u5v5iHDKC6n5LXOt/uzSXk0e+wFlaz9mMnhq3bE5mhob8rBv7Gc8/8/i1YXBxgmNcTKF4fAyTckkFWFnZgSMDH83bvn+D2keaJgxheVK9crUpG6TH8gMKBWKprN2WKwCm2nctx6c 2025-08-05 13:00:12 [INFO]: item found in queue is if condition 14409 2025-08-05 13:00:12 [INFO]: item found in queue is 14409 2025-08-05 13:00:12 [INFO]: Message deleted from the queue for receipt handle: AQEBnbySV0iH9wpE3aovUUfKOqeZsgsKnsbWwYBjM9qtkdQYapWLQ6PYi7HY8bnlquG+s1v1isWjuMwC0CiYYUvy12h8zwWlrCqMEfkpGexlHO5FNLJfewlidPp7cMsdwM8rjfSANOxXHbLw2Y+W/ZY4HroTUMMcBxntZtXIab2sr67wgR3qLI1WMk8EKix2baeRJ1AdvvGJFYS+rcxC2pWNsUT1vis45EhdSKEE5lFPVIUXVt5sjBASoazBBqrzmRPyhA3IdaI65u1L5ynxNJctQn3if9UgeiCvMR97NU/Z5gpG+jbOPOXzChhOuSOWqXn5tBCW7jS2jezrpWcfSRpc3zUA0euo8s+7Fo6Pjyk5l2maJeKydLZnuqmCrpAJqdoxdFcJdmXDyOTiEyjNhb+EmLGi6Fn3xrHmpZjG8nEYVbcyYk71KQ+AwOqNJ8W2PfnZ 2025-08-05 13:00:12 [INFO]: item found in queue is if condition 14409 2025-08-05 13:00:12 [INFO]: item found in queue is 14409 2025-08-05 13:00:13 [INFO]: Message deleted from the queue for receipt handle: AQEBntNMbIqO198A0A6ZyG52Esmx4KXKbfk+zlOF5vEgyX9Sg3Fdw42f11rn48sIK9dZ1+s/kOZ9dhGBlUT483nUrdhKyvs/9cAWrTuKwyY3/NLViwA8BPetkYdR5waJcs/WZCTzd82RWTc+GUSYhKrD3e4gFp3TfaMPFx+9ddKDNRSRsY1+DAjnjDeMLS5t0C7DiGL8ELUhFiWX8jJqW4A47q887K4MFNZ237GfBvn8Hex4kzAvZoTCnifSayrLfB5h3K4GT5Xv9He5VwfPI8b4P1BMzfPFjzoenzs6PyR83HlqJAQ2LdB1+Kp2jXV1eF+GpHp48OhZFTDpqkhEEQOYd/pLi5PQsBNJqgNKh7AtUWm0vA5lhsRSuHIqehbgdPR7goNFwU8skJfq6PxUNKwVJM4ZfNJ7u6p1XYHjSHNPoJbZ3zsA0WlAcBOr8+NLCSQz 2025-08-05 13:00:13 [INFO]: item found in queue is if condition 14409 2025-08-05 13:00:13 [INFO]: item found in queue is 14409 2025-08-05 13:00:14 [INFO]: Message deleted from the queue for receipt handle: AQEBcBKGLOFRKZVV04sdgj2iI5c/wSGcmQDatZRvTT2W9R0zPUxKTsDHOVApTjuF7iT75UjFFfcb1CRHFvif92Z3SC2BDMCsgA5U92o/rIVO+2rZDhKqDAg/erUjA4aDnBgW3Aqez27nOT4DflKVMR6cGWg4sllqq4hsQJZ4eL9P23oMGGauXZx2WJuQZrRBirisubJg98TwqlzramQfOYlo/aDRRlcL4CFsHm3nDXKZFzmgSi/7L9sSQeV9rzwdAUjY9gXeHGbksRyNLxhLcRCSMTZBaPpPqyFqrtthmr6Xr8LbRtw0BsO3LjHwNfty6UChF4hjXxwo0ZZhtREv8N+vE6OLzo7BB880MKmH+0HcGjyoHMPK44l7TnOzc3/n6uM6buyPdmTzJmSxbQSJpm+5xZc3Y0yNbc6cAEmISHyhyeCC+AigVDTbuxoN3xjrbtxt 2025-08-05 13:00:14 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-05 13:00:14 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 13:00:14 [INFO]: inside itemsold and closed 14409 2025-08-05 13:00:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 13:00:15 [INFO]: autolink for user_id 14409 is 1 2025-08-05 13:00:15 [INFO]: Ebay item id :: 305955977674 exists in Database 2025-08-05 13:00:15 [INFO]: Item is reliested :: exists in Database 2025-08-05 13:00:15 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-05 13:00:15 [INFO]: inside itemsold and closed 14409 2025-08-05 13:00:17 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 13:00:17 [INFO]: autolink for user_id 14409 is 1 2025-08-05 13:00:17 [INFO]: Ebay item id :: 225605515056 exists in Database 2025-08-05 13:00:17 [INFO]: Item is reliested :: exists in Database 2025-08-05 13:00:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 13:00:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 13:00:17 [INFO]: inside itemsold and closed 14409 2025-08-05 13:00:19 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 13:00:19 [INFO]: autolink for user_id 14409 is 1 2025-08-05 13:00:19 [INFO]: Ebay item id :: 286201149705 exists in Database 2025-08-05 13:00:19 [INFO]: Item is reliested :: exists in Database 2025-08-05 13:00:19 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 13:00:19 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 13:00:19 [INFO]: inside itemsold and closed 14409 2025-08-05 13:00:20 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 13:00:20 [INFO]: autolink for user_id 14409 is 1 2025-08-05 13:00:20 [INFO]: Ebay item id :: 335713273448 exists in Database 2025-08-05 13:00:20 [INFO]: Item is reliested :: exists in Database 2025-08-05 13:00:20 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 13:00:20 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 13:00:20 [INFO]: in processold action queue is array for {"45141531":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45141531","ebayitemid":"305955977674","deleted":1}},"44733118":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44733118","ebayitemid":"225605515056","shopifyproductid":"8058733789406","variants":[{"price":"10.99","quantity":0,"weight":"2","shopifyproductid":"8058733789406","shopifyvariantid":"44220181807326","shopifyinventoryid":"46317282820318","shopifylocationid":"","product_id":"44733118","variant_id":"77641003","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44559506":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44559506","ebayitemid":"286201149705","shopifyproductid":"7694391050462","variants":[{"price":"16.99","quantity":0,"weight":"2","shopifyproductid":"7694391050462","shopifyvariantid":"42971751743710","shopifyinventoryid":"45066927243486","shopifylocationid":"","product_id":"44559506","variant_id":"77452186","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44559507":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44559507","ebayitemid":"335713273448","shopifyproductid":"7699562266846","variants":[{"price":"16.99","quantity":0,"weight":"2","shopifyproductid":"7699562266846","shopifyvariantid":"42995954417886","shopifyinventoryid":"45091152756958","shopifylocationid":"","product_id":"44559507","variant_id":"77452187","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 13:00:20 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 13:00:20 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 13:00:20 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 13:00:20 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 13:00:20 [INFO]: productIds WHich are having null productid -> [45141531] 2025-08-05 13:00:20 [INFO]: ebayItemIds WHich are not imported-> ["305955977674"] 2025-08-05 13:00:20 [INFO]: Entered in bulkUpdateProducts function 2025-08-05 13:00:20 [INFO]: Transaction started for bulkUpdateProducts 2025-08-05 13:00:20 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45141531) 2025-08-05 13:00:20 [INFO]: Query executed successfully. Affected rows: 0 2025-08-05 13:00:20 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-05 13:00:20 [INFO]: Transaction committed successfully. 2025-08-05 13:00:20 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-05 13:00:20 [INFO]: Shopify Inventory id 46317282820318 2025-08-05 13:00:20 [INFO]: Shopify Location id 58450641063 2025-08-05 13:00:20 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 13:00:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T13:00:21Z","reason":"correction","changes":[{"name":"available","delta":-4},{"name":"on_hand","delta":-4}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 13:00:21 [INFO]: Change: available | Delta: -4 2025-08-05 13:00:21 [INFO]: Change: on_hand | Delta: -4 2025-08-05 13:00:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 13:00:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44733118 and user_id = 14409 2025-08-05 13:00:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77641003 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 13:00:21 [INFO]: Shopify Inventory id 45066927243486 2025-08-05 13:00:21 [INFO]: Shopify Location id 58450641063 2025-08-05 13:00:21 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 13:00:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T13:00:21Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 13:00:21 [INFO]: Change: available | Delta: -1 2025-08-05 13:00:21 [INFO]: Change: on_hand | Delta: -1 2025-08-05 13:00:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 13:00:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44559506 and user_id = 14409 2025-08-05 13:00:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77452186 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 13:00:21 [INFO]: Shopify Inventory id 45091152756958 2025-08-05 13:00:21 [INFO]: Shopify Location id 58450641063 2025-08-05 13:00:21 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 13:00:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T13:00:21Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 13:00:21 [INFO]: Change: available | Delta: -1 2025-08-05 13:00:21 [INFO]: Change: on_hand | Delta: -1 2025-08-05 13:00:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 13:00:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44559507 and user_id = 14409 2025-08-05 13:00:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77452187 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 13:00:21 [INFO]: updateIdsQuantity -> ["77641003","77452186","77452187"] 2025-08-05 13:00:21 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-05 13:00:21 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77641003 THEN 0 WHEN id = 77452186 THEN 0 WHEN id = 77452187 THEN 0 END, quantityflag = CASE WHEN id = 77641003 THEN 0 WHEN id = 77452186 THEN 0 WHEN id = 77452187 THEN 0 END WHERE user_id = 14409 AND id IN (77641003,77452186,77452187) 2025-08-05 13:00:21 [INFO]: QUANTITY Updated IDs: 77641003, 77452186, 77452187 2025-08-05 13:00:21 [INFO]: Successfully processed data for user 14409 2025-08-05 13:00:21 [INFO]: Execution Started 2025-08-05 13:00:21 [INFO]: Execution Finished 2025-08-05 13:10:01 [INFO]: Execution Started 2025-08-05 13:10:01 [INFO]: old server sucessfully connected 2025-08-05 13:10:01 [INFO]: sqs client sucess created 2025-08-05 13:10:02 [INFO]: Number of messages in the queue: 1 2025-08-05 13:10:03 [INFO]: item found in queue is if condition 14409 2025-08-05 13:10:03 [INFO]: item found in queue is 14409 2025-08-05 13:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBufxftDH8Qy+K79RVtAs2Ep6EiECvJvGd8MJP9bhsExfRdfj/fut56I5MjmK0QCxRci/XzyVT+yumSumw8I1xK+/Uj/LZoifYlecXKxFyh5E+cmU7xT2OhBELtAGu9uzTh6FA6wTXHrodcaIDwMIiZDftAOUw4vl1bgUduV5l8QtfBO8tX6G7ggN+Mk3dwXPlHeUpOGFZoSzQiNWoeogh9Nd+u5ZTectclD8xNL6LPL4EFKPTs/0ccxABl4abFaiBsNIt8tn+aEqBfXnpa8yOu6gAG7i5zTnMlD3Mr0h8gcLwZszo3ow+U2Cy3LfdKtDF2am8Amo49MX/1PXioAKm9PGyQOLLhx/G5Ljk4kTQrAft/2t499M6s6mtSzG34j1lG+6Ez9H/nTP9CDMACrrW1GeY3rdX07WkcQ0eJwdbmwqXdXOXgkhwdNvqqV8cmkif 2025-08-05 13:10:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-05 13:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 13:10:03 [INFO]: inside itemsold and closed 14409 2025-08-05 13:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 13:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-05 13:10:05 [INFO]: Ebay item id :: 304637230113 exists in Database 2025-08-05 13:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-05 13:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 13:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 13:10:05 [INFO]: in processold action queue is array for {"44586694":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44586694","ebayitemid":"304637230113","shopifyproductid":"7804629876958","variants":[{"price":"15.99","quantity":0,"weight":"2","shopifyproductid":"7804629876958","shopifyvariantid":"43419052638430","shopifyinventoryid":"45514438901982","shopifylocationid":"","product_id":"44586694","variant_id":"77479403","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 13:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 13:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 13:10:05 [INFO]: Shopify Inventory id 45514438901982 2025-08-05 13:10:05 [INFO]: Shopify Location id 58450641063 2025-08-05 13:10:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 13:10:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T13:10:05Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 13:10:05 [INFO]: Change: available | Delta: -2 2025-08-05 13:10:05 [INFO]: Change: on_hand | Delta: -2 2025-08-05 13:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 13:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44586694 and user_id = 14409 2025-08-05 13:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77479403 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 13:10:05 [INFO]: updateIdsQuantity -> ["77479403"] 2025-08-05 13:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-05 13:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77479403 THEN 0 END, quantityflag = CASE WHEN id = 77479403 THEN 0 END WHERE user_id = 14409 AND id IN (77479403) 2025-08-05 13:10:05 [INFO]: QUANTITY Updated IDs: 77479403 2025-08-05 13:10:05 [INFO]: Successfully processed data for user 14409 2025-08-05 13:10:05 [INFO]: Execution Started 2025-08-05 13:10:05 [INFO]: Execution Finished 2025-08-05 13:20:01 [INFO]: Execution Started 2025-08-05 13:20:01 [INFO]: old server sucessfully connected 2025-08-05 13:20:01 [INFO]: sqs client sucess created 2025-08-05 13:20:12 [INFO]: Number of messages in the queue: 1 2025-08-05 13:20:12 [INFO]: item found in queue is if condition 14409 2025-08-05 13:20:12 [INFO]: item found in queue is 14409 2025-08-05 13:20:13 [INFO]: Message deleted from the queue for receipt handle: AQEBs6F2O6DFSMlLxywAoaj64+22D0Kpf0Rj2tL3DPJWNxVGV3mPhV4k1QgMl8BK3LmCyByvrqWkDoU9J2Ad3MwgeDN7D6dHVZF88VHZUCvnRA2vin40rUxraibK47eZlufRjzJg6X7ReOv4OKIxkKcIaOzTVEuPyCmV+FDrqa1BCE80SYdLIncRbIQ3iNSm7RfCviZI3E3lrx1HTLj3awqGrPTVHAnff2x1aWzcbUCfQAURUL8XfidyI/3LoCb33M3xbIMwxP8iAhI/K2n/ppk9vubxGvkJp5QvXcpfBtt1Rb8MUpr5A1ImaB1VUZdj26YoUq110Qxyru9SJlzsR/APWQXEPbz2zvcWN8wpACFecm/4doZgh8qCbJjV2FPypWWs60MqeLGbKGDL5jdHz1s8CZ00XSJTAMnfbxQ1pHGzNefQOuBxRQioIneS+GmevWxl 2025-08-05 13:20:13 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-05 13:20:13 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 13:20:13 [INFO]: inside itemsold and closed 14409 2025-08-05 13:20:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 13:20:14 [INFO]: autolink for user_id 14409 is 1 2025-08-05 13:20:14 [INFO]: Ebay item id :: 285026077794 exists in Database 2025-08-05 13:20:14 [INFO]: Item is reliested :: exists in Database 2025-08-05 13:20:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 13:20:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 13:20:14 [INFO]: in processold action queue is array for {"44556407":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44556407","ebayitemid":"285026077794","shopifyproductid":"7497286582494","variants":[{"price":"21.59","quantity":0,"weight":"2","shopifyproductid":"7497286582494","shopifyvariantid":"42252361859294","shopifyinventoryid":"44346436944094","shopifylocationid":"","product_id":"44556407","variant_id":"77449087","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 13:20:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 13:20:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 13:20:14 [INFO]: Shopify Inventory id 44346436944094 2025-08-05 13:20:14 [INFO]: Shopify Location id 58450641063 2025-08-05 13:20:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 13:20:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T13:20: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-08-05 13:20:15 [INFO]: Change: available | Delta: -1 2025-08-05 13:20:15 [INFO]: Change: on_hand | Delta: -1 2025-08-05 13:20:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 13:20:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44556407 and user_id = 14409 2025-08-05 13:20:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77449087 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 13:20:15 [INFO]: updateIdsQuantity -> ["77449087"] 2025-08-05 13:20:15 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-05 13:20:15 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77449087 THEN 0 END, quantityflag = CASE WHEN id = 77449087 THEN 0 END WHERE user_id = 14409 AND id IN (77449087) 2025-08-05 13:20:15 [INFO]: QUANTITY Updated IDs: 77449087 2025-08-05 13:20:15 [INFO]: Successfully processed data for user 14409 2025-08-05 13:20:15 [INFO]: Execution Started 2025-08-05 13:20:15 [INFO]: Execution Finished 2025-08-05 13:30:01 [INFO]: Execution Started 2025-08-05 13:30:01 [INFO]: old server sucessfully connected 2025-08-05 13:30:01 [INFO]: sqs client sucess created 2025-08-05 13:30:06 [INFO]: Number of messages in the queue: 1 2025-08-05 13:30:07 [INFO]: item found in queue is if condition 14409 2025-08-05 13:30:07 [INFO]: item found in queue is 14409 2025-08-05 13:30:07 [INFO]: Message deleted from the queue for receipt handle: AQEBdSXTmADeBZurT2EJzDqSvGXJmu6So21Nnl/k8dYo1VBiC1FeCgIScAb/SDUkMMYOp2jilcP79Me0+Ny0rbyIxb/ybYGXvJdvSTLGulNYy3FueQsH4OpHlQq1tSCiHhynrhxDLqU/+6y3PF0P7rxNfAiigDPM4ZgE4CtKfveD/vpoIvW8JORstilKT0kbWUaHB9iGC5x54UEgX1ZvG6bG+6D+hXwJ7e1YuD843E44CKizAHuaY579WmPdzBFEQHY08kKOf73lD9qQTS/GKVRSLNHDRYL8LTcLR6oABGay07R6N7JVL3qiNb8xyzxHnlyHFIk998KNRIvFWtOVmPO9q6wF0wig4TIl6f3sba/mXNTt0VarM/xdhPrBQ5KacPLcdv8PCWX56wKY+Wa+feC9IHnyGHHgo2nN/IKthEvrnCyC4hd6mDzxLpTisfyFmSUs 2025-08-05 13:30:07 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-05 13:30:07 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 13:30:07 [INFO]: inside itemsold and closed 14409 2025-08-05 13:30:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 13:30:09 [INFO]: autolink for user_id 14409 is 1 2025-08-05 13:30:09 [INFO]: Ebay item id :: 334849646902 exists in Database 2025-08-05 13:30:09 [INFO]: Item is reliested :: exists in Database 2025-08-05 13:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 13:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 13:30:09 [INFO]: in processold action queue is array for {"44592913":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44592913","ebayitemid":"334849646902","shopifyproductid":"8028661645534","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8028661645534","shopifyvariantid":"44164755914974","shopifyinventoryid":"46261741846750","shopifylocationid":"","product_id":"44592913","variant_id":"77485622","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 13:30:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 13:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 13:30:09 [INFO]: Shopify Inventory id 46261741846750 2025-08-05 13:30:09 [INFO]: Shopify Location id 58450641063 2025-08-05 13:30:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 13:30:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T13:30:09Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 13:30:09 [INFO]: Change: available | Delta: -2 2025-08-05 13:30:09 [INFO]: Change: on_hand | Delta: -2 2025-08-05 13:30:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 13:30:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44592913 and user_id = 14409 2025-08-05 13:30:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77485622 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 13:30:09 [INFO]: updateIdsQuantity -> ["77485622"] 2025-08-05 13:30:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-05 13:30:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77485622 THEN 0 END, quantityflag = CASE WHEN id = 77485622 THEN 0 END WHERE user_id = 14409 AND id IN (77485622) 2025-08-05 13:30:09 [INFO]: QUANTITY Updated IDs: 77485622 2025-08-05 13:30:09 [INFO]: Successfully processed data for user 14409 2025-08-05 13:30:09 [INFO]: Execution Started 2025-08-05 13:30:09 [INFO]: Execution Finished 2025-08-05 13:40:01 [INFO]: Execution Started 2025-08-05 13:40:01 [INFO]: old server sucessfully connected 2025-08-05 13:40:01 [INFO]: sqs client sucess created 2025-08-05 13:40:03 [INFO]: Number of messages in the queue: 2 2025-08-05 13:40:06 [INFO]: item found in queue is if condition 14409 2025-08-05 13:40:06 [INFO]: item found in queue is 14409 2025-08-05 13:40:06 [INFO]: Message deleted from the queue for receipt handle: AQEBH8ptPlhccvgWl560BG+bjMEaWj6G4Cn066+dNulZJzRjk/+aY+/Ozi2MF2idJYwlCa0Oyjlg4Kx8mhDWLCae/0L4wg9O1ZwcC8S9o+SeRmoPDua9XtO17xGe6S4bsUzBTpWDq9t4dy+pI43WfzWxr8MXI9T/LHBKJrs6tNHm074TyXvOk0vcnnNiVv4TtNW2KpTqxb7dO7hLtA0X5lijRFRcWJYYrEsppwg3xZAh1lBoWQOOjZqRz23iB5jUZWFTN6jJKYHmVp5nIteZYLsaa4aG1QSmOVqcJll3piwWDvD/bYbkeR8wElcqqxMnEOWvEGlEVqDGkyShE4RrPbMN7VT9dXLLCavseDAaI5QwNZy3A9RMqQGm/U79XPVBS7vVj+5e+iP0wuhPtfcyN9ib8MfSeSdbUd1U6j0vHHdp1c/4pTGxEN8LBT8L51mQxrws 2025-08-05 13:40:06 [INFO]: item found in queue is if condition 14409 2025-08-05 13:40:06 [INFO]: item found in queue is 14409 2025-08-05 13:40:12 [INFO]: Message deleted from the queue for receipt handle: AQEB7ZRFu1LaMGG+4VVXz3+EJo+EYWr8NDm7tA1t1Uz8k/RXD+3Q67tNbSk5+73JkAFNbBs1aodtwgnh5uFiA5z7XCe6y/iJnrZcZ82DKorc9LENKh1RVvfO1cb1Vj0q332FJzrqgQGLM7SH5twz45OPQASQrNImwHV0YQUbdTY3y3Je9nHVzcyrTIj1oXvIco+Dm3FTOWxmJAbG2fTgJWA6l3rGQ2bRg7GbLXIM6xuGJO3fZ1/qDGYGAmZWH4N3F+Y3Y0mO9Nwlf0EWvlzmbqDk6+4ltP90A6tsevfU4rEAqVi+lYLPhc9JzvAt/lxU/l6EPHbAD+1NQk1JpnY/MakLLbUMXlMV5TNQTW8Enj+R/g0UipauKC0mIWiSJsqcVU2vUEwJDHPnzlGFNzRbME8U9R9uY3tU6KafPVdNYX++ZGr+ww16/YLd87p9GHPffnbT 2025-08-05 13:40:12 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-05 13:40:12 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 13:40:12 [INFO]: inside itemsold and closed 14409 2025-08-05 13:40:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 13:40:14 [INFO]: autolink for user_id 14409 is 1 2025-08-05 13:40:14 [INFO]: Ebay item id :: 334870951302 exists in Database 2025-08-05 13:40:14 [INFO]: Item is reliested :: exists in Database 2025-08-05 13:40:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 13:40:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 13:40:14 [INFO]: inside itemsold and closed 14409 2025-08-05 13:40:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 13:40:15 [INFO]: autolink for user_id 14409 is 1 2025-08-05 13:40:15 [INFO]: Ebay item id :: 326606759308 exists in Database 2025-08-05 13:40:15 [INFO]: Item is reliested :: exists in Database 2025-08-05 13:40:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 13:40:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 13:40:15 [INFO]: in processold action queue is array for {"44569819":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44569819","ebayitemid":"334870951302","shopifyproductid":"8039822459102","variants":[{"price":"10.99","quantity":0,"weight":"2","shopifyproductid":"8039822459102","shopifyvariantid":"44186577764574","shopifyinventoryid":"46283625332958","shopifylocationid":"","product_id":"44569819","variant_id":"77462503","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44903282":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44903282","ebayitemid":"326606759308","shopifyproductid":"8940738445534","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8940738445534","shopifyvariantid":"47001474531550","shopifyinventoryid":"49112674631902","shopifylocationid":"58450641063","product_id":"44903282","variant_id":"77820512","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 13:40:15 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 13:40:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 13:40:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 13:40:15 [INFO]: Shopify Inventory id 46283625332958 2025-08-05 13:40:15 [INFO]: Shopify Location id 58450641063 2025-08-05 13:40:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 13:40:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T13:40:16Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 13:40:16 [INFO]: Change: available | Delta: -2 2025-08-05 13:40:16 [INFO]: Change: on_hand | Delta: -2 2025-08-05 13:40:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 13:40:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44569819 and user_id = 14409 2025-08-05 13:40:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77462503 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 13:40:16 [INFO]: Shopify Inventory id 49112674631902 2025-08-05 13:40:16 [INFO]: Shopify Location id 58450641063 2025-08-05 13:40:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 13:40:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-05 13:40:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 13:40:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44903282 and user_id = 14409 2025-08-05 13:40:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77820512 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 13:40:16 [INFO]: updateIdsQuantity -> ["77462503","77820512"] 2025-08-05 13:40:16 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-05 13:40:16 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77462503 THEN 0 WHEN id = 77820512 THEN 0 END, quantityflag = CASE WHEN id = 77462503 THEN 0 WHEN id = 77820512 THEN 0 END WHERE user_id = 14409 AND id IN (77462503,77820512) 2025-08-05 13:40:16 [INFO]: QUANTITY Updated IDs: 77462503, 77820512 2025-08-05 13:40:16 [INFO]: Successfully processed data for user 14409 2025-08-05 13:40:16 [INFO]: Execution Started 2025-08-05 13:40:16 [INFO]: Execution Finished 2025-08-05 13:50:01 [INFO]: Execution Started 2025-08-05 13:50:01 [INFO]: old server sucessfully connected 2025-08-05 13:50:01 [INFO]: sqs client sucess created 2025-08-05 13:50:08 [INFO]: Number of messages in the queue: 2 2025-08-05 13:50:08 [INFO]: item found in queue is if condition 14409 2025-08-05 13:50:08 [INFO]: item found in queue is 14409 2025-08-05 13:50:09 [INFO]: Message deleted from the queue for receipt handle: AQEBKokwlWjEAbe+z+OGCMOq2jJllzxuovyt+rccg5cjOzA+Ollt8aoOEfS8Ndthgp137o0+1/t1/nQt8LK+8pWNbo9l2C857XfXeO7t3N5u88OVIgOI0trOpjGyjLSKG7msfH+1vf2dhjZH0BMiJ8sKVcgREM52UF/isoPT8MU5haL+WppoTWsQA50AszvzGryBoVMgrHp2PrzngKP8OWwP+4Sxpcs2Ot2QlEe1qC8u6hdEKM6FraelXbt4B8LsbtPg8i+NHLJP58jbxfxaTfhC7cIbEKU2ukd2vC6EfB+KA+6sh75GBE3Z9hIcJKkVW5SuTlJg19/SKoZ4XbT/pUq8dtQ0Ipjd1/etOwhk3By3gH2igDwipIecMBE2VWwVGJCm1vGSS1MybpzJW1PIvnmUeBNtG/YKFpGvcOP2R6mrlUXzSFG376NFxEwEi1bFcDht 2025-08-05 13:50:10 [INFO]: item found in queue is if condition 14409 2025-08-05 13:50:10 [INFO]: item found in queue is 14409 2025-08-05 13:50:10 [INFO]: Message deleted from the queue for receipt handle: AQEBVlyvEGyn7w6yPHgiBGQ29mS3mPdn7Wcs+Qn4Rg4pk8QsH/BChGmECrmeudoHEx25PSSm1f4zua/gkUxsVua0b57BKvFG3ISxUW9PL5HDB0S7OdWhSgJ/UCycQrUsjST94Q9Q0Ox7ncMD8gbDw9T4zAgxe7UqbbILm2lPA1u8JLftNibAv8wsGz9j7N+/IpqYgG+mBVGNYpJMBqEix5+Y7su2zTo8aGLMjq0hb0v5VYDOCWseMcnFtYFE5mnJcOrsR0V+eXhi/z1XdB6TwK7jMA2jJhZtS1AGLi1atUooXIdO8CTZb7QjC4mbQCycbFbT/x088uCpKnpl8NO8rP9QyhbOzKu/5+XshpW9cfZlD2iEVMOHtSb1de7s3oqt00J/M3cTPZQ0EdlK19TabgpOQuwkOVQfL/NxuE3z8p48SPeSYIIMoH7PryPoDWzHk9Xk 2025-08-05 13:50:10 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-05 13:50:10 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 13:50:10 [INFO]: inside itemsold and closed 14409 2025-08-05 13:50:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 13:50:12 [INFO]: autolink for user_id 14409 is 1 2025-08-05 13:50:12 [INFO]: Ebay item id :: 334891129456 exists in Database 2025-08-05 13:50:12 [INFO]: Item is reliested :: exists in Database 2025-08-05 13:50:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 13:50:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 13:50:12 [INFO]: inside itemsold and closed 14409 2025-08-05 13:50:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 13:50:14 [INFO]: autolink for user_id 14409 is 1 2025-08-05 13:50:14 [INFO]: Ebay item id :: 304939466119 exists in Database 2025-08-05 13:50:14 [INFO]: Item is reliested :: exists in Database 2025-08-05 13:50:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 13:50:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 13:50:14 [INFO]: in processold action queue is array for {"44596083":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44596083","ebayitemid":"334891129456","shopifyproductid":"8051110609118","variants":[{"price":"13.99","quantity":0,"weight":"2","shopifyproductid":"8051110609118","shopifyvariantid":"44208402759902","shopifyinventoryid":"46305486242014","shopifylocationid":"","product_id":"44596083","variant_id":"77488792","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44581782":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44581782","ebayitemid":"304939466119","shopifyproductid":"8041976103134","variants":[{"price":"10.99","quantity":0,"weight":"2","shopifyproductid":"8041976103134","shopifyvariantid":"44190692901086","shopifyinventoryid":"46287748694238","shopifylocationid":"","product_id":"44581782","variant_id":"77474491","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 13:50:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 13:50:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 13:50:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 13:50:14 [INFO]: Shopify Inventory id 46305486242014 2025-08-05 13:50:14 [INFO]: Shopify Location id 58450641063 2025-08-05 13:50:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 13:50:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T13:50: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-08-05 13:50:14 [INFO]: Change: available | Delta: -1 2025-08-05 13:50:14 [INFO]: Change: on_hand | Delta: -1 2025-08-05 13:50:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 13:50:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44596083 and user_id = 14409 2025-08-05 13:50:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77488792 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 13:50:14 [INFO]: Shopify Inventory id 46287748694238 2025-08-05 13:50:14 [INFO]: Shopify Location id 58450641063 2025-08-05 13:50:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 13:50:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T13:50:14Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 13:50:14 [INFO]: Change: available | Delta: -2 2025-08-05 13:50:14 [INFO]: Change: on_hand | Delta: -2 2025-08-05 13:50:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 13:50:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44581782 and user_id = 14409 2025-08-05 13:50:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77474491 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 13:50:14 [INFO]: updateIdsQuantity -> ["77488792","77474491"] 2025-08-05 13:50:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-05 13:50:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77488792 THEN 0 WHEN id = 77474491 THEN 0 END, quantityflag = CASE WHEN id = 77488792 THEN 0 WHEN id = 77474491 THEN 0 END WHERE user_id = 14409 AND id IN (77488792,77474491) 2025-08-05 13:50:14 [INFO]: QUANTITY Updated IDs: 77488792, 77474491 2025-08-05 13:50:14 [INFO]: Successfully processed data for user 14409 2025-08-05 13:50:14 [INFO]: Execution Started 2025-08-05 13:50:14 [INFO]: Execution Finished