2025-08-09 16:00:01 [INFO]: Execution Started 2025-08-09 16:00:01 [INFO]: old server sucessfully connected 2025-08-09 16:00:01 [INFO]: sqs client sucess created 2025-08-09 16:00:02 [INFO]: Number of messages in the queue: 1 2025-08-09 16:00:03 [INFO]: item found in queue is if condition 14409 2025-08-09 16:00:03 [INFO]: item found in queue is 14409 2025-08-09 16:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBWt+zpFUwQmGp7VAD5aZw4EpyJ+od62ETpcJLgpX6GWQgwu6pQF/gVu4b7RTBAYnuDrimBsufzpBMe91xrcO2lMQwTLLIfmRB09sTzRdlGR1pvbT29JC2IHcnOPZnvjHXqA/V2pVjuDn/4jpw5E1sqUZqn3K0q6CLp7tnzsSYdDgvvEop+d3AJV1Gmgq9PXH0aa2W1S/7qRWjScJWDCrskLLma10PlyJpp4rvpQ4LxyZnjTDkFb6yUNAHSuGhFHlhex88Um8gvJcJ56GSEFSq/gvTSQdCOQxASydo5N0I7l6ZXC0mAoQkI5IdI6BGy8oZX5DG+ciidVHhTiUETgVjNzvZ/85pYSxlo7Nvyn9oV/89aZjzyLzcOE4PK20RHrtKcSV4QNM5Xt0VZjY2DxT/CCB15ww9Z7tc5cugtg+uHN7W361qVo8wkFwQ5GCnl9pc 2025-08-09 16:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-09 16:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-09 16:00:03 [INFO]: inside itemsold and closed 14409 2025-08-09 16:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-09 16:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-09 16:00:05 [INFO]: Ebay item id :: 286209627663 exists in Database 2025-08-09 16:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-09 16:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-09 16:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-09 16:00:05 [INFO]: in processold action queue is array for {"44777416":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44777416","ebayitemid":"286209627663","shopifyproductid":"8917800354014","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8917800354014","shopifyvariantid":"46726778912990","shopifyinventoryid":"48825268240606","shopifylocationid":"58450641063","product_id":"44777416","variant_id":"77685958","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-09 16:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-09 16:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-09 16:00:05 [INFO]: Shopify Inventory id 48825268240606 2025-08-09 16:00:05 [INFO]: Shopify Location id 58450641063 2025-08-09 16:00:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-09 16:00:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-09T16: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-09 16:00:05 [INFO]: Change: available | Delta: -1 2025-08-09 16:00:05 [INFO]: Change: on_hand | Delta: -1 2025-08-09 16:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-09 16:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44777416 and user_id = 14409 2025-08-09 16:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685958 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-09 16:00:05 [INFO]: updateIdsQuantity -> ["77685958"] 2025-08-09 16:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-09 16:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77685958 THEN 0 END, quantityflag = CASE WHEN id = 77685958 THEN 0 END WHERE user_id = 14409 AND id IN (77685958) 2025-08-09 16:00:05 [INFO]: QUANTITY Updated IDs: 77685958 2025-08-09 16:00:06 [INFO]: Successfully processed data for user 14409 2025-08-09 16:00:06 [INFO]: Execution Started 2025-08-09 16:00:06 [INFO]: Execution Finished 2025-08-09 16:10:01 [INFO]: Execution Started 2025-08-09 16:10:01 [INFO]: old server sucessfully connected 2025-08-09 16:10:01 [INFO]: sqs client sucess created 2025-08-09 16:10:03 [INFO]: Number of messages in the queue: 0 2025-08-09 16:10:23 [INFO]: Execution Started 2025-08-09 16:10:23 [INFO]: Execution Finished 2025-08-09 16:20:01 [INFO]: Execution Started 2025-08-09 16:20:01 [INFO]: old server sucessfully connected 2025-08-09 16:20:01 [INFO]: sqs client sucess created 2025-08-09 16:20:03 [INFO]: Number of messages in the queue: 1 2025-08-09 16:20:03 [INFO]: item found in queue is if condition 14409 2025-08-09 16:20:03 [INFO]: item found in queue is 14409 2025-08-09 16:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEB1SQJmfNQ5ksf0284xPA+ugdTCCjEfjiO16wSApJU+q6CrMJsxzKCv7odjKtmKVGqsdmNKHThNipdBW4d4lWpZlQtzSIiAxMzm93b272VOOd4R4tpcfbF/KpnbX2+3tzKn9X3sbNeHjn0aXlsyJLxXfRwbngTaRw3zNVFlh2i7nhz1HSHhXGg6qAghrkBCEFyraeu1OxAwE74MjSjJTWIpJy8yJe2H6DtFiS9ZjJT3m1kuABAuIUsJH/jABl9VEx4v07NFBMcl4W0uQD5wNgJW36BLipsXHEKGL6D9IBHl/rztTdL/8t49aojOAwzuyriuBqVcEEuDKTNsn8vgacseqQjC0uYZjn8E8g6+spfkSfPYkIkykQYknuYgedXnptiKzlBVJMicqq/UEkdaWwHsE8J9gPoWnQKgxfJdoxh/3Ljxwh4Ur7A/2LEbSwYgP+8 2025-08-09 16:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-09 16:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-09 16:20:03 [INFO]: inside itemsold and closed 14409 2025-08-09 16:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-09 16:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-09 16:20:05 [INFO]: Ebay item id :: 326595776786 exists in Database 2025-08-09 16:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-09 16:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-09 16:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-09 16:20:05 [INFO]: in processold action queue is array for {"44858354":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44858354","ebayitemid":"326595776786","shopifyproductid":"8927181209822","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8927181209822","shopifyvariantid":"46846582653150","shopifyinventoryid":"48958027301086","shopifylocationid":"58450641063","product_id":"44858354","variant_id":"77769435","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-09 16:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-09 16:20:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-09 16:20:05 [INFO]: Shopify Inventory id 48958027301086 2025-08-09 16:20:05 [INFO]: Shopify Location id 58450641063 2025-08-09 16:20:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-09 16:20:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-09T16:20: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-09 16:20:06 [INFO]: Change: available | Delta: -1 2025-08-09 16:20:06 [INFO]: Change: on_hand | Delta: -1 2025-08-09 16:20:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-09 16:20:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44858354 and user_id = 14409 2025-08-09 16:20:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77769435 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-09 16:20:06 [INFO]: updateIdsQuantity -> ["77769435"] 2025-08-09 16:20:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-09 16:20:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77769435 THEN 0 END, quantityflag = CASE WHEN id = 77769435 THEN 0 END WHERE user_id = 14409 AND id IN (77769435) 2025-08-09 16:20:06 [INFO]: QUANTITY Updated IDs: 77769435 2025-08-09 16:20:06 [INFO]: Successfully processed data for user 14409 2025-08-09 16:20:06 [INFO]: Execution Started 2025-08-09 16:20:06 [INFO]: Execution Finished 2025-08-09 16:30:01 [INFO]: Execution Started 2025-08-09 16:30:01 [INFO]: old server sucessfully connected 2025-08-09 16:30:01 [INFO]: sqs client sucess created 2025-08-09 16:30:04 [INFO]: Number of messages in the queue: 1 2025-08-09 16:30:05 [INFO]: item found in queue is if condition 14409 2025-08-09 16:30:05 [INFO]: item found in queue is 14409 2025-08-09 16:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBNYN2jiSooxw1Ghit1FyFHKTj2E4Igk5Uydws0kmeXvBdekmuSyjaKgAKgvSWao1YyVsnyQg1m06chrYXMsUbmpTAnBq+aN6iJ7tD0PC9TDUQeDgvVkJ+3WBVbx20P7Y13+IRBOOkAO3DKqhWt9pux1Xz/pKYnsNBCstU/5qf+YZQjDPJkQcoAV6EpLOjMnPXWXFL/XLMve/gjuVpIZk0k6KIbW0r7GLe65GvLvTVkqn5iQePSOEHfjgzepvgOOOaoVSOXBq4Gij44lKlKRvgN74f8dzL+u0ufdFUZ22XIi0kKAGmiIzvZ8wun4ZPCVgzTyUZXNPxpysdi7jVxhglYg2KCnFYAmuGa2S770FXS7A/z5bJNP7Zn16Zj1jDgIGU9K9zWzPYuT7mNddx0gm7ofCCB/rTYVHktqeTZ540wR8mTklxRmbcH3iLHZ7yh3sS 2025-08-09 16:30:05 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-09 16:30:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-09 16:30:05 [INFO]: inside itemsold and closed 14409 2025-08-09 16:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-09 16:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-09 16:30:07 [INFO]: Ebay item id :: 305875077773 exists in Database 2025-08-09 16:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-09 16:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-09 16:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-09 16:30:07 [INFO]: in processold action queue is array for {"44598861":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44598861","ebayitemid":"305875077773","shopifyproductid":"8721899159774","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8721899159774","shopifyvariantid":"46001304273118","shopifyinventoryid":"48099720954078","shopifylocationid":"","product_id":"44598861","variant_id":"77491570","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-09 16:30:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-09 16:30:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-09 16:30:07 [INFO]: Shopify Inventory id 48099720954078 2025-08-09 16:30:07 [INFO]: Shopify Location id 58450641063 2025-08-09 16:30:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-09 16:30:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-09T16:30: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-08-09 16:30:07 [INFO]: Change: available | Delta: -1 2025-08-09 16:30:07 [INFO]: Change: on_hand | Delta: -1 2025-08-09 16:30:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-09 16:30:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44598861 and user_id = 14409 2025-08-09 16:30:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77491570 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-09 16:30:07 [INFO]: updateIdsQuantity -> ["77491570"] 2025-08-09 16:30:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-09 16:30:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77491570 THEN 0 END, quantityflag = CASE WHEN id = 77491570 THEN 0 END WHERE user_id = 14409 AND id IN (77491570) 2025-08-09 16:30:07 [INFO]: QUANTITY Updated IDs: 77491570 2025-08-09 16:30:07 [INFO]: Successfully processed data for user 14409 2025-08-09 16:30:07 [INFO]: Execution Started 2025-08-09 16:30:07 [INFO]: Execution Finished 2025-08-09 16:40:01 [INFO]: Execution Started 2025-08-09 16:40:01 [INFO]: old server sucessfully connected 2025-08-09 16:40:01 [INFO]: sqs client sucess created 2025-08-09 16:40:03 [INFO]: Number of messages in the queue: 0 2025-08-09 16:40:24 [INFO]: Execution Started 2025-08-09 16:40:24 [INFO]: Execution Finished 2025-08-09 16:42:15 [INFO]: Execution Started 2025-08-09 16:42:15 [INFO]: old server sucessfully connected 2025-08-09 16:42:15 [INFO]: sqs client sucess created 2025-08-09 16:42:17 [INFO]: Number of messages in the queue: 0 2025-08-09 16:42:37 [INFO]: Execution Started 2025-08-09 16:42:37 [INFO]: Execution Finished 2025-08-09 16:42:44 [INFO]: Execution Started 2025-08-09 16:42:44 [INFO]: old server sucessfully connected 2025-08-09 16:42:44 [INFO]: sqs client sucess created 2025-08-09 16:42:47 [INFO]: Number of messages in the queue: 0 2025-08-09 16:43:07 [INFO]: Execution Started 2025-08-09 16:43:07 [INFO]: Execution Finished 2025-08-09 16:50:01 [INFO]: Execution Started 2025-08-09 16:50:01 [INFO]: old server sucessfully connected 2025-08-09 16:50:01 [INFO]: sqs client sucess created 2025-08-09 16:50:04 [INFO]: Number of messages in the queue: 1 2025-08-09 16:50:04 [INFO]: item found in queue is if condition 14409 2025-08-09 16:50:04 [INFO]: item found in queue is 14409 2025-08-09 16:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEBz8DaklejSfYB83bN5efsoQvGLOZKjiBsRam5jdIQhMDN4qlbALXKLvdDgFeBavwYympWutPaP0Zp7VMXUGxkbGL7HUp2V5eaPeOpA58uHGhidlKuMLefszW86k8UsVyJ1Zad2WFLgliwaDUHnmXrYHjuted2yGWe2xcVMj/xC5fewuN8voNcZ3GpbiZn0qW1N7/o8xqdrUVDB9g6HU/jRAK5p9Baq0KzN5+5wu3CK9o7Ou2XnZ3jDIn40vT4YtliDSef266okW+v8qXRMHLrDt1/h3x46yFjtljkzbw46gNavk7RNH/9fkSJ9DAJvYopSmPmVdULuVZA0qyuJmsnAeVfIVdqS2OJEm1iD3vgybH0AjtbLwzc+/HmwrKeXSzbWMe8WQha0PPzdYW9flBMhLguW2ZgAaTHtZPBT2HeJwDxcdLX3qMZYxtFpVtjEmbZ 2025-08-09 16:50:05 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-09 16:50:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-09 16:50:05 [INFO]: inside itemsold and closed 14409 2025-08-09 16:50:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-09 16:50:06 [INFO]: autolink for user_id 14409 is 1 2025-08-09 16:50:06 [INFO]: Ebay item id :: 326210093849 exists in Database 2025-08-09 16:50:06 [INFO]: Item is reliested :: exists in Database 2025-08-09 16:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-09 16:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-09 16:50:06 [INFO]: in processold action queue is array for {"44673755":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44673755","ebayitemid":"326210093849","shopifyproductid":"8694976938206","variants":[{"price":"99.99","quantity":0,"weight":"3","shopifyproductid":"8694976938206","shopifyvariantid":"45933686587614","shopifyinventoryid":"48032137773278","shopifylocationid":"","product_id":"44673755","variant_id":"77578975","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-09 16:50:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-09 16:50:06 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-09 16:50:06 [INFO]: Shopify Inventory id 48032137773278 2025-08-09 16:50:06 [INFO]: Shopify Location id 58450641063 2025-08-09 16:50:06 [INFO]: QUANTITY FOR UPDATE 0 2025-08-09 16:50:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-09T16:50: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-08-09 16:50:07 [INFO]: Change: available | Delta: -1 2025-08-09 16:50:07 [INFO]: Change: on_hand | Delta: -1 2025-08-09 16:50:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-09 16:50:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44673755 and user_id = 14409 2025-08-09 16:50:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77578975 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-09 16:50:07 [INFO]: updateIdsQuantity -> ["77578975"] 2025-08-09 16:50:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-09 16:50:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77578975 THEN 0 END, quantityflag = CASE WHEN id = 77578975 THEN 0 END WHERE user_id = 14409 AND id IN (77578975) 2025-08-09 16:50:07 [INFO]: QUANTITY Updated IDs: 77578975 2025-08-09 16:50:07 [INFO]: Successfully processed data for user 14409 2025-08-09 16:50:07 [INFO]: Execution Started 2025-08-09 16:50:07 [INFO]: Execution Finished