2025-08-11 13:00:01 [INFO]: Execution Started 2025-08-11 13:00:01 [INFO]: old server sucessfully connected 2025-08-11 13:00:01 [INFO]: sqs client sucess created 2025-08-11 13:00:05 [INFO]: Number of messages in the queue: 1 2025-08-11 13:00:06 [INFO]: item found in queue is if condition 14409 2025-08-11 13:00:06 [INFO]: item found in queue is 14409 2025-08-11 13:00:06 [INFO]: Message deleted from the queue for receipt handle: AQEBMbqNAtwD/kk2C/uxnpG+fRrRr1xHIaWB+ja7IKCkMhyZ18UgimtOCvVqQbNr4fupLdcORP73WYjQSrO69QBUAoMilvtww0yKMxDzE9P02d4qY+GDTFWFihG2ojcmPR0jCSALkHE6lycMCRKWoTvSSgokMm5tHOAxLSZOK39a1imUB+07jnuVVJVa3+DI4b6/2HW89URGFy7ejNQcIa+Fz6QT+txnr0niv+/kgtyJT+6oe+n8WqRp+uv9DJ8RKFXTRHiX6kUeMx8CEokAh7MsgyiyqRjxyxYYcoofHgNcASclc1n8VqhpVwyz0jxcd0dUXPlm1H7UzVuD3IelxhxYRelJrf9t3sdljxRh1BB5gDZG0msL9oMYy2shxw3m3yBnv8IzNIpVPE/K11+ptagKbZpSrdgaq69bOlZe2UCv98jWFu3aVw+EiCRFbX+534cG 2025-08-11 13:00:06 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-11 13:00:06 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 13:00:06 [INFO]: inside itemsold and closed 14409 2025-08-11 13:00:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 13:00:08 [INFO]: autolink for user_id 14409 is 1 2025-08-11 13:00:08 [INFO]: Ebay item id :: 257040596391 exists in Database 2025-08-11 13:00:08 [INFO]: Item is reliested :: exists in Database 2025-08-11 13:00:08 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-11 13:00:08 [INFO]: in processold action queue is array for {"45312655":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45312655","ebayitemid":"257040596391","deleted":1}}} 2025-08-11 13:00:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 13:00:08 [INFO]: productIds WHich are having null productid -> [45312655] 2025-08-11 13:00:08 [INFO]: ebayItemIds WHich are not imported-> ["257040596391"] 2025-08-11 13:00:08 [INFO]: Entered in bulkUpdateProducts function 2025-08-11 13:00:08 [INFO]: Transaction started for bulkUpdateProducts 2025-08-11 13:00:08 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45312655) 2025-08-11 13:00:08 [INFO]: Query executed successfully. Affected rows: 0 2025-08-11 13:00:08 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-11 13:00:08 [INFO]: Transaction committed successfully. 2025-08-11 13:00:08 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-11 13:00:08 [INFO]: Successfully processed data for user 14409 2025-08-11 13:00:08 [INFO]: Execution Started 2025-08-11 13:00:08 [INFO]: Execution Finished 2025-08-11 13:10:01 [INFO]: Execution Started 2025-08-11 13:10:01 [INFO]: old server sucessfully connected 2025-08-11 13:10:01 [INFO]: sqs client sucess created 2025-08-11 13:10:03 [INFO]: Number of messages in the queue: 0 2025-08-11 13:10:23 [INFO]: Execution Started 2025-08-11 13:10:23 [INFO]: Execution Finished 2025-08-11 13:20:01 [INFO]: Execution Started 2025-08-11 13:20:01 [INFO]: old server sucessfully connected 2025-08-11 13:20:01 [INFO]: sqs client sucess created 2025-08-11 13:20:03 [INFO]: Number of messages in the queue: 1 2025-08-11 13:20:05 [INFO]: item found in queue is if condition 14409 2025-08-11 13:20:05 [INFO]: item found in queue is 14409 2025-08-11 13:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEB/yJ6cyC0JIitdOXiJmMMbpmMaWPCaUMWbtuQFFZV8HvqRQ2QgOn5oYkk877Opr0SpwRMNyPPoNLDMjT3acNzM3MP1GWQIO9jFfxQAwh/HqAz695Pdp1x3f1/O5rW17ASjGGjQ+amb2RdorsEtIBZfQJkB8bwOu7QLsLQ2gb3s96kxFEcIHebu3yh9aLCkk53hJObV8sG++Db9raC4qavp3L4imB9o3TRnSaE7/NSj7b2lQ8qAU4scDtzgNwdf54o8dvbg1o5YPhs56DwNX+4K7WezG3rl+HxfctiokSVaeSAvFpFXgdRnjIZMjI1Vp12Zi+gm0Zz8Dguyk0LyrudS4iPhtDwhhNVsDVLEAdy9KeOifIEYqSFOQxyvnVk0kUOpjr7XYUF19QW4hYaBARSVcVgtFe3X7pg3UhdhIQNLsfa6fdV8f1R6huXmnP5ONSA 2025-08-11 13:20:05 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-11 13:20:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 13:20:05 [INFO]: inside itemsold and closed 14409 2025-08-11 13:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 13:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-11 13:20:07 [INFO]: Ebay item id :: 286587737506 exists in Database 2025-08-11 13:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-11 13:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 13:20:07 [INFO]: in processold action queue is array for [] 2025-08-11 13:20:07 [INFO]: Successfully processed data for user 14409 2025-08-11 13:20:07 [INFO]: Execution Started 2025-08-11 13:20:07 [INFO]: Execution Finished 2025-08-11 13:30:02 [INFO]: Execution Started 2025-08-11 13:30:02 [INFO]: old server sucessfully connected 2025-08-11 13:30:02 [INFO]: sqs client sucess created 2025-08-11 13:30:04 [INFO]: Number of messages in the queue: 1 2025-08-11 13:30:05 [INFO]: item found in queue is if condition 14409 2025-08-11 13:30:05 [INFO]: item found in queue is 14409 2025-08-11 13:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBdIuqFt0bMZk8ZbmLJ9ScxqVaJAlshKSI41hU+YtsY7HflGBEARdNe5StXjrw9HqXmn35jJfj9pQfCmECrm14LQS6YnohS9BD9CxpjD1ZhS1D6NnSrJUX/cU4ipkQIIViwv7wxH9raCveAHntKyAMYty+vmrU+k2VZjM3WQbq3a0wLG0tCX2bbhKfE7lwlgUrIPjbprahOv9Ad51ZyYoesEaYb7IVNlA0RjQ2ajbEgwf57uoScFDRrpesaV4C+6IVGQlo5RC+gE1P6r0ADwG/8jIosG3acdnuiC3ZDAVpfCbzuCieSNPiUJoF3n8gp43KmT6amuZVNnZJ2KaiVRWDS/ISoR5z6LF/xVPOdXwUmsno32p5I3CFL0dQIbi+x3IsVDagPBNI5pYs6GtudT3Zm6GNV6D9ePNjv/T3TrGHxtKVurXqphq202Rqca4B9Svc 2025-08-11 13:30:05 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-11 13:30:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 13:30:05 [INFO]: inside itemsold and closed 14409 2025-08-11 13:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 13:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-11 13:30:07 [INFO]: Ebay item id :: 335964586408 exists in Database 2025-08-11 13:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-11 13:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 13:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 13:30:07 [INFO]: in processold action queue is array for {"44984100":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44984100","ebayitemid":"335964586408","shopifyproductid":"8937287123166","variants":[{"price":"45.99","quantity":0,"weight":"2","shopifyproductid":"8937287123166","shopifyvariantid":"46989709639902","shopifyinventoryid":"49101112770782","shopifylocationid":"58450641063","product_id":"44984100","variant_id":"77903832","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 13:30:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 13:30:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 13:30:07 [INFO]: Shopify Inventory id 49101112770782 2025-08-11 13:30:07 [INFO]: Shopify Location id 58450641063 2025-08-11 13:30:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 13:30:07 [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-08-11 13:30:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 13:30:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44984100 and user_id = 14409 2025-08-11 13:30:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77903832 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 13:30:07 [INFO]: updateIdsQuantity -> ["77903832"] 2025-08-11 13:30:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 13:30:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77903832 THEN 0 END, quantityflag = CASE WHEN id = 77903832 THEN 0 END WHERE user_id = 14409 AND id IN (77903832) 2025-08-11 13:30:07 [INFO]: QUANTITY Updated IDs: 77903832 2025-08-11 13:30:07 [INFO]: Successfully processed data for user 14409 2025-08-11 13:30:07 [INFO]: Execution Started 2025-08-11 13:30:07 [INFO]: Execution Finished 2025-08-11 13:40:01 [INFO]: Execution Started 2025-08-11 13:40:01 [INFO]: old server sucessfully connected 2025-08-11 13:40:01 [INFO]: sqs client sucess created 2025-08-11 13:40:05 [INFO]: Number of messages in the queue: 1 2025-08-11 13:40:08 [INFO]: item found in queue is if condition 14409 2025-08-11 13:40:08 [INFO]: item found in queue is 14409 2025-08-11 13:40:08 [INFO]: Message deleted from the queue for receipt handle: AQEB5A7J1Bd/Dw2Dd79Gk4ApzQhIJY5TUUwe79Z69RXydCnCwYef6Wg+29efBLkpw/clpchmJMDose5Xj2t9ZVsO9tjRyavSih2eXQ6LOFi3mNz6Ftoyul9gsHqILXbYPcBoJ7RQybNG6WpDy0tGb2sgjNPSSZXjMnw2PhIlHqfDedTeJi4sNcVHyRwu9iZbDmaOaIdVAyUT8H1pROEkglW2YovS0J6g/gXVO2yuEeY7FIiqMQ1dsMI3ICU8aYdVnpcyaKfaYzcgTLyLpm7guQcx0LBPTn1RhwGR8OgDEOxEFPsYhndVcXTMMRrtqfB7qnmy1Ctv4baMrg3YGFvQCupjeihoCcKUK8z0n/+uLvZ0sCAKwDgOpMY1Cdhdx5cAkw53h2XtzPeZJEx6U5vw+gIOIARSGqR4DYtuaXWqRxdO/F7+mcHv+L9FiPMSbJRKgGn8 2025-08-11 13:40:08 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-11 13:40:08 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 13:40:08 [INFO]: inside itemsold and closed 14409 2025-08-11 13:40:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 13:40:10 [INFO]: autolink for user_id 14409 is 1 2025-08-11 13:40:10 [INFO]: Ebay item id :: 334983921991 exists in Database 2025-08-11 13:40:10 [INFO]: Item is reliested :: exists in Database 2025-08-11 13:40:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 13:40:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 13:40:10 [INFO]: in processold action queue is array for {"44566724":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44566724","ebayitemid":"334983921991","shopifyproductid":"8106990108894","variants":[{"price":"16.99","quantity":0,"weight":"2","shopifyproductid":"8106990108894","shopifyvariantid":"44304763322590","shopifyinventoryid":"46402186641630","shopifylocationid":"","product_id":"44566724","variant_id":"77459404","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 13:40:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 13:40:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 13:40:10 [INFO]: Shopify Inventory id 46402186641630 2025-08-11 13:40:10 [INFO]: Shopify Location id 58450641063 2025-08-11 13:40:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 13:40:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T13:40:10Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-11 13:40:10 [INFO]: Change: available | Delta: -1 2025-08-11 13:40:10 [INFO]: Change: on_hand | Delta: -1 2025-08-11 13:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 13:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44566724 and user_id = 14409 2025-08-11 13:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77459404 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 13:40:10 [INFO]: updateIdsQuantity -> ["77459404"] 2025-08-11 13:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 13:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77459404 THEN 0 END, quantityflag = CASE WHEN id = 77459404 THEN 0 END WHERE user_id = 14409 AND id IN (77459404) 2025-08-11 13:40:10 [INFO]: QUANTITY Updated IDs: 77459404 2025-08-11 13:40:10 [INFO]: Successfully processed data for user 14409 2025-08-11 13:40:10 [INFO]: Execution Started 2025-08-11 13:40:10 [INFO]: Execution Finished 2025-08-11 13:50:01 [INFO]: Execution Started 2025-08-11 13:50:01 [INFO]: old server sucessfully connected 2025-08-11 13:50:01 [INFO]: sqs client sucess created 2025-08-11 13:50:05 [INFO]: Number of messages in the queue: 0 2025-08-11 13:50:25 [INFO]: Execution Started 2025-08-11 13:50:25 [INFO]: Execution Finished