2025-07-31 14:00:01 [INFO]: Execution Started 2025-07-31 14:00:01 [INFO]: old server sucessfully connected 2025-07-31 14:00:01 [INFO]: sqs client sucess created 2025-07-31 14:00:04 [INFO]: Number of messages in the queue: 1 2025-07-31 14:00:05 [INFO]: item found in queue is if condition 14409 2025-07-31 14:00:05 [INFO]: item found in queue is 14409 2025-07-31 14:00:06 [INFO]: Message deleted from the queue for receipt handle: AQEBP51O2KT7DdEsP+jmZt5qHjOLjPKy/8klxxGWW9Br1xzbHQAhY6rA8XFK9kIEh8IxfyXEh6IBcmQQCQ+BK2TLuzx4sTXrJXmUPk+UaskaKbsebeWxbLSLdoFi3g1LLMi38KPsdhtDqgL7MchjHMoIsALP8ZmtjPOUt4iI2LTflYFwsnjlhB7GtRIJh1GSQDLodaFhiGxVdsB8haftb+cywLNEDepYdOkBpp69U0ziTHJWgxOAyiqahfjSWWbM8rSg2SNw9mCiWKEw37MXnTYH6oabRLjUXeJdEDQQy8QxhHRmU0D5AulSXJV82h59JPtfHDjUcRUyuPHyzPaGiPFiqBzfKx8MFvzvEUswSn1xI7yifSWuT6ww8PCdW9GQrZaDcsyJRBchHHiBqt6CCouwVEB91tXn/8QSuwTFJYFdYPMm7xvVUnNUGXKkG6ioODRX 2025-07-31 14:00:06 [INFO]: Processed 1 messages, reached the limit of 1. 2025-07-31 14:00:06 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 14:00:06 [INFO]: inside itemsold and closed 14409 2025-07-31 14:00:07 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 14:00:07 [INFO]: autolink for user_id 14409 is 1 2025-07-31 14:00:07 [INFO]: Ebay item id :: 256745970193 exists in Database 2025-07-31 14:00:07 [INFO]: Item is reliested :: exists in Database 2025-07-31 14:00:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 14:00:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 14:00:07 [INFO]: in processold action queue is array for {"44777350":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44777350","ebayitemid":"256745970193","shopifyproductid":"8066485289182","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"8066485289182","shopifyvariantid":"44237418234078","shopifyinventoryid":"46334553161950","shopifylocationid":"","product_id":"44777350","variant_id":"77685892","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 14:00:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 14:00:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 14:00:07 [INFO]: Shopify Inventory id 46334553161950 2025-07-31 14:00:07 [INFO]: Shopify Location id 58450641063 2025-07-31 14:00:07 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 14:00:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T14:00: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 14:00:08 [INFO]: Change: available | Delta: -1 2025-07-31 14:00:08 [INFO]: Change: on_hand | Delta: -1 2025-07-31 14:00:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 14:00:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44777350 and user_id = 14409 2025-07-31 14:00:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685892 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 14:00:08 [INFO]: updateIdsQuantity -> ["77685892"] 2025-07-31 14:00:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-07-31 14:00:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77685892 THEN 0 END, quantityflag = CASE WHEN id = 77685892 THEN 0 END WHERE user_id = 14409 AND id IN (77685892) 2025-07-31 14:00:08 [INFO]: QUANTITY Updated IDs: 77685892 2025-07-31 14:00:08 [INFO]: Successfully processed data for user 14409 2025-07-31 14:00:08 [INFO]: Execution Started 2025-07-31 14:00:08 [INFO]: Execution Finished 2025-07-31 14:10:01 [INFO]: Execution Started 2025-07-31 14:10:01 [INFO]: old server sucessfully connected 2025-07-31 14:10:01 [INFO]: sqs client sucess created 2025-07-31 14:10:05 [INFO]: Number of messages in the queue: 3 2025-07-31 14:10:05 [INFO]: item found in queue is if condition 14409 2025-07-31 14:10:05 [INFO]: item found in queue is 14409 2025-07-31 14:10:07 [INFO]: Message deleted from the queue for receipt handle: AQEBL0tSjA8Ea/+CuofQvZh2dSIljhXvv0qCrzvgQID7erC8GnDBiYuJ+UjGJ9N0vHz20xGrYyAYHIIyKwsdqK3vloNgFmH6ChBjBSyeT1YHnJt15isttiIU910pGxIfRzoEdpFmSmZIT75CGTAYejJgTYr2KchPAdWCQEtv+zImX6nRZy7Cc183FyFhXChmITKfsdRfhhhrbPQ/aq8adEac4qKv8Ha+Iq6SdocOe+4boVTxBNEsnMtBpa59FpBTGuyNSgr55Nb/WxJrie5GaHDHeV2uuVfvTVZFI4+BmrpHDo2jLzaBgys/x3n9ur8OEBDOA9O28wUz1H7adnSPqhvWwGV6ELd8dTIS5QQmjynfVUv6nVBjS1eJwWjediO+EF8fpOKkR3mbTwYLCNYkmqqDZ19sAZGpJdWj/AKthf5uS1rmp1ITXqON4PBA7CVCyIFg 2025-07-31 14:10:07 [INFO]: item found in queue is if condition 14409 2025-07-31 14:10:07 [INFO]: item found in queue is 14409 2025-07-31 14:10:08 [INFO]: Message deleted from the queue for receipt handle: AQEBCrDMokS6yaGEd8rxWlyYp3vkqCzMxLBysh61bvLTSnHAvaI0nMPntKbi4ptezG+x3VtxTzsYMtn2uSJZvAPBMmf4nHtdO2YNhoXjge7sATv7VSPYO0EuKJX9HYw+wnVRiMbW6aTFwSOEybtRV9QMekY9bF4VgdefaoHI5miwwrfptUXixDcoxMD6OtUDoK3ndj5oJ3jp/j4eFcGXgzMRBKlHr0z1D6eIUOrgRL5ol26Yj7DhqHePYI3vBJSUBu1bojrOBt1iZCO3VNlLulUDfOxXvE3wtulxkVIVfrAqx37g6NzAeOaedxeFs3mXGIetIbKYnQyt+CY5giswi5i3q4RmNW+q4OYsFybK5AEzTNb9NkIoYlOCX+WoOYAVp+j8gEQgIYuv0yoBcaX3rjVS08NbvuIuGq6TRG8NqrERG3DDmkeJMkFSzUuMpDsCLBK2 2025-07-31 14:10:08 [INFO]: item found in queue is if condition 14409 2025-07-31 14:10:08 [INFO]: item found in queue is 14409 2025-07-31 14:10:09 [INFO]: Message deleted from the queue for receipt handle: AQEBhnAoKSKyJcJKk8UobSIG5j1SzsdEH4LgoYKSDpnxe6kNNtJr6vVOG3ApdMhUVb6sSlYW1IMVOrKX0j7AKaapCBLKs//Cs16S+TnPpdJyF/UjdU3EqCPmoQMyqG36HAqZR3Ac/GpYKBVa5NcvNHtYSkvKd9PbjfWhRriE+qK9hBNcYlynylvqogtoFRg0EoKnfp+Ze74ZyQwfl+JYi9CLhNCVhlDVUzEUA2XHBoVf6dDQr821H+eo4RVgP4DqDmF/bilWkUiwq7Gno487yCmypNDS6JOLeM8WZPpKZsiTiwC4cumM1ALJXJI4XlN44uMJjUzddvWmm8SiJtUPLk/+mPVfsh0kmvBOhoXRALjIUssm4ymjVnsJLXit6eSM2PWwsAl55Y2fFKR/sAToZFz/Qe4HkzNi+XT6RkT4dZyTSe99J1Ir8A4HjVbAf48G2Ijn 2025-07-31 14:10:09 [INFO]: Processed 3 messages, reached the limit of 3. 2025-07-31 14:10:09 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 14:10:09 [INFO]: inside itemsold and closed 14409 2025-07-31 14:10:10 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 14:10:10 [INFO]: autolink for user_id 14409 is 1 2025-07-31 14:10:10 [INFO]: Ebay item id :: 256745990129 exists in Database 2025-07-31 14:10:10 [INFO]: Item is reliested :: exists in Database 2025-07-31 14:10:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 14:10:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 14:10:10 [INFO]: inside itemsold and closed 14409 2025-07-31 14:10:12 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 14:10:12 [INFO]: autolink for user_id 14409 is 1 2025-07-31 14:10:12 [INFO]: Ebay item id :: 405411852398 exists in Database 2025-07-31 14:10:12 [INFO]: Item is reliested :: exists in Database 2025-07-31 14:10:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 14:10:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 14:10:12 [INFO]: inside itemsold and closed 14409 2025-07-31 14:10:14 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 14:10:14 [INFO]: autolink for user_id 14409 is 1 2025-07-31 14:10:14 [INFO]: Ebay item id :: 326514319668 exists in Database 2025-07-31 14:10:14 [INFO]: Item is reliested :: exists in Database 2025-07-31 14:10:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 14:10:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 14:10:14 [INFO]: in processold action queue is array for {"44777362":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44777362","ebayitemid":"256745990129","shopifyproductid":"8143314616542","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"8143314616542","shopifyvariantid":"44376584945886","shopifyinventoryid":"46474374349022","shopifylocationid":"","product_id":"44777362","variant_id":"77685904","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44777360":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44777360","ebayitemid":"405411852398","shopifyproductid":"8143300690142","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"8143300690142","shopifyvariantid":"44376543101150","shopifyinventoryid":"46474332438750","shopifylocationid":"","product_id":"44777360","variant_id":"77685902","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44712047":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44712047","ebayitemid":"326514319668","shopifyproductid":"7872979140830","variants":[{"price":"19.99","quantity":0,"weight":"1","shopifyproductid":"7872979140830","shopifyvariantid":"43658407608542","shopifyinventoryid":"45754182861022","shopifylocationid":"","product_id":"44712047","variant_id":"77619660","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 14:10:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 14:10:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 14:10:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 14:10:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 14:10:14 [INFO]: Shopify Inventory id 46474374349022 2025-07-31 14:10:14 [INFO]: Shopify Location id 58450641063 2025-07-31 14:10:14 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 14:10:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T14:10:14Z","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 14:10:14 [INFO]: Change: available | Delta: -1 2025-07-31 14:10:14 [INFO]: Change: on_hand | Delta: -1 2025-07-31 14:10:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 14:10:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44777362 and user_id = 14409 2025-07-31 14:10:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685904 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 14:10:14 [INFO]: Shopify Inventory id 46474332438750 2025-07-31 14:10:14 [INFO]: Shopify Location id 58450641063 2025-07-31 14:10:14 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 14:10:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T14:10:14Z","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 14:10:14 [INFO]: Change: available | Delta: -1 2025-07-31 14:10:14 [INFO]: Change: on_hand | Delta: -1 2025-07-31 14:10:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 14:10:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44777360 and user_id = 14409 2025-07-31 14:10:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685902 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 14:10:14 [INFO]: Shopify Inventory id 45754182861022 2025-07-31 14:10:14 [INFO]: Shopify Location id 58450641063 2025-07-31 14:10:14 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 14:10:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T14:10:14Z","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 14:10:15 [INFO]: Change: available | Delta: 1 2025-07-31 14:10:15 [INFO]: Change: on_hand | Delta: 1 2025-07-31 14:10:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 14:10:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44712047 and user_id = 14409 2025-07-31 14:10:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77619660 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 14:10:15 [INFO]: updateIdsQuantity -> ["77685904","77685902","77619660"] 2025-07-31 14:10:15 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-07-31 14:10:15 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77685904 THEN 0 WHEN id = 77685902 THEN 0 WHEN id = 77619660 THEN 0 END, quantityflag = CASE WHEN id = 77685904 THEN 0 WHEN id = 77685902 THEN 0 WHEN id = 77619660 THEN 0 END WHERE user_id = 14409 AND id IN (77685904,77685902,77619660) 2025-07-31 14:10:15 [INFO]: QUANTITY Updated IDs: 77685904, 77685902, 77619660 2025-07-31 14:10:15 [INFO]: Successfully processed data for user 14409 2025-07-31 14:10:15 [INFO]: Execution Started 2025-07-31 14:10:15 [INFO]: Execution Finished 2025-07-31 14:20:02 [INFO]: Execution Started 2025-07-31 14:20:02 [INFO]: old server sucessfully connected 2025-07-31 14:20:02 [INFO]: sqs client sucess created 2025-07-31 14:20:05 [INFO]: Number of messages in the queue: 5 2025-07-31 14:20:09 [INFO]: item found in queue is if condition 14409 2025-07-31 14:20:09 [INFO]: item found in queue is 14409 2025-07-31 14:20:09 [INFO]: Message deleted from the queue for receipt handle: AQEBGOWPs+FrLQ4yH+QaBjKhMM9N+OVXh723rvbIwP0hzYWfN5dorgS9Lel6bPeIDsdyzYqHLT3M6xkL6xZWpZB33KiyZ+hWZf0Y/iaQ9NI+83jsthy0Dm8Jcgvnt3BpLnLTuEBYl4sUGbYhbTeA/Q5CW0Jlj4SVdglqfKYzcW75Ugj3cOHPxEKFS+/tUfNQpu/aoKs8PZVF5mKF3YFfSoGJYIOQNeULZie1FcnxIWsiGTHsCOi9YMtftRScEWM4JwTMhHWgKODXqvHHX3VTNoXxvHx0NARAtU4ckxYZRshvfcbzdGFqzNe3FiIoLYeL5kX8vJfkPrFLQfPHE/c6XrXHWFSjPc0F3TNpxAm9TtkkzSVzFNaPfWKY73yP+m9Gg7Q+HG2Z6b1XAYhRj9DoZZSkmJo0xa2HWIfPEoLG3CU09vANTaXNxNfrdgdIyDKNZTlQ 2025-07-31 14:20:13 [INFO]: item found in queue is if condition 14409 2025-07-31 14:20:13 [INFO]: item found in queue is 14409 2025-07-31 14:20:13 [INFO]: Message deleted from the queue for receipt handle: AQEBjSHStSs+nKDaaIKmhkFtVWg2PWG19LkUhK0gn7moKymh+cl3SlZJWma9Hx+IVeG0+D1HR3f6p+o9C16bpoqjwlxMQ/s/ZatgIH8r/ivlqB4Xoxb9OJHhZvZrhRYIKZzc7DNiuzaM9y7msj5X/GjvL1nfmv2ZC6z9/T0q+eKemZLG+hK/EXgKfCLwSkV9oVMgWgKi0N4c/gMcrs4MSRH0DZfsJ9fXYDEq504TRw2emwl7LT2E5r7nW5tuKTTdish7sGJwG5az22EzTsTQLhrgpxcMc8TvUi+cYDVV5Pc/kEPLbqWlu8rpOh6i+T2hPNp39Jq2/dUTdP3zbSjbKD30o8RVwvMViCSYW8dyO9tlo4IQvU7aqD9wq6y95lv0NIxG7AhKNoB0FtXZ9JJaFTVAG/N451bqlOj1TqSw4XyMVQnQGp0tJAKRkNji3cMAo1/w 2025-07-31 14:20:17 [INFO]: item found in queue is if condition 14409 2025-07-31 14:20:17 [INFO]: item found in queue is 14409 2025-07-31 14:20:21 [INFO]: Message deleted from the queue for receipt handle: AQEBBwAUtNine7evAvhX0RaTZNvcP8NPmOWaESZzuLROlE9zj3XO/h/1YDbBSrn2aVPwCQl1njnaWmWFnxcSx7o4/gTK2zYPKalK7Pvm+timVG/roBM3aVBy+QQXxNz2osRkbMvZrI3aO+p8J/pc+7jhc/VDFv+DPVXWmoeS05+XuuPniajE05Qg4UkwOnY2uTQor21QapDavuHDi6bvoGZr59lMZboCPBr3/vDL3oPoi/MSgYPja0QHnbSZbKLl0EkGKNarcC/hGAAGaOWG84ycV/orK7zEDAInEZ6EakT3gy3wqVuiRTgzTP4UsugHRKmvt/CiJCfuXdoB2BxOO+yXUO/mjGmSMPWixEIQpra0T3WxP9k+2CsjTpRFzOph1My7QFgNAlGzPmnb67X6o3/o/y2nBlgYqE3f2jv6R9GAmqvPZaP+Fvx6/aT3/QMcSEHv 2025-07-31 14:20:31 [INFO]: item found in queue is if condition 14409 2025-07-31 14:20:31 [INFO]: item found in queue is 14409 2025-07-31 14:20:32 [INFO]: Message deleted from the queue for receipt handle: AQEBLLrXVKSnX09uc1SmAv7HlQBitZFJ9mKpgiJQYSKzhJTOrpkfDIPK52WonwKWz0EGlNqKhLWcNe8+Up0cegpuJOUZlP+frY8KCTZ+cIVzZpYCSTm+c3sBfia6KcnorQV8kfDASfQLQ5CqRORFp9WEiySsr/WeyavWSoCViK+E1czQz//PF5G3imgrGabMCzVvJIKLHCHQ7g8ATHDVRogCbvReddUvCr0g13EiwYx7FtLdbQ1yiumFrKR9YR2gSIq8EXlSQi3aikctyxFyjPJQUo1UUWaGqLlf3cP0j0E7/NP9ucHhyhsbb3MVYaCeB908QBceQw5Zzp8WXQ8fQ3mHjhHRvcIEWeXChH5Trbu7zY4EOa1AdEcFXNK+JRMZ+AwOR02XS/8IGWt4mJ6hYqyBZYc1B2hie6v0f0dpKKrB2mkMCNrSSD5P73rhiFuQHMIO 2025-07-31 14:20:32 [INFO]: item found in queue is if condition 14409 2025-07-31 14:20:32 [INFO]: item found in queue is 14409 2025-07-31 14:20:32 [INFO]: Message deleted from the queue for receipt handle: AQEBak2FQwb1YMcp6Op4nhPcm1msm/z12NozETxfA/JgwNBCI2fpMq6Ekeec3TUwhncFAwrA9AYlkgTSdfFrd6M5+3WO914bRKR9I5LX7W6BYmRUR87+OTMvYo1qkQzcsCz0n99GLEMSyqevbhPv0TerRkvedZ0tOd7clN0XAQbosLvPHI0GuhYvdnXiLx4VuJ9q8ZkBSVeyG7PBBUBsVlM3hmukDskd01BE68Qg6MIxyNdRNTugQz19TjJQjt7txJhuW4FXXvxA0P/sEJTCvarUKsfpypJ4F8EJEfkxUT9VZ+Sjj18ie9pnvnRXabHIjMXHNb78dQBCggdQi+seQp2V1/f0dRI1RRo/HRFo6kookcMBNJ46ADo9cl4cf2FmvjmYIDyo/gmdrpgzFBuMp8ziK1BR4tm8jcPVuwRdQ1sYMED6opVxnANwerNCiqBBAGj+ 2025-07-31 14:20:32 [INFO]: Processed 5 messages, reached the limit of 5. 2025-07-31 14:20:32 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 14:20:32 [INFO]: inside itemsold and closed 14409 2025-07-31 14:20:34 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 14:20:34 [INFO]: autolink for user_id 14409 is 1 2025-07-31 14:20:34 [INFO]: Ebay item id :: 225170594238 exists in Database 2025-07-31 14:20:34 [INFO]: Item is reliested :: exists in Database 2025-07-31 14:20:34 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 14:20:34 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 14:20:34 [INFO]: inside itemsold and closed 14409 2025-07-31 14:20:36 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 14:20:36 [INFO]: autolink for user_id 14409 is 1 2025-07-31 14:20:36 [INFO]: Ebay item id :: 405411869585 exists in Database 2025-07-31 14:20:36 [INFO]: Item is reliested :: exists in Database 2025-07-31 14:20:36 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 14:20:36 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 14:20:36 [INFO]: inside itemsold and closed 14409 2025-07-31 14:20:38 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 14:20:38 [INFO]: autolink for user_id 14409 is 1 2025-07-31 14:20:38 [INFO]: Ebay item id :: 405411875946 exists in Database 2025-07-31 14:20:38 [INFO]: Item is reliested :: exists in Database 2025-07-31 14:20:38 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 14:20:38 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 14:20:38 [INFO]: inside itemsold and closed 14409 2025-07-31 14:20:39 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 14:20:39 [INFO]: autolink for user_id 14409 is 1 2025-07-31 14:20:39 [INFO]: Ebay item id :: 256671542374 exists in Database 2025-07-31 14:20:39 [INFO]: Item is reliested :: exists in Database 2025-07-31 14:20:39 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 14:20:39 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 14:20:39 [INFO]: inside itemsold and closed 14409 2025-07-31 14:20:41 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 14:20:41 [INFO]: autolink for user_id 14409 is 1 2025-07-31 14:20:41 [INFO]: Ebay item id :: 286402659285 exists in Database 2025-07-31 14:20:41 [INFO]: Item is reliested :: exists in Database 2025-07-31 14:20:41 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 14:20:41 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 14:20:41 [INFO]: in processold action queue is array for {"44660722":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44660722","ebayitemid":"225170594238","shopifyproductid":"7805662068958","variants":[{"price":"15.99","quantity":0,"weight":"0.5","shopifyproductid":"7805662068958","shopifyvariantid":"43422604067038","shopifyinventoryid":"45517993607390","shopifylocationid":"","product_id":"44660722","variant_id":"77565942","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44777364":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44777364","ebayitemid":"405411869585","shopifyproductid":"8148886159582","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"8148886159582","shopifyvariantid":"44394130145502","shopifyinventoryid":"46491928035550","shopifylocationid":"","product_id":"44777364","variant_id":"77685906","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44777365":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44777365","ebayitemid":"405411875946","shopifyproductid":"8212315439326","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"8212315439326","shopifyvariantid":"44539046559966","shopifyinventoryid":"46636999377118","shopifylocationid":"","product_id":"44777365","variant_id":"77685907","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44776094":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44776094","ebayitemid":"256671542374","shopifyproductid":"8702052761822","variants":[{"price":"29.99","quantity":0,"weight":"3","shopifyproductid":"8702052761822","shopifyvariantid":"45950655234270","shopifyinventoryid":"48049233002718","shopifylocationid":"","product_id":"44776094","variant_id":"77684636","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44893096":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44893096","ebayitemid":"286402659285","shopifyproductid":"8929165082846","variants":[{"price":"134.99","quantity":0,"weight":"3","shopifyproductid":"8929165082846","shopifyvariantid":"46853198577886","shopifyinventoryid":"48964636049630","shopifylocationid":"58450641063","product_id":"44893096","variant_id":"77808227","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 14:20:41 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 14:20:41 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 14:20:41 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 14:20:41 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 14:20:41 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 14:20:41 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 14:20:41 [INFO]: Shopify Inventory id 45517993607390 2025-07-31 14:20:41 [INFO]: Shopify Location id 58450641063 2025-07-31 14:20:41 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 14:20:41 [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 14:20:41 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 14:20:41 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44660722 and user_id = 14409 2025-07-31 14:20:41 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77565942 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 14:20:41 [INFO]: Shopify Inventory id 46491928035550 2025-07-31 14:20:41 [INFO]: Shopify Location id 58450641063 2025-07-31 14:20:41 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 14:20:42 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T14:20:42Z","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 14:20:42 [INFO]: Change: available | Delta: -1 2025-07-31 14:20:42 [INFO]: Change: on_hand | Delta: -1 2025-07-31 14:20:42 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 14:20:42 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44777364 and user_id = 14409 2025-07-31 14:20:42 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685906 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 14:20:42 [INFO]: Shopify Inventory id 46636999377118 2025-07-31 14:20:42 [INFO]: Shopify Location id 58450641063 2025-07-31 14:20:42 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 14:20:42 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T14:20:42Z","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 14:20:42 [INFO]: Change: available | Delta: -1 2025-07-31 14:20:42 [INFO]: Change: on_hand | Delta: -1 2025-07-31 14:20:42 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 14:20:42 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44777365 and user_id = 14409 2025-07-31 14:20:42 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685907 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 14:20:42 [INFO]: Shopify Inventory id 48049233002718 2025-07-31 14:20:42 [INFO]: Shopify Location id 58450641063 2025-07-31 14:20:42 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 14:20:42 [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 14:20:42 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 14:20:42 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44776094 and user_id = 14409 2025-07-31 14:20:42 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77684636 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 14:20:42 [INFO]: Shopify Inventory id 48964636049630 2025-07-31 14:20:42 [INFO]: Shopify Location id 58450641063 2025-07-31 14:20:42 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 14:20:42 [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 14:20:42 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 14:20:42 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44893096 and user_id = 14409 2025-07-31 14:20:42 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77808227 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 14:20:42 [INFO]: updateIdsQuantity -> ["77565942","77685906","77685907","77684636","77808227"] 2025-07-31 14:20:42 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 5. Affected rows: 5 2025-07-31 14:20:42 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77565942 THEN 0 WHEN id = 77685906 THEN 0 WHEN id = 77685907 THEN 0 WHEN id = 77684636 THEN 0 WHEN id = 77808227 THEN 0 END, quantityflag = CASE WHEN id = 77565942 THEN 0 WHEN id = 77685906 THEN 0 WHEN id = 77685907 THEN 0 WHEN id = 77684636 THEN 0 WHEN id = 77808227 THEN 0 END WHERE user_id = 14409 AND id IN (77565942,77685906,77685907,77684636,77808227) 2025-07-31 14:20:42 [INFO]: QUANTITY Updated IDs: 77565942, 77685906, 77685907, 77684636, 77808227 2025-07-31 14:20:42 [INFO]: Successfully processed data for user 14409 2025-07-31 14:20:42 [INFO]: Execution Started 2025-07-31 14:20:42 [INFO]: Execution Finished 2025-07-31 14:30:02 [INFO]: Execution Started 2025-07-31 14:30:02 [INFO]: old server sucessfully connected 2025-07-31 14:30:02 [INFO]: sqs client sucess created 2025-07-31 14:30:03 [INFO]: Number of messages in the queue: 1 2025-07-31 14:30:03 [INFO]: item found in queue is if condition 14409 2025-07-31 14:30:03 [INFO]: item found in queue is 14409 2025-07-31 14:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBq4Q1aG2MZwQkItTaansEp7NHPZonFOWRBpknDEf0m5I/lB+rqHcd0vY7fVKDHfmrETSHMN/E+n8oWU4PX4AvWFQqafVyfoJyo9Tj93Rtd8wnQ2hyeMYP04HX250KFDiatzxm5HiwvUZpTLca8Qn6RddnX1LOGGxW/ZCvZxE1HkecUk7OdQA2zlsRBkpKK291R+3szS7a16nppEJVKIWr8Ejpw8Zv5/cnJcqe+duX1W+yKXcdReQFh+oDNxJB/wboxxSOqva54UZltSacheZBt1zJDLJA8JT2lkmtMJKWr4MK7fycgK8S9FQOVSgO+dSK99IvD0dpFU4JcPtKKkFnas4vynvwvTXVrs1wnlO5bBEkdVRE96uDgTIf92rO9IMkH2kNwlC5ilUnjVewYZd4sCotQ6D8WweI1E+gaviggNFSOMfDQJCQzL6XZ4zV/k/4 2025-07-31 14:30:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-07-31 14:30:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 14:30:03 [INFO]: inside itemsold and closed 14409 2025-07-31 14:30:05 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 14:30:05 [INFO]: autolink for user_id 14409 is 1 2025-07-31 14:30:05 [INFO]: Ebay item id :: 286163183066 exists in Database 2025-07-31 14:30:05 [INFO]: Item is reliested :: exists in Database 2025-07-31 14:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 14:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 14:30:05 [INFO]: in processold action queue is array for {"44642772":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44642772","ebayitemid":"286163183066","shopifyproductid":"7993098830046","variants":[{"price":"35.99","quantity":0,"weight":"2","shopifyproductid":"7993098830046","shopifyvariantid":"44093128573150","shopifyinventoryid":"46189926219998","shopifylocationid":"","product_id":"44642772","variant_id":"77547961","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 14:30:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 14:30:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 14:30:05 [INFO]: Shopify Inventory id 46189926219998 2025-07-31 14:30:05 [INFO]: Shopify Location id 58450641063 2025-07-31 14:30:05 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 14:30:05 [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 14:30:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 14:30:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44642772 and user_id = 14409 2025-07-31 14:30:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77547961 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 14:30:05 [INFO]: updateIdsQuantity -> ["77547961"] 2025-07-31 14:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-07-31 14:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77547961 THEN 0 END, quantityflag = CASE WHEN id = 77547961 THEN 0 END WHERE user_id = 14409 AND id IN (77547961) 2025-07-31 14:30:05 [INFO]: QUANTITY Updated IDs: 77547961 2025-07-31 14:30:05 [INFO]: Successfully processed data for user 14409 2025-07-31 14:30:05 [INFO]: Execution Started 2025-07-31 14:30:05 [INFO]: Execution Finished 2025-07-31 14:40:01 [INFO]: Execution Started 2025-07-31 14:40:01 [INFO]: old server sucessfully connected 2025-07-31 14:40:01 [INFO]: sqs client sucess created 2025-07-31 14:40:04 [INFO]: Number of messages in the queue: 3 2025-07-31 14:40:05 [INFO]: item found in queue is if condition 14409 2025-07-31 14:40:05 [INFO]: item found in queue is 14409 2025-07-31 14:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEB5HEZk2GikCxHpvZI05MskPYQj/yqfirysGtLUFhEuXaIuxioLhc13ffH681HNO62peDKvsunfUl/HwS8LXFlahEYMjNNDg2rlpYtD4rANm8b8mKKheoSzIpWrz2JNrgnOvoApgQWxFqV+yr/v4WvcUV0N8QU8w+Emd4AN11QDRsW8BpZEwWyD45M5NC9YHz+3Nfy4n/BUOIOZT3fVtNOLUXFKQUENj/L47Dhzwsa/nBJRxBDnqdN3uKlxr7NlYUPWNVQD3k8C5wFCJx3MczvVxpk6Swk2zWRsPZUTMOvhA4Hrqy3OkdjXdtVIo6Czx6Le7W2DBEZVRczymrlwcmhtAbvOaTWuddtUSPS69eyn3+0Wlo42v7/xBUA/9pN3I9zHD2WJTc2N5kaBHPBoua1kOALXMhDli4VK+TinCr4tWF+VctTxqZih7NQ58gwLz3Q 2025-07-31 14:40:06 [INFO]: item found in queue is if condition 14409 2025-07-31 14:40:06 [INFO]: item found in queue is 14409 2025-07-31 14:40:06 [INFO]: Message deleted from the queue for receipt handle: AQEBP4r2ayAQwe1qu4H9sdcldGqvpd1vPLUeS3utZ+z9eiIUceKfQGhs8B2L6dI9rew3gRfhIw8E4Mvunxm8G8UZ4kpzkSV1K7LWhMDqotBpXXo7bAPSnO5LH1geqg6kepqqQSmWB5+QbuThunb+MNVEbKTd/QuS9q2yNHDmw/vLMqudZsVUcOY4DHk2eqRUFa4QJGbm94vLkpqcxIMqthbCeL0Ik4ZAlSEGp4UEhznW6ArwJjwKhtNT3fAcuffpIFKCT0Nc1wL7l89znlxqvMRc5oRHDHfUfqFoHQjg1lY7YaiNuOU0SVgQcLSPUuU+0heHWLK/RpdaanAShnCofrXCn52Wq0baU3djNoXaLzdAtAL3p6ABSC85cc5AYPCKF6i39E4NHNKEI39klFpAPkRnqP1WBSN+oCk9hOhLOycsWHX4LXy4SxTQFTc9Hi6lKqDH 2025-07-31 14:40:08 [INFO]: item found in queue is if condition 14409 2025-07-31 14:40:08 [INFO]: item found in queue is 14409 2025-07-31 14:40:08 [INFO]: Message deleted from the queue for receipt handle: AQEBlJvjtYX/XKrCRtizcN3BS/CCmp66+/rhB7bM5BXxLlGMj863lELQVtZHykQO7DDMgW7jzLKmVUJdiaw2FPW8FFU/q37TIqJomHgZVcIepA1N16UK2DVzbI8ySQvs78fWhfq6N5wZxRUwX2qNW2jLm/nbbMARQUDyKIrHtXd5dhqXQk8egb0Us6FV2DyslZxDf20OrnxazqGo5GpX52bQrIJ6DH9T335VJ2G+WDA1D4yKqKr0yMwi8k2seGfgVMyrJzcMBdoDNrC3zLXQUOf12HP/zQeZmoB4Tpcud7uPJK88K+m+Jcr875X3mioxmQtJGpYouG3afr8Bk+A9uRld840LTENN/qdE+lk5FO0PCdqU2qSLYutqYwnENPgXlEall8oyDgszIxbPd3jPspFRE3p2MwMBnL6dP0c3axjjWYUyDW4xB/LwytrEyvwypWuJ 2025-07-31 14:40:08 [INFO]: Processed 3 messages, reached the limit of 3. 2025-07-31 14:40:08 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 14:40:08 [INFO]: inside itemsold and closed 14409 2025-07-31 14:40:10 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 14:40:10 [INFO]: autolink for user_id 14409 is 1 2025-07-31 14:40:10 [INFO]: Ebay item id :: 336033370457 exists in Database 2025-07-31 14:40:10 [INFO]: Item is reliested :: exists in Database 2025-07-31 14:40:10 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-07-31 14:40:10 [INFO]: inside itemsold and closed 14409 2025-07-31 14:40:11 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 14:40:11 [INFO]: autolink for user_id 14409 is 1 2025-07-31 14:40:11 [INFO]: Ebay item id :: 404829477892 exists in Database 2025-07-31 14:40:11 [INFO]: Item is reliested :: exists in Database 2025-07-31 14:40:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 14:40:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 14:40:11 [INFO]: inside itemsold and closed 14409 2025-07-31 14:40:13 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 14:40:13 [INFO]: autolink for user_id 14409 is 1 2025-07-31 14:40:13 [INFO]: Ebay item id :: 286551324306 exists in Database 2025-07-31 14:40:13 [INFO]: Item is reliested :: exists in Database 2025-07-31 14:40:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 14:40:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 14:40:13 [INFO]: in processold action queue is array for {"45163482":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45163482","ebayitemid":"336033370457","deleted":1}},"44718274":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44718274","ebayitemid":"404829477892","shopifyproductid":"8303432761566","variants":[{"price":"52.99","quantity":0,"weight":"3","shopifyproductid":"8303432761566","shopifyvariantid":"44852142964958","shopifyinventoryid":"46950187303134","shopifylocationid":"","product_id":"44718274","variant_id":"77625893","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44624355":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44624355","ebayitemid":"286551324306","shopifyproductid":"8920698618078","variants":[{"price":"503.49","quantity":0,"weight":"8","shopifyproductid":"8920698618078","shopifyvariantid":"46784763494622","shopifyinventoryid":"48883277234398","shopifylocationid":"58450641063","product_id":"44624355","variant_id":"77528802","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 14:40:13 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 14:40:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 14:40:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 14:40:13 [INFO]: productIds WHich are having null productid -> [45163482] 2025-07-31 14:40:13 [INFO]: ebayItemIds WHich are not imported-> ["336033370457"] 2025-07-31 14:40:13 [INFO]: Entered in bulkUpdateProducts function 2025-07-31 14:40:13 [INFO]: Transaction started for bulkUpdateProducts 2025-07-31 14:40:13 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45163482) 2025-07-31 14:40:13 [INFO]: Query executed successfully. Affected rows: 0 2025-07-31 14:40:13 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-07-31 14:40:13 [INFO]: Transaction committed successfully. 2025-07-31 14:40:13 [INFO]: Transaction ended for bulkUpdateProducts 2025-07-31 14:40:13 [INFO]: Shopify Inventory id 46950187303134 2025-07-31 14:40:13 [INFO]: Shopify Location id 58450641063 2025-07-31 14:40:13 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 14:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T14:40: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-07-31 14:40:14 [INFO]: Change: available | Delta: -1 2025-07-31 14:40:14 [INFO]: Change: on_hand | Delta: -1 2025-07-31 14:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 14:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44718274 and user_id = 14409 2025-07-31 14:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77625893 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 14:40:14 [INFO]: Shopify Inventory id 48883277234398 2025-07-31 14:40:14 [INFO]: Shopify Location id 58450641063 2025-07-31 14:40:14 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 14:40:14 [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 14:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 14:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44624355 and user_id = 14409 2025-07-31 14:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77528802 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 14:40:14 [INFO]: updateIdsQuantity -> ["77625893","77528802"] 2025-07-31 14:40:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-07-31 14:40:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77625893 THEN 0 WHEN id = 77528802 THEN 0 END, quantityflag = CASE WHEN id = 77625893 THEN 0 WHEN id = 77528802 THEN 0 END WHERE user_id = 14409 AND id IN (77625893,77528802) 2025-07-31 14:40:14 [INFO]: QUANTITY Updated IDs: 77625893, 77528802 2025-07-31 14:40:14 [INFO]: Successfully processed data for user 14409 2025-07-31 14:40:14 [INFO]: Execution Started 2025-07-31 14:40:14 [INFO]: Execution Finished 2025-07-31 14:50:01 [INFO]: Execution Started 2025-07-31 14:50:01 [INFO]: old server sucessfully connected 2025-07-31 14:50:01 [INFO]: sqs client sucess created 2025-07-31 14:50:02 [INFO]: Number of messages in the queue: 2 2025-07-31 14:50:02 [INFO]: item found in queue is if condition 14409 2025-07-31 14:50:02 [INFO]: item found in queue is 14409 2025-07-31 14:50:02 [INFO]: Message deleted from the queue for receipt handle: AQEBp/H34kJJaaTNNj/brd8+rbLSrIdITvMoaDw6+ANttO0lEYjarWx9wEaof5hne7LLjBNhzM/toiR5wdeXOPJzBu4F0zQ2AsAcIN3tXZYiBGkGWAoosej+1ddTOfmgoHN0RmdH0ONi4uUel4EFtP8CZdrL/qVw4Ovla+QKEhf2h+ZVjCdzscpIJ23weucZkEuiOzL5h18wUuAkiX7336n9jOHm0FoJc46g6D8Sf90Y5awQJFPkDrI2q0xPYYsINetfVM1EeFs0MfZol0Mogbo+ChDFI9GPEfCQdlItihe0pFxV0NG1SW/Y4S/Xg8scyxy1eCilC/zTDMzp9XHz4twrgBiDsEUGpfWhL0Tv6soaBYO2DGr0ev8QeKHeCrAgLckuzEajlkR28oatLPgwBNy07UzYEHSr+weqKmg4TDeETvT2rnwAyGhrw5Jt06LUWY35 2025-07-31 14:50:03 [INFO]: item found in queue is if condition 14409 2025-07-31 14:50:03 [INFO]: item found in queue is 14409 2025-07-31 14:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEB/KV3CParAF70nZKLoMCyFA84zGw2fpFGEcdjIBEj0emuj/NIy26XpgyQNur3KF0N6RuRw1EYwpvI/sJ1g3ZRaJDEJcNUg2oWKpigSNnSl3I9jqEjbDi03fRvoZlMCWYyAIXXohzGCYaBv2lBks/UoOxY4MPZq2Jp7MX5CqU0RoIR+Q0WB9EXSuq+3w1ZRfxl1ku3UdgjBrs7CEM2wgCeiLClDJidfV8u8XB1drlf1Hx/G1KKuv3bNaa+YF3nx43l77I1+5pX42GaottlDDTVt4KywQ+bJ8EHE37rVYxdNDT+6+5w3fMgFj/2RKJ70tWVs9ESS0G2O8HWJWOPAj//DI9ItgOBnrXWMD5o5umlvv2WM8WqtTcr9sWVg9D8HBmxBsghLcG/dL7CbSEqdo2HgVAM34JAwGfsnOhy8zYuxPv7UADVLCtbuJzNAh19XWkk 2025-07-31 14:50:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-07-31 14:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 14:50:03 [INFO]: inside itemsold and closed 14409 2025-07-31 14:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 14:50:05 [INFO]: autolink for user_id 14409 is 1 2025-07-31 14:50:05 [INFO]: Ebay item id :: 404787572251 exists in Database 2025-07-31 14:50:05 [INFO]: Item is reliested :: exists in Database 2025-07-31 14:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 14:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 14:50:05 [INFO]: inside itemsold and closed 14409 2025-07-31 14:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 14:50:07 [INFO]: autolink for user_id 14409 is 1 2025-07-31 14:50:07 [INFO]: Ebay item id :: 404784262980 exists in Database 2025-07-31 14:50:07 [INFO]: Item is reliested :: exists in Database 2025-07-31 14:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 14:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 14:50:07 [INFO]: in processold action queue is array for {"44771539":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44771539","ebayitemid":"404787572251","shopifyproductid":"8695036182750","variants":[{"price":"199.99","quantity":0,"weight":"2","shopifyproductid":"8695036182750","shopifyvariantid":"45933826048222","shopifyinventoryid":"48032277463262","shopifylocationid":"","product_id":"44771539","variant_id":"77680081","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44771461":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44771461","ebayitemid":"404784262980","shopifyproductid":"8694931685598","variants":[{"price":"84.99","quantity":0,"weight":"2","shopifyproductid":"8694931685598","shopifyvariantid":"45933593428190","shopifyinventoryid":"48032044613854","shopifylocationid":"","product_id":"44771461","variant_id":"77680003","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 14:50:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 14:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 14:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 14:50:07 [INFO]: Shopify Inventory id 48032277463262 2025-07-31 14:50:07 [INFO]: Shopify Location id 58450641063 2025-07-31 14:50:07 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 14:50:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T14: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-07-31 14:50:07 [INFO]: Change: available | Delta: -1 2025-07-31 14:50:07 [INFO]: Change: on_hand | Delta: -1 2025-07-31 14:50:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 14:50:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44771539 and user_id = 14409 2025-07-31 14:50:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680081 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 14:50:07 [INFO]: Shopify Inventory id 48032044613854 2025-07-31 14:50:07 [INFO]: Shopify Location id 58450641063 2025-07-31 14:50:07 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 14:50:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T14: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-07-31 14:50:07 [INFO]: Change: available | Delta: -1 2025-07-31 14:50:07 [INFO]: Change: on_hand | Delta: -1 2025-07-31 14:50:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 14:50:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44771461 and user_id = 14409 2025-07-31 14:50:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680003 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 14:50:07 [INFO]: updateIdsQuantity -> ["77680081","77680003"] 2025-07-31 14:50:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-07-31 14:50:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77680081 THEN 0 WHEN id = 77680003 THEN 0 END, quantityflag = CASE WHEN id = 77680081 THEN 0 WHEN id = 77680003 THEN 0 END WHERE user_id = 14409 AND id IN (77680081,77680003) 2025-07-31 14:50:07 [INFO]: QUANTITY Updated IDs: 77680081, 77680003 2025-07-31 14:50:07 [INFO]: Successfully processed data for user 14409 2025-07-31 14:50:07 [INFO]: Execution Started 2025-07-31 14:50:07 [INFO]: Execution Finished