2025-08-06 20:00:02 [INFO]: Execution Started 2025-08-06 20:00:02 [INFO]: old server sucessfully connected 2025-08-06 20:00:02 [INFO]: sqs client sucess created 2025-08-06 20:00:03 [INFO]: Number of messages in the queue: 1 2025-08-06 20:00:03 [INFO]: item found in queue is if condition 14409 2025-08-06 20:00:03 [INFO]: item found in queue is 14409 2025-08-06 20:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBwq02Uvycz3LukNh1OmDqfki9AOwa8tVA3uhKD8FUwbE6wDDjaJS5HQXb0jDpE02MEwqWwQcmicJFVQwg8hqw1WmG32wMqbMx0amtHiKkvEk768Tl38PT9tFLNMkbBGdsi0aYVKZ4z+XMExes87xSWlXdMvkhfeUm0al+ArNS9k03iMkLJ+YM66k+Ibw8Ca4lKmiXUz4NBqkKen4uivzxTyqxzMd5V6YNlQEXYTVdTEXfbsrnvFYfOdjAlx8V+MWtmhZMgCp6g5wKCs8CC+2VhFG7EAeFEQYFdHVzq04E7T6h86KYbOI71P77rt/vEKkTatM5w61N/wu9zAkQogf2pXbRBxYfNZfEJ8iwvuFI5mMblAxBWHOSVsJI6jmO1BhGrNSUUwFfGuY7CslIyte7DIGat6yx40ab8LdyeI9wt2z0i7rktlKc8nalK1jvVpBH 2025-08-06 20:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-06 20:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-06 20:00:03 [INFO]: inside itemsold and closed 14409 2025-08-06 20:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 20:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-06 20:00:05 [INFO]: Ebay item id :: 335469022253 exists in Database 2025-08-06 20:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-06 20:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-06 20:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-06 20:00:05 [INFO]: in processold action queue is array for {"44555053":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44555053","ebayitemid":"335469022253","shopifyproductid":"8697448136926","variants":[{"price":"39.99","quantity":0,"weight":"2","shopifyproductid":"8697448136926","shopifyvariantid":"45939213828318","shopifyinventoryid":"48037670289630","shopifylocationid":"","product_id":"44555053","variant_id":"77447733","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-06 20:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-06 20:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-06 20:00:05 [INFO]: Shopify Inventory id 48037670289630 2025-08-06 20:00:05 [INFO]: Shopify Location id 58450641063 2025-08-06 20:00:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-06 20:00:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T20:00: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-06 20:00:05 [INFO]: Change: available | Delta: -1 2025-08-06 20:00:05 [INFO]: Change: on_hand | Delta: -1 2025-08-06 20:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-06 20:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44555053 and user_id = 14409 2025-08-06 20:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77447733 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-06 20:00:05 [INFO]: updateIdsQuantity -> ["77447733"] 2025-08-06 20:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-06 20:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77447733 THEN 0 END, quantityflag = CASE WHEN id = 77447733 THEN 0 END WHERE user_id = 14409 AND id IN (77447733) 2025-08-06 20:00:05 [INFO]: QUANTITY Updated IDs: 77447733 2025-08-06 20:00:05 [INFO]: Successfully processed data for user 14409 2025-08-06 20:00:05 [INFO]: Execution Started 2025-08-06 20:00:05 [INFO]: Execution Finished 2025-08-06 20:10:01 [INFO]: Execution Started 2025-08-06 20:10:01 [INFO]: old server sucessfully connected 2025-08-06 20:10:01 [INFO]: sqs client sucess created 2025-08-06 20:10:02 [INFO]: Number of messages in the queue: 1 2025-08-06 20:10:02 [INFO]: item found in queue is if condition 14409 2025-08-06 20:10:02 [INFO]: item found in queue is 14409 2025-08-06 20:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBE0z5rFQJezIDRxmutGa2GPAxStJe0rHO846lh7MXmfFQJNuC0myxiuVqcfSO3GyTomY7rWZI7ULxqphAe5kprVQVXAOqRoLKpyUGQkvA6g2RS5Mpvi2PwTbSninRKes38mjnWs5OK6BxcRUJacE8/RsD13/PuSPmH6p829/JLuckryZACzonI683n07Fjfl3lA2n/hPM02spNnDcB5PVS3FvAOeWnM1wcSqzZlbd8FoOeESVqZogHKOwmAjb9OA8VvGHUHUxl6iqHucpnzRUzytzHuB+rQdwq+JkvwiN0Haj59vpk5hE04jywQRwssrz0Q64cFV+z+EGIGSGD+UJCQH0KewEAT132psGvGG7rH1OpToGeB4EeI45uubNpgxJTGp7xrfU0w59btBgxOXfKpEquK7jLf7CRpBB1OtPQpN8aq1y4Lax+v59Q1EUIRIn 2025-08-06 20:10:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-06 20:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-06 20:10:03 [INFO]: inside itemsold and closed 14409 2025-08-06 20:10:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 20:10:04 [INFO]: autolink for user_id 14409 is 1 2025-08-06 20:10:04 [INFO]: Ebay item id :: 305675404643 exists in Database 2025-08-06 20:10:04 [INFO]: Item is reliested :: exists in Database 2025-08-06 20:10:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-06 20:10:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-06 20:10:04 [INFO]: in processold action queue is array for {"44573583":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44573583","ebayitemid":"305675404643","shopifyproductid":"8695087825118","variants":[{"price":"179.99","quantity":0,"weight":"2","shopifyproductid":"8695087825118","shopifyvariantid":"45933933986014","shopifyinventoryid":"48032385368286","shopifylocationid":"","product_id":"44573583","variant_id":"77466290","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-06 20:10:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-06 20:10:04 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-06 20:10:04 [INFO]: Shopify Inventory id 48032385368286 2025-08-06 20:10:04 [INFO]: Shopify Location id 58450641063 2025-08-06 20:10:04 [INFO]: QUANTITY FOR UPDATE 0 2025-08-06 20:10:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T20:10:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-06 20:10:05 [INFO]: Change: available | Delta: -1 2025-08-06 20:10:05 [INFO]: Change: on_hand | Delta: -1 2025-08-06 20:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-06 20:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44573583 and user_id = 14409 2025-08-06 20:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77466290 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-06 20:10:05 [INFO]: updateIdsQuantity -> ["77466290"] 2025-08-06 20:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-06 20:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77466290 THEN 0 END, quantityflag = CASE WHEN id = 77466290 THEN 0 END WHERE user_id = 14409 AND id IN (77466290) 2025-08-06 20:10:05 [INFO]: QUANTITY Updated IDs: 77466290 2025-08-06 20:10:05 [INFO]: Successfully processed data for user 14409 2025-08-06 20:10:05 [INFO]: Execution Started 2025-08-06 20:10:05 [INFO]: Execution Finished 2025-08-06 20:20:01 [INFO]: Execution Started 2025-08-06 20:20:01 [INFO]: old server sucessfully connected 2025-08-06 20:20:01 [INFO]: sqs client sucess created 2025-08-06 20:20:02 [INFO]: Number of messages in the queue: 1 2025-08-06 20:20:02 [INFO]: item found in queue is if condition 14409 2025-08-06 20:20:02 [INFO]: item found in queue is 14409 2025-08-06 20:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBwXR6HlzYSBSSrRsIPpzr9sTYaRywSQ3yPvuBMVWYKVVSM+i9EtQLKrI+A4shu5ljOW8oJpE+C1Q7PEA5+EjY+Hse9nn8pRF0o49UVAlfVhCu1uwBV+XdAlGhFApN40ac+NXnqYAsTyBy0c8jIypwiReL3juOYtMhofORO34sTqwbZF6MHDOBshjr2iPt9jYUyPmJRvh4lTcrf9sXELmXLVgZkTy3itMlSjBzm3MkGRhHVKS5KXgswF5UN6+O8+qIJbqLEhTA7kdtZCKqmwd4uWQZEVwomWjx8vFXAozraIGNvsBt+2+26JpEIoaH2rVkj08kRy1mRm8WOlBhXBULrIGyUSTJviqCk+rO/Y6Jy6QE6d7SWHFp1XkIGNHE7SYSmYNKbENG2VfVXqHvaSEmRxStv3qSSU6irCvo1lc+mBUvXmF1TMtqF3b1IQHxjmQG 2025-08-06 20:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-06 20:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-06 20:20:03 [INFO]: inside itemsold and closed 14409 2025-08-06 20:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 20:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-06 20:20:05 [INFO]: Ebay item id :: 305927365616 exists in Database 2025-08-06 20:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-06 20:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-06 20:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-06 20:20:05 [INFO]: in processold action queue is array for {"44587136":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44587136","ebayitemid":"305927365616","shopifyproductid":"8744594866398","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8744594866398","shopifyvariantid":"46099754025182","shopifyinventoryid":"48198584205534","shopifylocationid":"","product_id":"44587136","variant_id":"77479845","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-06 20:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-06 20:20:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-06 20:20:05 [INFO]: Shopify Inventory id 48198584205534 2025-08-06 20:20:05 [INFO]: Shopify Location id 58450641063 2025-08-06 20:20:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-06 20:20:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T20:20:05Z","reason":"correction","changes":[{"name":"available","delta":-3},{"name":"on_hand","delta":-3}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-06 20:20:05 [INFO]: Change: available | Delta: -3 2025-08-06 20:20:05 [INFO]: Change: on_hand | Delta: -3 2025-08-06 20:20:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-06 20:20:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44587136 and user_id = 14409 2025-08-06 20:20:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77479845 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-06 20:20:05 [INFO]: updateIdsQuantity -> ["77479845"] 2025-08-06 20:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-06 20:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77479845 THEN 0 END, quantityflag = CASE WHEN id = 77479845 THEN 0 END WHERE user_id = 14409 AND id IN (77479845) 2025-08-06 20:20:05 [INFO]: QUANTITY Updated IDs: 77479845 2025-08-06 20:20:05 [INFO]: Successfully processed data for user 14409 2025-08-06 20:20:05 [INFO]: Execution Started 2025-08-06 20:20:05 [INFO]: Execution Finished 2025-08-06 20:30:01 [INFO]: Execution Started 2025-08-06 20:30:01 [INFO]: old server sucessfully connected 2025-08-06 20:30:01 [INFO]: sqs client sucess created 2025-08-06 20:30:03 [INFO]: Number of messages in the queue: 1 2025-08-06 20:30:03 [INFO]: item found in queue is if condition 14409 2025-08-06 20:30:03 [INFO]: item found in queue is 14409 2025-08-06 20:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBvZOHhmtP91MMKe/nzxX7pN33zYPJ3fUgNG97u6lMf9RH4wvA1mko38WPLHT856S/m3mLnczXYMIzhhKhNPTMohwtHPJhllQS9pTEPuxit80Na+glqtBzA38ofLl2+Tm39NjYnwaoD9UTb8zm4m8X6bpXxBtPWjZaxoEtUgIZUpLFIgNdsI/6WsdhoAwen3ehiSbUM0sINpp5XoaWWay3aCPBc/nMwB+wKEVwfwcfxCmr+9EHIKYbB5EBVlKxOotg+Jls7zbJQIUpBDwgsHfXl3NfDwDiaegwYmGqwA2RRlCoE1H8lk8uKYBxN5iI/9mjuP7xJTx5FozpU7e1JpzfZWqKj7Tt1/MI6IqWW98uWm5ft1328EXTuhcuR5VF5b4kxxD7YYSTsc4xWEw9g0xuLF5CzLHaGoGVBRgw0LV2CYrC6FJRz7AzDo21h8p6mk7Y 2025-08-06 20:30:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-06 20:30:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-06 20:30:03 [INFO]: inside itemsold and closed 14409 2025-08-06 20:30:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 20:30:05 [INFO]: autolink for user_id 14409 is 1 2025-08-06 20:30:05 [INFO]: Ebay item id :: 305707132154 exists in Database 2025-08-06 20:30:05 [INFO]: Item is reliested :: exists in Database 2025-08-06 20:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-06 20:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-06 20:30:05 [INFO]: in processold action queue is array for {"44554514":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44554514","ebayitemid":"305707132154","shopifyproductid":"8906766254302","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8906766254302","shopifyvariantid":"46685940842718","shopifyinventoryid":"48784192045278","shopifylocationid":"58450641063","product_id":"44554514","variant_id":"77447194","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-06 20:30:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-06 20:30:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-06 20:30:05 [INFO]: Shopify Inventory id 48784192045278 2025-08-06 20:30:05 [INFO]: Shopify Location id 58450641063 2025-08-06 20:30:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-06 20:30:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T20:30:05Z","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-06 20:30:05 [INFO]: Change: available | Delta: -4 2025-08-06 20:30:05 [INFO]: Change: on_hand | Delta: -4 2025-08-06 20:30:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-06 20:30:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44554514 and user_id = 14409 2025-08-06 20:30:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77447194 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-06 20:30:05 [INFO]: updateIdsQuantity -> ["77447194"] 2025-08-06 20:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-06 20:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77447194 THEN 0 END, quantityflag = CASE WHEN id = 77447194 THEN 0 END WHERE user_id = 14409 AND id IN (77447194) 2025-08-06 20:30:05 [INFO]: QUANTITY Updated IDs: 77447194 2025-08-06 20:30:05 [INFO]: Successfully processed data for user 14409 2025-08-06 20:30:05 [INFO]: Execution Started 2025-08-06 20:30:05 [INFO]: Execution Finished 2025-08-06 20:40:01 [INFO]: Execution Started 2025-08-06 20:40:01 [INFO]: old server sucessfully connected 2025-08-06 20:40:01 [INFO]: sqs client sucess created 2025-08-06 20:40:02 [INFO]: Number of messages in the queue: 4 2025-08-06 20:40:03 [INFO]: item found in queue is if condition 14409 2025-08-06 20:40:03 [INFO]: item found in queue is 14409 2025-08-06 20:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBl6bwwrfia9fJ7jez4U+G5uPPqWq1TRNdJ76GPg43nLyLI4KmX74y5J3zk7J/eHBhsuZbxQx+lfzjDHstYwkk80/yN+U8jUBTf9UJU5Qn2KePWqob2GeS/W3F4najp5jMPeQsO9WMk41ZIJYt1SEgHMq7H+yIpfNDC4m+qGBXuRk7rCyAVXFY3rEdKq9ZhAh2KD2cISy5k8qHAj3QiApDpEeH3hrdPJwlL7btgUXjeciwRu65jtVkN9wlk3VJoWTcJpJgBBFU6wfd3fKFjWE/JsDKjfL1Drx4NOdUE+8S/bSTEsF6SLwgBnCilXaUWS3ZJSjXIVg1mCGtU/gbX0VqvgxALoecJez1dD4/5lcnjcqjqmTGtjuwjqsDHC/7150airYBsX4KA+Cg1hBhjGjLSrwPPGfzvte3D69kouAXzC3KM6LgYnrmiqChS1mZGB2G 2025-08-06 20:40:03 [INFO]: item found in queue is if condition 14409 2025-08-06 20:40:03 [INFO]: item found in queue is 14409 2025-08-06 20:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEB2om0LldBZSpSlQO+Noz2C+jI5CHAhqp8DpiVOa44nmV+oqVl+iR1WFJnqX+A6HT7lf1xmGPqrDFYRULj1CkTyZUrD9+OaRUjyRdC/20manXg7f9TM+8CsF66kBiBO9lqwVM1uFnSn/Qzd9rwrjNtRi7MqMSVihW5DU1gFwz48WoiyGSOlh74TnaBFrXEfrQAWjpWjbLprExVinwS3cDfndx0TmqzWGTZhTNWH10B5tCbptVbl25LzWQC8l+09n4AxfWEaVp1f0FhgZD8vU7MjgKvuOT/qjTLrK3NZr2/EwDioo8F3b9T+vvRjsCVfRtwtYdZo3AT5xuxpaQFT4RPqf5ytYpmGz0lgQTt95HRe5S/DdW/PF3QMFfZktida2htj0NkjCQj2/nO8tn5M9daGw93R+nfI+o0u0ThRvET/SV7Lp6Wqg8/xwqaUWwdgI2U 2025-08-06 20:40:04 [INFO]: item found in queue is if condition 14409 2025-08-06 20:40:04 [INFO]: item found in queue is 14409 2025-08-06 20:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEB9DjxgjBZKnE451fsjhcXZYmellVLxLrmEwMP2jf3clqCGcFaIF5Nq9BDbB2qiSqymc1MSdR8LMD9NgqKhuNtn/weaRGMZ3hQsrBSJss5mweDxRwkE4lsMeCVaZWGR6ISqZDTHgqtqXKY9w59Smi4Nsm9jfZgIpX5Hlx+D5N8IMMXBdRZbsAc25cOqad8n4In2f36YfncLBYljJcXyVMBTtLE2WPWa9rlgKO2Le/i7Pp63072ZFOEAM2/jY85eaL/FQPlEmJ88vgZEzDwFouJc4HjxVZmX2vY67ieyRXbnrNLIzWh7mtJO9fzd34G5QDEu2SZ+Dm72l2a5IDIlFDatomqbt4HGhQ5mLGJR/xjIiBqkgy49TT75nG/kTpTKKfMHRUJf9ZN/Hv8iVIP73d/IBLOUucRfmm0tr2xiC4sK42Bd9ZB4kDKVumIdWjALxsI 2025-08-06 20:40:04 [INFO]: item found in queue is if condition 14409 2025-08-06 20:40:04 [INFO]: item found in queue is 14409 2025-08-06 20:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBhDq15+5kjVA99sAtt6Gz3dhNC+LkON8Q9PDMlH5j5QQzAc81GL54k3XS/CDbOxspkZ3W6E+XQ6V3IwUzy9FnI0+qC3sF52DK1aT40DmGVlY14eTcTkQSt/eKLWKLm37U5zkzWiJc4XeJ9o6clMsoVSVOO3GQYvslbVyTEbE+n1HShB47GMf0R1bDILM5xUc1qWkvuAB8OymtUEtUGHfHKJm4RYvvKq4iAXnoS/mW1s4w/RWjQKWxCtjhfpuEAt76rJeTm5B/1K5Ve6/i8ia9Nu01OJoWu5nXqqGjwMFayvA1rrTBlUZ8S3SqGVekiyiEVQHWfkXsjv1xhQr8QBOn6R8vf2BNlg5E5IgmShc4dv5yIID3IL7hE0Q1kqRpGOKATA8zbADQ1nBIC+smqxPbxMZof+cT5bHR+LuYyggyBUfyNMwFzwOERjeUbDy997ac 2025-08-06 20:40:04 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-06 20:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-06 20:40:04 [INFO]: inside itemsold and closed 14409 2025-08-06 20:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 20:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-06 20:40:07 [INFO]: Ebay item id :: 326686290291 exists in Database 2025-08-06 20:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-06 20:40:07 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-06 20:40:07 [INFO]: inside itemsold and closed 14409 2025-08-06 20:40:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 20:40:08 [INFO]: autolink for user_id 14409 is 1 2025-08-06 20:40:08 [INFO]: Ebay item id :: 285974664277 exists in Database 2025-08-06 20:40:08 [INFO]: Item is reliested :: exists in Database 2025-08-06 20:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-06 20:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-06 20:40:08 [INFO]: inside itemsold and closed 14409 2025-08-06 20:40:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 20:40:10 [INFO]: autolink for user_id 14409 is 1 2025-08-06 20:40:10 [INFO]: not in db for user_id 14409 and the ebayitemid257043814817 2025-08-06 20:40:10 [INFO]: inside itemsold and closed 14409 2025-08-06 20:40:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 20:40:12 [INFO]: autolink for user_id 14409 is 1 2025-08-06 20:40:12 [INFO]: Ebay item id :: 285974664277 exists in Database 2025-08-06 20:40:12 [INFO]: Item is reliested :: exists in Database 2025-08-06 20:40:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-06 20:40:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-06 20:40:12 [INFO]: in processold action queue is array for {"45223749":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45223749","ebayitemid":"326686290291","deleted":1}},"44639254":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44639254","ebayitemid":"285974664277","shopifyproductid":"8696069357790","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8696069357790","shopifyvariantid":"45936110764254","shopifyinventoryid":"48034559688926","shopifylocationid":"","product_id":"44639254","variant_id":"77544443","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-06 20:40:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-06 20:40:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-06 20:40:12 [INFO]: productIds WHich are having null productid -> [45223749] 2025-08-06 20:40:12 [INFO]: ebayItemIds WHich are not imported-> ["326686290291"] 2025-08-06 20:40:12 [INFO]: Entered in bulkUpdateProducts function 2025-08-06 20:40:12 [INFO]: Transaction started for bulkUpdateProducts 2025-08-06 20:40:12 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45223749) 2025-08-06 20:40:12 [INFO]: Query executed successfully. Affected rows: 0 2025-08-06 20:40:12 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-06 20:40:12 [INFO]: Transaction committed successfully. 2025-08-06 20:40:12 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-06 20:40:12 [INFO]: Shopify Inventory id 48034559688926 2025-08-06 20:40:12 [INFO]: Shopify Location id 58450641063 2025-08-06 20:40:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-06 20:40:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T20:40:12Z","reason":"correction","changes":[{"name":"available","delta":-3},{"name":"on_hand","delta":-3}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-06 20:40:12 [INFO]: Change: available | Delta: -3 2025-08-06 20:40:12 [INFO]: Change: on_hand | Delta: -3 2025-08-06 20:40:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-06 20:40:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44639254 and user_id = 14409 2025-08-06 20:40:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77544443 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-06 20:40:12 [INFO]: updateIdsQuantity -> ["77544443"] 2025-08-06 20:40:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-06 20:40:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77544443 THEN 0 END, quantityflag = CASE WHEN id = 77544443 THEN 0 END WHERE user_id = 14409 AND id IN (77544443) 2025-08-06 20:40:12 [INFO]: QUANTITY Updated IDs: 77544443 2025-08-06 20:40:12 [INFO]: Successfully processed data for user 14409 2025-08-06 20:40:12 [INFO]: Execution Started 2025-08-06 20:40:12 [INFO]: Execution Finished 2025-08-06 20:50:01 [INFO]: Execution Started 2025-08-06 20:50:01 [INFO]: old server sucessfully connected 2025-08-06 20:50:02 [INFO]: sqs client sucess created 2025-08-06 20:50:03 [INFO]: Number of messages in the queue: 1 2025-08-06 20:50:03 [INFO]: item found in queue is if condition 14409 2025-08-06 20:50:03 [INFO]: item found in queue is 14409 2025-08-06 20:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBrovw3Z/LMSy9SwNm+/tU2EJevmH5ySgjBN8CFUAdZNDZs9LKAqAedqVF/vDYVbuXFMhuXr1+fwzMvOxangDiii9G/izdfY3E2oHrsA51Rwk9ezvEvPxq3Xzl/8zVCAufXWf2qq54ukl17UeRR6ivbgk4k6v6Ws22KRIpX/TN+qwiOLpz0D38rr10L5BuVAGHInHh923pT2jzfJAGR2TO+mP3jfRY2xfgdM+fP0h3Icz/XP7KFtNhKvX5WFf63uuj5Xb8+LE7/Ct59NsVXfhRLzbK409RAwyLtPI6qJLWbkEzMeV7zTVcQad1ee/FKLqTDVaRu2TSeUkncKQHPNieMQT5yHpWGXUWYEwBYbtpqlrznvZgSktN7nzs0T38DMhnvQU3Pp26PCvIXFJgnjSa4RnO8nn6dFU5wNI8Gg8DMpboI+2gXkU3Hr9JhAv43VLq 2025-08-06 20:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-06 20:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-06 20:50:03 [INFO]: inside itemsold and closed 14409 2025-08-06 20:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 20:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-06 20:50:05 [INFO]: Ebay item id :: 335510703279 exists in Database 2025-08-06 20:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-06 20:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-06 20:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-06 20:50:05 [INFO]: in processold action queue is array for {"44598402":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44598402","ebayitemid":"335510703279","shopifyproductid":"8695054663902","variants":[{"price":"414.99","quantity":0,"weight":"2","shopifyproductid":"8695054663902","shopifyvariantid":"45933868908766","shopifyinventoryid":"48032320291038","shopifylocationid":"","product_id":"44598402","variant_id":"77491111","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-06 20:50:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-06 20:50:06 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-06 20:50:06 [INFO]: Shopify Inventory id 48032320291038 2025-08-06 20:50:06 [INFO]: Shopify Location id 58450641063 2025-08-06 20:50:06 [INFO]: QUANTITY FOR UPDATE 0 2025-08-06 20:50:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T20:50:06Z","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-06 20:50:06 [INFO]: Change: available | Delta: -1 2025-08-06 20:50:06 [INFO]: Change: on_hand | Delta: -1 2025-08-06 20:50:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-06 20:50:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44598402 and user_id = 14409 2025-08-06 20:50:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77491111 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-06 20:50:06 [INFO]: updateIdsQuantity -> ["77491111"] 2025-08-06 20:50:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-06 20:50:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77491111 THEN 0 END, quantityflag = CASE WHEN id = 77491111 THEN 0 END WHERE user_id = 14409 AND id IN (77491111) 2025-08-06 20:50:06 [INFO]: QUANTITY Updated IDs: 77491111 2025-08-06 20:50:06 [INFO]: Successfully processed data for user 14409 2025-08-06 20:50:06 [INFO]: Execution Started 2025-08-06 20:50:06 [INFO]: Execution Finished