2025-07-31 21:00:01 [INFO]: Execution Started 2025-07-31 21:00:01 [INFO]: old server sucessfully connected 2025-07-31 21:00:01 [INFO]: sqs client sucess created 2025-07-31 21:00:02 [INFO]: Number of messages in the queue: 3 2025-07-31 21:00:03 [INFO]: item found in queue is if condition 14409 2025-07-31 21:00:03 [INFO]: item found in queue is 14409 2025-07-31 21:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBjahnSGyzipwPAXIT2MvOJBfh6wkl9r0t1iUfCXBVzledpNP0wuMlqlcpxWdph+gWAIHrg4ADw4PFgC15oNQS9DFmTQGoT7IQLtyeKeCP+diihQ1KBEryhdHecsZ281Fmrc+IU4agh+V43ovyEyR414nup7WdUlHuX5LOAVvbkCN8UKA3YM1fcrgG9G89LmVj72Dz+tOxzu18xauK1CsPhcufhsNSBZpFjejWpPEoUwYln7GzL879IuvbdduYA8xbsBZqLkuGVS6WkSql/zAakNEP8WQWPatGi/W2AIyTSRwCW38gxeSZr5++3KR1BqMuUFZBGx6rIrUwVHophaep10QTZJ+hVmCFCtvF02H5nMxK9wMtofCqVvzxhklxHbfMjg5g/DihkBxBpPz57yXFCXqYzd8iyWQqMMZEHO0+6E0zCFf2h+KlrJqm6yjIcjCp 2025-07-31 21:00:03 [INFO]: item found in queue is if condition 14409 2025-07-31 21:00:03 [INFO]: item found in queue is 14409 2025-07-31 21:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBEBWVzjwDntppjq/ltDE60rc8lz9MfPdPYR0cGD1NhZVgfPkzoiNrAbKQCMgzsV8Gc/wwwssOtqfRzxfUYCgsAj34UbVcCvrfuQhQpXdXtgMlayJ1p7ROrew1zatMPyjMWJXmlHfIx/3q1BXTqyjfeGdSKW348cma342vA1GK+Jo1Ar2v38+asTnelsK/yUHuGBa717SPdQ8gsq08AIQzw1rV9TidxKyXt7dqeuSAKEX7rz9jkWNVD/BXmnH4ZS7KxycVMt+asacQ/jIoWTCckH8bG0TizPWBWsUr77O74sRU5iloads0xGCSC67TVmLqSCFYjl2TzhWDJSTwDx/FhVX1L2tZtFH1RRyT+Qhs+QEi1iazJryO9U4Faq07ZeSnbt1I0qnqFzbo7Qqggv0xcvn4T+1opFHkpjOdqH2a2sMWO4EGoqtMTEZxFroWxlCZ 2025-07-31 21:00:04 [INFO]: item found in queue is if condition 14409 2025-07-31 21:00:04 [INFO]: item found in queue is 14409 2025-07-31 21:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBm2JVX/DEAGD5234iA5WFngscSDcdAFjOp6WXlJG3IWD3gZ1rUJ+DZr2w5TegU9tNplJSJCS25asBUqwheLxsFd9hssqhMLNc6L1dr1cd1EmBtUJCL5/n57J0W9pp00lfrz8GZHWOHEzvYJYbpMS9WeY6sjkNxEQv6R5ZrxhH0dlDthPFqyIDV7z0pVRr2zlPp+eMBqM2ZyB3w6IRS3BQjQPe1w4vDyck5wCMOW07g7dWDDbMco4VFEa0ngcqd0y4/Y1i7wI7VCPUbWOEPz+QMJEXKaD4Kq8I5Yxad0eC7Z87yLINCLtCNw7m0ZYUNVkhNyYgX6YAr5PJBgd5TJ9psuDpFk2Ntn2wsdXOmqR+ASB44Gn6atj4rVaSFJBjxYpjm/L9NRYE/Yb4e8p6x8one2BpZ19ZejFBHZEAG4xgkciN8Wej6yYPa/aArsVRctWg 2025-07-31 21:00:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-07-31 21:00:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 21:00:04 [INFO]: inside itemsold and closed 14409 2025-07-31 21:00:06 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 21:00:06 [INFO]: autolink for user_id 14409 is 1 2025-07-31 21:00:06 [INFO]: Ebay item id :: 335641054687 exists in Database 2025-07-31 21:00:06 [INFO]: Item is reliested :: exists in Database 2025-07-31 21:00:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 21:00:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 21:00:06 [INFO]: inside itemsold and closed 14409 2025-07-31 21:00:09 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 21:00:09 [INFO]: autolink for user_id 14409 is 1 2025-07-31 21:00:09 [INFO]: Ebay item id :: 286032581397 exists in Database 2025-07-31 21:00:09 [INFO]: Item is reliested :: exists in Database 2025-07-31 21:00:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 21:00:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 21:00:09 [INFO]: inside itemsold and closed 14409 2025-07-31 21:00:10 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 21:00:10 [INFO]: autolink for user_id 14409 is 1 2025-07-31 21:00:10 [INFO]: Ebay item id :: 335882043197 exists in Database 2025-07-31 21:00:10 [INFO]: Item is reliested :: exists in Database 2025-07-31 21:00:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 21:00:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 21:00:10 [INFO]: in processold action queue is array for {"44594013":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44594013","ebayitemid":"335641054687","shopifyproductid":"8711363461342","variants":[{"price":"34.99","quantity":0,"weight":"2","shopifyproductid":"8711363461342","shopifyvariantid":"45972764131550","shopifyinventoryid":"48071555711198","shopifylocationid":"","product_id":"44594013","variant_id":"77486722","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44641247":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44641247","ebayitemid":"286032581397","shopifyproductid":"8697444892894","variants":[{"price":"33.99","quantity":0,"weight":"2","shopifyproductid":"8697444892894","shopifyvariantid":"45939208388830","shopifyinventoryid":"48037664850142","shopifylocationid":"","product_id":"44641247","variant_id":"77546436","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44592755":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44592755","ebayitemid":"335882043197","shopifyproductid":"8857401589982","variants":[{"price":"518.39","quantity":0,"weight":"15","shopifyproductid":"8857401589982","shopifyvariantid":"46494509924574","shopifyinventoryid":"48596721172702","shopifylocationid":"","product_id":"44592755","variant_id":"77485464","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 21:00:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 21:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 21:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 21:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 21:00:10 [INFO]: Shopify Inventory id 48071555711198 2025-07-31 21:00:10 [INFO]: Shopify Location id 58450641063 2025-07-31 21:00:10 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 21:00:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T21:00:11Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-07-31 21:00:11 [INFO]: Change: available | Delta: -1 2025-07-31 21:00:11 [INFO]: Change: on_hand | Delta: -1 2025-07-31 21:00:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 21:00:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44594013 and user_id = 14409 2025-07-31 21:00:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77486722 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 21:00:11 [INFO]: Shopify Inventory id 48037664850142 2025-07-31 21:00:11 [INFO]: Shopify Location id 58450641063 2025-07-31 21:00:11 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 21:00:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T21:00:11Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-07-31 21:00:11 [INFO]: Change: available | Delta: -1 2025-07-31 21:00:11 [INFO]: Change: on_hand | Delta: -1 2025-07-31 21:00:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 21:00:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44641247 and user_id = 14409 2025-07-31 21:00:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77546436 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 21:00:11 [INFO]: Shopify Inventory id 48596721172702 2025-07-31 21:00:11 [INFO]: Shopify Location id 58450641063 2025-07-31 21:00:11 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 21:00:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T21:00:11Z","reason":"correction","changes":[{"name":"available","delta":1},{"name":"on_hand","delta":1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-07-31 21:00:11 [INFO]: Change: available | Delta: 1 2025-07-31 21:00:11 [INFO]: Change: on_hand | Delta: 1 2025-07-31 21:00:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 21:00:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44592755 and user_id = 14409 2025-07-31 21:00:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77485464 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 21:00:11 [INFO]: updateIdsQuantity -> ["77486722","77546436","77485464"] 2025-07-31 21:00:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-07-31 21:00:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77486722 THEN 0 WHEN id = 77546436 THEN 0 WHEN id = 77485464 THEN 0 END, quantityflag = CASE WHEN id = 77486722 THEN 0 WHEN id = 77546436 THEN 0 WHEN id = 77485464 THEN 0 END WHERE user_id = 14409 AND id IN (77486722,77546436,77485464) 2025-07-31 21:00:11 [INFO]: QUANTITY Updated IDs: 77486722, 77546436, 77485464 2025-07-31 21:00:11 [INFO]: Successfully processed data for user 14409 2025-07-31 21:00:11 [INFO]: Execution Started 2025-07-31 21:00:11 [INFO]: Execution Finished 2025-07-31 21:10:01 [INFO]: Execution Started 2025-07-31 21:10:01 [INFO]: old server sucessfully connected 2025-07-31 21:10:01 [INFO]: sqs client sucess created 2025-07-31 21:10:02 [INFO]: Number of messages in the queue: 2 2025-07-31 21:10:03 [INFO]: item found in queue is if condition 14409 2025-07-31 21:10:03 [INFO]: item found in queue is 14409 2025-07-31 21:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBWhbP4bDMB3phSmWJetmzB/ol1Ffc6okIqkN4500lQ2J8xoa7IC+AX7fPMbZdrZR2nDUNdIJtvmGdAiQ67auZDVuJK9oAKvBMR7EjPIhmSQuSzTUswOpTVJ/50DzR9MYJBiq/xwS+ID7JgqJ9Bv7bRpbg+LF0HaDeikAUAUdYsLA43T2xyAsXZKb9qf9DmmJ8cReNUKZ3x9BlstbNlsLR3rjtF2CXhS2kejQk2MdsfM3cwldCCvewSY42eHjS63hre9QmuAK955wElqEQuKTFDPEmrYg19FYO31yGD3RmFDjdE2RYitiJTDAK5A07r6bt8NKqh6Z6lqVDDr+GiA+3RC+M0dbUjHFzvzMS3qcEUv6HFJvEo0LRjn7ds4tmNohqP0VFqUhEAW9+LMNLVD3jruSI0Ta6FnqLwHQqqy6vXQ/HLodX1issVJZFa+wcZ8W/ 2025-07-31 21:10:03 [INFO]: item found in queue is if condition 14409 2025-07-31 21:10:03 [INFO]: item found in queue is 14409 2025-07-31 21:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBsHIcfiqgEzoEI/O0W0dSpObnLk7iLe5/Hp3bVLVbaT4otShdmXvVvs1dLtoOfEk8UtkrydxC3g6LpYV2vCDq0ipL605f7aXks2jMSMmZDW2QjAwhkeVKvb1WTwO4/i2qsjBriwHU+LrpvLPF7pbsdCuPrQx8F84m0j6kXmj+nQEUSvO9QE+BMeYYluZSAC4MQrVu0E0qkljEyAjb0PmOkLVfM/T0xlTLa8erbi+LIMv9FaR8L5eEIqXj5UMHgECkxzwCtfnyrPI4xosgNEMCDiwC4my7GLrp9yT8zpTUQQkFF5ZsdFoxTvSMd22vANn5N2wfwbNWE2rU5qTOeL97fXmMS5WULNJLrLO6B4FILNjOLwXNcXIGdNfPOpI7i5+yQYkmpCtfk2IzGGXk7wu7F9tETb1MkBzKLGqs04igHS/FHw4oIE3X454SslCnt19x 2025-07-31 21:10:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-07-31 21:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 21:10:03 [INFO]: inside itemsold and closed 14409 2025-07-31 21:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 21:10:05 [INFO]: autolink for user_id 14409 is 1 2025-07-31 21:10:05 [INFO]: Ebay item id :: 335385904904 exists in Database 2025-07-31 21:10:05 [INFO]: Item is reliested :: exists in Database 2025-07-31 21:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 21:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 21:10:05 [INFO]: inside itemsold and closed 14409 2025-07-31 21:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 21:10:07 [INFO]: autolink for user_id 14409 is 1 2025-07-31 21:10:07 [INFO]: Ebay item id :: 335670943478 exists in Database 2025-07-31 21:10:07 [INFO]: Item is reliested :: exists in Database 2025-07-31 21:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 21:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 21:10:07 [INFO]: in processold action queue is array for {"44780550":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44780550","ebayitemid":"335385904904","shopifyproductid":"8476757459166","variants":[{"price":"24.99","quantity":0,"weight":"2","shopifyproductid":"8476757459166","shopifyvariantid":"45344958775518","shopifyinventoryid":"47442908479710","shopifylocationid":"","product_id":"44780550","variant_id":"77689124","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44569697":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44569697","ebayitemid":"335670943478","shopifyproductid":"7931422245086","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"7931422245086","shopifyvariantid":"43899320074462","shopifyinventoryid":"45995478286558","shopifylocationid":"","product_id":"44569697","variant_id":"77462381","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 21:10:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 21:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 21:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 21:10:07 [INFO]: Shopify Inventory id 47442908479710 2025-07-31 21:10:07 [INFO]: Shopify Location id 58450641063 2025-07-31 21:10:07 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 21:10:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T21:10:07Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-07-31 21:10:07 [INFO]: Change: available | Delta: -1 2025-07-31 21:10:07 [INFO]: Change: on_hand | Delta: -1 2025-07-31 21:10:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 21:10:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44780550 and user_id = 14409 2025-07-31 21:10:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77689124 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 21:10:07 [INFO]: Shopify Inventory id 45995478286558 2025-07-31 21:10:07 [INFO]: Shopify Location id 58450641063 2025-07-31 21:10:07 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 21:10:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T21: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-07-31 21:10:08 [INFO]: Change: available | Delta: -1 2025-07-31 21:10:08 [INFO]: Change: on_hand | Delta: -1 2025-07-31 21:10:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 21:10:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44569697 and user_id = 14409 2025-07-31 21:10:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77462381 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 21:10:08 [INFO]: updateIdsQuantity -> ["77689124","77462381"] 2025-07-31 21:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-07-31 21:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77689124 THEN 0 WHEN id = 77462381 THEN 0 END, quantityflag = CASE WHEN id = 77689124 THEN 0 WHEN id = 77462381 THEN 0 END WHERE user_id = 14409 AND id IN (77689124,77462381) 2025-07-31 21:10:08 [INFO]: QUANTITY Updated IDs: 77689124, 77462381 2025-07-31 21:10:08 [INFO]: Successfully processed data for user 14409 2025-07-31 21:10:08 [INFO]: Execution Started 2025-07-31 21:10:08 [INFO]: Execution Finished 2025-07-31 21:20:01 [INFO]: Execution Started 2025-07-31 21:20:01 [INFO]: old server sucessfully connected 2025-07-31 21:20:01 [INFO]: sqs client sucess created 2025-07-31 21:20:02 [INFO]: Number of messages in the queue: 4 2025-07-31 21:20:03 [INFO]: item found in queue is if condition 14409 2025-07-31 21:20:03 [INFO]: item found in queue is 14409 2025-07-31 21:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBfBAa5mmxLZVQjBKd5pWiZiw2HtDl7xCBsEs1GNFyzsrXsT9doCvuMbr6K68YmC+vUVhN964dMfWIGKgc5lOOkNkmfx8ivQWegng2W6QzqSORPxZ0IA2D+5Mq2HmELMk5BICab99RES4kqVJH9K4bMrbWj90cns7+bVZyDIz4BNqGLxUqOok+KSVBzWz6HBovWlo58A5AzHtp1kN/FMzWyInIVxsIACtnn2tFEURDbG8zmz31CVwojyV7+u/92x8aX/eekgHrH00HaEdEJ32ue1AlTjsNoZE1Yv9U9xc1ma9uYl+HLMOK+rHwPy8eLPBmCZBf1xJFQrL+ucoT2ef5cbO/XIm5rFJ4QerLqi8NJWIdU14rDEVmZwD3tlJNWGF+1Sa7Ub6UHlJ+BsHxqd0wnhjpB3dF7jwJ/JzaKwcUjizARp2XtEIsypfrieDPEMdK 2025-07-31 21:20:03 [INFO]: item found in queue is if condition 14409 2025-07-31 21:20:03 [INFO]: item found in queue is 14409 2025-07-31 21:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBoQzIB4DDWeEsoQqxDbq4HCchTIyP3nRu42clOnmX6XSnec9DR2XMeqoFXIOF0rd6Z/G+Ot3vEM0irt1tkvR2R+LP3eJsWsQBC7zagk68idR1urowqDqTicOdJolvl2mY6ffo2//oic9hBib5myvVjvJUqN4Hcwo1cqevhaOkNLBuqUlTPXeFoJMzw25pHvOaFaTV2F/EgSoURv99VmOiYXA3cg8sJOYxcko4vKvKFIhO8j0Y58DYhgiy2RRsroB2P0EtyA3ECEagGUiybcK27jgpzfIkcd3fSaLPWrNgpKS86ew0YruSVzzkGzJuYQyKqJ06hjBEI7u4ZzLTR1NPL8zBRiyA7ILFJP11Dojj5MWizFJGVrf2H6cuXjruK9ZqBNhQ694bTA/BV8GNhbQ+hgKCY7TID4axRZJUdA/0F+Ks3MYa1AVzz/dPxQbQ0VWH 2025-07-31 21:20:04 [INFO]: item found in queue is if condition 14409 2025-07-31 21:20:04 [INFO]: item found in queue is 14409 2025-07-31 21:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBmZDAfhlVpPdjTn862djX2/7Xg0ELNCDzefxlwpJqNWHERS+tGKuI6Fzl4aJthVlNhyUXXmxfC3e1sQYR08ap7NBa/Kylm4vzzWGHkUQzLmwDvAwwE7qYXyVeXA3i78Vbx1EIyXuBqPyrZnaJTRt1Puok/6XL7fevi+6jJTYFK6uDDf0EcYxUbIdrSVVuk1WT1V2R7epS9UUnX/DeHuhwCICp9laHA/8kbHFT2j4Mh4rtUkByM9FEONoXjZiTD1H94ubrIA0cZPBoW0TBJ/dAIVFnqlBCJlT19cAzSN2NYaGIdUq8xUyp8cmNXWqcRrx4QhnC4boiJj+uXf+K1/SiMj1q1e0ubOsaCuGZoGAm0EavMxuwRePg/n86stbY7r4hMIJamE6kcLkAJtgdWhN4kSC+AHxpiJYrXqRp0m3u4RBGFRCVoA5DH1fTZbBOOzhZ 2025-07-31 21:20:04 [INFO]: item found in queue is if condition 14409 2025-07-31 21:20:04 [INFO]: item found in queue is 14409 2025-07-31 21:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBi1s02Gbg5MjZUIt2oTey2UGORLxUJHcAVmoPEbq2iQArvNGtMJs147AgWh/qtkXVhYVKzYdN/FvsxuzR7s7ks/hFRBzOCuha2n9AuSj8u5TOAW84a8ru7hIglfFNMQDLA/yItD9TM1JqHAV6SaI3zK7q2i4fLRAEOSUrQgIVHmYhYChhmxIhM3EGZKybYgeb5yX5xOPm1cMfMviVDaRAI5KAiAKmpYNCSiHlooRIYYcSC3kIFf+Wd5SmSB47r9k5G07E4dTmRLsSBe2Utz9myA3jMZ28cVNbaOMTyrg0Ztj7CkqcQzNekUGZUaMCxA1UYhDNleHokjM0GBPIJqKcBSASZXDY7iLVvIH84km4B4cyS7TSrcONzsF2/ORY7fu6W71Qo+sJZXXIlzo9Pzh52hgdE4QHDYJxMByBIocWkmH4noWVTp0jxNKcYqTjPzap 2025-07-31 21:20:04 [INFO]: Processed 4 messages, reached the limit of 4. 2025-07-31 21:20:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 21:20:04 [INFO]: inside itemsold and closed 14409 2025-07-31 21:20:06 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 21:20:06 [INFO]: autolink for user_id 14409 is 1 2025-07-31 21:20:06 [INFO]: Ebay item id :: 256872291449 exists in Database 2025-07-31 21:20:06 [INFO]: Item is reliested :: exists in Database 2025-07-31 21:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 21:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 21:20:06 [INFO]: inside itemsold and closed 14409 2025-07-31 21:20:08 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 21:20:08 [INFO]: autolink for user_id 14409 is 1 2025-07-31 21:20:08 [INFO]: Ebay item id :: 336025080460 exists in Database 2025-07-31 21:20:08 [INFO]: Item is reliested :: exists in Database 2025-07-31 21:20:08 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-07-31 21:20:08 [INFO]: inside itemsold and closed 14409 2025-07-31 21:20:09 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 21:20:09 [INFO]: autolink for user_id 14409 is 1 2025-07-31 21:20:09 [INFO]: Ebay item id :: 226817937124 exists in Database 2025-07-31 21:20:09 [INFO]: Item is reliested :: exists in Database 2025-07-31 21:20:09 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-07-31 21:20:09 [INFO]: inside itemsold and closed 14409 2025-07-31 21:20:11 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 21:20:11 [INFO]: autolink for user_id 14409 is 1 2025-07-31 21:20:11 [INFO]: Ebay item id :: 405518641966 exists in Database 2025-07-31 21:20:11 [INFO]: Item is reliested :: exists in Database 2025-07-31 21:20:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 21:20:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 21:20:11 [INFO]: in processold action queue is array for {"44683754":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44683754","ebayitemid":"256872291449","shopifyproductid":"8006306562270","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8006306562270","shopifyvariantid":"44126761812190","shopifyinventoryid":"46223628239070","shopifylocationid":"","product_id":"44683754","variant_id":"77588979","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45115574":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45115574","ebayitemid":"336025080460","deleted":1}},"45110898":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45110898","ebayitemid":"226817937124","deleted":1}},"44790551":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44790551","ebayitemid":"405518641966","shopifyproductid":"8926353195230","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8926353195230","shopifyvariantid":"46838054158558","shopifyinventoryid":"48936542208222","shopifylocationid":"58450641063","product_id":"44790551","variant_id":"77700784","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 21:20:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 21:20:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 21:20:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 21:20:11 [INFO]: productIds WHich are having null productid -> [45115574,45110898] 2025-07-31 21:20:11 [INFO]: ebayItemIds WHich are not imported-> ["336025080460","226817937124"] 2025-07-31 21:20:11 [INFO]: Entered in bulkUpdateProducts function 2025-07-31 21:20:11 [INFO]: Transaction started for bulkUpdateProducts 2025-07-31 21:20:11 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45115574,45110898) 2025-07-31 21:20:11 [INFO]: Query executed successfully. Affected rows: 0 2025-07-31 21:20:11 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-07-31 21:20:11 [INFO]: Transaction committed successfully. 2025-07-31 21:20:11 [INFO]: Transaction ended for bulkUpdateProducts 2025-07-31 21:20:11 [INFO]: Shopify Inventory id 46223628239070 2025-07-31 21:20:11 [INFO]: Shopify Location id 58450641063 2025-07-31 21:20:11 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 21:20:11 [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 21:20:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 21:20:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44683754 and user_id = 14409 2025-07-31 21:20:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77588979 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 21:20:11 [INFO]: Shopify Inventory id 48936542208222 2025-07-31 21:20:11 [INFO]: Shopify Location id 58450641063 2025-07-31 21:20:11 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 21:20:12 [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 21:20:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 21:20:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44790551 and user_id = 14409 2025-07-31 21:20:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77700784 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 21:20:12 [INFO]: updateIdsQuantity -> ["77588979","77700784"] 2025-07-31 21:20:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-07-31 21:20:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77588979 THEN 0 WHEN id = 77700784 THEN 0 END, quantityflag = CASE WHEN id = 77588979 THEN 0 WHEN id = 77700784 THEN 0 END WHERE user_id = 14409 AND id IN (77588979,77700784) 2025-07-31 21:20:12 [INFO]: QUANTITY Updated IDs: 77588979, 77700784 2025-07-31 21:20:12 [INFO]: Successfully processed data for user 14409 2025-07-31 21:20:12 [INFO]: Execution Started 2025-07-31 21:20:12 [INFO]: Execution Finished 2025-07-31 21:30:01 [INFO]: Execution Started 2025-07-31 21:30:01 [INFO]: old server sucessfully connected 2025-07-31 21:30:02 [INFO]: sqs client sucess created 2025-07-31 21:30:03 [INFO]: Number of messages in the queue: 0 2025-07-31 21:30:23 [INFO]: Execution Started 2025-07-31 21:30:23 [INFO]: Execution Finished 2025-07-31 21:40:01 [INFO]: Execution Started 2025-07-31 21:40:01 [INFO]: old server sucessfully connected 2025-07-31 21:40:01 [INFO]: sqs client sucess created 2025-07-31 21:40:02 [INFO]: Number of messages in the queue: 0 2025-07-31 21:40:23 [INFO]: Execution Started 2025-07-31 21:40:23 [INFO]: Execution Finished 2025-07-31 21:50:01 [INFO]: Execution Started 2025-07-31 21:50:01 [INFO]: old server sucessfully connected 2025-07-31 21:50:01 [INFO]: sqs client sucess created 2025-07-31 21:50:03 [INFO]: Number of messages in the queue: 1 2025-07-31 21:50:03 [INFO]: item found in queue is if condition 14409 2025-07-31 21:50:03 [INFO]: item found in queue is 14409 2025-07-31 21:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBIMI11vapy+3MrcK3UhzneyD8fUrXOx1/IJqOilOw3b3aQKn7qTZhIEOaiOIuwiE5Iv6Wn3kmd+5yzAmyd6vqnQm9FRAo9VuOIJCZPgA9HMdy+1tZDlmVjAGaye+mPgqu/FIcCn6NqWtFInPn1w9RmE8QjV4Ga2XxQ3uOXyim7QKds1uHeozcZjmyek7y99Css/0jGhsk1ZgSq2R571GByBxSXkLPT2AROQzk+VYa1VJh6ED8Qw8kdkSJjX5kzgkLOB1mUe+5i6tEYuoOLmVcx39HA2ZHYB2zlQybT7Q3y9Sjx526MmEdbfvGHOYy0/fub1SfMxemi+UIlmR50dofVZe9hWjvwl/RUnK5+mvpXbi8NWWkooRcsuFmUdQPvn+eC3qa8gGy62eUYUioZ+AvzAa4C15/ElKg0ILR3KYXXENV+CWSFVwPcjMFYfmJFbZA 2025-07-31 21:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-07-31 21:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 21:50:03 [INFO]: inside itemsold and closed 14409 2025-07-31 21:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 21:50:05 [INFO]: autolink for user_id 14409 is 1 2025-07-31 21:50:05 [INFO]: Ebay item id :: 305556200419 exists in Database 2025-07-31 21:50:05 [INFO]: Item is reliested :: exists in Database 2025-07-31 21:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 21:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 21:50:05 [INFO]: in processold action queue is array for {"44564395":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44564395","ebayitemid":"305556200419","shopifyproductid":"8476647424222","variants":[{"price":"24.99","quantity":0,"weight":"2","shopifyproductid":"8476647424222","shopifyvariantid":"45344245842142","shopifyinventoryid":"47442195546334","shopifylocationid":"","product_id":"44564395","variant_id":"77457075","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 21:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 21:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 21:50:05 [INFO]: Shopify Inventory id 47442195546334 2025-07-31 21:50:05 [INFO]: Shopify Location id 58450641063 2025-07-31 21:50:05 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 21:50:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T21: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-07-31 21:50:05 [INFO]: Change: available | Delta: -1 2025-07-31 21:50:05 [INFO]: Change: on_hand | Delta: -1 2025-07-31 21:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 21:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44564395 and user_id = 14409 2025-07-31 21:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77457075 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 21:50:05 [INFO]: updateIdsQuantity -> ["77457075"] 2025-07-31 21:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-07-31 21:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77457075 THEN 0 END, quantityflag = CASE WHEN id = 77457075 THEN 0 END WHERE user_id = 14409 AND id IN (77457075) 2025-07-31 21:50:05 [INFO]: QUANTITY Updated IDs: 77457075 2025-07-31 21:50:05 [INFO]: Successfully processed data for user 14409 2025-07-31 21:50:05 [INFO]: Execution Started 2025-07-31 21:50:05 [INFO]: Execution Finished