2025-08-04 11:00:01 [INFO]: Execution Started 2025-08-04 11:00:01 [INFO]: old server sucessfully connected 2025-08-04 11:00:01 [INFO]: sqs client sucess created 2025-08-04 11:00:02 [INFO]: Number of messages in the queue: 3 2025-08-04 11:00:03 [INFO]: item found in queue is if condition 14409 2025-08-04 11:00:03 [INFO]: item found in queue is 14409 2025-08-04 11:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBHySsK0I+5V5SWICiumqkDkeobxuxpbQd2AEfi6KiYLhwqaSlPv4uwX4nsdjIaOqkBbdWB5s7OoSB7PnGeqXkWvfICQi0hM93hBmyhA2dK8toopk8Izb/jgqO1A3kEilBfqAqkn7ashPf3Mv0bn2OKjMu1fVx/zWqYYnv+sL9MkecCUG7m1/2MhoyIKkoG8mZclX8cDUzJxYHgrvH0rJuKIsiwPyX6nVlXm/Pev62DRVBLBqrSrI6nWXPyA/uDnf8PXp3XbKGpz3u87slpYXOHJvVoIPa8UkzqdxTs1zvRQwswNi9JWq7ZGFVxOJ/reUmKjcOe4fyJx0IXbZwdtPG4zWObK5BXDtidRRE65/GxY49NCha8c2AN9p1sHHzAfODKsMJQttKaaZusVDC6uYodtChOgrkjP2jJaHBm3fJlX9R1YS/iCZ8bTLgYbHFA4kD 2025-08-04 11:00:03 [INFO]: item found in queue is if condition 14409 2025-08-04 11:00:03 [INFO]: item found in queue is 14409 2025-08-04 11:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBQU0l2LGgz+KKH7FUB/fi5+VV4BFmQLVK3gUeJxQlN25+xft45IdToXJLIjfUlED2zSJ3kedcG8q6nwELCJ6qvvrebYVb73/5wiDgJUn6Co2VHKD83WvK9zIzkbnirLfHOVmVG7LFOtNPIzU8OsilDaqqMALLP2B0MMFWF8awGfNCXxT6ld+/6E4NrKsauHJ432455uULbmRENEpepqMtHw9ZbvL+wkKd1NjHYeUVTpCv6qEqC1xz6kTKKb7oq658xX6gtx3nm3S5VF6UAf6nnmAHRMMKm0aYWAv1cYKScmvJAHULp6leNZdXPHomUAD3HraHFu03SJPquf4nzA3fbRy2lgUv8WkxtRjLXbBv6O17wwWHfdbmQsWwR3PwIUGkQEl+fx4iqkPLnEh9tv5l8PF5+nfoJSwV90xfhBvGP7Kw3V/hminoZXUM/5orFDdQ 2025-08-04 11:00:03 [INFO]: item found in queue is if condition 14409 2025-08-04 11:00:03 [INFO]: item found in queue is 14409 2025-08-04 11:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEB88BxjFKlvCuKh+CpjW5FAesYPr/ZCHFfGF1+q+nZVhS8IiEmQCOL0+1QntvY1u+WpR3x303VlEGSTlmK7drjQEGhqHBejmaTPNzwYJzfEBGDpuq7KTRHPkGr98WU3LTLcgJBrFQR3fP0/iMb1WccGwJ2kJcgHN1lFkdJVvO5RX/EyCAxEQNNRIJ1VSFbE5LvJvqKS07PmflsNzj9pxOh6mRt6366G+O9dKH23n25jOqjJjv0DiUQBPaQGOhXL0d0vnMvd9rS+WgfJ69IAHjFi9B4hQQqKxICwf0X6SG+OOxddX3RQDTLEq2ZDGyuecOefMEK1WcOwew3MeD2Wt3BDNufz6JoLndDNR45h8qpYTFQcb0dt09I/gKL8lJA6uitPrzyLFSPUso0Z8j9eKCRl5iDKcA6wY9tEDzcKNkUYUBpzlumEkn1eS9krZmmGOrQ 2025-08-04 11:00:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-04 11:00:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 11:00:04 [INFO]: inside itemsold and closed 14409 2025-08-04 11:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 11:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-04 11:00:05 [INFO]: Ebay item id :: 225079466510 exists in Database 2025-08-04 11:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-04 11:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 11:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 11:00:05 [INFO]: inside itemsold and closed 14409 2025-08-04 11:00:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 11:00:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 11:00:07 [INFO]: Ebay item id :: 325767841471 exists in Database 2025-08-04 11:00:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 11:00:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 11:00:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 11:00:07 [INFO]: inside itemsold and closed 14409 2025-08-04 11:00:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 11:00:09 [INFO]: autolink for user_id 14409 is 1 2025-08-04 11:00:09 [INFO]: Ebay item id :: 325302782659 exists in Database 2025-08-04 11:00:09 [INFO]: Item is reliested :: exists in Database 2025-08-04 11:00:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 11:00:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 11:00:09 [INFO]: in processold action queue is array for {"44655163":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44655163","ebayitemid":"225079466510","shopifyproductid":"8921701351646","variants":[{"price":"17.99","quantity":0,"weight":"0.5","shopifyproductid":"8921701351646","shopifyvariantid":"46809514508510","shopifyinventoryid":"48907994890462","shopifylocationid":"58450641063","product_id":"44655163","variant_id":"77560352","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44733417":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44733417","ebayitemid":"325767841471","shopifyproductid":"8106702733534","variants":[{"price":"12.99","quantity":0,"weight":"0.5","shopifyproductid":"8106702733534","shopifyvariantid":"44304099868894","shopifyinventoryid":"46401518698718","shopifylocationid":"","product_id":"44733417","variant_id":"77641302","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44732106":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44732106","ebayitemid":"325302782659","shopifyproductid":"7758100955358","variants":[{"price":"19.99","quantity":0,"weight":"0.75","shopifyproductid":"7758100955358","shopifyvariantid":"43260077768926","shopifyinventoryid":"45355237081310","shopifylocationid":"","product_id":"44732106","variant_id":"77639991","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 11:00:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 11:00:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 11:00:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 11:00:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 11:00:09 [INFO]: Shopify Inventory id 48907994890462 2025-08-04 11:00:09 [INFO]: Shopify Location id 58450641063 2025-08-04 11:00:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 11:00:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T11:00:09Z","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-04 11:00:09 [INFO]: Change: available | Delta: -1 2025-08-04 11:00:09 [INFO]: Change: on_hand | Delta: -1 2025-08-04 11:00:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 11:00:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44655163 and user_id = 14409 2025-08-04 11:00:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77560352 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 11:00:09 [INFO]: Shopify Inventory id 46401518698718 2025-08-04 11:00:09 [INFO]: Shopify Location id 58450641063 2025-08-04 11:00:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 11:00:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T11: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-04 11:00:10 [INFO]: Change: available | Delta: -1 2025-08-04 11:00:10 [INFO]: Change: on_hand | Delta: -1 2025-08-04 11:00:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 11:00:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44733417 and user_id = 14409 2025-08-04 11:00:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77641302 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 11:00:10 [INFO]: Shopify Inventory id 45355237081310 2025-08-04 11:00:10 [INFO]: Shopify Location id 58450641063 2025-08-04 11:00:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 11:00:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T11: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-04 11:00:10 [INFO]: Change: available | Delta: -1 2025-08-04 11:00:10 [INFO]: Change: on_hand | Delta: -1 2025-08-04 11:00:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 11:00:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44732106 and user_id = 14409 2025-08-04 11:00:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77639991 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 11:00:10 [INFO]: updateIdsQuantity -> ["77560352","77641302","77639991"] 2025-08-04 11:00:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-04 11:00:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77560352 THEN 0 WHEN id = 77641302 THEN 0 WHEN id = 77639991 THEN 0 END, quantityflag = CASE WHEN id = 77560352 THEN 0 WHEN id = 77641302 THEN 0 WHEN id = 77639991 THEN 0 END WHERE user_id = 14409 AND id IN (77560352,77641302,77639991) 2025-08-04 11:00:10 [INFO]: QUANTITY Updated IDs: 77560352, 77641302, 77639991 2025-08-04 11:00:10 [INFO]: Successfully processed data for user 14409 2025-08-04 11:00:10 [INFO]: Execution Started 2025-08-04 11:00:10 [INFO]: Execution Finished 2025-08-04 11:10:01 [INFO]: Execution Started 2025-08-04 11:10:01 [INFO]: old server sucessfully connected 2025-08-04 11:10:01 [INFO]: sqs client sucess created 2025-08-04 11:10:02 [INFO]: Number of messages in the queue: 1 2025-08-04 11:10:02 [INFO]: item found in queue is if condition 14409 2025-08-04 11:10:02 [INFO]: item found in queue is 14409 2025-08-04 11:10:02 [INFO]: Message deleted from the queue for receipt handle: AQEB1mx/hPiXpsJU1KIHjzatm0pXPrF207NGlz6VUa6FAI9IfrqK8MZxMPbLoe06BaaGG0NhuWjPvFgirZoKF/XVVEfwO65qpq3kcM7BmAMbArcPVI8NiUdN5SC2Eg8RupwmG5vKzIh/z8slLWXh+iZ9ZcslYR19l5EXu9bf6Q1jqH7VGLZq+o9bsRsOVxq0Gg0D+UuuKtrpnsdsLDwjgGgoiTiMG+SRL2qPuvUh1nAuq3Ge0pKxpnCjtN3hmkmtYh3N6VxJ81x5++Dre5pLGF2xVBNVJlUdXLpvqx/wK+6lLaCEi3UQdjKXz8fw/diQlsZUsZuM/c/HsQAbFkuFC2Fepp77ztI0sWoQY9hBWeN1ZO57J6WgKybgM23M7unU+4n80bXZYiI8j3Rlin7QWjGuu3nEyCwImvKfvdpybhMQpZbvj8tN9M5GysEjt1G/hXeJ 2025-08-04 11:10:02 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-04 11:10:02 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 11:10:02 [INFO]: inside itemsold and closed 14409 2025-08-04 11:10:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 11:10:04 [INFO]: autolink for user_id 14409 is 1 2025-08-04 11:10:04 [INFO]: Ebay item id :: 325915379385 exists in Database 2025-08-04 11:10:04 [INFO]: Item is reliested :: exists in Database 2025-08-04 11:10:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 11:10:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 11:10:04 [INFO]: in processold action queue is array for {"44733870":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44733870","ebayitemid":"325915379385","shopifyproductid":"8016258990302","variants":[{"price":"11.99","quantity":0,"weight":"1","shopifyproductid":"8016258990302","shopifyvariantid":"44144618176734","shopifyinventoryid":"46241522188510","shopifylocationid":"","product_id":"44733870","variant_id":"77641755","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 11:10:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 11:10:04 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 11:10:04 [INFO]: Shopify Inventory id 46241522188510 2025-08-04 11:10:04 [INFO]: Shopify Location id 58450641063 2025-08-04 11:10:04 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 11:10:04 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T11:10:04Z","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-04 11:10:04 [INFO]: Change: available | Delta: -4 2025-08-04 11:10:04 [INFO]: Change: on_hand | Delta: -4 2025-08-04 11:10:04 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 11:10:04 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44733870 and user_id = 14409 2025-08-04 11:10:04 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77641755 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 11:10:04 [INFO]: updateIdsQuantity -> ["77641755"] 2025-08-04 11:10:04 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-04 11:10:04 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77641755 THEN 0 END, quantityflag = CASE WHEN id = 77641755 THEN 0 END WHERE user_id = 14409 AND id IN (77641755) 2025-08-04 11:10:04 [INFO]: QUANTITY Updated IDs: 77641755 2025-08-04 11:10:04 [INFO]: Successfully processed data for user 14409 2025-08-04 11:10:04 [INFO]: Execution Started 2025-08-04 11:10:04 [INFO]: Execution Finished 2025-08-04 11:20:01 [INFO]: Execution Started 2025-08-04 11:20:01 [INFO]: old server sucessfully connected 2025-08-04 11:20:01 [INFO]: sqs client sucess created 2025-08-04 11:20:02 [INFO]: Number of messages in the queue: 1 2025-08-04 11:20:02 [INFO]: item found in queue is if condition 14409 2025-08-04 11:20:02 [INFO]: item found in queue is 14409 2025-08-04 11:20:02 [INFO]: Message deleted from the queue for receipt handle: AQEB9ctuulgYSfC51s/SGH3xgG3pQnsMkSOR6g30aQi1Zqss8JHro0MMnCSXwCJ6aIYe1JG6HGGPWAhFxID26VPGbRyzO94tZ1OifpVWWyKfcBAc5wmIL9WSu7cJakm2WQ+nhGJ9H5na9wVqeTjS+fP4nk8d0ci5DnZ1Wu12l6yvl++H8B3SGdRBXhgZPZqIR7kQ+48pZkOJyI+enEkvvg37FPAtsmSOTOC1R/OT+d6GdwhohPxnTw5nnKvU+Lzd5zHeg45BAKja7QRni9rw2AwwJ9ZVYtlRK3atp/Ek2YJAaoeX6QBP1ckfJ8qUG2c1MJZ9Cr6wq1VOO0ukBqdR890qsmmn7GDpvDW+8bNQ7Y7en0xRbLkW/6GifiTcvoB3CsZNjHbcSYDoHk+BBz7onzU+AOvXMysjMuxQkx4TtPZ4DEA8SMCVIAyDtQHRZ+ycJqzr 2025-08-04 11:20:02 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-04 11:20:02 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 11:20:02 [INFO]: inside itemsold and closed 14409 2025-08-04 11:20:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 11:20:04 [INFO]: autolink for user_id 14409 is 1 2025-08-04 11:20:04 [INFO]: Ebay item id :: 225907566643 exists in Database 2025-08-04 11:20:04 [INFO]: Item is reliested :: exists in Database 2025-08-04 11:20:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 11:20:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 11:20:04 [INFO]: in processold action queue is array for {"44733922":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44733922","ebayitemid":"225907566643","shopifyproductid":"8228266967262","variants":[{"price":"11.99","quantity":0,"weight":"1","shopifyproductid":"8228266967262","shopifyvariantid":"44585848176862","shopifyinventoryid":"46683813642462","shopifylocationid":"","product_id":"44733922","variant_id":"77641807","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 11:20:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 11:20:04 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 11:20:04 [INFO]: Shopify Inventory id 46683813642462 2025-08-04 11:20:04 [INFO]: Shopify Location id 58450641063 2025-08-04 11:20:04 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 11:20:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T11:20: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-04 11:20:05 [INFO]: Change: available | Delta: -2 2025-08-04 11:20:05 [INFO]: Change: on_hand | Delta: -2 2025-08-04 11:20:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 11:20:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44733922 and user_id = 14409 2025-08-04 11:20:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77641807 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 11:20:05 [INFO]: updateIdsQuantity -> ["77641807"] 2025-08-04 11:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-04 11:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77641807 THEN 0 END, quantityflag = CASE WHEN id = 77641807 THEN 0 END WHERE user_id = 14409 AND id IN (77641807) 2025-08-04 11:20:05 [INFO]: QUANTITY Updated IDs: 77641807 2025-08-04 11:20:05 [INFO]: Successfully processed data for user 14409 2025-08-04 11:20:05 [INFO]: Execution Started 2025-08-04 11:20:05 [INFO]: Execution Finished 2025-08-04 11:30:02 [INFO]: Execution Started 2025-08-04 11:30:02 [INFO]: old server sucessfully connected 2025-08-04 11:30:02 [INFO]: sqs client sucess created 2025-08-04 11:30:03 [INFO]: Number of messages in the queue: 4 2025-08-04 11:30:03 [INFO]: item found in queue is if condition 14409 2025-08-04 11:30:03 [INFO]: item found in queue is 14409 2025-08-04 11:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEB4MzYjWMPMadfECU52I7iU5tSMklLwQPWfbmqFhXftHHIVQltZ/F6GiZURX/RpSIUaqZNkOhjIuhzn5Cn/xJsdeFv+v0IrXISpaSESkH5I3d+6cJ4q8UGFCpsKKmi159I3mbuRBgBYRH/kkJEDlB1yNRTMZspCR6s/u6xYOJwP8g5Csz5tm6qJNQxQTxmqAie3RecxJEyJ0msRk4ZDicuOQ/b3H9KK8dg+wWa22nXfDVTsBUQpAQYu1+Jn965o+F8bFwDKEQY6aUYKB5/NjW14Bk26U0FXDDLgoRrTGLFQe5ICIe5C47Lx+x20V/rOzX3KN5drx4feq7en8RNhSoYVH3p5toxWDiM8v3j6n7ecnIP+hgFqZe9EyIQBHC1Q5qXaH/TFPfxt70RcZm325woh3BaRJsIbyTyZ0w4SEQzWkjHaMK//Lkaxab+/KZ4DvQC 2025-08-04 11:30:04 [INFO]: item found in queue is if condition 14409 2025-08-04 11:30:04 [INFO]: item found in queue is 14409 2025-08-04 11:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBAvNGOmB4r7kTeLJUZOVjICgr87nteKfEEDlMa4J2yIWMGfCnlt1S/4jjJ2WGqilgQqgh1kul4zMJdDOg5LOK8qgmny9gSCylXpo6ARZWZJ6YQUfygu9OttpYNkSdUMT0EWb36/RammnaiwAONj3UBsjru3jpdL8K/D0DaTusqMj1bwZytsubU17UzhENRY9JE9y+G+qR6kQ1Eof2o7eIrG8wI4Lprv0zbRJKQUiTjtCUODSHDn31spHuSVzUsLlsRT1KNaFJG1S4nDUdhNMrtPtPUQwr05AIvGY/J3UU9xKuEEfQi+q0wtJRVMNdVgYz5n92oJUE0GhzVmICdYHPZB8u4797HxfJjrZRUdqQnqQ5jCk9bzEK7A02e8FiAgcSD2ucIcOM5eAXvyHbWAFbgYQaJmoGe7i3qB73o9WlSemPMx/NbMSxqDRSgaFW3/xr 2025-08-04 11:30:04 [INFO]: item found in queue is if condition 14409 2025-08-04 11:30:04 [INFO]: item found in queue is 14409 2025-08-04 11:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBtuhE9xmCT8Ns1N9IwZUtFDqhvT6Kqbt4l2fTBxAV+uSXWyDAcotQo1C8mUzDNmpWQrD3jPZdkmbu1lyO2DFh4PSzhch7DkWCTO5Xsy+8Ckfo+eqrChla+MmlnvIB1TI1dRZnWL0a/De4R7di1tm/7HZk0M1m1eXAIHaiYhvVTbxVQ0jZUp1RczDGZ1HUt3nvX7t5EFQne6JbXKOjyyK8bJyFNTK1bEMesOx15xGC9C3na7VTFT7nmtgg9kN6hTgWcCTBEwmNNQVbyaOYOcyDwpUWNpcfrle1RUN77qaXd0ZE/4tayPhw9+0MUjYAb5BO2o5YB6Z53LT3tXcczvcp8be2KVXWCm6//stdmLYS//mMJM0eThrczSzCwTOYXBgPWXcQYkca+X64Etik6GBIlLXkAXjdMqMJl/u3yRNtTiSNTCFfY/XcTXTTDJauwp1U 2025-08-04 11:30:05 [INFO]: item found in queue is if condition 14409 2025-08-04 11:30:05 [INFO]: item found in queue is 14409 2025-08-04 11:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBUC/uds1LOJ8o5f/LVvYUjZhC5mT7Je6EZ4gMYksjGsDVd5kdEObF5IJZSiLa3Jns3a+kFOBN4crxQRuaoAJHPD8poa49MfPngW7QCCO8PTae9l6AP6bXR62kpG6z4j0avYsR6zwWBozhakHdE9glbcggCFE3CF//UtdKD3agTrj43gUg+YdtPp6aH4+tQeqTZ9c6EFdrZXVtqhUnpNTxwdXQWvyewmveuIsYJuAftPXJjbO68Qon4uv8ESHDWzb7IlVT/Wo5twVDoN4iHAt18wcL6BD3OATq5OW5i8fS7D/5b1TFRkUHgoLY8fKJuQmGsPyHrgP0Vhn7/k39jQIoXTmedU7568tJU+VUC/2Ngw3Fs5IF1TsavUDWKy1nuvx9y4O0NQv5UoezR7vjxPiFljwQ7PTCluhS44CUfE5phXA+tgxjXxReq+5Je77HeqOL 2025-08-04 11:30:05 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-04 11:30:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 11:30:05 [INFO]: inside itemsold and closed 14409 2025-08-04 11:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 11:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 11:30:07 [INFO]: Ebay item id :: 225974454949 exists in Database 2025-08-04 11:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 11:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 11:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 11:30:07 [INFO]: inside itemsold and closed 14409 2025-08-04 11:30:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 11:30:09 [INFO]: autolink for user_id 14409 is 1 2025-08-04 11:30:09 [INFO]: Ebay item id :: 226204148125 exists in Database 2025-08-04 11:30:09 [INFO]: Item is reliested :: exists in Database 2025-08-04 11:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 11:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 11:30:09 [INFO]: inside itemsold and closed 14409 2025-08-04 11:30:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 11:30:10 [INFO]: autolink for user_id 14409 is 1 2025-08-04 11:30:10 [INFO]: Ebay item id :: 226204147544 exists in Database 2025-08-04 11:30:10 [INFO]: Item is reliested :: exists in Database 2025-08-04 11:30:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 11:30:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 11:30:10 [INFO]: inside itemsold and closed 14409 2025-08-04 11:30:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 11:30:12 [INFO]: autolink for user_id 14409 is 1 2025-08-04 11:30:12 [INFO]: Ebay item id :: 225966439638 exists in Database 2025-08-04 11:30:12 [INFO]: Item is reliested :: exists in Database 2025-08-04 11:30:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 11:30:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 11:30:12 [INFO]: in processold action queue is array for {"44675710":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44675710","ebayitemid":"225974454949","shopifyproductid":"7866457391326","variants":[{"price":"17.99","quantity":0,"weight":"0.9375","shopifyproductid":"7866457391326","shopifyvariantid":"43630177779934","shopifyinventoryid":"45725907583198","shopifylocationid":"","product_id":"44675710","variant_id":"77580930","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44663136":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44663136","ebayitemid":"226204148125","shopifyproductid":"8697455771870","variants":[{"price":"24.99","quantity":0,"weight":"0.5","shopifyproductid":"8697455771870","shopifyvariantid":"45939224608990","shopifyinventoryid":"48037681070302","shopifylocationid":"","product_id":"44663136","variant_id":"77568356","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44663133":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44663133","ebayitemid":"226204147544","shopifyproductid":"8699673837790","variants":[{"price":"14.99","quantity":0,"weight":"0.5","shopifyproductid":"8699673837790","shopifyvariantid":"45944518181086","shopifyinventoryid":"48043052663006","shopifylocationid":"","product_id":"44663133","variant_id":"77568353","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44659711":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44659711","ebayitemid":"225966439638","shopifyproductid":"8257325007070","variants":[{"price":"18.99","quantity":0,"weight":"0.75","shopifyproductid":"8257325007070","shopifyvariantid":"44684853313758","shopifyinventoryid":"46782814257374","shopifylocationid":"","product_id":"44659711","variant_id":"77564931","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 11:30:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 11:30:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 11:30:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 11:30:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 11:30:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 11:30:12 [INFO]: Shopify Inventory id 45725907583198 2025-08-04 11:30:12 [INFO]: Shopify Location id 58450641063 2025-08-04 11:30:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 11:30:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T11:30:12Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-04 11:30:12 [INFO]: Change: available | Delta: -1 2025-08-04 11:30:12 [INFO]: Change: on_hand | Delta: -1 2025-08-04 11:30:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 11:30:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44675710 and user_id = 14409 2025-08-04 11:30:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77580930 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 11:30:12 [INFO]: Shopify Inventory id 48037681070302 2025-08-04 11:30:12 [INFO]: Shopify Location id 58450641063 2025-08-04 11:30:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 11:30:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T11:30:12Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-04 11:30:12 [INFO]: Change: available | Delta: -1 2025-08-04 11:30:12 [INFO]: Change: on_hand | Delta: -1 2025-08-04 11:30:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 11:30:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44663136 and user_id = 14409 2025-08-04 11:30:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77568356 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 11:30:12 [INFO]: Shopify Inventory id 48043052663006 2025-08-04 11:30:12 [INFO]: Shopify Location id 58450641063 2025-08-04 11:30:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 11:30:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T11:30:13Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-04 11:30:13 [INFO]: Change: available | Delta: -1 2025-08-04 11:30:13 [INFO]: Change: on_hand | Delta: -1 2025-08-04 11:30:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 11:30:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44663133 and user_id = 14409 2025-08-04 11:30:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77568353 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 11:30:13 [INFO]: Shopify Inventory id 46782814257374 2025-08-04 11:30:13 [INFO]: Shopify Location id 58450641063 2025-08-04 11:30:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 11:30:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T11:30:13Z","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-04 11:30:13 [INFO]: Change: available | Delta: -2 2025-08-04 11:30:13 [INFO]: Change: on_hand | Delta: -2 2025-08-04 11:30:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 11:30:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44659711 and user_id = 14409 2025-08-04 11:30:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77564931 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 11:30:13 [INFO]: updateIdsQuantity -> ["77580930","77568356","77568353","77564931"] 2025-08-04 11:30:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4 2025-08-04 11:30:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77580930 THEN 0 WHEN id = 77568356 THEN 0 WHEN id = 77568353 THEN 0 WHEN id = 77564931 THEN 0 END, quantityflag = CASE WHEN id = 77580930 THEN 0 WHEN id = 77568356 THEN 0 WHEN id = 77568353 THEN 0 WHEN id = 77564931 THEN 0 END WHERE user_id = 14409 AND id IN (77580930,77568356,77568353,77564931) 2025-08-04 11:30:13 [INFO]: QUANTITY Updated IDs: 77580930, 77568356, 77568353, 77564931 2025-08-04 11:30:13 [INFO]: Successfully processed data for user 14409 2025-08-04 11:30:13 [INFO]: Execution Started 2025-08-04 11:30:13 [INFO]: Execution Finished 2025-08-04 11:40:01 [INFO]: Execution Started 2025-08-04 11:40:01 [INFO]: old server sucessfully connected 2025-08-04 11:40:01 [INFO]: sqs client sucess created 2025-08-04 11:40:02 [INFO]: Number of messages in the queue: 2 2025-08-04 11:40:03 [INFO]: item found in queue is if condition 14409 2025-08-04 11:40:03 [INFO]: item found in queue is 14409 2025-08-04 11:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBzHfv0NHk+0/sUZkOpRvSSjfqojgvqTzwzKvw4qJ7kMX0B9AjvWbeIoi7JaOKEE0IJgEy5sparcV5ElP10dfiBYtK4s1/oXTAeGcbPoD/qcVaTCOpgrT+66KC/DTT+Z6P9PU/loBLMOJxwWGkBRoBRUlPCzWkGMS7fbltIJPV8yqiL+JGf3B4UyzEHD48HugIgltI7py/3VNKSaJ4JRZVziv+Flx9WLl8PHSrdDtV1OFhqs3k6G81O3PzrP6op6o1+gkvjDYUf70y0ZFWu0v6v05VVAdR1ByTx1Fl3zmZnv/JsYndqDE/W+983Wd/io6+gvz0G7GHgEYbffQeMij5q6+ai3s6J84X4dmbCC0nnA+DFKBBi+OWQgViQQrPoDS8N0XcHcK1p4K5ky/lGVcr1M8CmD5bcba3B7X38xUUKnrUEYTdeDEd4rOGdnEDAQY4 2025-08-04 11:40:03 [INFO]: item found in queue is if condition 14409 2025-08-04 11:40:03 [INFO]: item found in queue is 14409 2025-08-04 11:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBFd5ilaxobBTW336P3/UatHqRtAcjLhY2mIV0xi7kwhbo9nL6vcSPQn9sQgxpqqdJ7jhO7+n31y2BYYJZIL+fkkuy6v6kbHen/WvO90kWvhcrWFXuBCI7Pgi2D7DOcELxCWeFbLbrDejxG2NfgDqEDYy50Pf6gFZ+FrD8IBxCq07YlgGkEw6jLd8AL/DvitZlvMqms1QuKrUglWWk2AgO+AgVobB+SPsrMY8maEahDZbOLnOJDGYy7DqLmpDHqOPiB3f+TWGxYXHNCwGdWDXnzCvPkkdszem0RhHp6EV9QnwWB7fkvDqwqS60w8itGbyPbOOX1byVJpj3WnegmiNYOv6hdHIxjdV0HVqsjMqsk13U6tgOq7lNfG8HHpQfHVcqYgsDNSDanfRhe4J75ZEMl71MCdxUYbqP0KSwQFdJ2oC1d6bmslfuemtg2puMXeZx 2025-08-04 11:40:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-04 11:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 11:40:04 [INFO]: inside itemsold and closed 14409 2025-08-04 11:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 11:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-04 11:40:05 [INFO]: Ebay item id :: 226416613142 exists in Database 2025-08-04 11:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-04 11:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 11:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 11:40:05 [INFO]: inside itemsold and closed 14409 2025-08-04 11:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 11:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 11:40:07 [INFO]: Ebay item id :: 226416613142 exists in Database 2025-08-04 11:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 11:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 11:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 11:40:07 [INFO]: in processold action queue is array for {"44674651":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44674651","ebayitemid":"226416613142","shopifyproductid":"8106702602462","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8106702602462","shopifyvariantid":"44304099770590","shopifyinventoryid":"46401518600414","shopifylocationid":"","product_id":"44674651","variant_id":"77579871","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 11:40:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 11:40:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 11:40:07 [INFO]: Shopify Inventory id 46401518600414 2025-08-04 11:40:07 [INFO]: Shopify Location id 58450641063 2025-08-04 11:40:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 11:40:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T11:40:07Z","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-04 11:40:07 [INFO]: Change: available | Delta: -2 2025-08-04 11:40:07 [INFO]: Change: on_hand | Delta: -2 2025-08-04 11:40:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 11:40:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44674651 and user_id = 14409 2025-08-04 11:40:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77579871 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 11:40:07 [INFO]: updateIdsQuantity -> ["77579871"] 2025-08-04 11:40:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-04 11:40:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77579871 THEN 0 END, quantityflag = CASE WHEN id = 77579871 THEN 0 END WHERE user_id = 14409 AND id IN (77579871) 2025-08-04 11:40:07 [INFO]: QUANTITY Updated IDs: 77579871 2025-08-04 11:40:07 [INFO]: Successfully processed data for user 14409 2025-08-04 11:40:07 [INFO]: Execution Started 2025-08-04 11:40:07 [INFO]: Execution Finished 2025-08-04 11:50:01 [INFO]: Execution Started 2025-08-04 11:50:01 [INFO]: old server sucessfully connected 2025-08-04 11:50:01 [INFO]: sqs client sucess created 2025-08-04 11:50:02 [INFO]: Number of messages in the queue: 0 2025-08-04 11:50:23 [INFO]: Execution Started 2025-08-04 11:50:23 [INFO]: Execution Finished