2025-08-11 19:00:01 [INFO]: Execution Started 2025-08-11 19:00:01 [INFO]: old server sucessfully connected 2025-08-11 19:00:01 [INFO]: sqs client sucess created 2025-08-11 19:00:02 [INFO]: Number of messages in the queue: 3 2025-08-11 19:00:03 [INFO]: item found in queue is if condition 14409 2025-08-11 19:00:03 [INFO]: item found in queue is 14409 2025-08-11 19:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBD3F2WzkLxBL0mzzhCYUs4ombvvHBTGjbbLCukQbtFW3aUW7ayOUsLHykDCbZTijMmHxJ9km4WMETqCXJ6HoFUpSN8ULTph/F1qzsjXlOvkX4jibOeBH0EnrOke9fRxv0rSowdFFt0eqeTTb++bFfc8PL08FHT/B9XsqoGFO6+2piKVE+2a7Oa0XfYh+7yP5wlrRXFC/UY4eUuCL4D46/E1rYFHBzVjZHHFnApwIB51cnbyzM7ZHNQIyfHpzhj03pKJdOBZDSIvWBOcurZmQWu94a5PWtPNNNGEvKYNW0ILKwyyRhkgkigA16xfPmmdPSvOgq5dQ3kIr/WUg00RssVJBTI+J0NLX90ILG/0Bjf5bIlMBaqj5QBQ+dh+l31mdj3/GdupQ6uhimNRV26XnFcsowUyiuj0wCXgBHVP9iiiVBRK7c24mWe8a/8KDtkfXo 2025-08-11 19:00:03 [INFO]: item found in queue is if condition 14409 2025-08-11 19:00:03 [INFO]: item found in queue is 14409 2025-08-11 19:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBza5M+dK6s6cxtWPr8Ijjn8yXrUx6bsO+V5CF/xR0LSuEqgjZM3vYtO0bfkIrfInxH4olR5FsC/wrYfi3GaKJLlN6e306kXsyu46N2dgVIim07AaSK8J1Ur2/IgbHiDPV7A91YFUzXJ0XxzPcDtckFcCT5sLChNtrVSnvbShl9DhwxINM/O6fAfz0U92T/gpOUAr56llRJxedFyVihWthEBiPtDqVJEPEEQA0LjFlgM341r2Nq9g9YlhnwoCOh9EhU94E2nDZhPfoxMfqgHlRwaS61TGnzTeNvvyncfo7a+DgYF2AMIdOCLc0hN5VPK6YLkOZeBL0/whNiXewhzJfCaGnMmUvOc4QYSBoMzoccadSSvpYDIhBw8uHh7GbD2mWMceG7BT5terjE9LKyMaWj7TbXkB3iEvnZOXsbIgAr8Ca8LEMAQLKYM4xyjQjSpkw 2025-08-11 19:00:03 [INFO]: item found in queue is if condition 14409 2025-08-11 19:00:03 [INFO]: item found in queue is 14409 2025-08-11 19:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBh7LBTdhSL9FAEqrn1wz0nrlZdTgr8x+xcZhh17ycmfGPXp6i8IZu9T6XHdqih9Ly2QhjnYhWWxq6E10zXjfDQDOwKkk7RW2u7bCAlR40MmNn2LNlZzcUqaq6KjkKxfsV21o60N7Bn2inaDmy5M0z88OZxVnSbTHjeIhPLnzYGzGN5IhFP6kLIZsawNjAvXxjriBdPj8ljCPtNxdJYZ4Nnk3iFigqrsnHTpvfpECjbiy10F43UUxF2+RZNjvEYteCCrwiIkm1WYRcjbQZZVF1lrrXuBOsKOz7JjswvZs7jTO37D0IY5YPaVdxbKRdmX4Ae9INv7Z5Ftu1FBvE8Y0j5gJK5OuMrqeu+GN+B9yRz1jK6yILOKdK1sgqNpZmdCmZ1Au8M8m9QSe8ZWgV3brRhOxzzdefG+VIkyVBXKo7JhScTPE//IcfAhtphpq8EV6P 2025-08-11 19:00:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-11 19:00:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 19:00:04 [INFO]: inside itemsold and closed 14409 2025-08-11 19:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 19:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-11 19:00:05 [INFO]: Ebay item id :: 325511622239 exists in Database 2025-08-11 19:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-11 19:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 19:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 19:00:05 [INFO]: inside itemsold and closed 14409 2025-08-11 19:00:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 19:00:07 [INFO]: autolink for user_id 14409 is 1 2025-08-11 19:00:07 [INFO]: Ebay item id :: 404114332977 exists in Database 2025-08-11 19:00:07 [INFO]: Item is reliested :: exists in Database 2025-08-11 19:00:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 19:00:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 19:00:07 [INFO]: inside itemsold and closed 14409 2025-08-11 19:00:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 19:00:09 [INFO]: autolink for user_id 14409 is 1 2025-08-11 19:00:09 [INFO]: Ebay item id :: 326657958743 exists in Database 2025-08-11 19:00:09 [INFO]: Item is reliested :: exists in Database 2025-08-11 19:00:09 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-11 19:00:09 [INFO]: in processold action queue is array for {"44676215":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44676215","ebayitemid":"325511622239","shopifyproductid":"7939214672094","variants":[{"price":"9.99","quantity":0,"weight":"0","shopifyproductid":"7939214672094","shopifyvariantid":"43931171225822","shopifyinventoryid":"46027593351390","shopifylocationid":"","product_id":"44676215","variant_id":"77581435","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44656795":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44656795","ebayitemid":"404114332977","shopifyproductid":"7933635821790","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"7933635821790","shopifyvariantid":"43907964535006","shopifyinventoryid":"46004144668894","shopifylocationid":"","product_id":"44656795","variant_id":"77562015","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45163649":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45163649","ebayitemid":"326657958743","deleted":1}}} 2025-08-11 19:00:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 19:00:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 19:00:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 19:00:09 [INFO]: productIds WHich are having null productid -> [45163649] 2025-08-11 19:00:09 [INFO]: ebayItemIds WHich are not imported-> ["326657958743"] 2025-08-11 19:00:09 [INFO]: Entered in bulkUpdateProducts function 2025-08-11 19:00:09 [INFO]: Transaction started for bulkUpdateProducts 2025-08-11 19:00:09 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45163649) 2025-08-11 19:00:09 [INFO]: Query executed successfully. Affected rows: 0 2025-08-11 19:00:09 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-11 19:00:09 [INFO]: Transaction committed successfully. 2025-08-11 19:00:09 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-11 19:00:09 [INFO]: Shopify Inventory id 46027593351390 2025-08-11 19:00:09 [INFO]: Shopify Location id 58450641063 2025-08-11 19:00:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 19:00:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T19:00:09Z","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 19:00:09 [INFO]: Change: available | Delta: -1 2025-08-11 19:00:09 [INFO]: Change: on_hand | Delta: -1 2025-08-11 19:00:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 19:00:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44676215 and user_id = 14409 2025-08-11 19:00:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77581435 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 19:00:09 [INFO]: Shopify Inventory id 46004144668894 2025-08-11 19:00:09 [INFO]: Shopify Location id 58450641063 2025-08-11 19:00:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 19:00:09 [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 19:00:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 19:00:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44656795 and user_id = 14409 2025-08-11 19:00:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77562015 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 19:00:09 [INFO]: updateIdsQuantity -> ["77581435","77562015"] 2025-08-11 19:00:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-11 19:00:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77581435 THEN 0 WHEN id = 77562015 THEN 0 END, quantityflag = CASE WHEN id = 77581435 THEN 0 WHEN id = 77562015 THEN 0 END WHERE user_id = 14409 AND id IN (77581435,77562015) 2025-08-11 19:00:09 [INFO]: QUANTITY Updated IDs: 77581435, 77562015 2025-08-11 19:00:09 [INFO]: Successfully processed data for user 14409 2025-08-11 19:00:09 [INFO]: Execution Started 2025-08-11 19:00:09 [INFO]: Execution Finished 2025-08-11 19:10:01 [INFO]: Execution Started 2025-08-11 19:10:01 [INFO]: old server sucessfully connected 2025-08-11 19:10:01 [INFO]: sqs client sucess created 2025-08-11 19:10:02 [INFO]: Number of messages in the queue: 1 2025-08-11 19:10:02 [INFO]: item found in queue is if condition 14409 2025-08-11 19:10:02 [INFO]: item found in queue is 14409 2025-08-11 19:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBYnDagfPaUARwc4UrdL5vBLs1Hy+B5/NfMH2JQBkivAkx80z7EvWLT/RLqFrFuAWE1sQ8bW61NtD5K7ZNgfplMxHet5It3rssVstRofCWrmDi0WCIsRyK5MMfhe6ubbEmzTnAvbCqF4cnfWXeEy6Xmv0NQXHbMI8EfLNi0yZX2xx+VxmiR/2DdWrOqkuBfkAEsUdFIGUGUwaNtvDafjNvMMKdPZuVXnSXvwB9ubBjjasoQJZAKMVqoyaZjgSoi0aJxN26H/nXXLhqsmOkq1l1/cOTS1iwSXMp/3yYJl7ke2UN89IfX5VUt9vjy1Z2+yZMvgn5s43gAZfStw33FlEvMBEtWbvxa8S3ydp7aptEKa/W/7tUtXVsvzmXCBtID9fDzZYze0h+P2o+7MSixb0TppgWpJB5R6fBF1r0KeignRJKKecDBCfnHi2gjmZlC5R4 2025-08-11 19:10:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-11 19:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 19:10:03 [INFO]: inside itemsold and closed 14409 2025-08-11 19:10:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 19:10:04 [INFO]: autolink for user_id 14409 is 1 2025-08-11 19:10:04 [INFO]: Ebay item id :: 226154259620 exists in Database 2025-08-11 19:10:04 [INFO]: Item is reliested :: exists in Database 2025-08-11 19:10:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 19:10:04 [INFO]: in processold action queue is array for [] 2025-08-11 19:10:04 [INFO]: Successfully processed data for user 14409 2025-08-11 19:10:04 [INFO]: Execution Started 2025-08-11 19:10:04 [INFO]: Execution Finished 2025-08-11 19:20:01 [INFO]: Execution Started 2025-08-11 19:20:01 [INFO]: old server sucessfully connected 2025-08-11 19:20:01 [INFO]: sqs client sucess created 2025-08-11 19:20:02 [INFO]: Number of messages in the queue: 2 2025-08-11 19:20:03 [INFO]: item found in queue is if condition 14409 2025-08-11 19:20:03 [INFO]: item found in queue is 14409 2025-08-11 19:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBq+jp/B6b078z/27g6NGt2DaAnIJnevWQgRPd1ND/qC2vwikctpZ0DwqAz6rcx9KzNr3EYpute4R64llTsiUJCDJr1146f4xyKkTJwlzL7DuSOUVvBNaTD5UvBqafJ1aXlh2lj4rwsuT1P9ExaLHqiC1r//iE03xoocVo07Vm9I+uv8T65FPfd2i4kkXcMzqHfXg4yUPwraI8cliOrIIY1AaIt3kNETGAEK48aBNigrS/XsxZEsHIHMLF0gg91WoPz8B9IctwgCU81iHpbTkuvIuPSijtW2v8KGMk+O8wVaG+6EViEPyToocafudOsN7scDY8dwpg0l1cq352jqV8GZ3UCNB4rpI96p3GgHiUd9Y9KkkYccMebbDNkNuCb9dVtqwvIvcNrHScFymjZ6wFzD3Fh2eNwaCs7LlCkk+E07dE2ahtYAKFOhpK9N9vx5SA 2025-08-11 19:20:03 [INFO]: item found in queue is if condition 14409 2025-08-11 19:20:03 [INFO]: item found in queue is 14409 2025-08-11 19:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBBZMMm+EXjG5ViJAG9FQtonu4TihKYuVY8dU+UMdYTMXMPtAl8MObsutozDPkfKwx2ejdu4HbIPDmNxa6Yj2o9drJenznmcr+wNVTEZQ4NdqeMlw2oGDQOlfUOKGU32NjTrNXK7nKR46jqrWlgjQnaV6+GstQkUuov8weUXOjYNb7jqZw0QnwMdV7GaNrF8WRl9as/QT5fq2Dte5bPMf3fxh9HZiGUBKS1nyqog4VGYz2D17AxelS4XXNjRxmqxfUTZS0YkbG6ABtH2+O7MOvBsBFIMTKPmMQ/Gik1NCzsvND+qPdyVOWrXQUCqQf9z0UQ1DimK+dHtfYjSZ7J5qBlArPvzwQPv/zvwQNNdD511EL8CvC9SusH7qwgm7UGcr7nfKIxrWqBhCp76nZCfN4te6Te2fLzRhQWPJE6KV3jdBHA1pwehc6LiDKAQ8rpCye 2025-08-11 19:20:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-11 19:20:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 19:20:04 [INFO]: inside itemsold and closed 14409 2025-08-11 19:20:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 19:20:06 [INFO]: autolink for user_id 14409 is 1 2025-08-11 19:20:06 [INFO]: Ebay item id :: 284224383439 exists in Database 2025-08-11 19:20:06 [INFO]: Item is reliested :: exists in Database 2025-08-11 19:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 19:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 19:20:06 [INFO]: inside itemsold and closed 14409 2025-08-11 19:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 19:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-11 19:20:07 [INFO]: Ebay item id :: 336119871100 exists in Database 2025-08-11 19:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-11 19:20:07 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-11 19:20:07 [INFO]: in processold action queue is array for {"44656482":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44656482","ebayitemid":"284224383439","shopifyproductid":"6638774943911","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"6638774943911","shopifyvariantid":"39670368043175","shopifyinventoryid":"41765073060007","shopifylocationid":"","product_id":"44656482","variant_id":"77561671","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45314028":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45314028","ebayitemid":"336119871100","deleted":1}}} 2025-08-11 19:20:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 19:20:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 19:20:08 [INFO]: productIds WHich are having null productid -> [45314028] 2025-08-11 19:20:08 [INFO]: ebayItemIds WHich are not imported-> ["336119871100"] 2025-08-11 19:20:08 [INFO]: Entered in bulkUpdateProducts function 2025-08-11 19:20:08 [INFO]: Transaction started for bulkUpdateProducts 2025-08-11 19:20:08 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45314028) 2025-08-11 19:20:08 [INFO]: Query executed successfully. Affected rows: 0 2025-08-11 19:20:08 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-11 19:20:08 [INFO]: Transaction committed successfully. 2025-08-11 19:20:08 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-11 19:20:08 [INFO]: Shopify Inventory id 41765073060007 2025-08-11 19:20:08 [INFO]: Shopify Location id 58450641063 2025-08-11 19:20:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 19:20:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T19:20: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-08-11 19:20:08 [INFO]: Change: available | Delta: -1 2025-08-11 19:20:08 [INFO]: Change: on_hand | Delta: -1 2025-08-11 19:20:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 19:20:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44656482 and user_id = 14409 2025-08-11 19:20:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77561671 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 19:20:08 [INFO]: updateIdsQuantity -> ["77561671"] 2025-08-11 19:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 19:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77561671 THEN 0 END, quantityflag = CASE WHEN id = 77561671 THEN 0 END WHERE user_id = 14409 AND id IN (77561671) 2025-08-11 19:20:08 [INFO]: QUANTITY Updated IDs: 77561671 2025-08-11 19:20:08 [INFO]: Successfully processed data for user 14409 2025-08-11 19:20:08 [INFO]: Execution Started 2025-08-11 19:20:08 [INFO]: Execution Finished 2025-08-11 19:30:01 [INFO]: Execution Started 2025-08-11 19:30:01 [INFO]: old server sucessfully connected 2025-08-11 19:30:01 [INFO]: sqs client sucess created 2025-08-11 19:30:02 [INFO]: Number of messages in the queue: 3 2025-08-11 19:30:03 [INFO]: item found in queue is if condition 14409 2025-08-11 19:30:03 [INFO]: item found in queue is 14409 2025-08-11 19:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBI0dGDSW7gqaN1npyLEPZ7tY5RH/WY4Qqer8u8GvLDruNRBDzl4QuCK0O9eBBslZ4s8tzaRiXN/+f7ZRBMCsNHGvI7FO2+knZTHrxreqE2NpqtqjGo3N064JHQGppdj5gLF82TszBma3aecqXGg7ZURW+ZGRbMoFJWbMNVl7OKc7pBdK17HW+Rak+LJimfSRaf0KcB93qhSfmaFYlgxGBitdqH5MvddQzZDbAaFHQSEAwjsxMDmdJBFMuhXfaXobVlEDybsXb6xGZTN3VRf4ED4o+TdMGzXmtayuAZsf7r4j8qO/WCMvil9tqPilb4yBBXTyJGzuQRD6duL/qqeJ/pwLBKq6EiPBF4+QXU0Pbz9WhAjo2XOEsAS/yMyrU6t5VHjgv4xNbCLYWHbBD0CHA9IIUXb9fU9XHn9bqti/WABQjRHGlq653hlGVVx+s8hJB 2025-08-11 19:30:05 [INFO]: item found in queue is if condition 14409 2025-08-11 19:30:05 [INFO]: item found in queue is 14409 2025-08-11 19:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBX1lC+aPtgpNjw0lDSbDblSFL4PF/W2zxAIZ6gpypL8wS8uaZ0cORZtX0ufz7JC50VNM3w7r7xwkmTiGsPwHEaQyjIrSREKncPgAv3GEwZgbRv0a1gqpDmdxNlCArdiiDLduVLysPgvJzppmJhhD3PH5u97h2ARiukEr4pwmPwf/vW50ZNmSQo7rJ/vU9q0i11OQFpU0fa2GBT5kJwj7H0kcv8dJDTdkNeo3iSxeB+Llm+NxP/0jZF+sOBfW4Ob7zSXAUH2E5ptGCHspo8kgF/F29NrJdHtgRqOoP2tf0ibstCqnQGjgzdGjyDfjsOtMKkGc6xAXUqFSeJub5MoEJSAZ12e+iLyiezj6ZVJMBAkyvfQEtfJWhVYqcer9bvtnpU7a+km3AnO6j7g1ECZvWygBkKLPZvboKAzCow+qCskLxhxwIADGbcGh4yyb3zgJV 2025-08-11 19:30:05 [INFO]: item found in queue is if condition 14409 2025-08-11 19:30:05 [INFO]: item found in queue is 14409 2025-08-11 19:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBE6n/P0cdnbwq8p367ok2LMn+trvwvZO+3UEh4vry7np9+l5Z/N4mzKaiGXnkcEDIwfpr3r0kejiAm/tcm2PXxpURkXdPR9KNQ5SATHolNHJHEKQE7VUjzzog475gB+L+zH6dgGNQ7zW7GT9FCEYl6wud9/+HJM4BnHY8+kSzCRBmdkN3R+DYKDThau9r8uRTYt9/xLwf2SQtl68/Po/FjSukgQXSDKZhV1fdyjZdlwKY0S5n7WZZwxNDCHYDhnm7c9O89+4o+PL84UOEs4AhwPf+4o2styBzfMYZPL47qwFLOZK/FzZL3cRUuasF/jqfg1HUHqlDb48PxbNbSkYpsqLNgFifNkzub3B491g4J0cyhlBlfNBAPWFzqcNZhstTKnIxDReGjJOPtqH+mCSTUYYnVL+Ws06njFP1T/udYijmMDcwv4QRi3If5KjQDdl3 2025-08-11 19:30:05 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-11 19:30:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 19:30:05 [INFO]: inside itemsold and closed 14409 2025-08-11 19:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 19:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-11 19:30:07 [INFO]: not in db for user_id 14409 and the ebayitemid286739168080 2025-08-11 19:30:07 [INFO]: inside itemsold and closed 14409 2025-08-11 19:30:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 19:30:09 [INFO]: autolink for user_id 14409 is 1 2025-08-11 19:30:09 [INFO]: Ebay item id :: 335848179628 exists in Database 2025-08-11 19:30:09 [INFO]: Item is reliested :: exists in Database 2025-08-11 19:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 19:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 19:30:09 [INFO]: inside itemsold and closed 14409 2025-08-11 19:30:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 19:30:10 [INFO]: autolink for user_id 14409 is 1 2025-08-11 19:30:10 [INFO]: Ebay item id :: 404987843705 exists in Database 2025-08-11 19:30:10 [INFO]: Item is reliested :: exists in Database 2025-08-11 19:30:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 19:30:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 19:30:10 [INFO]: in processold action queue is array for {"44560458":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44560458","ebayitemid":"335848179628","shopifyproductid":"8838226510046","variants":[{"price":"584.99","quantity":0,"weight":"18","shopifyproductid":"8838226510046","shopifyvariantid":"46352468279518","shopifyinventoryid":"48454191448286","shopifylocationid":"","product_id":"44560458","variant_id":"77453138","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44662611":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44662611","ebayitemid":"404987843705","shopifyproductid":"8395440423134","variants":[{"price":"55.99","quantity":0,"weight":"2","shopifyproductid":"8395440423134","shopifyvariantid":"45145474564318","shopifyinventoryid":"47243344117982","shopifylocationid":"","product_id":"44662611","variant_id":"77567831","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 19:30:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 19:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 19:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 19:30:10 [INFO]: Shopify Inventory id 48454191448286 2025-08-11 19:30:10 [INFO]: Shopify Location id 58450641063 2025-08-11 19:30:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 19:30:11 [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 19:30:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 19:30:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44560458 and user_id = 14409 2025-08-11 19:30:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77453138 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 19:30:11 [INFO]: Shopify Inventory id 47243344117982 2025-08-11 19:30:11 [INFO]: Shopify Location id 58450641063 2025-08-11 19:30:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 19:30:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T19:30:11Z","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 19:30:11 [INFO]: Change: available | Delta: -1 2025-08-11 19:30:11 [INFO]: Change: on_hand | Delta: -1 2025-08-11 19:30:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 19:30:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44662611 and user_id = 14409 2025-08-11 19:30:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77567831 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 19:30:11 [INFO]: updateIdsQuantity -> ["77453138","77567831"] 2025-08-11 19:30:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-11 19:30:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77453138 THEN 0 WHEN id = 77567831 THEN 0 END, quantityflag = CASE WHEN id = 77453138 THEN 0 WHEN id = 77567831 THEN 0 END WHERE user_id = 14409 AND id IN (77453138,77567831) 2025-08-11 19:30:11 [INFO]: QUANTITY Updated IDs: 77453138, 77567831 2025-08-11 19:30:11 [INFO]: Successfully processed data for user 14409 2025-08-11 19:30:11 [INFO]: Execution Started 2025-08-11 19:30:11 [INFO]: Execution Finished 2025-08-11 19:40:01 [INFO]: Execution Started 2025-08-11 19:40:01 [INFO]: old server sucessfully connected 2025-08-11 19:40:01 [INFO]: sqs client sucess created 2025-08-11 19:40:03 [INFO]: Number of messages in the queue: 0 2025-08-11 19:40:23 [INFO]: Execution Started 2025-08-11 19:40:23 [INFO]: Execution Finished 2025-08-11 19:50:01 [INFO]: Execution Started 2025-08-11 19:50:01 [INFO]: old server sucessfully connected 2025-08-11 19:50:01 [INFO]: sqs client sucess created 2025-08-11 19:50:03 [INFO]: Number of messages in the queue: 0 2025-08-11 19:50:23 [INFO]: Execution Started 2025-08-11 19:50:23 [INFO]: Execution Finished