2025-08-08 17:00:01 [INFO]: Execution Started
2025-08-08 17:00:01 [INFO]: old server sucessfully connected
2025-08-08 17:00:02 [INFO]: sqs client sucess created
2025-08-08 17:00:04 [INFO]: Number of messages in the queue: 2
2025-08-08 17:00:05 [INFO]: item found in queue is if condition  14409
2025-08-08 17:00:05 [INFO]: item found in queue is  14409
2025-08-08 17:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBKl484u9O6A/6lxZHquEFwzvSQ+WaBmcl0UgMazb1aQuKci3CEPL9QoPA52FD5PHO7DCgcX1dmoik1Xz6L+zF3pC//ZSTer/RpWOFJ8Sk3tOB9sbNoiAluRcX1d/RwBFHSRl8sfOU5tWcl3+gtor++02AHqUWx5ccfCC9BxS0crolDaJY5wquUNu6pwu+CpiCPuO59ovR69TlXEqh28D/++3M0s72AEbwZrUXwfMs0D5WaACEaE67F4OEoqeb620DwdsZeQ/bhTqKZpy/dSME1fj/F36UT+vI4/DSdWS2ClVjiSgW4i6KrPHg64aqdJfUgybWqWHtpM+7AtSvezChc/TUVkHjw7xJDkLS7N5bCg5MSrwUkDM5Dhl8Re1jC73QknMEAwxjyZ7YrYXh/+v+Vyol4PuXVNBj7vGZTJ2bIhqDei5uX7rQ7XGUhfvF3eLR
2025-08-08 17:00:06 [INFO]: item found in queue is if condition  14409
2025-08-08 17:00:06 [INFO]: item found in queue is  14409
2025-08-08 17:00:06 [INFO]: Message deleted from the queue for receipt handle: AQEBBA+pXpN2BCYGVTvIf5c9hRlT9Jkm55q965K57Fk9wmN8K7rZtsES7fE6b1CSGeduXfEv5Tt1bLFwgLqUKV3LpLaO218m2xbCvyi930vf6e9/ZkFwT7kxeLHdMfokvBI3LZtn2h7SopFeJ77Ak6WSrLsHZn2W90KAPgKtlNWs6vZw/Thk7gY1XGUOkFDk4yAYEwGPc0GpHxLe8Qf4arI1Yv+PTib+tQqGI9Tap+fpEp6OlZR7eTKRW9vPtyhqvqJLGbLG6o+rvMbKkxJILJb0i/xdspIgajVmkjsY7W3d1878ITM/H3GYhsP8vzOZMhz/+NLuTGpwxhoUg7MgAwBb2huZraInt+LM/TUfDqGyfKCDSc9QJ7VrxmSR/gYREn/G7T+B6YkXUTubVdxKEpHCnntygjT/R9ZVGNHWqBD2vi2u6q7XOprMbvVWOKrLs3xN
2025-08-08 17:00:06 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-08 17:00:06 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-08 17:00:06 [INFO]: inside itemsold and closed 14409
2025-08-08 17:00:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 17:00:08 [INFO]: autolink for user_id 14409 is 1
2025-08-08 17:00:08 [INFO]: Ebay item id :: 335722526836 exists in Database
2025-08-08 17:00:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 17:00:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 17:00:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 17:00:08 [INFO]: inside itemsold and closed 14409
2025-08-08 17:00:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 17:00:10 [INFO]: autolink for user_id 14409 is 1
2025-08-08 17:00:10 [INFO]: Ebay item id :: 405275415772 exists in Database
2025-08-08 17:00:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 17:00:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 17:00:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 17:00:10 [INFO]: in processold action queue is array    for {"44636670":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44636670","ebayitemid":"335722526836","shopifyproductid":"8764362031326","variants":[{"price":"444.54","quantity":0,"weight":"18","shopifyproductid":"8764362031326","shopifyvariantid":"46152804139230","shopifyinventoryid":"48252117287134","shopifylocationid":"","product_id":"44636670","variant_id":"77541859","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44776050":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44776050","ebayitemid":"405275415772","shopifyproductid":"7921543020766","variants":[{"price":"9.99","quantity":0,"weight":"1","shopifyproductid":"7921543020766","shopifyvariantid":"43855665561822","shopifyinventoryid":"45951781306590","shopifylocationid":"","product_id":"44776050","variant_id":"77684592","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-08 17:00:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-08 17:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 17:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 17:00:10 [INFO]: Shopify Inventory id 48252117287134
2025-08-08 17:00:10 [INFO]: Shopify Location id 58450641063
2025-08-08 17:00:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 17:00:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T17:00:10Z","reason":"correction","changes":[{"name":"available","delta":-45},{"name":"on_hand","delta":-45}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-08 17:00:10 [INFO]: Change: available | Delta: -45
2025-08-08 17:00:10 [INFO]: Change: on_hand | Delta: -45
2025-08-08 17:00:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 17:00:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44636670 and user_id = 14409 
2025-08-08 17:00:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77541859 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 17:00:10 [INFO]: Shopify Inventory id 45951781306590
2025-08-08 17:00:10 [INFO]: Shopify Location id 58450641063
2025-08-08 17:00:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 17:00:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T17:00: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-08-08 17:00:10 [INFO]: Change: available | Delta: -1
2025-08-08 17:00:10 [INFO]: Change: on_hand | Delta: -1
2025-08-08 17:00:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 17:00:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44776050 and user_id = 14409 
2025-08-08 17:00:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77684592 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 17:00:10 [INFO]: updateIdsQuantity -> ["77541859","77684592"]
2025-08-08 17:00:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-08 17:00:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77541859 THEN 0 WHEN id = 77684592 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77541859 THEN 0 WHEN id = 77684592 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77541859,77684592)
2025-08-08 17:00:10 [INFO]: QUANTITY Updated IDs: 77541859, 77684592
2025-08-08 17:00:10 [INFO]: Successfully processed data for user 14409
2025-08-08 17:00:10 [INFO]: Execution Started
2025-08-08 17:00:10 [INFO]: Execution Finished
2025-08-08 17:10:01 [INFO]: Execution Started
2025-08-08 17:10:01 [INFO]: old server sucessfully connected
2025-08-08 17:10:01 [INFO]: sqs client sucess created
2025-08-08 17:10:02 [INFO]: Number of messages in the queue: 2
2025-08-08 17:10:03 [INFO]: item found in queue is if condition  14409
2025-08-08 17:10:03 [INFO]: item found in queue is  14409
2025-08-08 17:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBldhB0HLXDYCkC1H7AhuPO7lLNmIfmO0TxLZFzsS2IP7mOQMsq9kB5innoZ4jlr3m6cRy2WvBXNwkS5PDDAPzsdrn2nfZFnqEnoZrMVZBMzZa1xmdvlXdlxto5ycgdO2E1oNue+J31h6KtTwoTK9LdgjtyrNVZNDoqincVDyF6boMFlDy6Cx2RtSMnxdwFLu+SoUpvVKAfPc9B00V4Ou7+lMr5bKvXE/P9Xkg1yvuhgZ9bnmjqjSEJfsztJ3RaD9bsdibQa/Egk2BNijpQhJAzQwi6r4N9kAqhVCKAv6MB7Xcflx+Kp4ZpmhjmQrX+SrqH19AkS7qPEE1AdxjLaFEFMXWDmEpgha0B1w1j6N3ZstKWShcrQi4o0GLfEQ7Kueo1cAEbtBjNgPE6fNF6noixiLWXFH+H6HO5Kg1llUqQoeUCCtKxMwj+O8NL4v7R0Gj
2025-08-08 17:10:03 [INFO]: item found in queue is if condition  14409
2025-08-08 17:10:03 [INFO]: item found in queue is  14409
2025-08-08 17:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEB5Opfknf/siJ8StW+povihylkWVoBvZJSefV2EnF/+JZhJEnHls/Qn84YXBfsIfsig4Aa808HkRysZLYW6vSJG59+Ecwocdhc9NdshObV/YjsBVlsKQGLEaAeS4dSnhkMpp2UIhczkvnzAgxCr6dYo/MHxx2VT1JyTEW66UofV9LVeHUI5AKm+EHas89d48cveeVRpYv1Z6kq6au4TzHuT+R1t5p48PL55OnlenvNwPReXGQakQ0mOmH85WaYUKNyNmaGyiMZI4234BetkpG/eM1D6OVSU1RSpjU6i36Jr6KwBhuTATDaQrCZmj/Mzbuc0KIz+r/BNCt3kv+pPLfTRMAsN7FH8/5p9mK2LQyVR+AL/k2dAeDGahdOEHgwiDN2mMj7/X6GfnGHhAxNkVq78dqpw+r63jYJY3RL0gzckdbDQZD3HKduttoQ6RcRrJyM
2025-08-08 17:10:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-08 17:10:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-08 17:10:04 [INFO]: inside itemsold and closed 14409
2025-08-08 17:10:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 17:10:05 [INFO]: autolink for user_id 14409 is 1
2025-08-08 17:10:05 [INFO]: Ebay item id :: 286207245877 exists in Database
2025-08-08 17:10:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 17:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 17:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 17:10:05 [INFO]: inside itemsold and closed 14409
2025-08-08 17:10:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 17:10:07 [INFO]: autolink for user_id 14409 is 1
2025-08-08 17:10:07 [INFO]: Ebay item id :: 286137428083 exists in Database
2025-08-08 17:10:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 17:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 17:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 17:10:07 [INFO]: in processold action queue is array    for {"44565491":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44565491","ebayitemid":"286207245877","shopifyproductid":"8759198646494","variants":[{"price":"436.89","quantity":0,"weight":"18","shopifyproductid":"8759198646494","shopifyvariantid":"46137375490270","shopifyinventoryid":"48236597739742","shopifylocationid":"","product_id":"44565491","variant_id":"77458171","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44776369":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44776369","ebayitemid":"286137428083","shopifyproductid":"7954873450718","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"7954873450718","shopifyvariantid":"43994302972126","shopifyinventoryid":"46090821402846","shopifylocationid":"","product_id":"44776369","variant_id":"77684911","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-08 17:10:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-08 17:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 17:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 17:10:07 [INFO]: Shopify Inventory id 48236597739742
2025-08-08 17:10:07 [INFO]: Shopify Location id 58450641063
2025-08-08 17:10:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 17:10:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T17:10:07Z","reason":"correction","changes":[{"name":"available","delta":-45},{"name":"on_hand","delta":-45}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-08 17:10:07 [INFO]: Change: available | Delta: -45
2025-08-08 17:10:07 [INFO]: Change: on_hand | Delta: -45
2025-08-08 17:10:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 17:10:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44565491 and user_id = 14409 
2025-08-08 17:10:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77458171 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 17:10:07 [INFO]: Shopify Inventory id 46090821402846
2025-08-08 17:10:07 [INFO]: Shopify Location id 58450641063
2025-08-08 17:10:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 17:10:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T17:10: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-08-08 17:10:08 [INFO]: Change: available | Delta: -1
2025-08-08 17:10:08 [INFO]: Change: on_hand | Delta: -1
2025-08-08 17:10:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 17:10:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44776369 and user_id = 14409 
2025-08-08 17:10:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77684911 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 17:10:08 [INFO]: updateIdsQuantity -> ["77458171","77684911"]
2025-08-08 17:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-08 17:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77458171 THEN 0 WHEN id = 77684911 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77458171 THEN 0 WHEN id = 77684911 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77458171,77684911)
2025-08-08 17:10:08 [INFO]: QUANTITY Updated IDs: 77458171, 77684911
2025-08-08 17:10:08 [INFO]: Successfully processed data for user 14409
2025-08-08 17:10:08 [INFO]: Execution Started
2025-08-08 17:10:08 [INFO]: Execution Finished
2025-08-08 17:20:01 [INFO]: Execution Started
2025-08-08 17:20:01 [INFO]: old server sucessfully connected
2025-08-08 17:20:01 [INFO]: sqs client sucess created
2025-08-08 17:20:02 [INFO]: Number of messages in the queue: 2
2025-08-08 17:20:02 [INFO]: item found in queue is if condition  14409
2025-08-08 17:20:02 [INFO]: item found in queue is  14409
2025-08-08 17:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBXIu8y0ElXcl3bSw5m3JGEfhgIs31pGGxqh/0a2wu141Z3NG49CnAj+TAfDmp2go+qmUB2QP4bEnfVPO3NnjdAN73WkgqEbqRJl3XEo9dEr0Lug+30B9CVJIGlR3UsHKbgZR3ATs12zB2fWabeB/KCqSd6XtKq3PzVtIsx2KpsG0b0XjwcDMWw+Lv9q0cVL5OkZNXTYt/DFiPGJsr4mEZPhVIxdcC+WDM4nBOKghsJaPGQ+smP4HhjUiAYNe/IlRIwYBhmEN2slN5joko+tuzoh1zEcUPZaaF4zBAewIVcwoKnZsJ2W5tSqr8HuWh75yQZ3F/dhjPycygcXyEiPCgENprLMjC8k+5jkRlrCj4f0zwcR+BD1e+f0JqmyhWXc1zhRAw4mu1b0SELkQFa9IYMpUIhdtsZccqpEv1FjwcRMwOOurWpuTbgEqWYqgLZ5nO
2025-08-08 17:20:03 [INFO]: item found in queue is if condition  14409
2025-08-08 17:20:03 [INFO]: item found in queue is  14409
2025-08-08 17:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEB+ZUuXeeORr0ONaCyUbdZMWajBtdTKBmJziSIwwn+t6bhbwpcABbJXVgABioiU8iDvJerMgOKhSGA65u7SOEweJZHsKzEyTtJwH1atBVhvu92lBxOzvbSZZWiA3uedQZoiBt0VYOebNRdVxEEl0PuIei7rkGgQWIYC2lm46iqkNKVadb8YunXEbPqTFOMpaEhLO8h+b6S0YeLA8s67V/PT+fx598h9rvOwJ5jEaCvxK1QUX5ogZpvxDP59Q1akjM/4tPnZm69zb2IrZtHWKVhAScZX2U+zrIDf5JjOubloKUfITAaX1L1pfxWiaEC4PeBx6naQ+2JlevFPHrAfwgd7Y2znFYpWYrdcOOW2AHDeN2z4sd1mwev5s+2F9FPA3BYQ1sKCztaz5PBphWz4zsMdl154++ndSALmIODya4XIHzKBgOsAadpgjXp1EMAn/vx
2025-08-08 17:20:03 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-08 17:20:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-08 17:20:03 [INFO]: inside itemsold and closed 14409
2025-08-08 17:20:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 17:20:05 [INFO]: autolink for user_id 14409 is 1
2025-08-08 17:20:05 [INFO]: Ebay item id :: 305790829536 exists in Database
2025-08-08 17:20:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 17:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 17:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 17:20:05 [INFO]: inside itemsold and closed 14409
2025-08-08 17:20:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 17:20:07 [INFO]: autolink for user_id 14409 is 1
2025-08-08 17:20:07 [INFO]: Ebay item id :: 226644736662 exists in Database
2025-08-08 17:20:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 17:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 17:20:07 [INFO]: in processold action queue is array    for {"44579044":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44579044","ebayitemid":"305790829536","shopifyproductid":"8695056892126","variants":[{"price":"466.64","quantity":0,"weight":"18","shopifyproductid":"8695056892126","shopifyvariantid":"45933874282718","shopifyinventoryid":"48032325664990","shopifylocationid":"","product_id":"44579044","variant_id":"77471751","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-08 17:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-08 17:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 17:20:07 [INFO]: Shopify Inventory id 48032325664990
2025-08-08 17:20:07 [INFO]: Shopify Location id 58450641063
2025-08-08 17:20:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 17:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T17:20:07Z","reason":"correction","changes":[{"name":"available","delta":-45},{"name":"on_hand","delta":-45}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-08 17:20:07 [INFO]: Change: available | Delta: -45
2025-08-08 17:20:07 [INFO]: Change: on_hand | Delta: -45
2025-08-08 17:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 17:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44579044 and user_id = 14409 
2025-08-08 17:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77471751 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 17:20:07 [INFO]: updateIdsQuantity -> ["77471751"]
2025-08-08 17:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-08 17:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77471751 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77471751 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77471751)
2025-08-08 17:20:07 [INFO]: QUANTITY Updated IDs: 77471751
2025-08-08 17:20:07 [INFO]: Successfully processed data for user 14409
2025-08-08 17:20:07 [INFO]: Execution Started
2025-08-08 17:20:07 [INFO]: Execution Finished
2025-08-08 17:30:01 [INFO]: Execution Started
2025-08-08 17:30:01 [INFO]: old server sucessfully connected
2025-08-08 17:30:01 [INFO]: sqs client sucess created
2025-08-08 17:30:02 [INFO]: Number of messages in the queue: 1
2025-08-08 17:30:03 [INFO]: item found in queue is if condition  14409
2025-08-08 17:30:03 [INFO]: item found in queue is  14409
2025-08-08 17:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEB7uOxgQYonzMvegLGgjI6stjrGdacIBtb1RrlPZnqgP2t8ZlJ2OF8xIs7PkIT3mCs8NxhlLxwjSAj80VUUir2Dkw4VAET7GbLAuZr3kyQbiASPBD1Ee1Z3w9ONtCuxlk23uV5HTIjOxRD/DaDWGztAQpcnHpnl5cJ70JTlzwjvSrd+0Sn5U+b55KT407MA8YuaE98/kO4BFMU2wjX4bzBRuizxMNrQs4/Tzl02lpdJYfjXHkDNzAXwytJ0zgPYAdZDXcXAx8tLC3V1IXbBJ8JfM56M/V5sMgv1D9mBp+SCS00BhFSeNg95uWIH5Ao9wq6y8P4h7bwnb4m6iDMd1972Mi/GIdGI6+cNoWaK9YBL4s9PBHcM/QSXzZSf/UwgRH9d2wObqQ5IjP9xA8Knj7ZkKYLRFNWktupc2eYKfiCHm/L3Due6umNSLgm7RPWrKxQ
2025-08-08 17:30:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-08 17:30:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-08 17:30:03 [INFO]: inside itemsold and closed 14409
2025-08-08 17:30:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 17:30:05 [INFO]: autolink for user_id 14409 is 1
2025-08-08 17:30:05 [INFO]: Ebay item id :: 305790863333 exists in Database
2025-08-08 17:30:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 17:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 17:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 17:30:05 [INFO]: in processold action queue is array    for {"44582689":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44582689","ebayitemid":"305790863333","shopifyproductid":"8793920536798","variants":[{"price":"436.89","quantity":0,"weight":"18","shopifyproductid":"8793920536798","shopifyvariantid":"46229233238238","shopifyinventoryid":"48329505046750","shopifylocationid":"","product_id":"44582689","variant_id":"77475398","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-08 17:30:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-08 17:30:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 17:30:05 [INFO]: Shopify Inventory id 48329505046750
2025-08-08 17:30:05 [INFO]: Shopify Location id 58450641063
2025-08-08 17:30:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 17:30:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T17:30:05Z","reason":"correction","changes":[{"name":"available","delta":-45},{"name":"on_hand","delta":-45}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-08 17:30:05 [INFO]: Change: available | Delta: -45
2025-08-08 17:30:05 [INFO]: Change: on_hand | Delta: -45
2025-08-08 17:30:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 17:30:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44582689 and user_id = 14409 
2025-08-08 17:30:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77475398 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 17:30:05 [INFO]: updateIdsQuantity -> ["77475398"]
2025-08-08 17:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-08 17:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77475398 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77475398 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77475398)
2025-08-08 17:30:05 [INFO]: QUANTITY Updated IDs: 77475398
2025-08-08 17:30:05 [INFO]: Successfully processed data for user 14409
2025-08-08 17:30:05 [INFO]: Execution Started
2025-08-08 17:30:05 [INFO]: Execution Finished
2025-08-08 17:40:02 [INFO]: Execution Started
2025-08-08 17:40:02 [INFO]: old server sucessfully connected
2025-08-08 17:40:02 [INFO]: sqs client sucess created
2025-08-08 17:40:04 [INFO]: Number of messages in the queue: 0
2025-08-08 17:40:24 [INFO]: Execution Started
2025-08-08 17:40:24 [INFO]: Execution Finished
2025-08-08 17:50:02 [INFO]: Execution Started
2025-08-08 17:50:02 [INFO]: old server sucessfully connected
2025-08-08 17:50:02 [INFO]: sqs client sucess created
2025-08-08 17:50:03 [INFO]: Number of messages in the queue: 1
2025-08-08 17:50:03 [INFO]: item found in queue is if condition  14409
2025-08-08 17:50:03 [INFO]: item found in queue is  14409
2025-08-08 17:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBeWuxpeo4u18V1nxS2E/igmWNb/AsNr4RKXzmjY6PVubutrWZByNiEKpj8T4KDiXzdmV1CE/bo/vhMn2ywY+0CBpWv5X3AN8mojSQLapt6hFTmRwdKKAMrCfeKMTOKDhjk3NWTD5O8jO5ql8nyWwKFJI32oh60qbdMBaXyjlZz6Siq+ZT06Wq7HhedxAG5Z+wpFsXcXKqbDE5bORabH4AplI5gwLlzvpKNdexQ62M6W+JKs4aTEguMKLyq4tTrY/cEmvdgMiqPsmSFY+4+6VAgdFP3ORgz5t2iXI1meEy8ySi1wKWpCyfDDNrYvOCLSCzcQicHv/HX+B3SJKMhFoSS2QYEg9fpI17QipvhhDh+6qCUiqHuUK8ncDcXy6a7yVXrptF5vYH49oCfl2sKl0gYIrHm2pAj21oRVPwp5PZHLMNdT8NvYWGvf4mFeEDD+Wa
2025-08-08 17:50:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-08 17:50:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-08 17:50:03 [INFO]: inside itemsold and closed 14409
2025-08-08 17:50:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 17:50:05 [INFO]: autolink for user_id 14409 is 1
2025-08-08 17:50:05 [INFO]: Ebay item id :: 286386879624 exists in Database
2025-08-08 17:50:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 17:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 17:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 17:50:05 [INFO]: in processold action queue is array    for {"44820202":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44820202","ebayitemid":"286386879624","shopifyproductid":"8048941072606","variants":[{"price":"39.99","quantity":0,"weight":"2","shopifyproductid":"8048941072606","shopifyvariantid":"44203495751902","shopifyinventoryid":"46300573040862","shopifylocationid":"","product_id":"44820202","variant_id":"77730765","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-08 17:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-08 17:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 17:50:05 [INFO]: Shopify Inventory id 46300573040862
2025-08-08 17:50:05 [INFO]: Shopify Location id 58450641063
2025-08-08 17:50:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 17:50:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T17: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-08 17:50:05 [INFO]: Change: available | Delta: -1
2025-08-08 17:50:05 [INFO]: Change: on_hand | Delta: -1
2025-08-08 17:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 17:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44820202 and user_id = 14409 
2025-08-08 17:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77730765 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 17:50:05 [INFO]: updateIdsQuantity -> ["77730765"]
2025-08-08 17:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-08 17:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77730765 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77730765 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77730765)
2025-08-08 17:50:05 [INFO]: QUANTITY Updated IDs: 77730765
2025-08-08 17:50:05 [INFO]: Successfully processed data for user 14409
2025-08-08 17:50:05 [INFO]: Execution Started
2025-08-08 17:50:05 [INFO]: Execution Finished