2025-08-14 15:00:01 [INFO]: Execution Started 2025-08-14 15:00:01 [INFO]: old server sucessfully connected 2025-08-14 15:00:01 [INFO]: sqs client sucess created 2025-08-14 15:00:06 [INFO]: Number of messages in the queue: 2 2025-08-14 15:00:08 [INFO]: item found in queue is if condition 14409 2025-08-14 15:00:08 [INFO]: item found in queue is 14409 2025-08-14 15:00:08 [INFO]: Message deleted from the queue for receipt handle: AQEBkBZPspemxndy5lGlrAesZ/Y+lGjwH+53u2JodZXBmVwEAe2Kadyd64sgjIDqtT62PKBMHA1iUMPF1pNAz8jMcusXdg41RpvbrK7w4kT6W/r56Oy0qGouOYaGamyvA4ZiFag6ojRY7UZJ4d+dLTMDG/mKDuDdoyFx0Vvpxtv4cj5CtfQwRfUccrax6AdneE5oRk9IdityXdJZvDs3e3L0eXbje6spyuZ7+vp1FMr4etJw7Ekmxu41GxQL4LQHAh/AwtRVcjUb6u6JrmkzMfPOyg1NCh37hfDWjVwGZeFZoiSMWcheY3qyAt1BeXSz6mNlpIzqdd452qGLUcqefi7ELN8vvROEXxh+azIktUEAIpWkP38hoBnsFQDQqtmjlSk8z/eGxzKWfvoLYPPLHmjQ1QW6/8JdtaxexshXt61bpN2qqiBQmbr/1sIs/RTN5Z9F 2025-08-14 15:00:09 [INFO]: item found in queue is if condition 14409 2025-08-14 15:00:09 [INFO]: item found in queue is 14409 2025-08-14 15:00:21 [INFO]: Message deleted from the queue for receipt handle: AQEB3E/NkWKlHa7ncAY+MjkkAYZ8sD2mnAp0MmZTe88BNm3Fjn1sQ0x2JjWxV18FIfaZBn/BM+uh2mSz3NzVDwroeyo7wPGyArSaFoSw/OX8DVmCetNqVwa5qBMeRysga3iloUJ+9/UnLTGijKiOglRG6cITnkNUEff3Z0J9DgeKNwXqthe5+3SteHjHRmy7LqlWMIVbQkM7+6Wq6hw8jPPbQ50pRUkcX/c87pVm4m0TGTPn14jT72X4BRkvOv7ZkNfFgveJ2PEbD8n/dvoiADxuY7Vai2hui/gz0sDb6+25aWMMKcOcQc89mwkMzv7FOnprqUdqlK2PCmbkkGoJ3/9uVO2PvZGx6f4qPr2oRdOjm3xBDiJlG4VAGXdA/McK2GCZ7YSUN/5BQo14o1d3FrctWMCvFz89Lmz8+EuRuyq3RilrMzNooDb/XgKVHJbEBrHp 2025-08-14 15:00:21 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-14 15:00:21 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 15:00:21 [INFO]: inside itemsold and closed 14409 2025-08-14 15:00:22 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 15:00:22 [INFO]: autolink for user_id 14409 is 1 2025-08-14 15:00:22 [INFO]: Ebay item id :: 286427343333 exists in Database 2025-08-14 15:00:22 [INFO]: Item is reliested :: exists in Database 2025-08-14 15:00:22 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 15:00:22 [INFO]: inside itemsold and closed 14409 2025-08-14 15:00:24 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 15:00:24 [INFO]: autolink for user_id 14409 is 1 2025-08-14 15:00:24 [INFO]: Ebay item id :: 406131610133 exists in Database 2025-08-14 15:00:24 [INFO]: Item is reliested :: exists in Database 2025-08-14 15:00:24 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 15:00:24 [INFO]: in processold action queue is array for [] 2025-08-14 15:00:24 [INFO]: Successfully processed data for user 14409 2025-08-14 15:00:24 [INFO]: Execution Started 2025-08-14 15:00:24 [INFO]: Execution Finished 2025-08-14 15:10:01 [INFO]: Execution Started 2025-08-14 15:10:01 [INFO]: old server sucessfully connected 2025-08-14 15:10:01 [INFO]: sqs client sucess created 2025-08-14 15:10:04 [INFO]: Number of messages in the queue: 0 2025-08-14 15:10:24 [INFO]: Execution Started 2025-08-14 15:10:24 [INFO]: Execution Finished 2025-08-14 15:20:01 [INFO]: Execution Started 2025-08-14 15:20:01 [INFO]: old server sucessfully connected 2025-08-14 15:20:01 [INFO]: sqs client sucess created 2025-08-14 15:20:11 [INFO]: Number of messages in the queue: 2 2025-08-14 15:20:12 [INFO]: item found in queue is if condition 14409 2025-08-14 15:20:12 [INFO]: item found in queue is 14409 2025-08-14 15:20:13 [INFO]: Message deleted from the queue for receipt handle: AQEBIyRieHWQ1h2AHa9YW5GvtJ0ByMxLfyaGbr9bwauPjvDDE/e1gTI5VwSQ2LydZUuyCxahWy3sxIOQB3T+CSGrhX6tZMTVw+9nlDH7SbZHpn3vtrjHiVUe3xmESkQtGSIj4vQMmmteYjRbOJHZQu2VbII8EmdGxP7EEL18YL4A+8tuDZwyvr4vKHLD+dg+H6jHW9yGOGr7nofudQBSH353roV1NvOj3jDNHiIlce3SSMLpJMxuBBeyxuFf15sHLzgTEpAoGUNNV4YPZGagKcfvsl5OMYKgg87k9GYVNa9EVfhLCoS5qveZUz2OouBpxF7qieXPEbhfUQ0c03AkyOsPIJ9SJRUmm6HmcqK5xLcBgYghpfat2lgmwXiOzFEaLxi/x35PKynowQZDhTnH43ITjdMRp1TDJV5ucVTSCTXB472b8SS3Op0/3ygk8qHdoHnP 2025-08-14 15:20:13 [INFO]: item found in queue is if condition 14409 2025-08-14 15:20:13 [INFO]: item found in queue is 14409 2025-08-14 15:20:14 [INFO]: Message deleted from the queue for receipt handle: AQEBR48ydLsEI7w7jrUwqa3r6ZNzqnobGLdnZUeu8TJ5wJ7qVNJ9gKUvQaUVq1xEHaiYBJUvbVVhDbNs5B+psemAgrydqt31m5MJKBxV6W3YKIdGdWrdmH11io2+o0pxPplrIQJrbXHkY4qjnGg8StygdCfBHUjT50BHfa6WmI/QkS8MBCePb8oJJ1NCPoaYExLc0pqF4D6+YJ4y5g/Wv76v2pCK7Pmn7yBndAiz3pWdqvvc3ypBrUdbeJ88JxvVlAKSjpsdF0T8dn1c7pddoQwlRgWMPKDaIamq9P+y6oFVNmLo48nFAUk1cksnij7g83p9/Rices6kvZtMklf1OvTJZZDczVStU8gs2wU1iPxjNiUVVCrf7qk34q7PdGr099Z1i3Xbkop1gFv+VtMxoMooS6qiQ8bJdbzk/FXmEkZiWVMWHKeRZuL6xzLjJtqw3uFA 2025-08-14 15:20:14 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-14 15:20:14 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 15:20:14 [INFO]: inside itemsold and closed 14409 2025-08-14 15:20:16 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 15:20:16 [INFO]: autolink for user_id 14409 is 1 2025-08-14 15:20:16 [INFO]: Ebay item id :: 286747576513 exists in Database 2025-08-14 15:20:16 [INFO]: Item is reliested :: exists in Database 2025-08-14 15:20:16 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 15:20:16 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 15:20:16 [INFO]: inside itemsold and closed 14409 2025-08-14 15:20:17 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 15:20:17 [INFO]: autolink for user_id 14409 is 1 2025-08-14 15:20:17 [INFO]: Ebay item id :: 256845257307 exists in Database 2025-08-14 15:20:17 [INFO]: Item is reliested :: exists in Database 2025-08-14 15:20:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 15:20:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 15:20:17 [INFO]: in processold action queue is array for {"45313163":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313163","ebayitemid":"286747576513","shopifyproductid":"8980016169182","variants":[{"price":"14.99","quantity":0,"weight":"2","shopifyproductid":"8980016169182","shopifyvariantid":"47293301686494","shopifyinventoryid":"49405122248926","shopifylocationid":"58450641063","product_id":"45313163","variant_id":"78265676","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44820172":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44820172","ebayitemid":"256845257307","shopifyproductid":"8838177554654","variants":[{"price":"20.99","quantity":0,"weight":"0.5","shopifyproductid":"8838177554654","shopifyvariantid":"46352376824030","shopifyinventoryid":"48454099992798","shopifylocationid":"","product_id":"44820172","variant_id":"77730735","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 15:20:17 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 15:20:17 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 15:20:17 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 15:20:17 [INFO]: Shopify Inventory id 49405122248926 2025-08-14 15:20:17 [INFO]: Shopify Location id 58450641063 2025-08-14 15:20:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 15:20:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T15:20:17Z","reason":"correction","changes":[{"name":"available","delta":1},{"name":"on_hand","delta":1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1987,"restoreRate":100}}}} 2025-08-14 15:20:18 [INFO]: Change: available | Delta: 1 2025-08-14 15:20:18 [INFO]: Change: on_hand | Delta: 1 2025-08-14 15:20:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 15:20:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313163 and user_id = 14409 2025-08-14 15:20:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265676 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 15:20:18 [INFO]: Shopify Inventory id 48454099992798 2025-08-14 15:20:18 [INFO]: Shopify Location id 58450641063 2025-08-14 15:20:18 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 15:20:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T15:20:18Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1978,"restoreRate":100}}}} 2025-08-14 15:20:18 [INFO]: Change: available | Delta: -1 2025-08-14 15:20:18 [INFO]: Change: on_hand | Delta: -1 2025-08-14 15:20:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 15:20:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44820172 and user_id = 14409 2025-08-14 15:20:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77730735 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 15:20:18 [INFO]: updateIdsQuantity -> ["78265676","77730735"] 2025-08-14 15:20:18 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-14 15:20:18 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78265676 THEN 0 WHEN id = 77730735 THEN 0 END, quantityflag = CASE WHEN id = 78265676 THEN 0 WHEN id = 77730735 THEN 0 END WHERE user_id = 14409 AND id IN (78265676,77730735) 2025-08-14 15:20:18 [INFO]: QUANTITY Updated IDs: 78265676, 77730735 2025-08-14 15:20:18 [INFO]: Successfully processed data for user 14409 2025-08-14 15:20:18 [INFO]: Execution Started 2025-08-14 15:20:18 [INFO]: Execution Finished 2025-08-14 15:30:01 [INFO]: Execution Started 2025-08-14 15:30:01 [INFO]: old server sucessfully connected 2025-08-14 15:30:01 [INFO]: sqs client sucess created 2025-08-14 15:30:05 [INFO]: Number of messages in the queue: 0 2025-08-14 15:30:25 [INFO]: Execution Started 2025-08-14 15:30:25 [INFO]: Execution Finished 2025-08-14 15:40:01 [INFO]: Execution Started 2025-08-14 15:40:01 [INFO]: old server sucessfully connected 2025-08-14 15:40:01 [INFO]: sqs client sucess created 2025-08-14 15:40:06 [INFO]: Number of messages in the queue: 1 2025-08-14 15:40:07 [INFO]: item found in queue is if condition 14409 2025-08-14 15:40:07 [INFO]: item found in queue is 14409 2025-08-14 15:40:07 [INFO]: Message deleted from the queue for receipt handle: AQEBbwh0Jj2Iow8C/kiEUREAY0FdQP4BccBWoDChPgpWO/pg6BPkxCHtOkdxLEDqT5AHhtzrtRq8Y0/6Fnrap2cQ0NBAtJqzli/1GXc1QZswLAAKvgSWz0h5FmI53GsM0vaACd5ZxoUs80vJrcFfw9bwBiYcp3wQ6OiZ9VDGrYDW6dftfc/6PHhhj9BgKApliKsgDFfAfbQu8XsyrE8HZ63O/yzydCP4WTsBvYxzpWL82xuJzf3+nL0KRxGBBwLmDU+Oen4OByF2GSn1MjVVZelw1piXCXFndEbNhtkK3Rp8AkQbuB3QKN7OWz1jhR8oG93Vu6Bcp/K+Fj6uXtkHwB06f01Yp9Q6h+b9hOodq29E8tONZIgX/RfyiSSxTuYEFH+t3Oc/RweylcgxBMvUmb2zzvyUk7thCaCeEb9mEGPx4RBiGgffKrO1jX0dAaRzef42 2025-08-14 15:40:07 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-14 15:40:07 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 15:40:07 [INFO]: inside itemsold and closed 14409 2025-08-14 15:40:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 15:40:09 [INFO]: autolink for user_id 14409 is 1 2025-08-14 15:40:09 [INFO]: Ebay item id :: 286760027849 exists in Database 2025-08-14 15:40:09 [INFO]: Item is reliested :: exists in Database 2025-08-14 15:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 15:40:09 [INFO]: in processold action queue is array for [] 2025-08-14 15:40:09 [INFO]: Successfully processed data for user 14409 2025-08-14 15:40:09 [INFO]: Execution Started 2025-08-14 15:40:09 [INFO]: Execution Finished 2025-08-14 15:50:01 [INFO]: Execution Started 2025-08-14 15:50:01 [INFO]: old server sucessfully connected 2025-08-14 15:50:01 [INFO]: sqs client sucess created 2025-08-14 15:50:11 [INFO]: Number of messages in the queue: 0 2025-08-14 15:50:32 [INFO]: Execution Started 2025-08-14 15:50:32 [INFO]: Execution Finished